Search results for query: *

Jerryklymns, thanks so much for your time and input, this looks good.

JerryKlmns, "Client demographics" is an ODBC connected table. The problem is when the code gets to rst.Index = "socialsecurity" . I believe there's an issue with linked tables and indexes. I would love for someone to tell me what would work, actually modify what I have so that I can try it...

got it to work but now I'm getting an error message on this one.......Remember the database is connected via ODBC. it fails at the rst.Index = "socialsecurity" - Is there a way I can code this differently. I heard that INDEX and SEEK does not do well with ODBC connections...... thanks! Option...

Thanks for you reply. I found this code,I will try it and see if it works. Dim db As Database Dim ws As WorkSpace Dim rs As Recordset Dim connectstring As String connectstring = "ODBC;DSN=<datasource name>;UID=<username>;_...

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

This is the first error that comes up folks: [microsoft][odbc microsoft access driver] too few parameters.Expected 1.

thanks for your replies. I do have an odbc connection to the tables. I believe the problem is with the pivot table in excel, it gets the data from c:\work\drb.mdb I manually run the queries and they all run fine. The data source did not change.

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

Sorry Guys, I will post it in the correct forum.

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 don't know what's wrong but when I have this code, the secondary form does not show any fields : DoCmd.OpenForm "additional Victim", , , "[case number]=forms!client!casenumber and victim=2 and [accepted services date]=forms!client!acceptedservicesdate" When I have it without the accepted...

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

thanks for your quick reply, I'll try it.

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

did that, I'm still getting the the year portion wrong. seems like it is only looking at the month portion of the data.................. thanks for your response.

Have a date field with data type as &quot;text&quot;, 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 &quot;name&quot; 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!