Search results

Hi all, I have two tables, TBL_Students and TBL_Email. Each of these tables have a field called Category, which allows multiple values from a list. Is there a way to return records from TBL_Students where at least one value in TBL_Students!Category = at least one value in TBL_Email!Category...

Hi all, I have a primary field in my table called Membership_Number. This is a Long Integer data type. Is there any reason that anything more than 10 characters is being rejected under run time error '-2147352567 (800200009)' The value you entered for this field is invalid TIA

Hi all, I need an iif statement in my query criteria that works as follows: iif([Field] = "FirstPossible","str1",iif [Field] = "SecondPossible","str2",*) The problem is, I'm not sure how to display all of the records if neither the first iif or second iif returns true. Any ideas?? TIA

Hi all, This is driving me mad! I currently have a report in my database which, when opened, should maximize. Private Sub Report_Open(Cancel As Integer) 'Maximise the window DoCmd.Maximize End Sub Every time this runs, my report looks like picture123.png To actually view the data I have to...

Hi all, I have the following code: Private Sub Membership_Number_AfterUpdate() Dim SQL As String SQL = "INSERT INTO TBL_MemberLeagues ( League_ID, Member_ID, Registered )" & Chr(10) & _ "SELECT TBL_League.League_ID, TBL_Members.Membership_Number, False AS Expr1" & Chr(10) & _ "FROM...

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

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

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

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

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