Search results

I want to navigate a menu and change a password. I can enter the details but do not know how to select the various menu options to get to the password page. I cannot just navigate to the URL as for some reason it doesn't load the password page properly. I'm also not sure how to click the final...

I've been having issues with a couple of Excel documents that I access with Access. For some documents this manifests as the vba code for the excel document (not the code in access) completely vanishing. I wasn't sure what was causing this, but I'm now fairly sure it's something to do with...

I have a VoIP account and want to send SMS via the API. The details about it are here: https://support.aa.net.uk/SMS_API They give an example for linux curl --silent --form-string username=01234567890 --form-string password=123456 --form-string da=01234567890 --form-string ud="Hello world"...

Is it possible to have an access form Edge browser window visible but lock it from any input and only allow it to be scrolled up and down? Is it also possible to have the form Edge browser window pop out to a full Edge browser window? I'm guessing if this happens it will no longer be...

I've used this code for years to move to the next record. Over the last week or so it has started adding a new record if you are on the last record. It has never done this before in probably about 10 years. Can anyone help with how to stop it creating new blank records? On Error GoTo...

I have a database with around 3k entries. I want to create more tables that are linked to records in the main table, but only for some of the 3k main records, not all of them. I also want one of these tables to be capable of multiple records that are linked to a single record in the main table...

Starting today the Edge Browser window in a form has stopped working. It was fine this am. I have several versions of the code, all at different stages. I have tried them on 2 different PC. The site I'm trying to access works fine on chrome and normal edge. The Edge browser window doesn't work...

I'm trying to find a sting like "AFE43542" within a web page html with instr. The string will always be of the format [a-z][a-z][a-z]#####. I've used "[a-z][a-z][a-z]#####" and "???#####" Istr never finds the match. What am I doing wrong?

Can anyone help with how to click this button? It has no normal ID and I can't find it's position searching for the inner text. <input class="ipad-radio-btn-margin btn btn-default btn-largesize margin-right-5" data-ajax-url="/OPH/OphthalmicGosFour/SubmitSupplierDeclaration" data-btn-save=""...

I was writing a procedure usingVBA in access to use internet explorer. I have come up against an issue with compatibility which I will not be able to circumvent, and why am I using a depreciated browser? I had it largely working and am now trying to convert the code to work with an Edge browser...

I’m trying to complete a form where some elements are locked until others have been completed. When doing this manually just the act of typing something into the required fields unlocks the corresponding controls. For some reason entering the data like this doesn’t unlock the locked field...

I've been using: While IE.busy DoEvents Wend Loop between pages. although on initial load I use: Do Until IE.ReadyState = 4 And Not IE.busy DoEvents Loop I note if I interact with a page just after loading I get an error so have added: x = Timer + 2 Do While Timer < x DoEvents...

I've started using Set IE = CreateObject("InternetExplorer.Application") to try and control a webpage. Given IE is no longer supported, is it possible to do this using chrome or Edge?

Can anyone help with how to click this button using IE.document?

I can login to a website and navigate to this page. I want to fill in the form. The problem is the page source code doesn’t show the elements that I want to complete, so I can’t figure out how to enter any data. How do I go about completing the form, which includes a drop-down list for title...

I've been trying to adapt some code so I can take control of an open excel workbook. Dim WB As excel.Workbook Dim myWB As String myWB = "LabOrderSheet.xlsx" For Each WB In Workbooks MsgBox WB.Name If WB.Name = myWB Then WB.Activate MsgBox "Workbook Found!" Exit Sub...

This is an odd one. I set a table up and created a form from it. I then wrote some vba code. A while later I noticed I had named a field in the database SUrname instead of Surname. I've rewritten it as Surname in table, field controls etc, but in vba code it still corrects to SUrname. I then...

I'm using the following code to populate the columns in an excel spreadsheet with the field name from an access form. Dim count As Integer: count = 1 For Each fld In db.TableDefs!LabOrders.Fields oXLSheet.Cells(1, count).Value = fld.Name count = count + 1 Next What I also want to do is move...

I have some access vba code that pulls data from and excel spreadsheet. The problem is after it runs excel is still open in the background, so I must kill it via task manager. I’ve tried a couple of ways to close excel, which I use elsewhere in code and it works fine. Does anyone know how to...

I have used the code below for many years without issue Application.FollowHyperlink "C:\ProgramData\folder\temp." & filetype The files it opens are either jpg, pdf or docx. Previously they would just open in windows explorer as if you have clicked on them. As of today for jpg the code just...