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!

Recent content by fletch518

  1. fletch518

    Choosing Excel Spreadsheet for Import Using Code

    Are these spreadsheets constant? If so, try building a form with a list box and place the paths and names of all your files in the box. Then code it like this: Dim stFile As String Dim stTable As String stTable = "TableName" stFile = [Forms]![Formname]![ListBoxName]...
  2. fletch518

    How can I limit the number of queries here?

    All right, I give up! I'm trying to run a query(s) that will return data and perform calculations based on the criteria >=[Forms]![My_Form]![Date_In1] and <=[Forms]![My_Form]![Date_Out1]. This returns values for Starts and Hours on a particular piece of equipment (which will essentially tell...
  3. fletch518

    Searching by different date formats

    Doh! Thanks for sticking with me. I had a brainfart there due to a lack of sleep. Thanks for your time and patience, works like a charm. All's well in Metropolis, once again.
  4. fletch518

    Searching by different date formats

    I'm not sure if that will help in the short term. I'm using a mm/yy date on a form as the criteria for the query to find the appropriate records. However, you're response did help me find a temporary solution. Maybe I should rephrase now that it's working (within the last 10 mins). Is there...
  5. fletch518

    Searching by different date formats

    Is there a simple way to do a search by using a mm/yy format to find data in a mm/dd/yyyy format. I tried using a query that would add days to the mm/yy format (since I'm assuming Access believes the data to be from the first day of the month), but no luck. I'm probably missing a VERY obvious...
See more

Part and Inventory Search

Back
Top