Recent content by Geronimo

Scrub that last question, sussed it out! Thanks again for your help. :)(y)

Hi, that worked a treat, thank you very, very much, saved me a lot of time and head scratching! .....just a quickie, if I wanted to include a field from the query output (or a field from the form) in the exported filename, is there an easy way to do that? Its a nice to have, not a need to have...

Claim number is a number (autonumber) Crikey, more involved than I thought! I'll try the above in a mo and let you know how I get on...thanks

The test cmd button on the form successfully runs the query (code for that one below) but the xml export cmd button on the form (code above) does not. Has me scratching my head! Private Sub Command305_Click() On Error GoTo Err_Command305_Click Dim stDocName As String stDocName =...

Thanks arnelgp. That's what's confusing me as the form is open (the cmd button is on the form itself so has to be open to be clicked in the first place) but it doesn't seem to tie up.

Hi I'm going round in circles and, as a pretty amateur Access bod, wondered if anyone might be able to point me in the right direction with this, I'll try to describe the issue as best I can! : My users complete a form called claims to create a new claim. Each new claim gets a unique auto...

Thanks again, the Dlookup solution works perfectly. Brilliant and simple, and probably quite obvious to an expert, I couldn't see the wood for the trees! Cheers again.

Thanks for the warm welcome folks.

Thank you very much, lots of food for thought there, I'll try those suggestions and let you know how I get on. Cheers.

Hi there, newbie first post...please be gentle! I've tried to give as much information as possible... I have a form where new customer details are entered. One of these is Postcode (UK format which is Alpha Alpha Number Number space Number Alpha Alpha). I have a list of 17 postcode areas...

Good afternoon, Just a quick hello from a newbie.....I'm not a techie but use Access databases a lot in my work and recently designed a DB for customer record management that handles sales, scripting, claims, complaints and policy administration. I'd describe myself as somewhere between beginner...