Search results for query: *

I solved the problem. Refreshing the tabledefs in the loop keeps the problem from occuring.

Here's the situation - I am looping through the tabledefs in a database and re-linking tables. I have 2 ODBC linked tables in the database. The "For each td in database.tabledefs" loop is only showing me the 1st ODBC table. Just for grins, I linked another ODBC table in and guess what? I get...

I have a query written in Access 2003 that uses a custom function (VBA). Another developer in the organization is trying to execute the query from VB .NET (using ADO .NET). ADO .NET doesn't know what to do with the custom function. We don't want to copy the custom function in VB .NET...

I have a query written in Access 2003 that uses a custom function (VBA). Another developer in the organization is trying to execute the query from VB .NET (using ADO .NET). ADO .NET doesn't know what to do with the custom function. We don't want to copy the custom function in VB .NET...

Boxhead, I rarely respond with 'Fine'. The people I say it to, they know me so it's a bit of a joke. I'm the kind of person that likes to shake the tree and see what falls out.

Sometimes, when people ask how I am, I like to respond with 'Unarmed'.

As a developer, I find it difficult to do my programming work unless I have headphones on to shut out the noise of a work environment. I do my utmost to remove them quickly when someone needs to speak with me. Phil

Stella, you are correct. However, the calls that I receive are not from businesses that I have a relationship with.

Check out this site for the some useful information... http://www.stoptelemarketing.org/ I am going to start recording the calls I get from telemarketers so I can take them to small claims court. They almost always violate the law. Phil5673

Mufasa, that's the best one I have heard yet. I am going to use that on the next TMKR that calls me.

MichaelRed, Thanks for the response. No autonumber field on the table that I am updating. The primary key for the table is a SSN field.

Ken, Thanks for the response. I am using record-level locking. Since every copy of the front-end is limited to a different region, and no employee can be in two regions at the same time, no two front ends should be attempting to edit the same record. On the .addnew/.edit issue, are you...

I have an Access 2003 database that I have split into front/back ends. The front end is copied down to the users' hard drive, so everyone has their own copy. In the front end, I have a VBA function that updates a table on the backend. The backend table that I am updating has year-to-date...

Thanks for the help. The code that edsuk presented worked. Phil

I have looked through my books and on this forum but I cannot seem to locate the code to open an excel file and enable the macros contained in it. I do not want to run the macros from excel, just enable them. Can someone share some knowledge with me. Thanks. Phil Edwards

Yes. I have already checked that option. I get this message regardless of sufficient privileges. Phil

I have the following code to transfer a table to a text file. I am getting an error message "Database or object is read only." I am not sure what could be causing this. The database is not read only and the table is not read only. Any feedback is appreciated. strPath = strFolderName &...

That works. Thanks. Phil

I have the following code used to select a "save to" location. Set fDlg = Application.FileDialog(msoFileDialogFolderPicker) With fDlg .AllowMultiSelect = False .Title = "Select folder to save export to." .Filters.Clear If .Show = False Then...

Thanks. I am still learning SQL Server. I appreciate your help very much. Phil Edwards