I have a form for with two subforms that I use for data entry into my trainings database. The forms and subforms are bound and the tables are related. The main form has the following properties:
Allow Edits = yes
Allow Deletions = yes
Allow Additions = yes
Allow Data entry = yes
The subforms...
I have written function:
Public Function IsOpen(ByVal strFormName As String) As Boolean
' Returns True if the specified form is open in Form view.
Const conDesignView = 0
Const conObjStateClosed = 0
IsOpen = False
If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <>...
I have a report based on a parameter query that filters records by year.
My question is this, is there a way to incorporate the year information into the report's title?
For instance, if a user types the parameter "2003" into the message box, I would like the report title to read...
I have designed a report for my trainings database which is based on a query. The report is grouped by Organizations, then trainings, then the attendees (from that Organization) are listed, something like this:
Organization 1
First Training
Last, First
Last, First...
I've developed a Trainings Database. I have a listbox on a dialog form that lists training titles and training dates. I'd like to filter the listbox to show trainings for only the current year (whatever the current year happens to be). Do I use the DateSerial function in the QBE? If so, what...
Is it possible to filter records in a listbox using an option group of toggle buttons (A,B,C,D,etc.)? I want the user to be able to filter the list and then double-click on an entry to open the record in another form.
Can this be done? If so, how? If not, is there an alternative?
Thanks.
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.