Search results

Thanks Roy. I can see that I need to learn a lot more about this! Thanks again for your assistance. Peter

Hi Roy Sorry to be a pain, but I'm beginning to feel a bit dense!!!!! I have the default save record button on the subform, which I constructed using the command button icon on the form builder tools. When I go into the properties for that button and click on the "3 button" icon for the "on...

Sorry about the delayed response, I've been ill. Anyway I tried putting the code in the OnClick Event of my Erase button in the subform and got the message "Microsoft Office cannot find the macro ME" What am I doing wrong? Thanks again. Peter

Hi Roy I'm not sure how to do this. Can you advise further. Thanks. Regards Peter

I have a form which contains one subform. On the subform I have a command button which saves the record just entered. On the main form I have a "refresh form data" button which updates the main form so that the calculated controls can show the correct results based on the data just entered...

Reports / query by user from drop down menu Thanks for this. Can you explain further or point me in the direction of an example on how to pass the parameter? I'm relatively new to access and although I can build the forms ok, I haven't mastered this yet. Many thanks. Peter

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for. How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory...

Hi Ken thanks for this, it sounds like what I want. I'm fairly new to access, can you explain this further. What is the pk of a record and how could I use it to collect the data? Peter

I have a course booking form comprising of a main form which holds the person details, and a sub form which holds the details of each course they book. I want to be able to produce a report/ letter from the current form (ie once a person have booked a course) confirming that the course has...

Calculated controls. Hi Ian, thanks for your suggestion. I'm new to access and don't fully understand your suggestion. Did you mean me to modify the course booking table so that I only tracked total cost. If so, that is not an option open to me. The person I am helping, asked for these to...

I have a main form which shows customer personal details including their budget and a subform which shows the costs for each course they book. The sub form has 4 boxes which I use to capture course fee, travel fees,subsistance and other expenses (along with other details such as course code...