Search results

In the attached file I had created a chart using the Chart Wizard base on your table. Is that what you want? I don't know why you have East, South & West in your chart. It only take me a few clicks to create the chart with the Chart Wizard. Peter

Hi nine, There is only a "form" in your sample, not a "chart". Why don't you use the Chart Wizard to help you create the chart? Peter

see if this works: =Switch([InvUM]="EA", IIf([InvRoLevel]<=6,6,12), [InvUM]="QT", IIf([InvRoLevel]<=220,220,440))

Try to change the settings in Design Mode and save the report before switching back to Preview. Page Setup settings are not permenent if changed in Preview Mode.

Hi Ghudson, I still have no luck in solving my problem. I downloaded the Environment Variables mdb file. When I opened the form all the lines showed "#Name" in the text boxes. I was able to pull out all the viarables using a update query and put them into a table. However what I need was...

Hi, First of all don't use "Date" as your field name. Because it's a reserved word, in Access when you say "InvDate = Date" means you enter today's date in to the InvDate field. (I made the same mistake before :D ) Use this criteria in your query under YourDate field: Between #12/1/2001# and...

Thank you Ghudson. I will try again and do more detailed study. Peter

Thanks Ghudson, I am using Access 2000, the Environ() function does not work within access, it only works within VB Editor. And the string table does not include the Network Name. What I want is to check the name of the Work Group that is listed under Microsoft Windows Network so that I can...

I put the codes under the Form's BeforeUpdate event. I think only in very special case you can put it under the Control's BeforeUpdate event. The BeforeUpdate and AfterUpdate events of a Control will not be triggered if you bypass the control.

I have this work on several of my forms: If Isnull(yourControl) then Msgbox "your message", vbOkOnly, "Required information" Cancel = True Docmd.GotoControl "yourControl" Exit Sub End If I guess that GotoControl action keeps focus back on the same control and thus keeps the form from being...

Hi, Does anyone know how to return the network name with VB code? I wish I can restrict the use of my application in a special network. I think this is the only way to ensure that my mde file is not copied and used on other places than our company. I can't use user group control because I...

In Zone Alarm's Program Control I set to "Block" Skype acting as a server to the internet. I don't realise how this setting affects the performance of Skype, but at least I feel it saver. Same for Trillian too.

Here is another way, use Imaging that comes with Windows 2000 (Don't know if it's availble in Windows XP): After pressing Print Screen open Imaging (inside Programs - Accessories). File - New : to open a new file. Edit - Paste : say yes to expand the file size to accept the full screen image...

See if this can help you: http://support.microsoft.com/kb/239938/EN-US/

I have been using Skype for voice chat for quite a while. I have my Skype Privacy setting set to "only people whom I have authorized can call / start chat". But to my supprise when I opened the Zone Alarm log file one day I discovered there had been a lot of attemps to access my computer thru...

Angelina is a real beauty, she is one of the my most favouite star. How would you envision your cat with Angelina's lips? :rolleyes: Peter

Hi Vassago, You are quite right. That was only a joke. I just received an advice that the site was created by a student at M.I.T. And I guess FoFa and Oldsoftboss knew that already, right? :cool: Cat fans, The bonsai kitten was only a hoax. I'm sorry if this thread made you feel bad...

Take a look at the website - bonsaikitten.com. They said that is some sort of oriental art. What would you say about it?

Ha, that's a much simpler way, and is exactly what sponge wants - choose higher value. Peter

Did you ckeck the References in Visual Basic Editor? Peter