Solved

Access 2007, form, sql db

Posted on 2011-09-12
6
223 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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.

726 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