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 '*" &...
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...
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...
The following code returns "#Name?" and I can't figure out what is wrong with it.
=DMin("[RoadNumber]","ResidencesSpecificTable","[RoadName] Like '*" & ME.ResidencesSpecificFormRoadNameTextBox & "*'")
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...
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...
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.
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 =...
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...
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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.