Search results

you have solve my problem but now another problem arises when i use to hide database window then this code does not show me the report result but when i use to unhide the database window then this code shows me true result. plz help me because i want to hide the database window and get true...

Plz any one help me.

i am telling you the forms names....... Main form is ....... frmMainform In the main form unbound object name is ........object2 Sub Form Is ........frmReports when i open the main main form then unbound object opens the subform using this vb code Me.Object2.SourceObject = "frmreports"...

i am putting the criteria statement in query (date) criteria field

Actually i have linked the form"frmMainform" with a sub form (unbound object) "frmReports" For which i use........ Me.Object2.SourceObject = "frmreports" Me.Object2.Form.DataEntry = True Me.Object2.Form.AllowAdditions = True Me.Object2.Form.AllowEdits = True Now i think i have clear something...

I use this formula but there is no any resutl >=[forms]![ frmMainform]![frmreports].[Form].[txtDateFrom] And <=[forms]![ frmMainform]![Frmreports].[Form].[txtDateTo] Plz help me

Hello Dear All i am using this criteria in query to generate a report when i put dates in a form named "frmReports" in which the fields are named "txtdatefrom" & "txtDateTo" the criteria is....... >=[forms]![frmReports]![txtDateFrom] And <=[forms]![frmReports]![txtDateTo] Using this criteria...

All formates are jpg formates. Each picture size is 4 to 5 kb i am using access 2003 these pictures are related to each record i.e each record have a specific picture.

Hello All I have made a project in ms access that contains graphics/pictures. In that project i have added data of pictures in jpg formate. Now the problem is that when i generate any report of pictures or related data that contains more than 10 pages, it takes too much time to reach at last...

i am using this code for form Private Sub Command1_Click() Me.Object2.SourceObject = "Invoice" End Sub But which code will be used for reports?

Is it possible that any report can be linked with sub report For example can we link any report with unbound object like a form.

Plz Help mE

i use to hide database window in my project but when i use to unhide the data base window then every form is showing detail and header section of the form properly but when i use to hide the database window then only header section is showing not detail section. plz help me

i put this code in my data base but now there is nothing to show in subform object i mean to say that sub form is not showing detail section of the form only form header is showing instead of whole form.

but which complete code i will put into on_clik event in button? Because i want to open my form in subform unbound object

Hello I am using this code for opening a form with subform but i want to open form in add mode. Plz tell me how is it possible? Which code can i use? I am using this code Private Sub Command5_Click() Me.Object2.SourceObject = "Payments" End Sub Dj Wasim Pakistan

How can i protect my form/report/query/table design from changing through vb code? but only the person who have the password can change the design. Wasim Shahzad Pakistan:rolleyes:

Ohh thanks alot thank u sooooooooooo much.

i do that but no result found I am sending you the dbs plz check it and tell me there is problem in purchase form plz check it

how can i set the default value of a field (before entering any any value) as another field in a form? For example there are 4 fields named Quantity---Price---Amount---Avgvalue now i use to enter data as......... Quantity---Price---Amount---AvgValue ---5--------20------100--------20---...