in
All Tags » VBA » forms (RSS)

Browse by Tags

  • Access 2007 VBA end user saving control captions

    Hi Experts! Note sure if this is possible (I really hope it is) but here's the scoop. I've a form whereby the end user can select what their buttons do. It works to a certain degree except when the form is closed the captions are lost. From the code below - here's the way it works... User...
    Posted to Access Forms (Forum) by microsoft on 05-28-2010

  • Get Cursor to Start in Left Part of Date Field

    I have some forms in Access that have quite a few dates to be entered on them. The information is not always entered in a particular order, so the end users will skip around the form by clicking on the field to enter. They are asking me if I can fix it so that when they click on a date field, the cursor...
    Posted to Access Forms (Forum) by microsoft on 05-28-2010

  • Access 2007 VBA - hold value in control after on_change event

    Hi Experts, Not sure how to google or ask this question, but here it goes. I have a text box that is populated by a dlookup. When a user changes the value in the text box it becomes empty (on purpose). However, their first keystroke is also lost. I'd like to be able to keep it and put the cursor...
    Posted to Access (Forum) by microsoft on 05-25-2010

  • MS Access Make Forms Have an Icon that Lock and Unlocks Record Editing, MsgBox Confirmation of Record Change

    Hi My employees have been changing some of our Database records by mistake. 1. I want to have all Forms load as Read Only, (No Edits), and have them able to press an Icon (perhaps a lock that unlock on click and viceversa) that enables additions 2. Also, I wan t MsgBox to appear that informs then to...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-20-2010

  • Wait for user input on Access form before continuing code

    Refer to the attached access file, and run the sub tester in module1. basically, I want to call a form during execution of the code. once the user has pressed some input, then I want the code to continue. now, is there a better way to achieve this, rather than using a loop?
    Posted to Access Forms (Forum) by microsoft on 05-16-2010

  • VBA to restrict values and clear values on an Access Form

    Please refer to my attached database to better understand what I’m looking to accomplish. In frmLookUp I have two controls—fld1 and fld2. When I select a value for a particular record for Me.fld1, I would like to clear the values within that record for all other fields. For my attached database, I would...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-15-2010

  • Populate Listbox based on Wild card search

    I have a combo box that lists a bunch of descriptions of products. Limit to list is set to No. So they can either pick something from the drop down or type something in. If they type something in (and it's not in the list), then I want to do the following: Make visible a listbox (that's hidden...
    Posted to Access (Forum) by microsoft on 05-10-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

  • Corrupt Database - OK to copy code?

    I have a database that is corrupt. My last backup does not include a component that I need to recreate. I can get into the design view of the forms that I need to recreate. Is it OK to copy all the code out of them, and paste that code into my new database? Or can that corrupt the new database?
    Posted to Access Coding/Macros (Forum) by microsoft on 05-01-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
Page 1 of 6 (57 items) 1 2 3 4 5 Next > ... Last »