Search results

i want show data from different queries

Majp, i meant iam using at Report_Open(Cancel As Integer) section of the report

simplest way is to create another report, but i don't want to do that

didn't know that, what should i do?

i want to populate different values in a single report that why iam using recordset. iam calling in open report

The Following is the code iam using to populate the text box tsOrigin Public Sub repPopulate() Dim db As DAO.Database Dim rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Dim orig As String Dim countrec As Integer Set db = CurrentDb Set qdf =...

Yes, it's a big access query. And does have 4 where clause using temp variable

Iam trying to populate the results on a Split - data sheet view form. Will it work on a sub form view.

OpenQuery works fine and shows only the 2 rows that need to be displayed

Iam using using TempVars to change the controls of the query, below is the code TempVars.Add "tvyr", Trim(Me.cmbCropYear.Value) Me.RecordSource = "SELECT * FROM [qryNNDocsDue]" Me.Requery But the result shown in the datasheet form is for all the Years. Am i writing something wrong here? Pls...

it is searching thru Numbers and not digit strings. let me check my reference. in the meanwhile pls advice if there is any other alternative

Hi Arnelgp, i tried string thru TempVars the above code and it says Error 2465 as below error number : 2465 Error Source: mod_DB_Variable\cmd_LocateFile_Click Error Description: Database Cant find the field '|1' reffered to in your expression Can u help

Ok Will Look at them today, thanks for your guide. will let u know how it works.

Thanks Everyone

Finally Wrote =IIf(IsNull([Text])=False,"CHN/GO/" & Format([Text],"000") in the Expression and Found the Solution.

i tried in VBA Me.Text.Format = "CHN\GO" 000. This is what was typed in the Form Control

Iam trying to change the Format of a Textbox Pragmatically. I need the Text Box to Show "CHN\GO\ "000 but when i use s BackSlash in the Format() i get the Runtime Error 13, Type Mismatch. iam using Format(Me.Text, "CHN\GO" \ 0#)

This Worked great, thanks

iam getting the error 2455, i don't know how to do this

I used the below line in the Open Event of the Sub-Report and it working fine now. If TempVars!sRepRecSrc01 <> vbNullString Then Me.RecordSource = TempVars!sRepRecSrc01 But now i get the error "you can't set the source property in print preview or after printing has started access" for about 4...