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: *

  1. SellOut

    Cross reference table into list

    Hello, How can I convert a cross reference table into a list of two reference columns and a data column. eg. Longditude and latitude and wind speed long. 0 1 2 3 4 lang. 0 1 5 8 2 7 1 4 7 2 8 3 2 5 3 8 1 9 into.. long. lat...
  2. SellOut

    Wireless connection lost after 5 minutes

    Hello, I know very little about networks so I hope this is a really obvious problem. I have a Linksys 2.4 broadband wireless router and an IBM t40 thinkpad which i have just received. My flatmate also has a laptop of another brand. My flatmate can connect to the wireless network trouble free...
  3. SellOut

    Word2003 Page Numbering, jumping page numbers

    Hello, I have a specifically formated word file that basically produces the cover and chapter pages for a type of document I regularly produce. Currently in order to make the page numbers correct I have to insert various blank pages to act as the pages I will insert once the document is...
  4. SellOut

    Excel- Changing Dates to Text format

    Hello, I have an excel sheet that I am trying to import into Access. Two columns in the sheet have some cells that are formatted to date. This creates problems when importing into Access because it suggests the field should be Date/time when I want it to be text. I have been trying to copy...
  5. SellOut

    Date as table name in Make Table Query, SQL

    Hello, I would like to run a Make Table Query that each time it is executed saves the new table as 'Table' followed by the date and time, eg Table_2005_01_15_Time_06_37 or something similar in a different order. Something along the lines of: SELECT Original_Table.* INTO Table&Date&time...
  6. SellOut

    Access 2000, Querying same condition in one or more columns

    Hello, I am making a query that leaves only records with the condition <>"ok" in any one or more of its 30 fields. Is there a way around adding 30 lines and typing <>"ok" in each field with a line to itself? I am open to SQL suggestions as well. Thanks, SO
  7. SellOut

    Access2000. Same criteria in several columns. Comparing

    Hello, I am writing a query to seperate only the records with '<>ok' in any one or more of the columns. I have so far written a staircase shaped query in the design view that looks like this: <>ok <>ok <>ok and on and on! with each line having one column with the condition in...
  8. SellOut

    Access, taking sections a string

    Thats great thanks. I haven't used Access for a bit and I am pleasantly surprised how easy that is to do! Cheers, SO
  9. SellOut

    Access, taking sections a string

    Hello, I have a column with lots of values in the format '12PR' ie number, number, letter, letter. In fact they are all two digits followed by the letters 'PR' unless they are null or a '-' neither of which I want to include in my final result. I would like to just have the numbers in a query...
  10. SellOut

    Comparing sheets of data Excel or Access?

    Hello, I have three versions of what should be similar data and I want to compare them to find where there are differences. Two sheets are in excel and one is currently in access. I was intending to import the three sheets into an excel file on seperate sheets and, as each relative cell...
  11. SellOut

    Access Filter loses new records

    Matthew, Thanks for your help, that is working very well! SO
  12. SellOut

    Access Filter loses new records

    Hello, You are right but I am still slightly confused. The table (imported from excel) contains lots of empty squares which seem to not be Null. They don't appear to contain anything, not even a 'space', but are still counted as not null. Is there a way to change either my empty cells to...
  13. SellOut

    Access Filter loses new records

    Hello, I have a large access database with several users and tables etc.. I have a query that shows only the records applicable to my area from a large table (filtered on one column). In this query I have added two new records filling in about half the columns and leaving the others blank (NB...
  14. SellOut

    Excel Paste into autofilter table

    I want to paste two columns of data into only the visible cells of columns in another 'autofiltered' table. When I paste it in the data fills the hidden cells too which is no good for what I intend. Is this always the way it is? I feel confident I have been able to just paste into...
  15. SellOut

    Excel; Find while Autofilter is on

    Thanks for your help. I have got a new computer and everything seems to be working fine now which is good. I guess the old one just couldn't cope. Cheers SO
  16. SellOut

    Excel; Find while Autofilter is on

    Hello, Is it normal that I cannot use the Find function in Excel 2000 when the autofilter is on or can I go to my boss and ask for a non-clockwork PC? Thanks, SO
  17. SellOut

    Excel IF statements in VBA user defined Function

    Tony, Thank you!!! We must have been writing our replies at the same time! The Like statement is exactly what I was looking for! Thats great, my whole day is going to be a lot easier!!! Thanks, SO
  18. SellOut

    Excel IF statements in VBA user defined Function

    Hello, I have worked out some of what I did wrong. Firstly the statement needs to start on a new line after the Then. Secondly my use of * as a wildcard does not work (I am a bit of a vba novice). I have adapted this to using the Right function but this only works where the strings I am...
  19. SellOut

    Excel IF statements in VBA user defined Function

    Is the Then I have already in the wrong place? SO
  20. SellOut

    Excel, Multiple IF statements

    Thanks for your help but I have continued down the Function route as I need to keep repeating the operation on several different workbooks. I have posted another follow on problem with regards to my VBA code where I have tried to use elseif statements. Cheers, SO

Part and Inventory Search

Back
Top