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!

Search results for query: *

  1. FastEddieB

    Combo Box selection using a hand held scanner

    I know one of you is going to make me feel real stupid about this question....but here goes. I have a table called Components, which has a list of components and an ID number for each one. On my form, I have a combo box for components, which when selected will be inserted into another table...
  2. FastEddieB

    Transfer of Data from MS Access using MS Query in Excel

    In MS Access, I have a large group of queries that use a module I wrote called IsInDay. We collect data by shifts, but our 2nd shift runs a couple of hours after midnight, so when you query data using a shift and a date, it misses the entries after midnight. The IsInDay module, looks at the...
  3. FastEddieB

    Linking Access Query to an Excel Spreadsheet

    Hi GPOTony, Thanks for the idea. The problem is I am using MS Query. When I use MS Query, create the obdc connection, and select the ShiftDate field, then I receive the error that "Undefined function "ShiftDate" in Expression" Somehow I have to get Excel to recognize that...
  4. FastEddieB

    Linking Access Query to an Excel Spreadsheet

    Well, I tried copying the module to Excel, and I am still getting the error "undefined function "ShiftDate" in Expression" whenever I try to select a query that is using this function in access...which is all of my queries by the way. I am not a very experienced Excel user...
  5. FastEddieB

    Linking Access Query to an Excel Spreadsheet

    I want to link several Access queries to an Excel spreadsheet, instead of using DDE....... In my queries, I am using a Module called "IsInDay, so that any data time stamped between the hours of midnight and 3 AM, is considered to be the previous days data. Here is the code: Option...
  6. FastEddieB

    Linking Data from Access into Excel

    I want to link Access queries to an Excel spreadsheet, instead of using DDE....... In my queries, I am using a Moduld called "IsInDay, so that any data time stamped between the hours of midnight and 3 AM, is considerde to be the previous days data. Here is the code: Option Compare...
  7. FastEddieB

    Cascading

    Thanks so much Craig..I am kind of a novice at this.....Just as I got the email for your posting, I was poking around in the Table and Relationships Forum and saw a similar reponse for someone else who had the same issue. I love this web site....in just a small amount of time I have found...
  8. FastEddieB

    Cascading

    I have a cascading combo box issue. Actually it might be more of a relationship issue, so here goes. I have a table with a list of components and a table with a list of sub-components. I want to set up cascading combo boxes, so that when you select a component, only the sub-components that...

Part and Inventory Search

Back
Top