Search results

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!

I'm trying to create a query between two tables and I keep getting this error that 'one of the tables is not related to the other and that I need to edit the relationships. I checked the relationships and deleted them all to start from scratch. Same error. I'm using ssn as primary key, both...

How do I sort by field in design view of my table, I want this to reflect in the form. Please and Thanks

Thank you! I'll try that when I get back to working on it.

I was trying to export my table to excel and got this message - cannot update, database or object is read only. What does that mean? I need to be able to get it to excel format. Thanks in advance for your help, love this forum.

I think you go to tools, then options, then keyboard, then look at the "moove after enter" section. Choose the option you want.