Question: Hello, I am using access VBA and have a DoCmd.OpenQuery for a create table query. in the table that is created, I need an existing

Hello, I am using access VBA and have a DoCmd.OpenQuery for a create table query. in the table that is created, I need an existing field to be declared the primary key.

What is the VBA code needed to do this?

Thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Recher Corporation uses part Q89 in one of its products. The company's Accounting Department reports the following costs of producing the 7,100 units of the part that are needed every year. Per Unit...

ADM 1370 - Applications of Information Technology for Business - Winter 2022 - Assignment 3 Database Table Descriptions VOLUNTEERS Attribute Type Volunteer ID Number Volunteer_Last Name Short Text...

Hello, i need this to be done in PHP the code can't be more than 12 lines long. i can provide front end code. Thank you. Here is your homework assignment... Create a webpage that counts the number of...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

CIS221 Access Project Instructions You were recently hired by your local college to help with registering all transfer students. The college's Transfer Counseling Department is a one-stop location...

A. Lab # BSBA BIS245A-3 B. Lab 3 of 7: Database Design Using Visio and Based on Data Requirements and Business Rules C. Lab Overview--Scenario/Summary COs: 2. Given a situation containing entities,...

. Heading 2 1 Normal 11 No Spaci... Heading 1 Title Subtitle Subtle Em ont Paragraph Name: Styles ID MS Access and BPMN Paper 2 1. Use the Retailer Sales Items table. For each record, calculate the...

Calculating by using queries 21? Updating records by using queries As you use a database and as it grows, you might discover that errors creep in or that some information becomes out of date. You can...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Why is the Dipole Plate electric field different from the Parallel Plate electric field?

Prepare a cost of production report for the Cutting Department of Aladdin Carpet Company for May 2008, using the following data and assuming that all materials are added at the beginning of...

Given the strategy and economic outlook, what specific stocks and / or bonds will be put into the portfolio at the present time that are consistent with the client s policy statement.

An investor buys a European put on a share for $3 that will expire in two months. The current stock price is $42 and the strike price is $40. Is this put option in the money or out of the money?...