The weird thing is that I put DoCmd.Minimize in the form's open AND load events, but that doesn't seem to be enough -- Access keeps maximizing this window. Also, I don't want to minimize it -- I just want to 'restore' it. I can use the DoCmd.MoveSize method if I could just get it to stick. Any...
I'm working with legacy Access DB, and the startup form maximizes every time. Is this something that Access does by default? How do I make it open the window to the size I want? Thanks. -Brad
One question though...
Thought the only way to make a FlexGrid writeable is to make it bound to a database... If it's bound, why do you want to extract information from it?
Dim i
Dim someVariable
With MSFLexGrid1
.Col = 3
For i = 0 To 10
.Row = i
someVariable = .Text
Next
End With
You should also be able to loop through the Rows collection, probably like this:
For Each iRow In .Rows
someVariable = .Text
Next
Thanks Matt. I am using pretty much the same thing as your GetLineCount function. It's not TOO slow, but it seems like a lot of extra cycles just for the convenience of a progress bar...
I've gotta learn how to use the registry :)
I am using FileSystemObject to open, edit and create text files from VB. I have a couple questions:
1. Is there a way to find out how many lines are in the text file just opened?
2. Is this the best way to read/edit an ini file for my own application?
3. Is FileSystemObject the best way to...
The code you wrote (e.g., Access.Application...) is automation, and I guess I just confused that with ADO. Anyway, that's how I was trying to open the mdb -- with the opencurrentdatabase method. Any idea why that's not working, astrid?
Do you want to programmatically cope the text somewhere? If so, you can use the above code to get the value and then:
txtBox.Text = SomeVariable
If you want the user to be able to copy and paste, it is a little more complicated but the same idea. Can you elaborate before I post code?
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.