Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AndieV
  • Content: Threads
  • Order by date
  1. AndieV

    Rename files in TransferDatabase

    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...
  2. AndieV

    Help with correcting code

    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...
  3. AndieV

    Ignoring null or black fields

    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...
  4. AndieV

    Totals with multiple criteria

    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...
  5. AndieV

    Change a table link

    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...
  6. AndieV

    creating a running sum on a form

    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...

Part and Inventory Search

Back
Top