Search results

Is this a valid Access SQL statement: UPDATE tbActivity SET [tbActivity].Hours = (SELECT Sum([tbLabor].Hours) AS totalActivityHours FROM [tbLabor] WHERE ((([tbLabor].ParentActivity)='92'))) WHERE ((([tbActivity].Key) = 92)); Whether I run this statement from VBA by RunSQL or in the query...

I'm successfully using the code below to decode Vehicle Identification Numbers (VINs); but I'm looking for a VIN encoder module. Anyone? Public Function isVIN(strVIN As String) As String Dim I As Integer Dim intCount As Integer Dim intCount2 As Integer Dim aModelYears() As Variant Dim...

The focus moves to the first tab position on the sub form as soon as I attempt to set enabled property of a contol on the subform to FALSE. I want to disable all controls the subform individually so I've tried moving focus to the parent and seting the entire subform enabled property to false...

Is there a way to refer to (call) a subform private module from the parent. I can't make it working using the normal syntax I use to manipulate controls and objects.

Recordset is updatable and works fine when opened from database manager or from several simple forms using DoCmd.OpenForm. Recordset becomes not updatable when opening from one particular form. Doesn't matter whether using a filter or not with the DoCmd.OpenForm statement. Going to design view...

I've succeded in populating the field of a form using code from another form; however, it seems that the field is populated too late to use the data. I have no problem getting the information into the field; the problem is that all events occur before the field is filled which means I can't act...