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...
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...
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 ...
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...
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...
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!!!...
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...
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...
... 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...
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...
Hello Dawn, Thanks for giving me this great idea! Cheers mate! ~Arnold~ "Crosier, Dawn" <dcrosier@...> wrote: Arnold - I assume that you already have...
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@...
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...
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...
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, 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...
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@...
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...
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...
Hi, I've used this code IIf([Forms]![Complaints Report]![System]="ALL",[Complaints]![System], [Forms]![Complaints Report]![System]) and it works!! ;-)...
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...
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...
Your Criteria line needs to be: =[Forms]![Complaints Report]![System] Or ([Forms]![Complaints Report]![System] = "ALL") John Viescas, author "Microsoft Office...
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...