Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xmeb
  • Order by date
  1. xmeb

    Empty Text Boxes Until Cursor Is In Them

    ...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] & "*""")
  2. xmeb

    Empty Text Boxes Until Cursor Is In Them

    Problem still exists. Any ideas?
  3. xmeb

    Empty Text Boxes Until Cursor Is In Them

    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...
  4. xmeb

    Form Query Help

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

    Form Query Help

    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...
  6. xmeb

    Form DMin Code

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

    Form DMin Code

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

    Form Code Error

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

    Form Code Error

    ...& 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
  10. xmeb

    Form Code Error

    ...& 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
  11. xmeb

    Form Code Error

    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.
  12. xmeb

    Form Code Error

    ...& 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."...
  13. xmeb

    Form Code Problem

    ...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
  14. xmeb

    Command Button Problem

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

    Command Button Problem

    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
  16. xmeb

    Strange Form Behavior

    Anybody had this happen to them?
  17. xmeb

    Form Open At Botttom

    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
  18. xmeb

    Form Open At Botttom

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

    Form Open At Botttom

    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.
  20. xmeb

    Multivalued Field

    Any ideas?

Part and Inventory Search

Back
Top