اذهب الي المحتوي
أوفيسنا

alaa aboul-ela

03 عضو مميز
  • Content Count

    286
  • تاريخ الانضمام

  • تاريخ اخر زياره

  • Days Won

    1

alaa aboul-ela last won the day on يونيو 19 2018

alaa aboul-ela had the most liked content!

السمعه بالموقع

70 Excellent

5 متابعين

عن العضو alaa aboul-ela

  • الإسم الفعلي
    العلا سوفت 01096620227

البيانات الشخصية

  • Gender (Ar)
    ذكر
  • Job Title
    financialmanger
  • البلد
    ksa
  • الإهتمامات
    تصميم برمجيات ومواقع انترنت, تحليل نظم معلومات ,

وسائل التواصل

  • Website URL
    http://www.fmalaa.wordpress.com
  • Skype
    alaaaboulela@yahoo.com

اخر الزوار

1,289 زياره للملف الشخصي
  1. اسمحوا لي بالمشاركة النظام المحاسبي الموحد هو النظام المحاسبة للوحدات الحكومية في جمهورية مصر العربية تكون فيه الدفاتر والمستندات باسماء مختلفة نوعا ما وارقام مختلفة عن النظام المتبع في القطاع الخاص وكذلك تكويد الحسابات طبقا للوائح والقوانين المتبعة في النظام الحكومي تفاصيل اكتر ابحث عن او اطلع على المحاسبة القومية او النظام المحاسبي الموجد تحياتي للجميع وبالتوفيق ان شاء الله
  2. الف مليون مبروك .. وتمنياتنا بدوام التوفيق ان شاء الله
  3. السلام عليكم وجزاكم كل خير اسم وفائدة ومكونات كل ملف بترتيب الملفات على الرابط الاول كما اشرت في الملحوظة الرابط التالي ولكن عذرا اسم الملف وفائدة باللغة الانجليزية https://fmalaa.wordpress.com/2014/03/03/أكبر-مكتبة-للأكسيس-والتطبيقات-عليه/ اليكم القائمة بارقام واسماء الملفات No. Title Download All All the Access Archon columns from WOW wowaarch.zip 1. Null to Zero accarch01.zip 2. Date Magic accarch02.zip 3. Mysteries of the Enums accarch03.zip 4. Getting Information from the Registry accarch04.zip 5. Parameter Popups and What Causes Them accarch05.zip 6. Linked Combo Boxes accarch06.zip 7. Add-to Combo Boxes accarch07.zip 8. More Add-to Combo Boxes accarch08.zip 9. Inter-Office Images accarch09.zip 10. Selecting All or Nothing from a Combo Box accarch10.zip 11. Displaying Unrelated Data on a Form accarch11.zip 12. Using the Tag Property to Copy and Restore Values accarch12.zip 13. Conditional Report Formatting accarch13.zip 14. Pick from/Write To Combo Boxes accarch14.zip 15. Early and Late Binding of Variables accarch15.zip 16. Form and Report Types accarch16.zip 17. Printing the Same Information Twice on a Report accarch17.zip 18. Year-end Summary accarch18.zip 19. Fields and Controls — There Is a Difference! accarch19.zip 20. Debug.Print, MsgBox, InputBox accarch20.zip 21. Printing Forms And Why You Shouldn’t accarch21.zip 22. Creating Save Names for Word Documents accarch22.zip 23. Numbering Report Lines accarch23.zip 24. Exporting Access Reports accarch24.zip 25. A Miscellany of Tips accarch25.zip 26. Credit Card Dates accarch26.zip 27. An On/Off Switch for Warning Messages accarch27.zip 28. Conference Report accarch28.zip 29. Digital Certificates accarch29.zip 30. Form and Report Templates accarch30.zip 31. Backing up Database Objects accarch31.zip 32. Working with Forms Four Ways accarch32.zip 33. Odds & Ends accarch33.zip 34. Outlook to Access accarch34.zip 35. Working with Non-Normalized Data accarch35.zip 36. Two Access Add-ins accarch36.zip 37. Custom Database Properties accarch37.zip 38. More on Database Properties accarch38.zip 39. Creating Word Custom Doc Properties accarch39.zip 40. Customizing Menus and Toolbars accarch40.zip 41. Selecting a Sort Field for a Report accarch41.zip 42. Selecting a Filter for a Report accarch42.zip 43. Creating a Denormalized Table for Mail Merge accarch43.zip Access Archon Columns from Woody’s Access Watch No. Title Download 44. Merging to Word from Linked Access Tables accarch44.zip 45. Better Reports I accarch45.zip 46. Better Reports II accarch46.zip 47. Using Listboxes and Combo Boxes to Display Data accarch47.zip 48. Retrieving Data from Listboxes and Combo Boxes accarch48.zip 49. Record Numbers and Autonumbers accarch49.zip 50. Retrieving User Paths and Creating Folders accarch50.zip 51. Duplicating Records accarch51.zip 52. Using Special Controls accarch52.zip 53. TreeView Control Wizard and Subdatasheets accarch53.zip 54. The Three Object Models of Access accarch54.zip 55. Moving Large Quantities of Data from Access to Word accarch55.zip 56. Notes on Importing and Exporting accarch56.zip 57. Forms and Subforms accarch57.zip 58. Reports and Subreports accarch58.zip 59. Working with Strings accarch59.zip 60. Queries I accarch60.zip 61. Queries II accarch61.zip 62. Searching and Finding with Access Data accarch62.zip 63. Working with Linked Tables accarch63.zip 64. Updating Distributed Applications accarch64.zip 65. Working with the Word Object Model accarch65.zip 66. Working with the Excel Object Model accarch66.zip 67. Working with the Outlook Object Model accarch67.zip 68. Creating an Access 97 Distributed Application accarch68.zip 69. Creating an Access 2000 Distributed Application accarch69.zip 70. Troubleshooting Distributed Applications accarch70.zip 71. Paired Single-Select Listboxes accarch71.zip 72. Paired Multi-Select Listboxes accarch72.zip 73. Linked Forms and Tab Controls accarch73.zip 74. Getting A New Agent accarch74.zip 75. Renaming Database Objects accarch75.zip 76. Design Schemes Add-In, Part 1 accarch76.zip 77. Design Schemes Add-In, Part 2 accarch77.zip 78. Adding Data on-the-Fly accarch78.zip 79. Many-to-Many Relationships accarch79.zip 80. Formatting Address Components accarch80.zip 81. Working with Files and Folders accarch81.zip 82. Proper Case for Names accarch82.zip 83. Parsing Name and Address Data — The Utilities accarch83.zip 84. Setting Play Order — Manual Selection accarch84.zip 85. Creating Queries in Code accarch85.zip 86. PivotTables and PivotCharts, Part I accarch86.zip 87. PivotTables and PivotCharts, Part II accarch87.zip 88. Finding Things That Haven’t Happened accarch88.zip 89. Flattening Linked Data accarch89.zip 90. Tricky Queries to Impress Your Boss accarch90.zip 91. Using the Office XP FileDialog Object accarch91.zip 92. Mail Merge Mysteries accarch92.zip 93. Working with Captions accarch93.zip 94. A Round-up of Rounding Methods accarch94.zip 95. If…End If And Its Alternatives accarch95.zip 96. Calculating Working Days accarch96.zip 97. Report Footer Positioning accarch97.zip 98. Useful Access Add-ons, Part 1 (Total Access Analyzer) accarch98.zip 99. Three Ways to Do Anything in Access accarch99.zip 100. Specialized Combo Boxes accarch100.zip 101. More Things You Can Do Three Ways in Access accarch101.zip 102. Storing Outlook Mail Messages in an Access Table accarch102.zip 103. Using a TreeView Control as a Record Selector accarch103.zip 104. Making Variable-Height Bordered Text Boxes on Reports accarch104.zip 105. A Continuous Forms Compendium accarch105.zip 106. Mass EMailings from an Access Table accarch106.zip 107. Working with References accarch107.zip 108. Writing Access Add-ins accarch108.zip 109. Using an Array to Work with Form Data accarch109.zip 110. Printing Index Cards accarch110.zip 111. Working with Lookup Tables accarch111.zip 112. Faxing from Access using WinFax with DDE accarch112.zip 113. Avoiding the Object Model Guardian with the Redemption Library accarch113.zip 114. Creating an Incrementing ID with Date Information accarch114.zip 115. Auto-Saving an Access Database accarch115.zip 116. Displaying Search Results in a Subform accarch116.zip 117. Writing Data to a Text Box accarch117.zip 118. Writing Data to a Text File accarch118.zip 119. Access 2003 Security Warnings accarch119.zip 120. Garry Robinson’s Access Security Book accarch120.zip 121. Time Zone Converter accarch121.zip 122. Using the Office Envelope Object to Avoid Attachment Removal accarch122.zip 123. Saving Email Attachments to an Access Table accarch123.zip 124. Footers Like Word accarch124.zip 125. Denormalizing Linked Data accarch125.zip 126. Using Task Reminders to Send an Email Message accarch126.zip Access Archon Columns from Access Watch No. Title Download 127. Creating Excel Time Sheets from Access Data accarch127.zip 128. Comparing Files in a Folder with Files in a Table accarch128.zip 129. Fancy Filters accarch129.zip 130. Filter and Merge accarch130.zip 131. Using the Printer Object accarch131.zip 132. Counting Selections in Listboxes and Combo Boxes accarch132.zip 133. Copying Records and Linked Records accarch133.zip 134. Useful Access Add-ons, Part 1: Clickbook accarch134.zip 135. Mass Report Emailing accarch135.zip 136. Caps and Mixed Case Conversion accarch136.zip 137. Switching Fields and Records accarch137.zip 138. Playing Audio and Video Files Using the Windows Media Player Control accarch138.zip 139. Using Text Files to Write and Read Data accarch139.zip 140. Printing USPS Bar Codes on Envelopes accarch140.zip 141. Matching Word Document Properties with Access Fields accarch141.zip 142. Copying a Template for Use in Mail Merge accarch142.zip 143. Archiving Data accarch143.zip 144. Automating Access Using Windows Script accarch144.zip 145. Matching Access and Outlook Contacts accarch145.zip 146. Filtering Reports by Month and Year accarch146.zip 147. Confirming Deletion of Linked Records accarch147.zip 148. Retrieving Path Information accarch148.zip 149. Useful Add-ons, Part 2 – The Access Workbench accarch149.zip 150. Listing Table and Query Fields accarch150.zip 151. Updated Database Backup accarch151.zip 152. Storing Data in Database Custom Properties accarch152.zip 153. Creating a Folder for a Word Letter accarch153.zip 154. Getting User Paths and Date Formats for Use in VBA Code accarch154.zip 155. The Extras Add-in for Database Backup and Field Listing accarch155.zip 156. Saving to PDF in Access 2007 accarch156.zip 157. Rich Text in Memo Fields in Access 2007 accarch157.zip 158. Interactive Report Filtering and Sorting in Access 2007 accarch158.zip 159. Multi-Valued Fields in Access 2007 accarch159.zip 160. Simple Filters accarch160.zip 161. Add-to Combo Boxes accarch161.zip 162. Getting Your Add-ins to Work in Vista accarch162.zip 163. Sorting Reports by Date accarch163.zip 164. Displaying More Information about ListBox Items accarch164.zip 165. Recovering from an AutoNumber Disaster accarch165.zip 166. The Extras Plus Add-in accarch166.zip 167. Complex Query Problems and Solutions accarch167.zip 168. Merging Data from Queries and Recordsets to Word accarch168.zip 169. Editing Value Lists in Access 2007 accarch169.zip 170. Mass EMailing of Report Links accarch170.zip 171. Linked Listboxes accarch171.zip 172. Adding and Deleting Listbox Items accarch172.zip 173. Setting the Current Row Back Color accarch173.zip 174. Working with Word Document Properties accarch174.zip 175. Using the UpDown Control on an Access Form accarch175.zip 176. Using the Outlook View Control on an Access Form accarch176.zip 177. Writing Data to a Table from a Form accarch177.zip 178. Entering Data for a Many-to-Many Relationship accarch178.zip 179. Concatenating and Saving Data accarch179.zip 180. Working with a Password-Protected Database accarch180.zip 181. Working with Progress Bars accarch181.zip 182. Custom Navigation Bar accarch182.zip 183. Too Many Controls Problem accarch183.zip 184. Creating a Word Document with Form Fields accarch184.zip 185. Folder Selectors for a Main Menu accarch185.zip 186. Controlling One Database from Another accarch186.zip 187. An Unbound Combo Box for Selecting or Creating Records on a Subform accarch187.zip 188. Working with the New Access 2007 Attachment Field accarch188.zip 189. Working with Colors in Access 2007 accarch189.zip 190. And/Or Filtering and Searching accarch190.zip 191. Emailing Custom PDF Reports in Access 2007 accarch191.zip 192. Creating a Fake Access 2007 Split Form in Access 2003 accarch192.zip 193. Using Google Maps on an Access Form accarch193.zip 194. Currency Formatting on Reports accarch194.zip 195. Finding the Nearest Value accarch195.zip 196. Access 2007 Multi-valued Fields Revisited accarch196.zip 197. Filtering by Multiple Selections accarch197.zip 198. Editing Data in Lookup Tables accarch198.zip 199. Forcing Zeroes in Reports accarch199.zip 200. Exporting Access Data to Excel accarch200.zip 201. Colorizing Selected Datasheet Rows accarch201.zip 202. Concatenating Name and Address Fields accarch202.zip 203. Creating a Log File accarch203.zip 204. Creating Future Emails accarch204.zip 205. Backwards Compatibility Problem between Access 2010 and 2007 accarch205.zip 206. Updated Paired Listboxes accarch206.zip 207. Archiving Linked Tables to Another Database accarch207.zip 208. Dealing with Disabled Databases accarch208.zip 209. An Alternate Method for Archiving to Another Database accarch209.zip 210. Listing Office Properties accarch210.zip 211. Showing and Hiding the Navigation Pane accarch211.zip 212. A New Style Main Menu accarch212.zip 213. Slide Show Reports accarch213.zip 214. Mixing Text and Numbers in a Report Column accarch214.zip 215. The Dotted Square Bug accarch215.zip 216. Working with Access from Outlook accarch216.zip 217. Linking to a Textbox accarch217.zip 218. Selecting Countries for a ComboBox List accarch218.zip 219. Creating Text Files with Word Info accarch219.zip 220. Creating a Set of Records accarch220.zip 221. Crosstab Query Reports accarch221.zip 222. Calendar Form accarch222.zip 223. Select or Filter accarch223.zip 224. Printing Selected Record(s) accarch224.zip 225. Report Filtering with Combo Boxes accarch225.zip
  4. السلام عليكم الملف الملحق به فكره النسخ والقص واللصق عن طريق القائمة المختصرة رايت كليك وللامانة العلمية الملف تم تحميله من احد الموقعين اوفسينا او الفريق العربي تقبلوا تحياتي النسخ والصق والقص.rar
  5. السلام عليكم اهدي اليكم اكبر مكتبة للاكسيس وتطبيقاته وملفات جاهزة للتحميل وافكار مذهلة إضغط هنا الرابط مباشرة ملحوظة الرابط الاول به تفاصيل اكثر واسم وشرح مختصر لمكونات الملفات المضغوطة بالموقع بمعنى يمكنك الوصول للملف عن طريق معرفة الرقم التعريفي للملف من الرابط الاول لتحميله من الرابط الثاني وتقبلوا تحياتي
  6. هناك حل اخر لهذه الاشكالية وهي ربط بين جدول البيانات الخاص بالتلاميذ في الملف الذي تريد واي تعديل او تغيير على جدول البيانات في كلا الملفين ستراه واضحا جليا في الملف الاخر من خلال تصدير لملف اخر واختيار لينك سينشىء لك جدول مماثل في الملف الجديد
  7. السلام عليكم تحياتي للجميع بعد ان قمت بتعديل المسار للملف وتحديد مكانه الملفان يعملان بكفاءة المشكلة ليست في الملفات كما ذكرت المشكلة في تحديد مساره بدقه سواء كان على بارتشن c or d او كان داخل فولدر او منفرداً
  8. واليك صورة توضع الخطوات https://www.up-00.com/7pfso5m4dced الصورة مجرد استرشاد انسخ الكود بتاعك بعد اختيار الملف في استعراض وللعلم انت لست في حاجة للاستيراد او التصدير الفكرة بس انك تعرف مكان او مسار الملف ودي احدى الطرق لمعرفة مسار الملف apend query.rar
  9. السلام عليكم ورحمة الله اسمحوا لي ان اشارككم في الرد على استفسار الاخ العزيز الفكرة كلها موجودة في الكود ده INSERT INTO studen ( code, SPOS, stu_code, first_alaltahak_date, asase_code, stu_name, Parthday, parthplace_code, dyana_code, sex_code, code_alnoa, EPOS, addres, alhay_code, markaz_code, whda_code, karia_code, walealkmrname, saltalkarba_code, waleaalkamraddres, waleaalkamrjob, waleaalkamr_phone, fathername, fatheraddres, fatherjob, username, computer_name, [date], Photo, mather_name, mohaftha_elmelad, karia_elmelad, date_segl_alwaga, kyd_no, stu_tel, elram_elbarede, waleaalkamr_qawme, waleaalkamr_elsabab, fathername_qawme, fathername_elnashat, fathername_elmstawa_taleme, mother_qawme, mother_elmstawa_taleme, motherjob, stu_tarteep, no_ekhwa, waleaalkamr_mobile, mother_mobile, stu_eltamen, waleaalkamr_tel_work, segel_no, [select], HE_CODE, FIRST_NAME, FATHER_NAME, GF_NAME, FAMILY_NAME, COLUMN71, FIRST_NAME_e, FATHER_NAME_e, GF_NAME_e, FAMILY_NAME_e, stu_name_e, date_end, email, user_name, pass, [image], mantka, perm, familyFriend, selaFamily, familyFriendTel, tateem, memobody, Problems, user_name_fa, pass_fa ) IN 'C:\Users\Nada\Desktop\استعلام الحاقي\الحاق.accdb' SELECT studen.code, studen.SPOS, studen.stu_code, studen.first_alaltahak_date, studen.asase_code, studen.stu_name, studen.Parthday, studen.parthplace_code, studen.dyana_code, studen.sex_code, studen.code_alnoa, studen.EPOS, studen.addres, studen.alhay_code, studen.markaz_code, studen.whda_code, studen.karia_code, studen.walealkmrname, studen.saltalkarba_code, studen.waleaalkamraddres, studen.waleaalkamrjob, studen.waleaalkamr_phone, studen.fathername, studen.fatheraddres, studen.fatherjob, studen.username, studen.computer_name, studen.Date, studen.Photo, studen.mather_name, studen.mohaftha_elmelad, studen.karia_elmelad, studen.date_segl_alwaga, studen.kyd_no, studen.stu_tel, studen.elram_elbarede, studen.waleaalkamr_qawme, studen.waleaalkamr_elsabab, studen.fathername_qawme, studen.fathername_elnashat, studen.fathername_elmstawa_taleme, studen.mother_qawme, studen.mother_elmstawa_taleme, studen.motherjob, studen.stu_tarteep, studen.no_ekhwa, studen.waleaalkamr_mobile, studen.mother_mobile, studen.stu_eltamen, studen.waleaalkamr_tel_work, studen.segel_no, studen.[select], studen.HE_CODE, studen.FIRST_NAME, studen.FATHER_NAME, studen.GF_NAME, studen.FAMILY_NAME, studen.COLUMN71, studen.FIRST_NAME_e, studen.FATHER_NAME_e, studen.GF_NAME_e, studen.FAMILY_NAME_e, studen.stu_name_e, studen.date_end, studen.email, studen.user_name, studen.pass, studen.image, studen.mantka, studen.perm, studen.familyFriend, studen.selaFamily, studen.familyFriendTel, studen.tateem, studen.memobody, studen.Problems, studen.user_name_fa, studen.pass_fa FROM studen; ادخل على استعلام الالحاق سواء كان في قاعدة بيانات التلميد او قاعدة الالحاق ودقق النظر في الكود ستجد الحل باذن الله في السطرالسادس ستجد الجملة التالية 'C:\Users\Nada\Desktop\استعلام الحاقي\الحاق.accdb' وهي مسار الملف الذي تريد الحاق بيانات الجدول فيه قم بتغييره الى 'C:\Users\اسم المستخدم او المدير لجهازك \Desktop\اسم قاعدة البيانات .accdb' جهازي مثلا موقع الملف على ال سي / الديسك توب / اسم الملف الحاق 'C:\Users\alaa\Desktop\الحاق.accdb' لو عايز تعرف مكان الملف بتاعك بالظبط فين ادخل على استيراد او تصدير واضغط على لينك وانسخ مسار قاعدة بياناتك وضيفها في الكود مكان سطر 6 وبمجرد اتباع الخطوات ان شاء الله يظبط معاك وبالتوفيق
  10. الافضل هو فصل عمل جدول منفصل للمبيعات ويقابله جدول عملاء وتحصيل نقدية او شيكات وعمل جدول مشتريات ويقابله جدول موردين وسداد نقدية او شيكات ده هيسهل عليك كتير ويمنع تداخل الحسابات وتعقيدها القيم الافتراضية ممكن تنفع في حقول وحقول لا يعني في شرح القيد او بيان السداد ممكن تخلي القيمة الافتراضية لحقل البيان تحصيل دفعة او سداد دفعة في سندي القبض والصرف
×
×
  • اضف...