Search results

Here is the full code I have right now. The tables with (last 5) q at the end are querys. strPath = "M:\Research\Lung Us\Data\Exporting_OHSU\OHSU.accdb" DoCmd.TransferDatabase acExport, "Microsoft Access", strPath, acTable, "Admission_DX", "Admission_DX", True DoCmd.TransferDatabase acExport...

I end up with a Access database that has linked tables. (I need a copy of the tables, not links) Then the querys that I exported show up as empty tables, but actually in the table, not linked.

There was an issue with how the drive was mapped. I fixed it. Also the file extension wasn't correct and I fixed it. But now there is a different issue. It's not exporting the tables it only exporting the link. I'm trying to create a copy of part of the database so I can send it to someone not...

I might try moving the access file that I'm exporting to somewhere on my desktop

Yes, no errors with the tables or queries or the access files.

Ok, I will try using an alias.

Yes the path exist, it's a network drive.

I am trying to automate the exporting of several tables and queries. I have a button that you click that executes this code. I keep getting error messages. I was wondering if there is anything else wrong with my code. Micro_results_q is actually a query but I want it to export as a table. Can I...

Not sure if this screenshot is more helpful. My audit table has 7 fields in it.

I created an audit table for my database and I have been using the After Insert, After Update, After Delete Macros to create an audit trail in my audit_trail table. I created another Audit_Memo_fields table to track changes for my memo/ long text fields in my database. I can't get the macros to...

I took your code and used it in my forms. Its less code. Thanks.

Hello, I got my forms mostly working how I want them with record locking but Im having some issues with 2 of my forms. I have my main form with the Record_lock checkbox. IF it is checked yes, then it triggers all the forms and subforms to not AllowEdits or lock specific controls. Two of my forms...

I wrote some VBA code and got it to work for my main form. I created a Record_Lock checkbox that is on my main form. I created a toggle button that opens a popup message form where you can click ok or cancel. The pop up message form gives you a message That says you are unlocking or locking a...

I haven't tried that yet. I'm thinking of having a checkbox field called record_lock on my main form. In the on load event If record_lock field is checked then it would lock certain fields on my form. Then I will have a button that will check or uncheck that record_lock field. After update event...

Hello, I want to create a button that locks individual records in my database on the forms, so accidental edits don't happen. I used the code and followed the instructions from this website http://allenbrowne.com/ser-56.html. The code does work, but it either locks all the records or unlocks...

It worked. The Patient_Status form was creating a duplicate record. I can use this Data macro, just for a different table/subform now. Thanks for all your help.

My main form has buttons that open up different subforms in a subform container. I'm going to try having the data macro create a new record for one of my subforms(table) that isnt automatically open. Then I will try to create a new record on my main form. My patient_status table/subform is...

I will try doing this data macro to create a new record in a different table and see if I still get the error message.

I created a Data Macro with my backend table. I used the After Insert event for my New_Patients table, it triggers a new record to be created in my Patient_Status table. The two tables are linked. The Data Macro works great when I add new records directly in the New_Patients table, It will...

I have a database that is split with a front end version and the backend. The backend is stored on a shared mapped network drive. 2 people use the database, generally at the same times during the day. Each person has there own version of the front end forms that they save and use from their...