Browse by Tags

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
"Download file" dialog automation

I'm trying to automate a File download dialog from a web site, using IE automation on VBA. So far I've succeeded in getting the handle on the dialog window and the control (save button). But i can't click on it, although I've tried (as you can see in the code) several alternatives. The...

Posted to Automation (Forum) by microsoft on 04-25-2010
Query with Recordset-Dependent Field Values

I have two Access Tables. Table 1: contains an identifier and a value, call it B(0,k), where k in [1,n], n = # of recordsets Table 2: contains a set of fields: 1. identifier: i(k), where k runs over n. 2. dates: D(i(k), t), where i is fixed identifier, t ranges over a time period [0, T] 3. value1: v1...

Posted to Queries (SQL) (Forum) by microsoft on 04-22-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
How do I change cells marked as #Name? to display as a string?

Hi, I have a spreadsheet with a range of data I need to parse. Certain cells, as shown in the attached spreadsheet contain the value '#Name?'. The string(s) contained in the cells start with '=' sign. Is there VB code I can use to append/change these cells so the string contents display...

Posted to Microsoft Programming (Forum) by microsoft on 04-11-2010
open word document and populate with access data

I would like my users to be able to click a button on a form which is based on a query (filtered) and open a word document that displays the filtered results nicely formatted. I set up a word document as a mail merge but do not know how to create the link between access and the word doc from Access.

Posted to Access (Forum) by microsoft on 03-21-2010

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