Modules & VBA :: Getting Internet Explorer To Wait

May 5, 2014

Page loads, transaction is submitted, everything works fine 99% of the time, however, on occasion, the page loads a mini error page where you have to click a blue link for it to continue. Here is where I am stuck, if the blue link appears, I get an error that the object is not set, if I move my cursor up one row (For Each htmlInput) it will continue without error. How do I get IE to give the error message a chance to load before checking it out?

Code:

'click the SUBMIT button
For Each htmlInput In HTMLDoc.getElementsByTagName("Input")
If htmlInput.Value = "Submit" Then

[Code]....

View Replies

Modules & VBA :: GetElementByID With Internet Explorer Using Shell Windows

Jul 16, 2013

I can currently open a new internet explorer instance, navigate to my URL, then use the .getElementByID to insert my preference into a textbox on the page. Looks like this:

Code:
Dim oIE As Object
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Navigate "URL of my Choice"
Do While oIE.Busy Or oIE.ReadyState <> READYSTATE_COMPLETE
DoEvents

[Code] ....

View 7 Replies View Related

Automating Internet Explorer With Office XP.

Jul 29, 2005

I�m thinking of starting to use office XP for a small system I have. My question is:

Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I haven�t been able to do what I want.

Fuga.

View 4 Replies View Related

Using Visual Basic Together With Internet Explorer

Aug 16, 2005

There is an online form which we need to fill out for each of our inventory units. This form has several dozen fields though. We have to fill each one out for every unit that we ship (which is about a hundred a day).

But the good news is, about 25 of these 30 fields are always filled in with the same value (our name, address, city, state, zip, insurance, insurance no, carrier, carrier no, etc).

What we want is a way to fill out these fields for us automatically, and all we have to do is type in the remaining 5 fields ourselves.

My temporary solution was to create a form with 5 fields and a Submit button. Then using AppActivate "Inventory Adjustment - Microsoft Internet Explorer", we would use the SendKeys function and virtually "type" in the 5 variable values and the 25 other "hardcoded" values, using the Tab key to move in between fields.

However, we have encountered some issues using SendKeys. For one, the cursor doesn't always start in the correct place, and the fields become horribly offset and skewed. Also we notice that sometimes the cursor moves "too fast" apparently and skips pasting some of the values (an issue we tried to resolve by using "wait" commands, but it didn't help consistently enough).

