Search results

Hmm... yes I was thinking perhaps this is the easiest solution. Thanks for your suggestion!

If anyone has any suggestions, please let me know. I don't necessarily need the answer, just a pointer in the right direction. Thanks

Hi, I have three tables which each have their own uniqueID field that I really need to be unique across the three (for union at a later point). Therefore I have created a table which has two fields - an autonumber field and another indicating which table it lives on. I basically want to work...

Great - thanks for the advice. I'll give it a go.

Thanks for this suggestion, however doesn't seem to have worked. This error is consistent across different reports, so I am wondering if it is a problem with the data. Very frustrating and confusing. Thanks again

Thanks for the advice, but decompiling doesn't appear to have worked. I can successfuly output the file, but the database crashes soon afterwards. I originally thought it could be the AutoStart property being set to True, but setting it to False doesn't seem to make a difference. I've tried...

2002 (windows XP)

Thanks for your quick reply. Believe it or not, I've had this format working in another database (it gives the 97-2002 Excel version), but if I try replacing this with acFormatXLS it makes no difference. I just tried linking tables into a blank database and copying the report across...

Hi super-brains, I am finding that Access crashes on a line of code and I receieve the "Microsoft Access has encountered a problem and needs to close" type message. The offending line is: DoCmd.OutputTo acOutputReport, sReportObj, "Biff8", , True where sReportObj is the user...

oh wow - thank you. I knew it had to be something silly that I had overlooked. Many many thanks for taking the time to look at this for me.

Thank you. Unfortunately I'm not able to share the whole db with you, but I have created a copy as an example for you. AfterUpdate on Teamcbo should update two text boxes with columns 1 and 2. Column 1 to TeamIDtxt works fine for me, but column 2 to CuurDepttxt does not. It doesn't make sense...

Hi, I've tried searching for this question here to no avail, so sorry if this is a repeat. I have combo/list boxes with multiple columns and have no problems referring to columns 0 and 1 in VBA. If I try referring to any columns greater than this (ie 2, 3, 4, etc) however, it always produces a...