Recent content by snip6969

Yes I am using MS ACCESS 2003 TonyJollans: What your saying is exactly correct. Is it possible to get all of that in one select or any other way? DPlank: I can work it backwards with no problem. The issue is only retrieving the appropriate conversion. What TonyJollans wrote is dead on...

I have a table PurchaseOrder that has ItemNo, QtyOrdered, PurchaseUOM and CostUOM. I have a another table called Conversions. I am trying to retrieve the appropriate conversion from the table. For eg. PurchaseOrder Table ItemNo = Q1111 QtyOrdered = 60 PurchaseUOM = DRUM CostUOM = GALLONS...

GoDawgs your post was perfect! The report sorts correctly now. Good thinking!

I just tried doing the column thing and it works for the query, but its the report that keeps sorting it. Also note that I am using grouping on the Fruit name. If I don't group on the fruit name on the report it works fine. Is it possible to group on the fruit name but not sort it?

Kevin, Thanks for the reply. Could you walk me through it? The field name is Fruit. How do I make a column for each of my parameters and then include those columns in my Fruit field criteria.

Hello, I have a query/report that require paramaters. The found data for the paramaters entered need to be printed in order of the parameter entry. Access keeps sorting these based on the parameter entry value. For example: The parameter is [Fruit1] or [Fruit2] or [Fruit3]. For [Fruit1] I...

Make a script for each column you want to sort. For example SortFirstName, SortLastName etc. Put the buttons on top of each column and link them to the appropriate script. To sort a column use this easy script Go to Field["ColumnName"] Sort[No Dialog] that's it..... ColumnName...

It should be under Add/Remove programs under Macromedia. Click and uninstall.

Well...I have no idea of how to get IE to open up more than one pic per window. However, if you looking for something like a slideshow, Lview pro http://www.lview.com is really great software for doing this.

Check to see if you have a driver present. Go to start -> settings -> control panel -> click on system and go to Device Manager. Click on the plus sign next to Sound, Video and Game Controllers. If there is anything there click on it and click properties. It probably says 'this device is not...

You should try Folder Guard. It is user friendly and allows you to set permissions of drives, folders, and internet explorer from a list with either with check mark or an X. It is really good.

Visit this site http://www.computingcorner.com/help/tweak/tw.htm Download TweakUI, scroll down and read Removing Items from the "New List" How do I remove items from the list that appears when you right-click the desktop or a folder window and select New? You can remove any item...

Hey the message you got is NOT a virus. It is someone on a computer near you or on the same network sending it. At my school we ran Win2k and we used to send messages that way as pranks. It is really easy. However trying to figure out who it is, is a lot trickier...not impossible though...

I have a similar problem I there a way to disable it in Win 98

On my computer I have this program called Lview Pro. It is used to view pictures. If I want to open a picture by clicking on the picture the %1 has to be there in the shortcut command line. If the %1 is not there when I click on a picture only the program opens up. Blank with nothing in it...