Recent content by red7

Great, thanks for your help SJ :)

Hi, I have the code to ensure that if a purchase is made whereby the amount required exceeds the number in stock, then an error message appears to tell the user. The following code presents the error message and also deletes the purchase that the user has just attempted: Private Sub...

I've sorted it, thanks anyway

Brilliant, thanks a million :)

I have the following code for a command button to open a report showing the current record in the form the user is viewing: Private Sub Command39_Click() 'Filter report to display only Member currently showing on frmmembers ' (by MemberID field) DoCmd.OpenReport...

Hi, I have based a form on a parameter query, so that when the user is prompted to enter a 'Hobby' to search on, the relevant records will be displayed on the form. Now, I have created a command button designed to open a template letter in MS Word for a particular hobby. The problem is, I need...

Hi, I have based a form on a parameter query, so that when the user is prompted to enter a 'Hobby' to search on, the relevant records will be displayed on the form. Now, I have created a command button designed to open a template letter in MS Word for a particular hobby. The problem is, I...

HI, I need a macro to run once a 'confirm' button is pressed in one of my forms. I need the macro to send the current record I have added in my form to a table, which will store all of the day's takings. I have been unable to find a macro that updates a table with a whole record. Please help...

Thanks for your help Wayne, how do I go about switching it to 'no,' or indeed just finding out if it is on 'YES'?

I have two tables: tblMembers: MemberID (Primary Key) Title Forename Surname etc... tblGymAttendance: Attendance ID (Primary Key) Member ID (Linked to MemberID in tblMembers) Forename Surname etc... How do I get the Forename and Surname fields in 'tblGymAttendance,' to be dependant on the...

In 'Design View' of the Report you can drag down the Page footer to make the 'Detail' section larger, it spreads them out further so you can get it to one per page :)

Apologies if the answers are very simple, I'm a wee bit of an Access newbie! I have created a form with which I am going to record gym attendances for my members in my members table. When I do this it will update a table 'gymattendance' which stores the information about price paid, date...

Sorted. Thank you :)

So would creating an 'Interests' table sort it? Pardon my ignorance :(

Hey, I have three fields: Interests1, Interests2, Interests3. I need to somehow set up a query whereby I can search if certain criteria is present in ANY of those fields. I only know how to search if 'football' for example is present in ALL of the fields, or a specific field i.e...