wbw
Last Activity: Jul 11 '08, 08:11 PM
Joined: Mar 4 '08
Location:
-
Extract Capitalized Words from Text
I am trying to extract capitalized words from text in Excel. I have a list of a combination of brands and products and I am trying to extract out the product attribute from the text. Since the text varies in length, I cannot use standard text parsing excel functions to extract the product from the text. I could use text to columns but that gets labor intensive. Is there a way to extract out the capitalized words from text in Excel? How do I... -
The SEQNO field needs to be a sequential number starting from the first sold date and increment by 7, for example 1 for the first week, 2 for the second week, 3 for the third week… regardless if it sold in those weeks or not. -
Create Sequential Numbering Pattern from Date
I have a database of products in which I have determined when the product sold. The table has two fields ITEM and SOLD. Each product’s first selling date may be different and may not have sold in every week. I need to assign a sequential numbering pattern since the product was first introduced. A new field, SEQNO, needs to be created to show 1 for the first time, 2 for the second time, 3 for the third time… etc. I would like to benchmark... -
Listbox (or Combobox) Problem
I am trying to filter on rows with a selected value from a listbox and when I step through the ComboBox2 code, it jumps to the ComboBox3 code from the third line (.EntireRow.Hid den = True). This happens when I use comboboxes or listboxes. Why does it jump to ComboBox3_Chang e? I have seen this happen when I have code in more than one listbox/combobox on a worksheet.
Private Sub ComboBox2_Chang e()
With Range("A10:N296 ")... -
I understand your code changes the table name from oldName to newName, but where does it define Table oldName to be the right 9 characters beginning with the word 'DataTable' and change newName to just 'DataTable'?Leave a comment:
-
I am getting tripped up on how to write the From statement. Also how would you deal with aliases when working with multiple tables? Here is an example of my SQL string using a ADODB.Connectio n in VBA-
sSQL = " SELECT a.LDesc, b.ItemID, m.metric1, m.metric2 " & _
" from table_name LIKE 'datatable%' m " & _
" JOIN DimMrkt a ON a.ItemID = m.Mrktkey
" JOIN DimPer b ON...Leave a comment:
-
Select * from (Right 9 digits on table name)="datatable"
I will be querying from many databases and all of the databases that all have a table beginning with word the "DataTable" , but are named differently for example DataTable981911 , DataTable98174, DataTable946. How can I create a select query on table beginning with the word "DataTable" ? Find the table 9 characters in length beginning with the word "DataTable" and then do the select query from it. Thanks for your hel... -
Change Access Table Name from Excel VBA
How can I rename an Access table from Excel VBA? I know <DoCmd.Rename "new_name", acTable, "old_name"> however the ending characters of the "old_name" will vary from database to database. I need to know how to change “DataTableNLR98 1911” to just “DataTable”- the ending variable “NLR981911” will change and may vary in length too. Find the table 9 characters in length beginning with DataTable and then...
No activity results to display
Leave a comment: