Search results

What would i use for the field name?

Hello, I am currently using the following code in VBA to disable/enable a text box. DLookUp("[Department]","[tblUsers]","[UserTag]='" & [Me].[txtUser] & "'")=2 I have tried using this same expression in conditional formatting to enable a different box but it isn't working. Any idea why?

Hello, I'm trying to send an email based on a new form record that uses 3 unbound text boxes for it's data. i have tried to send the email based upon the text box directly but the data is always blank, i'm assuming because the record is not updated yet. I figured i would need to use an append...

Got it. I just added a refresh command on the Onclick event of the yes/no box. another thing, I'm trying to use the following code to refrence the table that the fields are insert into (tblEmailSend). Dim rst As DAO.Recordset Dim strEmailAddress Set rst =...

June, I created the local table [tblemailsend] and created and append query that runs when the user form is opened that list all the users. This works great, but there seems to be a slight problem when the check box is selected in the form. The results do not match up to what is selected. e.g...

Because i was using the temp table for the recordsource of the continuous form. This would have the memory of the check box wouldn't it? I did create the front end table though as suggested and used an append query and delete query to update the table which populates my email list.

But don't i have to create the temp table so that the checkboxes can be changed without affecting another user? If i create a front end table and add another user later to the backend, the front end will be out of date

Got it. I used a button to create the temp table which provided the record source to the continuous form, then used VBA to run a query for the email section. Then i just use the code to delete the temp table after Code below for anyone else reading,

Yes it is.

Hello, I have a table with a list of users [tblUsers]. The last field [EmailSend] is a Yes/No Field |UserID|UserTag|UserName|UserEmail|EmailSend| I have a form that that is filled [frm1] then a button that will open a continuous form that displays all the users/Email addresses [frmUsers]. I...

That fixed it. Excellent, thank you!

The only code i have on the Onload even is the code you provided me. By stepping through i assume you mean hovering my mouse over the fields in VBA? i don't get any values.

It is a numeric field.

This didn't work bastanu. The field is still locked. I double checked the names and Id's.

There is no current code asking for the department. This what i am trying to achieve by verifying that the current user in txt1 has the correct department before they can change cbo1 and/or enable txt2

Or maybe another way to do this if it's easier would be, If current usercode in txt1 has department = 1 then cbo1 is enabled. if not cbo1 is disabled by default.

Thanks for the reply bastanu. My cbo1 is actually a yes/no combo box. If the user tries to change the combo box to a yes/no answer, txt2 will only be enabled if txt1 matches cbo1 code asking for department = 1. I was thinking maybe this had to be achieved with a continuous subform displaying...

After messing around with coding, i still had an issue with not all boxes staying enabled/disabled correctly. I ended up using Conditional formatting on the text box.

Hello, i have 3 tables (tblUser) (tblDepartment) (tblfrm) On my main form (frm1) is a combo box (cbo1) and a text box (txt1). the txt1 is hidden and displayers the current users computer login. I'm trying to achieve a verification process so if a users name in txt1 is in the same...

Arnelgp, This worked well for when a person selected the "No" option but it still enables box1 if a combobox is left blank/empty. Also i have to refresh the form after every combo change for the changes to take effect. Would i use the requery option in this instance?