Search results

Well I managed to get it working. I took a different approach. Instead of making the form based off the table, I made the form based off a query with just the material field listed. Then made the combo box from that query and the update worked. Now I just have to have get the combo box to...

Here is what comes out on the Immediate Window UPDATE tblMoldSetUpSheet SET tblMoldSetUpSheet.Material = 'Trial' WHERE tblMoldSetUpSheet.Material = '1428-2' The Set function is right but the Where function is wrong. The 1428-2 is the part number field, not the Material field. For some reason...

Yeah I seen the miss-spelling of the cmbCurrentMaterial. That was just a mistype on my part in the thread. It is spelled right in the code. I didn't notice any updates to the table when the event ran. Will try the debug print and see what it comes up with.. Thanks

I copied what you had and put in the on click event Private Sub cmdUpdate_Click() DoCmd.RunSQL “UPDATE tblMoldSetUpSheet SET Material = '" & Me.txtNewMaterial & "' WHERE Material = '" & Me.cmdCurrentMaterial & "'" End Sub I got a compilie error in VBE when I tried to enter the code...

Still getting a compile error, and it highlights the tblMoldSetUpSheet. The error says Expected: end of statement

Thanks.. Will give it a shot

Looking for some clarification on how to write some VBA code for a task I am trying to perform. I know this is probable covered numerous times on these forums, when I performed a search I did not come up with anything that was matching to my problem. The bad thing is that this is such a simple...

I kind of took the long way about this. What I ended up doing is putting this If statement: If (Running_Total >= PmCycle) Then MsgBox "Time for tool to be PM'd" End If In the OnExit event on each data field. I probable could have made a general statement, but I am just learning VBA and this...

Thats alright. sorry to hear about your loss though. I did manage to figure out my delimea though. Thanks for all your help

Still no luck

If I put that in the On Current event on the Form, once I switch records the message box will come up, but need to have the message box come up as soon as the Running Total is >= the Pm Cycle total. Thats where I am running into the problem.

Just tried it,, didn't work

I was thinking that too, but hope there is an easier way since that seems to have to write a lot of extra code for one simple task.

This seems to be something easy to do, but I have yet to be able to get it working right. I have a field called Running Total that automatically updates as it calculates numbers being put into other fields. When the Running Total is >= to a certain number I would like a message box to automatic...

One the main form I actually do have a button that is to print a report, but still doesn't to anything.

I did a search on the forums thing to find an answer to my question, but didn't come up with any answer that I could use. I created a database obviously, but the users will be running the database off of a Runtime 2003 verison of Access. I have been using full versions of Access for the past...

Never mind.. I figure out what the problem was.. thanks a lot once again

That did the job and an easy solution... thanks a lot. But I have a problem when I try to cancel the operation. I get a visual basic error "Run-time error 2001" You cancelled the previous operation

I have a table that was set up from a parameter query. Before the form opens it ask you for a part number. You type in the part number you want the information for and the form pops up to that particular part number. The problem that I am having is that if I want to move to another part number I...

Thanks for your response. What I am actually looking for, but failed to mention in my first post, is to place a icon at each date field on the form and have it pull up a calendar to enter the date into the field. I am not a script writter and have just really begun to get indepth with Access itself.