in
All Tags » VBA » ms access 2002 (RSS)

Browse by Tags

  • Compare FileName Data in Access Against FileName on Server

    I am doing a daily import of files from my X:\ into Access. I have a table in Access that logs the file names and paths (e.g. X:\MyFolder\Import\FileName.xls) of files that have been imported. I would like to compare this data list against the names of files that exist in that same folder (e.g. X:\MyFolder...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-25-2010

  • Custom Message Box

    I have a combo box from which a user selects a claim number. If they type in a claim number that is not on the list, a standard message box pops up: The text you entered isn't an item in the list......... I would like to replace this message box with my own that gives them more detail of what to...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-02-2010

  • Filter a Recordset on a Form

    I have a form that has a combobox [claimCombo] from which I select a ClaimNumber. That box has two fields, ClaimID (autonumber) and ClaimNumber. Here is the SQL for the underlying query: SELECT tblClaimInformation.ClaimID, tblClaimInformation.ClaimNumber FROM tblClaimInformation; I want the selection...
    Posted to Access Coding/Macros (Forum) by microsoft on 04-25-2010

  • Update table from report

    I have a report that runs from a button on a form. The report automatically launches into word with the following code: Dim QueryName As String Dim sql As String Dim rc As Integer Dim db As Database Dim qdf As QueryDef Dim StrVendor As String Dim StrInvoiceNumber As String Dim StrClaimNumber As String...
    Posted to Access Coding/Macros (Forum) by microsoft on 04-14-2010

  • Duplicate Values Error message on close of Form

    I have a very simple Splash form that starts my database entry. It has a combo box, and 2 fields (not visible). The 2 fields are filled in with info from the combo box: Me.ClaimNumber = Me.ComboName.Column(0) Me.ParentClaimNumber = Me.ComboName.Column(1) I have done this, so that when the user clicks...
    Posted to Access Forms (Forum) by microsoft on 04-11-2010

  • Nested IIf syntax

    I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...
    Posted to Visual Interdev (Forum) by microsoft on 03-27-2010

  • Nested IIf syntax

    I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...
    Posted to Visual Interdev (Forum) by microsoft on 03-27-2010

  • Nested IIf syntax

    I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...
    Posted to Visual Interdev (Forum) by microsoft on 03-27-2010

  • subform with 2 different links?

    I have a form with 2 subforms. They are linked with a ClaimNumber parent/child link. There is a combobox that allows the user to choose the ClaimNumber. When they do, the subforms load. I need to have another way to load the subforms - with a combobox to look up PolicyNumber. Is there a way to change...
    Posted to Access Forms (Forum) by microsoft on 03-18-2010

  • Sudden Error Messages after duplicating form

    I had a form with 2 subforms on it, working very nicely. I needed to make a similar set of forms, with a different lookup on them (first looks up by ClaimNumber, second by PolicyNumber). Everything is identical on the forms except for the combobox that allows you to look up records. I saved the working...
    Posted to Visual Interdev (Forum) by microsoft on 03-10-2010
Page 1 of 2 (12 items) 1 2 Next >