Lots of questions :(

[systematic]

Hi all,

I am at the tail end of developing my first serious database, a customer enquiry management system. It has been a very long haul - and a very steep learning curve for me!

I have compiled lots of feedback from my users after some testing - and have a number of things I am uncertain about. While I have managed to find answers for most of my questions (either through research or my exploring code/DB settings) - I am hoping some light may be shed by posting here

1. When a customer enquiry is submitted, a new form is opened that displays information in a printable format.

Up to 8 checkboxes may be selected on the original form, and depending those checked will then populate a listbox. I was using the .AddItem method, eg -

If Forms!MyFrm!chk1.Value = -1 Then
With MyListbox
.AddItem ("MyCheckBoxAssociatedString")
End With
End If

I had an IF statement for each checkbox. So if 3 boxes were selected, 3 items would populate in the listbox.

Access 2000 does not recognise this method - so I changed .AddItem for .RowSource. Now it is not populating the listbox correctly (only placing one string in the listbox).

Can anyone suggest a way of making this work?

2. Is there anyway to control the mousewheel scrolling? It seems to jump up and down my form erratically - I would like to slow it down a peg or two!

3. For text input boxes that have an 'Input Mask' - I am having some difficulty controlling the user interaction.

eg. My input mask is Aaaaaaaaaaaaaaaaaaaaaaaa for a surname.

Firstly - the input mask creates a line in the box. Secondly, if the user clicks in the box - the cursor is positioned where they click - not at the 'start' of the box.

Can this be changed?

My apologies for the long post and numerous questions....I am getting quite desperate for answers so would appreciate any assistance that can be provided.

Thanks

Robert

 

[KeithG]

First off for your comboBox population you need to create a list of values seperated by a ";". Currently you are just changing the row source with the value related to the checkbox. You need to change your IF statement to something like below

If Forms!MyFrm!chk1.Value = -1 Then
With Mylist
.Rowsource=.rowSource & AssociatedValue & ";"
End With
End if

I am not quite sure about your input mask problem.

 

[MarkK]

3. Just remove the input mask for a field masked as Aaaaaaaaaaaaaaaaa. An input mask can be useful if you have formatted data like a zip code, phone number, Canadian postal code like A9A-9A9, but for names the mask just gets in the way. My opinion.
Cheers,

 

[systematic]

Thanks both for the replies...the cbo problem is all fixed up (cheers Keith!) - unfortunately for the input masks they are required - so I will have to try to find a way around my little problem.

Cheers

Rob