Search results for query: *

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

I am using the information in the query for plotting on a graph. I am trying to calculate a percentage failure of welds over the course of the project. The welds failed needs to be divided by the total welds nde's to date. I am plotting by month so that there is a nice trended line shown...

The item that I need the running sum on is the welds nde. I need it to sum all welds nde'd up to the month that it is grouping by...not sure if this all makes sense or not. Here is the SQL statement SELECT (Format([DT],"mmm"" '""yy")) AS Expr1, Sum([qry_NDE Failures Job]![Welds...

Question for the pros. I am trying to create a graph based on a query where two fields are summed and then grouped by month. I need to have one of the summed fields by a running total by month instead. How would I go about this? THanks in advance.

Thnks for the alternate suggestion, but nope...same problem I have even tried [frm_main].Form![Mark No].Filter = "[Mark No] Like '" & Me![Combo6] & "*'" [frm_main].Form![Mark No].FilterOn = True [frm_main].Form![Mark No].Requery still the same error.... I do appreciate your assistance with...

I keep getting an error, "object doesnt support this property or method" and then it highlights the top row of the following: Me![Mark No].Form.Filter = "[Mark No] Like '" & Me![Combo6] & "*'" Me![Mark No].Form.FilterOn = True Me![Mark No].Form.Requery ANy ideas?