I could really use some help with a problem I am having. I am trying
to add a new field to an existing form that combines two tables into
one form. In this same databse I have another form that exists off of
1 table and when I add a new field into the table I have no problem
adding into the corresponding form. However when I add a new field to
one of the following tables:
- Employee List & Main Profile tables (This is what the combined form
is based off of)
Basically i added a new field to Main Profile and wanted to add it
into my form as a combo box. However when I go to add it to the form
and get the wizard and it lists the fields that I can store the values
in it does not list my newly created fields just the old original
ones. What are the resaons for this and hwo do I remedy it? I hope
that I explained this in a somewhat cognizant way.
Thank You,
Tony
1  2459 
When you are using Fields from two Tables on a Form, the Form's Record
Xource is either a Query or an SQL Statement. A new Field in the underlying
Tables isn't automatically added. In Design View, click on the RecordSource
property of the Form in the Property Sheet, then click on the little box
with three dots and update the RecordSource, which will be shown in a
QueryBuilder window.
Larry Linson
Microsoft Access MVP
"Tony D." <wa*********@ao l.com> wrote in message
news:93******** *************** ***@posting.goo gle.com... I could really use some help with a problem I am having. I am trying
to add a new field to an existing form that combines two tables into
one form. In this same databse I have another form that exists off of
1 table and when I add a new field into the table I have no problem
adding into the corresponding form. However when I add a new field to
one of the following tables:
- Employee List & Main Profile tables (This is what the combined form
is based off of)
Basically i added a new field to Main Profile and wanted to add it
into my form as a combo box. However when I go to add it to the form
and get the wizard and it lists the fields that I can store the values
in it does not list my newly created fields just the old original
ones. What are the resaons for this and hwo do I remedy it? I hope
that I explained this in a somewhat cognizant way.
Thank You,
Tony This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bobbak |
last post by:
Hello All,
I have these tables (lets call it ‘EmpCalls', ‘EmpOrders', and
‘Stats') that each contain the list of EmployeeIDs, I want to be able
to create a Module in which I could call in my VB form (by clicking
and command button)that will add a column (field) to each table and
label it with the current date that is specified in my form. Does
anyone know how I can go about doing this?
Any suggestion will be greatly appreciated.
|
by: Wendy Powley |
last post by:
I have a subform which represents a 1:N relationship with the main
form. I would like to be able to read values from an external file,
fill the subform with the values read & allow the user to view/edit
the values via the subform.
I thought this would be accomplished using a simple loop; read values,
assign the various fields of the subform & repeat for each row of the
subform. Seems this is not possible, or at least I have been unable...
|
by: Randy A. Bohannon |
last post by:
This is probably a simple thing to do, but I can't find how in the help
files or the manual I have.
I'm using Access 2000. I have three tables joined by a common field, and
I'm using one form to enter data into all of them. The form was created
using the form wizard. I need to add new fields to one of the tables, and
consequently, to the form. I can add the fields to the table, but not to
the form. I've done this before with a form...
|
by: Jiho Han |
last post by:
In CreateChildControls method of my Page, I am trying to see if a hidden
input field is present (by id) and if not, add it to a predefined form (by
id).
protected override void CreateChildControls()
{
base.CreateChildControls();
HtmlForm form = FindControl("myForm") as HtmlForm;
|
by: Rudy |
last post by:
Hi all,
I know this is easy, just can't seem to get it. I have a windows form, and
a text box, with a value already in it. I need to add that value to a table.
It's just one value, so the entire row doesn't get filled. I have a
connection and all that stuff.
Private Sub btnPlaceBet_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnPlaceBet.Click
' Dim Myds As Footbet.DStable
'...
| | |
by: shumaker |
last post by:
I'm wondering if adding an autonumber primary key will improve the
performance of a multiuser access database on a network share. I have
a website that lists many tips for improving performance of access, but
doesn't mention primary keys.
However, it seems logical to think that having no primary key means
that when a user updates a record, the database has to do comparisons
on multiple fields to identify the specific record being...
|
by: Genalube |
last post by:
I am new to access, so I figure this is an easy question to answer. I just can't find it on my own.
Background:
Two tables with a one to many relationship (irelevantField1 is a place holder, these fields are not relevant to posting, the number of fields represented is correct)
Parcels:
ParcelNo
irelevantField1
irelevantField2
|
by: The Eclectic Electric |
last post by:
I'd be very grateful if anyone could help me with this. From my limited
knowledge of Javascript I don't think it is possible, but I'll punt anyway.
I downloaded and very slightly adapted this guy's Javascript "combo box" -
http://sandy.mcarthur.org/javascript/select/select.html. It allows my users
(when I get some!) to select from a list of preexisting options and also to
add a new one by clicking on "add new". Essentially it's a select...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
