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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.