Search results

Describe the columns in this list box. Or email me the database.

Private Sub Hrs_Calc() Dim i As Integer Dim JHrs As Double For i = 0 To lstResults.ListCount - 1 JHrs = JHrs + lstResults.Column(1, i) 'assumes the data you are looking for is in column 1 (the 'second column in the list box) Next Job_Hrs = JHrs End Sub

Create a new button on your form. In its OnClick event, paste the following: DoCmd.RunCommand acCmdSpelling Good luck!

I too am having trouble with the OCX. Pat, can you provide guidance for using the API?

Send it on over. I'd be glad to help.

Sub SearchField() Dim db As DAO.Database Dim tbl As DAO.TableDef Dim fld As DAO.Field Dim strField As String Dim boolExists As Boolean Set db = CurrentDb Set tbl = db.TableDefs(InputBox("Please enter table name:", "Table To Be Searched")) strField = InputBox("Please enter the field name you...

Try this... 'BEGIN CODE' If Send = False Then MsgBox "Please select users" Exit Sub End If Dim NameSpace As Object Dim EmailSend As MailItem Dim EmailApp As Object Set EmailApp = CreateObject("Outlook.Application") Set NameSpace = EmailApp.GetNamespace("MAPI") Set EmailSend =...

You can email me if you like. I think I can help.

Look for help on SelLength.

Adding "All" to the combo box is no small feat. Why not add a button or something that will select all records for you? In the Click event of the button: Dim i As Integer For i = 0 To ListBoxName.ListCount - 1 ListBoxName.Selected(i) = True Next If you're still interested in adding...

Why not divide the given number by 1 million and then add some text to it. If txtNumber holds 2500000. The following code will return 2.5 Million in a text box called txtMillions. txtMillions = txtNumber / 1000000 & " Million"

Check your email.

'Place in AfterUpdate (or Click) event of check box Dim i As Integer If CheckBoxName = True Then For i = 0 To ListBoxName.ListCount - 1 ListBoxName.Selected(i) = True Next End If

Is this a VB app or an Access app (VBA)?

Look up the Nz() function.

DoCmd.Close acForm, "Pop-up Form Name"

Yes. This is a problem with references. If you ask your client to open the db with the SHIFT key down. Then go to design of any module (or code behind any form) and go to Tools>>References A dialog box will appear showing all the references. There will be one or more with checks next to...

Travis, Thanks for the reply. True for Office apps, not for MS Project. Any other suggestions?

Is it possible, in Access, to fire an event when a record is inserted into a table? I know I can do this via a user form, but without a form?

I am building an application that has the ability to export some data to MS Project in order to produce a Gantt chart view of a set of records. In order to do this, the database must have a reference set to the MS Project object library. This works beautifully on my machine, but I'm afraid...