Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kosala1981
  • Order by date
  1. kosala1981

    I hav 10 forms and how can i add them into a

    Thank u all for ur kind support.
  2. kosala1981

    I hav 10 forms and how can i add them into a

    i have 10 forms. i want to put them in a menu bar in another form and when i click an item in the menu bar the system should be able to show the required form. is it possible to do that in ms access application. or else how can i do such thing to give my application a rich look and feel...
  3. kosala1981

    how to show a record set value in a text box?

    i want to display a value in a record set in a textbox .but it gave an error saying "You can't reference a property or method for a control unless the control has the focus" here's my code : this is a Combo box click method. Private Sub cmbIndicator_Click()--->Combo box Dim rsRecordset As...
  4. kosala1981

    How to fill a combo box from a column having values seperated by comma

    well im new to programming and ms access. thank u for ur kind help.
  5. kosala1981

    How to fill a combo box from a column having values seperated by comma

    i didnt get that. what's a split function and can u explain it more please
  6. kosala1981

    How to fill a combo box from a column having values seperated by comma

    i want to fill a combo box in a form, from a table's column data where that column has few possible values seperated by commas. i just used a bound combo box but it filled values seperated by commas. how to remove these commas and fill values one by one, downwords. i think it needs some code...
  7. kosala1981

    How to execute a message having 'Yes/No' Options?

    thank u all for ur kind support.
  8. kosala1981

    How to execute a message having 'Yes/No' Options?

    I want to execute code, only when i click yes option of the message. following is my code. here i try to delete a record and when i click 'Yes', the record should be deleted but the record deletes when i click 'No' as well. Code: If vbYes=6 Then 'both yes & no options delete records'...
  9. kosala1981

    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...
  10. kosala1981

    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...
  11. kosala1981

    combo box validation rule

    how to set a validation rule on a bound combo box where u cant not keep it empty/null. or else can we put it in the before update subroutine. i set it's validation rule as isempty(source). but when u leave the combo box empty, it doesnt give a message instead it gives the message when it's...
  12. kosala1981

    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='" +...
  13. kosala1981

    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...
  14. kosala1981

    Report generation with VBA code

    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 boxes then selected items go as parameters to...
  15. kosala1981

    Report generation with VBA code

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

Part and Inventory Search

Back
Top