Recent content by gillianleec

Skip, I understand perfectly what you were saying but it wasn't what I WAS looking for. Perhaps you didn't understand me. For those who want to know how to do this. I ended up using VBA to put a Subtotal formula into the inserted cell and calculating the area that needed to be subtotaled...

I am trying to do this without touching the spreadsheets as I am passing this off to users who do not have that level of technical expertise.

When you say no VBA, do you mean that I should use the subtotal function on my spreadsheet directly rather than applying the format through Access. I am trying to do all formatting with Access at time of transfer. I have tried experimenting with this WorksheetFunction.subtotal(9...

For each spreadsheet transferred the code: 1. Evaluates the values in the A column and inserts a row when a new set of values begins A B becomes A B Test1 10 Test1 10 Test1 20 Test1 20 Test1 30...

The first spreadsheet has the previous cells summed. The subsequent spreadsheets have a 0 in the cell where the sum should be although it is formatted correctly with color and bold.

I have a series of queries that I transfer to a workbook and then format using VBA. My problem is the section of code below that only works correctly on the first spreadsheet. Dim xlApp As Excel.Application Dim objExcel As Object Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set...

I have a dataset that I import and then need to concatenate. The dataset comes in the form of two record sets that then need to be parsed into one record. There is no connecting id, the only thing that I can do is grab them in two record groups and then concatenate that into one. I have...

I think I might have figured it out if (DateDiff([timeunit],Date(),[startdate])) Mod [timenum]=0 Then ....'include order

Thanks for responding so quickly. I guess my question is more on how to get the calculated date. If I use the startdate as my base date: Dateadd(TimeUnit, startdate, TimeNum) then the date won't progress past the first order. How do I continue the process?

I am having trouble getting started on this project and would appreciate some direction. I have a table for Standing Orders where the user enters a client and the timeframe for which their orders should be generated. For example, they want their order bimonthly, the user would select...

Thanks!!! This code has really helped me out.

yes-it was initally with a phone list. The records were set up so they were in two columns (across and then down)

I need an original copy of this code again and cannot find mine. Is there any other place that it might be posted. This link no longer has it. Thanks, Gillian

I have a report that prints for a location and has a subreport that prints the people associated with that location in columns. I have written code into the subreport that changes the fontsize depending on the recordcount in the subreport. I would also like to change the number of columns and...

On format worked. Thanks!!