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