Search results for query: *

Thanks.

Loomah I think I get what you're saying now. I ws trying to do this through the VBA form and not actually the form controls in Excel. I was hoping to keep it off the sheet and just execute via the VBA form and insert the end result back into the workbook.

But what if the data is not on the worksheet but is actually selected on the form via a datetime picker and combo box, with the intention of inserting the concantenated result on the worksheet?

Hi all, I am trying to design an excel form that basically solicits input from the user via a series of input options on an excel form. These are: 1. Field Name is "Planted Date" and it's selected via a date time picker. I would like to extract the month and year from that. Let's assume the...

Alright. I thought that may be the way I had to go. Essentially, the table I was trying to extract the data from calculates the life of the fields over 16 and 24 months depending on the type of field. I though there maybe a trick to quickly get at the period. I'll have to normalize it I...

I am trying to lookup a heading of a column and am having difficulty with it. The spreadsheet looks like this: Field Number 1 2 07107 01/31/08 02/28/08 07108 06/30/08 07/31/08 Basically, I want to retrieve the values 1 or 2 based on the criteria...

Awesome!!!!! Thank you so much!

Pwise...I see that it's using plantdate which is why it only increases it by on for the 36 times to 8/1/2008. I may be doing it wrong but it seemed the way you mentioned. I renamed a couple fields but here's the SQL copied from access: SELECT tblFldLifeTest.Field, tbldigits.DigitID...

It inrementally increases it to 8/1/2008 but repeats that number 36 times in the RS. I think I'm missing a key component of this:) Thanks

So I'm not sure if a query is the best way to do what I'm trying to accomplish but essentially: 1. I am trying to create a table that hold's the life of a agricultural field. The table I set up has the following data: FieldNum PlantingDate 6133 07/10/2008 2. Based on that...

I agree Skip. That was my first approach but getting to the source data here is at best difficult. I have tried connecting to the source tables to utilize SQL to query off of but neither I nor the IT person can get to the proper table so I have been forced to utilize the reports out of this...

The second option would be ideal. Can you do that? I think I need to up my VBA skills....

Dang...that is pretty good. The only thing I really need to capture is this line which is currently excluded: 06105 Field 506-Planted 5\1-13 Acres: 15.300 Awesome though! If you can help point me in the direction to resolve this piece then I am...

Hi, I aplologize if this doesn't lay out on the screen properly. I've been meesing with it a bit to format but hope it gives the general idea. Anyhow, I have a report that runs every month in in text that I want to parse via fixed width. The fixed width would be based on the spacing in the...

thanks....

Skip, I'm sorry if I did not follow protocol within this forum but find that your tone extremely condescending. I will gladly follow protocol and will do so in the future. Please feel free to point me to the guildelines so I can be comliant in the future. As for the bolded "copied straight...

Month Year AccountingNumber Account Amount 12 2007 08210 SALES 12 2007 08210 # of Boxes 12 2007 08210 Freight 12 2007 08210 Packing 12 2007 08210 Equipment 624.29 12 2007 08210 Fertilizer 12 2007 08210 Herbicide 12 2007 08210 Insecticides 12 2007 08210 Fungicides 12 2007 08210...

Not sure I understand what you are exactly proposing. I would need to somehow calc Total Expenses and Net Profit in the source then. What are your thoughts on that or can you give me an example, if it's not too much trouble? Thanks again.

There is no data for that field for 11/30/07. The pivot table is set to display nulls as zero. This is a from historical table and there are other fields that have valid data for 11/30/07. The problem that I see is if you create a calculated item then it applies and calculates whether there...

OK on this field there are no values for 11/30/2007. I do not want that column to show. It is only showing up because of the net profit/loss and total expense calculated items below. I cannot categorize it into revenue or expense totally (I do not think) since # of boxes is neither. For other...