Search results for query: *

I have the following code set up in my program. I would like to know if there is a way for me to change the name of the dbaseIII file without having to go into the code. ie. I would like to export Newtable to Monday.dbf on Monday, Tuesday.dbf on Tuesday etc. Is there a way to do this easily...

Hi MichaelRed Thank you for the suggestion. Yes both computers are identical for file set up...I will be checking ODBC drivers, I hope that this does the trick. Andie

Thank you for your reply The references are all the same and in the same order on both computers. If you have any other suggestions, they would be most appreciated. Thanks Andie

I'm having a problem with some code in the database that I am working on. When I load this database on my computer it runs smoothly and without a hitch. When I load the same database on another computer, it doesn't run. Both computers are running ACCESS 2000. Am I missing something in the...

I have a database setup in Access97 that contains a linked table that is coded to delete and update its link to the various dbf files that were created previously. I have all of the reports, queries and forms based on this transitional database and everything was running smoothly until the...

Hi John, Thanks for the tip. My original setup used DSum on an unbound text box but I didn't know how to integrate the months. When the user enters data, they often enter two or three months at a time and they need the totals to be separate for each month and each unit number. If I base it...

I need to create running totals for fields in a form based on multiple criteria. I need the total kms and total litres that were entered on the current date, for the current unit number and month and the user needs be be able to either have a running total on the form or an autokey that would...

Please add me to the mailing list for a copy as well. andrea@spelunking.mb.ca Thanks Andie

I've inherited a database that was a conversion from dBase III. Is it possible to write a macro or sql expression that will allow the user to change a table link. What I need to happen is for the user to select the company for which they will be entering information. All the information is...

I am working on a database and need to create a running sum on a form. The database tracks mileage in both kms and miles and I need to be able to track the totals entered: 1)that day 2)by company 3)by unit number and for each miles or kms I know I could use a parameter query and enter the...