Search results

Hi, I have a query that prompts with a parameter box for the field Contributor_ID. Contributor_ID is a numeric field & Key and I use it to allow the user to print a report based on which Contributor_ID value the user enters. This works fine. However, I would like the user to have the option...

I am trying to print the & character on a report but it does not display. It is a Label box that I want to display Systems & Sensors on but it prints without the & character as Systems Sensors My guess is the & is a special character in Access but is there a way to turn that off and it...

The statment below worked for me in this database while the database was in Access97. Now that I've converted the database to Access2000, this query no longer works, I get the message: Undefined Function 'Left' in expression. SSN...

I currently have an iif statement that creates a value in a new field name based on a value in an existing field name. Example: SELECT [EMRB MASTER].LMPID, [EMRB MASTER].[Last Name], IIf([EMRB MASTER].[SPMES Promotion]=-1,"SPMES") AS CURRJOB FROM [EMRB MASTER]; if the SPMES Promotion field...

I have a form with 6 different Job Code fields on it. Each field is a check box, each is a field in the employee table. Each time a person gets promoted, the next Job Code field gets a check mark but the prior check mark still contains the check along with promtion date, amount, etc. I want to...

I have a query where I calculate the Annual Contribution Amount with the following statement: Annual$: ([Current DEDUCTION]*52) With my query, I also want to select only those records that have a calculated amount greater than the amount I will enter in a parameter. I normally enter a...

Here's my scenario: I have a query that randomly selects a record from an Employee Table for a prize drawing. This query is the source for a report that prints out a pretty "your the winner"document. All of this is working well. However, what I'd like to do and can't figure out how is: For...

I created an Access97 report that is printing a blank page after every page of data. Actually, there is a small symbol on each blank page but the symbol is not on the keyboard for me to show here. Any ideas on what is creating the extra page to be printed? Thanks. Tom

I have an entry for that when started displays the first record in the table. I have to hit the "new record *" key to get a blank screen with my autonumber displayed. How do I get the form to go immediately to the new entry, autonumber state? This will save a step for my user. Thanks for the...

I have a form with numerous data fields on it. When I click on a checkbox field, I automatically open a second form for additional data entry. I want to pass some of the fields (SSN, Name, EMP#,etc.) onto the second form. The problem I'm having is the data being passed to the second form is...

I have created a report that lists information on all the people in the company. I want to add a box that prompts the user to key in a certain department code and only report for that department. How do you do this? I see another report in the system that does this but for the life of me, I do...