Search results

Between [Forms]![ExperationDialog]![BeginninDate] And [Forms]![ExperationDialog]![Ending Date]

1. build a form, name it frmRetlaw 2. add two text, name them after and before a. set format as date 3. add button 4. search this forum for keywords like Report Form Dates and Query. Im not going to write out everything for you, because i don't know anything about the structure of your...

assuming you already have the report built, you need to build a query/SQL statement which will select the data from your tables, as specified in your form, and use this as the source for your report.

im not totally clear what you have done, but do you have a button on your form which opens your report and passes the values from the form to the report?

are you trying to search for records or for Reports?

dude, let me be the first to say that this post doesn't really make much sense. "i have data with a lot of (records?) and report(s), I w(a)nt to create a form to select report name and (the date also? the date from two?)" Are you trying to make a form which will display report names and...

get well soon!

I could be wrong, but i think that if [WO/PM #] is a text field you need to wrap WO* in single quotes so that access knows its text. something like this... [WO/PM #] = '" & WO* & "'" also be sure to use AND as CPREMO suggested

heh. after a continuous loop made me start over, i tried this again, this time with ruralguys code from here: http://www.access-programmers.co.uk/forums/showthread.php?t=117314&highlight=list+requery while it doesn't seem too different from what i was doing, it did the trick. methinks it was...

I haven't worked much with subforms, but it seems to me that if you are trying to change the fields displayed by the controls in your subform, this should be totally possible. see if this thread helps...

im not sure exactly what you are asking here, but it is possible to bind a form to a SQL statement and programatically set the fields to display. Can you be more specific with what you are trying to do?

kinda. im doing this as such: Private Sub cboPurchaseOrder_NotInList(NewData As String, Response As Integer) Dim intAnswer As Integer intAnswer = MsgBox("Do you want to add this item to the list?", vbYesNo, vbQuestion) If intAnswer = vbYes Then DoCmd.RunCommand acCmdUndo DoCmd.openForm "addPO"...

ah, it seems i should have searched 2118 error before i posted that. I believe i have THE SOLUTION.:rolleyes:

ok this is pretty sweet. Im having a little problem though im doing this in form1: Private Sub cboPurchaseOrder_NotInList(NewData As String, Response As Integer) DoCmd.openForm "addPO", , , , , , NewData End Sub and this in addPO: Private Sub Form_Load() If Not IsNull(Me.OpenArgs) Then...

like.......EXIT SUB. stupid noob. stupid stupid noob. can't you see you're good for nothing, you're soooo stupid!

I've finally got a validation rule going in a public function. sadly the msgbox's spring, but the rest of the code continues to run. setting the function as boolean... amdValid = true If Nz(vFrm.txtvalue, "") = "" Then MsgBox "Please Include a Dollar Value for this Record"...

thanks for the nz bit, that was spot on. on to new Problems...:)

hot buttery nipples, that sounds right up my alley. Thanks guys! Now if i could only get a grip on that validation function....maybe next week :)

Dread Pirate Read which, I believe, is the same name as last year. maybe not the Read bit, I think i chose muppets over the book last year, and was Dread Pirate Walter.

I have a combobox, populated from a lookup table and a button which opens a form to add new values for the combobox. Heres what i would like to do (users idea, not mine, apparently clicking the add button might be too confusing for some old fogies) If the user types a value which is not in the...