Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Loomah
  • Content: Threads
  • Order by date
  1. Loomah

    Flat File Source Alternatives

    Hi 2 or 3 years ago I created my first SSIS package in SQL2008, upgrading SQL2000 DTS packages. I knew little of ETL at the time (I'm not much better now!) When I was doing this everything fell at the first hurdle - ie importing some data from a csv file. There were numerous errors and when...
  2. Loomah

    CopyFromRecordset slowing down to a crawl with large-ish recorset

    hi i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in excel 2003 - there are currently c420000 records, expanding at around 1000 a week. this is the requirement, i have no option to use access or later versions of excel for the output. i have been...
  3. Loomah

    excel11.xlb on widows 7?

    hi i think i'm going mad! i've just set up a new home pc with windows7 pro (64bit) having loaded office 2003 i then copied my 'old' excel11.xlb file over to the new machine. when i open it it retains the customisation i'm used to but after closing it and opening excel from the programs menu it...
  4. Loomah

    Query Filter 'masks'

    hi i know i'm using the word mask (in the subject) in not quite the right context here but... in access 2003 i would like to exclude a set of records from a query but can't quite get my head around what kind of criteria i need to use. the format of the values to exclude is consistent and...
  5. Loomah

    Importing a Record Set

    hi I’m developing a system to import data from a total of 96 spreadsheets into 3 tables in access, ie 32 spreadsheets into each table. giving the end users access is not an option as it is not a permitted application on the network and users will change from day to day. I’m not an expert when...
  6. Loomah

    capturing import error tables

    hi i'm creating a tool that imports data from nearly 100 'input' spreadsheets accross a network. the import process works fine but there are occasionally import error tables created. is there a way of checking at the end of each set of imports whether a import error table or tables has been...
  7. Loomah

    location of active/current db

    hi i'm not too hot on access vba (or access in general) but is there a way to identify the location of the active database? basically the access equivalent to excel's thisworkbook.path thanks! ;-) If a man says something and there are no women there to hear him, is he still wrong? [ponder]...
  8. Loomah

    Pivot Tables : Multiple Summaries

    Hi I've been asked to produce a report based on a set of data. the solution lies in creating a pivot table (or multiple tables) and a chart. The data consists of, amongst other things, the date, a unique id, and a department name. the basis of the requirement is to report on the count of id...
  9. Loomah

    Allocate Ranges with Chart Sheet active fails

    Does anybody know why the following code fails when the active sheet is a Chart sheet. There are no chart objects (other than the chart itself) selected. ActiveWorkbook.Names.Add Name:="Data_Full", _ RefersTo:="=RawData!" & Range(Cells(1, 1), Cells(lRow, LAST_DATA_COL)).Address error is...
  10. Loomah

    Run one query following completion of another

    Hi I'm no Access expert so please bear with me on this! I have a create table query that merges data from 5 other tables into a single source. I now need to update the new table (I have the update query) immediately after it is created. The update data doesn't fit nicely into any of the...
  11. Loomah

    Too Few Parameters

    OK, I'm hoping this forum is more appropriate to this than the Office forum. I'm trying to set up a spreadsheet to import data from a query in an Access database. The query simply extracts different data elements from 5 tables that will form the basis of a paybill model. Using xl and Access...
  12. Loomah

    SUMPRODUCT giving #VALUE! error

    Hi all I'm using sumproduct to find the total number of people who meet certain criteria in a pay model. The following works perfectly =SUMPRODUCT((Band=A4)*(Range=B4)*(FT_Sal>=B19)*(FT_Sal<=B20)) where Band, Range & FT_Sal are all named ranges which are (currently) 1 column by 500 rows...
  13. Loomah

    Does Find work in a worksheet UDF??

    Hi All! Am I just being dense/stupid or does Find not work when in a function? The background is that I need to be able to calculate the median value of a cells depending on a criteria (well 2 actually!) The ideal function would be DMEDIAN but it doesn't exist in xl97!! So the following is...
  14. Loomah

    System Tray - List applications

    I've looked through many sites for what I thought would be an easy thing to find but it seems it isn't so common! Plenty on how to add, change etc apps in system tray but not list. So, is it possible to list applications currently in the system tray (visible or not) inluding where the target...
  15. Loomah

    ISNA() generating #N/A ??

    Hi all This isn't really a life or death situation. My original question was going to be:- why does this work =IF(ISNA(AS2),AM2*(1+Uplift2),IF(AS2=0,AM2*(1+Uplift2),AS2)) and this doesn't (generates #N/A error) =IF(OR(AS2=0,ISNA(AS2)),AM2*(1+Uplift2),AS2) But just before posting I checked the...
  16. Loomah

    Doesn't like hotmail!

    Hi Not sure if this should be in here or if the problem lies with IE. On my home laptop I'm set up as Administrator and others as Limited users. However the limited users can't log into their hotmail accounts. I can log into a hotmail account and if I change the account type to admin the...
  17. Loomah

    Pivot Medians

    Morning All! I'm trying to create a Medians field in a pivot table of salary data using a formula The data is broken down by grade from fairly large data set and shows head count and mean. I'm trying to use a formula for the median value but keep ending up with sum of the calculated field...
  18. Loomah

    Add In Error?

    Hi All A Strange occurance... I'm getting an error message as follows "Cannot Open MS Excel 97 Add-In for editing. Please edit the source doc instead" The background:- I have a file which requires that the Analysis Toolpak is installed but I have (stangely) come up against some resistance to...
  19. Loomah

    Protection - UserInterfaceOnly

    Hi All I'm almost afraid to ask but I really do think I'm going mad!! I'm protecting a worksheet (xl97, SR2) using UserInerfaceOnly, with relevant cells locked and unlocked but once data has been entered the sheet becomes unprotected. This even happens with a password. I want the protection...
  20. Loomah

    Shift + Enter moves up one cell

    Hi All Using xl97(sr2) on NT4(sp6) I'm trying to enter text onto 2 (or more) lines in one cell. Normally SHIFT+ENTER does the job but it isn't working here! I end up just moving to the cell above!!! Anyone ever seen this "feature" before or am I just luck? ;-) If a man says something and...

Part and Inventory Search

Back
Top