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 ...
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 ...
5 pts.
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 column with every...
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 column with every...
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 give, including telling...
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 give, including telling...
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 Worksheet ...
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 Worksheet ...
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 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)....
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
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
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...
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...
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...
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...
Link Outlook Calendar to Excel Spreadsheet
Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...
Hello I am new here and this is my first post. I am wondering whether is possible to link Outlook 2003 Calendar to a spreadsheet in the same way as you would link 2 spreadsheets. For instance if a new entry is created in the Calendar the spreadsheet would be updated automatically. So far the way I...
Microsoft Word 2003 VBA Endnotes
I have a report that I am creating in MS Word 2003 VBA. I need to place some text at the bottom of each section in a Footnote or Endnote. The report is not behaving and the Word Help is not helping, does anyone know a good site to explain how to use and give examples of using Endnotes and Footnotes?
View Answer
| Apr 28 2009 4:55 AM GMT
VBA, Word 2003 Templates, Microsoft Word 2003 footnote/endnote
I have a report that I am creating in MS Word 2003 VBA. I need to place some text at the bottom of each section in a Footnote or Endnote. The report is not behaving and the Word Help is not helping, does anyone know a good site to explain how to use and give examples of using Endnotes and Footnotes?
View Answer
| Apr 28 2009 4:55 AM GMTVBA, Word 2003 Templates, Microsoft Word 2003 footnote/endnote
VBA How to get cpu usages and updated in every one hour,in with in the system.
How to get cpu usages and updated in every one hour,in with in the system.
How to get cpu usages and updated in every one hour,in with in the system.
Picking values in the intersection of row and column values
In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem...
In row 1(column 2-column11) i have location"<NAMES>"(all different) and in cloumn1 i have customer codes, and the values at an intersection of particular customer code & location are hard coded. I m giving the picking values for customer codes and locations from user defined data. The problem...
ComboBox in Microsoft Excel VBA
HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?
HOW TO RUN A MACRO WHEN SAME VALUE IS SELECTED IN THE COMBO BOX IN EXCEL VB?
Paste values over a formula on condition of a column in same sheet
Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 = “X” – then select F2 and paste...
Answer Question
| Apr 21 2009 9:49 AM GMT
Microsoft Excel macros, Visual Basic for Applications, Microsoft Excel formulas
Hi, I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do. Basically I need to run a check which does the following: If J2 = “X” – then select F2 and paste...
Answer Question
| Apr 21 2009 9:49 AM GMTMicrosoft Excel macros, Visual Basic for Applications, Microsoft Excel formulas
VBA EXCEL 2003 table coding
Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.
Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.
Meeting Invitation not updated in Calendar
I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for...
I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for...
Microsoft Excel to VBA
We are working on a spreadsheet that we need to run with VBA. I need a field to hold "". when running it in VBA it gives me 4 to 8 "". How do I get it to just give me 2 ""?
We are working on a spreadsheet that we need to run with VBA. I need a field to hold "". when running it in VBA it gives me 4 to 8 "". How do I get it to just give me 2 ""?
vba recorder issue
When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...
When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...
Microsoft Excel subtraction using VBA
I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...
I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...
How to Create "Are you sure you want to ...." MsgBox
I am creating a userform at the bottom of which there are various commands including "Save". When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an "Are you sure you want to save" box with the options Yes and...
I am creating a userform at the bottom of which there are various commands including "Save". When you click on this I ahve written in a series of checks to make sure that all the fields are filled in correctly but after that I want an "Are you sure you want to save" box with the options Yes and...
