Search results

I have a simple report which pulls data from a query. The query prompts the user to enter in a variable (route number) and it then displays the data; hence, when the report is run, it prompts the user to enter in the variable. This all works correctly; however, my dcount function doesn't...

I resolved the problem...it was in my code, thanks!

Its always that easy, isn't it....thanks for my oversight!! :)

I have the following code: Private Sub Command23_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim CTotalPointsEarnedVariable As Integer Dim HTotalPointsEarnedVariable As Integer Dim ATotalPointsEarnedVariable As Integer Dim MTotalPointsEarnedVariable As Integer Dim...

This hopefully is an easy question for you guys :) My problem is this...I have a lot of code on a command button. One portion is it divides one field by another field. this works correctly; however, it is rounding stuff and I'm unsure what to do about it...here are the examples: 100/10=10...

Thanks for all of your help on this one...its running very smoothly now :)

I currently have the following on my command button: Private Sub cmdSubmit_Click() If D1EntreeOrdered.Value = 5 And IsNull(D1OtherChicken.Value) Then MsgBox "Enter a Value for Other Chicken", vbCritical, "Required Field" Cancel = True Exit Sub End If If M6Carbonation.Value = 1 Or...

Genius...pure genius, I love it and it works perfectly!! You can also place it on a command button to run it, it doesn't have to be on the before update action; but, it can't be on the after update as stated earlier...my button is a submit button which runs this, cancels if there is an error...

That is exactly what I am looking for; however, it doesn't work correctly. The msg box says "You must complete the required field '' before you can continue" Any ideas?

that works awesome!! Do you think there is a way to customize the message being sent to the user? Meaning, instead of a general one, could I somehow place a variable in there to display which one inparticular isn't filled in?

If I place all the code on a command box for the on click command, it still produces the error and shuts down the database. If, however, I have a "dummy" cmd button on a seperate form with the exact same code, then it works fine...any ideas on how to fix / a workaround for this?

Thanks for the suggestions guys! I like having the exit sub portion to the code, that answered one of my future questions. However, I am still getting the same problem. It is on one of the if/then statements...regardless if I have 20 or 1, this particular one always causes my database to...

I wish to have a message box pop up if I have a field that is left empty...I am able to do this through vba code with the following: If IsNull(P3Temperature.Value) Then MsgBox ("Enter a Value for Cold Side Item Temperature") Cancel = True End If However, once I get to around 20 of those, my...

That did the trick..thanks a ton!

I wish to have a msg box pop up to the user if my text box is null, and hten cancel the update...else, have it run as normal. here is my current code: [code] If Me.txtStoreID = Null Then MsgBox ("Hey") Cancel = True End If It updates the record if txtStoreID is null, and it isn't popping up...

it all works great..thanks a ton!

sweet! so far so good!!! It works for one of my if then statements...now, I am going to put the other 20 in, and place it in my form, and i'll get back to make sure everything works correctly...thanks a ton!!!

unsure I am unsure on where to put this code...I placed it on a command button and tried to compile, but received the following error: Compile Error: user-defined type not defined The following is the code I currently have: Option Compare Database Private Sub Command2_Click() Dim dbs As...

haha Oh, its horrendous..but I can't really think of any other way to do it. I am making a scantron form and putting it into an access database to put the data online...will save my company a ton in shipping and the forms alone; however, the way the form has been in the last 5 years is...

I have a series of 20 if then statements I wish to run per record set...My current code works fine for one record setl; however, I wish to have it run for all of my records...here is a sample of one of the if then statements (they are all the same, just diff. fields) If P4Fresh.Value = 1 Or...