1
  • Copy/paste a record with VBA in Microsoft Access

    How can I copy number of records from a form and paste them in another form with VBA, not with the right click, in MS Access? Thanks!

    Toli70 pointsBadges:
  • How to read HTML in Lotus Notes inbox messages in VBA

    Can anyone show me how to get html from Notes inbox messages in VBA? I am using Access VBA to send notes email messages.  The message is a form I'm asking the recipient to fill out and return.  The message contains html with <select> and <input> elements.  The replies come back and...

    JoeLilly5 pointsBadges:
  • Handling Record Update Collisions

    I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other...

    MarvinM8050 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • Microsoft Access: Hiding form fields with Null values

    Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing...

    Wesleycrozier30 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following