Using Docmd.SetProperty for width
I have a search which generates a Table “Found”. I wish to vary the width of one of the fields [Title] in the Table display (NOT Form or Report) using VBA. How do I use Docmd.SetProperty for width? I can’t figure out the syntax from what the help files display.
SQL Query with Where clause equal to value in text box
This should be easy but I can’t figure it out. I have a form that displays one row of a table. There are multivalued fields in the form and they are set to a RowSource sql query. Here is the query:
Use a Control Value From a Different Form in a Navigation Form
I have a navigation form and I want to use a control from a different form to pass to a control in the clicked on form of the tab.
Pass a Variable to an Open Form
I want to pass a variable to another form which opens with OpenForm. My form open event does not seem to be called. Maybe I am not referring to it correctly. The print statement in the first subroutine is correct, but the Debug.Print “A” never happens. Also, once this variable is passed to the new form, how do I use it in an SQL statment?
MS Access VBA: Storing and retrieving variable names and values in a table
I am trying to refer to an existing public variable and change it’s value based upon a table which stores the variable name and value. I have searched everywhere and can find nothing that can help me with any pointers. Please be gentle with me. Many thanks in advance.
Combine multiple values into a multivalue field
I’m trying to get an sql query to convert rows with the key in one table into a multivalue field.
Select Case never reaching final statement
Case Else not being reached.
VBA Change_Column_Name Procedure
I am simply trying to write a function which changes the column name of a table in MS Access/VBA.
How do I clean up a remote drive using a recordset?
I have a sorted record set (“NewTbl”) of the contents of a remote disk drive. This shows a great number of duplicated files and other anomalies. The record set holds the file name, its location on the disk and file type (extension). This allows me to assemble a string that should allow me to correctly identify any particular file. Using the Kill command I would be able to eliminate the duplicates. Generally speaking I’m OK with the logic of selecting the file I’m after but not so hot on the link to the disk using the available information. The code I’ve got together ( that doesn’t work is below). The line it fails on is “fl.Name = ThsHm & ThsFl & “.” & ThsExt” returning error 438 “Object doesn’t support this property or method”.
Clicking a button in another ms-access application via hWnd
I’m trying to write a piece of code in VBA that clicks a button in another access application.
I know how to do it when the application is written, e.g. in C#, via Windows API, e.g. FindWindow and SendMessage.
For the ms-access app, I can’t find the button handle. In Spy++, the application window is visible, but its button components are not visible.
How does ms-access handle buttons and how can it be done in VBA via Windows API?