Search results

Well I'm glad someone got it to work! All the variables seem to work. However when it gets to the .Range(Cells(1, 1), .Cells(intMaxRow, intMaxCol)).CopyFromRecordset rs It refuses to post the data in Excel and comes up with an error. Maybe something wrong with the query I'm using? Thank you...

I'm trying hard to learn VB but having a hard time with uncommented code I have found on the net. Here is the Problem: I need to take a report[invoice] and make it into an excel file to send to customers that prefer that format. I sure I can format the excel file in the way I want it but...

I'm looking for the same I'm trying to do the same. Thanks.

Hmmm Still no help? Is what I'm asking even possible? If not please let me know, so I can go on to something else. Thanks.

I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself...

Hi, As an example lets say I have customer names that I build a query for for a certain time. Lets say it has 50 names. I have another query with 10 names, nine of which are on the first query. How do I go about getting a dataset of the first list minus the overlapping names and ending up with...