Search results for query: *

...like this. Below are some of them. Could you get me started? Thanks. =DCount("ID","DataTable") =DMin("[RoadNumber]","ResidencesTable","[RoadName] Like '*" & [ResidencesFormRoadNameTextBox] & "*'") =DCount("*","ResidencesTable","[RoadName] Like ""*" & [ResidencesFormRoadNameTextBox] & "*""")

Problem still exists. Any ideas?

I have several forms that use DCount, DLookup, DMin, and DMax. When I open the form the "D" text boxes are empty until I put the cursor in it and the correct value then appears. If I set the tab order to "0" on a particular "D" text box and open the form the value is displayed but that is no...

Duane: That works perfect! It is exactly what I needed. Thanks, xmeb

Hi: I am using the following query for a text box (DLookup) on a form which works fine. However, there are quite a few records where the "Residence Name" is null which means there is one null record at the top of the list that the query returns. Is there anyway to eliminate that null record...

Duane: That was it! It works fine now. Thank you very much, xmeb

The following code returns "#Name?" and I can't figure out what is wrong with it. =DMin("[RoadNumber]","ResidencesSpecificTable","[RoadName] Like '*" & ME.ResidencesSpecificFormRoadNameTextBox & "*'")

Okay, thanks. I will put the "1" at the end and try it. Thanks again.

...& Me![1RegistrationNumber] & _ "' AND [1RegistrationState] = '" & Me.[1RegistrationState] & "' AND ID<>" & Me!ID lngCount = DCount("*", "ParkingTicketsIssuedTable", strWhere) If lngCount > 0 Then MsgBox lngCount & "Other registration number(s) exist." End If End If End Sub

...& Me![1RegistrationNumber] & _ "' AND [1RegistrationState] = '" & Me.[1RegistrationState] & "' AND ID<>" & Me!ID lngCount = DCount("*", "ParkingTicketsIssuedTable", strWhere) If lngCount > 0 Then MsgBox lngCount & "Other registration number(s) exist." End If End If End Sub

This following line of code is in red. If Not (IsNull(Me![1RegistrationState]) Or (IsNull(Me![1RegistrationNumber]) Or IsNull(Me!ID)) Then There is no error number - description, a popup just says compile error and syntax error. Thanks.

...& Me![1RegistrationNumber] & _ "' AND [1RegistrationState] = '" & Me.[1RegistrationState] & "' AND ID<>" & Me!ID lngCount = DCount("*", "ParkingTicketsIssuedTable", strWhere) If lngCount > 0 Then MsgBox lngCount & " duplicate registration number(s) exist(s) in the table."...

...Or _ (IsNull(Me.ID)) Then strWhere = "(1RegistrationState = """ & Me.1RegistrationState & _ """) AND (ID <> " & Me.ID & ")" lngCount = DCount("*", "ParkingTicketsIssuedTable", strWhere) If lngCount > 0 Then MsdgBox lngCount & "Other registration number(s) exist." End If End If End Sub

Thanks. I deleted the macro that the command button opened and it seems okay now. Why do these things happen?

Hi: I have a pop up form with a command button that pops up a message box which works fine. However, when it pops up the message box the pop up form goes full screen. What's wrong? Thanks, xmeb

Anybody had this happen to them?

TheAceMan1: You solved it. I had a tiny set focus text box at the bottom of the form that I had forgotten about. Thanks! xmeb

Thanks for answering. It is single and has no code. Thanks again.

I have a form on a tab in a six tab form which works fine except that one form is much longer than the others so it has a vertical scroll bar but when it is opened it is always at the bottom. Is there a way to fix that? Thanks.

Any ideas?