Search results

I dont record the members info in the 'payments' table becasue the 'payments' table come straight from the bank so I cant change the format. All ive done is relate the bankdescription field which is the same for every member to the Description in the membership form. As far as the...

Hi, Ive got a small problem in a form on my database. I have a main form called 'Members' which stores details of all our members. With in this form I also have a subform named 'Payments'. There is a relationship between the forms Membership>Description and Payments>BankDescription as one to...

Hi, I found the problem, there was some duff data in the R fields. some fool put RO6 instread of R06! Cant get the staff!!! Cheers for your help guys! Phill

MStef, This is not the first record under R. I am currently up to R06049 so the next record should be R06050. Col, Well spotted, the example is correct, there should be 3 letters after the date so B06002 would be correct. I cant use 4 digits after the date as the membership number formats is...

Hi! Ive been using the code above for the last week or so and its worked great unitl I came to input a new member this morning. The problem arises when I try to add a member whos name begins with 'R'. Ive tried most of the other letters and they seem to work but R throw up a Run-time error...

cheers mate. does exactly what I wanted. Phill

Hi, Im putting together a membership data base. the data base has an already existing client base which all have membership numbers in the form of first letter of there sir name, last to numbers of the year and a 4 digit number. So for example Joe Bloggs membership number would be B06001 his...

Hi, Thanks for the reply, Ive had a go with this part of the query above and Im not understanding it to well. I dont have a LastPayDate from the members table? What am I doing wrong?? Phill

I have attached a snap shot of the members form so hopefully this will be a little clearer. Phill

Thanks for the replies. ok I should explain a little about the download20060602 table. this table is an imported table that the boss gives me every month as a spread sheet from the bank so the fields and data in that table i cant really change. on my members form I have a subform of the...

went to a halloween party last year, I went as the increadible hulk, great fun, very much so when walking through the town centre painted head to foot in greet face paint! And it ttok about 5 days to get it off! so why dont you do super heros?

Hi, Ive come up against a brick wall once again in my database so once again here we go. I have my main from Members which contains a field traffstatus, this field will be filled in with either Green, Amber or Red. Green is some one who is up to date with there payments, Amber is someone who...

I did some more searching and found the answer to question so ignore this one! Cheers Phill

Hi, Ive never used the security in access before but I have designed my database and have used the security wizard to set my security. it has now put a shortcut on my desktop which is now used to open the database. The problem is that now I need the database to be opened from other computers...

Thanks for the reply. The query you wrote is kinda what I want but I still need to be able to put the dates in myself rather than just bringing up everything. I'll try to explane, I want the query to show me the payments that have not been made (so null date) between a specific date. So the...

Hi, This query will allow me to view payments that are made between 2 dates. I would like to know how to flip the query around so that it gives me the payments that have not been made. I think this would be described as returning the null values? The SQL code i have at the momnet is: SELECT...

That works great but I can only place bitmaps into the picture box. is there a way to put a jpg in there?

Hi, Ive got another query I need to do which I just dont know where to start from. I have two tables, membersdata and bankdata. These tables are linked in a relationship thou the field 'description' in both tables. What I want to do is be able to input a date and have the fields I require...

Hi, Can any one tell me how to create a query that will allow me to view data between two dates. For example I need to see payments between 01/06/06 and 12/06/06. I would like it to come up with an input box also so the user can input the dates in with out editing the query. Any help would be...

Works a treat! Cheers mate, your a genius!