Search results for query: *

I have had this API function working for months without any problems. After XP SP2, the error it returns is 5. Anyone knows what fHandleFile / ShellExecute error 5 means? Thanks. shar

I have converted an Access application from 97 to XP. The problem is the XP version which keeps on growing in size, much faster than the 97 version does. I know db file growth is a typical Access behavior. I tried compacting it, but it did not reduce the size much. I tried the decompile...

When I use the Currentdb.name, I get the 8.3 naming system, i.e.: C:\PROGRA~1\Projects.mdb. How can I get the long file name such as: C:\Program Files\Projects.mdb? I am using Access 97. Thanks. Shar

Is there a way to declare api functions in a vbs file. I have been declaring api function such as: Declare Function RegOpenKeyEx Lib "advapi32.dll" Alias "RegOpenKeyExA" (ByVal hkey As Long, ByVal sSubkey As String, ByVal lOptions As Long, ByVal lSAMDesired As Long, hResult...

Please help. Here is a very simple 4 lines vbs code: Dim lPath lPath = "D:\cpj.mdb" Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run strLocalPath Why when I double click the vbs file it wouldn't start cpj.mdb in MS Access? It doesn't do anything. I tried...

I am new to this, so please bear with me. How do you step through a vbs script? I know you save the commands in a text file with vbs extension and double click on it to run it. I have done that, but something in my script does not work. How can I step through the code one line at a time to...

I use access 97 to export data into an Excel file. I have written code in MS Project to import the data from the Excel file and perform modifications and formatting. In Acc97, my code exports the data to an Excel file and start MS Project, but I cannot run the codes in MS Project. I tried the...

I use access 97 to export data into an Excel file. I have written code in MS Project to import the data from the Excel file and perform modifications and formatting. In Acc97, I can export the data to the Excel file and start MS Project, but I cannot run the codes in MS Project. The SendKeys...

Some of the reports in my application (Access 97) are on legal size paper. As a work around for the problem of Access reverting back to its default page setup, I have the page setup icon on the report menu bar so users can change the paper to legal before sending the report to the printer. By...

We are using Access 97 on Win95 workstations (we have started moving out of caves and have just discovered fire.:) The infamous second instance of Access when merging data to Word document has plagued us. I have viewed and followed MS “workaround”, but it does not work and upgrading to newer...

I have a parentform with a subform and a subsubform. In the subform events, I want to run the "DoCmd.GoToRecord acDataForm, formname, acFirst" command for the subsubform. However, the formname is giving me trouble. If I just use the subsubform name, I get an "object not...

I have a form with a dozen tabs, one for each child table (all are 1->many to parent). The application is running over a network. Now the app speed is barely acceptable. Would making the tabs invisible reduces the query calls to the application and therefore increases the record to record...

We use Novell's GroupWise as our email system. The Docmd ..... False always comes up with 'recepient unknown' error message. Once the 'False' is changes to 'True', with no other changes, it works fine! Anyone can shed any light on this? Thanks.

I use a function call in Access 97 to pass variable data to the criteria field of a query. Up to now, the function was evaluating to a single string, such as "Completed" or "Active" and it worked fine. Now I need to have the function pass two value separated by an 'And' or...

Last week when I started using a database with approximately 450,000 records, the console on our companies server started reporting thousands of error message with my workstation's MAC address. I do not know the exact error message, but it had to do with exceeding the max number of locks. Our...

I have a report with a subreport in the footer. When I preview the report, the first 10 to 12 pages has data and then a never ending array of blank pages with the header from the last record. I have tried testing the HadData property and setting the subreport to invisible if there is no data...

I have 2 mdb files, the front end with all forms, reports, queries, and modules, and the backend with just the tables.<br><br>Users open and work in the front end which is linked to the backend tables.<br><br>As the users get in and out of the database, the front end and backend mdb files grow...

I have a simple vb code to look in one table, record 2 values, go to next table, find the records with value1, paste value2.<br><br>Here is the code:<br><br>Function AddCStoCOtbl()<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim rs0, rs1 As Recordset<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim db As...

I have written SQL statements for changing form recordsource using VB code.&nbsp;&nbsp;How do you use SQL statements for changing&nbsp;&nbsp;report recordsource.<br><br>It seems the report must be in design view to be able to change the recordsource.&nbsp;&nbsp;However when I send it to screen...

I have a form with 8 child tables, all 1 to many relationship to partent table.&nbsp;&nbsp;Three of the child tables have a date field with today's date as defualt.&nbsp;&nbsp;These dates fields are showing #Name? instead of today's date.&nbsp;&nbsp;I can enter today's date and the form accepts...