Recent content by hjeff71

Actually, I do not have a “sample database” to demonstrate the action I was looking for. Some of these forms that I needed this process for, are rather very complex with lots of vba and sql programming, interactions and rules etc,. However, with what niamliam has pointed out, I was able to...

Thanks for the info, I have changed: If Me.Dirty Then Me.Dirty = False to DoCmd.RunCommand acCmdSaveRecord But i still get the same error message, any other ideas to explore? (Forgot to mention, I am using Access2007 on Windows XP)

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...

Thanks!!! I managed to make it work with the modMouseHook and Private Sub Form_Load() Dim blRet As Boolean blRet = MouseWheelOFF(False) End Sub Simple, and it works,

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...

Thanks for the reply, Your approach is the most logical way, and it works beautifully,

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...

I’m just trying to find an alternative to the “ControlTip Text” The ControlTip would be great if it was faster, but it is soooo slow,... Therefore, if you make a form (Popup:Yes Border Style:None) – it gives you more flexibility in what the popup looks like, and its opening speed. I would...

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...