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
Insert Data from an Access table to a similar table in MS SQL Server
.
Here is a clean code sir INSERT INTO tblStaff ( EmpName, EmpPassword, UserRights, tpin, bhfId, userId, adrs, cntc, authCd, remark...
Apr 6, 2024
N
nector
posted the thread
Insert Data from an Access table to a similar table in MS SQL Server
in
Queries
.
I thought this was going to be very simple but I keep on getting an error message when I try to run a pass through query to insert data...
Apr 6, 2024
N
nector
replied to the thread
How to update Parent form controls from the child / subform line totals
.
Another way is not to try to use the subform to update the main form, but simply requery the main form. I can see that there could be...
Apr 4, 2024
N
nector
replied to the thread
How to update Parent form controls from the child / subform line totals
.
Do not save any totals data in the main data set. ;) And if this is absolutely necessary (for whatever reason): you are using the SQL...
Apr 3, 2024
N
nector
posted the thread
How to update Parent form controls from the child / subform line totals
in
Modules & VBA
.
I want to update my parent form controls from the results of the subform line totals so that people do not need to capture the results...
Apr 3, 2024
N
nector
replied to the thread
Solved
How to convert an access delete query to Passthrough query
.
Well after trying many way , I have come realise that since I need to the entire data in the temporal table , the systex should be like...
Apr 2, 2024
N
nector
posted the thread
Solved
How to convert an access delete query to Passthrough query
in
Queries
.
I have tried to convert this query below into a passthrough delete query but I keep on getting an error message from the SQL Server why...
Apr 1, 2024
N
nector
replied to the thread
Solved
Access query with linked tables slow
.
Okay thanks Minty I missed the key word snapshoot, very correct
Mar 28, 2024
N
nector
posted the thread
Solved
Access query with linked tables slow
in
Queries
.
I'm only pulling one record at a time to be used by the VBA record set from Cloud SQL server, I'm using this strategy as per advice from...
Mar 28, 2024
N
nector
replied to the thread
Solved
How to clear captured record from MS Access
.
Thank you for the advice to all contributors
Mar 26, 2024
N
nector
posted the thread
Solved
How to clear captured record from MS Access
in
Modules & VBA
.
I want to clear the input form so that new record can be added, I'm using this code below, but it's creating a new PK number, this is...
Mar 26, 2024
N
nector
replied to the thread
Solved
How to convert "" to null in MS Access VBA
.
Okay thanks , this one has worked IIF(Len(rs!stockreleasing), rs!stockreleasing, Null) This was given by Josef P. Many thanks him...
Mar 22, 2024
N
nector
replied to the thread
Solved
How to convert "" to null in MS Access VBA
.
I'm still getting the same "" instead of null by using the provided function: Company.Add "stockRlsDt", NullIf(rs!stockreleasing.Value...
Mar 22, 2024
N
nector
posted the thread
Solved
How to convert "" to null in MS Access VBA
in
Modules & VBA
.
The field below is a date release now sometimes the date field is empty , now in the Json dictionary it keeps return "" instead of null...
Mar 22, 2024
N
nector
replied to the thread
Solved
Failing to save change made from MS Access Front End to SQL Server Cloud
.
GPGeorge & Minty Thanks you so much to you valuable professionals , the timestamp field has sorted out the problem, this has been a...
Mar 19, 2024
Home
Members
Top
Bottom