Search results

Not really looking to re-engineer the whole thing as I have most of it working and I don't really want to go importing a load of modules and forms. Thanks anyway though. I'm really just looking for an explanation as to why it is opening up the blank copy of the template as well as the merged...

Hey there. I'm trying to automate a process to load up a Word template and populate it with data from from my Access 2010 database. The process is iniated by clicking a button on one of my Access forms. I have managed to get it working using some code I picked up online (see below) but the...

Anyone got any idea about this one? Still looking for a solution.

Hey folks, I ma currently in the process of creating a pop-up menu to allow my users to do some simple text formatting. I have used the following code to do so: Dim cmbShortcutMenu As Office.CommandBar ' Create the new pop-up menu instance Set cmbShortcutMenu =...

Like JHB says it's probably to do with your use of The IsEmpty() function. I always use the Nz() functions as a fail safe in this type of case. if Nz(me.DocFullName, "") = "" Then That way you can check for null values and empty string in one command line.

I think you might be right. I've just realised that I've reached the maximum height for a detail section in design view and I'm beginning to suspect that is what's causing the erratic behaviour. I've done a bit of resizing on my controls and sub-reports and the problem seems to have gone away...

A couple of other strange things I have noticed: It only seems to occur after a certain point in the detail view. If I create the control further up the report it moves around fine, but as soon as I move it down to the bottom where I want it, the strange behaviour starts to happen. When I...

Just using the cursor key didn't make any difference, I'm still getting the same effect. Here's the sequence of events: I select the control I use the cursor key to move it The control moves the correct position I go to move the control again to fine-tune its position A black line appears in...

Yes I am in design view.

Remove Layout is disabled.

Hi folks, I've recently upgraded on of my systems from Access 2003 to 2010. In the past I've always used to the ctrl key and the cursor keys to move and fine tune the position of my controls on my reports. However since upgrading the controls jump about all over the place when I try to move...

Hi folks, Just signed up to the forum so thought I should do a quick introduction. My name's Baz and I'm a systems developer in the Health Service. I've been using Access for the past 15 years or so but still class myself as a bit of a dabbler. Most of my work has been in Access 2003 but...