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 wOOdy-Soft 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. wh0wants2know

    exporting from acess to excel with vba, saves multiple workbooks?

    I'm trying to create an excel spreadsheet from my access application and when I try to use the save method, it only saves one .xls file, called test.xls. however, when I open test.xls, the correct spreadsheet comes up and a second one opens that is similar to the first and called "book2.xls"...
  2. wh0wants2know

    sql query not running from event procedure

    I have an access project with several linked tables from a sql server. The tables are linked through a file dsn and i can view the data in them. I also have a query in access that runs on the linked tables and some of the local tables simultaneously. When I run that query by double-clicking...
  3. wh0wants2know

    how to edit a report?

    this is a stupid question, but how do you edit a report? i have some reports that this application uses that i want to change, so i dragged one of them into visual studios and it popped up. now, i can change the text in the fields, but i can't add new objects, i can't resize anything, i can't...
  4. wh0wants2know

    insert question

    I have two tables, dbo_postalcode and ACI. some of the records in ACI may or may not be in dbo_postalcode, so what i want to do is insert only the values in ACI that are not present in dbo_postalcode into dbo_postalcode. my sql query is thus: <code> INSERT INTO dbo_PostalCodes ( PostalCode...
  5. wh0wants2know

    update one table from another table

    i have two tables, aci_zip and dbo_postalcodes. they both contain a bunch of zipcodes, but aci_zip has a field called ACIarea and dbo_postalcodes has a field called ACIZones. these two fields are the same. Now, most (but not all) of the zip codes in aci_zip are also in dbo_postalcodes and...

Part and Inventory Search

Back
Top