Search results

What is the User Base? What is the Security Requirements? How Large will it get? There are many questions that you have to have the answer to in order to make a well informed stance on what would be the best to use.

You could also try this: (Creates an array only as big as the number of Items actually selected) Dim monthArray As Variant Dim strSelected As String 'array is created as a dynamic array 'need to grab the values of the multiple selections from the list box 'and...

I agree with Mailman, Pad leading Zeros. However I would suggest more then two. Select * From [Table] Order By Format([Priority Field Name],'0000000000')

If your bound column is 1 and you want to reference the first field in the columns property you need to use 0 [Forms]![frmInput]!cboReferrer.Column(0) This is what is refered to as a Zero Based Property.

When you have the frmInput open goto the immediate window (Debug window for those of us who have been around awhile) and type the following line: ?[Forms]![frmInput]!cboReferrer.Column(2) What does it return? A string of text or a numeric ID? From what I am reading the field...

References are Machine Specific. It may be that a new ADO driver has overwriten the current one (Such as a new app being installed that over rights even newer versions of the DLL) To the version of ADO being used not being installed on PC.

For iLp = 1 To 3 If Me.Controls("Combo" & iLp).Value <> "" Then If sqlvital <> "" Then sqlvital = sqlvital & " AND " End If Select Case iLp Case 1: sqlvital = Case 2: sqlvital = Case 3...

You will only need to check the references on the MDB file that runs the code. Most of the time this is only the Front End (FE). You will know that you have a broken/missing reference when you goto the code view, Tools, References and see the words Broken or Missing on the selected reference...

Basic concept is to not loop 1 to 4 but 1 to 3. Then on Case three check to see if data exists (since the code you sent me seems to deal with Dates use ISDATE) in the COMBO 4. If it does create a Between... AND ... statement. If it doesn't create an equal statement.

Check your references and make sure that you still have an ADO reference. It may be missing or broken. Also make sure that you don't have any other missing or broken references as these sometimes cause issues with the native commands of VBA.

In the QBE Grid replace the Criteria with a reference to the form and Combo: Example: =Forms![Your Form Name].[Your Combo Box Name]

Yes See the following MS Knowledgebase article. http://support.microsoft.com/default.aspx?scid=kb;en-us;209207&Product=acc

You could use the Mouse Down Event of the Combo Box and use the X parameter and the Combobox's Width property to determine if the user clicked on the Arrow.

You may. My Email is in my profile

Public Sub OpenReport() On Error GoTo ErrorHandler DoCmd.OpenReport rptcustomers, acViewPreview Exit Sub ErrorHandler: 'Err.Number 2497 is the Report Cancel Error Message 'This will ignore this error If Err.Number <> 2497 Then MsgBox Err.Number Else...

Where you have the Docmd.OpenReport you will need to Trap for the Error (On Error Goto ErrorHandler)

What I put in my response was from the MS Access Help file. SendObjects requires a To (mind you I think the programmers forgot to talk to the Outlook programmers, since Outlook does not require a To if CC or BCC is used :) )

Search here: http://www.mvps.org/vbnet/

check out this site: http://www.mvps.org/vbnet/ Select Search VBNet Use [b]PING[/p] as what you are searching for You will find an articles entitled - Determining if a Network Destination is Reachable Determining a Network Host Name and IP Address Using Visual Basic How to Ping an IP...

Basically this means someone needs to be the receipent (You need to supply the to.)