Search results

Thank you sir, good idea :D

Hi, I have a combo box that is used to select which record you are viewing on a form, how can I make the name selected from the combo box automatically appear as the form title, in a Label box?

Sorry, what I meant was I have that kind of thing now, but I want the user to be able to customize the destination and file name each time they export, without changing the code. Can that be done?

Hi, I have the code TransferSpreadsheet running in one of my forms to export to Excel, is it possible to specify the file name and directory you wish to export it to each time, instead of specifying the directory and file name in the Macro? Thanks

Alright yes that works nicely. I think I'm still missing something though. Is there supposed to be a relationship between the two branchIDs?

Thanks I really appreciate the help :) A beer on me any time (I would post on the American equivalent of this forum but no one ever replys to anything there) I got the job today so I'm starting to sweat a little about this code hahaha. I got the first query working fine until I realized that...

Well it originally wasn't based on a query, but now it is and works perfectly. Thanks!

Hi, I have a pretty dumb question I'm sure is really easy to answer: I'm running a report that returns the names of all companies, and their results based on a check-box, in a yes/no format, so the report looks like this: COMPANY NAME YES company 1 company 3 company 6 NO...

Thanks Cameron, I definitly didn't make a fool of myself in the interview! I have not found out yet if I got the contract, but please forward your paypal address to andrewclb@hotmail.com anyway, as I can definitly use this macro information in the future. thanks!

Hi everyone, just joined, just started making databases for a living (go figure). I'm up for a contract tomorrow, and I know how to build everything they are requesting, except this one thing, is it even possible? If your solution works and I get the job, there's a $20 paypal reward in it for...