Latest activity
-
The_Doc_Man replied to the thread Solved HELP WITH VBA ON SUBFORM.If you want to force a sub-form to refresh after you do something in the parent form, [name-of-sub-form-control].Form.Requery The... -
esturgesjr replied to the thread Solved HELP WITH VBA ON SUBFORM.Ugh, a slight problem. When I run the above code (which is running from the AfterUpdate on the Main Form), the subform is NOT refreshed... -
Pplog replied to the thread SQL problem.Apology and thanks accepted. When you want to hardcode SQL inside VBA you should first get your SQL correct by using the query...
-
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...
-
Pplog replied to the thread SQL problem.1. You make it so much harder to debug SQL when you have it in VBA. It's like a game of telephone you have to play to get to the SQL...
-
Ttvanstiphout replied to the thread Enhancing a small form.The old-fashioned way. I saved a color bitmap at (in this case) 48 x 49 pixels. Then dropped a button on a form, and clicked on the ...
-
JPublic Function getBoxContent() oDB.Execute "DELETE * FROM counted", dbFailOnError sQry = "INSERT INTO counted ( Family, Infra...
-
The_Doc_Man replied to the thread Enhancing a small form.There is no reason you cannot stack something on top of something else and have it sometimes visible, sometimes not. And if it is...
-
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...
-
MMark_ replied to the thread Have you ever been pressured into building something with a bad design?.Depending on what fields are prompted, I can see a separate form that is used with cash purchases to avoid prompting for payment method...
-
Ttvanstiphout replied to the thread Solved SSMS22 Application Itself Slower Than SSMS21.WRT the connection used by SSMS: it says so on the Connect dialog: ADO.NET
-
-
isladogs replied to the thread Form with subform in transaction.I floated that idea as a possibility almost a year ago. See... -
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...
-
