Solved

Access 2007, form, sql db

Posted on 2011-09-12
6
220 Views
Last Modified: 2012-05-12
Hi,

I have a fornt end from in access which is connected to SQL server 2008.
 I have formA which has a dropdownbox that I select countryName and when I submit, I go to FormB.
In formB there is a label called lblCountryName which displays the selected country from formA..

I like to submit the lblCountryName to my employee table.

How can this be done in access 2007?

Thanks in advance
0
Comment
Question by:shmz
6 Comments
 
LVL 17

Accepted Solution

by:
Kent Dyer earned 500 total points
ID: 36526868
Forms!formB!CountryName from your formA design mode..

That should do the trick for you..

HTH,

Kent
0
 

Author Comment

by:shmz
ID: 36526992
I am not familiar with access.

I already have the lable or scountryName from formA. how can I apss lblCountryName (sCountryName) to employee.CountryName in in formB?
FormB pass all values to sql database.
0
 
LVL 9

Expert Comment

by:borki
ID: 36527066
can you post you database?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 84
ID: 36528159
What do you mean by "pass the lblCountryName to employee"? What do you want to do with the value in lblCountryName in regard to Employee? Do you want to filter the employees by that value, or do you want to update the Employee table based on that value?
0
 

Author Comment

by:shmz
ID: 36528891
insert that value into employee table.
0
 

Author Closing Comment

by:shmz
ID: 36555076
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now