Search results for query: *

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 '*" &...

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.

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

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?