Recent content by antonyel

  1. A

    Append many table from ACCESS to SQL server Table

    Hi Sir, now i understand with your idea, lets me follow the steps and try i will update later on many thanks
  2. A

    Append many table from ACCESS to SQL server Table

    Hi Sir, I do not understand the meaning of your explanation or maybe I'm still too new in the database thanks
  3. A

    Append many table from ACCESS to SQL server Table

    Hi Sir, from your explaination i got your idea and i have tried before, the steps that i did is 1. import by wizard all the table that i need from access 2. i create the ODBC Connection to sql server 3. from access db i did connection from external db to all my table in sql server. the...
  4. A

    Append many table from ACCESS to SQL server Table

    HI Friends, :) could you help me some advice how to simple way to append multiple access table (20 table simultanouly) to SQL Server Table sample on attachment everything is the same format header and name in access and sql server are the same. my idea is i have around 20 table from access...
  5. A

    Access FORM

    hi sir.. thank you for the input, you are really right. Brs DN
  6. A

    Access FORM

    hi Jhb, after i did remove the code, now when i run the tools looks perfect thank you very much.. now everything was perfect to me.. thanks to everyone in this forum
  7. A

    Access FORM

    Hi arnelgp is working well cool, like proberb said There are many ways to go to Rome :) thanks for the Idea.. and shared the code.
  8. A

    Access FORM

    Hi.. JHB thanks for the answer, sorry I forgot to tell you how to use the tools. first we have to change the date format in laptop to yy-mmm-dd hh, after that please follow the picture that I attached 1. select working set name 2. select date before and after 3. generate because I just...
  9. A

    Access FORM

    HI Master, last year I had learned from this forum and shared the tools that really help me to generate the report and it was really helping me a lot. really thank you especially for JHB that shared the code for me and helping me to develop the tools that I used today. after almost 1 year used...
  10. A

    How to Export Chart from FORM to PPT

    HI Mate, I have tried to make a Picture Border (line Black/Blue), and put the code wich is highligh RED but still error could anybody help how to make the border line. Many Thanks SlideNo = 1 Set PowerPoint = CreateObject("PowerPoint.Application") PowerPoint.Visible = True...
  11. A

    How to Export Chart from FORM to PPT

    I see Got it.. thanks Mate
  12. A

    How to Export Chart from FORM to PPT

    Hi Mate, could you help explained me what is the meaning for this Code what is ControlType = 113 If Me.Controls(x).ControlType = 113 Then '"MSGraph.Chart" Many Thanks
  13. A

    How to Export Chart from FORM to PPT

    Hi Mate.... really cool, awesome... and when i change the code with "PowerPoint.ActiveWindow.View.PasteSpecial ppPasteEnhancedMetafile" it will copy as pic, so i have 2 options right now as a Data and Clickable and as a Pic really really cools mate.. thanks very much.. you ar genius the...
  14. A

    How to Export Chart from FORM to PPT

    Hi Mate, I do not know what to be grateful, very pleased to be turned out to be 100% thank you very much for your help. I would make it more presentable again and I will share. Once again, thank you
  15. A

    How to Export Chart from FORM to PPT

    Hi bro, Do you have any idea how is the VBA Code if my plan just export the chart from Access FORM to directory Drive "C" or "D" as aPicture or any Sample code.
Top Bottom