Search results

I have a button on form Membership with ID [Membership_No] and trying to open "frm_gmem" with ID [GMembership_No] at the current record. The preceeding If msg works as expected but if false brings up Enter Parameter Value prompt for GMembership_No Left blank or given an ID number, it still...

I have a strange problem with date format. The problem is that dates for day 01-12 are converted to mm/dd/yyyy on saving. Whiles dates for day 13-31 are saved in the correct format. There is a subform that allows updates to the main form. The date field on both forms has the Format specified...

I have a table OwnershipLog including fields Membership_No and [Current Owner] and want to retrieve [Current Owner] using open form field X_MemNo This Code: If DCount("[Current Owner]", "OwnershipLog", "Membership_No = " & Me!X_MemNo & " ") > 0 Then MsgBox ("This Member is...

I have a table MembershipList, containg the field PostCode and a form with field Code (contain AA or A). This code works: WHERE (((MembershipList.PostCode) Like ([Forms]![frm_membcode]![Code] & "*")) but returns all possible A# and AA codes. I have found suggested code using: LEFT(my_field, 2)...

I total novice at VBA I am trying to code a button to modify (the last) record in a subform list and then add a new record based on values in unrelated or unbound fields on the button form. The following code is based on the first of two YouTube tutorials (this bit on the edit) and looks like...

I am trying to set a criteria field to look for >#01/09/[current year]# but every combination of Date() returns invalid value. Any clues?