View Full Version : Modules & VBA



  1. Can I Remove Append query warning via VB code?
  2. Formatting problem when importing from Excel
  3. Referencing a cell in an Access table with VB
  4. tranfer of record(s)
  5. If Statement Maybe
  6. Access-VBA Graph.Chart problem
  7. Run time error 2001
  8. Text/variable formatting?
  9. Handling DLookup's Null Return Value
  10. Code for using a variable generated on loading a form to lookup a table and based on
  11. Query In String Variable
  12. SQL server and value null with a datefield
  13. Output to Excel???
  14. "sums" with dates
  15. Dont show drop down on ComboBox
  16. Access directory and files with another user
  17. display current time
  18. Parsing variable length strings
  19. If Yes, second field is required
  20. Completely New to VB - Convert Macro Problems
  21. use a variable with .value??
  22. Use of calendars
  23. Auto list
  24. Inserting Too Much Text Into A Text Box
  25. Exporting PivotChart to image
  26. Need 'Like' in here? Where does it need to go?
  27. Creating a macro in Excel
  28. hide the taskbar window
  29. Weird Sticky Current Record.
  30. Unique items in Recordset
  31. Email report based on current record.
  32. Table cell location on datasheet as variable in VBA
  33. sendobject attachment on mail body instead
  34. Alternative to Dlookup which returns an Array of values.
  35. OpenForm action was cancelled
  36. Navigating through records event
  37. Using Parameters and problems if Is Null
  38. current time at runtime
  39. Using Access Forms, populating all records in textbox...
  40. Mailmerge help
  41. Help! I am confused with this code. How does it work?
  42. current date and time on save
  43. AfterUpdate trigger
  44. OK Button
  45. IIf Statements with DoCmd
  46. Variation on 'Proper Case' problem.
  47. Dialog Box on Form Close
  48. CDO CID image
  49. Run-time error '2105' - can't go to the specified record
  50. Database Automation help
  51. Reference another Database
  52. Registering MSCOMCTL2.ocx
  53. code for comacting access database which has password protection
  54. Windows Desktop Search - WDS -ifilters - searching PDF text
  55. Code/macro to add a field to a table
  56. Run-time Error -2147217900 (80040e14)
  57. Glitch in my code Please Help
  58. DoCmd.OutputTo acOutputReport
  59. Help with calling my code
  60. Trigger Event from Date Picker
  61. Prevent table deletion
  62. Division by Zero error
  63. help required badly
  64. Sending emails with attachments.
  65. Action query won't run
  66. LIKE in VBA
  67. Run-Time Error 3188
  68. QueryDef the Best?
  69. Best practice for synchronizing related table?
  70. question about a datefield
  71. UPDATE code wont work...
  72. Copying a result
  73. MS Outlook 2003 - extracting mail details using VBA
  74. You cancelled the previous operation (another!)
  75. Changing ribbon on application start.....
  76. Insert field in outlook subject line
  77. Outlook Forms and Access
  78. How do I substitute variable value in this command?
  79. Convert table with only one column into a table with several
  80. transfering an export/import specification from one database to another
  81. Selecting a Report From Dropdown
  82. Complete novice needs help
  83. Opening a Form From Dropdown
  84. help me write vb for combo box
  85. Set rs = db.OpenRecordset - Fails
  86. If statements to control visible parameters
  87. Exclusive Access Error
  88. copy data from one table to another
  89. Update Password
  90. VBA does not break
  91. Docmd.Echo not working
  92. Calendar Control Shrinking!
  93. matching up records from 2 recordsets but not in order
  94. Runtime error on CopyObject
  95. Generating a rank of data on a table via form.
  96. CREATE TABLE with 'Required' set
  97. read/write in VBA
  98. Add User Groups and permissions with Shell in VBA
  99. Instantiate problems??? Help Please
  100. Need to set a Variable to the Name of Database
  101. Access "Guesses" incorrectly when creating table to store Spreadsheet data
  102. Import Data Directly from Word Forms to Access Tables
  103. Loading Text file to Access Database
  104. Testing links
  105. rs.MoveNext increasing recordcount
  106. 07 Runtime & "Execution of this application has stopped due to a run-time error."
  107. Getting RunTime Error 1004 Excel Cannot Access File
  108. Moving between records with a mouse and access 2007
  109. Export to csv A2007
  110. Access 2007: Connecting to DB in VB
  111. Setting a Yes/No field to true
  112. Code to determine field names to send when calling different module?
  113. Mail Merge from Access
  114. Print specific record
  115. Filter off without moving records
  116. removing multiple list items
  117. Import Data Directly from InfoPath Forms to Access Tables
  118. Screen Rez
  119. Filtering a Seperate Form With Text Value
  120. recordset help - filtering??
  121. Copy B/E table from F/E
  122. Display Document Tabs
  123. Move Multiple Fields on a Form
  124. InputBox showing as password (astrix)
  125. Sendmail from Access2007
  126. Building Accumulator in Access
  127. Add Fixed Value to Field
  128. Adding multiple records to plain-text email
  129. Basic question about passing variables
  130. how to auto uncheck controls
  131. Text to columns?
  132. Accessing a query through ADODB
  133. Editing a Linked Table Through Subform
  134. Conditional Formatting With Months
  135. Adding (All) Options to Combo Box crashes Access
  136. ComboBox.Enabled problem
  137. snp to pdf Problem
  138. Automatically Writing SQL From A Table
  139. Adding Code
  140. Testing outlook connection
  141. User selection of code
  142. SetFocus Tab Control Page
  143. VBA code - clash of the date formats;-)
  144. Archiving data
  145. Working Days in a Month NOT between two dates
  146. Compile Error: Invalid Qualifier
  147. How to pass codes in a menubar function
  148. ProperCase
  149. Importing a excel file
  150. Protection
  151. Batch variables to increase efficiency.
  152. Locate Column with Value
  153. Mail Merge from Access with SubReport
  154. Currency on user request
  155. Common Dialog API and My Documents
  156. Closing Access application problem
  157. Comparison to set background color of textbox
  158. after update hassles
  159. Shell Command
  160. Rows/Columns Looping
  161. Problem with text data type
  162. Change of Drives - Module
  163. Code meaning
  164. No Advanced button on CSV Export wizard
  165. Open Form Based on Value From Main Form
  166. Combo Box Limit To List Problem
  167. Switch databases in Access.
  168. How come form saves data without clicking saverecord button?
  169. Using code to set export specs
  170. Query on the Fly
  171. Open Specific Form Based on Criteria
  172. How to get filename from string?
  173. >= Like Text
  174. Parse through a recordset, running an update query as required
  175. Creating a data adder from subform to other subform?
  176. Error Handler in a Function Routine
  177. Variable Button Labels
  178. Help With Array!!
  179. Run-time error '-2147217900(80040e14)' Invalid SQL Statement
  180. BeforeUpdate required fields problem.
  181. Getting 12/30/1899 when inserting a row.
  182. Use VBA to get a Bound Column from list box
  183. Help obtaining values from table to put in array
  184. Public Sub code problem
  185. Rearranging input data from an unbound text box
  186. Changing a table name - how to change code
  187. type mismatch in do loop
  188. SQL Insert Into question
  189. (Noob) Foriegn keys?
  190. get code where date is latest
  191. Kick users, Compact and repair, create backup, auto compact on close?
  192. Adding data from a subform into another subform marking yes/no and autonumber?
  193. TrasnferText acImportDelim?
  194. dCount causing Run Time Error - 3078
  195. qdef with OpenRecordset through SQL Server
  196. Formatting Excel spreadsheet in Access
  197. Create Excel Pivot using Access Table
  198. Importing report results into outlook(Office 2k7)
  199. Find Databases with Linked tables
  200. Calculating data based on a trend
  201. writing a new record to an unrelated table
  202. Master Table
  203. Sending Multiple Emails via VBA & Checkboxs
  204. Query problem
  205. Time validation problem
  206. Using VB to add record with combo box.
  207. Running fraction penny rounding
  208. Retrieving local computer name from within Terminal Services session
  209. Running a Parameter Query within a Loop
  210. customize error message
  211. RegExp MultiLine Replace Not Working
  212. Missing Office 11.dll
  213. Reading a Crosstab query column
  214. Using VBA to enter data into a new record
  215. VBA to validate multiple fields in a form beforeUpdate... I think
  216. If and statement
  217. Access to excel export?
  218. dynamically change powerpoint
  219. Kick off Access Queries From Excel
  220. Programitically entering data from a global variable to a loaded form
  221. Shut off Access Security warning on open
  222. Variable behind Bound Form producing runtime error
  223. dbpix help
  224. Bring Word Window to Front
  225. Network management
  226. Consolidation of Permutation combination code
  227. Removing characters from the beginning of a text field.
  228. UI translucent code problem...
  229. Send msg via command prompt
  230. How to bind more than one client in one computer to winsock server
  231. Importing data from excel to access
  232. export module as .bas file with vba code
  233. Date Validation - On Error - Focus
  234. Lotus Notes
  235. Update syntax error
  236. After Update - just the 1st time?
  237. Search and substitute
  238. Multiple Questions from an Access and VB Newb
  239. Select entire contents of Combo Box
  240. Need Help. VB code to write text file by variables
  241. Access Reports to PDF via vba
  242. link using VB
  243. Treeview doing something like TreeView_Click() except with checks
  244. Strange behavior
  245. Using Outlook Express to send emails from MS Access
  246. Record number not being stored?
  247. Changing SQL in VBA
  248. Removing Filter without changing record
  249. Error Handler problem No2!!!
  250. Linking two Subforms