Search the web
Sign In
New User? Sign Up
MS_Access_Professionals · MS Access Professionals
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 52604 - 52633 of 76975   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
52604
Thanks Crystal, I will try it out. It rings a bell <ding!>. I think that someone posted it, maybe you, a few months ago. Regards, Clive. ... ...
Clive Williams
horastacatto
Offline Send Email
Sep 1, 2007
8:10 am
52605
you're welcome, Clive ;) happy to help ... ____________________________________________________________________________________ Be a better Globetrotter. Get...
Strive For Peace
strive4peace...
Offline Send Email
Sep 1, 2007
9:20 am
52606
Hi Jim, Thanks for the example, it really helps to see some data To better see what is going on in your query, I formatted it as follows: SELECT...
Strive For Peace
strive4peace...
Offline Send Email
Sep 1, 2007
9:48 am
52607
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...
ozairkhalidozair
ozairkhalido...
Offline Send Email
Sep 1, 2007
12:17 pm
52608
Clive, Following alternatives could be considered for toggling the subform view between form and datasheet views: (a) Mdb file As mentioned by Crystal, default...
A.D.TEJPAL
adt_h
Offline Send Email
Sep 1, 2007
2:24 pm
52609
Hi Ozair, 1- Restrict an unbound textbox to accept only three characters Add the following code to the Textbox KeyDown Event: Private Sub...
Clive Williams
horastacatto
Offline Send Email
Sep 1, 2007
9:10 pm
52610
Thanks. Now how do I include two queries as the record source of the report? Do I just link the two together so there is only one source? Jim Coon...
Jim C
liteguy.rm
Offline Send Email
Sep 1, 2007
9:20 pm
52611
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...
Strive For Peace
strive4peace...
Offline Send Email
Sep 1, 2007
9:38 pm
52612
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...
Clive Williams
horastacatto
Offline Send Email
Sep 1, 2007
9:56 pm
52613
I'll give it a try. I never thought of trying that. Jim Coon...
Jim C
liteguy.rm
Offline Send Email
Sep 1, 2007
10:28 pm
52614
Hi Jim you're welcome ;) happy to help Warm Regards, Crystal * (: have an awesome day :) * ... ...
Strive For Peace
strive4peace...
Offline Send Email
Sep 1, 2007
11:29 pm
52615
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...
tercar266
Offline Send Email
Sep 2, 2007
8:17 am
52616
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_rovelli
Offline
Sep 2, 2007
12:53 pm
52617
Hi Giorgio, Yes, that's what his code does. It makes sense since there is no design view in an MDE. Regards, Clive....
Clive Williams
horastacatto
Offline Send Email
Sep 2, 2007
1:38 pm
52618
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...
Bill Mosca
wrmosca
Offline Send Email
Sep 2, 2007
3:29 pm
52619
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...
Bill Mosca
wrmosca
Offline Send Email
Sep 2, 2007
3:37 pm
52620
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...
Bill Mosca
wrmosca
Offline Send Email
Sep 2, 2007
3:48 pm
52621
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...
toddbuckles
Offline
Sep 2, 2007
4:23 pm
52622
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...
glcass58
Offline Send Email
Sep 2, 2007
8:08 pm
52623
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...
Shan Roy
shanro_im
Offline Send Email
Sep 3, 2007
1:20 am
52624
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...
Strive For Peace
strive4peace...
Offline Send Email
Sep 3, 2007
3:43 am
52625
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...
Bill Mosca
wrmosca
Offline Send Email
Sep 3, 2007
4:07 am
52626
Clive! Thanks -- you are a life-saver :)...
ozairkhalidozair
ozairkhalido...
Offline Send Email
Sep 3, 2007
5:01 am
52627
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...
Strive For Peace
strive4peace...
Offline Send Email
Sep 3, 2007
6:04 am
52628
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) ...
Shan Roy
shanro_im
Offline Send Email
Sep 3, 2007
6:47 am
52629
Hi Ozair, Thank you. Glad to help. Regards, Clive....
Clive Williams
horastacatto
Offline Send Email
Sep 3, 2007
8:26 am
52630
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...
Shan Roy
shanro_im
Offline Send Email
Sep 3, 2007
8:29 am
52631
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...
tercar266
Offline Send Email
Sep 3, 2007
8:59 am
52632
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,...
Strive For Peace
strive4peace...
Offline Send Email
Sep 3, 2007
9:18 am
52633
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...
Clive Williams
horastacatto
Offline Send Email
Sep 3, 2007
9:43 am
Messages 52604 - 52633 of 76975   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help