Maintaining data for a datasheet

finneyz

Registered User.
Local time
Today, 08:43
Joined
Dec 27, 2012
Messages
51
Going to ask a dumb question on here.
Brain fried for a day.

Trying to maintain Data for a datasheet
We are trying to maintain the data throughout the datasheet table. Meaning that

Field 1 Field 2 Field 3 Field 4
1111 Contract Apples Carrots
1111 Contract Soups Celery

Getting and Maintaining Field 1 & Field 2 to stay the same throughout the table.

best ways.
 
Are you just trying to avoid having to type the 1111 and Contract in the table fields each time you add a new record? Do you have other values that would also go into field1 and field2 besides 1111 and Contract? Or is your entire database going to keep those same values?
 
database will retain field 1 & field 2 the same throughout the table.
all other fields will either be combo boxes, input.
The fields are also locked so user input will not be able to change.
I dont want user input to change anyhow.
I dont want any user input to fields 1 & field 2
 
if field 1 and field 2 are ALWAYS both the same, you only need to store one of them. it is hard to see why fields 3 and 4 are both "products".

The table/database does not look to be properly normalised.
 
Yes, I agree with @gemma, the database does not sound like it is properly normalized, however if you must maintain those values you can do it in the datasheet.

Go to the datasheet form design view and then bring up the properties for each of the Fields 1 and Fields 2. Find the property called Default Value and set the value there. So you would put 1111 in the default value for Field 1 and Contract in the Default Value for Field 2. You can also set the Locked property of each field to Yes.

Attached is a screenshot.
 

Attachments

  • defaultvalue.jpg
    defaultvalue.jpg
    25.6 KB · Views: 84
haha I didnt see that. default value.
Thank you!
close this session pls
 
hmm Let me ask this,
Is it possible to put the default value on the table itself. Rather than the form
aka, [CONTRACT_TBL]![CONTRACT_NO]
I tried or attempted to put it in the default value box within the table. The one where data is being placed into
 
hmmm...not sure on that error. Are you sure that is an error or is it putting in that value in the table?? When do you get the error, just when trying to save the table after putting in default value? Or is this error in the form?
 

Users who are viewing this thread

Back
Top Bottom