Search results

Were are do you want to use the query as in which form?

Have you tried to select the hole colunm then right clich and properties. Alastair

Your Database will not let me change any thing could you send the master database, because it is a replica

I will have a look now and let you know

Can you post your database and i will have a look for you.

Silly question is there data in your tables?

You could try if you are stuck Link: http://uk.ask.com/web?qsrc=2004&q=Ms%20Access%20Examples Alastair

If you relink your tables this should do the trick. Alastair

Have you changed the name of your main form or maybe the textbox it is linked to, If you would like post your database and i will have a look for you. Alastair

I have got your backup database working, i have add my name to the parts i have changed. Alastair

The item "filesystemobject" is not found and as a result errors, either there is a file reference missing or not selected. I have looked though the object browsers and got not find any reference to "filesystemobject". I take it this may of been taken from an old access version. I will have a...

Emma, You say more then six is this more then six peoples sure names?

Going any were nice Brian

You could try Like "*" & [Your Textbox Name] in a query, you will need to know the name of your input form, should look something like:- Like "*" & [forms].[MainForm].[Subform].[Combo Box] Let me know if this works for you. Alastair

Thats a good idea Monkey,i always forget that you can capture a screen, silly me. Alastair

I take it you must be using sub forms this normally were this kind of problem exists. You will need to reduce the size of your subforms and then the size of your main form. Alastair

Thanks For your Help on this one, i have sorted it all out. Alastair

Hello All, I thought i would ask this question an how to import data from excel into access. I am using sage to invoice clients and i can output this in to excel format then i would like the best and simplest way to pull the data though into access. The data file has column headings at the...

You could use a sub report Alastair

Thanks Peter will try and see if it all goes pete tong or not by fingers are crossed. Crossing fingers makes it hard to type Alastair