Search results

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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