Kelly Warden
Last Activity: Dec 30 '10, 09:41 PM
Joined: Sep 15 '10
Location:
-
Kelly Warden replied to Why is my search form returning 1 record in my subform when there should be multiple?in AccessMy subform is a tabbed subform; It has 3 tabs and the two last tabs show more then one. However the first record just shows one. I have it set to single form. I tried other forms but it they don't work or look right. -
Kelly Warden started a topic Why is my search form returning 1 record in my subform when there should be multiple?in AccessWhy is my search form returning 1 record in my subform when there should be multiple?
I have a search form with a sub data form. When i search for "john" for example I should get a bunch of records in my subform, however it is just showing the first one from the table.
Here is the VBA.
...Code:Option Compare Database Option Explicit Private Sub btnClear_Click() Dim intIndex As Integer ' Clear all search items Me.txtID = "" -
Kelly Warden started a topic How to write VBA for Search box to display in records in multi tab Subform?in AccessHow to write VBA for Search box to display in records in multi tab Subform?
I created a dynamic search form and had records displaying to a list box. However I decided to create a Subdata form instead w/ varying tabs. I can't seem to get it to work.
In the VBA Code, lstresult used to be the name of the listbox in the form. Now there is a sub data form and I tried just renaming it but it doesn't seem to work. PLEASE HELP!
I have attached my database with no records so you can see the code and... -
Kelly Warden started a topic How to create a button to open up records in a datasheet by double clicking?in AccessHow to create a button to open up records in a datasheet by double clicking?
I have a rather complex form with a listbox. I would like to be able to highlight a record and view in dataform. Unless there is a way to make the listbox look like the datasheet. The way it comes back now is all together. I would need a scroll bar.
Any suggestions? -
I already did that work. I am looking for a simple approach I can use as a guideline. I am not looking for an exact answer. I want to know after things are set up how do I go about creating the above.
Thanks!Leave a comment:
-
Kelly Warden started a topic How do I create a Form in Access to automatically update my table fields?in AccessHow do I create a Form in Access to automatically update my table fields?
I want to create a form in Access to update my table automatically with the information selected from combo boxes, lists, comments, etc.
Also, I want to automate this w/ some VBA or SQL or something in Access. I want to be able to automatically fill out parts of the form based on some other tables containing different data.
Basically in the form, if reason 1 is automatically filled out then its done and no one needs to look...
No activity results to display
Leave a comment: