Search results

I have a form bound to a query. the query is just the table with all fields selected. The JobID field is in the table in all caps, which is how the user wants it displayed. When the form comes up, the jobid is displayed in all caps, but when it is clicked into sometimes the jobid changes to...

Here's my code: DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\" & strMDBName, acTable, "CLR Extract Time", "New CLR Extract"

I need to import tables to an access db and am trying to automate it. My transferdatabase do cmd appears to run since Ii have error traps in the code and the errors are never output, but the transfer is unsuccessful and the table is not imported. What could I be doing wrong? Thanks

I have a pass-through query that is passing a pair of variable parameters to execute an oracale procedure. Here it is: Exec P_AssetTagUpdate ('ABC', 'DEF') note, here we are trying to change a pc's tag number from ABC to DEF. User gets the message: ODBC call failed [Oracle][ODBC] Syntax...

Wayne I just stepped through my program and Yes, the dos window comes up and the shell appears to run.

I have the following statement in my module: X = Shell("d:\BOM\Wrapup.bat", 1) The file that should be updated by this statement is not getting updated when it runs in the module, but if I run the Wrapup.bat on it's own, it updates the file. What could I be doing wrong? Thanks for any help.

Zero-length string Harry, My field is No on required.

Why do I get the message "Field "XXXX" cannot be a zero-length string"? I have the table validation set up so the field is not required and the same on the form. Any help is appreciated. Thanks.

Okay, I now know how to use the GetOpenFileName to have the dialog box come up so the user can choose their file. My next question: I want a default drive and directory to appear in the file box How do I do that? Thanks in advance.

How do I delete an excel spreadsheet via code? I run a query that creates the spreadsheet, but when I run it again it will not overlay the spreadsheet, it makes a second copy. I either need code to delete before I create, or overlay it. I am using the TransferSpreadsheet method of the docmd...

In Access, is there a parameter which stores the ODBC user id value? Thanks.

How do I programatically check to see if a query exists? Thanks.

What code do I use to decode the month? In other words, for date 2/5/2003, I need "February" written out. Thanks in advance for any help.

Where is the setting in access so the upper and lower case will match and I don't have to search on both in a query? Any help is much appreciated!!

Is there any way to make a windows subdirectory via code? I need to make a new one each month, using a variable. Thanks.

Database comments If you right-mouse click on the database name when your db is open, then click on the bottom of the drop down "Database Properties", then 5 tabs show, Summary being the 2nd tab. The "comments" I am referring to are under this tab. Those are what I need to display in my...

I need to print the contents of the "comments" under the database summary tab. How do I do this in visual basic. thanks in advance for any help!!

Does anyone else have the problem of a too complex query not running? I get the message "No current record" but then I take out one of my joined tables and the query runs. Is there anything I can do besides making 2 queries instead of breaking the query down to 2 instead of the one? Thanks...

I am running a report and getting the message no current record. What could be wrong? Thanks for any help.

I have a form with command buttons with bitmap pictures. On my PC the form and buttons are displayed properly, but on one of my user's machines the icons with bitmap pictures are weird looking with lines through them and different colors appearing. What could it be? The buttons are working...