Search results

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...

How many rows are there in your table and do you have duplicates in the data? If less than 255 unique values then you could use a crosstab - it would look something like TRANSFORM First(Description) AS SELECT "Row" AS Expr1 FROM tblCurrent GROUP BY "Row" PIVOT "Field" & [ID]; gives you this...

That is not my query. you are missing the non standard left join SELECT TranDetail FROM tblTransactions LEFT JOIN tblSuppliers on tblTransactions.TranDetail like "*" & tblSuppliers.SupName & "*" WHERE tblSuppliers.SupName is Null

Suggest provide some example data and the outcome required as your description is too vague. also ‘description’ is a reserved word and should not be used as a field name

if you use sql to connect to the text file (or use transfertext to link to the file) you can do all that in a single query (or one per table you are appending to) using a few functions such has the one we have been discussing and joining to other tables as lookups (such as joining on the...

are these all the options for what you want returned? It looks like a similar scenario I have with with my accounting apps. To handle this I simply have a table containing the required (in this case) supplier names then using a simple query such as SELECT [Enter SupName], trandetail FROM...