Search results

I have always used the File, Import data commad, to import to access from excel. You can import to an existing table or create a new table this way, and then run an append query to add to an existing table if you need to. The thing with importing is to be sure the field types are the same and...

I am trying to add an appointment scheduling feature to my access application, where I can draw off my contacts table to book appointments. I am trying to develop the base table to allow for appt types, calander days, slots, etc... and it seems pretty involved once you get into it. Does anyone...

I have several forms I have created that contain subforms. I would like to print the current form and only have it print the subform record I am viewing. I have tried to use most of the print commands, and they all result in multiple subform records printing out. I only want the general form...

Hkbana It sounds as if one of the fields on your form uses an expression to draw in data from a base table, perhaps a lookup field. This error can sometimes occur if you changed any table names or field names in the base table that that expression is referring to. I would look at the form in...

Thanks ! Pat, Thanks, That was very helpful. Chris D:)

Upgrade Rich, My thought is that once I package & deploy the application, I will probably add new functionality to it over time and then repackage a new application (with no data). I woul dthen need to import the table data that a user has been building on the old application. With Many of...

Back-up Jen, I would definately create a macro that performs a full back-up of your database to a separate directory on the same computer or a different computer on the LAN in that office. Select the "copy database file" from the macro options, and then list the destination directory file...

I have created a application with a "customer" type table that has an account # field that is auto-number field type. This is the field I used to link to all other tables. I am concerned that I may not be able to restore data to a new customer table when I upgrade the application due to the...