Search results for query: *

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

VB6 has a very easy solution to this. Add a menu item, name it, then check the 'window list' checkbox on the menu editor.

Ever install a program and when you're done the folder where everything is installed pops up? How is that done?? 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?

Try: Tracker.AddNew Tracker("aname") = straname

Homesick, please tell us more about "tracker".

Dim SomeVariable As Variant With MSFlexGrid1 .Row = .Col = SomeVariable = .Text End With

Thought that was ADO... Is it not?

great idea... but the .ldb file doesn't exist at this point.

Mark, DAO is faster and I've already written the program.

Sorry, maybe I wasn't clear. I close the connection AND set it to nothing, but that doesn't help. Just read a knowledge base article, and Microsoft says they keep a connection open for 10 minutes after I destroy the connection variable (how nice of them). They offer a solution, but it means...

comes with vb. just look on the toolbox.

Maybe a little more info on what the form will do will help. Why do you need 38 text boxes? Can you use tabs (like when you go to Tools, Options in Internet Explorer...)?

I run a routine that interacts via DAO w/ Access database. When it's done, I want to open the database for the user to see. The only way I know how to do this is with ADO (e.g., Access.Application.OpenCurrentDatabase and .UserControl = True). Problem is... I get an error saying that the...