Search results

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

I removed all fields from form and I added them again. The problem disappears!!! I don't know what happens and why...:confused::confused::confused:

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

yes you are right I corrected... Me.fieldForSum + DSum("fieldForSum", "SUBFORM_TABLE", "id<>" & Me.id)

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

Don't be so rushed I'm not asking people just to confirm my question Just read my previous response Thanks anyway

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

If we create a C callback inside dll and the thread function call this (instead of vba callback) and then the dll callback call vba callback?

Ok... This means that if we could call the Callback from the main thread of dll (ie from dll message function) would be perfect. Indeed I have tried it and works perfect. But we must have a mechanism in the dll that thread function notify the main dll thread when it has to inform for a change...

more information: 1. I have switched the textbox reference with filter. So first to execute the filter and second the textbox. The result was that filter executed but not textbox value set. 2. I removed textbox and filter's settings. I wrote only one line of code: MyForm.RecordSource="..."...

below I have the report from Event Viewer Faulting application name: MSACCESS.EXE, version: 14.0.7230.5000, time stamp: 0x5c6738e8 Faulting module name: MSACCESS.EXE, version: 14.0.7230.5000, time stamp: 0x5c6738e8 Exception code: 0xc0000005 Fault offset: 0x0015a3f1 Faulting process id: 0x66fc...

I have made a simple dll with C for use in an Ms Access vba project. The dll makes a new thread and makes use of a vba callback function inside the thread's code. According to MS documentation the vba callback function has to be in a vba module and not in a form's code. Inside the callback...

unfortunately with OutputTo you do not have any way to configure pdf's options... for example if you want to embed the fonts to the exported pdf you are not in lucky!!! I am looking for a solution that contains the dynamic naming of the files (without human intervention) but using the pdf...