Search results

I have 3 tables which have one-to-many relationships. A Supplier table with general details. A Supplier Log table with meeting details and a Supplier booking table with any events we have booked with them. I am trying to put these into one form where each tables data appears on a seperate...

I am trying to loop through one query (qryMailingList) and using the value in field UserID. I am using this value in my criteria in another query (qryExceptions field:Opportunity Primary Login). If qryExeptions has records in it, I want to email this to the user using the email address in the...

I am a beginner to VB in Access 97. I have a query called qryMailing List which is a list of all users and their email addresses. Also a query called qryExceptions which is is a query with certain conditions applied to it. I would like the code to open qryMailingList and go to the first user...

I have a query called qryExceptions which holds records off all errors within a table. This has to be mailed out to the person who submitted that record. From this query, I have created another query which looks up the users from qryExceptions and exracts their email address. This query is...

I have a report which details products on certain order numbers - So each order number could appear many times if it has many products. I want to count how many distinct order numbers there are in total (not how many records appear on my report) Am I making myself clear???? Can you please help...

I have a main form with all my records in it, and I want to create another form where I can enter the criteria in just one field (the reference ID) and click on search and it will open up my main form with the relevant record. How can I do this without writing any code? Any help would be much...