Search results for query: *

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

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.

A form I was using was working fine and yesterday the text boxes were not displaying what they had been and should be. While trying to figure out what was wrong I just happened to put the cursor in one of the text boxes and up pops the number that should have been there. I did it to all of them...

Hi: I have two number fields (pickups and dropoff) for various pick ups and a drop off. There are several pick ups daily in the early morning followed by one drop off. I need a text box on a form that will compare the pick ups total to the drop off total for the past twelve hours so that we are...

Hi: I built a multivalued field and it works fine in the table and in a query but it will not work in a form. What do you have to do to make it work in a form or do they just not work in forms? Thanks, xmeb

Hi: I have been using the following code on a form for months and it worked fine. Private Sub DataEntryFormMasterSaveCommandButton_Click() myReply = MsgBox("Are you sure you want to save this record? You cannot edit data after you save it.", vbYesNo) If myReply = vbYes Then...

Hi: I have searched on Google for what I want to do but I have found nothing that is exactly the same so far. On a report I have a subreport that has a "PrimiaryLocation" text box. I use the following in the subreport query criteria for my field "DDate" to show primary locations for the last...

I am trying to make the following code work but so far it does nothing. What's wrong with it? Private Sub Form_Timer() Clock.Caption = Time ' Update time display. If Weekday(Date) = 3 And Time() >= #9:00:00 AM# Then Me.Visible = True End If End Sub

I cannot seem to get the following query to work. It runs but returns "0" as a result. SELECT Count(DataTable.StartTime) AS CountOfStartTime1500, Count(DataTable.StartTime) AS CountOfStartTime1600 FROM DataTable WHERE ((Hour([StartTime])=15) AND (Hour([StartTime])=16)); I would also like to...

I am using the following in a text box on a report which works fine but in addition to returning the total of all vehicle jump starts which it now does I also want it to return the daily total for the report date. =Sum(IIf([Action]="Vehicle Jump Start",1,0))

I have searched the web without success trying to find a way to remove the "Enter Parameter Value ?" text that appears when I run my query. Is there a way?

Hi: I am using the following code to save several text boxes to my data table and the ones listed to my locations table. It works okay except that it creates one blank record every time it saves a record in the locations table. Private Sub DataEntryFormSubmitButton_Click() myReply =...

Hi: I have a form that has approximately 20 text boxes and combo boxes that saves to a table. I need to add a couple more fields. I was reading about normalization and was wondering if I have a problem. For instance, the user selects a primary location from one (and only one) of three combo...