Search results

Is your table field set to text? See my attachment and see if it helps you.

Look here, I think you need to use the Date Part function.

I'll look more tomorrow.

Nevemind, I misunderstood what the problem was - I thought you were talking about the controls on frmNewTimes.

When I look at the DB in post 37, what I find is that the control "txtSelection" Needs to be requeried in the click events for both list boxes before they are set to being invisible. Using A2010 When I look at the DB in post 26, it works just fine in A2010 as a .mdb if I am reading the...

I don't see any way in conditional formatting to aply multiple conditions in an "AND" like fashion, I think you might have to use vba.

Spam Reported seoconsultant

Also, if the table is not there, it may be hidden, you can show hidden objects see attachment for how

There is a drop down at the top of your left hand menu, switch it to tables.

Ha, the exact thing I was trying to point out, doh (the Ands I mean, hence my first posting)! I was using something that someone had given me to help with this sort of thing.... so the single quotes were part of an example I had been given, probably which I applied incorrectly.

Or actually something like this maybe?: Dim stLinkCriteria As String stLinkCriteria = "[Community]=" & "'" & Me![cmbcomm] & "'" stLinkCriteria = " '" & stLinkCriteria & "' & [Building]=" & "'" & Me![cmbbldg] & "'" stLinkCriteria = " '" & stLinkCriteria & "' & [Facility]=" & "'" &...

Don't you need something like: DoCmd.OpenForm "Fac_Mgmt", , , '" & stLinkCriteria & "' And '" & stLinkCriteria1 & "' And '" & stLinkCriteria2 & "'

Probably in the query, and your welcome. :)

Check this out and see if any of it helps you.

Have you tried setting the field property "Format" to Short Date or something like that?

How about a DLookup that concatenates everything? Then you can set a text box on each form with the same DLookup, hence the same information. See Here for examples, example 5 is what you want I think

Great! I am glad you got it working. :)

Well, that's good to know. Thanks!

If you aren't willing to redesign then you can put something LIKE this in the after update event of the Aircraft_Reg combo box/textbox Select Case Me.Aircraft_Reg Case A5-EAA, A5-EAB, A5-EAC, A5-EAD Me.Aircraft_Type = "A320" Case A5-RAA, A5-RAB, A5-RAC, A5-RAD Me.Aircraft_Type = "B737"...

Hmmmm. Are you willing to redesign your tables? If so you can set up an Aircraft_Reg table, and include the Aircraft_Type in that table. Then in Aircraft Details you would have a fk to the Aircraft_Reg Pk. Then you could display the Reg and the Type on a form either using a dlookup in an...