Search results for query: *

Access tables were migrated to SQL via the upsizing wizard, connecting to tables via an ODBC connection. Need to know how to change the connect string to now connect to the ODBC tables. here's the code when the tables were linked to MS access: 'Option Explicit Sub localnet() Set ws =...

We moved a database from ms access 2003 to SQL server 2000. We kept all queries in ms access and link to the tables via ODBC. Can someone please tell me what is wrong with this code, I'm getting the error " problems obtaining data" when it tries to import the data into excel. it's supposed to...

We moved a database from ms access 2003 to SQL server 2000. We kept all queries in ms access. Can someone please tell me what is wrong with this code, I'm getting the error " problems obtaining data" when it tries to import the data into excel. it's supposed to import data to an excel...

I'm using this command to pass fields "case number" and "victim id" to "additional victim" form from "clients" form, I need to pass 2 more fields from clients: "accepted services date" and "accepted service". What would be the correct syntax ? Private Sub Add_Add_Victim_Click()...

This used to work in access 97, I upgraded my computer to access 2002; I get "undefined function MID in expression" when I run query. DISP: Mid([ACTV_STATE],16,1)

Have a date field with data type as "text", the data is in MM/YYYY format. having trouble querying by date range. Any sugestions?. I'm not allowed to change the date type in table. Help is appreciated.

I have a "name" field in an access 97' table with all records in uppercase, I need to convert them to propercase (first letter in cap's, rest in lowercase). Does any one have any ideas on how to accomplish this. Thanks a bunch!