Search results

Thank you Gasman for your suggestion, BUT for some reason they do not work on the new Access 2003 form we tried to create. We will go back to using an OLD form that works. Your suggestions are appreciated. Marylyn

Thanks Bob for your note about the cross posting, which will not happen again. I / we are under a pressure at the charity as all of their reports have to be completed by December 29th and little things like changing the field name from Yes to No are slowing us down. Regards, Marylyn

= = = Thank you The_Doc_Man for your comments. We are volunteers at a charity helping to run their office. The code that we tried to transfer to a new form does NOT work, while it does work on their OLD forms. So I will use the old forms. Thank you, Marylyn

Thank you Bob for your suggestion, we have tried to use your suggested code in our Access 2003 database without success. The error message that we get is // Run-time error’3144’: Syntax error in UPDATE statement. = = = = I am trying to; In the Field Investigate, change from Yes, => No or In the...

We have been trying to correct the code in this Access 2003 form without success and continue to have a syntax error. Any assistance will be appreciated. Thank you Marylyn

Uncle Gizmo thank you for the Link. Nicole

Thank you GPGeorge for your suggestion which we entered as below, but we received an error when using your code. Dim strSQL As String strSQL = "update Investments01_tbl" & _ "set investigate = 'No' " & _ "where Investmentl_ID in (SELECT Investmentl_ID from (" & Replace$(Me.RecordSource, ";"...

Thank you Pat Hartman for your suggestions. I have attached the table “Investments01_tbl” and used your debugging suggestion but did not change the query and a new error occurs Compile Error “Ambiguous name detected: Clear_Investigate_Yes_Click” Nicole

Thank you Mike Krailo for your suggestion. I have attached a Valid Table but did not change the query and the same error continues. Run-time error ’3144’ Nicole

Thank you The_Doc_Man for your note, the code below is what we have tried. Private Sub Clear_Investigate_Yes_Click() ' Fuction Name ===> In the field Investigate, Change "Yes" => "No" ' Table Name ==> update Investments01_tbl ' Field Name ==> investigate ' Change Data in Field Investigate, from...

Could we please have assistance in changing the data in a field. The code that I have entered does not work. A = Change Data in Field Investigate, from Yes to No B = Change Data in Field Investigate, from Watch to No Thank You Fabiola

Hello Arnelgp, thank you for your help, your database is 99% Complete. Could you please adjust the Portfolio combo box, as I cannot get it to co-operate. Thank you. // Crystal 2023_Dec_09; Arnelgp your assistance in fixing our database was CORRECT. "Our" problem was that there was no data in...

Thank you all for your suggestions, but I could not remove the picture, so I Deleted the report and than Recreated the report. Nicole

We had ADDED a picture to our Access 2003 report many years ago. We would like to remove the picture now, but keep receiving the message. "The Ole Server Isn't Registered" We reinstall the Office 2003 MsAccess program. Could I please receive a suggestion on how to fix this problem?

Thank you Arnelgp for the Combo Box Form adjustments that you made. I made an error in their groupings = = = Group Printing = A Could you please assist us by letting the user choose; Investigate => All or the records marked with Yes Currency => All or the records marked with a currency such as...

Hello, Pat Hartman and thank you for your past suggestions. Could you please send us the code that you use to back up your databases when closing, as the user forgets to =>File => Backup Database before closing their program? At the present time we use a timed Batch file to backup our data...

99%. Thank you arnelgp for getting our Combo Box Form to work. Would you please show us how to send the chosen data to the Report so that we can print this data using our report form? I notice that you are waiting for Jelly Beans, may we send you some? We do appreciate your assistances. Crystal

Could I please, receive assistance in printing a report using 5 different combo box choices in our Access 2003 Database? Your suggestions will be appreciated. Thank you, Nicole

We would like to upgrade our software from Access 2003 to Access 2007. Do we have to do anything special or just upgrade our databases? Thank you. Nicole

I am trying to preview a report before printing which uses the following code for printing; ‘= = = Old Code = = = Private Sub cmdPrint_Click() Dim repFilter As String If IsNull(Me.cmbFindAccountYearMOR) = True Then Exit Sub Else repFilter = "[AccountingYear] = '" & CStr(cmbFindAccountYearMOR) &...