Search results

Hi, I'm struggling with this. All I want to do is edit an existing excel sheet from access one cell at a time e.g. A1 = "hello". I've found several code examples for this but none of them seem to work quite right, I'm either left with the excel doc locked to editing, or for some bizarre reason...

If anyone can help me with this I'd really appreciate it. On a report, I've made if a user prints (saves) it as a PDF it works fine, but if they use the option to have it attached to an email it adds in weird characters. Normal one: command : DoCmd.RunCommand acCmdPrint Odd characters...

I'm trying to write a query that grabs data from a few tables to display in a report. But for some reason, the test in one of my fields is getting mangled it's just outputting some of the end of the field. I think it must be something to do with it being "select Distinct", because without the...

Hi guys, I'm hoping this is an easy one and I'm just blind and haven't found the right option.:banghead: I'm just making charts for a dashboard-type form and I want to have the pie charts etc. not all have the same colour scheme for a bit of variety. How would I go about setting a different...