Recent content by PSmit

Got it working - although not like I wanted it Thank you for the replies. DCrake, I went to Tools -> Options, but didn't find System Objects. mhartman, I somewhat used your suggestion. I imported the Excel file as a new table in the database. I then wrote queries to delete the data in the...

I am having a problem importing an Excel file into an existing table and can not find any solution in the forum (maybe I missed a posting...). A group I work with had an Excel file that they imported into an existing table in a DB perfectly fine. They decided to then add more columns to the...

Thanks for the posts Pat and Ian. I appreciate all of the good ideas and the help (especially as it appears it took you a lot of effort to get your post online, Ian!). This way, I at least have several options as to how to get this thing done and working! Thanks again~

Found A Solution!!!! After more searching online, I have found a solution to my problem... Here's the code (with some comments) to help anyone else that ever finds this post... To actually copy a spreadsheet in one file to a spreadsheet in another, do the following (this assumes that the...

That's my point, though... I have that part working fine. I have all four queries dumping to different Excel files perfectly. Please refer to my original post. I need help with combining these files into one file using VBA so I can have it done when my user clicks the button within Access...

Can I dump several queries into the same file in Excel (on different tabs)? If so, my problem will be solved. If not, I still don't have an answer as to how to combine the files into one final files after they are outputted....

Well, here's the whole senario... My boss wants a report in Access dumped to Excel. But, she also wants it pretty and formatted with colors, bold text, etc, like the Access report is. The report in question is made up of four different subreports, each of which is completely different. Using...

I am attempting to write an Access module to merge two Excel files together. I didn't find anything on this site, but something on another that I can not seem to get working. I don't get any errors, but I don't get any results, either. Any help would be appreciated... Here's what I found...

Never mind... Chalk this one up to having to add in extra features after creating the initial queries a while back (and forgetting what you did in the first place)... I completly forgot that when you reference things (like a checkbox, combo box, etc.) on a form within your crosstab query, you...

By record filter, do you mean the following? Put something like "Expr1 : [Forms]![MyForm]![Checkbox]" as a field in the crosstab query with the Criteria set to True? If so, I've tried that as well and it gives the same error message... Can you think of anything else that I can try or did I...

I'm attempting to build a crosstab query that references fields on a form as criteria for my query. I have no problem referencing a combo box as part of my criteria -- the query likes that fine. However, when I attempt to reference a check box (ex. iif(Forms![CheckBox] = true, "A", "B"), I...

Just in case anyone ever finds this thread again, here may be a way to make this work (at least, it is working for me). In the VBA code for your form, add a new variable (like DIM value as Double) before any of your Subs. This allows this variable to be accessed by any of the subs. Set the...