Search results

All 16 databases are identical, just different data in them so the code will be identical too. I am sure last year we made changes to one database then transferred it across to the others I just cant remember how we did it and the girl who wrote the database has left.

Is it possible to copy a command button from one database to another with the same code attached? I have 16 versions of the same database, one for each service, and I have made several amendments to one of them. I obviously need to make the updates to all databases and wondered if there's an...

Thanks for that Alan, looks like it is just what I need.

I have tried searching for this but don't seem to be able to find anything that actually relates. I have a simple mailing list which has customer names & addresses and activities we will be mailing out about. There is a form for customer details with a subform for the maillists they wish to be...

Thanks, will have a go.

Thanks for that Rabbie, I think most of it makes sense! I need my customer table and my interest table and basically have a seperate table with customer reference and interest refernce in it so each customer has any amount of interests Is that about right? How does this affect data entry...

Would this still allow a customer to have more than one interest in the database? i.e. be on the mailing list for Christmas mailshots, easter mailshots and historic mailshots

I have a mailing list database with three fields for interested in and want to be able to list anyone who is intrested in say Easter activities for a mailshot. This could have been input in any of the three fields. I can do this by running a parameter query with three different inputs, one for...

I have a database which records project details such as location, date, size etc and also the service area working on the project. This can be up to three different area on each project. I have three tables with the same area names in with three flds on my main form linked to them. I need to...

Is it possible to put a page break into a report only when a record splits over two pages? I have tried using an event procedure to force the break but can't seem to get it right. Had a year off and my brain seems to have gone mushy! Thanks in advance

Hi, I am in the process of creating a timesheet for the office. So far I have a form with drop down lists to populate Officer name, Project, client and then manually type in the date and time spent on the project. I am working on using a pop up calendar to enter the date and have several...

I am trying to use a calendar to fill the date box on a simple form, I have used the examples from various threads on here but I cannot get the calendar to pop up. The error message I get is Run Time Error 2110 Microsoft Access cant move the focus to the control activeXCt161 Any thoughts...

Hi everyone, I've just started using Access 97 and am trying to create a command button to open a new record when you click it. I've used the wizard but get an error message everytime I try it Ambiguous name detected: Add_ New_Record_Click Does anyone know how I can get round this doing it...