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
.
CJ_London's latest activity
C
CJ_London
replied to the thread
Query export to Excel through button
.
I don’t see where the OP has said that and I see no code to indicate they are adding macros to the newly created file. I don’t disagree...
40 minutes ago
C
CJ_London
replied to the thread
Query export to Excel through button
.
@Pat Hartman - perhaps try it for your self - numerous posters on this thread have done so without issue
Yesterday at 7:06 PM
C
CJ_London
replied to the thread
What's your best/worst joke?
.
Yesterday at 7:03 PM
C
CJ_London
replied to the thread
Query export to Excel through button
.
I tried the exact code with a query of my own - and it worked without a problem. you just did it all you didn't say is how many rows...
Yesterday at 5:48 PM
C
CJ_London
replied to the thread
Query export to Excel through button
.
As I stated in post #2 the is nothing wrong with the code so the issue has to be with the query. Either misspelled or requires...
Yesterday at 3:15 PM
C
CJ_London
replied to the thread
Query export to Excel through button
.
no - works in the immediate window ?Environ("userprofile") & "\Desktop\qryCrosstab_Payment" & "as of" & Format(Date, "mm.dd.yy") &...
Friday at 2:04 PM
C
CJ_London
replied to the thread
Query export to Excel through button
.
Nothing wrong with the code so far as I can see. Check your query - does it exceed 65k rows? does it have an error in the data when...
Friday at 9:28 AM
C
CJ_London
replied to the thread
Solved
Hi, stumped with how to build this query
.
Since users can only select one option your use of an option group would work ok since only one value is stored
Wednesday at 3:30 PM
C
CJ_London
replied to the thread
Report opening without record
.
where all events are - in the property sheet events tab this error can apply to many things (just google 'vba error 2501'). But you...
Wednesday at 1:15 AM
C
CJ_London
replied to the thread
Access query question
.
Well first record wont have one before and the last one after so nothing to compare to anyway
Tuesday at 11:24 PM
C
CJ_London
replied to the thread
Access query question
.
You can use a non standard join From tbl1 A inner join tbl1 B on A.idate=B.idate+1
Tuesday at 10:43 PM
C
CJ_London
reacted to
JefJFitz's post
in the thread
Access query question
with
Like
.
I have attached a simplified version of the database that I am working with no proprietary information. It should give you a basic...
Tuesday at 10:39 PM
C
CJ_London
replied to the thread
How to call a module in main code VBA
.
huge number of errors in the code (438, 3078, 'no object' in the control' to mention a few). Plus you have multiple public versions of...
Tuesday at 7:52 PM
C
CJ_London
replied to the thread
Display only yes
.
you can also use the format property Booleans are numbers 0 for false, -1 for true the format property allows for four states...
Tuesday at 8:47 AM
C
CJ_London
replied to the thread
Display only yes
.
They are the same font, but a different character. I’m on my phone right now and if I type “hello” you can see two different ‘quote’...
Tuesday at 7:30 AM
Home
Members
Top
Bottom