Recent content by JWilson

Label Have you looked at the timer option to set a timelimit for the label??? Have a look it might just work for you :)

How can i achieve the following: From two tables, 1 by the name of invoices and 1 by the name of payments. I want to show on a single form line by line the following. Date |Payee/Payer| Ref (either chq/Invoice No|Net |Vat|Gross |Type 01/03/04 Me 101010...

my sincere apologies when you say you dont in ms access does that mean you cant? (create a table with with a roll on of seven days based on a given date) :rolleyes:

Sorry about this Rich, i wasnt specific enough with my last response. I dont want to record zeros but i need the date and fact that there was no payment to be recorded automatically?? Therefore it should look like this: Date Member Amount Due Amount Paid Balance...

I guess you will have to send me the appropriate code sorry!! i need to have this data as entering a nil for a hundred people would be time consuming sorry if they didnt pay as some will pay 2 weeks and nothing for six weeks...:confused: PS: Thanks for being patient :)

Thanks for your reply It would help me a lot if you could even give me a clue as to how i can have a make table query produce a list of 26 dates all 7 days apart based on an entry date. I can hopefully work out what i need and dont need from that. There would be no redundant data as this...

As Previous Yes this is correct i would want to print this say monthly and hand out as proof of payment or non-payment as required. And also view on screen.

Youth Club (membership) This is needed when someone joins the club and pays a weekly membership fee. They can join at various time throught the week so therefore a static table of dates with a 7 day increment would be of no use. It has to calculate every 7 days from a give date for a period...

Can someone shed any light on the following? I am new to MS Access and want to create a table from a query that will create periods based on a start date and an end date. Eg: I want to say select 01-March-2003 as the start date and twenty 26 weeks (6 months) later select an end date. I want...

I have a list box in which i have specified extended selection (what do i need to tell the query to pick up more than one selection? eg; number 1 2 3 4 5 out of these i select 1 2 3 5. The query takes these values a prints labels based on the selection(s) I have a funny feeling that i have not...

have you tried a make table query for each of the tables and then a query to link all three and filter on required data?

Im not sure if this is the answer you are looking for but i would suggest getting a copy of paintshop pro and use the animation program that comes with it this should let you change the speed of the animation. I've designed web sites with the same problem using gif graphics. Not only van you...

This may be a silly question.. But have you checked the forms format properties to see if the form view is set to continuous forms? Change to single form if this is the case.

Does anyone know of a way to change the title bar and scrollbar colours in access?? In anticipation... Yes i'm a newby