Search results

Hi here's some information on setting up a standard import that you can automate to import all files in a directory into a table https://rounduptheusualsuspects.org/?p=1825 You should be able to convert that into importing excel spreadsheets by replacing the DoCmd.TransferText to...

No problem Z You sound like you are well on your way. It sounds like a fun project. Those templates are kind of fun as they are nice and theoretically pure so unlikely to really age and should be available in any database (with tweaks to the code and implementation). Generally speaking you can...

Transfer of the entire local authority building control and development control records for local authorities in the UK between Oracle backends - the biggest provider in the UK uses MS Access as a significant tool within their Export Transportation and Load projects. They also recommend MS...

Even the ones that are simple run like syrup with most taking at least 2 seconds to resolve. Although that might just be web stuff and not form specific. My googlemail account takes about 4 seconds to resolve. Pages on this forum resolve quite well for me still takes 2 seconds. My wordpress...

IMHO - the only reason to move away from an ms access application is to take advantage of the web and even then you can get round that with cisco / terminal services. I can't see why I will stop using some of the applications I have already built if they continue to work - it would take me too...

Hi Z Here are a few templates that I use for EAVs / child tables Firstly if I have multiple child records but I want to pull out specific maximums or minimum based on date or vector. When placed in a table this can nicely assist between comparison of entitities. EG - Please give me a list of...

I think your choice of the EAV is right on the money. The SQL Server types that I've come across have disliked it in certain circumstances because they have been focused on applications that are externally facing with 1000 of concurrent occasional users that have little or no focus on the system...

I like EAV models for storing information about entities the attributes of which are not particularly predictable. I will typically have the entity as a FKID to the parent. Attribute might be a lookup and then Value will typically be largish text and sometimes even a memo. I quite like it for...

Creating your own software to be used in a professional environment urgently is a serious undertaking either if you do it yourself or you commission another. Either way it is like writing a book - it is likely to take months at the least and is usually something that people come to slowly after...

For anyone following this I would always recommend 32 bit windows drivers and 32bit version of MS Access. Here's a link to database drivers. https://dev.mysql.com/downloads/connector/odbc/ Be very careful with primary keys as well - in SQL SERVER big int which is often standard primary keys...

If you are just staying with desktop environment there is little point in re-development the best of the rest is only as good as MS Access in my opinion. The next step would probably be to go to the web - that way you get round the issue with Mac / Windows dual development. And when selling to...

As per Uncle Gizmo there are two common paths - PHP or ASP There are low coding environments for the web I actually use something called php runner which I find excellent which is made by a company called Xlinesoft Xlinesoft - PHPRunner and ASP Net Runner And this is a basic review of my...

You might find this helpful My investigations on the same subject https://rounduptheusualsuspects.org/?p=1360

Once you have an account and have created a database it is very easy to link it to MS Acces FMS inc have a great web page on how to link Acces (most versions) to MS Azure Its actually very easy http://www.fmsinc.com/microsoftaccess/cloud/link-to-azure-sql-database.html

Think this might require money :cool: As a long term project I would suggest Learn about SQL Azure - a developer database monthly pay as you go is about £5 a month for a 2gb 5DTU basic SQL Server database. Its actually very easy to spin up a database now. Getting information in and out of...

I believe 2016 has big int support but I guess this has not been an issue for you. I also read that somewhat crazily this did not extend to the runtime version. https://www.devhut.net/2018/06/05/access-runtime-the-database-you-are-trying-to-open-requires-a-newer-version-of-microsoft-access/...

Top work MajP thanks for assisting.

I tend to build systems where there my popups are set to modal yes and I only have one of these open at any one time. I just find it easier to manage.

Not sure yes its possible to run a vba function from the desktop using a vbscript I have something sorted so I can run compacts. http://rounduptheusualsuspects.org/?p=1386 This is the vbscript which shows where you put your function name it doesn't entirely run it from the desktop though. It...

Congratulations from a newbie