Search results

It looks like Access has very poor window management. Unlike Excel, there is no .Left or .Top property and MoveSize is quite limited. Anyway I've done what I needed using Win32 API. VBA sucks :(

OK I found a solution, for all of you who need this: Add ADOX referrence to the project. Dim cn As ADODB.Connection Dim catDB As ADOX.Catalog Dim cmd As ADODB.Command Dim sQueryName As String Dim sSQL As String Set cn = CurrentProject.Connection Set catDB = New...

Is it possible to modify stored query using VBA?

Thank you :)

Well, basically that's what I'm looking for. If there's possibility to manually specify the position of that form during runtime, that would solve my problem. But I cant find any function that does it.

Weird, because I couldnt find anything about positioning the window vertically. Thanks anyway.

I have a very small form (Dialog) without any buttons and I'm using it to show the information that database is processing something. I set AutoCenter to Yes and it centers it horizontally but not vertically. It's positioned at about 30% of the screen. Very strange. Is it normal? Or maybe there...

Awesome! Thank you very much!! That was the fastest reply ever! Works fine now :)

Hi. I've created a report based on a query. I have some text boxes in the report bound to the fields that are connected to the report. I have also some unbound text boxes on the report and I want to update them manually using VBA. The problem is that everything works fine but not on the first...