Search results

I did it. #,##0;[Red](#,##0) in filed format. Thanks

Thanks for the reply. This changes the negative to positive. But I need the value to stay negative but only appears positive in the datasheet. I have seen this in other programmes. When the number is selected it shows the negative value. I think it's done with conditional formatting, but don't...

Hi there, Is there a way with conditional formatting to change negative numbers to appear positive in a datasheet? Thanks a lot

God bless you. Thanks so much.

Hi there, I have a form with a subform. The recordsource of the subform is a table. When the user changes the sort order of one of the fields in the subform, this sort order stays until the form is closed. I need to change this sort order by VBA. Any ideas? Thanks a lot

Thank you all. control-name.text worked like a charm. Many thanks again.

It does not work. When the date is entered incorrectly, the _onError event fires, the _BeforeUpdate event does not fire. When I look at the field value in the OnError event, it's null, or the old value, not the incorrect entry. Thanks again for your time.

I need to show my own messages, If possible! Before the beforeUpdate event fires, the error message appears. I trap the error in the OnError event but the value of the text box is still the old one because it is not updated. Thanks

Hi there, I need to trap the date field entry errors on my forms. The date format is mm/dd/yyyy If it is entered as 08/20/2021, everything is OK, but if it is changed to 13/20/2021, I could not trap the error because the field value is still the old one (08/20/21). I need to trap the error and...

I meant the MVF is nonsense. Your article helps a lot of people like me. Cheers

Yes I did. I agree with you completely. it's nonsense. Thanks

Thanks again.

Thank you for the replies. I tried the .value part but it shows the IDs, not the names like (David,Smith,Lara). Is it possible to show the multi-selected data as it appears in the query (David,Smith,Lara), on a form or I am wasting my time? Thanks again.

Hi there, Can anyone help me regarding the multi-value field? I have a multi-value field and the selection is OK. Now I need to show the data stored in that field in a text box or a sub-form. Example: stored data is "David,Smith,Lara" I can see it in the table or in a query but I can not use...

Thanks. The shortcut does not work because the program starts with .exe file. Thank you.

Thank you for the reply. The application works fine but it opens under the access window and all the menus go under the add-ins. Dear Minty, you replied that "You may need to point the application to use the runtime or create a specific shortcut that achieves that." How do I do that?? Thanks

Hello there, I have an accounting software which I bought many years ago, developed under Access 2003. It comes with Access runtime. It works fine on a computer which has no access or access 2003. Now I tried to install it on a computer with win 10 and access 2016. When I run the program, it...

Hi guys, I tried what CRONK suggested and voila!!! it works like a charm. Thank you so much. GOD bless.

Thank you all for the replies. I tried DoEvents and declaring "Function Sales_Values(code as string) as double " but it did not work. The problem starts at the first record. There are say 20 records in the table for now. I did this method several times with no problem. I explained in the...

Thanks for the reply. The query is not open. The function works when called from a form or ... I need the result of Sales_Query_2 which needs Sales_Query_1. Query one has a parameter (Account Code) which changes every time, that's why I need to create it each time.