Search results

I think Ive done it!! Its a miracle!! :D Ok so the query I have made to show all the none payers between a date goes as follows, Ive made a query with the Payments table and the Paydates query with a join between the bank description on table and query. From there i put the Is Null criteria...

ooooooh I get it now! Must have been that full nights sleep that i had last night! I see now why it doesnt work since there is nothing there for the Is Null to give back. Cheers ajetrumpet. Still no idea how to make it work though :)

Sorry about that! Nothing but trouble that security! Ive done what Mircosoft advise to remove all security and it seems to work so Ive attched the database minus the fortknox level security! Phill

hi everyone! Ive been away the last few days so I havent had chance to reply to you. I have had a go at the suggestiopns you have posted but with no luck. I still cant get anything out of it so Ive attached the database so if you have a few minutes you can have a look and if your feeling...

How?? Im not sure what tables or queries I should have in this query?? If you could tell what needs to go into the query, if I need the other query I made to show the people who have paid in the month first etc it would be great. Sorry for being crap at this! Thanks for all the replies! Phill

Hello again, I understand what you mean here but I cant find this unmatched thing on my wizard? And Im not sure of what I should be putting on the criteria. I'll take a step back and describe the database a little more. Its a members database which for this part has 3 tables: Members...

Sorry Im getting a little messed up. The purpose of this query is to pick out poeple who have not sent a payment to us. So if I put in a date range 01/01/2007 to 31/01/2007 then the query will return to me any refernces with no payments between this date. Will the Not Between criteria do...

Hi, I have a problem with my query. I have a table which has a record of payments, the fields are id/datepaid/reference/amount My first query works fine. its simply to find the payments between two dates. The criteria is Between [Enter Start Date] And [Enter End Date] which is under...

Bob your a legend!! Cheers!

Last bump if any one can help?

No problem bob. Your replies are greatly appreciated! Thanks again Phill

Bump! Help if you can?

One workgroup file! Yeah I didnt actually mean to put security on the database, I was just playing around with it and kinda got carried away! Cheers for the reply!

Hi, Thanks for the quick reply. Ive attached the database, please excuse the mess but its still very much a work in progress. It has passwords on it, starting password is Username:owner password:swissball and the VB password is water. Thanks for having a look I really appricate it. Phill

Hi, Thanks for the quick replies but my problem is still here. Im not suret he code is exactly correct, this is what Ive got so far, Private Sub Form_AfterUpdate() CallDisplayImage Forms!members.Requery End Sub Private Sub openpayments_Click() On Error GoTo...

I did this but it comes up with a 'Method or data member not found' for the Me.MemberIDTextBox part of code. Should I have a MemberId text box on the form? This field is an Autonumber. Also do I need to keep the Relationship? Entering the information does save the information in the table...

Hi everyone, This is so simple but I cant get it to work for some reason so I'm probably over looking something really stupid. Ive got two forms, one 'Members' and one 'Paymentdetails'. On the members form I have a button which when pressed should bring up that members payment details. This...

This is essentially the same problem as Im having. Trying to populate one subform using information from to seperate fields. I have found the same problem also when I take one field out of the problem it works fine but when using two it doesnt work what so ever. Lets have some help on this...

Ive attched a picture of the database screen as it might help with description which was pretty hopeless to be fair. In the top right corner we have the description which is typed into the main members form which then shows all the records in the subform. All that data in the subform is...

Anyone else know how I can achieve this result? I am finding myself going around in circles at the moment. I have tried linking the two fileds under the linking master and child fields under the properties of the subform but to no avail. Any help would be fantastic as Im loosing my hair...