Search results

Hey, I have a question but can't seem to find an answer to it: Is it possible to navigate to a particular record of a table without applying a filter to the form? This is how my forms are set up: On the form used to edit Supplier details there is a combo box that is used to navigate directly...

Yep, to get the last 10 records from one of your tables, create your combo box and set it up to show the data you want (the columns from the table) and just have it show all rows for now. Then in Design view, modify the SQL statement in the control's properties... Properties -> Data -> Row...

Peliq, As Dennisk has suggested you could pad the data with a 0 or a few 0's to order the data correctly. When ordered it would then become: 01. waiting 02. inorder 03. install ... 11. handover 12. maintain Or if you don't want to modify the data as above, you could have a separate column...

I'm confused by this - create a new button on the subform itself? The subform is a datasheet, as far as I know, controls can't be put on there, unless I'm missing something?

I've got a bit of a UI issue with a subform & a datasheet in one of my forms. I am making an Inventory database, a form contains the product details and also a subform containing the transaction details (units in, out, adjustments). I.e. it's basically in the same mould as many of the Access2k3...

I had a similar problem, Willem, and only managed to "fix" it through trial and error. It seems to have been an issue with having a subform on the Detail part of the form. (Now my knowledge of Access is limited as I've only started playing around with it this week so I might not name things...