you're welcome, Clive ;) happy to help ... ____________________________________________________________________________________ Be a better Globetrotter. Get...
Hi all Could someone tell me how to... 1- restrict a unbound textbox to accept only three characters. 2- restrict a unbound textbox to accept only numeric...
Clive, Following alternatives could be considered for toggling the subform view between form and datasheet views: (a) Mdb file As mentioned by Crystal, default...
Hi Jim, "Do I just link the two together so there is only one source?" Yes 1. turn on the Property sheet in the design view of the report (r-click anywhere and...
Hi AD, Thanks for the extra information. There are quite a few things in there that will come in handy. Regards, Clive. ... design view. Sample code is given...
I am using access 2007 . Does it have a provision to uplaod as a web page. I know in the previous version it has to be created as pages. I am new to access so...
So, followinsg on with A.D.'s advice, in case of MDE files you have to actually switch between two subforms: F_Sub_FormView and F_Sub_DSView. Am I correct? ......
Giorgio I'd use 2 forms even if I was using an MDB. The extra file size for one more form isn't going to break you, and the design is more solid than changing...
Jim It might help to think of queries as tables. They can be used in the same way for just about everything. Should you reach the point where you need to use...
Terence The term you are referring to is Data Access Pages (DAP). They are no longer supported in 2007. My guess is because they were really lame to start...
Hi All, I am running a report from a query and one of fields is a combo box. When I print this report, the background of the combo box is black, and the...
I know this is probably the most simple question ever asked, and I've tried to look at past postings, websites, books, etc, but I just can't seem to understand...
Hi Strive For Peace, I managed to solve with following code which fully supports for keyboard without any bug (which is the one I need at present). But it does...
Hi Shan Roy, not really clear what you actual goal is ... but glad you got something you are happy with <smile> Warm Regards, Crystal * (: have an awesome day...
Shan Roy Crystal gave you the correct way to do what you want. Checking it the text is a zero-length string (ZLS) as you do is not enough. You have to also...
Hi Roy, If you don't want to do API calls (which I can't help you with but did do enough research to see it can be done that way), just use an image to get the...
Dear Crystal, Right now I have no choice other than drawing 2 horizontal & 2 vertical lines and connect them with 4 arcs at their edges. Thanks (Shan Roy) ...
Hi Bill Mosca, As far as I understood Crystal gave me a solution related with mouse and nothing related with Keyboard. If he had given me a solution for...
Can you give me a link to that book as mentioned by you. Terence ... no longer ... start with. ... and they ... will help. ... Conrad's book, "MS ... with the...
Hi Shan Roy, The GotFocus event is for BOTH mouse and keyboard -- it is triggered when the user enters the control regardless of whether they clicked in,...
Hi Shan Roy, Whether you are using the mouse or not the following is applicable. To show the values as you type, set the AutoExpand property of the Combobox to...