TEXT BOXES.. HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im new to access and I have been having problems with my text boxes in my
form. I am currently using Access 97 and I have text boxes that are supposed
to be filled in with the First Name, Last Name and Employee ID but when I run
the form it shows the FName, LName, and EmployeeID populated with just the
EmployeeID in all the fields. How do I fix it that it is populated with the
correct information.
Thank you in advance for your time and patience!
Cathleen
 
Open your form in design view. Select the FName textbox. Open properties and
go to the Data tab. There's a control source property first in the list.
Click on the down arrow at the right and change the value there to FName.
Select the LName textbox and change the control source to LName.
 
Cathleen,
In Design Mode, place your cursor in the FirstName control. Find the
ControlSource property for FirstName, place the cursor in that property, and
use the little arrow on the right to drop down a list of available fields
you can use for this ControlSource. IF [FName] (or whatever your table
field name really is) is not on the list... then you haven't included it in
the query behind the form. You'll need to correct the RecordSource query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form will be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp
 
I did what you suggested and it still shows the Employee ID, what else can I
do, why wont it show what is in the control source... I would be grateful for
any more suggestions.
Thanks!

AlCamp said:
Cathleen,
In Design Mode, place your cursor in the FirstName control. Find the
ControlSource property for FirstName, place the cursor in that property, and
use the little arrow on the right to drop down a list of available fields
you can use for this ControlSource. IF [FName] (or whatever your table
field name really is) is not on the list... then you haven't included it in
the query behind the form. You'll need to correct the RecordSource query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form will be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Cathleen said:
Im new to access and I have been having problems with my text boxes in my
form. I am currently using Access 97 and I have text boxes that are
supposed
to be filled in with the First Name, Last Name and Employee ID but when I
run
the form it shows the FName, LName, and EmployeeID populated with just the
EmployeeID in all the fields. How do I fix it that it is populated with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
 
Cathleen,
Well, something is definitely amiss. There's no way that a field with a
ControlSource of [FName] can display the [EmployeeID] value.

What are the Names of each control on the form?
What are the ControlSources for each field?
What are the field names from your table?
Please post your SQL statement behind the report.
Is there any code that runs when the form opens, that relates to any of
the fields involved?

