Search results

Hi, I have a main form which has a subform with another subform in it. Subform 1 gives details of a loan and a balance field which is calculated in subform 2 after amt paid is entered - using a macro on exit. If the balance is zero after amt paid is entered. I want the amt paid field in...

Hi, I have a report which pulls data from a query. I have a checkbox field in the query and I want to be able to show only those records where the check is "Yes". I did some code to hide the fields on the report, but even though it hides the fields, it still adds to the grand total. (The...

Hi, I have a form which opens with a 'go to new record' macro. I also have navigation command buttons in the form footer. If I press the back or previous button - I can access all past records. I want to be able to have the user enter a password before any editing can be done to the past...

Hi, I have a field in my query that displays the occupation of an employee. I have another field with an "if" expression, which displays the occupation if certain criteria is met. However, it displays the occupation ID and not the name. The occupation ID is an autonumber, but I just want to...

I ahve a table called occupation with 2 fields, one is ID (autonumber) the othet is occupation name. I have another table with job info from sun to mon - with 7 fields for occupation lookup. e.g. monoccup, tueoccup etc. I have a query and I pulled these fields into it, and the occupation names...

Hi All, HAPPY NEW YEAR! I have a 2 fields, one is start date in the format dd,mm,yyyy - the other is end date in the same format. I want to create a field in my query called "month" which will give the month for any record. This will be a parameter field. So that when I type in January in my...

Hi, I want to hide fields on a Payslip report which contain $0.00 I have read through similar cases which hide empty fields, but they do not work for me - maybe because the fields display a zero balance. Is there a way to do this Any help is greatly appreciated - and by the way I am a beginner!!

Hi, I have this table with job numbers stored by days of the week e.g. mon job, tue job, wed job etc. You can have the same job number everyday of the week or different ones. I have to get a report that shows JOB # ??? and all of the fields associated with it. I'm trying with a query, but...

Is there any way to either hide or change the form name that shows at the top of an open form - instead of renaming the form and all associated queries, reports etc. Maybe a cosmetic shortcut (wishful thinking here - bear with me). Thanx in advance..

I have a form created from a table and I had to use calculations in some of the fields to automate certain processes. Now, if I pull a report based on the fields in the table - I am getting all except for the fields with the calculations. Is there any way to update the main table - since most...

I have a report based on a parameter query which prompts for a trans#. It works fine, but is there any way to customize the "Enter parameter query" text at the top of the prompt box?

I have a database that I want to install on a client's pc as a demo only. I want to restrict the number of records he can enter to 3. Is this possible in access? I will appreciate any help. Thx!

I have a form with a subform which has a lookup table (combo box) as a field. I want to be able, when I select a certain item in the lookup to have it automatically open a form. e.g. A field called insurance class - I select motor, I want the motor details form to open. If I select Fire, I...