Search results

sorted needed a 0 instead of the "no"

hmmm so its trying to update my CDNumber field to "no" yes? which it cant do because thats an autonumber

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

nope

ive found this acCmdFilterByForm. is that what i want? i cant get it to work though :(

do you have any idea how i would go about that?

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 :)

basically my projects a video rental shop with CDs. you have have details on members and cds in two tables. loans of CDs that are yet to be returned are in the tblLoans and when they are returned they are moved into the archive. the fines in tblfines are the outstanding ones and the fines that...

oooo nice one, where do i put that? into a module?

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