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 gkittelson 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. mswarner

    Pass through query in code

    I'm using a pass through query to select records from an AS400 system that I'm connected to through ODBC. You can't have a pass-through query prompt you with parameters so you have to create the SQL statement through the concatenation of your statement and the parameters you want to use. See...
  2. mswarner

    Passthrough query in VB code

    I'm trying to use code to execute a pass through query with parameters. I got the procedures from Microsoft's site. Here's my code: Option Compare Database Option Explicit Function ParamSPT(StartRange As Long, EndRange As Long) Dim MyDb As Database, MyQ As QueryDef, MyRS As...
  3. mswarner

    Pass through query in code

    I'm trying to use code to execute a pass through query with parameters. I got the procedures from Microsoft's site. Here's my code: Option Compare Database Option Explicit Function ParamSPT(StartRange As Long, EndRange As Long) Dim MyDb As Database, MyQ As QueryDef, MyRS As...
  4. mswarner

    Linking to AS400 with ODBC - can't access some tables

    I've linked to my AS400 system through ODBC. I've got a few tables linked. Some of them will allow me to open them and/or do queries and some just give a little blink of hte hourglass and won't let me access them. They don't give errors or anything, just - nothing happens. I think it's...
  5. mswarner

    ODBC Linking won't open certain tables

    I've linked to my AS400 system through ODBC. I've got a few tables linked. Some of them will allow me to open them and/or do queries and some just give a little blink of hte hourglass and won't let me access them. They don't give errors or anything, just - nothing happens. Any ideas?
  6. mswarner

    Aging reports

    This is what I want to do: Trans [tab] Trans [tab] Order [tab] [tab] Change in [tab] Date [tab] Type [tab] Number [tab] Loc [tab] Balance [tab] Balance 8/14/00 [tab] FROM [tab] [tab] T8C [tab] -36000 [tab] 46600 8/14/00 [tab] R FIN [tab]...
  7. mswarner

    Aging reports

    Does anyone know how to do aging reports?  I want to do an aging of inventory availability.  I've got all the manufacturing orders to make the stock and when they're due as well as a bunch of sales orders against the stock.  I want to create an aging report that...
  8. mswarner

    Splitting a database for use on two versions of Access

    I used Access 2000 to split a database into front end and back end.  Then I created converted a copy of the front end database for use on Access 97.  When I tried to open that copy (on another computer running Access 97), it didn't recognize the back end database...
  9. mswarner

    Using Subforms to add a full record from a table to another table

    I'm trying to set up Bills of Materials for a project I'm doing.  I have an raw material item master table.  For each product, I want to be able to type in a raw material item number in a subform and have it bring up the whole line for that record in the item master...

Part and Inventory Search

Back
Top