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 Rhinorhino 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: *

  1. lyonder2000

    VBA query results in subform

    I have a form that will navigate through records. Each record is in a division (division is displayed on the form). Based upon which record is displaying, I will need a VBA query to run and display in a subform the results of the query. I need some assistance knowing which event to place...
  2. lyonder2000

    Use of Segregation Table

    I hope this makes sense. I have a segregation table: 1 2 3 4 5 2 3 4 x 5 I have a form that has product in it with classes. Classes are 1,2,3,4,5 in the segregation table. Product conflict is created if an 'x' falls in place on the grid. Product A and Product B conflict if A is a 4 and B is a...
  3. lyonder2000

    Importing Several Files with a Macro

    I have a report designed in Access. I have six tables that populate this report. The data for each table comes from six separate excel files. I have designed a macro that uses the TransferSpreadsheet to import the excel files. I wanted it as automated as possible. Here lies my problem. The file...
  4. lyonder2000

    Query for all data from a Form with Subforms

    I have a database that I developed that will have forms with subforms. I also have an export feature that will export the data from the respective table. However, I didn't realize that the subforms throw a twist on a simple SELECT * query. What is the best way to export out all the data from...
  5. lyonder2000

    Converting a Calculated Time to Decimal

    I have a calculated "WorkHours" in my time application. In an effort to create a Productivity measure, I need to divide this time into a single integer. (ie, WorkHours = 2:15, CompletedTasks = 20; CompletedTasks/WorkHours=20/2.25=8.89 audits per hour

Part and Inventory Search

Back
Top