Search results

  1. skilche1

    Date of when Yes/No control has been checked

    OK, I understandnow. I had posted a tanks to YPMA for his help and getting the date to fill in when the Yes/No box was checked. You then suggested that I have it remove the date from the field in the even the user made the wrong decision on that particular tool. I had said that I wouild like...
  2. skilche1

    Date of when Yes/No control has been checked

    Sorry RL, I didn't follow your question in post #8. Maybe I need more coffee or something. lol Can you expand on that? Thanks
  3. skilche1

    Date of when Yes/No control has been checked

    Really, I just tried it and worked for me. Buttons as well as the date addition function. Do you have your macro set to "on"? I kow when when I didn't enable marcos, that has hapened tome as well.
  4. skilche1

    Date of when Yes/No control has been checked

    RL, If you go into the "Add Calibrated Tool" and "Assign User/Update Cal#/Add Comment" Forms, under the "After Update" for the Yes/No Field, you will this code: Private Sub Obsolete_AfterUpdate() Me.ObsoleteDate = Now() End Sub
  5. skilche1

    Lost My "No Duplicates" in a Field

    Hi MrB. Yes, I have tried that and it will not allow me to, which is why I amwondering if the alternitive method...
  6. skilche1

    Date of when Yes/No control has been checked

    The forms I'm looking into doing this is from the Main SB, to the "Add Calibrated Tool" and "Assign User/Update Cal#/Add Comment" fields. Also in addition, in another post I posted this AM, I am having an issue where I lost the (Yes (no Duplicates) for the Cal# in the tbl_ToolInfo table. If...
  7. skilche1

    Date of when Yes/No control has been checked

    Yes, I agree and was thinking of that yesterday. I'm not a coder so I amnot sure how that is written... lol
  8. skilche1

    Lost My "No Duplicates" in a Field

    OK, here is my issue that I just realized this morning. I have completed a database and it works great except for one issue. This morning as I was adding custom error messages to the a particular field that I do not want duplicate values, I see that I am able to. When I originally set up the...
  9. skilche1

    Date of when Yes/No control has been checked

    YPMA, I jsut wanted to let you know that your method works like a charm. Thanks again for your help.
  10. skilche1

    Date of when Yes/No control has been checked

    Thank you RainLover and YPMA, I will try both when I have a moment. I'll give you my input when I give it a go. Much appreciated. :)
  11. skilche1

    Date of when Yes/No control has been checked

    Hi, I've been working on a db for my department. I have completed it but when I demonstrated it to the higher ups (which was a big success), I got a request to indicate a date when a certain field has been changed. This field is a Yes/No control, which indicated when the tool was obsoleted and...
  12. skilche1

    Subform Not Showing Data, Query Is...

    Cool man, thanks. I'll go through this and learn from your correction. Thanks a whole lot man. I really appreciate your help... :)
  13. skilche1

    Subform Not Showing Data, Query Is...

    Tried that too with the same results... I've attached the db for your view if you wish to take a peek at it.
  14. skilche1

    Subform Not Showing Data, Query Is...

    Yes, I have tried that. Here is the code I've used in the OnChange for the Combo Box: ************************* MainForm: Dropbox (OnChange) Me!sfrmCal.Requery ************************* Funny thing, I started this at home last night and was working great with Access 2010. I'm at work now and...
  15. skilche1

    Subform Not Showing Data, Query Is...

    Hi All. Been a while since I’ve been developing a database and I’m having an issue where the I’m having an issue where I select from the combo box and the subform isn’t showing the related data. However, when I run the query, it shows the data. Attached is the screenshot. I did search for...
  16. skilche1

    Decimal to the proper placing not showing

    No I haven't, I've just learned to live with it. Help anyone?
  17. skilche1

    Question Serious Issue with Crashing

    Hi, not sure if anyone can assist here with databases that crash, but I need some assistance. I just about finished with this database when I need to tweak the report. When I open it up, go to "View Product", then select a product, the db seems to crash and I have no idea. I'm not using any...
  18. skilche1

    Decimal to the proper placing not showing

    OK, now this is weird. Never had this happen to me. I have all the setting set up correct in my table to show 3 decimal places. This field is related to another table with a list of numbers 24.000 to 96.000 (in 0.125 increments), which is showing correctly in Datasheet View. When I open...
  19. skilche1

    Filtering Between Two Comboboxes

    Never mind. Found that if I started form a blank Form, it actually works.
  20. skilche1

    Filtering Between Two Comboboxes

    OK, I need some help here. Have to admit, it's been a while since I last created a db. That said, I'm trying to perform an actions I have done once and cannot seem to duplicate. I have form with two comboboxes (on the main Form). I cannot seem to filter the Post size by product. Note pic...
Back
Top Bottom