Search results

Parameter Query - Can't believe I can't figure this out This should be an easy one, I have a parameter query on a form with two criteria options; works great. I want the user to be able to type in the criteria so that it runs for all the criteria (or what would simply be a "xxxx" or "yyyy"...

Hi, Can anyone help me with why this is not working? In the event code of a command button I have: Private Sub DocStatusCmd_Click() -THIS IS HIGHLIGHTED?? On Error GoTo Err_DocStatusCmd_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Documentation...

Hi all, Any ideas on why my form is not working to run a parameter query? In my query criteria I have: Between [Forms]![HUSubmitDteFrm]![SubmitAfterDate] And Date() The unbound text box in the form is named SubmitAfterDate. However, when I type in a date in the form, nothing happens (even if...

Hello, I couldn't find help on the forms forum, so I thought I'd try here. I have a form for a query with a parameter value. I'm having problems 'refreshing' this query, meaning once a value is entered as a parameter, I can't get the parameter box to appear again (unless I close out the form...

Hi all, Yet another newbie question... I have a form running off a query with a parameter value. I also have this same form 'linked' to a main form via a command button. Every time I click this command button I want the parameter value box to request a parameter (right now it's like the form...

I've searched high and low for the answer to this basic question to no avail, so I apologize if it's somewhere on the forum... I'm trying to set a parameter query to prompt the user to enter one date, and retrieve all records after that date. (I'm thinking this is a Between and Present...

Simple question (I hope), When users enter text in the comments box, I want the ability to highlight and change some text to red (like in excel). Any idea how to do this? I'm currently using the code: SomeControle.ForeColor = vbred in the fore color box to keep the effect to only one cell...

Hello all, Sorry for the basic question, I can't seem to find the answer in any other post. I created a landscape form with wizard, and since I've reformatted, the width won't increase with the arrows. I've tried changing the width in properties, but access tells me the "number is too large"...