Search results

  1. K

    how to lock all controls in the form at once

    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 =...
  2. K

    How to add Record Sources to a Tab Control containning several pages?

    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...
  3. K

    Convert String to Date Problem in SQL statement.

    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='" +...
  4. K

    Set record source, controls and display data in a report using VBA Code.

    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...
  5. K

    pls help me guys! I need help regarding report generation with VBA coding

    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...
Back
Top Bottom