Recent content by roaml

Hi Jerry, I actually have two seperate fields, one for date and one for time. I currently have a criteria form extracting data for the dates (between start date and end date) which works well. I would like to extract the data as I am currently doing but extract between specific times...

Hello, Wondering if someone can help me with this problem. I need to perform a query on specific times of the day. We have three shifts (A, B and C) and I need to pull data for shifts B and C. Shift B is scheduled for 4:00 PM to 12:00 AM and Shift C is scheduled for 12:00 AM to 8:30 AM...

Hi, Can someone tell me why when I execute the following code and go to view my Excel file the Excel application returnes with an error? I'm trying to export records from an Access (2000) table to an Excel file. <BEGIN CODE> Private Sub Export_TT_Records_Click() On Error GoTo...

Crystal ball or not, you are still the MAN. Your sample worked. Thank you.

He, he. Sorry. Here it is. It is a division formula, =D4/C4

Hi, I have tried to set this format to 0 but have had no luck. I am dividing two columns and is receiving "#DIV/0!" if the formula has noting to devide by. How can I clear or format to a "0"? Thank you.

Yepeeeeeeeeeeeeeeeeeeeeeeee, it worked!! Thank you so much Lilliabeth. I appreciate your prompt assistance.

Hi Dale, Thank you so much for your overview. I am not that familiar with Excel formulas, but I am trying. :-) I was wondering if you can tell me what I am doing wrong with this formula? =SUMIF(A1!F2:F5000="Mike Smith",A1!K2:K5000,D4) Tab A1 F2:F5000 holds the Manager's name and A1 K2:K5000...

Hello, I need a suggestion on how to get the following in a formula. I would like to sum “days” associated with a particular manager. For example, I have raw data in Tab A and would like to sum the number of days (10) for “Mike Smith” and place the sum total in Tab B. WO# Days Mgr A1...

Yaaaaaaaaaaaaaaaaaaaaaaa!! You two are the best. Thanks for helping out Skip. This stuff can drive a person to drink :-) Thanks again.

Hi Skip, That formula works, but if the row is blank and there is no data in Row H3, the row with the function fills the rows with the number "38191". This is fine if I can hide the number or format it to a zero. Any suggestions? Thanks.

Hello, I wonder if someone has a solution for me. I am using the following function to calculate the number of days a workorder has been open. =DAYS360(H3:H5752,TODAY()) I would like to prefill the function for 5000 rows. I am getting this 5 digit number (38191) when I copy and paste the...

Hi Roy, I'm using the same code on a switchboard menu and it works great. Unfortunately, I am unable to locate a module or other global variables relating to this code. I tried declaring the Excel App and Workbook. It runs but when I attempt to open my Excel file it crashes on me. Am I not...

Thanks Leslie. I will work on this.

Hello, I am having problems using the following code to export records to an Excel file. I have used this code in the past and it works great, but now it is giving me an error "Variable not defined". I am receiving the error on "myXL" and "myWB". I have not received this error on the same...