Filling up bounded form with information from another table while creating new record

Posted by amir shadaab on Super User See other posts from Super User or by amir shadaab
Published on 2013-06-27T15:40:17Z Indexed on 2013/06/27 16:23 UTC
Read the original article Hit count: 201

Filed under:

forms

|

access

I have an excel sheet with information about each employee. I keep getting new updated spreadsheet every month. I have to create a database managing cases related to the employees. I have a database and the bounded form already created for the cases which also contain emp info fields. What I am trying to do is to only type in the emp id in the form and want the form to look up in the spreadsheet(which can be a table in the cases db) and populate other fields in the form and that information can go into the cases db. Can this be done?

© Super User or respective owner

Related posts about forms

Designer issue in VS: Events cannot be set on the object passed to the event binding service ...

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a little problem: the Winform control (that contains between others WPF) suddenly stopped to be displayed in Designer. Message: Events cannot be set on the object passed to the event binding service because a site associated with the object could not be located. Call Stack: … >>> More
Winforms TabControl causing spurious Paint events for UserControl

as seen on Stack Overflow - Search for 'Stack Overflow'
For our project, we've written a WinForms UserControl for graphing. We're seeing some strange behavior when our control is sited in a TabControl - our control continuously fires Paint events, even when there is absolutely no activity by the user. We only see this in the TabControl. When we site… >>> More
C# Gui setting control.Enabled to false fires OnClick event???

as seen on Stack Overflow - Search for 'Stack Overflow'
For some really weird reason when i set the .Enabled property to false on a simple text box on a small GUI, it fires a radio buttons OnClick event and its causing lots of problems. I have breakpointed the txtBox.Enabled = false; and after stepping over OR into it i jump straight to the OnClick event… >>> More
Django's forms.Form vs forms.ModelForm

as seen on Stack Overflow - Search for 'Stack Overflow'
Could anyone please explain to me similarities and differences of Django's forms.Form & forms.ModelForm? I've used Django for 4 days, so excuse me if I don't know basic things. Thanks in advance! >>> More
C#.NET Forms programing - Modal and Non-Modal forms problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a problem with modality of the forms under C#.NET. Let's say I have main form #0 (see the image below). This form represents main application form, where user can perform various operations. However, from time to time, there is a need to open additional non-modal form to perform additional… >>> More

Related posts about access

Postgres user drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
Postgres user/role drop

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access… >>> More
ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

as seen on Server Fault - Search for 'Server Fault'
ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to communicate with… >>> More
.NET Access automation with Access 2007 Runtime

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble deploying .NET application which uses Microsoft Access automation. I've installed the Access 2007 Runtime and Primary Interop Assemblies (PIAs) on the target machine: Access 2007 Runtime Office 2007 PIAs However, when I try to create the ApplicationClass: Application access… >>> More
Cisco 800 series won't forward port

as seen on Server Fault - Search for 'Server Fault'
Hello ServerFault, I am trying to forward port 444 from my cisco router to my Web Server (192.168.0.2). As far as I can tell, my port forwarding is configured correctly, yet no traffic will pass through on port 444. Here is my config: ! version 12.3 service config no service pad service tcp-keepalives-in service… >>> More