Search results

I am building a database to hold all employees resumes. I have 6 tables; "Employees", "Awards", "Education", "Certifications", "Training" and "Experience". I have created a report that contains subreports for each table that allows me to print something that looks like an employee resume...

That example is a bit extreme but did help a little. I found that if I type Like "*" & [Degree Type] & "*" in the "criteria" box for the column I want to search in then a dialog box will display and I can type what I need. Searching for "psy" returned records containing "psyshology" and "BS -...

I have a query that when opened, opens a dialog box to type in what I am searching for. The problem is that I need to type in exact value in order to retrieve the record. Ex, if a field contains "BS - Psychology" and i search for "Psychology" then I will not retrieve that record. I must search...

I have a report that spits our several fields from a query. How can I add a button on the switchboard that opens a dialog box and allows the user to type in a keyword and then opens the report for all records that contain the keyword anywhere within the entire query?

I believe the answer is that I want hide individual controls when that field has no data. Lets say a form has 3 labels and text boxes: Name University Graduation date I want the report to look like: Name: John Doe University: Lamar University Graduation date: 8/1/2006 If there is...

I am trying to hide lables and text boxes if there is no data entered to be shown. I have sucessfully done this, but my report now shows a gap or hole where the label and text box would be if it were visible. Is there a way to get rid of the hole?

OK, I partially got it. The "can shrink" property set to yes wasen't working due to the control layout. Once I removed control layout then the empty text box dissapeared in the print preview. I then deleted the label and created another text box and binded it to an expression...

Ok, all three of you lost me. :( I do not do this on a daily bassis so im not that skilled in Access. I do have an Access 2007 book "The Missing Manual" but I do not see the answer I need. Microsoft should have added a control labeled "hide field and label if its empty and move everything below...

Joao, I am having the same issue. I looked at the link you posted but do not know how to perform the function mentioned. How did you get the results you needed?

Scratch that last post. I got it to work. I now see all records in the query that are in the employee table even if an employee is not in the awards table. Thanks!!

The relationships and joints are similar to what I had. I tried several different adjustments to no avail. I still onyl get 2 people in the guery that have data entered in all tables.

I am running Access 2007 and have a report pulling data from a query in which a record may have several fields that are left empty. I need the report to display only fields that contain data and leave off the empty fields and labels that go with them. All lables beneath would also have to be...

Currently I have a querry pulling employee data from several tables (experience, education, awards, etc...). My problem is that if a record (employee) is on the experience and eduation tables but has no awards and is not on the awards table, then they will not be displayed in the query. I would...