Recent content by GreenLil

Sorry I was confused by the statement 'frm is the name of the form you want to send to Excel I thought I was to change frm to my subform name. Now it is working perfectly, thank you so much for your help it is greatly appreciated!

Thank you for the code. I'm trying it and not sure how to make it work properly. I copy and pasted to create the Module. The only thing I changed frm to my subform name. Then I put the following in an onClick button on the main form (the filtered records have been displayed on a subform): Call...

Hello, I'm a bit stuck on an export of a query and I feel like what I'm missing is probably obvious, but since I'm here I clearly can't see what it is I've missed. I have a form to export records based on two sets of combo boxes. One drop down chooses the field, the second allows you to input...

Thanks for the help, I was able to do a make table query from the first query and then do an update query from there. The values aren't calculated, they're data entry of test results. Unfortunately there are some issue with normalizing the data because the access database is connected to a...

Wow that was pretty straightforward, thank you. Unfortunately now I'm having problems with my update query, its giving me an error "Operation must use and updateable query" when I try and update the main table (Entrytable) with data from this query. Any ideas on this one? Thanks again for all...

Hello, I have a problem that I can't seem to wrap my head around. Lets see if I can explain my issue in a way that makes sense. I have an Access database with a Key that doesn't allow duplicates, and need to import data to a temporary table, and the use an update query to move the data to the...