Recent content by punter

Is there some kind of bump points (or whatever it used to be) that I could click for you?

That worked awesome. Thank you so very much. I'm getting better with VBA but not great at it yet. I knew it was something simple but it would have taken me forever to figure it out.

Hello everyone. I thank you in advance for your time. I think I have a little bit too much stuff in my code. I want an error message to pop up if the Carton Count or CBM is out of balance. Here is the code: Private Sub AddRecord_Click() On Error GoTo Err_AddRecord_Click If (Me.Cartons -...

Bob = the man!!!!! I was wayyyyyyyyyyyyyyyyyy off. Your formula works great. Plus, I can take it apart and figure out why it works. Thanks again Bob.

I didn't have a chance yesterday to attached the zip file. I have now. The form in question is named BOL_information_entry. The field with the formula is named ETA date. It seems like it should be working but it doesn't. Any thoughts on what I'm doing wrong are most welcome. I had to...

Thank you so much for your quick reply. I put the copied the formula and put it but it doesn't seem to be working. It returing a blank which is an improvement over the #Name? I was getting before. Is there something else I should be trying? Thanks Eddie.

Hi, I have a formula that I think should be working but isn't. =[BOL Date]+(qryTransitDays!TransitTime) I want to Add the BOL Date with the Transit Time from the Transit Days query. It is giving me a return of #Name?. Any thoughts on why? Thank you so much for you help. Eddie.

Hi, I have a field in form named ETA Date. I would like that field to have a formula in it but I'm not sure exactly how to do it in Access. The formula would be based off three other fields in the form. They are BOL Date, Port of Origin, and Port of Entry. I would like the formula in the...

Stupid (punching myself in the head), that is right Bob. You told me to set it up like that months ago. I took your advice but it was working so well I forgot that is how I changed it. Thanks for the quick replies. I got it now. Eddie.

Hi, I'm having a little problem with one of my forms. I have a table called BOL_Entry and I just added a new field in there named Carrier. I want to add a text box onto a form called BOL_Entry for the Carrier field. When I got to the drop down choices for that text box Carrier is not an...

Oh yeah, that makes sense. I didn't think about that. Thanks much. I know what I have to do now. Eddie.

Hi, I have a query that is run off a form. When the query opens up there is a field you can enter data into. Once you close the query the data saves into the proper place in the table. That all works great. I'm trying to make this as user friendly as possible. Instead of having someone go...

Thanks Rural Guy. I was about to start looking at this in about 30 minutes. You no doubt saved me a lot of time. Eddie.

Thanks anyway Link, I was able to work it out. You have helped me in the past (and I'm sure in the future) but I was able to trip across the answer this time. Eddie.

Oh yeah, that screen shot is not good. Let me see if I can get something else up there.