Search results

I would like to populate cboAssigned with the UserFullName value taken from a SELECT statement. I'm trying to populate the combo box so only assigned records are filtered on a form when a user opens the database. Do I run the SQL statement first or can i just run it directly to the code. I'm...

I spoke too soon. It did not work. Thanks though.

You were right. I had to put the same SQL statement without the WHERE clause on cboStatus_Click() and it worked. Thanks.

I've created a search form based on several unbound comboboxes. Two of them are cboTaskSearch and cboStatus. When the form opens, cboStatus is populated with all Status values and cboTaskSearch is populated with all Task values. When a user selects a value in the cboTaskSearch, the form will...

I need syntax help for an UPDATE statement. I'm trying to update StatusTx with the value listed on the CBOSTStatus and the StatusDt with the date/time the value was updated. It's producing a Run-time error '3144': Syntax error in UPDATE statement. I have listed the code below. I appreciate...

I have two unbound text boxes in a form called startdate and enddate. On form open, the two fields are populated with dates with the code below. Private Sub Form_Open(Cancel As Integer) Me.StartDAte.SetFocus Me.StartDAte.Text = Format$(Now - 7, "MM/DD/YYYY") Me.EndDate.SetFocus...

TaskID = AutoNumber(PK) StatusTx = Text StatusDt = Date/Time cboStatus comes from StatusID = AutoNumber(PK) and StatusDescTx = Text Would it be the cboStatus producing the mismatch?

I was able to come up with this however an error message appears stating "Data type mismatch in criteria expression." DoCmd.RunSQL "UPDATE tblTask " & _ "SET tblTask.[StatusTx]='" & Me.cboStatus.Value & "'" & _ "AND tblTask.[StatusDt]='" & Me.txtChangeDate.Value & "'"...

I'm trying to store the value from cboStatus to StatusTx and from txtChangeDate to StatusDt where StatusID is equal to Status ID. I've searched and was able to get this. I am not familiar with SQL or VBA. I appreciate any help I can get. Thanks. DoCmd.RunSQL "UPDATE tblTask SET...

I've updated the module to look like below. However, it still does not do what I want it to do. When the user enters a value, it will prompt user if either the mandatory field or mandatory fields have been completed. I'm only able to accomplish this for one field. When a chosen value has two...

After updating the module, I am still unable to do what I want for the form. When the user enters a value, I would like to validate if the mandatory one or two fields have been completed for each value. If not completed, a messagebox should appear indicating which fields are missing. For...

Hi. I have the following code below where after user makes a selection the code will check if the other necessary fields are filled in or not. Then, a message will be displayed if any or both required fields are not filled. I am able to do this with only one necessary field but unable to...