Search results

Guys, attached is the modified file, do anyone help to test it? Thanks all

Minty, Where i must put my path? Which line i must put into immediate window? thanks again for your time and help

Minty i'm direct here again because of the error. Following is the real database vba code (because the attached database is an example) and the problem persist again. Note that, i call the code direct from the report (when is open) and all the data on it its correct (name, customer no etc)...

Thanks Minty, I will check it and will be back

Hi all, The attached database includes an MsAccess Report and vba code so to be convert to PDF and then to stored it in a standard Path. I would like your help so to change the standart Path with my own. Please note that: My application has an application main folder and the Customers folder...

Could you please explain in details (if you have time please)?

Hi The_DOCguy, The ideal is On After Update but anyway the problem is to find a way to do that... Is that a way?

Good afternoon, I am sure that my new post its so interested for many members so I think that if we found solution for that everybody will be happy. Is there a way for automatically translate (as far as possible) a name from Greek to English or vice versa? Example: George Stylianou is...

Morning The_DOCMan Yes, i have some queries DSum as well as DCount..! Really interested what you said but any idea on what can we do in this case?

Hi and thanks, They said must change the HKEY_LOCAL_MACHINE\ SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines\ACE\MaxBufferSize to 50000 but i'm using Ms Access 2016 and i cannot see where is the Access Connectivity Engine\Engines\ACE\MaxBufferSize . Any idea? Thanks again

Hi all, I have the following problem which i cannot find solution in order to solve it. My database is about 150MB with enough complexity into the code I can said. My computer is Lenovo i5 - 8GB RAM and my database giving the error "System Resource Exceeded" only on the specific processes of...

Hi all, I would like to have the help of the most experienced of you to be able to read and import data from an Csv file into a new table in my access database. I have tried some methods but unfortunally i cannot do that Attached you can find both the Csv file and my database.I will...

TheDBGuy can you please give an example on how using command button to call the Script (Vbs) file please? And sorry for my last post....

Yeap, working. Tell me something, how can i run external Script file using code into my form?

Another solution that i found and works perfect but i cannot run it within vba module is a Script file for backup. Anyone can help me in order to run the Script file within access form (command)? attached is the Script

Hi TheDBGuy and thanks but, I modified the code as follow but i have problem because there is a password in my backend and i'm getting the error msg. Option Compare Database Option Explicit Public Sub BackUpAndCompactBE() 'Courtesy of Brent Spaulding (datAdrenaline), MVP 'Source...

Hi all, There is a way using code to copy the back_end database? Please note that, i wanted to do that from Front_end Interface. Thanks

Good morning and gave a nice week, I'm back again in order to make clear on what exactly need to do. I just wanted to see and control my emails form outlook into an access form as well as to set appointment form access form and to have automatic sync into an Outlook app. The Second part its Ok...

Hi, Really don't know what happened but attached you can see the problem persist in my real database

Dear friends, I have the following simple code which working fine in order to read any external files into an access form. But, the problem is the confirmation message after the selection of the file (attached). Is there a way to skip the confirmation after the selection of the file? The code...