Recent content by CJ_London

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 with using the correct terms but in this case it is irrelevant in that either term creates a file, distracting from trying to find a solution to a file not...

@Pat Hartman - perhaps try it for your self - numerous posters on this thread have done so without issue

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 it produces At least provide the sql to your query

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 parameters (name implies it is an xtab so any parameters must be declared) we are now 17 posts in and the OP would appear to be ignoring this simple check

no - works in the immediate window ?Environ("userprofile") & "\Desktop\qryCrosstab_Payment" & "as of" & Format(Date, "mm.dd.yy") & ".xlsx" C:\Users\ChrisA\Desktop\qryCrosstab_Paymentas of05.03.24.xlsx missing some spaces I suspect to make it readable and personally I wouldn't use . as a date...

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 executed? are the parameters populated? (for Xtabs you must specify the parameters)

Since users can only select one option your use of an option group would work ok since only one value is stored

where all events are - in the property sheet events tab this error can apply to many things (just google 'vba error 2501'). But you should have a message as well which tells you where to find it. Since you are talking about reports, my guess would be this link will be indicative...

Well first record wont have one before and the last one after so nothing to compare to anyway

You can use a non standard join From tbl1 A inner join tbl1 B on A.idate=B.idate+1

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 the function and your module has the same name. Change the name of the module to something like 'modUseHand' and comment out or remove all the UseHandsfunctions...

you can also use the format property Booleans are numbers 0 for false, -1 for true the format property allows for four states positive, negative, zero, null separated by semi colons. So you could just set the format for the mandatory control to ;"Yes";; or to add a bit of colour ;[red]"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’ characters https://www.cl.cam.ac.uk/~mgk25/ucs/quotes.html think it is factor of keyboard settings

And how are you calling it from the mousemove event? Show the code if vba or screenshot of the property also recommend you have option explicit at the top of every module