Newbie question about Forms

[Mljohn]

Is it possible to create a form or report that allows me to look at one record at a time?
It needs to be read only (doesn't affect any table data).

Also it allows me to type in a box and as I type it tries to out guess me.

I just want to look up info in an organized form.

If there is a way how do I do it?

My fields are: Item, Cost, Retail, 10% Discount, 20% Discount

Thanks

Matt

 

[boblarson]

You can have a form which has the Allow Additions, Allow Edits and Allow deletions set to NO (so read only), set it to SINGLE FORM, and then you can have a combo box which, if you set the autoexpand property to yes can start finding the item name you are typing as you type and if you use the On Change event of that combo box, you could requery the form and have it actually find the records as you type. Only problem with that one is that it can be slow depending on how many records you have. You might check out this "Better Record Finder" from MVP Armen Stein.

 

[ajetrumpet]

Is it possible to create a form or report that allows me to look at one record at a time?
It needs to be read only (doesn't affect any table data).

Also it allows me to type in a box and as I type it tries to out guess me.

I just want to look up info in an organized form.

If there is a way how do I do it?

My fields are: Item, Cost, Retail, 10% Discount, 20% Discount

Thanks

Matt

matt,

for all of your questions, try these:

*lookup the "allow" properties on the data tab of the property sheet
*set the form to a single form, not continuous on the "general" tab
*for the typing thing, you need code behind the keypress event or change event of the control you're typing in...

 

[Mljohn]

Thank you ajetrumpet and boblarson for your help. Please remember that I am a newbie on Access so I will need more detail.

I created a test table and a test form from that table.

1) I had 3 fields: Company, Item and Qty
2) I added in design view a combo box and linked it with the "company" field by answering the questions.
3) I deleted the other "company" box in the form.
4) I selected the combo box and went to properties. In the "Data" tab I saw "Auto Expand" and it said "yes". Also in the "Data" tab I saw "Allow value list edits" I changed that to "no". I did not see any other "Allow" options.

I do not see any "general" tabs to change the form to "single"

I found the "Event" tab and the "On Change" but I don't know what to do with that or how.

So far when I type in a company name in the "company" combo box the other fields don't show the correct info. I would like the other fields to be data only I would prefer that the tab doesn't eve go to those fields.

How do I fix this?

I'm using Access 2007

Thanks

Matt

 

[ajetrumpet]

TABSTOP is a property for controls.

id you want autopopulation, read here: http://www.access-programmers.co.uk/forums/showthread.php?t=155420&highlight=autopopulate

the stuff you are doing is pretty easy. if you're really having a lot of trouble, upload it and someone will help you out i'm sure.

 

[gemma-the-husky]

start again with this - it sounds like you are just starting out

i assume you have a table designed with various fields - to get started open the table and put some initial data in there, directly

then use the new form wizard to create a form. this will let you pick the fields you want to see.

now the default form will show you the records in your table, one at a time. at the bottom will be a small vcr like contyrol to move forwards/backwards through the records. ignore the readonly bit for the moment. just get used to creating the forms.

then try redesigning the forms - add labels - change the forms captions - add another control manually - move the controls to different places - change colours, change control sizes, look at control properties etc etc. -

look at different control types (combo boxes/list boxes/option groups/tab controls etc)

now try making the form readonly and see what happens - its not so good with some controls - for instance comboboxes wont work now