Recent content by Stowers

Thanks VBAINET Will play around later this afternoon , have got to do a bit of work now Thanks again Ian

Hi VBAINET I can appreciate the design aspects but going back to my original post JobDate .... CompanyInvoiced PaidOut PaidOutDate 10/10/2011 ABC ................... £200.00 11/11/2011 11/10/2011 XYZ ................... £200.00 11/11/2011 12/10/2011 GHF ................... £200.00 If I...

Hi VBAINET In the Header but your code wont help if I leave the cursor in a blank reord or WILL IT I will try the docmd ian

hI vbainet Have added the message box and the following is happening If I add a date to the record and move cursor to another record (without date) it displays that syntax error If I leave the cursor in the record with the date it displays the msg box with the date I entered and produces...

Hi VBAINET Its definately got a date there Have finally (hopefully) managed to upload DB I have mangaed to do the form pass to form (see my DB) but even that was wrong, to the extent that it only passes the record that the cursor is in

HI VBAINET DoCmd.OpenReport "RDRIVERPAID", acViewPreview, , "PAIDOUTDATE = #" & Me.PAIDOUTDATE & "#"

Hi Have tried what you suggested and have got the following run time error 3075 syntax error in date in query expression '(paidoutdate = ##' Am I still missing something, you have the following line in your reply [PaidOutDate] <= SomeDateIs this meant to go anywhere.

Hi Guys Can someone help me do the following . I have a form (sorry I would have posted a image but apparently I need 10 posts) but the jist of it is JobDate .... CompanyInvoiced PaidOut PaidOutDate 10/10/2011 ABC ................... £200.00 11/10/2011 XYZ...

sorry to bother everyone I have stumbled across answer CTRL + TAB

when I have gone into a subform to enter data how can I then tab out back to the next control on my main form many thanks ian