Search results for query: *

If you enter the & twice it normally appears as one on the display. Regards Dave

I have a split database which I want to secure to stop users from viewing the datatables on the BE but still update/add and delete data via the FE. Using access security I can stop them viewing the tables but when the FE trys to re-attach itself It comes up with the error saying that the user...

GingerR I've been away for few days and just read yours and MichaelRed comments. I'm glad I wan't the only person having this problem. Did you eventually get the code to work as per the thread that you found? or did you have to make any changes to it? I've printed it and will try it out...

I have a sub report that is based on a continuous form. A couple of the fields have their Can Grow properties set to Yes. I want to seperate each field with a vertical line but can't figure out how to get them all to grow to the same height as the tallest text box in the line thus producing...

Steve, You could save the combo selection in another table if you want to use it later. Create a table with just the one field in it (Called ComboInfo). Add that table to the record source of the form that has the combo box on it and add ComboInfo from that table as a hidden text box on that...

Thanks for the advice re the autokeys macro but I forgot to mention that I want to use other F keys on the same form to open or close other forms. I very rarly use macros and when I tried your suggestion I can only get it to carry out one F key action. Is there no way of just disabling the...

The row source of the combo box should have the unique ref (autonumber) as the first field, which you can hide by setting its column width to 0cm. The record source of the second form should have the same field, and you can then set the criteria to be based on the combo box i.e. [Forms]![FIRST...

I have similar fields on a database I wrote.I use a seperate hour and minute field plus a hidden field which holds the hours mutliplied by 60 plus the minutes giving the total mins for that entry. You can keep adding to this field for each entry on the page. When you wish to display the total...

I have a form that I wish the user to close by pressing F12. I've set Key Preview to Yes and in the on Key Down event proceedure I've used a select case statement against vbKeyF12 set to Docmd.Quit. However I keep getting the MS default for F12 of a Save As dialog box appearing which them stops...