911 - CANT ADD A FIELD TO AN EXISTING DATABASE

[Guest]

I HAVE A DATA BASE THAT I CREATED ABOUT A MONTH AGO, AND AFTER ENTERING
INFORMATION IN THE DATA BASE, I DECIDED THAT I NEEDED ANOTH BOX. (IN FORM
vIEW) SO I OUT ONE IN, BUT IT WONT LET ME TYPE IN IT. I GET AN UNBOUND ERROR.
AND NO MATTER WHAT I TRIED I JUST CANT SEEM TO FIGURE OUT. AND AFTER 3 DAYS
OF MESSING WITH IT MY BOSS IS GETTING ANNOYING. (WITH WHEN IS IT GOING TO BE
DONE) PLEASE HELP. I CAN EVEN SEND YOU THE DATABASE IF YOUD LIKE.

TINA BEARD

 

[Rick B]

First, please turn off the CAPS lock.

Did you add the field to your TABLE? You can't add it to the form until it
is in the table. In mostt cases, your form would be based off a query
(which is based on the table). If that is the case...

Add the new field to your table. Then add it to the query. Then add it to
your form.

Rick B

 

[Dan Artuso]

Hi Tina,
First, some advice. All caps is considered to be SHOUTING and it's also very hard
to read.

If you want to add a new text box to your form, and have it save what you type into
the table, you have to set it's Control Source (look on the control's properties sheet)
to the field in your table. This is known as 'binding a control to a field'.

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi Tina,

check if your textbox control source property is pointing to a valid field
in your table.

 

[Guest]

Sorry about the caps, its a habit- (we have to type every thing in caps at
work. but i will give these a try and get back to you.

 

[Guest]

again, sorry for the caps. this did help very much, now one more question can
i get some columns to automatcally add up in to one field for say like i
have freight, labor, truck supply, mileage, and i needed them to total in one
box?

 

[Micah Chaney]

Yes, create a Query and bring down the fields you want sums of.

From the File Menu | View | Totals
Change the GroupBy's to Sum's

You can filter which records you want added or just add all records. You
can also put these Totals on your Form. When you create the new fields in
your Form make sure you point the Control Source to the Query with the
Totals.
Hope this Helps.

 

[Dan Artuso]

Hi,
Use something like this for the Control Source of the text box:
=[freight]+[labour]+[mileage] + [truck supply]