Access – Bound sub form trying to set the value of an unbound field
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

Answer Question   |  August 6, 2009  3:44 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA

format cell based on contents using VB
i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 [...]

Answer Question   |  March 29, 2010  10:45 AM
Conditional statements, Excel VBA, VBA, Visual Basic for Applications

Vlookup Worksheet Function
I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says ‘application-defined or object-defined error’ or more frequently I get something along the lines of [...]

Answer Question   |  August 12, 2009  12:21 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications, VLOOKUP function

how to create autonumber
while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don’t think its an autonumber because i used manualy so, hlp pls

Answer Question   |  January 23, 2012  6:46 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications

Combobox Intro. Question
Hi! I’m extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to “produce” the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to [...]

Answer Question   |  July 8, 2009  4:38 AM
ComboBox, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

Revision clouding on selected cell
I need to cloding e.g. revision clouding accors the selected cell. Can you help me to write macro for the same.

Answer Question   |  July 2, 2009  5:20 PM
VBA, VBA macro

Access Reports to PDF file
Greetings, I have an objective that’s been driving me in circles…. Windows XP Office 2007 I need to figure out how to convert “multiple” Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to access [...]

Answer Question   |  June 29, 2009  7:22 PM
Access 2007, Access reports, Microsoft Access, Microsoft Office, Office 2007, PDF, VBA, Windows XP

Import data from Lotus notes into Openoffice
I’ve found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to Open [...]

Answer Question   |  June 23, 2009  12:42 AM
COM, excel, Lotus Notes, Macros, Open Office, OpenOffice, VBA

Extract all instances of a search between two symbols
Dear Friends, I have created the following code to search entire C Column from WrkBk1 with “<*>” string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No. <pernr> Verify: 1. [...]

Answer Question   |  June 23, 2009  11:33 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

deny delete permission in VBA
How can I add a deny delete permission entry to acl of a folder for a user, using command line or VBA?

Answer Question   |  June 18, 2009  6:53 PM
VBA, VBA Permissions

Excel VBA cell.find
I have this code recorded by XL. Works ok. ** Cells.Find(What:=”dd”, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part – (What=”dd”, I want the macro to read Cell G1 and looks for text that is in that cell.. G1 changes often. Thanks Charlie

Answer Question   |  June 12, 2009  6:18 AM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

MYOB open macro causes ‘macro disable’ messages when Office documents opened
On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

Answer Question   |  October 25, 2009  12:57 AM
Macros, Microsoft Office VBA, MYOB, VBA

VBA copying a range from Excel and pasting to a text file
Do you know how to copy from excel and paste to a text file using VBA?

Answer Question   |  February 2, 2012  9:38 PM
Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

SQL or VBA code to loop through two columns of data
I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product has one to many link product [...]

Answer Question   |  May 20, 2009  12:34 PM
Microsoft Access, VBA

String Comparison VBA
I have two columns of string values in excel. They are part numbers so they are typically 6 – 10 characters and a mix of letters and numbers. The columns contain many like strings. That is, the part number is listed in both columns. I need a quick way to compare each string in one [...]

Answer Question   |  March 2, 2010  2:02 PM
Microsoft Excel, Strings, VBA

Viewing sametime user status on lotus via vba
Hi. I am newbie in this vba-lotus work, and right now I need to know if there is any vba class that allows to see via code a certain user state on lotus and if the status is disconnected, send a mail to ask for getting connected. I really appreciated all help that you can [...]

Answer Question   |  May 14, 2009  5:44 PM
Lotus Notes, VBA, VBA Class

VBA format a cell based on range contents
I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. ‘assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As [...]

Answer Question   |  May 20, 2009  5:11 AM
*RANGE, Conditional formatting, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications

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 list of components has [...]

Answer Question   |  November 25, 2011  9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

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 msaccess? Thanks

Answer Question   |  May 19, 2009  3:37 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications

Replacing this ListBox code with Treeview code in VBA
I am importing the Board file and loading the data into treeview directly(Busname as parent node and NetName as Child node with delimitor as ! and i have taken the (myArray(i), “!”)(1)) as Bus name and (myArray(i), “!”)(2)) as Netname. Simultaniously i am tracking the Duplicate Netnames Listedin a Listbox which is seperately created.Now I [...]

Answer Question   |  May 4, 2009  5:41 AM
Excel VBA, ListBox, Microsoft Excel 2003, TreeView, VBA, Visual Basic for Applications