Search results

Today Access updated to Microsoft® Access® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20078) 64-bit The good new is the Edge browser window now appears fluid and responsive. The bad new is the password to the test account I was using has expired and they are dragging their heels...

Hmm. I have a back up copy and testing this there are no new records created. There are no extra me.dirty = false. Allow additions in form properties is true. I can't see why it has changed how it works. I think something must be entering data and thus activating the new form. I've done that...

Thanks. I found and disabled "allow additions". The problem is now the add new record button won't work. Both this and next record button produce a pop up of "You can't go to the specified record", which is what use to happen with the next record button when you got to the end. EDIT: I now...

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...

Thanks. I will try and upload some more info.

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...

Hi, I've sent across a test database. I hope it function correctly. Many thanks Andy

Thanks. I tried to produce a cut down version but it is proving difficult. It will be easier if I just code up a "working" version in separate database. I have put this on the back burner as I'm hoping when office updates the issue will resolve. Is there anywhere I can find out when I will be...

No worries and many thanks. Here is sample of the code that was working fine. I've added a pause function instead of all the x= timer + 2 stuff, but this is since the code keeled over so will stick to what was working. If I run this the browser window freezes up. Also how do I get updates...

I'm happy to PM you the login as it's a test site. I just don't think I should post it publicly. Would be willing to test it for me? If so I would be very grateful. Is it really possible that an update that happened without my knowledge killed it? I have had previous issues that have been...

I've stripped out everything except navigating to the site, pausing, entering details, clicking login, pausing etc. It still doesn't work. The front page shows but I cannot interact. Previously as the code was running I could move the webpage in the window and see all the data being entered and...

Thanks. I pretty much had it fully working and was getting ready to transfer it across to my working database. I think I'm on ver 2311, but will check when I get back home. I'm going to get rid of any non essential code and try it again. If I get working is it likely to be temperamental with...

Looks like I can type posts again. Thanks for your help. I slowly transfered the code to another version of the database. What appears to be happening is the edge browser window is not updating. The code appears to be running in the background. On some occasions it will run until the end. I...

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...

Thanks. I knew I was having another brain freeze moment Me.EdgeBrowser0.RetrieveJavascriptValue("document.documentElement.innerHTML") Like "*[a-z][a-z][a-z]#####*"

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?

I think I've tried everything, but will double check tomorrow. On another note, how do I check to see if a checkbox is selected or not? I've tried isSelected(), but it just errors and .value always returns true.

Many thanks for your help and patients. As you can probably tell I'm learning as I go along. I would like to use the API in the future, and will build myself up to that. ATM I am under time pressure to get something working before 1st Jan. If I can get it working reliably with the internet...

Thanks. Output is: 0 - 1 - Cancel Claim 2 - 3 - RetrieveJavascriptValue timed out. Please verify the JavaScript expression supplied is valid. 4 - RetrieveJavascriptValue timed out. Please verify the JavaScript expression supplied is valid. 5 - RetrieveJavascriptValue timed out. Please verify...

Debug.Print x & " - " & Me.EdgeBrowser0.RetrieveJavascriptValue("document.getElementsByName(" & Chr(34) & "btnSave" & Chr(34) & ")[" & x & "].value") Darn. I needed to look for value. Sorry it's been a long day. Sadly: Me.EdgeBrowser0.ExecuteJavascript "document.getElementByName(" & Chr(34) &...