Search results

Now that you mentioned that, I do recall that happening. It's almost as if MS Office 2007 takes the default position.

The problem may because when you opened the db in 2007, it converted it to 2007 version. Suggestion: Open that db back up in 2007 and save it for the 2002 version. That should clear that issue up. I ran into this issue when I upgraded to 2000 from 98 version. One of the things I do once I...

I concure. :D

Just wondering what the consensus is on MS Office 2007 package. I find it tasty and is quit different from the past versions. That being said, I am relearning the options and finding many new features that weren’t available in the past. I am very impressed with it thus far. Kilch

Thanks Pete, I think I understand what you are saying here. I'll furhter clearify for you. In the comgo box, I haved a table will all color values. ex: 100, F100, P100, S100, 101, F101, P101, S101, etc, etc...... When I select the color number value that is contain within the Combobox, I...

I have a query filtering question. Please note attach pic for further details. I am trying to put together a search in a form to seach for a certain color or color series from a Qery from two two different sources (from a Combo Box and from a Text Box). I am not sure how to set this up in the...

Can you tell me where about in the Group Polocy? Thanks a lot

About three weeks ago, my work computer crash hardcore. Windows (2000 ver) had many corrupt files in the Windows Directory and in the Registry. Because of that, IT gave me an up to date computer running Widows XP. I am still running the same version of Office (2003 Pro). I think because I...

not sure if I follow. I am using MS Access 2003. <shrug>

OK, I have tried and just cannot seem to get it. Perhaps if you were to take a look at the file? Got to "W-GraphSearch" ---> in the Forum Category, then select "Chart by Day" via the dropdown and run search, there you will see the Chart and mayber you'll have a better idea. thanks

short date - "Expr1: (Format([Date],"Short Date"))". This is taken from the Chart sql. Date data type in the Table is "mm/dd/yyyy" Hope this helps. Thanks

Never did that. How do you go about doing that bob? Thanks (as usual)

Just tried the way you said Rich "Not Is Null" and it's a no-go. Same results... hmmmmm, any other ideas? Thanks

Thanks Rich, That wouldn't be "Is Not Null"? I have tried this method and to no prevail. I will try your suggestion based on your reply. Thanks again, Steve

When creating a graph, how do I not show the graph that contains no data? As it stands now, when I do a search using a date criteria, it shows all the days of the week. Those including days without data. How do I get rid of the days without data? Thanks, Steve

OK, think I have done that. Can you view the files I uploaded? It shows how its all set up. Thanks again bob.

Ok, New Question OK you guys. Here is another one. I am trying to setup a report by month. My issue is that its sorting alphabetically, not in calendar order. Anyone have any ideas? Please view the attached Word doc for eamples of my issue. It dispalys the Query setup, Query ran results...

bob, that worked ver well. Thanks again. Just wanted to up the code slightly in order to get it to work for others that may be looking for the same help: Expr1: Format(([Production Date]-Weekday([Production Date])+2),"mm/dd/yyyy") Had to remove the extra end parentheses ([Production Date])...

Thanks guys, I have copied all the scripts and are on file. bob How could tack on "Format([DateID],"mm/dd/yyyy") " onto "(Format([Production Date]-Weekday([Production Date])+2))" Thanks again, Kilch

Is there anyone that can help me out here? This is the fdicussion forum I can access from work, so I cannot look elsewhere. Thanks, Kilch