Search results for query: *

I am trying to write a VB Script to run a SAP transaction and download to Excel. Then manipulate the output. What I want to do is with the first worksheet (objWB1), is to activate it, select all data in column A, insert a sheet ‘after’ the current sheet, paste and then remove duplicates. Then...

I have to keep track of an item through a sign-off process. When we get an new order for a item, we want send it through all departments for approval and keep track of the who/when it was completed. Fields that I need are: Item DateCreate EngAppToSchedUser (Engineering Approval to Master...

I have a situation and don’t know the best approach. I have come into an environment where there are many databases (20-30) using many of the same tables. Example is that db 1 may use tables from 2,4, & 5 and db 2 may use table from 4. Hope that makes sense. One db in particular has...

I need to count the number of records in a sub-group then update all the records to the value of the max count. In the example data below I need to change all of the values of group ‘4138’ to ‘LVS’ , since the count is LVS – 3 and LVL – 1. Now for the tie breaker – If there is a tie then I...

I have linked the “Global Address List” from the Exchange server, however, it seems to only contain the information on the ‘General’ tab. Like First, Last, Address, City, State, etc. When I open the properties of a contact I see a tab label “Organization.” On this tab it lists a manager and...

I have a query that contains 56 fields: Item, Desc, Wk1, Wk2, Wk3, ... Wk56. What is the best way to select the Item if any field (Wk1-Wk56) contains a value that is less than zero?

From sample the data below, I need to return the 'Grp' if any value in cItem contains '4' in the 3rd position and a citem begins with '120' within that group. Grp Item Date cItem 1 123 5/15/00 014236 1 235 9/19/03 120236 1 173 2/23/01 014998 1 126 8/13/02 024329 1 143 1/19/06 014236 1...

I need a way to find the first occurrence of any of the following characters that appear in a string starting in position 3 and return the position. Characters to find: _ / - * {space} ' I know I can do it with nested if's and instr but believe there has to be a slicker way. Can anyone help...

I have searched and reasd many posts here and founf several ways to get the userid and computer name, Like: Environ("username") Environ("computername") However, I can not find anything on how to find the user's name. ie. like the name used on the top of the start menu in XP. Is it...

When I boot up my PC, IE 6 also starts. I have been unable to find what is making it startup. XP Pro sp1 IE 6 sp2 Can someoene help me?

I have a databse that contains a table called tblWeeks. I know that there are many databases that link to this table. I want to change the location of my database but if I do then all of the 'links' will be broken. Is there anyway to search/find all the db that use this this table so I can...

I have a ListView which I have set the following: With Me.ListView1 'Set ListView style .View = lvwReport .GridLines = True .MultiSelect = True .FullRowSelect = True .Checkboxes = True .ListItems.Clear .ColumnHeaders.Clear...

I have a report/subreport as follows: Date Qty Comp Rem 9/12 100 90 10 Oper Made 1 35 2 25 3 20 Total 90 9/14 200 150 50 Oper Made 1 150 Total 150 ----------------------------------------------------------- 300 240 60 The...

I have a form when I open I fill a treeview control recursively. I want to be able to open this form by double-clicking on a value from another form and only displaying the node related to double-click value. If this can't be done then can I open the form and move to and expand the node...

I have ‘inherited’ a table with data structured as such: All data is in one table… no joins. Item Item Qty 11 21 1 21 31 2 21 41 1 21 63 14 21 76 5 63 55 2 41 85...

I am trying to automate the transfer of data from Access to Excel. The file is password protected and contains links to refresh. I want to open the workbook, give it the password, refresh the data, then append the access data to the end of the existing data in Excel. It appears that the...

I have a report that contains two subreports. If I print the report directly to the printer both subreports print as expected. However, if I preview the report first, the preview will show both subreports correctly, but when I print from the preview screen the second subreport will not print...

I have an Excel sheet with data like: 253549 200529 C-8661-A 265 KB18392 200529 C-8571-A 100 36080 KB18129 200529 C-8656-A 300 36198 262551 200529 C-8149-A 172 36198 262552 200529 C-8571-A 74 36301 258235 200529 C-7651-B 400 200529 Total...

I have the following data that I have added subtotals to get several totals for each week time period. Within each week I also need to know how many different ODs occur and how many different Balls occur. See highlighted numbers. In the example below I used the formula...

I am trying to use the code below in my query to reference a field on a form. I'm using Access 2002 SP2. <=[Forms]![frmShipRequire]![EndDate] When I execute the query I get the error message: "The Microsoft jet database engine does not recognize '[Forms]![frmShipRequire]![EndDate]' as a...