Recent content by HairyArse

Yeah that's the problem. I know a Citrix server is probably the best solution for all of this but I've had 1.5 days to set this all up as well as doing a thousand of other things and having never touched Citrix before it's not viable to buy the hardware, configure it, set up Citrix, train my...

Sorry, no I meant build the forms with PHP/HTML/CSS/MySQL and use a bit of javascript for rules, prompts, exceptions etc - I've done similar work for other parts of our system and I know it works and works well, it's just a time commitment I don't have right now. I use the Metronic framework...

Sorry, I've had a completely hectic morning and haven't made myself as clear as perhaps I needed to. I was wondering what the typical professional approach was for people in this scenario. My preferred option, and what I believe to be the best option longer-term is to migrate to a web-based...

All of my entry forms, reports and queries are handled by an Access front-end connected to a local back-end database server. All under this roof. When my users work from home, they are not on this network and currently the only way for them to connect in to the database is through remote...

Oh and my tables are already in a MySQL database. I have XAMPP running on my database server and can manage my tables using PHPMYADMIN.

This system runs every facet of the business so that number of tables is entirely necessary. Actually there are only 153, but your point still stands. But take just a simple Sales order for instance. The following tables are all required and essential. Sales Order Sales Order Detail Customers...

Caspio actually looks great but at $8 per month per additional form/report/table outside of the initial offering, for this project at least, it would soon get very expensive.

Hmm. The other thing I have to contend with is that these are low skilled users uncomfortable with anything outside of even the most basic of operations. Trying to talk them through installing remote desktop software alone was painful and time consuming. I came across Caspio myself earlier and...

I work for a small company (25 employees) 10 of which are database users. We have an internal Access Database we've been using and developing for the last 10 or so years. Needless to say it's quite complex and there's a lot to it. Access front-end connected to a local MySQL server backend...

OK I've come up with a solution. Might not be the most elegant but will help me get this job. I've added 5 new fields to the products table - fault1_combined, fault2_combined etc. Then I've run separate queries against each record in the pieces table, concatenated the values and then inserted...

As the three fault1 types are individual records in the fault1 table, the difficulty comes in combining all of these into a single string to display against each piece. In PHP/MYSQL I just run an separate query in each 'cell', but I don't know how I'm able to do this in an Access report short...

It's too late to change the structure of the tables. Faults continue to be logged and I have a whole separate PHP/MYSQL/HTML data input system setup for use on our tablets. Fault1 means a fault within category type 1. A Category type 1 fault can be a knot, a slub, a spot or a stain. Category...

Fault3 doesn't need a type. That's not a mistake.

I've built a system to log faults against products. Each product can have 5 types of fault. Fault1, Fault2, Fault3, Fault4, Fault5. Each product can have multiple instances of each fault type and for each fault logged, the metrage is also logged. For instance: Product 1 can have a Fault1 at...

Actually, removing the input mask doesn't technically sort it. It's just that without the input mask it's impossible for the cursor to be anywhere other than at the start.