View Full Version : Modules & VBA



  1. Record protection - user security access
  2. date converion
  3. VB - Access - Mysql
  4. Assingin a set number of records
  5. Needing Help
  6. Saveas
  7. A neater way to do the following, Looping through controls
  8. Didn't anyone need to set report orientation in code before Access 2003 came along?
  9. Random Number Trouble
  10. Help witha modual/Sql in Access xp
  11. SQL Statement
  12. Loading form fields from table
  13. CSV file from HELL
  14. Sql
  15. Transfering Data 'tween listboxes
  16. Simple DB open
  17. Sql Statement creating a query
  18. Save Sum field to Table
  19. remove application scrollbar
  20. Programatically re-write sql statement to row source
  21. Access95 export error forms/reports
  22. Null Help please!!!
  23. Self-building database
  24. OLE for Internet explorer.
  25. Not in List Error
  26. Zip Button
  27. Define limits for integer
  28. Auto Increment Code
  29. Check Query Status
  30. Expressions still on holiday
  31. Save Problem
  32. Automatic mail by CDO objects
  33. Trying to update the records in a continuous form
  34. DCount criteria issue
  35. should I use DSum in an update query for this problem? If so, how?
  36. RunSQL INSERT
  37. for beginners: cascading Combo boxes
  38. Use VB to CREATE a report :: Problem
  39. Import from one table to another
  40. Sending Data to printer
  41. populating bounded textbox
  42. Export Table with date in filename
  43. Query and VBA
  44. Modify search code
  45. Update Table With Query Value Using VBA
  46. Attempting to use SQL in a module
  47. Access output to Word template fields
  48. Counting Records in a Table
  49. Checkbox Code question
  50. Filtering Form Data based on a Combo Box
  51. Suppressing Insert/Update Warning
  52. update info from an unbound textbox into a register
  53. Automate Find/Replace for part of field
  54. Change field type from a Make Table Query
  55. Simple: Check if Query is Hidden *need help
  56. passing a variable from one module to another
  57. Reporting number of records ADDED and UPDATED
  58. Importing text files
  59. DLL is possible with VBA ?
  60. How to specify unformatted when sending text files using sendobject
  61. Populating a primary key with 2 fields
  62. Sending email from Access
  63. Function question
  64. Activate control in subform
  65. Goofy Breakpoint Happenings!
  66. Add column/field to linked database?
  67. Cell Selection in Subform
  68. OutputTo Excel not working in MDE version
  69. Open a form to a specific record
  70. Adding Branches to treeView
  71. Changing Forms In TreeView
  72. Cycling through a recordset
  73. Exporting dates to Outlook Calendar
  74. Basic If Function
  75. Global error message function?
  76. File System Object - Rename Folders
  77. Node Creation
  78. Data Access Page - Field won't update
  79. Internet Data Transfer Library help
  80. NTH Select
  81. no current record found for new version
  82. Select Folder Directory Instead Of File in OpenBrowser
  83. Run a function
  84. Code Failure on Split Database
  85. DAO Help please!
  86. Import a dbf file
  87. using data from forms in the creteria of queries
  88. Label Backcolor
  89. open form find specific data
  90. Import data from Pivot table in Excel?
  91. pseudo php/java code to vba translation help
  92. Enter data using Form and VBA Code
  93. DOA or ADO nowdays ??!!!
  94. DOA or ADO nowdays ??!!!
  95. Programatically change datatype?
  96. Outputing queries with parameters in VBA
  97. import data into new db without access
  98. Reading files names and seving them into a table
  99. Getting data from a form into a table
  100. Why doesn't this work?
  101. Please help me with this problem.
  102. "Query" problem
  103. Counting Records in a Pass Thru Query
  104. Remove Spaces
  105. Test SQL Connection before running
  106. Puzzling code -
  107. Any help appeciated!
  108. Send email using addresses in a table.
  109. Record Counts of Queries
  110. MUlti-user custom counter
  111. AfterUpdate Problem
  112. Listbox and checkbox
  113. Running a function once a month
  114. refresh a subform
  115. Listbox select output to Excel
  116. Error: Subscript out of range
  117. Public variables
  118. Set file properties
  119. Percentile code - Module Collection Error
  120. Help with For Next statement
  121. Search for a value in a table from a form
  122. Possible? Use VBA & Copy / Clear contents of VBA Immediate Window to .txt file
  123. Import then Append?
  124. Automatically generating weekly reports behind the scenes
  125. DMax/DCount not incrementing
  126. Entering database password using code
  127. download upload files
  128. Help with VB syntax
  129. Saving the contents of a control in a variable
  130. Retriving Data from a table based pn a partial value...HELP
  131. Help with date procedure
  132. Choosing ADO or DAO for Working with Access Databases
  133. application resize event
  134. Send Email
  135. Help with MsgBox and If Then Statement
  136. Refering to subform in VBA from subform.
  137. Have I ask this before?
  138. Query Table From A Form
  139. Underlining in VBA
  140. Launching a txt file in VBA
  141. Code stopped working
  142. Help With TransferSpreadsheet
  143. Me![anything] or Me.anything, what's the diference
  144. Automating Outlook Task
  145. Printing to Adobe Printer
  146. Files and List Items
  147. database not working on other computers
  148. swap values
  149. Counting Records in a Query
  150. Too few Parameter
  151. Check if Value Exists
  152. change regional language
  153. Problems with 2000 DB in 2003
  154. Totally Confused, OnNotInList, DAO or ADO
  155. Loop thru all controls on a form/report and delete them
  156. On Error
  157. insert code into an object using code !
  158. Dealing with 'non-existent' data
  159. String 2112-E interpreted as 2112 minus E
  160. How to save a change??
  161. VB MSGBOX Help required
  162. Open "Windows Explorer" from VBA?
  163. TransferDatabase code needed
  164. Function return Collection
  165. Problem opening a recordset ...
  166. «DoCmd.SendObject acSendReport» sends too many attached files...
  167. «DoCmd.SendObject acSendReport» sends too many attached files...
  168. Code is giving incorrect answer
  169. What's my malfunction? change recordsource
  170. Combo Boxes as filters
  171. combo box dependant on data from another combo box
  172. Select record from subform
  173. Duplicate a record?
  174. Web browser properties/methods
  175. Import Delimited HIPAA 997 X12
  176. Change date of MS calendar control 11.0 in VBA
  177. Speed - changing between forms
  178. Sum field dependent on its control source
  179. Data Member Not Found
  180. Problem exporting a query using Transfertext method
  181. Get Selected Record In Activedatasheet
  182. Collection
  183. Problem with Textbox lock/enable
  184. Sending email from within Access2002
  185. Oh dear! E-mail AGAIN!
  186. Export Table to New Database
  187. Code for opening powerpoint file
  188. Writing current user / comp name to field
  189. Looping through Tables
  190. Need help with VBScripting in a DAP
  191. Dispaly data from a linked table.
  192. every year need code
  193. help files whys it so hard to open one!
  194. Link tables to SQL via odbc using VB
  195. open report when booting up pc
  196. DoCmd.Save Question
  197. Graph1.HasTitle alternating
  198. Need help converting Outllook Data..
  199. Page Set-up
  200. Delete Query problem
  201. Recordset question
  202. Learning VB.NET
  203. Number of users
  204. Error Handling
  205. Please help!
  206. Error 3075
  207. Beginner DAO question
  208. Record Import Message
  209. Pass a wildcard from a form control into a SUM query
  210. Macro/ VB Help - Refreshing data
  211. recordset.seek with compound field lookup issue
  212. Open ADODB.Connection to already open Database
  213. Trouble with Outlook address book
  214. Accessing Outlook Address Book Groups
  215. Number of seasons between 2 dates
  216. Limit decimal places in Excel automation
  217. Obtain first two words in memo field
  218. Create new Access Database in code?
  219. Password protected Linked table
  220. Open Import dialog via VBA...
  221. Run-Time Error 2465 - and personnal settings
  222. Public Members of Object Models??
  223. Printing on POS printer STAR SP200
  224. Rounding Up Question
  225. What's wrong with this loop statement!?
  226. Move current record in a continuous form
  227. Beginner Help
  228. Need a little help.
  229. what am i doing wrong here?
  230. activate button('s sub routine) from other form
  231. jet engine substitutes "#" instead of "." ???
  232. Problems with VB... can someone please help??
  233. Note Pad
  234. Memorise ODBS Username and Password in Access Database
  235. Create table, error '13' Type mismatch
  236. Edit/add new record
  237. Module/VBA Question
  238. Look up values of Excel in Access table
  239. Search a folder?
  240. GroupLevel error
  241. Help with Run Time Error
  242. packaging wizard missing
  243. another problem with rs
  244. Problem with VB code printing an extra page
  245. how to get the emailadres of the sender using VBA
  246. parameter crosstab query in VBA
  247. Combo boxes and search
  248. Can someone tell me how to....
  249. Create database using ADO
  250. saving records to a temp table??