Search results

Hi all, I currently have a button on a form which, when clicked, I would like to do several things: 1) Check if the folder, "folder name (1)" exists 2) If no, make it; if yes, check if the folder, "folder name (2)" exists 3) If no, make it; if yes, check if the folder, "folder name (3)" exists...

Hi all, I have a combo box in which I wish to show the Person_ID's of every record in the table TBL_Person, except those which are returned by a separate query. Is this possible at all?? TIA

Hi All, I have a report in my database with a button called "MailMerge". My aim is that when clicked, this will open a word document, that has already been created, but automatically complete the merge based on the data in a table. The catches: 1) I need to be able to ask the user the content...

Fantastic, I knew it would be simple for someone; just not me!

Hi all, I'm sure this is on the web somewhere, but I just can't seem to find it! I currently have a simple piece of code: Private Sub PDF_Click() DoCmd.OutputTo acOutputReport, , ".pdf", , -1, , 0, acExportQualityPrint End Sub My problem is that when the save as dialogue appears, if the user...

Brilliant! Thank you both!

Hi all, I have a table, "TBL_Email", which simply contains a list of email addresses in a field called "email". I would like to concatenate all of them together into one string, and add semi-colons to the end e.g. "123@abc.com;456@def.com;789@hij.com" I believe a may need a record set, but...

OK. I'll try that. I think I have another way around it, because I've come up with further complications now. Thanks anyway though!

Hi all, I have a parameter query that contains information on a list of people and contains 3 checkboxes: alumni, parent, business In this query, I am trying to use parameters to filter the results based on these three fields i.e. true, false, true would return all records where either...

Thank you! Worked a treat.

Hi all, Currently I have a query, QRY_Test which contains a load of records under the fields "Gift_ID" and "Person_ID". I have another query, QRY_PersonList in which I would like to show all of the "Person_ID"s except the ones returned by QRY_Test. I hope this is a really simple fix but I just...