Search results

What I would like to do is select a DATE from a combo box, and within the form in different areas (not in the combo box) have the rest of that dates record data information displayed in seperate fields. All of this information is on a separate form already, I just need to get that records data...

Below is the code that I am using; I pick a date from a drop-down list, and am trying to display the first data record that corresponds to the date, but it is not working. What displays is the first record of the file. The Me! section of the code is not displaying the correct data record. Can...

I am in Create Report feature: 1) I have an input date range; How can I get the date format to display with slashes? Also, 2) How can I create a dialog box with drop- down list within the Creat Report feature??? I hope someone can understand and assist. Thanks!!!

How can I get a recordset to display on a subform??? Any assistance is appreciated Thanks!

How to resolve the following error message? 'The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the...

1) How to refresh any form from another or how to refresh/reload a subform??? 2) How to pass a parameter to Query from VB code?

Pat below is my code and now I am getting a Runtime Error : 'This Record set is not updatable. Can you help! Thanks! Set rs2 = CurrentDb.OpenRecordset(strSql) Forms!change_timecard!change_timecard_sub.Form!txtAppName = AName (Doesn't work) Me![txtTaskName] = TName Me![Monday] = rs2![MON]...

Aname is a global variable which has a value. When I code the following: Forms!change_timecard!change_timecard_sub!txtAppName.text = Aname I receive ERROR: 'The property is read only and can't be set.' Where should I change the property so that the value will display? Thanks for your quick...

Aname is a global variable which has a value. When I code the following: Forms!change_timecard!change_timecard_sub!txtAppName.text = Aname I receive ERROR: 'The property is read only and can't be set.' Where should I change the property so that the value will display? Thanks for your quick...

See my code below (it is not displaying the values of the days of week on my subform.) I get a message that it cannot find the field/form.Private Sub WeekNo_AfterUpdate() Dim rs As Object Dim rs2 As Object Dim strSql As String strSql = "select * from timecard where WeekNo =...

How to point Me to subform? OR How to reference one form to another form. (Isn't this one in the same or is there more than one way to reference?) See my code below: (The values for the days of the week are not displaying on the subform.) Private Sub WeekNo_AfterUpdate() Dim rs As Object...

Can someone assist in showing a sample of code of how to setup a Global Variable with a value that will be used on multiple forms within the same database. Thanks for any assistance.

What code is needed to be able to have user enter Username and Password then click on login button (of form) to access the database? Only accessing the records/data pertaining to him/her? Also, once the user has access to the data, and have updated the data, what code is needed to auto update...