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 derfloh 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 SchoonDog

  1. SchoonDog

    Update record with previous record

    I am using a imported text file as my table so I am not manually entering all of the data to begin with. This is begining to give me a headache :) SD
  2. SchoonDog

    Update record with previous record

    hey everyone, I thought this would be pretty simple but I am running into some troubles. I want to replace a null ID in a table with the previous ID in the same table if ID is null. I have been trying VBA but I can't seem to do it. I can do it fine in Excel but that is way to manual. Any...
  3. SchoonDog

    Bold Menu Items? Really Weird.

    Yes I checked that. The bold menus seem to be specific to Microsoft products. Do you know of a setting anywhere else?
  4. SchoonDog

    Bold Menu Items? Really Weird.

    Hey all, For some strange reason all of microsoft office has bold tool bars and menu items. Access, Excel, Word, and VB are all like that. I have no idea what is going on. It seems to have happened around the time I installed Visual Basic. Does anyone have any ideas? SD
  5. SchoonDog

    Running two reports at once

    Also I would like to use the same parameters from Report A in Report B.
  6. SchoonDog

    Running two reports at once

    Hi all, I would like to run two reports by running only the first one. ie) Run report A and report A and report B run and open. Thanks, SD
  7. SchoonDog

    Query Performance

    Hi Everyone, Is there a way to enhance the speed of a query on a rather large table? I have a table of almost 2 million recs and I am doing a name search on the full or partial name but it seems to be taking a very long time. Any ideas? Schoon
  8. SchoonDog

    Left Join Problem?

    It actually gives me an ODBC error. The weird thing is that when I remove the last left join it works fine. ODBC problem or SQL? Thanks, SD
  9. SchoonDog

    Left Join Problem?

    My SQL looks like this: SELECT tblname1.field1,tblname2.field2,tblname3.field3,tblname4.field4 FROM ((tblname1 LEFT JOIN tblname2 ON tblname1.field1=tblname2.field2) LEFT JOIN tblname3 ON tblname2.field2=tblname3.field3) LEFT JOIN tblname4 ON tblname3.field3=tblname4.field4; Can anyone tell me...
  10. SchoonDog

    ODBC Call Fail

    Does anyone know why I would get an ODBC call fail when I define criteria in a query but when I remove the criteria the query runs fine?
See more

Part and Inventory Search

Back
Top