Recent content by 4star

@arnelgp That last update fixed it all, thank you.

For some reason, what once worked, now we can't get it to run, on changing the data in the combobox Access now throws out "Run time error 2448 - You can't assign a value to this object."

That's worked brilliantly, thank you!

I have a form in a Database that has a combobox on it with two fields. When an item is selected it shows the first column in the combobox and then shows the second column in a textbox next to the combobox for the user to see. A button then runs a query based on the selections in the combobox...

Split the macro down into several smaller operations and then did the final file copy to a network drive via batch file.

After a lot of wailing and gnashing to teeth I've got passed the problem I was having.

It's definitely the Append Query that stops it. Everything else runs fine through the Task Scheduler. I just have no idea why it doesn't run through Task Scheduler, when the macro itself works fine in Access.

Yes, the macro that I have works perfectly fine within an Access environment, it's just when we run the scheduled task that it sits there indefinitely "running"

I have a database that is importing information from txt files using an import macro tied to a scheduled task. This is working perfectly fine. However, what I then need to do is run an Append query to get some of that data that is imported into another table for export. The issue I am having...

From the Main Menu there is a list box under "to print batch sheets" This is pulling data from the "interviews" table (attached database has been anonymised). There are three buttons underneath it that allow you to run reports based on the fields in the box. If the three fields are populated...

Tearing my hair out with this one. I have a list box on a form with three fields. Two dates and a text field. The text field is always populated but the other two fields may or may not have data in them. There are three reports that run from these selections. Should also mention that this...