Search results

OK started thinking about this.. First issue I've thought of is that I need to deal with decimals rather than integers. I guess I can multiply out to remove the decimals I thought that there might be a remainder issue as well but I don't think there will be because I am not dividing by a...

Thank you that looks like the solution

Dear All Looking for TSQL appropriate for SQL Azure. I have a need to create sub records on a table by calculating a split of a volume. I probably haven't explained that very well but if you see the example below it might be clearer. Essentially I have casks and I want to split them into...

Thank you guys much appreciated

Dear All - I thought I had posted this already but can't seem to find it. That's what happens when you are a bit rusty. Hope everyone is well. Looking to see if anyone can point me in the direction of a good skeletal design of a inventory management system for liquid aclohol management system...

I believe it is creating a web UI and the backend remains in whatever it was before. This is an established pattern for code generators. This has the advantage that you may be able to access the data either by Access or Zoho Creator.

If someone uses a tool that improves what they are doing over what they did before it is a benefit. The fact that it is sloppy or you would have implemented a better option may not be as relevant because you cannot be there to implement that solution. People critisize MS Access for the same...

Its a bit of a problem if you can't get authorisation for a proper backend like mysql / sql server or postgres.. I'm probably not going to take on projects that won't let me get the back end into one of these three. And most of the new tools are starting to drop support for MS Access backends...

I wasn't really worried but people in the past have reported issues so I thought I might have more..

Mainly because I have an Access 2003 installation disk so it was free for me for 17 years.. and I literally had no issues at all until last year. I could even connect to MS Azure fine with it.. For a while it was an advantage to design in the oldest version of MS Access and port forward. I am...

Next time - I thought it was a general conversation about web options for low code development... Can I ask do you have an interest in Zoho?

No problems with the speed seems the same. Its not networked but I would be pretty confident that I could make it into an accde and get it networked. I 'm not a massive fan of the toolbar / ribbon but I can live with it. I never used menus before anyway just having buttons in forms to navigate...

Hey guys I had been holding out for ages but finally issues with the mdb format has meant I've had to move so rather than muck about with suspect copies of Access 2010 just went for Office 365 and... My 2003 personal CRM project pretty much worked out of the box - had to change some...

An alternative to Zoho which is free and potentially you can run on your existing servers is nubuilder https://www.nubuilder.com/ For people who already have the following a) cloud provider offering access to cpanel that has file manager b) cloud provider offering similar access to file...

I've done this before using the following - its in a situation where there is a master table and a child table I'm not sure that might not reflect your table structure.. https://rounduptheusualsuspects.org/?p=1621

Just curious - I think I read that runtime of latest access version had issues with Bigint variable type. Is this the case or was I mistaken in that point or has that been fixed now?

I'm late to the party and plenty of good suggestions above but here is something that I have used in the past it is a combination of a vb script and a ms access function https://rounduptheusualsuspects.org/?p=1386

The 3 2 1 rule seems to be sensible Store 3 backups Ensure they are in 2 locations (2 devices) Ensure 1 is off site I just use rolling backup scripts that takes unique seconds / days / weekly / monthly and yearly backups of the whole database Particularly useful functions I will write up on my...

And here is what some example backup files look like in explorer when I double click on the short cut you can see I made two backups on the 15th April One at 16:45:47 and another at 17:13:14 April file is constantly overwritten with the latest version and will be until May is reached.

And here's a vbs version that will make copies and name them unique to the second I've left in the names of an actual file that I targeted for backup - here its an application that times athletics races which so happens isn't split. The database is pretty small data wise usually only about 200...