Search results

;)

Hey John :D Welcome! I am also still studying and access-programmers is an amazing place to learn! We have some super nice people here! And Adam is behaving too recently :) Anyway, looking forward to hear from you ;)

I did not take a look at arnelgp's database, but here are a few code snippets that may help you: Dim destinationFolder As String destinationFolder = "C:/tmp/" Sub CopyFileAndInsertIntoDatabase(fileLink As String) Dim fso As New FileSystemObject, fileName As String fileName =...

Indeed! The article was a blast to read :D Thank you! Boiling down complex data to a simple dashboard is what i do all the time, and it is so much fun! Having simple visualization such as traffic lights, bars, charts, or even just highlighting numbers with little up/down arrows and color helps...

Hey ;) I am successfully using Access 2013 64 Bit on Windows 11. Nothing really changes, because Windows 11 is mostly just a graphical update. Keep in mind though, Windows 11 does not support 32 Bit any more. So the 32 Bit Version will probably not work.

Great! I used something similar in the past too. Be carefull though, in my experience, OneDrive does cause some issues if you edit the database on both sides at the same time, because then he can not merge them correctly.

Thank you very much! That is a great idea :)

Hello everyone, i know this is a bit offtopic, as we are talking mostly about dll's here, but at the end the dll should be used in access. I created a custom COM DLL using C# in Visual Studio. After importing the DLL in Access, a runtime error popped up "class not registered". According to...

Okay after a lot of back and forth i managed to fix the issue. I created a custom DLL using C#. Basically i imported the AWS Module in a C# Class Library, wrote a custom function that fits my needs, compiled it and registered it as COM Interop. Then i simply imported the dll in access. Usually...

Hello everyone, i am trying to use Amazon AWS WebService in MS Access. Amazon does not include official VBA support, but they provides a precompiled DLL for various different .Net Versions. https://www.nuget.org/packages/AWSSDK.Core/ My experience with DLL's in Access is limited to say the...

I tried various local database solutions in the past, including access. And i would absolutely not recommend it, because it scales badly. If scaling is not a problem for you, and you are the only user, kindly ignore this post. For your task i would setup an sql server on your webspace and...

"2 men have a conversation"

Hey, so you can not assign individual fields on a continous form. A continous form is very optimized, because it will render row by row once. This means that if you assign a value to a field, your code is executed BEFORE the list is rendered, which causes all the fields to become the last value...

Here you go. I forgot something in my code so that was my bad. You do need to add the parameters to the MouseMove Function. I just added some 0 Values. In addition to that your MouseMove Events for the different buttons are written in lower case, and does not match with the names of the...

Sadly it is impossible to just "read" the name of the current function, or the control you are using. That's why we are using the hard coding with the for each loop. If you want to call the functions you already have, then i have another solution for you. This will loose the parameters though...

Are ID, name, adress single values or arrays?

The delete statement i wrote does not delete every entry. It just deletes the entry with the same ID. So only one. A replace is basically the same as "delete the old entry" and then "put in the new one". If there is no entry with that id, then the delete statement won't actually do anything...

Okay but in my understanding a few DoEvents in the timer code should fix the issue then. I still do not understand why access is flickering though. To my knowledge access does not need to redraw unless you change something from the form. So even if the code takes longer to run, the screen should...

That is interesting. The Timer does not change anything on any forms? No edited queries or updated fields, just pure VBA? To be honest, i do not understand why the flickering would occur then. Because flicker should only occur if you changed something that is displayed, because access needs to...

That's the behaviour he already has :D (At least the ignoring part). If you want to tell the user that an entry already exist, you might want to execute a select query in python first, and then check if it returned a valid entry. But i do not know how to return data from a query in python, so i...