Search results

Thanks for your message. I will check the location when I next view her screen although previous versions of my db have run ok. I was looking for anything labelled "Enable" but couldn't see anything. Most of the program works fine; it just doesn't want to run the code.

Someone is using an Access db I have written and it includes code which runs fine on my computer. However, on hers, the code does not run at all. Is there a setting I can change?

Many thanks for such a quick response. I have printed the document and am studying it carefully, but I am completely puzzled. This used to be such a simple and quick operation, but now I just can't link to a new back end file. One way round seems to be to rename the new back file to be the...

I want to re-link my front end to the tables, but the Linked Table Manager now looks completely different and has buttons labelled "Refresh", "Relink", "Add" and "Expand All" among others. Can anyone please direct me to some instructions on how to use this form. I have tried all sorts of...

Fantastic. That works perfectly. Thank you.

Yes. That works too. Many thanks.:)

An expression to get the last day of this year is DateSerial(Year(Date()),12,31) but I am trying to figure out expressions for both the First Day and the Last Day of LAST year. This is so that I can prepare queries for sales info etc for the whole of last year.

Many thanks indeed. That looks to be just the job. Thank you.

Many thanks. I'll take a good look at those ideas. Andrew.

Is there an add-on program for Access whereby you could type in a UK postcode and it would display the addresses belonging to that postcode?

That's done it. Many thanks. Fantastic!!

In the query design grid I'm trying to concatenate a short piece of text with a currency field. It works, but unfortunately the currency then appears with lots of decimal places even though it appears everywhere else with the normal 2. I've tried setting it to 2 in the Properties formatting...

Many thanks. I've uninstalled the nl version. I'm sure it was Dutch because all the prompts were in a language that looked like it. It all seems to be running a bit quicker now as well. I will let it settle and then go for the Repair again. Thanks again for all your help; it's very much...

Although I didn't have a disk (hardly anyone does now, I think), I pressed F1 for Help and went to the "Repair" section and I chose Online Repair. It's hard to be certain with any sort of intermittent issue, but I do believe it has solved the problem, so a huge thank you!! Whilst in the...

Access 2016 (bought as pre-loaded on a Dell). Strange phenonema recently both on desktop and laptop. In form or report design, after grouping two objects and using Left/Right align or sizing to smallest/largest, it works the first time, although it leaves the options box on the screen. Next...

Great stuff! That's working very well, thank you. I had previously put code into the On Double-Click event. Thanks again.

Thank you for the link - there are certainly lots of useful shortcuts there. For PasteAppend, I have tried using a docmd action as described in another thread. It works fine, but a standard shortcut would have been even better. Thanks again.

I often use Ctrl+V for Paste. Is there a shortcut for PasteAppend?

Absolutely fantastic. Thank you so much; that has worked perfectly. I'm so grateful; I would never have found that however long I looked. What a great forum!! Thank you.

A 2016. Under options, if I choose Datasheet and then Default Font size, I see a combo box with the expected values. However, after selecting one and then closing/re-opening the database, the font size has not changed in any subforms viewed as Datasheets. If I change the value for default...