In Progress

MS Access Macros - update fields based on SQL query results

I need some MS Access Macros that call SQL queries to check fields in an existing Table in the database, and populate fields in another Table based on the results.

I have 4 specific fields in Tables that need to be updated automatically via this method, so 4 separate Macros and (multiple) SQL queries. I can provide the specific details and sample Access database.

An example of the most complicated of the 4:

----------------------

MS Access User Table (USER_TABLE) consisting of 3 fields: Customer_Number, User_Name, and Email_Address. I have another table (NEW_USERS) that consist of new requests for Users. It has a User_Status field that is blank by default, and also has the Customer_Number, User_Name, and Email_Address fields.

Half of the new requests that come through are users already existing, so I want to set up a query that will check the USER_TABLE to determine if a new request exists or not, using the Email_Address field checked vs. the Customer_Number field. Complicating this is the fact that 1) Customer_Number is not unique (many Users exists for a single Customer Number) and 2) Users can have multiple accounts for different Customer Numbers. This results in 4 scenarios in the NEW_USERS table when checking vs. the USER_TABLE:

Email_Address does not exist for Customer Number in USER_TABLE (New)

Email_Address exists for Customer Number in USER_TABLE (Existing)

Email_Address does not exist for Customer Number in USER_TABLE, but exists for other Customer Numbers (New-Multi)

Email_Address does exist for Customer Number in USER_TABLE, and also exists for other Customer Numbers (Existing-Multi)

What I would like to do is run these checks and enter the corresponding result (New, Existing, New-Multi or Existing-Multi) into the User_Status field.

-------------------------

Skills: Microsoft Access, SQL, Visual Basic for Apps

See more: call scenarios, what is ms sql, what is ms access, sql microsoft access, on sql, ms access sql, microsoft access sql, want to update existing, SQL Query, sql queries, sql microsoft, ms access 2013, access macros, access query table, sql different, blank fields, access table query, 2013 query, update field sql field field, table based, multiple fields, populate table using, update automatically, access sql query, sql query access

About the Employer:
( 5 reviews ) Temecula, United States

Project ID: #5197723

Awarded to:

sswijaya

Hi Russ, Thanks for inviting me to this project. I'm very interested and would like to help you again with this. Can you send me the details of the 4 tables? Regards, Susanto

$50 USD in 3 days
(7 Reviews)
3.5

23 freelancers are bidding on average $76 for this job

Prashantskin

[url removed, login to view] I have gone through your project requirements. I will help you in building macros that will update fields based on sql query results like.. The program will run the checks mentioned by you and enter the co More

$88 USD in 3 days
(485 Reviews)
7.0
winghei

A proposal has not yet been provided

$50 USD in 1 day
(30 Reviews)
5.4
djain01

Hi, Lets discuss more on the scenarios. I have already read the details you posted and ready to work on the same. Please send me a message so we can discuss more on the same. Please also check my reviews and f More

$72 USD in 3 days
(26 Reviews)
4.8
adaytay

Hi - I can help. I've been an Access developer for over 15 years, and I'm always building stuff like this. I actually have a similar system in one of my databases where if someone tries to register and they already h More

$84 USD in 3 days
(11 Reviews)
4.8
cheapexcell

Hello, I am an expert in Access with over 5 years of experience. I have done many similar jobs. Ready to start. Thanks, Alex

$144 USD in 3 days
(24 Reviews)
4.6
NourElDeen

Dear Sir, I'm interested on doing your project could you please send me a copy from database???. Kind Regards, NourElDeen

$45 USD in 1 day
(35 Reviews)
4.6
elboukharimu

Hi, I'm very interested helping you creating your Access macros, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, ther More

$100 USD in 3 days
(14 Reviews)
4.5
wesolvevw

Hello, Is that the only query you need which updates the filed in NEW_USERS table based on the presence of it in the other table based on your conditions. If that is the case, I can finish off in a day once you prov More

$54 USD in 3 days
(32 Reviews)
4.4
juan1matos

Hi there, I would like to work on these macros/queries for you. Thank you for your time and consideration. -Juan

$155 USD in 7 days
(16 Reviews)
3.9
mail2vimalarora

Hi.. I have done several MS Access projects and worked on VB coding part also. I feel comfortable in taking up your project to its completion as per your requirement of writing macros. Waiting for your response to tal More

$66 USD in 3 days
(11 Reviews)
3.6
expertatwork

hey cnwinger, please share the access db and the details about the remaining three requirements. Please reply and we can discuss further. thank you :-)

$66 USD in 3 days
(6 Reviews)
3.2
swarm22

I have +4 year Experiences in Ms Access Project. I am able to full fill our all requirements. Thanks & Regards Hardik G. Dumaswala

$100 USD in 3 days
(4 Reviews)
2.8
hieutc

Hi, I have read your requirement and sample of the User Table, and if this is the most complicated then I think I can done the work in less than a day Regards,

$50 USD in 1 day
(3 Reviews)
2.6
pkcyber

I can give u simple application, you will select the access database and click on process button. Applicaiotn will automatically put data in respective tables.

$100 USD in 2 days
(1 Review)
2.2
sayli2

Expert in MS Access and Sql Server. Very easy task for me. Already did that type of work here. Please check my profile for details. Thanks

$33 USD in 3 days
(4 Reviews)
2.0
pallavibk

hi I am experienced developer. I can create queries and macro for you. I have ms access 2007 installed which ver your Access database is? thanks

$66 USD in 3 days
(2 Reviews)
1.6
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a More

$40 USD in 1 day
(1 Review)
0.8
Steponitgal

Hi cnwinger - I am an experienced Access developer and am able to assist you with this project. I've been running my own business for approximately 20 years, building custom MS Access systems and assisting client More

$200 USD in 3 days
(0 Reviews)
0.0
SCKRamana

i am ready to work on your assignment . More

$61 USD in 1 day
(0 Reviews)
0.0
Mazzzola

Few projects built in MS Access with VB programming, including an accounting module. Also a project for Numerology done.

$50 USD in 2 days
(0 Reviews)
0.0