Recent content by Heathy

Hi. Hi. I am aware there are differing opions on Html emails. However, I have been requested to produce an html document to email to specific recipients in this format. Some of the html functions I need to use are not handled well by the Email client I am using (Outlook 2007), let alone...

Hi. I have an access 2007 database in 2007 format. Access 2007 SP 2. I have a field on a form bound to a date field with format set to short date and show date picker set to yes. It has been operating correctly for months. However, in the past few days, when selecting a date from the date...

Hi. I have an Acess 2007 database containing a linked public folder from Outlook 2007 in it. The user only has one outlook profile and that is set to be the one that opens in the control panel. When outlook is started it does not ask for the required profile, however Access does. If anyone...

The DB was originally developed in AC 2007 and I have tried deleteing the list box saving the form, recreating the list box with the same results... VBAInet, thanks for the input, I have tried your code also at requery of list box, same results.

I have now, installed office 2007 sp2, but still no good. Thanks for all your help.

That is correct. What version of Access are you using, I am using 2007. There is no code/macros associated with the list box.

I have attached ascreen shot without the header row on the listbox, to show that the problem still occurs. I have done as you suggested and check the results under each set of circumstanses. If I just select row 1, correct results. control and row 2, correct results. In fact all rows using...

Thanks again for your responses. Attached are screenshots of your suggestion David. I have checked the listbox, there is no code associated with it, I have removed the headings and changes it from extended to simple and back again. The problem does seem only to happen when using the shift and...

Thanks again. On looking at your code I thought, yes good workaround and tried it alongside the original test code:- Private Sub Test_Click() Dim x As Long, cnt As Long cnt = 0 MsgBox (Me![stk pals].ItemsSelected.Count) For x = 0 To Me.[stk pals].ListCount - 1 If Me.[stk pals].Selected(x) =...

It appears, I may be getting closer to solving this, the problem looks like it is only happending when the shift key is used in conjuntion with the control key to select multiple items, when the control key is used by itself the code performs correctly. Any further ideas would be great. Thanks...

Thanks for reply David. However, I didn't mention the results are not consistant. The reported figure changes, sometimes giving the correct result and not in other cases. Very strange.

Hi. I have a listbox which is Extended Multiselect. I have code that run based on the click of a command button, the code run through all itemselected. However, when the command button is clicked the number of itemselected.count is one more that that selected. I have simplified the code, to...

Hi. I had a corrupt replica of my database (which only contains tables), and carried out a repair on it. However, I was unaware there may be a problem with it losing it's replica status. Unfortunately, I did not notice this at the time, and many chages have been made to this replica in the...

Hi. Can you please advise if there is any way to Fully justify text in an Memo field set to Rich Text format in Access 2007. I understand the field contains essentially HTML data. Thank you.

Hi. I have searched the forums for any reference to these type of file. Google provides limited results. I was hoping someone may be able to point me in the direction of some resource regarding the above files used in the travel industry. Thanks in advance. Stuart.