Recent content by markwilliams2004

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....