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
.
Kingz's latest activity
K
Kingz
replied to the thread
Access 2021 compiled for accde file
.
First of all, thanks for all the information! I'm left with a very confused frame of mind now however. Let me maybe elaborate on what I...
Apr 23, 2024
K
Kingz
posted the thread
Access 2021 compiled for accde file
in
General
.
Hi, I thought an accde file, wouldn't give the user access to the tables and queries, but I don't see any difference to the developing...
Apr 22, 2024
K
Kingz
replied to the thread
Docmd.Transferspreadsheet
.
It works for me! I read it somewhere and tried it. I think the main purpose is give you a chance to say exactly where, say...
Apr 20, 2024
K
Kingz
replied to the thread
Docmd.Transferspreadsheet
.
Ah, I've found it... It's "Range" oddly enough ;) Thanks
Apr 19, 2024
K
Kingz
posted the thread
Docmd.Transferspreadsheet
in
Modules & VBA
.
Hi, I was wondering if I could rename an excel export. I'm actually surprised there isn't a "sheetname". I guess I could rename my query...
Apr 19, 2024
K
Kingz
replied to the thread
Several executes with currentDB possible?
.
Yeah, sorry for replying in words. I liked what you wrote, and made the appropriate changes to delete from, rather than drop the...
Apr 16, 2024
K
Kingz
reacted to
GPGeorge's post
in the thread
Several executes with currentDB possible?
with
Like
.
All of that sounds reasonable with the exception of the need to repeatedly create new tables using the "SELECT INTO..." syntax. If, as...
Apr 15, 2024
K
Kingz
replied to the thread
Several executes with currentDB possible?
.
Ok, to give you whole the picture, I'm using pass through queries to access a database, because the query is complicated, consisting of...
Apr 15, 2024
K
Kingz
posted the thread
Several executes with currentDB possible?
in
Modules & VBA
.
Hi guys, I was wondering, I have an SQL statement which was dynamically created and which I have stored as such: Set Qds =...
Apr 15, 2024
K
Kingz
replied to the thread
Saveas method with workbook
.
First of all, thanks.. I've got a problem with this, which might explain the general difficulties I'm having. I can't declare like you...
Apr 15, 2024
K
Kingz
posted the thread
Saveas method with workbook
in
Modules & VBA
.
Hi guys, I'm trying to simply export data in a recordset to an excel file, which I show in the code. Unfortunately, only a manual entry...
Apr 15, 2024
K
Kingz
replied to the thread
CTE Passthrough query giving error(3129)
.
Fantastic!! Thanks for that!
Apr 10, 2024
K
Kingz
reacted to
Minty's post
in the thread
CTE Passthrough query giving error(3129)
with
Like
.
You need to open it using the correct parameters, so you need to set the query def to return records. Something like (untested)...
Apr 10, 2024
K
Kingz
posted the thread
CTE Passthrough query giving error(3129)
in
Queries
.
Hi guys, I've got a complicated CTE query (strQuery) which works as a passthrough query, so I needed to dynamically set some dates in...
Apr 10, 2024
K
Kingz
reacted to
cheekybuddha's post
in the thread
Opentextfile leads to error 5
with
Like
.
Do this. (y) Option Explicit will then be added automatically to all new code modules But you will also need to add it manually to...
Apr 10, 2024
Home
Members
Top
Bottom