Search results

Access 2010 Acrobat X Standard I have reports on both 11X17 and 8.5 by 11. When I convert the 11 X 17 to Acrobat, it changes the paper size to 8.5 X 11 on both the PDF and the print view of the report in access. If I set Acrobat to 11 X 17, it still does it. I'd appreciate some help if...

I have a report based on a query. There is a field in my personnel table and the query: [Field] with values from my lookup table and has three choices: 1-Inspections 2-Administrative 3-Safety I have a report and would like to filter based on [Field] I can filter by putting [Field]=Inspection...

I have a field SSEEndDate I have some records in which this field is empty. What I would like to do is add a comment to explain why the field is empty on a report if possible. Click on it or move the mouse on it or whatever and the comment would show up. If this possible?

I have a short date field 5/20/2014 I would like to set up a conditional format to format those fields in the current month. For example, this month is would format all fields with "5". Next month all fields with "6" In the month space. I can't seem to figure out the expression, I know...

I have a date field in my table using short date (Assessment Date). I want to keep that and add a field in the table that converts that same date to a day of the week. I'm trying to use a calculated field in my table (AssessmentDay) and can't seem to get the expression right. Can somebody...

I have several forms in a navigation form. On all the forms, the little search bar at the bottom shows # of 103 records. On my navigation form it shows 1 of 1 and won't allow me to search. It would seem that the search bar is only looking at the current form and not at the records. Can...

I have a table. One of the fields in the table is Aerial Lift. It is a check box. I have a query that includes many fields including the Aerial Lift Check Box. I have a report named Aerial Lifts. What I would like to do is have the report check the query for the aerial lift box and that...

I have fields with expiration dates. I am attempting to conditional format them to show a color when the date is 30 days or less from today. I have: Value<=DateAdd("d",30,Now()) It's working bit it's also formatting all of the dates that are 1/31/2014 for some reason. Not any other 2014...

I have 10 tables. None of them have any entries in them. Just field names. Is there a way to combine them all into one table.

Is there a way to insert a hyperlink in a field title on a table? For example, I have a field that is a check box for whether the person has taken a class. What I would like to do is insert a link in the field title for that class so I can click on it and bring up the supporting documentation...

http://office.microsoft.com/en-us/templates/desktop-time-and-billing-TC010222096.aspx I downloaded the above template. It looks like it will do exactly what I need to do, which is record several employees' hours against several projects. What I don't need is the billing information such as...

Access 2007. I have a report that includes the field Lead. It is in short date format in the table. I would like for a blank entry to fill the space on the report with a red fill. Not highlight, but stay red until a date is entered. I have read the instructions on how to highlight it, and...

New to the forum looking for help from time to time with Access. Thanks for all the great information.