Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
nector's latest activity
N
nector
replied to the thread
How to return a 0.0 in MS ACCESS VBA
.
If SomeNumericField = 0 Then JsonValue = "0.0" Else JsonValue = SomeNumericField End If But the program keep on rejecting "0.0"...
May 14, 2024
N
nector
replied to the thread
How to return a 0.0 in MS ACCESS VBA
.
Case VBA.vbInteger, VBA.vbLong ' Number (use decimals for numbers) ConvertToJson = VBA.Replace(JsonValue, ",", ".")...
May 14, 2024
N
nector
replied to the thread
How to return a 0.0 in MS ACCESS VBA
.
Sorry sir This is not work see the amended cod below , and yes i'm using the module for Tim Hall: Public Sub CmdCwrite_Click() Call...
May 14, 2024
N
nector
replied to the thread
How to return a 0.0 in MS ACCESS VBA
.
These are values required in Json , we have to comply
May 14, 2024
N
nector
posted the thread
How to return a 0.0 in MS ACCESS VBA
in
Modules & VBA
.
I want to return a 0.0 if this co.de below has a zero value, the zero should not be a string but a number. Round(Nz(Me.txtclassC1, 0), 4)
May 14, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Okay for curiosity sake I seam to develop some ideas, how about working directly with the server before coming to the said record set...
May 12, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Have you considered using an ado disconnected recordset rather than caching The entire program is using DAO to switch to ADO means...
May 11, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Do you mean between 10 and 50 records? Yes and even more depending on the number of records or lines
May 11, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
The statement that rings a bell is "run the loop". WHAT loop? The query should bring down ALL the records you need to export, not one at...
May 11, 2024
N
nector
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? Yes I did there are no errors at...
May 10, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
How many records does QryJsonPos001 typically return? About 10 and 50 zeros
May 10, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Making the select statement with the joins available as an SQL server view or using a pass-through query is not an option? I used a...
May 10, 2024
N
nector
replied to the thread
Solved
Caching recordset in MS Access VBA
.
Thank you so much uncle GIZMO. We have done and followed the rules of SQL Server, example: (1) All the forms open empty including its...
May 10, 2024
N
nector
posted the thread
Solved
Caching recordset in MS Access VBA
in
Modules & VBA
.
Hi all, I'm trying to speed up the record set in MS Access being used by the VBA code below, see the code, but I got mixed up in the...
Apr 18, 2024
N
nector
replied to the thread
Solved
Progress meter for reports & queries in MS Access
.
But I will not give up on this one no matter what, a solution will be found soon, I had the combo boxes problem before where 3 million...
Apr 16, 2024
Home
Members
Top
Bottom