As I say I have a long memory and also I'm quite resentful when I have been mauled. But you're right in this case I can be totally confident that the relevant form/control has focus so nothing 'interesting' should happen.
I think I'll take another look. Actually I'm slightly surprised that...
I got that recursive error which I was surprised by.
Hmm, sendkeys is a bit of a hack and I have a long memeory. I was bitten nastily by that in VB5 I think so I'm not keen to go there. Wasn't there some issue with doevents and the order in which things happened.
It's a pity I can't do it...
Sorry I thought I made it clear.
What I want to prevent is any cell in columns 1 & 3 getting focus, so if the user clicks into any cell in column 1 then focus is sent to the cell in column 2 in the same row for example.
I have already set columns 1 & 3 as readonly but as you know it is still...
Thanks for the reply. I'm aware of the readonly setting but I wanted to use the grid as a data entry form layout with columns 1 & 3 holding captions for data entries made in columns 2 & 4. So, in that case I wouldn't want the user to be able to click into columns 1 & 3 if you see what I mean...
I am using ODBC to connect to a remote MYSQL database.
I have two PCs one is the development PC and the other my laptop.
Both use the same DSN, both connections work and test OK. The laptop can use Access to link to the MYSQL database using ODBC.
However, when my VB.NET program connects to...
Does Access support CASE? I can never recall. I thought there was CAST and CONVERT as well.
However, as you suggested I have used CASE to make the entries as required. Crude but effective.
Mike
Yes I could presumably do something like that in the SQL statement but it's not really very convenient nor desireable as we haven't decided if it will be an SQL server database or Access and the two systems require different SQL to achieve this.
Are you telling me that in your experience what...
Once again I have to apologise for the question!
I have a field that is a BIT so it's 0 or 1
It appears in a datagridview as a column
All I want is for a Yes/No entry in that column!
I thought it would be format="Yes/No" but obviously not.
In the immediate window ? format(1,"Yes/No")...
Bear with me on this one.
I want to add 28 rich text boxes to a form in code.
I can do that.
I want to refer to these controls easily - well an array RTB(7,4) of richtextboxes seems good to me especially as they are in a grid 4x7..
BUT I want to handle the click event of each of these 28...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.