Search results

Hello: Be sure to substitute your table name for the tblAscii entry in the code. Mark

Hello: the below code would cycle through all the fields in a table or query and display the title of the column in a message box: On Error GoTo Procedure_Error Dim db As Database Dim rs As DAO.Recordset Dim fld As Field Dim strRowSource As String ' Set db =...

Here it is...... http://support.microsoft.com/kb/209511/en-us Regards Mark

Hello: Are you trying to sum the whole column? More information is needed. Regards Mark

Hello: It is not possible. However, you may click here: http://www.utterangel.com/pages/access_downloads.aspx for a work-around solution. Regards Mark

Hello: Your welcome and good luck with this. Regards Mark

Hello: In your report footer, place a two text boxes with the following as the ControlSource: =Now() ="Page " & [Page] & " of " & [Pages] The first entry would go in the Left text box The second entry would go in the right text box Regards Mark

Hello: I looks as if you need to related all your tables with a "Primary to Foreign" key relationship to pull this off. What you have right now is called a "Look-up" table arrangement. Regards Mark

Hello: If you right-click on the query, you can select Properties from the menu and fill out a short description. It does not appear with the cursor though. The user by doing this can see what the query does. Regards Mark

Hello: Just in case I meet an untimely demise, heres the file. Regards Mark

Hello again I forgot to add my explanation: This will count all the records in a table named Employees that have PowerSteering checked in the "PowerSteering" field. Add the TractorID and PowerSteering field to the query only! If you need the file, Let me know. Regards Mark

Hello: SELECT Count(tblEmployees.TractorID) AS CountOfTractorID, tblEmployees.PowerSteering FROM tblEmployees GROUP BY tblEmployees.PowerSteering HAVING (((tblEmployees.PowerSteering)=True)); Regards Mark

Hello: The above link is for an Access project. Below would be for an Access database http://support.microsoft.com/kb/210242/en-us Regards Mark

Hello: Here's another link that tells how to build your own. http://support.microsoft.com/kb/235359/en-us Regards Mark

Hello: http://www.utterangel.com/pages/access_downloads.aspx Candace's "Flexible Query" might be what your after. Regards Mark

Hello: Access does not have a specific "Vertical Spacing" property for combo or text boxes. If your box is the right height for your font, the text should be somewhat centered in the box. Regards Mark

Hello: Your welcome. That came directly from the help file. What you condensed it to is what I use also. Good luck with this. Regards Mark

Hello: In your table design, just make your own custom format and put this in the "Format" property space of the table design. Something like this does it the trick...... dd-mm-yyyy: hh:nnampm Regards Mark

Hello: What you want to do is cycle through the controls collection on your form and at each control set its locked property to "True" (Locked). You want to repeat this procedure when you want to unlock the controls. Regards Mark

Hello: Here it is: Example The following example examines the ControlType property for all controls on a form. For each label and text box control, the procedure toggles the SpecialEffect property for those controls. When the label controls' SpecialEffect property is set to Shadowed and the...