Is there a better way to use Visual Basic to fill in fields in an Internet Explorer window? :(

View 2 Replies View Related

Open The Internet Explorer From Access

Mar 22, 2006

I want to open the internet explorer from access

but with url

for example

dim strUrl as string
strUrl = "http://www.google.com"

'here I want to open the explorer with the strUrl

thanks!

View 4 Replies View Related

Dealing With Internet Explorer Via A Form

Aug 3, 2006

Hello...

I created a button that opens a link to a URL and copies information from a record to the clipboard to paste on this webpage.
The users are not using it correctly (they need to close the page each time they need to do the next record).

what i want to do is to close ALL IExplore windows via access if there are any open then open the URL again. Sounds pointless but we have to close it because of security.

Thanks.

View 1 Replies View Related

Problem Opening .mdb Via Internet Explorer

Jan 21, 2005

We have a webpage hyperlink to a network drive that contains a database...but this particular database doesnt open. It shows Access running under process in Task Managerk, but the application doesnt show up as running. Our other databases open fine...for some reason this particular one refuses. I get a message when opening the link that the publisher could not be verified. It almost seems like a security issue with Internet Explorer. I've lowered all security to the lowest levels and enabled everything. These links are only accessed from within the company. Any ideas would be great. Thanks, Jeff

View 5 Replies View Related

Error Using Internet Explorer Embedded Into Form

Aug 24, 2015

I'm getting the attached message using internet explorer into an access form..

View 6 Replies View Related

I Need My Code To Wait... (modal?)

Mar 29, 2005

Hi

I am importing a database, but I first need a couple of parameters from the user.

Now I write this mostly in Access VBA, since I come from programming background.

What I want to know is how can I let my code wait for the modal form to close before continueing?

Thanks

-Canderel

Sub ImportFoo()
'//Prepare files for import

docmd.OpenForm "frmImportParameters" '//(with modal, pop-up, etc.)

'//---- WAIT For form to close ---- THIS IS MY Question...

'//Import Code... This runs before I close (actually before the form opens about)
End Sub

View 14 Replies View Related

Call Shell(...) - Wait Until App Ends

Feb 4, 2007

Hey guys!

just wondering if there is an way to command

Call Shell("my_bakcup_string",1)

and wait 'till the bakcup program ends to go next command in VBA

thank you! :cool:

View 4 Replies View Related

Wait For Shell Execution To Finish?

Jun 19, 2007

I'm using hte Shell() function but this doesn't wait for the executable file to finish so I'm looking for a command line function that would wait until the executable file is finished executing...

I saw this function WaitFor but it is not supported in MS-Access? So, what do I do?

Thanks...

View 7 Replies View Related

General :: Doesn't Seem To Wait For Second Click

Aug 28, 2013

I have a listbox in which I am using both the single and double click events to return different data. It seems that when I try to double-click it is interpreted as a single click! It doesn't seem to "wait" for the second click. I have been coding for years but never saw this before.

View 6 Replies View Related

Advanced VBA Wait In Subroutine Until Form Is Closed

Jul 7, 2004

Hi all.
I have a form that opens up another form when you click on a button. The button does more than just open the form, it does other checks. I want to wait until the opened form is closed to continue with the subroutine. Is this even possible in VBA? I was wondering if there was a frmFormName.IsOpen or some kind of flag that would tell me if a form is open or not. Any help would be greatly appreciated. Thanks in advance.

Sub open
Checks things
Checks things
checks things

Opens form(frmDetails)
Wait for form to close (THING I DON'T KNOW HOW TO DO IF POSSIBLE)

Checks things
Checks things

end sub

View 2 Replies View Related

Forms :: Timer Event - Wait Until Form Fully Loaded Before Visible

Nov 7, 2014

I have tried using a timer event to not show a form until it is fully loaded, to no avail.

Code:
If CurrentProject.AllForms("FONNewEdit").IsLoaded = True Then
Me.Visible = True
Me.TimerInterval = 0
End If

I have tried using the onload, onopen but the form still displays before being fully loaded.

View 7 Replies View Related

Windows Explorer On Form

Apr 14, 2006

Hi All,

Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.

Thanks in advance,

Jatz

View 3 Replies View Related

Windows Explorer On Form

Apr 14, 2006

Hi All,

Is there a way that I can view window explorer within a Form. Is it also possible to have Drag & Drop facility in that form.

Thanks in advance,

Jatinder Kalsi

View 1 Replies View Related

Button To Open Windows Explorer Window

Jan 28, 2006

Hello everybody, it's been a while since i wrote on the forums and yet again I am in the need to ask for the help of this wonderful community.
I have a form on which is a button that I want when pressed to open a Windows Explorer window displaying the contents of a directory.
The exact way that I want this thing to work is like this : The user is browsing a form of lets say client details and on the form lies the button that when pressed will take the client's name and apply it to the path in order to open that Windows Explorer window and create a path like C:program filesclient name and display the contents of that window.
I would like if possible someone who can point me as to how I can construct this button to work cause I cant see to get it done.
Many thanks for your time :)

View 3 Replies View Related

Launch Windows Explorer Window From A Button (directory)

Apr 7, 2006

I would like to be able to have a button that my firm's legal assistants can click which will automatically popup the folder on the server where the client's documents are stored. What is the easiest way to write this?

View 3 Replies View Related

Create Explorer (File Manager) Style Drill Down

Dec 6, 2006

Hello, I am wondering if there is an efficient way to create an explorer style drill down for a location/equipment table I have

i.e.

-Dept
+Finance
+HR
-Quality
+Supplier
+QA
-General
+Etc1
-Etc2
+Production

I have used the tree control to acomplish this but the major drawback I have found is it becomes WAY too slow when utilizing large amounts of data due to many embeded loops. Does anyone know an alternative or a way to program the tree control to only add nodes once a selection is expanded?

Basically I want this to operate as a drilldown of infinate levels with the speed of windows explorer. Unfortunatly all the code I have seen requires that all nodes are designated/Created when the form is loaded.

Any thoughts are greatly appreciated

View 3 Replies View Related

General :: Create File Explorer Functionality In Access

Jan 31, 2013

how to create file explorer like functionality in ms access.

1 -I need to be able to browse files within specified directory and only. I can't alow users to browse any other directories.
2- I also need to be able upload (copy/paste) folders and files in that directory

I looked at different solutions and found a solution which might work on this foum link below.
---access-programmers.co.uk/forums/showthread.php?t=102667----

The treeview working for browsing specific directory, but i need to enhance it to allow to copy files and folders in that directory.I use MS ACCESS 2010 and not very proficient in programming.

View 5 Replies View Related

General :: Cannot Open Database File From Windows Explorer

Jan 9, 2014

All of the sudden I get an error message when I try to open my database from a file rather than through Access. If I open Access first and open the file that way, there is no problem but if I click on it from Windows Explorer, I get the error.

See picture.

View 7 Replies View Related

Db On Internet

Jun 7, 2006

I have a database which is being used for maintaining documents status. Its working fine in stand alone PC. I want to share it on internet. But problem is, I can upload the complete file, then download and use. Its not updated.
So is there any way to upload this db onto internet and work there only the way we do in single PC?

View 2 Replies View Related

Forms :: Provide File Explorer Functionality To Open PDFs

Nov 1, 2013

I'm a newbie and using Access 2007.

I have added functionality that creates a report, saves it as a PDF, and then sends it to a customer via email as an attachment. The PDF file is saved to a folder and is named to include the Customer's unique customer number and the date and time the PDF was created.

For example, if the customer number is 09 and the date was 10th October 2013 and the time 09.00am, the file name is 0009101020130900.pdf.

What I want to be able to do from within the database is to have a button, that when clicked, will display all of the Pdf's for only customer number 09. The customer number will be based upon a field in the customer record.

View 4 Replies View Related

Internet Database?

Jan 3, 2006

Hey, I am currently designing a database for my group of friends. Things such as ,Name, Age, Musical Instrument, Band (of which they play in), Favourite Band etc. would be in there indefinately.Its not a complex Db and so I was hoping to put it on my website but dont know how i would do this...I would like it to be on the internet as if you were just looking at it on your own computer and webmaster could edit any fields after it is finished. Is there anyway of doing this? If yes is there any way of doing this without the viewer having to download the Db?

Regards, Tommo

View 10 Replies View Related

Getting Access On To The Internet??

Mar 14, 2008

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to run the reports off control buttons /macros of the forms view not see the tables or query design. Any suggestions of best to approach this, Also any input about "project" or "ADP" woud, be very useful, thanks Andy

View 1 Replies View Related

General :: Rightclick Menu In Explorer - Compact Or Decompile Access File

Sep 24, 2012

I am looking for a registry setting or .reg file to rightclick on an Access file and in the menu i want to compact or decompile the access file.

I know it is possible but i don't know what's the registry setting.

View 1 Replies View Related