Search results

Take a look at this example where Daniel launches MS Word: https://www.devhut.net/2010/09/09/vba-word-open-a-word-document/ It should work the same for IE.

I believe you should first test if the object is already open with the GetObject method, if that gives an error you should trap it and run the CreateObject method instead.

Like this: Ok changed checkbox to true but no luck. Private Sub ChkMailingAddressSame_AfterUpdate() If ChkMailingAddressSame = True Then Me.MailingAddress = Me.Address Me.MApt_lot = Me.Apt_Lot Me.MCity = Me.City Me.MState = Me.State Me.MZip = Me.Zip Else Me.MailingAddress = ""...

Clear, thank you very much June7. I agree that it will be much easier to retrieve the data when I store it horizontally, like it shows on the source. Back to the drawing board it is... :)

Hi Jdraw, Yes This shows you the first 50 fields or so. This can be extended with a 'Date Acquired' field and a 'Date Last Modified' field which would obviously change over time... Additionally for Fuel information and Frame specifications, additional datasets are available, increasing the...

Thank you June, could you briefly explain a bit more 'your design' ? How would you structure it? I guess a tblObjectID containing an ID and name for the object. And a tblObjectProps containing PropertyID, ObjectID, Brand, Type, Color, Share, Weight, etc, etc up to 40 ? For now I have...

Hi June, Thank you for the response. Yes, the objects could be considered as Automobiles and it has properties like Brand, Type, Year, Color etc. Now my Object Properties table has ObjectID PropertyID PropertyValue 1-1-BrandX 1-2-Type1 2-1-BrandY 2-2-Type2 3-1-BrandX 3-2-Type3 4-1-BrandZ...

Goodmorning guys, Sorry for the silence on this question, I have been working on creating this table structure and the required function to import and normalize the data this way. So I now have the 3 tables as the dbguy proposed and included the data type value in the properties table as...

Thank you guys, I will modify the structure as proposed above. It makes sense. How about the retrieval part in this structure? Lets say I need to retrieve the values of 6 properties from a certain object, would that be 6 dlookup calls or is there a fancier way? I would need to find the Object...

Hi all, I need to store details from objects. I will store many different objects, potentially up to 1 mil. Each object has 30 to 40 properties and each property has a value. So I created 1 objects table so that each object gets an ID. Then I created 1 properties table that contains an ID...

Well strTarget doesn't exist in your function. I guess you need to change that to strHTTP

Not sure if someone still has this issue but it's caused by a setting in Word. I believe you should disable cache while printing or something like that. When the print job is sent directly to the printer then this shifting of the characters to the left doesn't happen anymore. Edit: I believe...

Actually, the good thing about the Google API is that you can choose between XML and JSON output. The XML output is much easier to parse in VBA. I have used the tutorial linked below that makes parsing these results extremely simple, with some very clean code. I would definitely recommend using...

Nicely done there Colin They also provide the opening hours where the op was interested in

Would hiding it be an option by placing some kind of image of square on top of it? How about the Google Places API? It may provide the info you are looking for without the map.

You can do it in 1 replacement using the Chr() function. Replace(string, chr(32) & chr(nr-for-quote), "") and then remove the last character with the mid function for example...

You need to perform 2 seperate replacements. First replace the comma with nothing, then replace the the quotes with nothing. I would advice to use the Chr() function to do the replacement. Replace(string,chr(ascii-nr),"")

Hi Lizz, blank and zero are different things. But you can use the Nz function to validate the input: If Nz(me.txtbox,0) = 0 then Msgbox "input cannot be blank or 0" End if

Ok, finally got it to work. The image object is in fact recognised as an image. So in the Public Sub call is now: Call ValidateInput(me.imgResult) And in the Public Sub it is declared as an image: Public Sub ValidateInput(img as Image) To modify the image itself, I do need to use the Picture...

Yes, the example I provided was just air code. In fact, I have a Public Sub. I'm calling it from a single form, not continuous. But there are multiple (single) form that have this same validation procedure and images. So maybe I need to include both the form name and the image object in the...