Search results

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

Our accountant requests that we save the data to a Pdf file and Zip the Database to a DVD after all of the Yearly Documents have been printed.

Thank you for your follow up information.

Thank you Arnelgp for your code and comments, which I discussed with our Accountant. She agrees with your word “Adjustments” Accounting adjustments are modifications made to financial statements at the end of an accounting period to ensure accuracy and compliance with accounting principles.

Thank you Arnelgp, I appreciate your suggestion and advice. Nicole

T.H.A.N.K. Y.O.U. Cheekybuddha Your suggestion works, Since you like dogs, I will try to find one to pat this week. Nicole

Thanks Cheekybuddha for your comments. I thought that I was writing a Query to copy and calculate data, but it seems that I was wrong. A Government Department is requesting more information from us and I was hoping that this Expression, which I thought was a query, would allow us to provide...

Could I please have a suggestion to fix this Query. IIf([Transaction_Type]="Sold_$", [CRA_Settlement_Amount] - [Book_Value], Null) and [CRA_Settlement_Amount]-[Book_Value] What we are trying to accomplish is; If the Transaction Type is "Sold_$" then the Transaction_Total is copied from the...

Arnelgp, Thank you for your suggestion.