Search results

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:

I did a google search on this but didn't hit on the answer. I want to prevent users from using an old access application form by placing a password on the form load. Thanks.

Not sure if this is helpful but I use: set rst = db.openrecordset ("SELECT...") and it always works fine. Would that work for you?

Did check the references and they are the same. ugh

I checked the printer selection on the field office printer, and ours, and they are set to default. The runtime error has the end and debug buttons and when the debug was selected it highlighted the line I mentioned. Would that be true as well for a wrong printer selection?

Great advice. I always do searching in FAQs, google etc...before bothering help blogs but hardly ever mention it in a post. Thanks for the heads up.