MS Access question

Suburban Rhythm · 10-24-2014, 01:48 PM

Excel I can do...access not so much. I know just enough to be dangerous.

Got asked to troubleshoot a form used in another department. For the life of me can't make any sense of it.

The form compiles training hours from hire date forward for all employees in the DB. When pulling up the first record, name, DOB, SSN, Hire Date all populate from the tables.

Training hours is not populating...or so it would seem. When printing /print preview, the total hours appears. But does not display in any view on screen.

From what I can tell, field is set up the same as the other fields pulling from tables and displaying OK.

Am I missing something obvious?

henry296 · 10-24-2014, 02:10 PM

There is a visible property that might be turned off which might allow it to show up on Print Preview but not the form.

Suburban Rhythm · 10-24-2014, 02:30 PM

Probably didn't explain very well

The field title and text box appear in form view. The value is not populating the text box.

However the value is populating in both preview and a hard copy.

henry296 · 10-24-2014, 02:48 PM

Quote:

Originally Posted by Suburban Rhythm

Probably didn't explain very well

The field title and text box appear in form view. The value is not populating the text box.

However the value is populating in both preview and a hard copy.

So in form view the text box border shows up, but with no value?

Suburban Rhythm · 10-24-2014, 04:26 PM

Correct

When tabing through records, the other details change. This field never shows a value.

But it is there, since it's viewable in print preview

weegeebored · 10-24-2014, 06:10 PM

Just curious. If you click into the Total Hours field on the form do you get a value?

HerRealName · 10-24-2014, 06:25 PM

Some possibilities from weird things I've seen:

Is this field in a sub form?
Are there multiple fields stacked up on top of each other on the form?
Is the field locked? (I think that's the term used, it's been awhile)

Suburban Rhythm · 10-25-2014, 04:32 PM

Quote:

Originally Posted by weegeebored

Just curious. If you click into the Total Hours field on the form do you get a value?

Nope. In fact since its a sum from another table, can't click in the field.

Quote:

Originally Posted by HerRealName

Some possibilities from weird things I've seen:

Is this field in a sub form?
Are there multiple fields stacked up on top of each other on the form?
Is the field locked? (I think that's the term used, it's been awhile)

Will have to explore these Monday.

10-24-2014, 02:10 PM	#2
henry296 College Starter Join Date: Oct 2000 Location: Pittsburgh, PA	There is a visible property that might be turned off which might allow it to show up on Print Preview but not the form. __________________ "It's a great day for hockey" - "Badger" Bob Johnson

10-24-2014, 02:30 PM	#3
Suburban Rhythm Pro Starter Join Date: Jan 2002 Location: Pittsburgh	Probably didn't explain very well The field title and text box appear in form view. The value is not populating the text box. However the value is populating in both preview and a hard copy. __________________ "Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!"

10-24-2014, 04:26 PM	#5
Suburban Rhythm Pro Starter Join Date: Jan 2002 Location: Pittsburgh	Correct When tabing through records, the other details change. This field never shows a value. But it is there, since it's viewable in print preview __________________ "Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!"

10-24-2014, 06:10 PM	#6
weegeebored High School Varsity Join Date: Sep 2006	Just curious. If you click into the Total Hours field on the form do you get a value?

10-24-2014, 06:25 PM	#7
HerRealName College Prospect Join Date: Dec 2002	Some possibilities from weird things I've seen: Is this field in a sub form? Are there multiple fields stacked up on top of each other on the form? Is the field locked? (I think that's the term used, it's been awhile)

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)