Browse by Tags

Easy: How can I clear the contents of a ListBox in Access VBA?

This is kind of crude code, but what I am doing should be a no brainer. It is a no brainer in vb 6.0, but I can't do this in VBA for Access? The math is simple .ListCount - 1, but it doesn't work. All I need to do is clear the items in a list box. My application has an unbbound List Box control...

Posted to Access (Forum) by microsoft on 05-22-2010
LOOP THROUGH EXCEL WORKSHEET & INSERT SPECIFIC COLUMNS DATA INTO ACCESS TABLE

I have a table, tblOwner, in my Access 2003 database. I am able to browse & capture the path to a specific Excel workbook. That is where my skills end. I need to be able loop though all the data rows in the 1st worksheet in the Excel workbook, and insert that data into my tblOwner. However, following...

Posted to Access Coding/Macros (Forum) by microsoft on 05-18-2010
Send E-Mail from MS Access based on form field value

I have an Access 2000 database which is used to track equipment movement throughout our facility. The scope has continued to creep WAY beyond initial project presentation (who's surprised??) Here is basic function: 1. Grab item off shelf 2. Go to PC running databse and click 'Remove Item'...

Posted to Access (Forum) by microsoft on 05-09-2010
Import text file into Ms Access and replace missing values with value form previous record

Hi, I have a requirement to import data (txt file) into an access db. The text file is from our corporate HR system. The issue is that the file drops certain values from the text file output where the value is repeated, exactly like ms access function 'Hide Duplicates'. The issue is that I use...

Posted to Access Coding/Macros (Forum) by microsoft on 05-08-2010
Cannot Make Word Application Visible with Access VBA

Hi. I'm just getting into the world of automating between Office 2007 applications using VBA. I have a simple Access database which stores survey questions, and a form which displays the results of a user query. Once they have found a question they like, they click the INSERT button to copy the current...

Posted to Access Coding/Macros (Forum) by microsoft on 04-23-2010
How do I search between two worksheets comparing cell value in each?

Hey all, Please see the attached Excel files, there are two. What I need to happen is the following: 1) In workbook 'Example', I need to use a filtered range in the 'Changes' column of 'New' and 'Modified'. 2) In workbook 'Example2', for each value in column 'A'...

Posted to Microsoft Programming (Forum) by microsoft on 04-22-2010
How do I search between two Excel sheets?

Hello, Please see the attached Excel sheet. I am trying to do the following: 1) For each value in 'Sheet1' column 'B', search 'Sheet2' column 'A' for an identical value. 2) If an identical value exists in 'Sheet2', place the value from 'Sheet2' column 'B'...

Posted to Other (Forum) by microsoft on 04-19-2010
How do I remove all characters in a string before the first occurance of a certain word?

Hi, Please see the attached example Excel sheet. In the 'B' column on the 'BEFORE' sheet, notice there is junk test placed before the word 'Summary'. I need a VB macro that removes the junk text from each cell so the end result is as shown in the 'AFTER' sheet. The range...

Posted to Microsoft Programming (Forum) by microsoft on 04-19-2010
How do I dim/grey out buttons after using them to run a macro?

Hello, I have created an Excel add-in that will display macro buttons. After a macro is run, is there a way to have the button mapped to that macro dimmed/greyed out so it can no longer be selected? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25...

Posted to Microsoft Programming (Forum) by microsoft on 04-11-2010
How do I split one string into two?

Hello, Please see the attached Excel file. Using VB code, I want to be split each string in column 'A' into 2 separate strings. The seperator for the two strings could be the '>' symbol. Any idea how to impliment this? Thanks, mvem

Posted to Microsoft Programming (Forum) by microsoft on 04-11-2010

Page 1 of 4 (31 items) 1 2 3 4 Next >