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

    Making fields visible after inputting data

    Thanks a bunch! We will try this tomorrow and hopefully this will solve our problem
  2. diggerbob

    Making fields visible after inputting data

    I have a form that I am creating where in the first field I input dollar value and the second field I input quantity. A third text box is used as a calculated field based on the first field times the second field. I have multiple sets of these fields on my form and all are invisible except the...
  3. diggerbob

    "MARS"

    Has anyone used the Christian Steven prgram "MARS" for task scheduling in Access? If so, what are your thoughts on using this and is it worth the investement? BobK
  4. diggerbob

    Date Picker

    Ian, Thanks, and will be looking forward to hearing from you. BobK
  5. diggerbob

    Date Picker

    MajP, I understand that I should do that but that data will be imported into the table from an excel sheet. The person using this has to export the data from a database into an Excel worksheet. Then in turn, import it into Access. This will be done on a monthly basis. The names in the access...
  6. diggerbob

    Date Picker

    Yes, I have got it working, and yes, I could kick myself... for not seeing that! I appreciate everyone's help on this. Bob K
  7. diggerbob

    Date Picker

    Ian, I will give your ideas a shot when I get to work tomorrow. Thanks Bob K
  8. diggerbob

    Date Picker

    ck1999, I know you said that you would be out of ideas but I would like you to take a look at the database. I have attached the url where it can be found. If that doesn't work I appreciate your helphttp://mysite.verizon.net/bobkinney/Warehouse.zip
  9. diggerbob

    Date Picker

    ck1999, No, it still doesn't work, it just doubles the # sign in the error message. I hope by tonight, getting this up and available on line but will let you know. Thanks, Bob K
  10. diggerbob

    Date Picker

    ck1999, I tried the change but I get compile error messages at the # signs around the word #"And"# PH, Tried your suggestion but doesn't work either.
  11. diggerbob

    Date Picker

    ...[Accrual Table].[Receive To ID], [Accrual Table].[Qty Received (UOP)], [Accrual Table].[Original Unit Cost], [Accrual Table]![Qty Received (UOP)]*[Accrual Table]![Original Unit Cost] AS [Received Total], [Accrual Table].[Item Total], [Item Total]-[Received Total] AS [Amount Not Received] FROM...
  12. diggerbob

    Date Picker

    Actually, the error is popping up in Visual Basics
  13. diggerbob

    Date Picker

    PH, I should have explained my problem more clearly. I cannot find where this query expression is. I have only one table, I did a query from this table, and then did a report from that query. That's all I've done and the date picker should work, but doesn't.
  14. diggerbob

    Date Picker

    I have used a date picker which uses a calendar on my form for sometime now and have no problem with it. I copied this to a new database that I am starting for someone else at work but every time I try to run it, I get the following error message: Run-Time Error '3075', Syntax error (missing...
  15. diggerbob

    Count Function on Date Field

    I have a report that I use that shows my natural gas usage per day. I also have to show how many days per month it was used. I have a count function set on the report but recently I have came across a problem. There will be days that we shut down and start back up on the same day, maybe even 3...
  16. diggerbob

    Summing Time Fields

    chazgaz, I believe I put this formula in a control on my report rather than in the query but I will double check on Monday when I return to work and let you know for sure. Thanks for your help also Leslie. Bob
  17. diggerbob

    Switchboard Wizrd

    Is there any way that the amount of buttons on each page of the switchboard wizard can be increased without having to design a custom switchboard? Access only allows you to have 8 buttons per page. I'd appreciate some help. Thanks, Bob
  18. diggerbob

    Summing Time Fields

    Thanks for all the help Skip and PH. The solution works great! I am slightly more than a beginner and am learning on my own. Hopefully when the company hires me on as a permanent employee, I want to take some Access Classes. I like working in it but it can be a little mind boggling. Again...
  19. diggerbob

    Summing Time Fields

    Skip, No, my run times will never go over 24 hours in any given row. Only when I want to see the total for the month. Your help is much appreciated. I will try this tomorrow to see how it works. Thanks, Bob
  20. diggerbob

    Summing Time Fields

    Skip, I forgot to send you the formulas in my controls on my report. The one control was =Sum([System1RunTime]), the other one was this for an average of =Avg([System1StopTime]-[System1StartTime]). They do not calculate correctly. thanks bob

Part and Inventory Search

Back
Top