Search results

Perfect. Thank you very much!

Could you expand on this?

[Solved] Conditional Formatting of Cells based off of date and time criteria Hello, Here is what I am trying to do. I have three cells right now: Date of incident Due Date Date completed What I would like to do is the following: When they enter the date of the incident. There are specific...

Just wanted to report back, forgot to do it the other day. Worked like a charm!!!! Thanks again.

vbaInet... Thank you very very much for taking the time to talk me through this!!!!

Ahhhhhhhhhhhhhhhhhhhhh...... Yes I was getting the two after the " = " sign confused. Ok, reading I understand there is a difference, but is there a difference in doing one way or the other? They should do the same thing correct?

You are correct I am seeing way to many EmployeeNumbers! LOL... The part that is getting to me, is there are two EmployeeNumbers left of the tblMain. The first one should the field in the table tblMain the one right after should be the control on the form? Which is what I was doing before...

Ok..... Just so I understand: first EmployeeNumber = Field in table tblMain = database table EmployeeNumber resides in Second EmployeeNumber = Also Field in table? Third EmployeeNumber = field name on form in question? The txtEmployeeNumber is the actual field name on the form. The way I had...

That is correct, I have it named txtEmployeeNumber on the form itself. This is how it should be correct? Or in my previous statement it should be looking up the same field from tblMain?

vbaInet Just so I understand, the item you highlighted should be the field from the table? IE "tblMain", (Main datatable) "EmployeeNumber"=" this is the actual field from the tbleMain? So I would be calling the field "EmployeeNumber" twice, once before the tblMain and once after. Just...

Hello.. I found this code in another thread and I can't seem to get it to work. Private Sub form_beforeupdate(Cancel As Integer) Dim icount As Long icount = Nz(DLookup("EmployeeNumber", "tblMain", txtEmployeeNumber=" & Me.txtEmployeeNumber), 0) If icount <> 0 Then Beep MsgBox "Worker ID...

Just wanted to say thank you to bradcccs and added to his reputation for taking the time list out the date functions ie m=month etc. Thanks again. Keywords: Dates, Date, Minutes, Months, Seconds

Crap... thank you for the info. What a pain in the butt. Thanks for again for the info and also thanks for the link! Greatly appreciated!

Hello.. I am not an administrator on our network so I can't log into a computer to try this out and I have searched and I haven't found what I am looking for. Question: If an administrator logs on a computer as the computer administrator fires up access. Can they set the default security...

Re: Requied Field on a Form How would you set it up if you have say 5 txtboxes and 3cbo boxes that you want to make sure something is filled in? I have tried the , and the word and and I can't get it to work. ***EDIT*** I figured it out... Just use a couple more IF statements. :)

Kiwiman.. That did the trick. Thank you very much. No need to be sorry! Thank you! I was so close!

Here you go: frmSubComponent I also attached a pic just to make sure we are talking about the same thing.

It is showing the following under caption and under source object: frmSubComponent However this subform is on a tabbed interface. I don't know if that will make a difference or not again, but I thought I would put it in there.

Ah... no the subform was not showing up. Let me check something.

Ok.. I did the following code: Private Sub Form_Close() Me!frmSubComponent.Form!cboLocation.Requery End Sub I am still getting the following error: Run-time error 2465 microsoft office access can't find the field 'frmSubcompnent' referred ito in your expression.