Search results for query: *

If you are ever looking to open a web based pdf, here's a great way to do it. Dim varHyper As Variant varHyper = "http://www.statlab.com/skin/frontend/default/statlab/inc/catalog/statlab_catalog_2015.pdf" Application.FollowHyperlink varHyper If you already have the link in the...

Skip, You are awesome dude!! You taught a great deal through this post. Thank you sooooo much!!!

I was trying to do something like this. I parsed out the data like below: UOM[tab][tab]Column1[tab][tab]Column2[tab][tab]Column3 EA[tab][tab][tab]EA-1[tab][tab][tab][tab]BX-10[tab][tab][tab][tab]CA-40 CA[tab][tab][tab]BX-10[tab][tab][tab][tab]EA-1[tab][tab][tab][tab]CA-40...

Skip, So, if the data look like this: UOM[tab][tab]Package Content EA[tab][tab][tab]EA-1;BX-10;CA-40 CA[tab][tab][tab]BX-10;EA-1;CA-40 BX[tab][tab][tab]CA-40,BX-10;EA-1 What would the formula look like now? This makes that it a little bit more difficult to parse out that data. I discovered...

Thanks Skip. I guess I was making it too difficult.

Hello Everyone, I have trying to parse a value from a string based on the value of an adjacent cell in Excel 2010. My data looks as follows: UOM[tab]Package Content EA[tab][tab]EA-1;BX-10;CA-40 BX[tab][tab]EA-1;BX-10;CA-40 CA[tab][tab]EA-1;BX-10;CA-40 I am trying to use SEARCH in addition to...

Hello Everyone, I ended up fixing my own code. Thanks for looking, and any attempts to assist. This is how I fixed my code. OLD: wks.Hyperlinks.Add Anchor:=wbk.Worksheets(" & rst2!Category & ").Cells(lngLastRow, 5), Address:="", SubAddress:="'Market Share Detail'" & "!A2", _...

Hello Everyone, I have some code that I'm working on. I think that my syntax is correct, but I am getting a run-time error 9 - Subscript out of range error message. Below is a sample of the code that I am running. What this code ultimately does is create hyperlinks for four (4) items to...

Thanks kjv1611!! It was painful because my Director and VP were looking at me with disgust in their eyes. I had never missed a report before, and it was like they were testing me to see how much I could handle, and when I gave them their report 4 hours prior to their deadline the frowns turned...

Thanks Andy, It went from several hours to about 5 to 10 minutes. It was great to discover those suggestions. I work in a highly visible, high pressure position to provide executive reporting. Going forward I will defintely use your suggestions, because it allows me to save space, and do...

Oh I left strongm out, I'm sorry I didn't put you in my original post. I didn't know that Access would make the other variables into variants. I thought that it was a shortcut so that I wouldn't have to Dim every single varible. I took your advise, and made sure that I gave each variable a...

Hello Deniall, marcopod, and Skip, Thanks for your outstanding assistance. I can't wait until I'm as good as you guys are. It was a nightmare trying to copy and paste data of that size in bits and pieces. I have several applications where I can use each of your advise. Deniall and...

Hello, I have created code to help me write large amounts of data to an Excel 2010 file. The code works great, but it's working slower than what I would like. It ran for 2 hours and only posted 40,000 records which is way to slow for my fast paced environment. I have a recordset that has...

Thanks for your help so far Skip, but my code within the For Each is not working. I'm trying to figure out how to make it look at the next record first, and then subtract one. It seems to be taking the first record, and subtracting that one to make the end date. My end date is prior to my...

Updating a null field for each row in my table.

I wanted to write directly to the table rather than using the query to be the focus of my recordset. No one else has access to this table. I use it to create reports. I guess if there were multiple users I would use a query. What would a query do that a table wouldn't do?

Hi Skip, Here is a sample of my code. Dim db As Database Dim recset As Recordset Dim x As Variant Dim EndDate As Date Dim recdate As Date Set db = CurrentDB() Set recset = db.OpenRecordset(“tblCYSmSOrd”) Do until recset.EOF For Each recdate in recset x = recdate – 1...

Hello Everyone, I am trying to create some VBA code to help create and ending date for my records. I have start dates, and the end date should be the next start date - one day. For example: Start Date: 2/25/2011 Next Start Date: 4/30/2011 End Date for 2/25/2011 Start date should be...

Dallas

Thanks Skip, I'll try it, and let you know what I discover.