Search results

I have a membership database with over 1700 records held in it, I want to print a membership card for each member each year here is my problem: I want to print a selection of records i.e. abc, def etc. I want to mark records that have had the card printed for this year. I want to be able to...

I am trying to delete records from a temp table using the following code. CurrentDb().Execute "Delete * From tbl_temp_bank_statement Where [Original_Member_Number]= '" & Me![ListBoxGarther] & "'" This does not work I get the following error. Data type mismatch in criteria expression. (Error...

I have a form with two list boxes in it. When a user double clicks a name in the left hand list box, that name is then place in the right hand box. I am trying to allow the user to remove that name if a mistake has been made. The code I am using is below. Private Sub...

I have a form with a combo box that list membership numbers, once a user has selected a member details are displayed. Once the user has updated the record I would like to reset the combo box back to null. How do I do this? :confused:

John, Why the inner join and the query. this is not based on a query? Below is the complete code: Dim stDocName As String Dim stOption As String Dim chkOption As Boolean Dim ssql As String Dim sdSql As Date chkOption = False stDocName = "rpt_membership_card"...

I formatted the date because it did not work? The date format is short date. If I use the WHERE membership_card_date Is Null, how do I place the stOption on this?

I am trying to update a table after a form is printed for members of a club. The Table I am trying to update has two fields, 1 is membership card printed, and is a yes/no field. The other is membership card printed date, which is a date field. I have a criteria that I have set to stOption...