Search results

UPDATE tblCDDetails SET tblCDDetails.Available = "No" WHERE (((tblCDDetails.CDNumber)=[forms]![frmLoanCD]![CDNumber])); is what ive got, yet i get some type conversion error. basically i want it change the availability of the CD to "No" (its a yes/no field) by searching for the CDNumber and i...

ive tried looking for past threads and i cant find anything so here it goes: i cant find the filter by form code in the list of properties. theres filter and filteron commands but i want to be able to open filter by form via a button and onload. any help appreciated :)

i have three forms which i want to collect from lots of data from. the four sources are: [forms]![frmLoanmember]![MemberID] [forms]![frmLoanCD]![CDNumber] [forms]![frmLoan]![ReturnByDate] [forms]![frmLoan]![LoanDate] thats in my criteria. all the data needs to be taken to tblLoans in the field...

i need to produce a random 4-digit number that cant be the same as any other in that record. now i tried to use the autonumber function in access and put to restrict it to four digits with the use of input masks/formatting but it didnt like it. am i looking at vb code? or is there another way...