Search results

There's a good quote in that original article which was "When they created Access the problem was that they did too good a job.." The query designer still seems much better to me than SSMS Similarly the relationship designer seems better than SSMS Master Details form designer is absolutely...

I had one application that I had been running for over a decade. I settled on a split front and back ends and I took copies of the back end and the development front end. I would not keep copies of the runtime front end and I just compiled the front ends from my latest development copy. If I...

I vote however I am aware that you are being sold ideas (no matter who you vote for) and irrespective of the background of the individual it is likely they will have to skewe reality and what they can deliver in order to get in. I see it in myself sometimes when I am selling something at the...

Many thanks

View table definition in TSQL TSQL

OK will add some notes in this thread Something similar with Oracle

In Azure SQL I was wondering if anyone had tried to save the Create table/view generated SQL scripts in some way automatically to a linked ms access table from specified remotely linked SQL Azure database. I only need specified tables and views.. (I am talking about SSMS which has an option to...

Thanked count is the one thing I miss I wonder might be worth making a suggestion to the developers of the forum software?

One thing I would say you might want to investigate which I don't think has been discussed is time period. Typically in sales/production environments you want to know the popular sold & produced units in the last year / month or week in relation to all other time periods. The most popular of...

I'm just thinking about this kind of thing now. I'm thinking of a structure where you have one table for everyone and relatives (at least genetically) are referred to each other by their parentage. To try and prevent loop through input of wrong data. A parent mother or father must at least have...

Hang on I see there is an actual relevant thread in the Modules and VBA posted yesterday of all times... I'll have a look at that.

Dear All I have a single table of a list of persons that is referenced to itself for the father and mother field. So lets say its called t001 and has a primary key of PKID structure is similar to the following where pkidt001mother and pkidt002father is referenced to itself. pkid firstname...

I think I just enjoy the act of investigation more than 'work' sometimes.. I know I can get easily distracted when I have been on a project for a while and I suddenly remember some interesting thing that I wanted to take a look at..... 5 hours later...

On a bit of a tangent please be aware that I think Access at least 2003 (I suspect it is the same for all other versions) could only handle about 13 nested iifs in a single SQL statement before it errors. I was once involved in a ETL project and had to replace a lot of values in a table I ended...

Just went to Utter Access its consistently reading in the 2.5 second mark however looks like it is asnychronous loading as first paint looks like it comes in around the 0.5-1 second mark and then it takes a while to load in adverts etc... leading to the final time in the mid 2-3 second mark...

Excellent question - this new site is pretty fast for me.. I actually have a chrome plug in which I use to measure all web applications that I build and it just measures every page time I go to. Load Time Plugin Chrome And for me on the desktop (I can't measure on my mobile) I'm getting load...

OK not sure how that works but will try it out.

Congratulations Jon so far I think the only thing I miss is the thanks record. Mobile experience is vastly better.

Here's another reference about finding maximum or grouping child records which is similar to the link to Allen Browne's site but maybe not as indepth Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value

I think Xenforo does appear to be an improvement. Would like to see the stats more easily of posters but once you know where to look its probably ok... I've come across width concerns with responsive designs as well. Sometimes its easily configurable and sometimes its not. Width however is...