Search results

OK forgive my ignorance, but where would I put that on the form? In control source of the button? Have tried it but it won't let me tick it on/off.... Will there be a conflict given that I have =Date() in the table field? Thanks, Brian

Hi pbaldy How would I go about that? I know how to create a button in a form but wouldn't know how to get it to enter tomorrows date...what would be the expression? Thanks!

Hi I have a basic data entry form whereby users enter the details of people who need to be paid. It then populates a table, and the date is set to todays date automatically. However, some people require payment the next day, so I would like my users to open up another form which populates the...

JNAR - you are a legend! It works! Thanks very much, I knew I was doing something stupid. Thanks pbaldy for the tips too...cheers!

OK please see attached screenshot... If I can get it working this way that would be great as I had a nightmare trying to get table relationships working etc and would rather go down that route as last resort! Thanks for your help

Hi Unfortunately I can't post the DB as it has telephone numbers/names etc in it...unless there's a way of excluding the data? Essentially I have a data entry form and I want users to select either CHAPS or BACS to populate the table - I figured a table lookup was the way to go about it to...

I should probably add I'm adding this expression in the "criteria" row in the design view of a query....I presume thats the right place...

OK first off, the semi-colons didn't work, it gave me an invalid syntax error (my computer is setup for UK settings for what its worth). But thanks for the tip... Secondly, there is no space after the BACS. In the table design I used "Lookup Wizard", then "enter text you want", then used...

Thanks for the quick reply! I have copied and pasted it straight from Access so what you see there is what I have. I was a bit concerned about the spaces etc, and I note that if I remove the spaces from 'payment method' and 'CHAPS Charge' I don't get an error message but I do get a dialog box...

Hi I'm relatively new to Access and have been trying to create what I thought would be an easy expression. My main table is (client field = primary key and in relationship with table below): Client | Client name |CHAPS Charge 123 |ABC | £20 999 | XYZ...