Recent content by andycapp28

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?