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: reg999
  • Content: Threads
  • Order by date
  1. reg999

    Lookup form value between limits.

    I have a table of inventoried parts. The parts have different markup percentages based on the cost of the part. In a form to update inventory cost and markup, I am trying to add a control that will display (for user reference) my standard markup percentage based on cost. I have added a table...
  2. reg999

    Programs won't close from Processes

    Both WINWORD.EXE and MSACCESS.EXE remain running in Processes after the programs close. Each time they are used, another instance is added in Processes. Here's what I have done/found so far. If I stop the Service for MDM.EXE, I can prevent the problem occuring with Word, but not with MS Access...
  3. reg999

    Show newly appended records on a form

    Yet another silly question. I have a form with a button that needs to do the following: -run a query appending data to a table (underlying the form) -close the form -re-open the form to show the last entry in the table. Everything works up to re-opening the form. When the form re-opens it...
  4. reg999

    Lookup of corresponding file names

    I have a database of sales records. I keep invoice numbers in a table and scanned images of hand written invoices as .pdf files in a directory on the hard drive. I would like to list all of my sales and have the list show whether there is an existing .pdf file that corresponds with each...
  5. reg999

    Separating values to multiple fields

    OK... This has got to be simple. I have a table laid out as follows. Date G S TN SN GN 4/1/03 4.33 48 1 1 H 4/1/03 3.28 41 2 1 H 4/1/03 4.4 40 3 1 H 4/1/03 6.25 38 1 2 H 4/1/03...
  6. reg999

    Action based on a value in an unbound table

    ...need help coding this, I'm very new to VBA coding. I have a button control on a form that needs to perform an action based on the value of a field in a table that is not bound to the form. Access table name is "Match" field name is "Mtc" (Text field). All values in the "Mtc" field are the...
  7. reg999

    Top 10 query returns 11

    I have a query in Access that uses Top 10 to get values from a record set. When I have duplicate values for the 10th and 11th record, both records show up in the results. I've forgotten how to leave out the 11th record. reg
  8. reg999

    Looping

    I think that this should be easy, but I'm having trouble. I'm creating a database for my shooting club. I need to select each shooter's top ten targets from a table. I have a top ten, append query that I'm trying to loop over with a FOR EACH loop. I have a field holding each shooter's ID...
  9. reg999

    Looping over access query

    I think that this should be easy, but I'm having trouble. I'm creating a database for my shooting club. I need to select each shooter's top ten targets from a table. I have a top ten, append query that I'm trying to loop over with a FOR EACH loop. I have a field holding each shooter's ID...

Part and Inventory Search

Back
Top