dbTalk Databases Forums  

Sponsored Links


comp.databases.ms-access comp.databases.ms-access


Discuss in the comp.databases.ms-access forum.



Post New Thread
Threads in Forum : comp.databases.ms-access Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hi, I have been trawling round the net trying to find an answer to this, but all the solutions I have found so far have given me errors. I have a...
Kroaky
10-22-2009 09:01 PM
Allen Browne Go to last post
14 114
Hello, I have a continuous subform within a form. Behind a button on the form, I included validation checks to ensure that various fields (on both...
Odd
10-22-2009 05:34 PM
Odd Go to last post
2 90
I am working with an ocx control, that refuses to be instantiated directly through code. So, I thought I would employ a little "workaround." I...
Vincent
10-22-2009 11:26 AM
Vincent Go to last post
3 69
We have an MDB that will need to impersonate a system user rather than the user using it. IT will assign the security groups surrounding...
Bob
10-22-2009 10:44 AM
Bob Go to last post
4 80
Hi everyone, I'm trying to write a past append qry and as this is the first time I've had a go at it, I think I am way off the mark. I've got two...
Stinky Pete
10-21-2009 08:17 PM
Stinky Pete Go to last post
3 128
Hi, I am using the dynaPDF solution for printing reports to PDF documents. On my own machine using the full Access 2003 it works fine. However, on a...
franc sutherland
10-20-2009 04:38 AM
franc sutherland Go to last post
6 94
Access 2003 Listbox.AddItem w / 5 Columns Is Incredibly Slow As one can see from the function / code below I create a recordset with 5 returned...
JustBoo
10-19-2009 07:46 PM
rquintal@sympatico.ca Go to last post
1 74
Hi - I haven't done anything in Access in a few years now and I'm blocked! I hope someone can help. I have data in a table: Key AccountNumber...
sara
10-19-2009 07:33 PM
sara Go to last post
16 261
I have a CrossTab query that needs to use some values from a Form in its Where clause: TRANSFORM Sum(ContractProfitsTaken.ProfitTaken) AS...
Jim Devenish
10-19-2009 12:26 PM
fredg Go to last post
1 47
After upgrading to 2007 i get a Query is too complex error on one of my queries. Here is the SQL statement. SELECT ProjectSnapshot.WBSID,...
koturtle
10-19-2009 11:01 AM
Milhouse Van Houten Go to last post
16 137
I have a problem with an Access 2002 db deployed in an Access 2003 environment. I can change the permissions for tables for individual users, but not...
Bob Darlington
10-18-2009 10:01 PM
Bob Darlington Go to last post
3 92
I am using an external linked GIF file as the picture on an image control Does anyone know the code to print this image (probably to the...
Phil Stanton
10-16-2009 05:48 PM
Phil Stanton Go to last post
4 88
I'm trying to export a query to excel file using VBA. I can export the data only once, successfully. The code runs fine every 1st time after reopen...
shanq
10-16-2009 02:14 PM
MGFoster Go to last post
1 68
Hi, I have a purchase order table that has a yes/no tick which triggers an add as asset form. At this point other detail such as serial number of...
don
10-16-2009 02:10 PM
Salad Go to last post
1 74
Access 2007 running on Windows XP. Report is a multipage letter format and Access is not handling paging correctly when a text field, which can span...
bontemps
10-16-2009 12:59 PM
bontemps Go to last post
2 98
I have a table containing profits taken (transferred) from contracts. There is either zero or one entry per month for a contract. The day of the...
Jim Devenish
10-16-2009 12:11 PM
Jim Devenish Go to last post
4 70
Access 2003 SP3, Windows XP Pro, FE/BEs on a LAN. The Macro Security Level is set to low in our applications. An interesting find that may prove...
Bob
10-16-2009 09:46 AM
Bob Go to last post
2 69
Hi, Instead of hard coding the actual name of the menu, how would I scan through a table or query replacing the references in the following code...
PW
10-15-2009 06:47 PM
PW Go to last post
4 85
Hello All I have the following code which I am using to dynamically change sub- reports on a master report. Do Until rs.EOF ReportToPrint =...
Trevor
10-15-2009 04:28 PM
Trevor Go to last post
5 73
I self taught myself enough to create a database for keeping track of stock transactions some time ago. It's worked fine for probably more than year...
Gord
10-15-2009 12:07 PM
timmg Go to last post
1 51
In AccessXP I use the following vba code to email a message thru GroupWise, the company I work for is changing to Outlook and I need to re-write this...
bobh
10-15-2009 11:09 AM
bobh Go to last post
2 103
Hello, I'd like to put security type tables in a small separate database instead of where the rest of the data is located (in case either...
PW
10-15-2009 12:42 AM
Tom van Stiphout Go to last post
1 73
Hi Everybody Access 2007 I have a form based on a query that does NOT include the primary key autonumber And I am trying to use the "Duplicate"...
bobdydd
10-14-2009 06:55 PM
Marshall Barton Go to last post
3 60
Using A2003. I've got a 2-page report with several totals in the report footer. The totals preview and print just fine when printing both pages but...
emanning
10-14-2009 04:48 PM
emanning Go to last post
2 61
In previous version os Access, there was a Duplicate command on the Edit menu. It could also be called by hitting Ctrl-D. If you were in form or...
BB
10-14-2009 04:34 PM
Marshall Barton Go to last post
1 76
For the moment, Google Search is finding old posts. Thanks Google. Does anyone sell a searchable archive of this NG? If not, it's ironic that no...
James A. Fortune
10-14-2009 01:50 PM
bobh Go to last post
1 54
I keep getting this error Run time error 2501 This SendObject action was canceled. This is my code: Private Sub cmdMailTicket_Click() On Error...
shanq
10-14-2009 01:19 PM
shanq Go to last post
4 56
I'm working on a legacy app that uses separate date and time fields. Yet, they should probably be combined -- especially now that I need to do a...
Jeff
10-13-2009 09:04 PM
Jeff Norville Go to last post
1 70
I am trying to apply conditional formatting. i have to use code since i have 10 different conditions. basically, i want to change the color of the...
Gaby Sandoval
10-13-2009 09:43 AM
Marshall Barton Go to last post
4 69
Is there a way of forcing the Wizards to write code rather than macros?
anthony
10-12-2009 11:04 AM
anthony Go to last post
2 90
I have a table set up like this ClassID (pk) ClassName ParentClassID And of course another like this ItemID (PK) ClassID (FK)
shanq
10-12-2009 10:57 AM
Phil Stanton Go to last post
7 78
I have some clients (there are about six team members) working on an Access 2003 Front End which is connected by a WAN to an Access 2003 Back End...
Edward
10-12-2009 09:14 AM
James A. Fortune Go to last post
26 158
Hello I use this code to change visible true/false of some controles in my workbook. I get SheetName, ShapeName and true/false (0 or -1) from...
kalle
10-11-2009 05:45 PM
fredg Go to last post
1 59
Dear reader, By linking tables to a back-end database on a server as the database is already linked to an other front-end I have the experience that...
Simon
10-10-2009 09:48 AM
AKN_39 Go to last post
1 75
How do I disguise what users are entering in a text box? I want to have a password field but not have whatever is typed to appear...
PW
10-09-2009 10:16 PM
PW Go to last post
2 73
I have worked on a lot of databases but never had to worry much on security. Now they want a database that Admin(me) can see everything and...
sparks@home.com
10-09-2009 03:49 PM
Albert D. Kallal Go to last post
2 78
I keep getting an error: run-time error '2185' "you can't reference a property or method for a control unless the control has the focus." There is...
shanq
10-09-2009 02:13 PM
shanq Go to last post
1 44
hi folks, long time no see but still slogging away, thanks to the Cravens and Brownes and particularly Seaches of this world .... One of those...
auntiejack56
10-08-2009 06:33 PM
Allen Browne Go to last post
5 99
I've found several posts regarding the Maximum number of allowable fields in Access97 (which is 255), but I've been unable to find the same...
Takeadoe
10-08-2009 02:34 PM
Takeadoe Go to last post
2 65
I created a form that contains 1 subform ( lets call it lvl 1 subform) in which I created another subform( lvl 2 subform). lvl 1 subform acts like a...
shanq
10-07-2009 11:17 PM
shanq Go to last post
4 84
Using A2003. I've created an update query to update a row in a table. The SQL to update the table is here: UPDATE tblPeople INNER JOIN...
emanning
10-07-2009 11:17 AM
Rich P Go to last post
5 62
I put a new directory and an undated database2( 2 for reference) in our network directory. When someone opens database1 they see a previous version...
sparks@home.com
10-07-2009 10:31 AM
sparks@home.com Go to last post
3 58
Now I have a Treeview form set up, works great. I can view parents and children, but only view. Now I want to expand the function a little bit. I...
shanq
10-07-2009 04:59 AM
hbinc Go to last post
3 59
How do you hide or edit Record button in Form? http://www.mypicx.com/uploadimg/41128670_10052009_1.bmp Thanks, Shanq
shanq
10-06-2009 10:56 AM
Krzysztof Naworyta Go to last post
3 66
Hi, I have a program that prints on Cheques (Check). The problem now is that they have to type in the Value in numbers and words. I want to be able...
Hank
10-06-2009 05:49 AM
Hank Go to last post
5 65
Hello, I'm trying to use Microsoft Access 2007 in Windows XP SP2 to access a certain real estates website and extract certain transaction records...
HC
10-06-2009 01:26 AM
lyle fairfield Go to last post
2 60
Hi, I have a employee database and it tracks time off. Occasionally employees change their last names (marriage) is there a way to have the...
Pat
10-05-2009 10:17 PM
DeZZar Go to last post
4 78
hi, i've an application in converted into ac2003 and mad in Ac2000. It did work without a problem for several months after conversion....
Georg
10-05-2009 04:59 PM
Georg Go to last post
2 66
Hi, I know in VB you can create an group of controls with the name's txtBox(0), txtBox(1), txtBox(2) ..etc is this same type of naming convention...
bipin
10-05-2009 03:32 PM
hbinc Go to last post
7 103
I want to try to use the SQL upsizing wizard in Access2007 so I downloaded and installed SQL server express (with .NET framework etc). SQL took a...
Lou O
10-05-2009 08:58 AM
Lou O Go to last post
4 77
Post New Thread

Display Options
Showing threads 2451 to 2500 of 35205
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.