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!

  • Congratulations strongm 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

    Yeah, I agree. These "D" functions have been nothing but trouble. However, I have never used code for something like this. Below are some of them. Could you get me started? Thanks. =DCount("ID","DataTable") =DMin("[RoadNumber]","ResidencesTable","[RoadName] Like '*" &...
  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

    Thanks. I tried it and the first three lines are in red and I get the same compile error and syntax error. Strange because the following works fine but I am told it lacks an "if condition". Private Sub Form_Current() Dim strWhere As String Dim lngCount As Long If Not...
  10. xmeb

    Form Code Error

    The same text is still red and the first line is highlighted in blue. The following code works but I was told it needed the "if condition" added to it. Private Sub Form_Current() Dim strWhere As String Dim lngCount As Long If Not (IsNull(Me![1RegistrationNumber]) Or IsNull(Me!ID)) Then...
  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

    I am getting compile error and syntax error using this code. Anybody know what is wrong with it? Thanks. Private Sub Form_Current() Dim strWhere As String Dim lngCount As Long If Not (IsNull(Me![1RegistrationState]) Or (IsNull(Me![1RegistrationNumber]) Or IsNull(Me!ID)) Then strWhere =...
  13. xmeb

    Form Code Problem

    I am trying to use the following code to alert users to how many registration numbers are in the table that have been issued parking tickets. I keep getting a compile error. What's wrong with it? Thanks. Private Sub Form_Current() Dim strWhere As String Dim lngCount As Long If Not...
  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