Activity Stream

Link in post 33.

What I'm missing here is the story what you want to achieve. Before you can start thinking about structures, you need to know how you're going to...

I think you're right about doing the cost/benefit analysis in order to gain a couple of seconds of speed. I would like to pursue the FedEx API...

Micron has come to the same conclusion as me. The Code needs to be deleted. Your process is you want to open a specific record using your Off...

I think I understand what the issue is now but I dunno what caused the record to be deleted. I commented out your Docmd.RefreshRecords because I see...

So that means if you open the offer to edit the record(s) about that offer get deleted? Or is the problem that when you use the search box (no real...

The idea of a List of previous records like your "Offer Register" is to quickly open a Form to display the record selected. Please explain what it...

this is very difficult to solve :(

You have options. 1. Stick to the built-in Internet Explorer automation. 2. Create a Fedex api key that lets you use their tracking service. Moke...

I don't think I can create an object with any other browser as the following line does with Internet Explorer: Set ie =...

Thanks, Colin.

Tried again. This time left the # characters. Compiles but still crashes.

This is the correct Sleep API code: #If VBA7 Then 'A2010 or later 32 & 64-bit Private Declare PtrSafe Sub Sleep Lib "kernel32.dll" (ByVal...

Have you tried any of the FedEx API's? https://developer.fedex.com/api/en-us/catalog/track.html

Removed DoEvents If VBA7 Or Win64 Then line errors so tried each Declare. Sleep compiles but same result. Access crashes. Worse with PtrSafe. ...

Glad it works for you Euler. The slowness could be because of Internet Explorer, newer browsers are optimized for that sort of website, so they load...

Got it! I had assumed that was something to that effect, but wanted to be sure. impossible to build anything with faulty logic. thanks

Hi This Field on the Report :- Transferred: =Nz(,0) This just means if the field QuantityAdjustment in the underlying Query is Null,...

Yes, I found the API code and entered "PtrSafe" so it would work. Now, it works just fine, though a little slow compared to the original code. I...

crossposted here with answers https://www.access-programmers.co.uk/forums/threads/pivot-tables.328868/

Glad it works for Euler, crashed Access for me. I already have Microsoft Internet Controls reference library selected. Sleep 3000 does not compile...

Did you include the Sleep API code? If you did and are using 64-bit Access, it will need updating using PtrSafe

Look up crosstab queries in Access:...

For some reason "Sleep 3000" doesn't compile. I will have to research that.

This works great, Edgar. Thanks so much for your expertise.

That's my question. Is there a way for VBA to capture the data in the outerHTML. I manually copied the outerHTML to Word. It's over 900 pages but...

Hi Welcome to the forum This is not the way to enter data in Access, this is a Spreadsheet layout Ward 1 Ward 2 Ward 3 Ward 4

You're welcome. If its not too late (i.e. if its not already fixed), are you able to email me with any additional info or screenshots on the error...

Oh there are so many things I would have done differently if I was the Architect. To Start I would not have used MS Access to build an ERP system to...