Search results

OK, but as I had updated. I rebuilt the form control by control and the box only appeared after adding the the on load event to open another form in the event that the recordset in the other form is >0. So the box is somehow related to the on load event after the msg box is cleared. So there is...

Well I still don't know why, but I know what it is associated with now. I started rebuilding this form piece by piece and once I added the on load event that opens a form (or not if the recordset is 0) and a msg box, that dotted frame appeared. The addition of none of the controls produced the...

To prove my point, I made a copy of the form so I can mutilate it at will (he he). I started deleting controls one by one, and then I skewed them here so you can see its not a layout.

I tried that. None of my text boxes or anything have a layout attached to them. When I right click each control and select Layout, there is no option to remove layout.

Yes. It does not show in design view. So I'm thinking it is part of the navigation form...

Can someone tell me what this red dotted box is? This is on a form within a navigation form. This shows in layout view, and it doesn't appear on any other form in the navigation form. I also do not see it when I open the target form on its own in layout view. I can't seem to select it. Any ideas?

I don't disagree with you. This was in response to Gasman stating that it works if the column is hidden. And then I did in fact adjust the column widths to accomplish it. 🤷‍♀️

Well, what I did was go to row source and I unchecked the box for Email. When I did so, the combo box no longer even had that column. Is there another way to "hide" that column. Changing the column widths accomplished the same though...

Excellent! Thanks...does this also work if the column is not displayed in the combo box? So if uncheck that column and only the person's name displays in the combo box, can I get the respective email address in the text box? EDIT Answering my own question. Discovered I can't do that, but I can...

Sorry if the title is confusing. What I'm trying to do is use both columns of a combo box in different ways. My combo box (cboSendTo) has two (visible) columns: one's name and then one's email address. Is there a way to specify the column of the combo box to use in code other than whichever...

Perfect! This works great! Thank you!

Hello, I have a query that is tied to a form that will show records based on the user's division in the org. The criteria comes from a TempVars captured at login. What value would I need to get in this field to return records for all divisions? SELECT tblContracts.ID, tblContracts.Division...

I have not. Don't know how that one works. However, I am happy to report that I did successfully add the line of code I needed to accomplish this! I was wrong in my first post. I ended up adding: TempVars ("UserDivision") = rs!Division.Value Works as intended! Thanks!

The previous scenario was setting the tempvars from the combo, but I want to restrict the access to the division associated with the user. I don't want the user to select a division and then have access to that division's records if that's not the division they wanted. This also gives me the...

Right now it is a concatenated algorithmic password; not something the user chooses himself. Once I am done testing all this, I will move to something the user is able to reset. Baby steps. (This is a learn as I go project!)

I apologize. :oops: I often end up typing it all out, and then figure it out before I ever post the thread, in which case then I don't ever post it. In this case, I had already let the cat out of the bag. I'll see if I am able to delete the thread.

OK, I have a login form that uses recordset to validate the associated password entered into the login form. I have been using this information entered to capture TempVars that will be used throughout the many forms in this DB. Up until now, it set the useraccess of the person who logged in and...

Still perplexed as to why the VB code would result in the issue when the macro does not; however, I added an On Error Resume Next and that took care of it in the "Denied Access" scenario, and it functions properly when logged in as a user with access as well.

I did...previously, it was ",,,,," etc. I only added them in this instance to see if that helped the error. Incidentally 2501 is "The OpenForm action was canceled" which in every other instance (macro instead of vb) is handled by the "Access Denied" msg box.

Yes, well edited from one on a tutorial found online. It works on all my other open forms: They all deny access when appropriate. So Update: I'm no longer getting the security error. Turns out I had inadvertently combined the "if" argument and both on the "on current" instead of in the "on...