Search results

I have a pop-up form that is coded through VBA to open on certain button clicks. I would like this form to always open in the top-left corner of the window. For the life of me, I can't find anyway to specific in access where the form should open when called... Is there a way to specify this...

Thank you Spikepl for the example! One thing I've noticed is that it seems set up for already entered inforation. In my example, I have a my form coded so that it opens to a new entry automatically, all the fields are blank. If you start completing the form, say completing 2 of the 4 fields...

Whoops, not sure how that Form_Upload got in there. It is correctly Form_BeforeUpdate in my code. In my form, there is a Submit Request button and a Cancel Request button. (I know that nothing is actually being "submitted", but the user will think it is, which is what matters.) What I am...

Okay, follow-up question: is it possible to cancel the BeforeUpdate event to prevent the form from closing?" For example (modified the second half of your provided code): Else If MsgBox("Are You Sure You Want To Cancel This New Record?", vbQuestion + vbYesNo + vbDefaultButton1, "Cancel New...

This is exactly what I was looking for. Thank you Linq! I am still new to VBA so seeing the code is incredibly helpful in understanding how it works.

Hmm... thank you for your response but I'm not sure I follow. I'll try to clarify. The table in question holds all the service requests (e.g., requests 1, 2, and 3). The form adds new requests to the table. If the form is opened and closed with no changes whatsoever, no new entry is added to...

I have a form which users complete to submit a service request. The completed fields are saved to a table. As soon as users started completing the form, a new record is saved in the table. I would like to code it such that if they close the window (or possibly click a 'cancel' button'), the...