Let's try that for now. If still no luck, would you consider sending me
the MDB? (if it's not huge)
hth
Al Camp


Cathleen said:
I did what you suggested and it still shows the Employee ID, what else can
I
do, why wont it show what is in the control source... I would be grateful
for
any more suggestions.
Thanks!

AlCamp said:
Cathleen,
In Design Mode, place your cursor in the FirstName control. Find the
ControlSource property for FirstName, place the cursor in that property,
and
use the little arrow on the right to drop down a list of available fields
you can use for this ControlSource. IF [FName] (or whatever your table
field name really is) is not on the list... then you haven't included it
in
the query behind the form. You'll need to correct the RecordSource query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form will
be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Cathleen said:
Im new to access and I have been having problems with my text boxes in
my
form. I am currently using Access 97 and I have text boxes that are
supposed
to be filled in with the First Name, Last Name and Employee ID but when
I
run
the form it shows the FName, LName, and EmployeeID populated with just
the
EmployeeID in all the fields. How do I fix it that it is populated
with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
Click to expand...
 
Good afternoon

If your record source does in fact contain First Name, Last Name and Employee
ID, and the appropriate text boxes are bound to the fields, then they have to
show the appropriate information.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
I will try and answer all your questions the best I can, Im sorry I dont know
what things are quite yet.
Here is what I have,the Form is called Inventory Transactions:
Supply Request/Order From Vendor...CS... Supply Request/Order From Vendor
Transaction Date...CS...Transaction Date
Product Item Number... Control Source...Product Item Number
Transaction Description...CS...Transaction Description
EmployeeID...CS...EmployeeID
First Name...CS...First Name
Last Name...CS...Last Name
Product Description...Product Description
Units Requested...UnitsRequested
Invoice Number...Invoice Number
Reference Number...Reference Number
Units Ordered...Units Ordered
Units Received...Units Received
Units Backordered...UnitsBackordered
Discontinued...Discontinued
Unit Price...UnitPrice
My SQL Statement(RecordSource) is: Inventory Transactions
The code when I open the Form is:
Private Sub First_Name_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub LastName_BeforeUpdate(Cancel As Integer)
End Sub
This Database is huge, and I have had people in my office look at it and
they cant understand why it's doing this, it acts like it is completely
ignoring the control source, I can even select other fields and it displays
correctly. It just doesn't display the first name and the last name.
This has been a very weird experience trying to use Access without the help
menu, and only knowing enough to be dangerous.
Thank you so much for trying to help me..
Cathleen



AlCamp said:
Cathleen,
Well, something is definitely amiss. There's no way that a field with a
ControlSource of [FName] can display the [EmployeeID] value.

What are the Names of each control on the form?
What are the ControlSources for each field?
What are the field names from your table?
Please post your SQL statement behind the report.
Is there any code that runs when the form opens, that relates to any of
the fields involved?

Let's try that for now. If still no luck, would you consider sending me
the MDB? (if it's not huge)
hth
Al Camp


Cathleen said:
I did what you suggested and it still shows the Employee ID, what else can
I
do, why wont it show what is in the control source... I would be grateful
for
any more suggestions.
Thanks!

AlCamp said:
Cathleen,
In Design Mode, place your cursor in the FirstName control. Find the
ControlSource property for FirstName, place the cursor in that property,
and
use the little arrow on the right to drop down a list of available fields
you can use for this ControlSource. IF [FName] (or whatever your table
field name really is) is not on the list... then you haven't included it
in
the query behind the form. You'll need to correct the RecordSource query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form will
be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Im new to access and I have been having problems with my text boxes in
my
form. I am currently using Access 97 and I have text boxes that are
supposed
to be filled in with the First Name, Last Name and Employee ID but when
I
run
the form it shows the FName, LName, and EmployeeID populated with just
the
EmployeeID in all the fields. How do I fix it that it is populated
with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
Click to expand...
 
Cathleen,

If the 3 fields we're discussing in your table are: EmployeeID, First
Name, and Last Name...
And the 3 fields on the form have a RecordSource of EmployeeID, First
Name, Last Name...
And... given that I can not actually "see" MDB then I can only offer
these suggestions...

1. What happens when you just open the InventoryTransactions table in
datasheet view... (not using the form)?
Does EVERY (and I do mean every!) record contain the right values for
EmpID/FN/LN??
Is there any chance someone may have entered EmpIDs in the FN and LN
fields in several (or many) records, by mistake, and they happen to be the
records you see when you open the form?

2. Using the form, does EVERY (and I do mean every!) record display
the EmpID in place of LN/FN? I think you said all the other fields on the
form are correct??

3. Compact and Repair your tables... I've seen that cause really
strange stuff. Back up your stuff just in case, but Compact and Repair is
well worth the try.

That's all I can suggest without seeing the MDB. If you have some
hidden or obtuse code somewhere that's causing this problem, there's no way
we can determine that via email.

What version of Access are you running?
Is your application Split? (ex. DATA.mdb and PROGRAM.mdb)?
If you Compact your MDB AND Zip it... what is the size/s?
I can accept up to ~8MB files in my email...
I develop Access applications for a living... your information would be
confidential.
If you think sending me the MDB is viable, please post back your real
email (cryptically encoded in some fashion) and I'll contact you "off-line".

Try today's suggestions, and if that doesn't work, I'm afraid that's all
we can do for now.
hth
Al Camp

Cathleen said:
I will try and answer all your questions the best I can, Im sorry I dont
know
what things are quite yet.
Here is what I have,the Form is called Inventory Transactions:
Supply Request/Order From Vendor...CS... Supply Request/Order From Vendor
Transaction Date...CS...Transaction Date
Product Item Number... Control Source...Product Item Number
Transaction Description...CS...Transaction Description
EmployeeID...CS...EmployeeID
First Name...CS...First Name
Last Name...CS...Last Name
Product Description...Product Description
Units Requested...UnitsRequested
Invoice Number...Invoice Number
Reference Number...Reference Number
Units Ordered...Units Ordered
Units Received...Units Received
Units Backordered...UnitsBackordered
Discontinued...Discontinued
Unit Price...UnitPrice
My SQL Statement(RecordSource) is: Inventory Transactions
The code when I open the Form is:
Private Sub First_Name_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub LastName_BeforeUpdate(Cancel As Integer)
End Sub
This Database is huge, and I have had people in my office look at it and
they cant understand why it's doing this, it acts like it is completely
ignoring the control source, I can even select other fields and it
displays
correctly. It just doesn't display the first name and the last name.
This has been a very weird experience trying to use Access without the
help
menu, and only knowing enough to be dangerous.
Thank you so much for trying to help me..
Cathleen



AlCamp said:
Cathleen,
Well, something is definitely amiss. There's no way that a field with
a
ControlSource of [FName] can display the [EmployeeID] value.

What are the Names of each control on the form?
What are the ControlSources for each field?
What are the field names from your table?
Please post your SQL statement behind the report.
Is there any code that runs when the form opens, that relates to any
of
the fields involved?

Let's try that for now. If still no luck, would you consider sending
me
the MDB? (if it's not huge)
hth
Al Camp


Cathleen said:
I did what you suggested and it still shows the Employee ID, what else
can
I
do, why wont it show what is in the control source... I would be
grateful
for
any more suggestions.
Thanks!

:

Cathleen,
In Design Mode, place your cursor in the FirstName control. Find
the
ControlSource property for FirstName, place the cursor in that
property,
and
use the little arrow on the right to drop down a list of available
fields
you can use for this ControlSource. IF [FName] (or whatever your
table
field name really is) is not on the list... then you haven't included
it
in
the query behind the form. You'll need to correct the RecordSource
query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form
will
be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Im new to access and I have been having problems with my text boxes
in
my
form. I am currently using Access 97 and I have text boxes that are
supposed
to be filled in with the First Name, Last Name and Employee ID but
when
I
run
the form it shows the FName, LName, and EmployeeID populated with
just
the
EmployeeID in all the fields. How do I fix it that it is populated
with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
Click to expand...
 
Al,
1. The form in the datasheet view shows the wrong information in FN and LN
2. I am the only one that is entering any information into the table right
now. I have the record source pulling from the Inventory Transactions table
and all the information is correct in there, so I dont know how it is pulling
the EmpID for FN and LN.
3. I tried to repair and compact and nothing happened.
I am running Access 97, and its not split.
I appreciate the offer to look at it but I could be fired if I e-mailed this
information, I am grateful for all your suggestions... Thank you for all your
help.
Cathleen


AlCamp said:
Cathleen,

If the 3 fields we're discussing in your table are: EmployeeID, First
Name, and Last Name...
And the 3 fields on the form have a RecordSource of EmployeeID, First
Name, Last Name...
And... given that I can not actually "see" MDB then I can only offer
these suggestions...

1. What happens when you just open the InventoryTransactions table in
datasheet view... (not using the form)?
Does EVERY (and I do mean every!) record contain the right values for
EmpID/FN/LN??
Is there any chance someone may have entered EmpIDs in the FN and LN
fields in several (or many) records, by mistake, and they happen to be the
records you see when you open the form?

2. Using the form, does EVERY (and I do mean every!) record display
the EmpID in place of LN/FN? I think you said all the other fields on the
form are correct??

3. Compact and Repair your tables... I've seen that cause really
strange stuff. Back up your stuff just in case, but Compact and Repair is
well worth the try.

That's all I can suggest without seeing the MDB. If you have some
hidden or obtuse code somewhere that's causing this problem, there's no way
we can determine that via email.

What version of Access are you running?
Is your application Split? (ex. DATA.mdb and PROGRAM.mdb)?
If you Compact your MDB AND Zip it... what is the size/s?
I can accept up to ~8MB files in my email...
I develop Access applications for a living... your information would be
confidential.
If you think sending me the MDB is viable, please post back your real
email (cryptically encoded in some fashion) and I'll contact you "off-line".

Try today's suggestions, and if that doesn't work, I'm afraid that's all
we can do for now.
hth
Al Camp

Cathleen said:
I will try and answer all your questions the best I can, Im sorry I dont
know
what things are quite yet.
Here is what I have,the Form is called Inventory Transactions:
Supply Request/Order From Vendor...CS... Supply Request/Order From Vendor
Transaction Date...CS...Transaction Date
Product Item Number... Control Source...Product Item Number
Transaction Description...CS...Transaction Description
EmployeeID...CS...EmployeeID
First Name...CS...First Name
Last Name...CS...Last Name
Product Description...Product Description
Units Requested...UnitsRequested
Invoice Number...Invoice Number
Reference Number...Reference Number
Units Ordered...Units Ordered
Units Received...Units Received
Units Backordered...UnitsBackordered
Discontinued...Discontinued
Unit Price...UnitPrice
My SQL Statement(RecordSource) is: Inventory Transactions
The code when I open the Form is:
Private Sub First_Name_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub LastName_BeforeUpdate(Cancel As Integer)
End Sub
This Database is huge, and I have had people in my office look at it and
they cant understand why it's doing this, it acts like it is completely
ignoring the control source, I can even select other fields and it
displays
correctly. It just doesn't display the first name and the last name.
This has been a very weird experience trying to use Access without the
help
menu, and only knowing enough to be dangerous.
Thank you so much for trying to help me..
Cathleen



AlCamp said:
Cathleen,
Well, something is definitely amiss. There's no way that a field with
a
ControlSource of [FName] can display the [EmployeeID] value.

What are the Names of each control on the form?
What are the ControlSources for each field?
What are the field names from your table?
Please post your SQL statement behind the report.
Is there any code that runs when the form opens, that relates to any
of
the fields involved?

Let's try that for now. If still no luck, would you consider sending
me
the MDB? (if it's not huge)
hth
Al Camp


I did what you suggested and it still shows the Employee ID, what else
can
I
do, why wont it show what is in the control source... I would be
grateful
for
any more suggestions.
Thanks!

:

Cathleen,
In Design Mode, place your cursor in the FirstName control. Find
the
ControlSource property for FirstName, place the cursor in that
property,
and
use the little arrow on the right to drop down a list of available
fields
you can use for this ControlSource. IF [FName] (or whatever your
table
field name really is) is not on the list... then you haven't included
it
in
the query behind the form. You'll need to correct the RecordSource
query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form
will
be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Im new to access and I have been having problems with my text boxes
in
my
form. I am currently using Access 97 and I have text boxes that are
supposed
to be filled in with the First Name, Last Name and Employee ID but
when
I
run
the form it shows the FName, LName, and EmployeeID populated with
just
the
EmployeeID in all the fields. How do I fix it that it is populated
with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
Click to expand...
 
Cathleen,
now. I have the record source pulling from the Inventory Transactions
table
and all the information is correct in there
Click to expand...

The data in the table is OK... that's what I needed to know.
Anything I can suggest beyond this would just be guessing.
Well, we tried...
Al Camp



Cathleen said:
Al,
1. The form in the datasheet view shows the wrong information in FN and
LN
2. I am the only one that is entering any information into the table
right
now. I have the record source pulling from the Inventory Transactions
table
and all the information is correct in there, so I dont know how it is
pulling
the EmpID for FN and LN.
3. I tried to repair and compact and nothing happened.
I am running Access 97, and its not split.
I appreciate the offer to look at it but I could be fired if I e-mailed
this
information, I am grateful for all your suggestions... Thank you for all
your
help.
Cathleen


AlCamp said:
Cathleen,

If the 3 fields we're discussing in your table are: EmployeeID,
First
Name, and Last Name...
And the 3 fields on the form have a RecordSource of EmployeeID, First
Name, Last Name...
And... given that I can not actually "see" MDB then I can only offer
these suggestions...

1. What happens when you just open the InventoryTransactions table
in
datasheet view... (not using the form)?
Does EVERY (and I do mean every!) record contain the right values for
EmpID/FN/LN??
Is there any chance someone may have entered EmpIDs in the FN and LN
fields in several (or many) records, by mistake, and they happen to be
the
records you see when you open the form?

2. Using the form, does EVERY (and I do mean every!) record display
the EmpID in place of LN/FN? I think you said all the other fields on
the
form are correct??

3. Compact and Repair your tables... I've seen that cause really
strange stuff. Back up your stuff just in case, but Compact and Repair
is
well worth the try.

That's all I can suggest without seeing the MDB. If you have some
hidden or obtuse code somewhere that's causing this problem, there's no
way
we can determine that via email.

What version of Access are you running?
Is your application Split? (ex. DATA.mdb and PROGRAM.mdb)?
If you Compact your MDB AND Zip it... what is the size/s?
I can accept up to ~8MB files in my email...
I develop Access applications for a living... your information would
be
confidential.
If you think sending me the MDB is viable, please post back your real
email (cryptically encoded in some fashion) and I'll contact you
"off-line".

Try today's suggestions, and if that doesn't work, I'm afraid that's
all
we can do for now.
hth
Al Camp

Cathleen said:
I will try and answer all your questions the best I can, Im sorry I dont
know
what things are quite yet.
Here is what I have,the Form is called Inventory Transactions:
Supply Request/Order From Vendor...CS... Supply Request/Order From
Vendor
Transaction Date...CS...Transaction Date
Product Item Number... Control Source...Product Item Number
Transaction Description...CS...Transaction Description
EmployeeID...CS...EmployeeID
First Name...CS...First Name
Last Name...CS...Last Name
Product Description...Product Description
Units Requested...UnitsRequested
Invoice Number...Invoice Number
Reference Number...Reference Number
Units Ordered...Units Ordered
Units Received...Units Received
Units Backordered...UnitsBackordered
Discontinued...Discontinued
Unit Price...UnitPrice
My SQL Statement(RecordSource) is: Inventory Transactions
The code when I open the Form is:
Private Sub First_Name_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub LastName_BeforeUpdate(Cancel As Integer)
End Sub
This Database is huge, and I have had people in my office look at it
and
they cant understand why it's doing this, it acts like it is completely
ignoring the control source, I can even select other fields and it
displays
correctly. It just doesn't display the first name and the last name.
This has been a very weird experience trying to use Access without the
help
menu, and only knowing enough to be dangerous.
Thank you so much for trying to help me..
Cathleen



:

Cathleen,
Well, something is definitely amiss. There's no way that a field
with
a
ControlSource of [FName] can display the [EmployeeID] value.

What are the Names of each control on the form?
What are the ControlSources for each field?
What are the field names from your table?
Please post your SQL statement behind the report.
Is there any code that runs when the form opens, that relates to
any
of
the fields involved?

Let's try that for now. If still no luck, would you consider
sending
me
the MDB? (if it's not huge)
hth
Al Camp


I did what you suggested and it still shows the Employee ID, what
else
can
I
do, why wont it show what is in the control source... I would be
grateful
for
any more suggestions.
Thanks!

:

Cathleen,
In Design Mode, place your cursor in the FirstName control.
Find
the
ControlSource property for FirstName, place the cursor in that
property,
and
use the little arrow on the right to drop down a list of available
fields
you can use for this ControlSource. IF [FName] (or whatever your
table
field name really is) is not on the list... then you haven't
included
it
in
the query behind the form. You'll need to correct the RecordSource
query
for the form and include FName field.
If it is displayed in the list, then select it.
Now... what the user enters in the FirstName control on the form
will
be
stored in the FName field of your table.

Do the same for LastName on your form with [LName]

hth
Al Camp




Im new to access and I have been having problems with my text
boxes
in
my
form. I am currently using Access 97 and I have text boxes that
are
supposed
to be filled in with the First Name, Last Name and Employee ID
but
when
I
run
the form it shows the FName, LName, and EmployeeID populated with
just
the
EmployeeID in all the fields. How do I fix it that it is
populated
with
the
correct information.
Thank you in advance for your time and patience!
Cathleen
Click to expand...
Click to expand...
Click to expand...
 
Back
Top