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!

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

Recent content by Emmie1

  1. Emmie1

    Change activated button on IE download dialog box to be save.

    I'm not sure if I'm in the right forum or not, but does anyone know how to change the activated button on the IE File download dialog box to be "save" instead of "cancel"? I’ll have a large download, and will multi-task while waiting for the download to “load” the dialog box. Since the...
  2. Emmie1

    How to change the startup form of a db with vb?

    Thanks Remou, I had already started the tweaking process! It works great! You ROCK! Thanks sooooo much!
  3. Emmie1

    How to change the startup form of a db with vb?

    Thanks Guys! Remou: Do I put this code in the old DB code that creates the new database or put it somewhere so it starts up in the new Database when it's open? PHV: Each months DB starts out with about 129K (possibly more if it's a good month!) records, which we do much manipulation through...
  4. Emmie1

    How to change the startup form of a db with vb?

    Hi, I have a database which I have written code to create a new database each month. This code works perfectly except for the need have a specific form be the startup form for the newly created database. When I create a new month, I want the new month to have the form [BEGIN] as the startup...
  5. Emmie1

    Adding values together based on 2 criteria

    These suggestions work great!! However, I left out a peice of info above. The 3 columns listed above are the ones that matter to me right now, but there are about 15 other columns (Customer name, date ordered, type of order, options, delivery method, etc....)that I will need a few steps down...
  6. Emmie1

    Adding values together based on 2 criteria

    Hello! I current have a table [ORDERS] that lists customers orders with debits and credits. What I would like to do is for each customer who has the same customer number and order number, add the debit and credit together to give me the remaining value. BOTH criteria must be met before the...
  7. Emmie1

    Using a calculated field from a form in a query

    Thank you very much PHV for your wonderful help! It worked perfectly! You're the BEST!! Thanks again, Emmie
  8. Emmie1

    Using a calculated field from a form in a query

    Hello! I'm not sure if I'm in the right place, but here goes.... I have a form "Customer Entry" that I created in Access 2002. In this form I have a calculated field based on "Customer Table". Outstanding Days =IIf([phone call date]<>"" And (IsNull([completion notification])),[Date]-[phone...
  9. Emmie1

    VBA code to append Excel data into the next blank line of a text file

    Hello, I currently am looking for a way to copy a row of data from an excel spreadsheet into the first blank line of a pre-existing text (CSV) file. I have about 30 remote locations who enter info into an excel form. I have a hidden (load) sheet that gives me the info that I need in the order...
  10. Emmie1

    Using wildcard as source and destination name in TransferDatabase??

    Thanks so much for the posts!!! PHV - The counter code seems to work out. The problem that I'm having now is that my query names are descriptive "01combine prodcode", "02Import price", etc. But I can work around that!! Thank you very much!!! LESPAUL - This database is a "prep database" it...
  11. Emmie1

    Using wildcard as source and destination name in TransferDatabase??

    Hello, I have a database that has about 60 queries in it. A new database will be created each month. Using a command button, I would like to write code to import all of the queries from the previous months database into the current months database for the user. The code I have written so far...
See more

Part and Inventory Search

Back
Top