Recent content by vaughan198

Hi there I am using a simple code to append three excel worksheets (in the same workbook) to three tables in my database. There are multiple records per table/per import. Is there any way to apply a unique ID to all the records in each import. I.e all the records I import today have an Import ID...

Hi there I am having the following problem. I have a database where every day I import a report into three tables (unverified, unallcoated and TMQ). I have three queries that return the most recent records by running another query first to get the most recent report date. When I run the...

Many thanks, that worked perfectly. Now that I have the three queries is it possible to export them to three different tabs of the same (new) excel workbook?

Hi there, Every day I import an excel report so I have lots of records for each day that have the same report date. I need to create a query that finds the most recent report/date and pulls in all the recors for that date. I need to do this for three different tables Then export these three...

DataMinerHome. That would do the trick I think, Having trouble actually putting it in with the rest of my code. I understand this is a function. Are you (or anyone) able to help?

Hi there. Any help with this would be hugely appreciated. I have an unbound form (for many reasons). I have a button which imports all the fileds on the form into a new record in a table (NewAccounts). This all works fine until I try to include a multi-select list box and then the whole...

Sorry sorry. I think you have completely misunderstood me. Let me start from the top: I have a form that has a listbox which has its row source as the table "Products". The user saves the record into a table ("New Account") along with other values. It saves the text string of the list...

I dont think that is quite it. I have a listbox that has multiple values (each have a checkbox next to them). When the form loads the listbox brings up a list of seven options (none of them are selected). I want the code to select the desired records from the query when the vba code is run (but...

HI there, I can't do that becuase when it first loads I dont want it to pull in any results but when the vba code runs I want it to pull in the results from the query

Hi there, I have a question. I have nearly completed a database and I know that perhaps the design of it may have not been ideal but I can't really change it at this stage! I have a query that returns the most recent record for that user. I need a peice of vba code that looks up a field in the...

Perferto! Thanks

Hi there I am trying to get my access form to send a report and have the subject of the email be a field from a query (or report - it is the same). I have the following code DoCmd.SendObject acSendReport, "New Accounts Request", acFormatPDF, "email@email.com", , , "New Account Request for: " &...

anyone got any more ideas about this. Any help hugely appreciated.

OK here is the sql code

Hi there. I have a continuous form that pulls in records from a query depending on the selected user. It does this by having the user field in the query criteria. If I wanted to give users the option of also filtering by client (and ignoring the user filter) how would I go about that (I want to...