On the occasion of this debate just a thought that came to me ...
I think that adp is a more truly client-server option but unfortunately Microsoft stopped supporting it. So even if I had the option to migrate to .adp (because I use Aceess 2010) I didn't want to for the sake of maintainability...
You are right.. this is the technique I use when I develop web applications due to browser considerations. But a desktop application is more flexible on this issue.
In this case, records are few to worry about, and the growth rate is only about 2500 new records per year!
Also the concurrent...
Upsizing to Sql Server performance
Hi, I have migrated an Access 2010 database to Sql Server 2008.
When I open a continues form bounded to a table with 31.000 the form crawls until all records loaded. I did not have this problem before when the data was in Access backend. I realize that when I...
This is true only when you have new record. If you edit an old record fails because the current sum also takes into account the old value so your solution will have a higher value by old value.
I have found the solution. Just thought if there was a more elegant solution:
Me.NewValue +...
Thanks for your reply, as I said in the subform's before update event you don't know the current sum (I mean with the changes you have done). Only after update event you know the sum but then it is already too late!
FYI
I use a textbox in subform's footer that calculate the running sum of the...
Hello, I have a form and a subform. Every time I use the subform to make new records or to update a record I need to check if the sum of subform's field is greater than the value of parent's form field before subform's update.
It seems simple but it doesn't because you can't know the subform's...
No... people don't do that...
If the parent form is a bound form (as in our case) then if you press the escape key then the changes in the bound field of the parent's form will return to the previous value!!!
You must use after this: Me.Dirty=False
The directory has only one text file. Τhe file we are interested in.
The link is an example. It doesn't mean that I use it as is. Of course I have changed the wait handle to FILE_NOTIFY_CHANGE_LAST_WRITE.
There is no delay. The program that changes the contents of the text file close the file...
A simple example from Microsoft ready to be compiled and run:
https://docs.microsoft.com/en-us/windows/desktop/fileio/obtaining-directory-change-notifications
This is wrong... I have already code from Microsoft that do this... monitoring a Windows folder for changes!!! And works like a charm for other languages like C#... !!! The problem is not Windows but Access.
Monitoring folder's changes in Windows is used quite often and there is code for all...
I need a real time solution and not polling... so I leave behind Access and I change platform from now on...
The problem is that the application is too huge and works for years to develop again from scratch only for this reason!!!
Thanks anyway