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!

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

    ok, i've tried this and it did not work. it's still like the query is just not being run and there's no error message of any kind.
  3. wh0wants2know

    sql query not running from event procedure

    This is all well and good for me, but I have a lot of other users who use this program and only have the access runtimes, although the file DSN is identical on all of their computers. if i save the password, will it work for them also?
  4. 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...
  5. wh0wants2know

    how to edit a report?

    probably whatever version came with visual studios pro 6. i know that the program was written in that, but i have no idea what version of crystal it is. i know it is NOT the one that i have with visual studios .net, and i have NO idea how to find out what version i have under .Net
  6. 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...
  7. 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...
  8. wh0wants2know

    update one table from another table

    that works. now, i'm only running this in access to test the query with my dev server and corresponding database. ultimately, i will need to run this on the sql server, probably via DBAMngr2k or similar, so will this query not work for that? will the access query work on the sql server or is...
  9. wh0wants2know

    update one table from another table

    This looks like what i want to do, but as soon as i try to run this (i'm running it in access with aci_zip as a local table and dbo_postalcodes as a linked table to the sql server), it asks me for the values of A.city, P.city, etc. so it clearly is not taking these values from the tables that...
  10. 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