Search results

Thank you Pat for your comments. We have been using this code in many different forms and databases since before 2010 iwith no problems. The ONLY problem we have with the code is with this form. Once we have resolved all of our little problems we will be upgrading our Access 2003 databases to...

Thank you DHookom, for your suggestion. We have been using the code in this database since 2010 without any issue until now, specifically, “ONLY in THIS FORM”. We have tried many other codes without success and would appreciate your assistance with this problem.

Thank you for your note, Ken. The database is attached. We have been using this code since 2010 without any issue until now in THIS FORM

Ken, please find the code and database with which I am having a problem.. = = = I would appreciate some help with the adding of new records to this form @On Click = Event Procedure = = = Private Sub cmdAddNewRecord_Click() On Error GoTo Err_cmdAddNewRecord_Click ' Save any current...

I would appreciate some help with the adding of new records to this form @On Click = Event Procedure = = = Private Sub cmdAddNewRecord_Click() On Error GoTo Err_cmdAddNewRecord_Click ' Save any current changes to the record DoCmd.RunCommand acCmdSaveRecord ' Attempt to add a new record...

Thank you, Doc Man, for your comments. We were given the new, unopened software as a gift. Batbara

Thank you Arnelgp for supply us with your code for printing empty reports that we manually fill in. manually. Batbara.

Thank you Arnelgp for your suggestion. However, Nicole has retired from her volenteer work after turning 80. Barbara

Thank you Doc_Man for your suggestion. Barbara

Thank you Pat for your suggestion. Barbara

GaP42 Thank you for your note. I am new to this and thought that our database had been uploaded. Please find the problem database attached. Barbara.

Thank you all for your suggestions. It seems that our problems occurred during a Windows 10 upgrade. My boss purchased the latest version of Access, so hopefully our current Access 2003 problems will be resolved after upgrading. Barbara

An error message keeps occurring when trying to add a new record with the button event on the form or using the macro Ctrl + New.. A similar error occurs when trying to copy the stock name, using the “K” button event. We would appreciate your assistance in solving these Access 2003 problems...

Hello The Charity where I volunteer at own Microsoft Office 2007 which they were thinking of upgrading their MANY Access 2003 databases to. MOST of their staff are Volunteers so we have to keep their data input EASY (KISE = Keep It Simply And Easy) Which Microsoft version of Access do you...

Thank you for your comments. When the queries are now run the filters are not CURRENTLY grouping the records as as requested. Fabiola

Our databases were functioning until last week, but to-day our queries are not working. Could you please advise me how to get our queries to filter our records again? Do you have any suggestion for restoring our toolbars? Thank you, Fabiola

T.H.A.N.K. you Mark for pointing out something that I did not Know, THE SUM FUCTION.

T.H.A.N.K. you Amelgp, for your suggestion.

I tried to change the value from Currency to Numeric, but the math error continues. Original formula =Sum(Nz([Stop_Current])-Nz([Current_Price])) Second choice formula =Sum(Nz([Stop_Current], 0)) - Sum(Nz([Current_Price], 0)) A = calculaction is wrong B = the calculation in the DIFFERENCE...