Search results

I agree, it is completely scary. But that is the way it is, status quo henceforth I am working towards a temporary "fix" as I begin to completely redesign the process. I know what I need to do to not have this happen, but can anyone offer a solution or a work-around to meet what I started this...

No it is a individual form, individual report, and individual query. All dependent upon what the product code is. And then once the "Done" button is pressed, use VBA to export all information specific to that product code. Is it possible to write VBA to transfer forms and or queries via VB...

There is one set of code (this code) that actually builds the templates (the mappings). There is another set of code that runs at the end of the cycle that actually takes the data from the table and fills in the mappings. Then from there reports are generated etc. etc. It is just done in...

The queries/forms/tables are solely dependant upon the product code that is input into the textbox, once all of the other checkboxes have been checked and updated, there is no longer a use for these items. It's almost like the database is only a storage location. There is no actual data within...

I am wanting to keep the structure/design of those forms/tables/queries, but just have them transfer to a different db. I know I can manually do it, I know how to do it that way, I just thought there was some VB code that could automate the process. Am I wrong in assuming this?

There are checkboxes on the form, and depending on what checkbox is checked and what button is pushed, there will be a form/query/table created within the db. I am wanting so that once all work has been completed on the input product code, you can press the "Done" button, and it will export...

Sorry, no. On this form it is a generic form, and on it, I input the product specific code into a textbox and then click a few buttons to run some queries. Those queries will then generate some reports, I want to then push my "Done" button and have that "Done" button take all...

That code would work, from just pushing the button on my form? Is it possible, to once you click the button, it asks what value you want to update field1 to? And then it update field1 to the value entered? I think I can set up the update query to run this way, but I am not 100% sure...

I have a button on my form, and I want the On Click Event () to take the form, table, and query in my current db and export them (completely removing from current db) into a different database. What would be the VB code needed to make this happen?

***These are both Access 2000 databases. I want to put a button on a form in DB1, and when the button is pressed, I want to update field1 (or whatever the field is called) in DB2 to "Richard (or whatever value is decided to be set)." What VB code would I need in order to make this happen? I...