Search results

Thank you so much for your quick reply. I realize the spaces were not the best thing in the world. I'm getting better at this all the time thanks to help from people like you. Where is the Beforeupdate event? Is that in the command button? I'm looking in the properities and the VBA code and...

Sorry. I left off the database. It is attached below.

Hi, I have form which has a subform and a command button that enters records. What I'm looking to do is not allow the record to be updated unless the difference between two fields = zero. I have attached a zip file of the database. The form is called BOL information. The two fields in...

I was able to get it to work. It was werid. I was using the expression builder and access didn't like that. When I typed in the code similar to that in the Northwind database it worked. Odd. Anyway, thanks for all your help. Eddie.

Thank you Craig. I realized before I got your reply that I needed to create a subform. You know anything about getting subtotals to work? I have the subform working but now I want to make sure there is some validation on the sheet. I have another thread going if you want to look. Thanks...

I attached the updated verision of the database. It seems the subtotals are now working in the subform. I put the text box in the footer of the main form that should give me the subtotal as I go along. I'm not sure what I'm doing wrong. It's really driving me crazy. Thanks Eddie.

I thought I did that. I'm just noticing now that I didn't. How do I do that? Thank you for your quick reply.

Hi, I have a attached a zip folder of my database. It is has a form that has a subform. The form is named BOL information. I have a subtotal in the footer of the subform and a text box in the main form pointing back to it. What am I doing wrong? It seems right. I'm looking all over the...

Hi, Access newbe here. I have a problem and I hope someone can point me in the right direction. I have a table that has three fileds (more actually but the theory should be the same). They are: 1-Unique #. This is a number that will be unique to this record. It can be repeated in table...

Thank you for your reply Bob. I will look into your suggestions. That is exactly why I come here. You and others on here know the answers to questions I'm not experence enough to ask yet. You probaly just saved me a ton of time in the future. I hate "band-aid" and "work around" solutions...

Thank you so much for your reply. I put the brackets in. I'm getting an error on the Cancel = True portion. It is highlighting the Cancel and = part of the line. It is telling me the variable it not definded. Which variable do you think I should stick in there? Thanks Eddie.

Hi, I'm having an issue with getting some code to work. I have a form that has a command button that updates a table. The code is listed below: Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Exit_Add_Record_Click: Exit Sub...

Hi, I'm new to access but picking it up pretty well. It is a great toy. I'm building a database (attached in a zip file) and an entry form to populate the database. The issue I'm running into is with the Vendor Invoice # fields. There are 15 seperate fileds and I don't want to be able to...

Got it. I'll make sure to do that more in the future.

Oh, one other thing. I was reading in your sig i should click somewhere if someone helped me. Where should I click for you?

Thank you so much Bob. That worked perfectly. I can't wait until I have this program down cold. The learing process is fun though. Eddie.

Thank you so much for your quick reply. I'm sure that code works great but I'm not sure where to put it. I have stuck it in a couple of different places but nothing seems to popluate the field with the BOL Date plus 30. Where would you suggest I enter the function? Thanks Eddie.

Hi, I'm new to access but picking it up as fast as I can. I'm putting together a form and was wondering if someone could help with the validation on one of the fields. The two fields in question are BOL Date and ETA. BOL Date is a regular date (02-02-07 for example). I'm looking to add 30...

Various ones. I'm getting "expects =" sometimes and other systax errors. It seems to me the code should fit in there somewhere but I'm not sure where. Am I barking up the wrong tree? Thank you for your reply. Eddie.

Hi, Below is the macro that has been recorded in access: Option Compare Database Option Explicit Private Sub Add_record_to_database_Click() On Error GoTo Err_Add_record_to_database_Click DoCmd.GoToRecord , , acNewRec Exit_Add_record_to_database_Click: Exit Sub...