Recent content by kosala1981

i'm interested.

Thank u all for ur kind support.

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

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

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

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

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

thank u all for ur kind support.

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

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

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

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

Thanx a lot myfriend.....

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