Search results

I have a Main form with a subform(datasheet view) When dbl-clicking on any field of the subform, I open another form (frm_2) with all the details of the record clicked in the subform. Private Sub contact_name_DblClick(Cancel As Integer) DoCmd.OpenForm "frm_2", , , "ID = " & Me.ID End Sub...

How do you get the mouse wheel to scroll in a memo field?

I have a form (datasheet view), with Project Number and Child Number Each project can have childs (ie: Project 1001 can have 1001-1, 1001-2, 1001-3 etc) I’d like to learn how to navigate through the data of the table and have the option to delete the record if: - The project # or the child...

I have a form with a subform (in Datasheet view). The subform Record Source is a query. If we delete a record in the subform (while in Form View), it will disappear and never be seen again in the subform (while in Form View) However, the record is still present in the table (that the query...

How do you pass the data from a listbox to a subform? When the data is transferred, it would automatically create a new record in the subform. Would this work with multi-selection?

How do you populate/filter a subform based on search criteria in the main form? Main form has a “search field” with a command btn. The “search field” will find the search criteria in any fields, and populate/filter the subform with all the records it finds, no matter what field it found it...

Is there a way to have a popup form (without the borders) follow the mouse?

Access 2007 – Linked tables on a web server? We have a database used by multiple users. Each user has the *.accdb installed on their C drive. Each *.accdb is link to the tables on our internal server. (Using the “Link to the data source by creating a linked table” option.) However, if we...