Recent content by krc777

Finally figured this out and thought I would post in case anyone else runs across this problem. The fix was in shortening the SELECT statements. Access had set the query selects by using each tablename.fieldname. When I shortened the SELECT to SELECT * from table it worked just fine for...

You could bring the file in and then in the next line change the first field name to what you want using: ALTER TABLE table_name RENAME COLUMN old_name to new_name;

I did find this. (http://gis.esri.com/library/userconf/proc01/professional/papers/pap417/p417.htm) In the DDE architecture, the ArcView application and the Visual Basic application exist as two separate processes on the client system; DDE provides the means for passing data back and forth...

I can't get a response from the field today but I have attached my screen shot and when I had them read theirs to me yesterday it was the same except the Ms Access 10.0 Object Library was Ms Access 9.0 Object Library.

How do I attach a bitmap here?

They never see the version 10 to uncheck. I'm sorry if I'm not understanding this. Thanks for your help.

I thought I would try to use the 9 here based on Bob's answer but when I try and uncheck 10 I get a "Can't remove a control or reference in use" message.

They have the 9 version and I have the 10. We have tried sending them the MSACC.OLB and they are saving it in the C:\Program Files\Microsoft Office\Office10 folder but it doesn't appear in the list after we have browsed to find it. Should we uncheck the 9? Is that causing a problem?

They can get to the form (main menu) and some of the buttons work to open other forms and some buttons when clicked return a 2580 error. I'm sorry I don't have the text for the error only that it reference a SELECT statement using a reserved word... The app works fine in my office for the few...

I created an app that used the 10.0 library and a field office that recieved the app is using the 9 library. They are having difficuties getting buttons on forms to work. They are getting a 2580 error something about the SELECT statement. Could the library be the problem and if so is there...

So I did some searches and came up with 'perhaps the leading character is not a space, in which case TRIM would not work. I placed this in my code mplan = LTrim(rst.Fields("Service Bureau ID")) Asc (Left(mplan, 1)) -- this was a 48 (in the lookup table a 0) The situation is that the mplan...

Yes. The deliv table's proj_no is a long integer and not a primary key. If I'm understanding this correctly "You have to set up the Master / Subform links properly and have the linked field in both the main form recordsource and subform recordsource." In the source object for the subform the...

The relationship between the Main table and Deliv table is set to the primary key in Main (proj_No) and then to Proj_no in the linked (Deliv) table. The cascade is set on to both add and delete. In the form the Main form and sub link correctly but when I try to add a new record the subform...

I have a MAIN table with autonumbering for the project number. In a table related to the MAIN table I have a project number that I want to be updated when the MAIN table has a new project entered. Can I keep these in sinc automatically?

Sorry! should have searched here. Found it. :eek: