Search results

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

Seens to me you are missing a bunch of declarations

Is the file actually a.xlsx or a .csv or.txt file? If not a .xlsx then opening either of the other two formats as a .xlsx can change the format. personally I never import from excel formats and use .csv as it is more stable as for testing, rather than just continuing, abort the process and...

Not quite true- you could add a record, add some more then edit an earlier just added record before closing the form. I think filtering or sorting will also clear the form

Forms rarely work without data - so what type of form are you referring to? If you did upload such a form, you would need to rebind the form to your dataset and perhaps the uploaded form has different expectations regarding relationships, data types etc. which won’t be documented. and what is...

it is in the list of reserved words https://learn.microsoft.com/en-us/office/troubleshoot/access/reserved-words may be OK for a query in this situation, but can cause issues in other areas of Access where 'description' is a property and typically results in misleading error descriptions...