Creating fields from one table into another

J

John

Hi

I have two tables linked form the backend into front-end. How can I do the
following in front-end via code?

1. Lock both tables so no user can change them while we are running this
process.

2. Go through one table's field list one by one and check if same field
exists in the second table. If not create that field in second table.

3. Unlock tables.

Thanks

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How to open multiple instances of Word 365? 5
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Add New Table to Existing Form (Access 2003) 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Insert Index into a Table 1
Ghost references to deleted tables in a back end database (Access2000 XP) 5

Top