Josef P.'s latest activity
-
JJosef P. replied to the thread Solved accdb v accde.I would remove On Error Resume Next and replace it with explicit error handling to find out the issue.
-
JJosef P. replied to the thread How to return a 0.0 in MS ACCESS VBA.You must distinguish between the stored value/data type and the visual representation. I thought you would want something like that in...
-
JJosef P. replied to the thread How to return a 0.0 in MS ACCESS VBA.How did you adjust the highlighted lines in ConvertToJson function? => Case VBA.vbInteger, VBA.vbLong ' Number (use decimals...
-
JJosef P. replied to the thread How to return a 0.0 in MS ACCESS VBA.When inserting/converting into the JSON string, you can format the number as you wish. If you use the JsonConverter from Tim Hall...
-
JJosef P. replied to the thread Optional Variant in Inventory Control code.Change Controls to Fields ... I overlooked the fact that you take the values from a recordset. lngQtyLast = Nz(.Fields("Zone" & vZone &...
-
JJosef P. replied to the thread Optional Variant in Inventory Control code.A few thoughts: You can also check explicitly with IsMissing. Public Function onhand(vProduct_Code As Variant, Optional vAsOfDate As...
-
JJosef P. replied to the thread How to create multi value select in access form and add values in database table.An example file with several variants: https://github.com/josef-poetzl/access-examples/blob/main/forms/MuliValueSelection.zip Continous...
-
-
JJosef P. replied to the thread Preventing System Admins From Accessing Database.Note: And if someone has the rights to copy the backup file, they can restore the database in their own server instance in which they...
-
JJosef P. reacted to theDBguy's post in the thread Preventing System Admins From Accessing Database with
Like.
There's no way for me to test this, but my understanding is if you left SA in, then they can reset its password. Or, if you took out... -
JJosef P. replied to the thread Solved Caching recordset in MS Access VBA.Only opening the query or measured incl. moving to the end of the data records?
-
JJosef P. replied to the thread Solved Caching recordset in MS Access VBA.That should already work. Is there an error message for this? Have you already tried this variant? SELECT ProductName, ProductID...
-
JJosef P. replied to the thread Solved Caching recordset in MS Access VBA.[OT] Making the select statement with the joins available as an SQL server view (in FE as linked table) or using a pass-through query...
-
JJosef P. replied to the thread Need help with data filtering form.2 Tasks: 1. generate filter expression (where condition) - When changing the length option group, supply the textbox for manual filling...
-
JJosef P. replied to the thread Tools for frontend development.Ivercy also supports the MSSCCI interface. Alternatively, there is also OASIS-SVN or the open source application msaccess-vcs. I now...
-
JJosef P. replied to the thread Access Europe - Using VBA to create a class based on a table - Wed 1 May.Note: A useful article on the topic of member variables: https://nolongerset.com/this/
