Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Datathumper

    Problem with subform

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

    Problem with subform

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

    Problem with subform

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

    Problem with subform

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

    Problem with subform

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

    Problem with 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...
  7. Datathumper

    Reports CAN GROW function

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

    Reports CAN GROW function

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

    Audit Trail

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

    Database Corruption

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

    Database Corruption

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

    Display status meter while report compiles...

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

    Running total by month

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

    Running total by month

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

    Running total by month

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

    Running total by month

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

    Running total by month

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

    Running total by month

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

    Dynamic filtering of a form

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

    Dynamic filtering of a form

    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?

Part and Inventory Search

Back
Top