Recent content by mshellay

You know what I'm so silly. I figured out why I got the error. I forgot to take out the "where" statement in my pass through query. It's so late!! Anyway your solution worked. How can I append this data to a table?

I tired docmd and now I'm getting syntax error on location_id. It highlights the docmd line when I debug. I attached a screenshot of the error. thoughts?

I have been scouring the internet trying to find a solution for my issue, to no avail. This is my first time writing a pass through query pinging sql tables using an input parameter from a form. I have gotten as far as executing the query but I can't seem to display the result to ensure it's...

Awesome sauce! That worked. Thanks so much!

The day_value is a text column.

Hi Minty, Thanks for the quick reply. I still get an error with too few parameters. I'm sure it has something to do with how I set the value for the date. Any thoughts?

Hello, I am new to VBA and I'm trying to write a query that will update a table with dates based on user input. For example a user will run data each Monday and that date will be day01. The date table has 28 days total and I need each day row to update with the next date i.e. day01 is 12/30...