Search results

I was in that situation many times. I solved it by undocking all windows and redocking them one by one. I found out the pattern and the docking areas more easily with that. IIRC, if you want to dock 2 windows to the left, you dock the lower window first then the upper window. If you want to dock...

With a launcher form where users login. Include a token with expiration date while processing the credentials. Store the token somewhere, a file, regkey, etc. When using any form in any access app that requires this authentication, validate the token on open. And so on

I put it in a regular module in case it needs to be reused somewhere else, such was the case in the sample, where it's using the on click event of the subform and the buttons in the main form. I was going to add another form to test another variation with arrows, but I hope someone else...

CurrentSectionTop would indeed help with that task. Depending on the full behavior you want to program, you could modify the following code to suit your needs. It's a combination of the suggestions by theDBguy and Josef, but with built in functionality. Public Function bounceRecordView(frm As...

At this point, it would be best if you could post something we can play with, because that error is not very specific, but since it highlights the line that checks if it's fully loaded, we could add a timer or approach it differently. You have not yet confirmed if the "Incorrect Ref" string...

Can confirm, pretty effective.

@Pat Hartman I will rewrite what I said from: To: Let's not go down the path of me vs you. Thanks for your clarification on why you suspect this is a cloud issue.

Mind elaborating why you believe this is a cloud issue? OP: Here's my 1.5 cents, when something in Access does not work, which is not uncommon, implement it yourself. Lock your records in a custom way, make a table where you can store which records should be locked and also release the locks...

Private Sub FUNC_HRREFForm() Dim IE As InternetExplorer Dim doc As HTMLDocument Dim html As String Set IE = New InternetExplorer With IE .Visible = True .Navigate "http://corp/ViewHRDetails.asp?Headerid=" &...

Something like this should do the job Private Sub FUNC_HRREFForm() Dim IE As InternetExplorer Dim doc As HTMLDocument Dim html As String Set IE = New InternetExplorer With IE .Visible = True .Navigate "https://www.google.com.mx/" While .Busy Or...

Your code will find that string even if it's not meant to be shown. Maybe OP should post a snippet of the html.

Maybe the watercooler board is the tiktok of a few posters over here.

It could also be done by using a lookup function that checks a list of definition in the same worksheet, same workbook, another workbook, some access database, a text file, hardcoded definitions, and many other ways. I disagree.

I don't know what the guy in the tiktok video is doing, but you can easily accomplish that using a http request to some web service that gives you the definition of names. You make the function in VBA or use the built-in feature of the newest versions of Excel for that.

I'm happy to help. Good luck in your project!

Sure, modify the sub and make it return a date with dd/mm/yyyy as format. Since it returns something like this: Tue, 13 Jun 2023 17:10:34 GMT, we can extract the date starting from the 6th character, with a lenght of 11 characters using the Mid function. After that, we cast it into a date...

Who knows. Oh I didn't read it, he uses a similar approach. But hey, my code is shorter, eh.

Wouldn't your users be able to open the VBA editor and change the lines of code that prevent them from using your database? If that does not matter, then maybe it would be easier to just get the time from a http request. This is a google service that returns the date in the headers when called...

Just make you server send you the response of a SELECT NOW() AS MyTimeStamp If that doesn't work, then let us know what you're using as backend.

To get selected item: Me.MyListboxControl?