Search results

Hi Adelina, I used SQL Server for this sample but there is no real difference in using MariaDB (except of course the specific features for each environment). The story: for performance reasons I had to take a subset of the records, resting on the server-side, to a local table and do the user...

Thanks you all. Enough reactions to get me going. I have have to investigate the offered solutions (and hints of solution directions). The result will be posted.

Hi, the external applications in scope now are SalesForce and a custom made automatic PhoneResponse application. Starting myAccessApp when it is not active is not that hard but how to detect if myAccessApp is active?

hi experts, I have been searching but I can't find the solution. What I want is the following: Provide a command-line option to an external program to: check whether myAccessApp is already open if so then activate myAccessApp and open e.g. a form with the provided external Id if closed then...

Thanks for your answers DBGuy and Gemma but tt was something else. While away from the screen and walking the dog (which always leads to the solution of the problem at hand ;)), it came to me: the user must have had the report open on screen while, in an another form, the batch creation of the...

Hi, I recently ran into a strange error with getting an Id from a DAO.Recordset.The back-end is a sql-express 2014 database. The high level logic being: make a pdf (access report) store the path in a table and get the DocId send out a mail to the party contact with the pdf as attachment I got...

thanks Minty, so easy!

Hi fellowdevelopers, I have a multiple business unit report. I have a page break after the business unit changes in the data I want to print the correct logo of the actual business unit on each page My problem is that the print preview is correct (works as designed). However when I want to...

hi all, today it was my turn to have a corrupted db :banghead:. Luckily I found this thread:- Export All Database Objects Into Text Files But I missed a way to restore the objects again in a new empty database. So I created a table to store the saved objects. step 1 => define the table. I...

hi all, I'm a seasoned Access (Office) / SQL Developer. I have a corrupt Access database so I was looking for some help... I hope I can contribute as well of course. greetings Leon