Search the web
Sign In
New User? Sign Up
ms_access · Help and advice for users of MS access
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

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 15488 - 15517 of 21712   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
15488
Ronan, I just read the following, didn't try it myself tho. Quote : You can force the setting in Access 2000, but only by opening the report in design view. If...
strep21
Offline Send Email
Sep 1, 2004
12:09 pm
15489
Arnold- 1) You need a clock ActiveX control. I found one at: http://www.winsite.com/bin/Info?500000021520 2) You must build an AutoKeys macro and write a...
John Viescas
jlviescas
Offline Send Email
Sep 1, 2004
1:25 pm
15490
Linda- First, it's a bad idea to define lookups in your tables. It's OK to use them in limited cases in forms. See: ...
John Viescas
jlviescas
Offline Send Email
Sep 1, 2004
1:32 pm
15491
Charles- You're mixing apples and oranges. If you move your application to the web, you will no longer be able to use Access forms. A web page is the "front ...
John Viescas
jlviescas
Offline Send Email
Sep 1, 2004
1:49 pm
15492
Hi, I have a report in Access, that has 7 sub reports. The sub reports have fields: Fields Data Corrections First Name ABC...
Amit Rami
amitrami3
Offline Send Email
Sep 1, 2004
2:29 pm
15493
Charles- There are several ways to do this. You can write a good old-fashioned batch file that includes a Copy command and trigger it in the middle of the...
John Viescas
jlviescas
Offline Send Email
Sep 1, 2004
2:49 pm
15494
Arnold - I assume that you already have a label in your form. If not, put a label in your form. Type an X so that it has a caption. Name the label. I used...
Crosier, Dawn
dlc110161
Offline Send Email
Sep 1, 2004
5:22 pm
15495
Hi, i've tried it with the line of code below!! it did not work!! then i've tried it with the specific and default printer. It still goes back to portrait!!!...
ronan carty
ronan_19
Offline Send Email
Sep 1, 2004
7:07 pm
15496
Hi again, Another question i have, to tidy up a query i have is it possible to do the following!!! I have three list boxes where the user selects one of each...
ronan carty
ronan_19
Offline Send Email
Sep 1, 2004
8:08 pm
15497
Make sure all the Office and Windows Updates are current. There was a bug in one of them a while back that would make your page layouts stuff change back when...
Neil Squires
greaterdesig...
Offline Send Email
Sep 1, 2004
9:57 pm
15498
Ronan, I guess now the circle is round :) Eddie...
strep21
Offline Send Email
Sep 1, 2004
10:02 pm
15499
... Maybe Mike. Embedded graphics will kill your database. It will bloat so fast it just won't be credible. Yes you can use graphics but they are much much...
Brett Collings
zkbac
Offline Send Email
Sep 2, 2004
2:46 am
15500
Hi!! Are you looking… - to earn some extra money? - to replace your current income? But… - You don't have the time to recruit - You can't promote - You...
naz25987
Online Now Send Email
Sep 2, 2004
4:51 am
15501
Dear John, For Question 2, if i would like to apply it to any other buttons in the form how can I do so base on the requirement below? E.g: F1 =...
arnold choo
arnoldcch
Offline Send Email
Sep 2, 2004
8:41 am
15502
Hello Dawn, Thanks for giving me this great idea! Cheers mate! ~Arnold~ "Crosier, Dawn" <dcrosier@...> wrote: Arnold - I assume that you already have...
arnold choo
arnoldcch
Offline Send Email
Sep 2, 2004
8:44 am
15503
If I use an Excel file a s an external table, can it be shared by several users the same way as if it were an Access table ? Thank you G.A. Clauss Institut...
Clauss Gilbert
gilbert.clauss@...
Send Email
Sep 2, 2004
11:55 am
15504
Arnold- Tell them to get over it? <s> The technique is the same for any function key you want to apply globally - put an entry in AutoKeys and write a...
John Viescas
jlviescas
Offline Send Email
Sep 2, 2004
1:27 pm
15505
M. Clauss- You can share an Excel file so that more than one user can open the file and edit it in Excel at the same time. Open the workbook, choose Share...
John Viescas
jlviescas
Offline Send Email
Sep 2, 2004
1:47 pm
15506
Thanks for the tip. I will add the graphics directory and move the picture files there. What are the steps to link the graphics instead of embedding? ...
Mike Coday
codayfamily
Offline Send Email
Sep 2, 2004
2:12 pm
15507
Mike, I've got a linked picture demo database that will show you how to do them. http://propertychampion.com/Developer_Tools/Addins/Addins.html Good luck and...
Neil Squires
greaterdesig...
Offline Send Email
Sep 2, 2004
2:18 pm
15508
Thank you John, I will make an Access copy of my Excel file ... De : John Viescas [mailto:JohnV@...] Envoyé : jeudi 2 septembre 2004 15:47 À :...
Clauss Gilbert
gilbert.clauss@...
Send Email
Sep 2, 2004
3:12 pm
15509
I would like to use the function bellow for several fields. How can I call this function from the text fields it self (by going to the Event Tab on the...
myhnews
Offline Send Email
Sep 2, 2004
3:38 pm
15510
There's no way to avoid the individual event procedures. But why did you write ConvertToProper? You can call StrConv directly: Private Sub...
John Viescas
jlviescas
Offline Send Email
Sep 2, 2004
4:07 pm
15511
Hi all, I have the following line in for the criteria on a query!! If the value in a list box on a form is "ALL", i want the query to return all the records...
ronan carty
ronan_19
Offline Send Email
Sep 2, 2004
4:13 pm
15512
Hi, I've used this code IIf([Forms]![Complaints Report]![System]="ALL",[Complaints]![System], [Forms]![Complaints Report]![System]) and it works!! ;-)...
ronan carty
ronan_19
Offline Send Email
Sep 2, 2004
4:42 pm
15513
I know that you can designate a field as required at the table level. Can you make a field "required" at the form level? I would like to designate a field to...
marty1118@...
marty1118
Offline Send Email
Sep 2, 2004
5:14 pm
15514
On the AfterUpdate event of your Field2 you can do something like this: If Me.Field2 = X Value Then If Len(Me.Field1 & vbNullString) = 0 Then MsgBox, "You must...
Jack Malki
jackvmae
Offline Send Email
Sep 2, 2004
6:02 pm
15515
Your Criteria line needs to be: =[Forms]![Complaints Report]![System] Or ([Forms]![Complaints Report]![System] = "ALL") John Viescas, author "Microsoft Office...
John Viescas
jlviescas
Offline Send Email
Sep 2, 2004
6:18 pm
15516
I'm trying to avoid opening the Module for each field like this. Private Sub MyField_AfterUpdate() End Sub I just want to add the function name...
myhnews
Offline Send Email
Sep 2, 2004
6:23 pm
15517
Hi John, Thank you so much for giving me that much of information about function key controls! I will work them and reckon there must be more testing to run by...
arnold choo
arnoldcch
Offline Send Email
Sep 2, 2004
6:31 pm
Messages 15488 - 15517 of 21712   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