Recent content by Christian1977

Dear All, I'd like to import an excel file but the data begin from cell "A10", above there is a "privacy text". Is it possibile import or link the excel data in an access table directly from the cell A10? Thanks, Christian

Hi, I think you refered to Custom group. I already Know. Maybe with a VBA code? I try to ask! Thanks

Dear all, I have in my DB a lot of tables, queries and macro and every time I spent too much time by choose the right object. Would be really helpful give a color or change the character on each object. Is it possibile? Thanks a Million!

Hi KatrinaC, I'm glad to help you and others users... sometimes you help me and so on... I give you a little suggestion: if you really appreciate a post or it is really helpful click on the "thanks" button. Have a nice day!

Hi Guys, what and how do you do to keep updated your know-how? Courses, Books, Blogs and so on... and how frequently?

Hi, in this link you'll find the answer. "Autorecover file location" http://grok.lsu.edu/Article.aspx?articleId=3174

Thanks godsspeed. ?l'll give a look!

Hi, first I don't know where put this code, before my queries or after. Second I've try to manage the code and Access gave me this message: "The object you referenced in the Visual Basic procedure as an OLE object isn't an OLE Object". I don't think that this method can help me. Maybe I should...

Sorry, I tried to put it on my DB. I create the VBA code and the unbound textbox control. Then in the Macro I used the command "runCode". VBA is not my best and maybe there is more than one error from my side... Regards, Christian

Hi CJ_London, I tried the code, but doesn't work. If I find the solution, I'll post it. Thanks and Regards, Christian

Dear all, PowerPivot is more Powerful than Table pivot? Yes, NO, Why? Thanks

Dear All, Is possible to see the queries when the macro is running? Es. the Macro contains the queries 1,2,3 e 4 When the macro is running, will be useful see: 1) which query is running after "x" time 2) More useful see the queries run, the query is running and the queue query. (Es.: 1 e 2...

Hi, I'll try these way: 1) Import all DB in microsoft Office 2010 2) Import the 3 tables linked via ODBC in a new DB and then link these three tables on the main DB Really interesting the question about a way to show all the database elements tables, forms, macros, modules etc and list their...

Hi MarkMohan, how much is big this file? If it is some MB I could try and maybe also anyone else.. Have you tried to import tables, queries and so on in other .mdb file? Have you a Mac or Windows?

Hi Preetisoft2, what is your purpose? Internet, books, courses...