Some more questions for the day

[Douglas]

Howdy all, its me again.

Boy have you ever had one of those days when you are working on a DB and everytime to fix one thing you find 3 more to fix and have no idea how too?

Here are a few of the ones I haven't been able to figure out yet.

1. Is there anyway to code an input box in a form so that it will automatically make all letters capital?

2. Is there anyway to make a combo box display one value as default, but still have the ability to change it?

3. How do you make a combo box drop down list scrollable (ie. you can scroll down the list using the mouse wheel) within a form.

4. and one more. =) I am doing a data base that uses auto numbering for the records as the key field, I also use our computer MMCN# as a special field (i.e. you can not enter in the same information in this field more than once). When you open the database you come to the front page offering choices of either "entering data" or "viewing reports". What I would like to do is have is to that when you click the "entering data" button a "search box opens" requesting the MMCN# of the equipment..then if the MMCN# is already in the database then it would go to that record in the form. If the MMCN# was not in the record list then it would go to a blank form for input.

Doug

 

[Adrianna]

Douglas,
Okay...I'm on my way home, but here is something for you to work on:

1. Use the > greater then symbol to keep everything upper case!

2. You can set a default value to your combo box. Just right click on the combo box, select properties, and scroll down until you see "Default value"

3. I don't know what you want to do with the combo box, but if you have a combo box instead of a list box...you should be able to put your mouse over the the field...and scroll. Mine does that! If there is more then one entry...which 99% of the time there is...just select the field and scroll away!

4. You can write some code to run from your switchboard or if you have made your own switchboard forms, then just ad a command button with :
The form set to open with a query as the control source. In the MMCN# field make the criteria [Enter the MMCN# that you wish to review: ]
This will prompt the user to make an entry and it will filter your form so that they users will only be provided data for that entry.

Also..if you do this....in the OnNoData() Event, don't for get to use a
Msgbox " You have either entered an invalid MMCN# or there are no records currently in the system with that reference"
DoCmd.Cancel Event

Just my recommendation

 

[Douglas]

Adrianna,

Thank you for the great info. I just have a couple of question on what you said.

on number 1. Where do I use the > symbol?

On number 2. I want the default value to be a value from a table, how do I go about doing this.

on number 3. I created the form using a Tab control, will this affect scolling? as when I do use the scoll button it just scrolls the records not the lists in the drop down box (even after clicking withing the box).

Thanks
Doug

 

[mattbland]

hey,

If the textbox is bound, go to the corresponding table and look for the input mask bit. click on help and it'll give you all the characters to create what you need.

if unbound - click on properties and its on there too.

Matt

 

[Adrianna]

Douglas,

1. Place the > before the input mask (to establish an input mask, type "input mask property" into the Access Help index. THis will give you all of the characters that will determine the formate that you will require from your users.

2. Do you need your default to be dynamic? I have many fields that default to N/A or "Not Yet Selected" because I will not accept null value or because the defaults are the most commonly used. just type in the value that you want to set as your default....if it's in your table, just make sure that the value's match....if it's text...place quota around it!

3. if you scroll I have noticed that it will scroll through the records and this is terrible...it confuses users. But if you select the field with the mouse and while the mouse is over the field, you scroll....it will scroll the combo box field!