Minty's latest activity
-
Minty replied to the thread Help with formatting decimal places in calculated query field.If this works: 48: ((36/48)*(([Yards]*36)*[Inches])/1296) Then you correctly added the format in the second version 48: Format(... -
Minty replied to the thread Recordset field not readable after update.I think you misunderstood me. I know it will be valid until you issue .Update Store the value at the start of the insert: Dim NewID as...
-
Minty replied to the thread Recordset field not readable after update.When you issue rs.update the recordset doesn't stay on that record. Assuming your NUOVO_VALORE_DA_GENERATORE_GLOBALE() function...
-
Minty replied to the thread AWF Slowing Down.Buy out Google?
-
Minty replied to the thread DoCmd.SendObject and CDO.I think the effect is far more noticeable / undesirable within the Access ecosphere we inhabit, as developers we tend to leverage the...
-
Minty replied to the thread Speed Up Query.Sorry, this is just wrong - indexes won't help with very badly stored data. It's like putting a small band-aid on a broken leg.
-
Minty replied to the thread Speed Up Query.If you pulled all the station data into one table with an couple of identifier fields for the Building and floors, you would only need...
-
-
Minty replied to the thread Open a form and insert data SQL.I would just set those values as the default values on the form controls. When you then go to a new record they will be the values in...
-
Minty replied to the thread Speed Up Query.That looks very much like very poorly stored data, and I suspect would benefit from being correctly normalised. Any time a table name...
-
Minty replied to the thread Solved How to include line sequence in MS Access Line details table.If this is just displaying existing data then use your MySQL database to generate the row number, why would you try and do it locally...
-
Minty replied to the thread MS Access VS MSQL Server.We support in excess of 40 databases of various sizes that are hosted in Azure SQL with Access front ends. Whist it will never be as...
