Open report on value of textbox

[ahmad]

dear i mean, in following coding


DoCmd.OpenReport "statement", acViewPreview, , "Dateofissue >=#" & Me.textbox1.value & "# And Dateofissue <= #" & Me.textbox2.value & "#"

i wanna add another textbox3 in form and above coding. and when i click button, open report only particular report that i enter text in textbox3 with date range that i entered date. hope u understand. plz reply

[blueraincoat]

OK,you mean in the textbox3 user enter the date range directly, and on command button click you want the particular report opened, right?
Of course you can. Just make sure the date range entered is correct, it's supposed to be
Dateofissue>=textbox1 and Dateofissue<=textbox2
The whole syntax may be
DoCmd.OpenReport "statement", acViewPreview, ,me.textbox3.value

[ahmad]

dear i have a textbox3 that has name value, when i enter both date and textbox3 value and click button, open report that has all textbox3 value and date range also.

in short, textbox1, i entered first date and textbox2, i entered second date and textbox3, i entered name. and i click buton, open report that has all records which has same name and date range also.
help me

[pbaldy]

It is certainly possible. Why don't you try? It would follow the same pattern, except a text value would require ' around it instead of #.

[ahmad]

i have tried bt i m unable to do it. can u plz add textbox3 in following coding that take textbox1,textbox2,textbox3 condition. plzzzzzzzzzzzzzz

[ahmad]

DoCmd.OpenReport "statement", acViewPreview, , "Dateofissue >=#" & Me.textbox1.value & "# And Dateofissue <= #" & Me.textbox2.value & "#"

[blueraincoat]

what you need is just add another condition,right?
it's very simple.
DoCmd.OpenReport "statement", acViewPreview, , "Dateofissue >=#" & Me.textbox1.value & "# And Dateofissue <= #" & Me.textbox2.value & "# And " & condition3

[ahmad]

dear when i writing following code, error is coming.

DoCmd.OpenReport "statement", acViewPreview, , "Dateofissue >=#" & Me.Text106.Value & "# And Dateofissue <= #" & Me.Text108.Value & "#" And "& toms=" & Me.Text94.Value

plz tell me the correct coding if it is wrong.

[blueraincoat]

http://www.baldyweb.com/wherecondition.htm
Please read this page wrote by Paul carefully,and hope you can find what's going wrong, and learn how to write the where condition.

[ahmad]

hi all, plz help me. when i open ms access file, error is coming. but when i open old file, that is opening. plz solve my problem.

the error is
"microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"