Search results

Here it is, I also attached the DB now the on the main form click view then it will bring up another form and on that form click vendor reachout, that is where the problem is. I am not sure why it does not take me to debug screen anymore if there is a problem or error, it might for you but for...

Yes I left the code for the message box and set a break point. it is now red but when I click on save it just shows the message box, that's it.

Thanks for thissss this is exactly what I need! :D:D:D

It is not bringing me back to the code line when I click save... :confused:

There is a message. I put a breakpoint now it is marked red. Should I run it again by clicking save?

It is triggered by a save button. Here is the code: Private Sub save_Click() 'check the always required fields If IsNull(Me.extdatevreachout) Or IsNull(Me.lfassessedvreachout) Or IsNull(waiverapprv) Or IsNull(reqmethod) Then MsgBox "Please check empty fields", _ vbCritical, _ "Canceling...

Yes, update query but how do I make it reference the other table? I'm sorry I can't seem to construct it... I am up until UPDATE tbl_info WHERE... And I don't know how to proceed from there... because the WHERE only looks for one value, do I add a dllookup on it? Having difficulty...

Hello all, good day! I apologize if I am opening up a lot of thread lately, just can't figure out how to do stuff...I really appreciate your help everyone! So I have a list of let's say approved companies. I would like to update a field on a table based on this list. I have a company name...

Not sure if I'm doing it right, I set a breakpoint which was marked in red, when I try to run the code still nothing happens. I just want it to check and not allow saving if the fields are blank based on the selection,... on the waiver approved field. If the value is Yes, 3 of the fields...

I cannot get in the debug mode.... it seems like it is not running at all... when i debug it does not show any error...

I just presses f8 and nothing happens... i have to be at the start of the code right? The private sub that is where the cursor is... then i pressef f8 and nothing happens

F8 does not work, tried to singlestep....

The primary key one is autonumber, while the other two are numbers.. The other two tables data come from data entry... can you work on the stuff even if I strip off all the data on it? I cannot send the copy with the data mostly it is sensitive info... thank you :)

Oh I'm sorry yes I did not say the problem, it just does not work, and another weird thing happening is that VBA does not tell me anymore where the error is unlike before, not sure if I turned off something, I just know that it does not work because when I click on the button that is supposed to...

Hello, starting another thread again, thank you everyone for your patience on a beginner like me I really appreciate it. so I need to be able to make sure that there will be no required fields that will be left blank. I attached an image of how it looks like. * Ext date, InVoice count, LF...

Hello I apologize for the late reply, here is the screenshot. thanks much!

I apologize for the late reply, i checked it and i realized that i have the field name incorrect so it was fixed when i corrected the field name cbstatus to status. Thanks for your help everyone!

Hello, sorry, I don't know where to check for that, could you tell me what to look out for? Thankss

I see... so i dont really need it but does it mean there is something wrong that i need to fix in my db since it is not showing the subform as it normally should? Since i am getting the error...

Hi! Here I am again asking for help, I have a little plus sign on my table. It shows on the image attached. When I click it, it says "This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try...