Search results for query: *

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"...

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.

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?

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

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

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

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

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

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

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