Search results

Why doesn't .SetFocus get the message? Can anybody tell me why .SetFocus does not work in this code in a continuous form? Private Sub ConnectIdentify_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then Dim strFilter$ strFilter = Screen.ActiveControl.Name &...

Yes, just tested it. It works perfect for me. Private Sub txtTextBox_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then MsgBox "User hit the Enter key" End If End Sub Here's are two lists of key codes...

Found this in a forum: (I didn't have a chance to test it yet) you can capture the enter key in one textbox. try this: Private Sub myText_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then MsgBox "User hit the Enter key" End If End Sub

Ok, this helped me to get my way around my problem. http://stackoverflow.com/questions/632774/what-do-the-different-readystates-in-xmlhttprequest-mean-and-how-can-i-use-them (Sad it took me so long)

When navigating to a webpage from VBA, How do I click "Ok" on the website's OnLoad Alert box?

Yep, it just came to use for me, thanks.

Thanks Beetle, that made it. Although I tried following that thread a few months ago without success, I guess a few months experience does make a difference.

I admire your reply Bob, I thank you for your advice which keeps on getting me better, and I value your nature that when you help somebody, you go the whole path down to understand his needs and providing the right solution. But I was different, I saw he was using IIF for 16 sticky cases, so I...

Hey Bob. I respect you for all the help and advice you give for me and others. I might still be a 'bad' [vs. 'learning'] programmer, but it does not mean that I shouldn't put my 2 cents into a post that was ignored for 20 minutes, while some are ignored forever. If anyone else has any better...

Case "JOHN" NumbeField = 1 Case "Sara" NumbeField = 2 Case "Paul" NumbeField = 3 "NumberField" stands for the name of the field where you want to save the number to.

Here's a sample to play with: Private Sub Command24_Click() Select Case InputBox("Name") Case "JOHN" MsgBox "1" Case "Sara" MsgBox "2" Case "Paul" MsgBox "3" End Select End Sub

If you use code, you might look into "Select Case" method.

How do I use code to fill in web pages? Lets take Google for example. I want to: 1. Open Internet Explorer AND navigate to "http://www.google.com/". 2. Press the "Sign in" button 3. Fill the "Email" and "Password" input boxes with "string" 4. Press the "Sign in" button Help please?

Usually a print report command prints all records, unless you entered a WHERE condition.

The following SQL gives me the FIRST found child in one column, and the LAST found child in another column. SELECT Children.ID, Count(Children.ID) AS [Count], Children.Father, Children.Family, First(Children.Child) AS [First], IIf(First([child])<>Last([Child]),Last([Child]),"") AS [Last] FROM...

Hi all, I have a table of students and their parents information. Example: ChildFirstName,_ ParentID,_ ParentFirstName,_ ParentLastName. Child1___________ 1_________ ParentF1_________ ParentL1 Child2___________ 2_________ ParentF2_________ ParentL2 Child3___________ 3_________...

Bob I took your advice. I just finished 'glancing' and learning on functionx "Microsoft Access 2010" 37 lessons and "VBA for Microsoft Access 2007" 28 lessons. I mainly needed it for Self-confidence;)

AccessForums.net has the exact same layout like here, but has only the Forums part. Look's like multiple sites by same owner.

I actually meant to ask him which site he likes more, access-programmers or AccessForums. (Maybe it was not nice of me.) Anyway, good to know what pro's I gained by buying 2010, Bob.

BTW, which one do you like more?