Search results for query: *

I upgraded to Access 2000 and I'm getting the same error. I use both IBM Client Access and HiT Software to connect to the data on the AS400. Both give me that error. If I run the application it crashes with the message: The instruction at "0x65009f45" referenced memory at...

You can not control it from Access but you can on the AS/400. Have the AS/400 administrator create a logical file (view) with only the 5 fields you need from the physical file. Then just connect to the logical file.

The code I gave you works also. You just forgot the single quotes that need to surround the variable. One goes after the equals (=) sign and before the second double quotes ("). The other one goes between the ending pair of double quotes. Look at my example again. Larry SDC

Where is the email address kept? If it is in the same table as the personnel data you can just save it with the project data. If it is in a different table you need to know and save the key field data that relates the email address to the employee saved with the project. Then you can use the...

So what caused the problem? What is the fix? Share please! Larry SDC

You could have a compiling error. Open any window containing text like a module or form event. Go to Debug on the toolbar. Click Compile All Modules. If an error ocurrs fix it and repeat the process until there are none. Now try creating the MDE. Hope this helps. Larry SDC

By definition GLOBAL variables are available throughout the application or database, in this case. Every variable takes up memory. While it does not hurt to have some GLOBAL variables, it has been my experience and understanding that if you can get the job done with standard (PUBLIC and PRIVATE)...

Beth, If I understand your question, you can just change the field names with no problem. The lookups will still remain with those fields no matter their names. Make a copy of the table and test it. If you want, you can create a copy of the table, delete all the records in the original, change...

=DCount("*","tbl","[columnX] = 'A'") To add more conditions: =DCount("*","tbl","[columnX] = 'A' and [columnY] = 'B'") if using variables: =DCount("*","tbl","[columnX] = '" & VarA & "' and [columnY]...

I believe that the parent's properties supercede the child's. So, when you created and set the parent form's properties to FALSE, the child inherited them. When you code the parent to all the changes, the child still has the inherited properties. The key words here are 'created' and 'code'. I'm...

Use the DSUM function. Place it in the Control Source property. Here is an example. =DSum("[Hours]","tHistorySummary","[year] = " & [iYear] & " and [CustNo] ='" & [CustomerNo] & "'") This example sums up the hours for a customer in a year...