Recent content by kosala1981

how to lock set of controls in a form with out specifying one by one. i tried a for loop. but it didnt work. i couldn't get the Locked property of the controls. here is my code: For x = 0 To Me.Count - 1 If TypeOf Me.Controls(x) Is TextBox Then Me.Controls(x).Locked =...

my tab control contains several pages and each page contains several controls. i set each control it's control source. but i couldn't find the record source in the Tab Control Page Property. because of that problem i couldn't see any records displaying in it's controls. Answer for this...

Thanx a lot my friend......

In the following statement i tried to send BeginningDate(textbox value) and EndingDate(txtbox value) to the SQL stmnt but it gave an error saying "Type Mismatch" even though i used CDate method. answer for this problem is greatly appreciated......:( "WHERE Project.tProjTitle='" +...

i cud generate da report without setting the source code..... thanx for ur kind support. i really appreciate it.

"X" is my table name...........

I have created a report using sample codes taken by the forum. one problem is that the report displays the field/column names in the table in columnar format(field names display in rows.) but i want to be able to display filed names and its relevant data in tabular format in the repor but the...

customizable reports using cross tab query.. well my requirement is to generate customizable reports.i've already developed a form having four combo boxes. two of them filled with two tables data and other two filled with field names of tables. so when a user selects these items from the combo...

I need to create an access report uisng VBA code. i want to be able to create a report name and save it and also create labels and text boxes in the report using the vba code and those fields should come from the table in the database. and data of the table should be displayed in the report...