Search results for query: *

different reports show different numbers from what I know... so it is probably not a big deal.

Yes those should be compatable with her board.

So for every blank cell you need to sum the values below it, or until the next blank cell?

Can you have pre-existing forms that open upon the users choice? If so, set up your forms using the different querys as your datasource and you should be good to go. Just have the forms open when the user selects the correct query from your list.

http://www.newegg.com/Product/Product.aspx?Item=N82E16834997340 This is a little more then you expressed wanting to pay but the product is out there at least.

Thank you Randy and Duane(for the initial help). I just got this to work.

Please excuse my vagueness. rank FName Lname Dept TrainDate HN Jonathan Scinta DMH CONT Zach Kover DMH CIV Junior Stroud DFA 12/7/2009 LT Christon Duhon DPH 12/7/2009 CIV Hayden Mennley DCSS 11/9/2009 GS...

Hello, I'm fairly new to access and am trying to create a database that uses a linked spreadsheet of names, depts, and dates some training was preformed. My goal is to create a report that has percentages of who has completed said training. For the whole command and by departments. If the...

Nope, you can have more then one sub in a module.

Please post your code. So someone can help you out.

Sub color2() Dim N As Long For N = 1 To 56 If Cells(N, 16).Interior.ColorIndex = 3 Then MsgBox "Codes don't Exist " exit for End If Next N End Sub

exit for, not break. haha

So you want to break out of the for loop when a red cell has been found. or you could always use a goto statement that goes to after the for loop once one red cell has been found.

If your output is already in excel then, just set up a temp string variable as your output. Then loop through the cells and concatinate them to the temp adding in your ".|".

The .csv should be able to be imported through excel without writing code for the action. I think this is what SkipVought suggested. Why would that have an issue because of the data being on other pages? This should import whatever is in the .csv file.

Why not send an esc keystroke before calling the second procedure?

Will the printer being printed to always be the default? If so you should be able to do something like this: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

It has been my past experience you can save songs directly to an Ipod but it isn't as easy as one might think, as the songs are stored in a group of hidden folders on the Ipod. This way you can bypass itunes if so desired, I know it's a software some people dread using. These hidden folders...