Search results

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

We have been using this Access 2003 Bank Reconciliation database regularly. It was last used yesterday, but to-day we have received this message. You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish...

Thank you June7 for pointing out our problem. I missed Binding the fields as I was working late on this project to meet a deadline. We do appreciate you pointing out my error. Thanks/ Crystal

The data that we are entering into our form is not being saved, could I please receive a suggestion as to how to correct this problem? I appreciate your comments. Nicole

Thank you Pat Hartman, your comments about ZLS where not known by me previously. We are obtaining the results which we required and thank you for your assistance. Crystal

Thank you GaP42 for your assistance and we are now getting the results that we wanted. Crystal

Thank you Pat for your question. Should I refer to the empty records as, Empty, Null or Blank? Thank you. Fabiola