I'll get to work on adding that in. I believe I'm following where you're going. Obviously the button code is in the on click event. Where do I place the code for the public function?
I am open to either one of those options if it gets me where I need to go. But I'm not entirely sure how to do those things. I have all the data and tables to say print report using record 1 from table as operation but then I need it to repeat all the way through the operations. I hope I'm...
I have a form that shows our manufacturing schedule. It has a sub query in it that you select which operation you want to preview the data for. It loads the data in another sub query in which I have a button that will print that data. The sub query on the left is labeled qProdHrs5bRS2. The query...
I have searched all over but can't seem to find a definitive answer as to what is going on with this form. I'm preparing to roll out a new version of our database and when testing it on another users computer I find this issue with the subforms. On my computer everything lines up nicely. On the...
That might do what I need it to do. Anytime a user opens a specific form I could make it execute those steps and add the new order. I'll give that a try.
I apologize for that. No it is not in the ERP system. It is in the access file that we are building a database off of. The access file has the linked ODBC connections and it also has a table that I've made inside it that contains the engineering data.
The ERP system contains all the info about the order. But for instance another table (sorted by the same sales order) would contain info about which engineer was working on it for example. Obviously in the erp system when a new order is entered there won't be a record for that sales order (so...
We have a table that is an ODBC connections from our erp system. Any time a new sales order is added into the erp system I need the ODBC table to also create that record on another table. We will call it Engineering sales order table. I've googled and cannot find this answer. Is there a way to...
So we did some testing this morning. I had a user crash it. Once they did we got the following message for the user and anyone trying to get in at that point.
"unrecognized database format"
From there when I open the table to C&R I get the error
"Microsoft Access has detected that this...
I would say at times yes there could be a lot of churning. When a user enters all the items under a sales order it's almost like a bom. They then will enter all the data for it and click through different buttons to timestamp where a job is. This is looked at by multiple people to see the...
At this moment it's 24.3 mb. The front end is 42.62 mb but I don't see that being an issue. I can check the size the next time we have to do it. It can be random. Sometimes works for a couple of weeks and sometimes every single day it messes up.
Yes on the BE. It would corrupt and lock everyone out. I'd get everyone out and then compact it. That's why I was looking to make the back end SQL and hoping this would take care of those errors for me.
I did split the database. It wasn't originally split years ago. All the tables reside on the back end on the network. There's currently a set of tables for engineering and a set for quoting. Then I created the GUI front end that resides on each users computer for the to access the data.