Search results

I am with both of you but it does. I will investigate further

This too works great until you delete data in one of the text boxes. Then you get a pop up that says No criteria and the title bar reads nothing to do

I gave this a read and am no wiser for it. As I am still learning vba the hard way I need to understand what that code does and how.

I used a variation of your code on this page but still got the same results. It does make the control hidden but if you remove the data it comes back with no criteria error. Here is the code If Len(Me.txtFirstName & vbNullString) = 0 Then Me.cmdAddNewClient.Visible = False...

I have a form with three text boxes and one command button I want to hide the command button from view until at least one of the boxes has data in it. I also want the command button to return to hidden if the data is removed So far I have tried this on the after update event on one zof the...

Ok let me see if I can lay this out Forms Involved: frm_MainMenu with a subform sfrm_Clients pfrm_AddClientDuplicateCheck So pfrm_AddClientDuplicateCheck is opened from a button on the sfrm_Clients subform. The frm_MainMenu and sfrm_Clients remain open but in the background. There are three...

I have several database that I have created. Three of them always print to the bypass tray no matter what computer or what printer is connected. Does anyone have any ideas.

Alas it is working. Changing the and to or did the trick. I was wondering about that because the if statement seemed to be asking for the date field to be in two different states at the same time. Here is the complete code fully functional and working. Dim stWhere As String Dim...

So now the between is working again but the one that uses only the start date and the one that uses only the end date still do not. They act as if no dates had been entered at all

It should be ... stWhere = stWhere & "[DateEntered] Between #" & Me.txtCDCContactNotesStartDate & "# And #" & Me.txtCDCContactNotesEndDate & "#" because there already is a # inside the stWhere = stWhere & "[DateEntered] Between #" ...... I enter the dates in mm/dd/yyyy format ie: 10/17/2013

I see that mistake and have changed the three where statements to stWhere = stWhere & "[DateEntered] <=" & "#" & Me.txtCDCContactNotesEndDate & "#" stWhere = stWhere & "[DateEntered]>=" & "#" & Me.txtCDCContactNotesStartDate & "#" stWhere = stWhere & "[DateEntered] Between #" & "#" &...

Changed it to stWhere = stWhere & "[DateEntered]>=" & Me.txtCDCContactNotesStartDate & "#" But that did not fix anything. You mentioned earlier that the date section of Bob's sample was flawed. Remembering that I am a work in progress I am having trouble understanding the logic behind the...

You are correct .. Where = "[EnteredBy] =" & """ & Me.cboCdc & """ did not work but Where = "[EnteredBy] =" & "'" & Me.cboCdc & "'" did work as expected

I'm Back. So I am now tackling the two txt controls that are used to specify a from date, a to date or a between two dates. The between two dates works perfectly but the from a date or to a date returns all records regardless of the dates. I must add that if I incorporate cboCDC in the mix...

I have tried stWhere = "[EnteredBy] =" & """" & Me.cboCdc & """" and stWhere = "[EnteredBy] =" & "'" & Me.cboCdc & "'" and stWhere = "[EnteredBy] =" & """ & Me.cboCdc & """ All three work when cboCdc is blank. But when a name was selected I got a parameter prompt for EnteredB. Then a light...

I am so far lost I think I am ahead. I have looked at this example and can not even get the first part to work. That is where the stWhere should be using cboCdc for part of the filter. I am taking baby steps with this to get one thing working at a time. Here is my code so far Dim stDocName...

I am afraid I have no idea what you are talking about. You mention filter by form when I am trying to open a report. I do not see how one has anything to do with the other. I am pulling the criteria from a form and it is the criteria I am having trouble with. If I am missing something here...

I have a report that has a couple of fields that I wish to use criteria to pull from a text box on a form The first field is called EnteredBy and has the following text in the criteria line of the query that loads the report Like "*" & [Forms]![frm_MainMenu2]![frm_Reports].[Form]![cboCdc] &...

I have a weird problem where my forms seem to shift down and to the left all on there own. Here is the scenario On an unbound for I have large tab control which has six tabs named Clients, Archived Clients, Employers, Prospective Employers, Maintenance and Report On each tab is a form that are...

Thanks guys. I actually figured that last one out late last night. Thank you ever so much for the learning experience. Again many thanks....