Search results

I think I got it right thanks. I had a now() on on focus of the form. I just deleted that.

rivate Sub cboStatusId_AfterUpdate() If cboStatusId.Value = 1 Then Me.txtDateCompleted.Visible = True If IsNull(Me.txtDateCompleted) Then Me.txtDateCompleted = Now() End If Else Me.txtDateCompleted.Visible = False End If End Sub

I tried the code. but when I changed the date on the computer the date changed also.

But the date will change every time you open it right? What I want is when I choose cboStatusId.Value = 1 it should be completed and save the date and after that it shouldn't be edited anymore or the date shouldn't change at all.

4th line - Me.txtDateCompleted = Now(date_completed) how do I save the "now()" to the field if i am not to put "date_completed"?

I've got this code, once it updates it would give me a run-time erro '13' type mismatch date_completed is a date Here is the code: Private Sub cboStatusId_AfterUpdate() If cboStatusId.Value = 1 Then Me.txtDateCompleted.Visible = True Me.txtDateCompleted = Now(date_completed) Else...

thank you very much

how do I do that?

I tried querying all my tables (9) on 1 query why won't it display any record? There is already data on it.

I have another access db with the same problem but this one is an inventory sort of thing. I'll try this code first if it doesn't work i'll post the same issue again. Thanks again for the very big help.

Wow! thanks a bunch. It is working now.

Sorry, it's frmFacilitiesEntryForm

Here's the db

I've checked and it is set at that already. Somethings I've noticed browsing through the records. 1. When you open the database it will set you to the first record say combobox1 = training and combobox2 = MSAccess once you move to the second record combobox1 = facilities location and combobox2 =...

It is bound to a field. I think what I should say is not displaying the data on combobox2 not that there is no data.

Actually the code is already there and still every time I add a new record it will only save the last record and the previous records will be empty on the combobox2

Can you help me with the code? thanks

Hello, I've two combo box. Lets call combobox1 and combobox2. when you add and choose data from the combo boxes and will save it and it will display the data but once you add another data it will only display the data on combobox1 and the present data on combobox2 and if you go back to the...

I've a table with records. some records are active and some are not. What I want to do is when I open the form and I choose to deactivate the record it will not show up the next time I open the form but will not delete the record because I will need it for reporting purposes. Can somebody show...

thanks Rio