Search results for query: *

Put this in the field: Total: =[Ttl Hrs]*[Rate] That should do it for you :)

I apologize for the confusion. I guess to re-explain my situation: The problem I was having, the gap being created, only occured when I created a report for a record # greater than 1. To further explain, to create the report there is a button on a form which simply opens it in preview mode and...

There are no actual records in the report itself; the main report is simply a placeholder for the rest of the subreports. I have semi-fixed this. I dunno how I did it but suddenly it stopped doing it as much. No change was done to the report itself so it leads me to think its a bug in access...

No, there is no code in the report themselves. The subreports are based off queries that contain basic SUMs etc but that shouldnt be causing this kind of error.

It is a single column report that consists of four subreports all contained within the "detail" section of the main report.

The detail section is the section that is causing it but I have no idea WHY it is happening. It seems the higher the record number the bigger the gap. What is going on, im stumped:(

I have several fixed controls in the form header part of a continuous form. The problem is when I am entering values into a new section in the continuous form, the values in the fixed controls disappear. They reappear if i go to something that has already been entered in the continuous form...

Here is my problem: whenever I create a report for a record other than record #1 there is a big gap (whitespace) between the header and detail section of the report. This does not occur for record #1 only 2 and up. Any idea why this is happening and how it can be fixed? Thanks!

Great tips from both of you. scriverb, actually there is nothing wrong with the queries. I was doing some reading and it seems that the requery commands at the end of it all was causing it. Found a better way to do it though; I decided to bookmark the record # then requery the whole and goto the...

Yes, I have been playing around with DLookup, but with no success. Here is the code I have been using that does not work: IIf(IsNull(DLookup("numFTEID", "tblTransFTE", "[tblTransFTE].[numTransactionID]=[numTransactionID]")), Forms!frmClients.cmdAddAssumptions.Enabled = True...

Can someone help me out with coding this form OnLoad event? I want to see if a certain record exists in the database and if it does disable a button that runs a query. If it does not exist then enable it. I also need this code for after the button is run. It will see if records exist if they do...

That works perfectly :) However, at the end of it all I get an error message saying "Application-defined or object-defined error." Nothing else. Any idea how to get rid of this final error? The queries run perfectly, dunno why its giving me this error. I am having a bunch of subforms requeried...

Is there a way to do this? I tried using the execute command but it says "Too few parameters. Expected 1". Any ideas? This is being executed when a button is clicked on a form

I need to keep all the graphics, lines etc that are in my report but I also need to be able to email this report to other people. Am I looking at a limitation of Access97 and will I have to upgrade in order to be able to do this? Thanks!

This code checks to see which FTEID it is currently on (performing calculations). Since I need this in a query I cant use If...Then or Cases thus it is a very nested IIF query and its giving me troubles. Can anyone see any major errors with it? Will this work at all? SELECT...

Thanks for you help Jon. What I actually ended up doing was adding another column in the TransAssumption table that was a yes/no column. I then made an append query that would simply insert all the different assumptions for each client. Not the most efficient way but it ended up working in the...

Which INNER JOIN should I be changing? I have tried changing them all but I am not getting the desired results. Thanks for your help so far!

This is my original code which selects all the assumptions that ahve not been chosen by the user: SELECT tblAssumptions .* FROM tblAssumptions LEFT JOIN tblTransAssumptions ON tblAssumptions.numAssumptionID = tblTransAssumptions.numAssumptionID WHERE (((tblTransAssumptions.numAssumptionID) Is...