Search results

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...

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...

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

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

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.

Is there a way that I can see the whole form in form view? I can't find a zoom button. The way it is now, I can only see the top portion of the form, and have to scroll down with each record.

Is there any way to go back and get a field from a table that somehow didn't get included on the query?

Can tables be crossed over from one data base to another. There's information on a table in db1, that I need to add to a form that's in db2. Is that possible?

I had a great table 'comp master' which contained almost a thousand records. I used this table to query another table 'query2'. While in query2 I sorted data and deleted a particular company 400+ employees because I didn't need that particular co in the report. When I went back to comp master to...

I'm trying to make my form attractive, is there any way you can add a colored border to the outside edges? The drawing toolbar is unavailable.. I tried creating something in word and pasting it, any suggestions?

I have a table, most of it is populated..with exception of the Birth Date field. Instead of entering those dates manually on the table, is there a way to query them in using the social as primary key? All this information is to be reflected in the form also. Thanks for any help!

I have a table and a form, they both have the same name "comp master 2002", because I saved the table as a form. I don't know how to get into either of them without going through the start menu - documents. I tried going through program - access.. and it asks if I want to 1.blank access 2.access...

Somehow my field thinks it can only receive numbers. I compared the properties tabs to another field that will receive text, and they're both the same. What am I missing. This field didn't have any data from the orig table to determine whether to format text or numbers. Would greatly appreciate...

I have a form set up through a table. On this table I had information in the wrong column. I put the bonus percent instead of bonus amount in amount column. I would like to get that copied and pasted to the percent column so it will correctly reflect on the form. Does any one know how I can do...

Ok, I asked for advice on the combo box. I have used it successfully for those titles reflected in the "field list" box. However, I have a new field I want to add "regional division" (this should have about 8 listed). I don't know how to get that one going. I copied it from another field with a...