Search results for query: *

WP, I'm sorry about the late night for you last night, I guess I didn't realize the time differential between the States and Scotland. Your input is much appreciated! Despite all our efforts, something is still wrong. I don't know what could have happened between yesterday and today, but the...

WP, Thank you for you help and your patience. Please bear with me, I will try to answer all the questions you asked, but keep mind that I was given Access 2000, an old database and a manual. I am learning as I go! The report is based on a query called Fulfillment Qry and uses three separate...

Did that. Still #Error. The debugger doesn't run anymore, I just get that #Error where the field is on the report. Could I have something else mixed up? Thanks!

Sorry I wasn't more clear. I'm using Access 2000 and I assume that the code I'm trying to use is for Access 97 with the Data Object Library 3.51. The Help menu says that 3.51 is not supported by Access 2000, so I have selected the Microsoft Data Object Library 3.6, and changed the code...

WP, Thank you for your responses! I really appreciate your insight. Unfortunately, I have had another project I've been working on and couldn't respond back to you. I have re-installed Access with all the bells and whistles, but that hasn't done the trick. I even tried to modify the code...

Something is still amiss... I haven't a clue about any sort of code, so I'll have to have someone out there interpret this for me!! Thanks for your help in advance. I got the report set up just how I wanted and used the fConcatChild function from the module, but when I click to view the...

Thank you for your reply!! The report should look like this: John Doe Address CSZ Product1; Product2; Product3 The database is similar to Nwind with Customers, Orders, Order Details, & Products tables. While I was waiting for a reply, I found the following post on The Access Web but I keep...

Not a programmer, and pretty new to Access, so there is probably a simple fix for this but here goes... I am trying to run a report of Customers and Orders for fulfillment purposes. I would like to be able to concatenate all the ProductName values from an Order Details table in one field so they...

I am probably missing something really simple here, but I have no idea what it might be. I have a data entry form that I created with tab controls that contain subforms. Four tables are represented and three of the tables are linked to the main table by an autonumber field. I know that the...