Search results for query: *

Has anyone got knowledge of how this occurs and if so how to correct. I've tried looking around security and macros.

Thanks Duane that's exactly what I am wanting. In the existing form I am adding too I can see a command button with a black tick in the centre. I cannot however see this in the build drop down icons. If you understand my question any ideas where its come from or do I have to create it myself...

As I said very new to access forms. All I want is a simple form to use command buttons to run querys. What you are suggesting sounds like the sort of thing I need to do. I just am unsure how to find that property from design view or do I right click the command button I'm using to execute the...

I am new to forms and have an issue that I do not wish to see the line that is appearing at the bottom. I have checked object dependancies and I am using none. I cannot find a control source in properties either.

Skip, I do not seem to be finding any examples of how to tag data in a thread? I need every 21 rows from the spreadsheet converted to a single row. Keeping columns a to f as is. Then column g to aa is to be made up of the row values from the existing column i. Then 21 rows underneath the...

I have an excel sheet holding information in rows. Some of the 21 rows need to become 21 columns. for example cell I2 needs to become G1 cell I3 needs to become H1 The 21 row values in column j need to be kept in step. for example cell J2 needs to become G2 cell J3 needs to become H2...

Got it, Issue now us that the workbook I need to read was saved as a .xlsm file because it contains a VB macro. I am showstopped as the format required in MS query goes no higher level than have to be Excel 97-2000. I will save file again as an Excel 97-2003.xls. Thanks for now [neutral]

Thanks for the fast response but I do not see External Data GROUP, other sources from Data menu. Am I meant to change some of the excel options or something. The prompts are just so different to 2003.

Typical, I just get to grips with creating an excel msquery as data source/connection for a word mailmerge! What happens Office 2010 is installed, now they need a change and nothing works as the layout/familiarity with Excel 2007 is all over the place. Does anyone know the way now to create a...

Not to worry about the issue. My time using UNIX and VI should have led my thought process to using an alternative text pad. Thanks again Skip for all this help AC

Thanks Skip, OK, so I get into the SQL now. The drop down boxes for field names are way too small which is very unhelpful. Anyhow jump that bit because the query results are getting interesting. I have a 20" screen yet cannot expand the SQL coding space, its very small! Adding third table...

Skip, Excel 2003 Data> Import External Data> New dataabase Query > Choose Datasource > I selected New Datasource > Named it and chose Driver do MS xls > Clicked Connect and Selected my Workbook > The default table box confusing as it showed my table names twice? > Hit OK a couple of times and...

Skip, Now having understood the Index/Match solution I would like to progress with trying the sql one. I have created in the workbook a separate list(table) for each worksheet, ie Fund Description, Address, Monthly. I am unable to name these so I do not see how I can reference them in the Sql...

Thank You Skip I will look into trying both those offerings. Many thanks for all your ongoing support and perseverence on my behalf it's been invaluable and very much appreciated. Boy do you know your stuff!! [2thumbsup] AC

That's a fine solution but if I want to use the sheet as a mailmerge datasource will it print the 0 do you think?

Skip, [thumbsup2] many many thanks its at last doing what I wanted. There is one final issue I have and that is on the County column, some are blank. I used ISBLANK on the vlookup but appears not to work in MATCH. It returns a zero? AC

Thanks Are you saying both of my worksheets have to have create names in top row? My first test resulted in #name? When I returned to the version using the ugly alternative =if(ISNA(VLOOKUP, MATCH etc and substituted in the column number from the address sheet I was looking to fill it worked...

Skip, I've always found it impossible to get the likes of table and formatting into a thread. In an earlier attempt I tried offering uploaded file to media fire. I can only apologise for latest thread leaving you a mess as you put it to sort out. In my last thread I took your advice and...

Skip, working on the example you sent, I believed the result of the index/match OH to be Sunny from head3. I have created names and put an =if isna/index/match in the cell I require the result in. My lookup value is Monthly B2, my result requirement is Monthly J2 looking to receive...

Skip, thanks I not sure I can ask you anything more on this subject. I can get the results I want for Addressee(ColB) and Salutation(ColC)from sheet2 returned into (ColH) and (ColI) in sheet1 but everything after that returns nothing! If I ever resolved it I need to roll this formula across...