View Full Version : Modules & VBA



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