Search results

Is it possible to filter a forms records by using a boolean True/False field. I want to show all current records for option 1, Expired records for option 2, and all records for option 3. The form is based on 'tblMembers' which has a field [Expired] which is a boolean yes/no field formatted to...

Thank you that’s what I thought but the (unbound)check box is greyed out. I wish I had made the function but I didn’t .I thought I understood it until I couldn’t get it to work which made me think I wasn’t putting in the correct values. If I check the box on a members payment as expired then all...

I have an unbound check box on a form and I want to set the value of the check box to the return value of the function in the parent fors Current event procedure i.e. the relevant values into the function to 'check the box ' if a fee is due. Exactly what part of the function is the return value...

I thought I had just about finished my DB but now Ive printed out and checked my reports I notice I have several records in different types of reports showing duplicate records. Iv'e gone back over the queries and there are one or two duplicates in several of my queries that I did not notice...

NewQueries tried again from unmatched Query wizard Trying to find New Members using unmatched query wizard: - LastYearQ (Returns 267 Records) SELECT DISTINCT S_Members_Table.MemberID, S_Members_Type.MemberTypeID, S_Members_Type.Type, S_Members_Type.MemberDues, S_Members_Table.FirstName...

Too much SQL so attachment:- There is a lot of SQL to post so am adding an attachment with it in. At least I haven't used this facility in the forum before so hopefully it will work OK for me - if not will have to re-post!

I have several queries to find expired members, current members etc, however I can't get new members this year. Iv'e tried the unmatched query wizard using these two queries, also several other queries and tables but I either end up with all records or none. I'm going round in circles. I don't...

Yes it works and does exactly what I want- brilliant.

Thanks a million EMP --yes that is what I want, will try it asap but it looks similar to code I already have for Current records which I tried modifying but couldn't get quite right! It was getting the correct 'minus' number in each case I couldn't get right. Thanks a million, hope it works...

This is the SQL I have for the Query after adding your statements: SELECT tblMembers.MemberID, tblMembers.FirstName, tblMembers.LastName, tblMembers.Address, tblMembers.PostCode, tblPayments.PaymentAmount, tblPayments.PaymentDate FROM tblMembers INNER JOIN tblPayments ON tblMembers.MemberID =...

How? Um ..OK sorry to be so dumb but how do I use it - Do I type it into the text box?

Iv'e looked through several date functions but cant figure out which one to use or how. I want to produce all records for a period of 1 year, for 1 year ago. i.e if I run the query during any month of the 'current year' (obvously) if its after August it will show me the previous year of August...

Is up to date. Thanks for the tip Rod will check it out. Rural Guy - I had megga problems with my database back two -three months ago. I was using a memory stick to transfer the DB from one laptop to another then once I tried to use my first function and Macros the DB kept getting corrupt...

Working Code is finally working. I went over it all deleted all pieces of code I had tried and had commented out then reinserted this into Payment Form. Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.PaymentAmount) Then MsgBox "Payment Amount is a required field", vbCritical...

Will try again but Sorry John -I did check your forms while they are read only I can't check to see if they work because I can't add another record however I did check the code behind the forms and that is exactly what I have done. Both ways- however I did put it onto the Main form that...

Sorry still cant get it working tried it both ways but am getting a compile error now method or data member not found. I have rechecked my field and it is definitely called PaymentAmount. I am entering this on the Before update event of the main form -should this be on the SubForm 'PaymentForm'...

Have download will try Thanks -I have downloaded the zip file will try both methods, thanks again.

Dwight. (Pat Hartman) recommendation. Put it on the BeforeUpdate event If IsNull(Me.txtPaymentAmount) Then MsgBox "Payment Amount is a required field", vbCritical, "Field required " Cancel = True Me.txtPaymentAmount.SetFocus Exit Sub End If This gives Access message box : The field tblPayments...

thanks All Thanks for all the responses, will try them to see results.

How? OK So exactly what validation code should I put in the BeforeUpdate event? I dont know VB code and so far have used mainly SQL? Is this where I put a message box. If the underlying record doesnt change then will it affect the working of the code?