Solved

Access 2007, form, sql db

Posted on 2011-09-12
6
222 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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 the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

790 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