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...

Sorry, I probably don't explain myself very well. I have a qry called qryExceptions which filters out data which has certain criteria i.e. no order date, or status between 1-4 etc. I want to mail these Exceptions to each individual user to let them know what Exceptions they have. I then have...

Alex - Thanks for this............ That solved the problem with the empty recordset, but I seem to be doing something wrong as my qryExceptions doesn't open with any records. Is this line correct.... MyUser = MailRS("User ID") MailRS is my query qryMailingList and the field User ID is the...

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...

Thanks again Harry. I am also getting an error on this line - do I need this? Set ExcRS = CurrentDb.OpenRecordset("qryExceptions", dbOpenDynaset) I am trying to make a reference to my user field in qryExceptions which is "Opportunity Primary Login" I have done this with MyExc Do I need to...

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...

Thanks for this Harry. If I filtered on user who wasn't included in the qryExceptions and the query came up blank, how can I skip to the next user in qryMailingList? i.e. If qryExceptions is null then......... Also, how do I save the qryExceptions output as an Excel or Text File? (Sorry...

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 still can't seem to do it. I want the total to appear in my report header. I am quite a novice at this so I may need step by step instructions.

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...

Thankyou

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...