Search results for query: *

Thanks very much for the replies, Unfortunately I couldn't get this to work as desired so have abandoned this idea and gone back to just using a command button to remove the item from the list.

Thanks very much for the response, Unfortunately none of your suggestions have resolved the problem. I has already tried moving focus to another control and back again without success. I tried form refresh and listbox requery, but the only thing that works is displaying a msgbox which when...

Hi all, I have an unbound single select listbox on an unbound form. I have the following code on the On Key Down event of the list box so that users can remove an item from the listbox using the left arrow key on the keyboard. After removing the selected item I want the user to have the...

You could create one main form, put a tab control onto the main form and then add as many pages to the tab control as you want forms open at once. On each separate tab page put a subform control containing each of the forms you want to display.

EDIT.... With more experiment I have changed the mailto html to read: <div>&nbsp;<a href="mailto:enquiries@here.org.uk">mailto:enquiries@here.org.uk</a></div> This now opens the default mail client and adds the correct 'to' address : "enquiries@here.org.uk" the only problem being now is that...

Hi I'm having problems getting the mailto hyperlink working in a text box on a form that has text format of "rich text", control source being a memo data type. To test the rich text control and source i have created a form with 2 text boxes, one set to rich text the other plain text so that i...

Thanks for your input. \N000 works well as the display format. I was hoping to create an input mask as well using \N000;0;_ but unfortunately the leading zeros are not displayed just blank _ placeholders, so PRNid of 11 displays as N011 but when entering the field N_11 is displayed. I guess...

Hi, I have an identification number (PRNid) stored as a integer in the underlying table. On a data entry form i have a textbox with the control source set to PRNid. I want to keep this number as an integer but when ever it is displayed on a form or report it need to take the format "N000" -...

Thanks Hugh, Sorry for the delay in responding but had to wait until i was back on site as the original code words fine on home PC. AppActivate is indeed available for VBA. And after a couple of tries it eventually worked. If anyone else could shed some light as to why the original code did...

Having just tried to reproduced the steps involved in it working properly and then not working i have found the following situation... I open the database, navigate and open an approriate form which has the spell check functionality - click on the button and the dialog is not shown - i then...

Hi, I have an extremely frustrating problem. I have developed an Access database (Office 2007 on Windows 7). I want to allow users to spell and grammar check certain information that they enter onto the system. As Access has no native grammar checker I found and adapted the following code that...

That is perfect. Thank you very much Tony

I have the following macro that reads content control values within a word document - saves them to a back end database and then opens the front end to show an access form/subform and highlights the record that has just been changed: Sub TransferDate() 'On Error GoTo ErrHandler Dim cc As...