Search results

In that case I think someone else in the database, is doing something that relies on that query which is modifying the querydef. I will look into it :-)

Hi Guys, Thanks for the replies. The reason as far as I can tell for the report becoming empty is when the query changes from: SELECT * FROM SAM becomes SELECT * FROM SAM WHERE EventNo='123456789' So the problem is not that I need to test for a empty report, but WHY is the query being...

Hi All, I have a button on a form which emails a report based on the current record. This works, but occasionally (for a reason I cant yet pin-point) the next time you go to email a record the report is empty. When I look at the underlying query I find that it has been modified. For example...

Yeah about 5 minutes after posting I found current event - but it was still awaiting moderation! Thanks

Thanks for the replies guys. Yes it is a mainform. If the user ungracefully exists Access (Im thinking those who just click the cross to exit access) will it still trigger the form unload event? Cheers -Al

Hi Guys, I want to enable/disable certain controls on a form depending on other values of controls on the form. Initially I thought I could trigger off the on load event, but this doesn't work as form controls do not have values set until after form loads, and sometimes this form is displaying...

Hi, I found a great way to get the current User ID and User Name for the currently logged on user and write to a table so I can keep a record of other users in the database. But how do I mark a user as having left the database - what is the triggering event? Cheers -Al

Thanks! It looks like a compact and repair of the backend fixed it! -Al

Whats even more strange is that I have copied the database to another PC for testing and when I open the form with the recordset on that computer it doesnt display a blank record first - it goes straight to the record with data in it. Very very odd. -Al

Hi The recordset is not empty, and the form correctly displays, for example 3 records returned, but initally the form is blank until you navigate to the "next record" when you see the first of the 3 returned. I assume this blank record the form "displays" is then entered as a record into the...

My SQL asks for records where SAMStatus is null. That is not the line however that is creating a blank record. The blank record appears to be created on the line: DoCmd.OpenForm "SAM Input", acNormal I stepped through the code, and it is after the form opens there is no record set, so it...

Hi All, I have got this horrible issue where when I open my form based on a record set, the first record is always a blank and it ends up entering a blank record into my database, even though the record set itself contains no blanks. Here is the code...