Search results

just my luck. cant find anyone with office 2010 but should do in the next hour Can I make any changes to the spec from saved import area, you alluded to earlier? I can access that and have repointed it to my own folder

I opened both of them but they have that same error when I go to the import wizard

Good morning I opened up the DB and when I went to import data I couldnt get to the advanced tab as I got the same error messages attached any idea why that is happening? did that happen to you?

Thanks , sorry one more question. How will I actually import the specs? Should I just be able to go straight to wizard

Ok thanks . Will try that first thing when I am in tomorrow as I couldn't bring my pc home with me. Many thanks for your assistance today and will let you know how it goes

Thanks, yes I can see that but the file drive it's pointing is someone who has left now. Is there a way I can open that and bring it to me? Also were you able to get to the import wizard to work ? How could I change the import specs from here ?

HI Gina I posted my DB and was hoping you could ahve a look please when you get a chance? Can you see why I cant get my Advanced area for importing

haha yes, sorry for so many posts please let me know if you ahve any questions about the attachment

Can you see it now? i think it was too big

I have attached my front end. Please if you can have a look and let me know if there is anything I can see I am stumped and really need to have more data brought in via the specs Many thanks

Thanks Gina. sorry didnt see your reply earlier I unchecked the box but dont know what you mean by "compile your DB" where can i do this? after unchecking that box i still couldnt get to the "Adnvanced" bit as it still have the same error message

I will need to remove some data as it is still quite large Ultimately I just want to get to the import wizard so i can charge my import specs. Do you think that me potentially having the controls there might effect that? Other than that how else can I change my import specs?

Apologies, yes I did use it in one form and just checked that it is not there any more. it was only for a small piece so I am confident i didnt use it anywghere else

It was all gone as i had removed the code once I upgraded as was giving me issues then. I checked again and cant find it anywhere

Apologies :) I use to have Ocx control for a calendar but didnt need in 2010 so took it out. otherwise i cant think of anything else other than what you mentioned. is there a way i can check? I do still have a version of the 2007 DB and I can see my import specs there and use the import...

Thanks vbaInet attached are my controls which are in my backend (i split mine into 2 using the DB splitter) The front end has many (about 20 or so) forms but none in the back end

Hi I upgraded from 2007 to 2010 I can see the import specs on the hidden table that Gina mentioned so I think I can make changes to that table if I need to add another table? Would you agree with that? As for the import wizard, the screen just goes blank (i.e. no options to choose other...

Thanks Gina I see the specs in the table now but how I do I make changes to them now? I want to add in a couple fields (to csv file) to the import spec but cant seem to do it anywhere. When I go to import and try get to the advanced setting on the import wizard thats when it says "no object in...

Hi I am new to this forum and need some assistance please I upgraded my database to 2010 and cant find my import specs I use to have. When I try import new data there is a "no object in this control" error message that comes up I upload data daily that somehow picks these specs up (its...