Recent content by Dukelewis

I have a form with an attached subform. The subform is in datasheet view and is used for data entry. The input screen in the subform has 18 necessary fields. The problem is that after the user tabs to the 10th field the fields are no longer visible unless the user leaves the keyboard to...

Thanks for the advice! I'll try both suggestions and see what happens.

I am attempting to use an append query to append data to a table in another database. The database is in another folder on my network. The problem is that Access automatically assumes which folder I'm attempting to append to. For instance, the table I want to append to is located in...

I have a nasty message that pops up on a union query I run. It states, "System Resources Exceeded". Until today I never encountered this message. The only changes I've made today is adding one column to each of the two union queries that feed into this one. I don't even include this column...

Thanks for the help. I sniffed out the errant code.

I am organizing and renaming tables and queries in a database. My queries automatically update the new table and query names when I view them in Design mode. However, when I click on Datasheet view it asks for parameters from tables I have renamed. I looked at the parameter dialog box under...

Twenty-five fields total.

I am building a query based upon another query. I also use calculations based upon earlier fields listed in the query. Whenever I am half to three-quarters completed the fields already created in the query disappear from the expression builder. I then cannot properly build any more...

I have a complex PivotTable form that has worked well for months. Monday, however, I received the following message, "A problem occurred while MS Access was communicating w/the OLE server or ActiveX Control. Close OLE server and restart Access. Then try the original operation again in Access."...

Thanks for the help. Your procedure works great!

I need an import macro that could import an Excel file as an Access table. The macro needs to specify the top row as a header and be able to name a primary key column. Any help on this would be greatly appreciated. Thanks! [This message has been edited by Dukelewis (edited 11-17-2000).]