I tried both ways. I did get it to work with an alteration but I don't know what the ramifications are.
I changed: "Dim rstClone As Recordset"
To: "Dim rstClone As Object"
Do you know why it works now and didn't then?
This code is from a book but when I try to use it, I get a type mismatch error every time. I did call the function as described below. The error occurs on the line that says, "Set rstClone = frm.RecordsetClone"
Public Function DisableEnable(frm As Form)
'To call the function set the...
Does anyone know how to export a Professional File System (PFS) database (a 12 or more year old database program) to a comma or tab separated value file or some other database format that Access 2000 can read? I am unfamiliar with the database and its files. I haven’t even seen it yet but I...
Does anyone know how to export a Professional File System (PFS) database (a 12 or more year old database program) to a comma or tab separated value file or some other database format that Access 2000 can read? I am unfamiliar with the database and its files. I haven’t even seen it yet but I...
How can I click a button on a subform form from a button on the main form? For instance if I click Delete on the main form, I want it to also run the code in the OnClick event for a button located in a subform.
Does anyone know a way to dynamically change the placement of control(s) on a report based on data from the report source?
For instance, if the field “Side” had the value “Right” then the textbox control “Name” would print on the right (say, at 3.75”)? If, in the next record read, the field...
I guess I need to be more specific.
In the textbox someone would type in something like “Smith” then tab over and select the field within which to search. One would select the field via a combo box that would list field names from a table. The result would display in a listbox.
Does anyone have any ideas for the code behind this scenario?
I would like a text box in which one would type a search criteria and then next to it a combo with a list of fields to search on.
I know how to get the inside width of my form but how can I get the inside with of the application window. Basically, when the form is maximized, what will be it's width?
I work with these properties:
Me.WindowHeight
Me.WindowWidth
Me.InsideHeight
Me.InsideWidth
I use them to dynamically move and size controls when the form is maximized. WindowHeight and WindowWidth sounds like what you want.
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.