Search results for query: *

I tried Can grow but only that text box will be expanded and I want all the text box in that row to be of same size. Is there way to display the report in Excel format?

Thanks a lot. This is exactly what I wanted. I have one more problem in Reports. I hace created block tabular report. One of my text box has many line. The tex box displays only part of the information. Is there way to set auto fit the contents? Is ther any other control for Tabular display.

Thanks for the response. I want to set the value only when the user adds new record. I don't want this event to trigger when user copies or edit the record. If I place my code in OnDirty event it will trigger for everything. Is there any other way to do it? If you check Northwind sample...

I have form A which has field "FID". I want set the value FID=Me.OpenArgs when something changes in my form I tried setting the value in form close but it didn't work. Where should I place my code? None of the field is mandatory except primary key which is automatically generated. I have...

I have a report which has line after every control. After first page I get just one line in second page. How to avoid this? I decreased line width but the problem still exists. I'm not able to decrease the size of the report in design mode. I'm also getting blank page. How to slove this? thanks

I'm using OpenForms function to open form B with specific record from form A. If the record is present in Form B then it should show the record and allow user to update else if not present then user should be allowed to enter new record in Form B Function OpenForms(strFormName As...

Thanks for the response I want user to edit but prevent from entering new record. If I lock all the controls on the form will the user be able to edit?

I would like to prevent the user from entering new records I used With frm .AllowAdditions = false .AllowDeletions = True .AllowEdits = True End With User should be able to update and edit. If the form has no records then form will be blank. Form doesn't even show the controls. How to...

Thanks it works.

Forms.Item(stFormName).RecordSource = mstrSQL worked. dim stablename as string stablename = Me.OpenArgs I have one more problem. My table name is a variable which is stored in stablename dim stablename as string stablename = Me.OpenArgs mstrSQL = Select * from stablename; when I use...

Thanks for your response but this doesnot work Forms(stFormName).RecordSource = mstrSQL My form is not a subform. Here is the scenario, my form name is stored in a variable stFormName it's not a form. So when I try Forms(stFormName).RecordSource = mstrSQL the message I get is stFormName...

How to set the record source for a form where form name varies depending on where it is called? My form name is stored in stFormName I have to set this property in different form. I tried following but doesn't work Forms(stFormName).RecordSource = mstrSQL Forms!stFormName.RecordSource = mstrSQL...