Search results

  1. C

    Import or link an excel file on access db

    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
  2. C

    Name Object - Change color and/or character

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

    Name Object - Change color and/or character

    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!
  4. C

    Excel 2007 Auto Backup

    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!
  5. C

    know-how update

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

    Excel 2007 Auto Backup

    Hi, in this link you'll find the answer. "Autorecover file location"
  7. C

    PowerPivot vs Table Pivot

    Thanks godsspeed. ?l'll give a look!
  8. C

    Is possible to see the queries when macro is running?

    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...
  9. C

    Is possible to see the queries when macro is running?

    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
  10. C

    Is possible to see the queries when macro is running?

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

    PowerPivot vs Table Pivot

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

    Is possible to see the queries when macro is running?

    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...
  13. C

    Database size!!!

    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...
  14. C

    Access database is not open

    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?
  15. C

    How to learn it?

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

    Can I sell Access appplication

    Hi, frankly speaking I think that it's a good idea in order to do extra money but I don't believe that could become your job. Sorry...
  17. C

    Self Employed - How much pay for Liability / Errors and Omissions Insurance

    Hi, i'm a Business Analyst and Web Marketing Consultant and I Work at home. I've been thinking about an insurance but I don't have great risk.. or at least I think.... Great Poll
  18. C

    how can i advertise my locksmith business at low cost

    Hi, in italy there is some site that promotes your services. They earn a percentage- try to see groupondotcom. It's an other idea...
  19. C

    Ideas for side work

    Hi Gary, I can suggest you to start building a website to promote yourself and your service/product. Second step is to promote it by a Web Marketing Plan. In few month you could discover if your service is interesting or not. Your work will be safe because your first goal is promote yourself!
  20. C

    See the query's name that is running on the macro

    Dear All, I have several DB with more than 100 queries and I run these queries with a Macro. When the macro is running, I'd like to see query's name that is running. Is it possibile? Thanks and Regards, Christian
Top Bottom