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
posted the thread
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
N
nector
replied to the thread
Solved
Progress meter for reports & queries in MS Access
.
Many thanks all contributors, Kindly take note that is not the live table by just a fiction table , but the point remain the same was...
Apr 16, 2024
N
nector
posted the thread
Solved
Progress meter for reports & queries in MS Access
in
Modules & VBA
.
I'm trying to develop a progress meter to help users have an idea of how long their report or open record set is taking running, this...
Apr 16, 2024
N
nector
replied to the thread
Solved
How much computer memory is required to run SQL Server Cloud
.
Thank you so much all contributors
Apr 14, 2024
N
nector
posted the thread
Solved
How much computer memory is required to run SQL Server Cloud
in
SQL Server
.
I have come across the statement below suggesting that the memory could be very important to gain speed with MS Access linked to cloud...
Apr 13, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
If you are suggesting some like below: DoCmd.OpenForm "frmCustomerInvoice", Where [InvoiceID] = 0"
Apr 12, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Either you are doing something wrong like binding your forms to tables or queries with no criteria and using Access to filter locally...
Apr 12, 2024
N
nector
replied to the thread
Access query design help
.
Just filter a query either <> 0 in the query grid, I always do it that way
Apr 11, 2024
N
nector
replied to the thread
Solved
the expression you entered is too complex
.
If you are using those codes within access and the DB or BE is access then its fine, but if you want to use the SQL server with Access...
Apr 11, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Yes sir, from my own experience, using the SQL server can only be good if you are running Views for reports. But using bound forms to...
Apr 11, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Many thanks cheekybuddha I will surely settle on your solution , also warm regards to all the contributors all your answers are...
Apr 9, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
try it and see. Why not just use a linked table to sql server - what do you see as the benefit of using a passthrough query? I'm...
Apr 6, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
How about OPENROWSET in a passthrough query can it work here
Apr 6, 2024
N
nector
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Its looks like it does not recognize my access table tblstaffnew
Apr 6, 2024
Home
Members
Top
Bottom