Search results

tabs etc. Thaks very much for your help. I'll try it now :-)

I have a form with tab controls in it. This is what I want to do. The first tab shows all members, the second tab shows members that belong to group "a" only, the third tab shows members belonging to group "b" only. I know a need a filter but how do I attach the filter to each tab? I don't...

Print forms Thank you for your reply. I will try your suggestion.

Hello revered Access Gurus! My problem. I have a form displaying data from a table. I have a Print button which when clicked tries to print ALL the records in the table. How can I make it pint only the curent record I'm viewing at the moment? Should I use a query? Sorry if this is a rather...

colors thanks v much, will try

Hi all, Is it possible to change the colour of various controls in a form via VBA code or a macro? My idea is to set up a setting form whereby the user will select background and foreground colours (ideally there should be a colour picker but I'll just give user a few options) so that the...

Thanks again Thanks for the code samples, am off to try 'em :)

Yipee! Thank you very much, the last one worked a treat! :) :)

Hi all, more questions from me (I'm beginning to get the bug ) If I want to put a maximum currency amount that can be entered against a set database table - i.e. no overspend - how would I set that up so that the user was not allowed to enter the data? Say I have £7,500 available. The user has...

Thanks Will try that. Thank you very much :)

I wnder if you can help. My problem is with saving records and refreshing forms. MS Access automatically saves the record added or edited as soon as we move the insertion point to a different record. How can I make it explicitly save the data in a record while I'm still editing it? i.e. I...