Search results

This function tests to see what the user access and type are in whichever form is (attempted) being opened. Public Function UserAccess(FormName As String) As Boolean UserAccess = Nz(DLookup("HasAccess", "tblUserAccess", "UserAccess_ID=" & TempVars("UserType") & " AND FormName='" &...

OK. This didn't work. It still popped up the "Access Denied" box, but then once clicked OK, it popped up the frmUpdateStatus Anyway. So I'll go back to using the OpenArgs on current and keep the function without the If. But I was able to successfully pass the Contract No using the quotes, which...

Thank you for all the replies. I'm going to try to redo it with the quotes and see if I can get the syntax right. I'll report back...

Thank you. I'm confused by the multiple quotes. Why a single, double on the left and a double, single, double on the right?

I'm running a function on open to check for user access (certain forms in this DB are blocked from users whose access level doesn't allow them). Would I run the OpenArgs before or after that function? Private Sub Form_Open(Cancel As Integer) If Globals.UserAccess(Me.Name) = False Then...

OK, so would that be... Private Sub btnUpdateStatus_Click() DoCmd.OpenForm "frmUpdateStatus", , , , , , 'Me.txtContractNo' End Sub ...single quotes around Me.txtContractNo ?

In this particular record the text box txtContractNo (short text type) had the value "EM-22-104". See my other post...

see my other response on where it came from...

OK I sort of found a solution, but I still don't understand why it didn't work. I changed the value that I'm passing from the Contract No (which is the primary key, short text featuring letters and dashes; the "EM" in the parameter value prompt is coming from) to just an ID that is numerical...

txtContractNo is a text box that holds the primary key in the originating form

These are the same as in the other db where I basically copied the same process.

Good afternoon, I'm trying to pass a value from one form to another. The originating form has the following code: Private Sub btnUpdateStatus_Click() DoCmd.OpenForm "frmUpdateStatus", , , , , , Me.txtContractNo End Sub and when we open frmUpdateStatus a box asking for a parameter value...

OK this worked! Thank you all for the suggestions. Minty, I appreciate understanding what is happening (i.e. the original event being halted while the modal form is open). This gives me a bunch of ideas on how to manipulate the order of operations in some forms!

OK, so in my click event that opens the form, just add this as a line item after the open form? I will try this and report back... Thanks!

I have this scenario in several forms in my DB: clicking a button will open a pop-up form that will update a record. When the pop-up form is closed, I would like to refresh the main form, but I don't know which event that is. So currently, I have a button I manually click to refresh. Can anyone...

I did it!! I ended up using this method suggested by CJ London, but it took a little more than two queries to accomplish. I knew which one of the calculated values would be ideal for applying the modified difference because there is an entity that appears in each of my zones, and that is a...

Without digging intensely deep on that one, from the top of my head I can offer that that field is (a) the one that was not subject to the Round() function; and, (b) is the result of being multiplied earlier up in the chain by the other credit field that I posted later in this thread.

I just found something, and wonder if this could be an issue. I'm asking this because throughout this thread, many of you have asked for the data types of these fields, and I just discovered this one is different from the data type of the distribution percentage (which we have been discussing)...

I wrote out a methodology for management, and I thought I would post it (redacted) just to show what I am trying to accomplish. This sort of helps explain the multiple levels of aggregating, slicing and dicing, and aggregating.

Thank you, it is post 8, but the highlighted data type is the Distribution (percentage) field and it is Number/Decimal with one decimal place...