Recent content by DAPPLE

Oh, one more thing... where exactly am I suppose to enter this formula? on the properties tab somewhere I assume.. overlook the ignorance. In the control source, with expression builder? once again, I appreciate any help.

Thanks, I'll print your response, try to digest it... and see if I can put it to work. Anything to make my job easier - I love. Thanks again!

I have a form created from a table which was created from a query in access... hope I'm getting the terminology right. Any the db is related to payroll. Is there any way I can fill in a field with a payroll code of B5Z, which will automatically fill in the relating fields such as: Payroll Coord...

I have a report, which is based on a query. I don't know how to 'find' a particular record. I have to do it the hard way, by going into the query, finding it, then back to the record to find it so I can print it. I have a lot of records in this report, needless to say it is very time consuming...

I have a query based on about 10 different tables. One table 'basic' has about 1250 employees on it, the other tables relate to their benefits and salary information (these other tables only have about 1150 records of data). My final query shows the 1150 records, where are the others from the...

I have a report with many fields, a few fields display salary/earning information. Is there any way I can hide this information on a select few reports (for salaried employees indicated by a particular field in the report)? The salary information is confidential and cannot go out to the field...

Another way of putting a border around your field is by clicking the linecolor in the toolbar from transparent to black, or color of preference.

I looked at your sample, and it's too vague. If you have more details, just didn't send for confidentiality - then good. Now, I'm not a pro at access, but I love excel. What I'd do if I were you is put finishing touches on your spreadsheet. Add columns (total paid, total past due, days past due)...

I have a main report, with employee information... and added a sub report with dependent information, using the ssn as primary key. However, with some of the records it links by last name giving Mr. Jones 20 kids. In other records, it matches the ssn's perfectly even if the step children have...

I HAVE TWO - THREE BLANK PGS BETWEEN EACH RECORD ON MY REPORT WHEN I PRINT IT. IS THAT BECAUSE I SET IT UP WITH A SUBREPORT, AND IT AUTOMATICALLY ALLOWS 5 PGS OF CHILD INFO (BLANK IF NONE) PR PARENT ??

THANKS SO MUCH!

How do I format the field to show number as a SSN with dashes? Please and Thank You!

Thanks for the help Pat. I'll try the sub feature on the report. See how that goes. Hope you don't mind if I holler again later?!? Sure appreciate you, D. Apple

If I use a subform, will the details show on the main form so that I only have to print one pg pr record?

Help - I have a report with many records. But when I tell it to print, it prints the first record over and over. What should I do?? Thanks!