Recent content by Linda31

Hi all I have code that I want to be able to access from 2 different forms. I want to be able to put it in a module, there is a place on the form where it needs to reference a control and pass a value back to that control. Is there a way that in this function I could reference the current form...

Hi I have a sales order that does the same thing. What I have done is added a field in my table called printed, after it has run a query on the close of my report it updates my check box in the table. Hope that helps Here's my code : DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE...

Hi everyone. I have a report formatting problem that I hope someone will be able to help me with. I have an Access db that I have been updating. When I transfer the database from my design computer to any other in the lab all of my reports lose the formatting, for example I have a report that...

Thank you ancient one. I actually figured it out. I appreciate your reply.

Hi all. I need to import data from an ACT db to Access. I cannot directly link Table to db because of multi users. ACT db is on the network, and I need to update the Customer table in Access with the info from ACT. The code I currently have is: Testing\Documents and Settings\Act\Cust.dbf...

Details about the Windows 98 default realtek driver problem can be found here: http://support.microsoft.com/default.aspx?scid=kb;en-us;189778 It took a few days, but I was able to isolate the table corruption to one computer & after talking with the user, I found out that they had stopped...

Everyone, thank you for your input! I believe that I solved this issue. A local computer on the network had a Realtek network card driver (rtl8029.sys) that was included in Windows 98. This driver has been known to send corrupt data packets and I believe that it was this that was causing the...

Autoeng, While at the developer station, I was probably doing some combination of running test data and modifying front-end forms and code onto the local database. the structure of the tables on the back-end database was not touched. The developer's station frontend db being open, unfortunately...

Autoeng, thank you for the ideas. I do not have any make-table queries, and i've double-checked that all relationships(foreign keys) between tables and all data types agree. As far as user input, on various forms input is derived from selections from list boxes and entry into text boxes. The...

Here is my problem: We have a multi-user Access 2000 frontend/backend environment where the front-end database contains all of the forms, queries, reports, code, modules, etc and the backend contains just the linked tables. We have the front-end installed on about 10 computers, but the problem...

subreports OK I have 5 diesetup charges at $63.00 each, the fifth one is free. I also have 5 extra time charges at $17.50 each.So the subtotal due is $402.50, but the total due is 339.50 ($402.50-$63.00). Is this enough of an example? Thanks

I have a sales order report that has two subreports on it one calculates the number of items sold and their amounts and the other is a list of the names of dies sold. On the subreport quantity, I have two items that can be sold, diesetup and an extra time charge these have to be calculated...