Recent content by Datathumper

Perfect. That worked better than the temporary fix that I had come up with. Thanks for the help.

I also researched the .hasdata with no success. I am trying to avoid having to create fields in the subform table that I dont need just to avoid this problem. There has to be an easy way to ignor my if/then statement if the subform is unpopulated. I am just learning VBA so my knowledge is...

If [inst dcn tracking].Form![DCN issued] = True And [inst dcn tracking].Form![DCN complete] = False Then Me.Label402.Visible = True It is in the OnCurrent for the main form.

The error message that I get if there are no records on the subform is Runtime error 2427 You entered an expression that has no value.

The label is on the main form and the checkbox is on the subform.

I have a label on a form that I want to turn the visibility on/off based on a check box condition on a subform. It seems to work fine unless there are no records in a subform, then I get an error message. Is there a simple way around this. I am a pretty basic user, so I am sure that this is...

It works perfect!!!!!!!!!! Thanks a million.

Can anyone help with this one. I have a report where the fields are set to "can grow". I want to have the "excel" look (ie. each field has a visible border) when it reports. I would like to have all fields grow equally to the size of the larges one. Is that possible? Otherwize it produces...

Here is a question. Using the audit trail code, how could a person add a revision number to the changes. Basically, every time the data on a record changes, I would like to update the revision number (another field in the record) to notify users that someone has edited the data? Has anyone...

I have tried to import, but the database cannot be opened to do this. Even when I start a new database and then try to import from it. I can connect to the tables via excel however by "open with, excel". So I know that the data is still in tact. Unfortunatelly, its not the data that I am...

I know, I know always back up the database...I didnt. I had it on a USB disk and for whatever reason (more than likely improper removal of the device), the database has been corrupted and cannot be repaired by the compact and repair procedure. I have also tried the Jet4.0 compact utility from...

I have a report that crunches several queries before opening, and I would like to launch a form while it is openning that would display the status bar that is found at the bottom left of the screen. I would then like to close it when the report is finally produced. Is this possible?? Thanks...

.........scrap my last question, I found the solution. Thanks again for the awesome help.

It works almost flawlessly..!!!!!!!! The only other thing that I was wondering, right now it shows multiple values per month (as welds nde are entered daily). How could I format the grouping so that it gives a month summary instead of showing a plot point for every day that there was an entry...

I will give it a try and let you know...thanks for the code and the time spent..