Search results for query: *

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...

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...

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...

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...

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...

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

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...

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

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...

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...

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

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...

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...

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...

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

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

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

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...

Is the Then I have already in the wrong place? SO

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