| Thread | Last Post | Replies |
|
| environment variables | 24 Aug 2006 15:33 GMT | 7 |
Good day All, Does anyone know where I can get the full list of environment variable (args for environ()) - (Doug, the API is good, but I need the environ$ list.) thank you
|
| Character limit | 24 Aug 2006 15:20 GMT | 4 |
I have a string, which is long. It is an update statement. When I display the results in the message box, my statement is cut off at the end. What I did was put the where part in a different string variable and concatenate the two strings, but that did work. Does anyone have any ...
|
| Single and Double Quotes | 24 Aug 2006 14:47 GMT | 6 |
I am new to vba am and encountering some issues when attempting to run a sql statement. I am having issues with Single Quotes and Double quotes causing errors. If the values contain any single or double quotes I get an error. See code below.
|
| help with HTML | 24 Aug 2006 14:20 GMT | 2 |
I would like to transfer a query as HTML by providing the user a command button on a menu, I need to do the transfer with on click. Can some one help. thanks
|
| Updating Office 2003 with SP2...can lead to error if don't? | 24 Aug 2006 12:43 GMT | 2 |
is there any chance that a Database coded on a pc with Office 2003, Visual Studio 2003 and all the latest updates installed can run fine and the same database when run on a pc that has office 2003 installed, but not updated, gets error?
|
| using Date to filter reports | 24 Aug 2006 11:58 GMT | 2 |
Well I thought this was going to be easy but.... I want to print out a report for contact birthdays. I have the date in date fields and put Me.Filter = "birthDate = " & START_DATE
|
| problem when load image files to database.. | 24 Aug 2006 09:56 GMT | 5 |
i got a problem with database..when i trying to link the images from 1folder to database using vba coding i've got error 438"object doesnt support this property or method"....this the code: Option Compare Database
|
| Using Call Shell to open Excel Workbook within Access 2003, SP2 Ve | 24 Aug 2006 07:04 GMT | 1 |
In a Sub procedure, I am updating a spreadsheet from queries within Access. Then I use the 'Call Shell' in Access to open the spreadsheet for viewing. When opening the spreadhseet, I get a warning message "File???.xls is already open. Reopening will cause any changes you ...
|
| Calendar versions different | 24 Aug 2006 06:01 GMT | 2 |
I made a form with the calendar version 8 from the system32 folder. On my laptop, it has the calendar control 9, from the microsoft office folder. When I try and run the form on the laptop, the calendar kinda works, but the numbers don't show up. Do I have to register the ...
|
| Having trouble with OLE - Help please 3rd time asking - No respons | 24 Aug 2006 03:18 GMT | 7 |
I have a note table that I want users to be able to attach or link to a number of different objects (1 object per Record). Meaning they may need to attach a video or a graphic or a document to the note. I set up the field as an OLE Object (Imbedded, which I need to change.) ...
|
| how do I debug access script? | 24 Aug 2006 03:12 GMT | 3 |
I have a database that someone else created for me and then went on vacation...When I attempt to upload data from a selected file, i get runtime error 2391 Field F2 does not exist in destination table. When i pull the table and do a find, there are no results...
|
| Trying to catch a bad user. | 23 Aug 2006 23:54 GMT | 11 |
I did not setup the existing software. I have a user who has decided that she has the right to go into the program code and write queries and run forms manually. She is causing problems! My intension is to catch her doing what she is doing. Now the reasons for
|
| Immediate Window code --> listbox value | 23 Aug 2006 23:25 GMT | 3 |
I am attempting to debug my form. I know there is a way to use the immediate window to return the values of listboxes (lstRMonth, lstRYear) on my open form. Thanks in advance!
|
| How can I enumerate the macro list in Access97? | 23 Aug 2006 18:23 GMT | 2 |
In VBA in an open DB, I am creating a new blank DB, and copying over every object from my open DB. Everything can be copied except for the Macros. I can't find a collection of them or any way to enumerate them. Any ideas out there? I just need to loop thru the list of existing ...
|
| Selecting a specific record in a subform | 23 Aug 2006 17:17 GMT | 2 |
I have a main form for people that has a subform to load their addresses which are multiple. How do I get the form to open to a specific address (i.e. a default address). I want to avoid opening to the first address in the recordset. The table for the addresses distinguishes ...
|