Search results

What I have done for similar situations is to create a new menu(Toolbar), then have it selected and uncheck all other default menus in View-Toolbars-Customize. You can then drag your forms,reports etc. to your new menu. Hope this helps.

Thanks for you help.. but I did finally get through using conditional macros!

I realize that it is kinda tricky..but what expression or criteria do I use and where do I enter it?

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

Thanx, I used a filter in the form properties and it worked!

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

But I want the actual "month" name evaluated by both the "start" and "end" date

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

what do u mean?

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

U have been absolutely wonderful. Thank u, I will give it a go.

Job No can't be a primary key because many different employees work on the same job in the same pay period. Also.. each employee has a standard pay rate (hourly). I have to enter the number of hours each day in the three categories (std, x2, x3) representing the number of hrs worked. Their...

Yes - it's the construction industry

Hmmm... Well, what I have is an employee time sheet - I have a form with a tab control for all days of the week. For each day, I need to enter a job #, hrs worked at std rate, hrs worked at double time rate and hours worked at triple time rate. My "job" table looks something like: mon job no...

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

Thanks alot.. worked like a charm!! U Guys R Great!!!

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