John Sh's latest activity
-
JJohn Sh replied to the thread Solved query not working with empty control.That's exactly what I was trying to do, in a testing phase.
-
JJohn Sh replied to the thread Solved query not working with empty control.Thank you Tom I have set the table defaults to "" and had also changed the contents of cboinfra to " ", so with a definite space, just...
-
JThis query fails if the control "cboInfra" is an empty string. The field defaults to "" and I have tried " ". I have tried various...
-
JJohn Sh replied to the thread SQL problem.Exactly. So why are we now at post 15?
-
JJohn Sh replied to the thread SQL problem.Hi Ken. The table "Boxes" is an interim table that collects raw data. The data in "Counted" is also interim data. This data is then...
-
JJohn Sh replied to the thread SQL problem.I have attached a tiny sample of the final table. It is 1850 records long. I would be delighted for you to show me how this can be...
-
JJohn Sh replied to the thread SQL problem.This is just one of a string of queries that generate a table that lists all the errors from an inherited database. Many of the errors...
-
JJohn Sh replied to the thread SQL problem.Thanks. Already sorted this one out
-
JJohn Sh replied to the thread Enhancing a small form.Thank you both. I'll play with it although I did try a bitmap and still got b/w. It seems there is also a way to do this with a png but...
-
JJohn Sh replied to the thread SQL problem.3. The problem is that when you use an aggregate function in the SELECT (e.g. COUNT, MAX, MIN, etc.) you need to use a GROUP BY if you...
-
JPublic Function getBoxContent() oDB.Execute "DELETE * FROM counted", dbFailOnError sQry = "INSERT INTO counted ( Family, Infra...
-
JJohn Sh replied to the thread Enhancing a small form.How? According to all I have read, the only way to have a coloured image on a button is to use a "Shared" image, not embedded. I have...
-
JOver the years I have received much needed help from many on this forum, so now it is my turn. This might be an old trick but I put it...
-
-
JJohn Sh replied to the thread Unable to reduce form's detail size.So Simple. Ta muchly.
-
JThis is best explained in pictures, see below. I have a simple form with two buttons. I would like the form to encompass the buttons but...
-
