Search results for query: *

I think jedraw is correct. "Division = '" & rs.Fields("Division") & "'" Adding single quotes around rs.Fields("Division") ensures the value is treated as a text string in the SQL filter.

I'm not in front of the switch at the moment, but couldn't you create a VDN that goes to a wait time xxx seconds/mins/hours hearing music?

Oh, sorry. I was testing in Access (VBA) bot.start not VB 6.0 com. For VB6, try: Option Explicit Private Sub WebAutomationSelenium() Dim bot As Object Dim Table As Object, Rows As Object, Row As Object, Cells As Object, Cell As Object Dim i As Integer, j As Integer '...

Since you have installed selenium and chromedriver, you can try the code below. This code is a classic scraper in that it attempts to automate human interaction with the page. If you Step through the code (F8), you should see each interaction and be able to troubleshoot any issues that arise...

Below is a good start but I could not finish. I tested to clicking the Cerca button, but the table disappeared? Note: I ran this in an Access Module so I could F8 Step through code. If you load this into excel, I think you'll have to reference Internet Controls in VBA In the VBA editor, go to...

If this.Value = CTOD(" / / ") this.BackColor = RGB(255, 128, 128) this.SetFocus RETURN .F. && This stops the cursor from moving to the next field ELSE this.BackColor = RGB(255, 255, 255) && Reset to default color if valid RETURN .T. ENDIF In FoxPro, RETURN .F. and...

From your post, I think you have this setup: 1) you have calendar details in an Access table, 2) you have a form (or will create a form) with a button, when that button is clicked, it sends an email with calendar with appointments by month. I don't know what appointment fields you have or what...

Glad strongm saw that and the code is working.

Hmmm... Apparently that the WinNT:// provider does not support querying groups for computer objects. Let's switch to LDAP. Try the code below... Option Explicit Dim domainName, computerName, groupName, ADSPath, objComputer, objGroup, objConnection, objCommand, objRecordSet, scriptTitle...

Let's change your code to include a computerName variable, a GetObject call (change "WinNT://" & ADSPath & ",user" to "WinNT://" & ADSPath & ",computer)" so that you're querying a computer object in AD instead of a user with updated prompt to reflect that you're checking for a computer, not a...

If using DVD-R or DVD+R (write-once), the recorder typically formats it automatically when you begin recording. If using rewritable discs (DVD-RW or DVD+RW), the system may prompt you to format the disc into a compatible mode (VR Mode or Video Mode) when you insert the disc.

Create the Button: Open your form in Design View. Add a Command Button to the form (this will be the button that opens the second database). Right-click the button and go to Properties. In the Event tab, find the On Click event. Click the ellipsis (...) next to On Click and choose Code Builder...

The software is proprietary, it's called SEB Manager, and I think there was another one called "nGen" or something similar. There's a lot going on inside that SEB (there's two SDI Port connections (in the event the cores swap), a database that captures diagnostic routines (and I think CDR)...

Not 100% sure when or how you want to "switch" between the two databases? Do you want a Shortcut key sequence? Do you want a trigger in the code (if x happens, then toggle to second db).. At any rate, I assume you want to pass data from one database to the other? (Code below will transfer...

Can you place the file here? I can check it in goldwave.

The way I read it is this: First, Insert a disc with enough space for recording. Then the system will interact with that disk, verify it, and bring up the DVD recording mode options for you to select... At any rate, you can try this: Insert a Blank DVD: Make sure the DVD is properly inserted...

You didn't show the error? At any rate, try Run this program in compatibility mode for: and select a previous version of Windows to get you past this error. Next, start rebuilding the macro until you find the function or line causing the error. Or, if you're not seeing errors, then it's likely...

Glad you found the issue -- yes, it can get a bit off track when I was focused on Power Query when it looks like looks like it was Power Pivot.

The error you are seeing in Power Query indicates that Power Query is still trying to reference a column called "Billing Days," which no longer exists in the source file. You'll need to update the Power Query to prevent it from looking for that specific column: Try these steps... -- Open Power...

There are a few issues in the code that could be causing it not to function... The wildcard in endswith(): The function endswith('*.txt') won't work as expected because endswith() looks for the exact string. You should remove the * and use just .txt. Incorrect use of variables inside strings...