Search results for query: *

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!

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

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

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