Search results

Can any one assist with displaying specific record data according to Date selected from combo box??? THANKS!

Microsoft DAO 3.51 object Library is checked. I used Object instead of Recordset and I don't get an error, but no data is displaying. Do you have an idea on how to get this working? THANKS!

charityg, Thanks for you response. We tried that code and we are getting a 'Compile Error; Can't find project or library' on dim rs as recordset line of code. We are using MS Access 97. Do you have any idea what we need to do? Thanks!

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

TO ALL: CAN ANYONE HELP!!! THANKS!

Chris, What are you referring to when you say ProjectID? Are you referring to the field that I am already using? And what field are you referring to as cboDate.Column(1) Are you referring to my date field WeekNo ? I already have the record by using this string of code: SQLstr = SQLstr &...

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

Can any assist with explaining or giving sample code on how to display recordset values on a subform??? 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?

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 Me![txtTaskName] = TName Me![Monday] = rs2![MON] Me![Tuesday] =...

I've run/opened the query and it displays the data; how can I tell if it is updatable?

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

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? Thanks for your quick responses!

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