View Full Version : Modules & VBA



  1. Resetting the RecordSource for a Form
  2. Need help with Access VBA & Recordsets
  3. database window not staying hidden
  4. Padding in a String
  5. Modify Query
  6. How to run code
  7. Visual Indicator
  8. Need help VBA and Access
  9. specifying a record by its unique primary key value
  10. problem with command button
  11. problem moving focus to subform
  12. Filtering records in a subform while the user enters text
  13. Build an "or" clause in VBA and use as criteria in a query
  14. setting default date fields
  15. Help in writing a simple function
  16. html in e-mail
  17. The Best Solution?, Creating Unique ID
  18. probably a simple recordset question
  19. Merge Recordsets with BOOLEAN criteria
  20. IsVisible method
  21. Initialize form controls on record load?
  22. Access 97 to Access 2003
  23. Help with Homework Please
  24. VBA Module- How to format date in a field?
  25. vbYesNo Popup If Field is null or not in list
  26. Need two separate answers from an IF statement
  27. Code too slow - would arrays be better
  28. DCount to search for a record
  29. error message
  30. Commenting Code
  31. Set field to Null instead of zero length string
  32. Copy data between forms
  33. INSERT INTO/SELECT with VB variable
  34. Simple probably my error
  35. Losing global and module level variables
  36. Lifetime of a module level variable
  37. Delete - No Record Selected
  38. Update data when form opens
  39. Outputto problem! Need help!
  40. code req'd to specify numbering system
  41. Multiple Keywords Search
  42. event
  43. Checking if Recordset has data
  44. Login for access
  45. transfertext columnar
  46. What Dlookup won't lookup
  47. Loop freezing database
  48. Archiving A Database
  49. append query question
  50. Change Input Mask code for ISBN Number field
  51. Another Dlookup Question
  52. Is there a way to use Greater then and less then with Like operater?
  53. Print Reports to PDF Programmatically..
  54. Enabled Property HELP!
  55. UPDATE is not accepting numbers with comma as decimal point
  56. Trouble With Dates
  57. Opening a specific switchboard
  58. How can i do this?
  59. Yet another Email Question
  60. Print only first page
  61. calling groups of records
  62. forming one big string from multiple records
  63. Undo Action?
  64. How do you loop through a listbox?
  65. Moving a record from one table to another
  66. check for records in table
  67. If statement for query help
  68. Code for a command button in form
  69. Hello,
  70. Automatic Section Numbering
  71. Populate Textbox with SQL query
  72. Exporting Certain Fields to Certain Cells in Excel
  73. Please help with file copying in VBA!!
  74. show Drop down list in combo box on key press
  75. Changing field order in a table with VBA
  76. Customizing one Function key changes all function keys
  77. Dynamic Currency
  78. File op-en di9alog
  79. Using If, Else and Visible
  80. Input Data From Message Box
  81. Form Question
  82. Syntax for setting control row source property
  83. cycle through control changing properties
  84. Difference between Format and $Format?
  85. Open form without it becoming the focus
  86. Need help querying into text field
  87. Trying to read from a text file
  88. Open Dialog Box And Search
  89. How to Play a Flash Movie in Access.
  90. Navigation Button
  91. How can I get the data in a field in a table from a form?
  92. need help with a search function.
  93. Generating barcodes
  94. Macro/VBA Code Open CSV file, save as xls, run excel macro
  95. Call a function direct from KeyPress event
  96. Runtime Error 2471 Object doesn't contain Automation object
  97. unspecified directory path
  98. Force Access to use Outlook Express and not Outlook
  99. ipconfig obtain IP Address
  100. Rank problem
  101. Still suffering from Delete runtime error 3021
  102. Variable Drive Letter - Import.csv
  103. Turn off Delete Table confirmation box???
  104. Format of a ComboBox
  105. Opening Activex Object
  106. I/O Open with \folder name\ space
  107. Count & Group a recordsource
  108. Output Query results and paste into an excel sheet automatically
  109. help converting DAO to ADO
  110. Unique Field Values
  111. Open Record from table depending field value
  112. Cancel new record after half entering
  113. Can not remove Breakpoint
  114. Populating data in MS Graph Chart by VBA
  115. Use ListBox Rowsource to export .xls
  116. Restricting to 2 decimal places
  117. Find date in recordset
  118. Print a report with populated textboxes using code
  119. Help in creating output file from a table
  120. database window at specific size
  121. importing into Access from a .exp file
  122. 4 text boxes and a funeral
  123. Is there any way to search a record with many conditions?
  124. Invalid use of null error message
  125. Problem using CommonDialogBox and TransferText command
  126. RecordCount doesn't work?
  127. Coding for a log on screen
  128. The Openreport action was canceled error
  129. DMax on a text field - way to treat numbers uniquely from text?
  130. How do I make a condition case insensitive
  131. Comma Generated Problem
  132. Stop the next button creating new record
  133. Export: Error 3190 - "Too Many Fields Defined"
  134. Trying to update a checkbox in excel from access public sub
  135. Insert into tables, with active users & and from forms!! help!
  136. Get imported data into right format
  137. Finding a record with many conditions??? HELP!!
  138. Command for Action query using stored query
  139. User-defined types - initialising?
  140. New computer shuns Functions
  141. Turn off Access Validation Msgbox /Error in insert
  142. Linking text files to BackEnd
  143. help
  144. change values in continuous form's rows
  145. Changes to form recordset not committing to disk
  146. recordset oddity
  147. Date field not containing anything
  148. VBA Question regarding Forms/Table
  149. Create Primary Key on Importing Table
  150. a variable as where condition?
  151. New VBA user needs help with variables
  152. Variables and Queries
  153. Making a Command Button Invisible
  154. Very Complicated!!!!
  155. Code pop-up to "yes"
  156. Page down problem
  157. Import Specification DOES exist... sob...
  158. Create new table & form from button
  159. date and time
  160. DIM dbs as database (missing reference?)
  161. New to vba, need help ordering list in a defined format
  162. Confuse problem about ADO Connection
  163. Reference information...
  164. Dlookup not looking at the date value of field with default set to "Now()"
  165. Currency formatting in VBA
  166. Is the order of a requery important?
  167. Curious label display problem
  168. Requery doesn't, example attached
  169. On Change Event (Maybe?)
  170. Help !!!!!!!!!!!!!!!!
  171. SQL IN VB Problem
  172. Is there a way to shut down the computer with VBA?
  173. get domain name
  174. Insert a table in the body in the E-mail
  175. help suffering badly
  176. email bummer
  177. Opening A HTML File From A Button
  178. Surprise... None of Your Code Works!
  179. Mapping an If...else statement
  180. Emailing through VB script
  181. Table locked by exclusive user problem
  182. Invalid column name
  183. How to show the last modified time of a table?
  184. Form / Subform / Subform calling problem.
  185. struggling newbie...help gurus
  186. Auto Relinking Tables that are Part of a Relationship
  187. Get Argument Values of Macros with VBA
  188. Programatic parameter query based on parameter queries
  189. Is it possible to programmatically set "UNICODE COMPRESSION" using DAO?
  190. Maximum by date
  191. Stored queries
  192. Referencing Form properties with Access 2003 Nightmare
  193. Get current Windows 98 Username
  194. Excel automation, cannot quit Excel instance
  195. Build a recordset with no underlying table
  196. ADO, VBA, and ms access 2003
  197. Arg!
  198. Detect if user is changing new or old record??
  199. Excel data to Access
  200. Module not Found
  201. Using Worksheet functions/properties from Access
  202. Updating Axis tickmark/ticklabel spacing
  203. Can you check my code
  204. Help with undo, please.
  205. Help, Editting record fields in a table
  206. graph 9.0 object lib
  207. help help help
  208. List Box data to Update Table
  209. "You can't go to that specified Record" on third use
  210. Inet Control
  211. Error trapping
  212. RecordSet, MoveLast? Copy? Apply to Shell command?
  213. Streets and Trips
  214. Multiple queries exported into csv files.
  215. Multiple subform link criteria
  216. Changing a Text Value in another form based on a Button Click
  217. 'Public' and 'Private' Prefix, when do I need them?
  218. help help help again
  219. Module function not working.
  220. importing filename and content of file
  221. Range referencing in Excel
  222. Export to txt
  223. Print Dialog Macro
  224. Audit Trail Problem...
  225. "File sharing lock count exceeded"
  226. Which book on VBA?
  227. Problem With Unbound Forms!
  228. Print only certain Page numbers
  229. Question for Audit processes
  230. Sum function with variable range
  231. Module to fetch date for filename
  232. Error 2176 - Standalone vice Network issue
  233. Run Module within another database?
  234. Coding Graphs
  235. DoCmd.TransferText loads blank rows
  236. Open form in data view
  237. Use Variable @ Diff Form
  238. VB/Web Pages
  239. can it be done
  240. Validate numbers to nearest 0.5
  241. Multiple Line Message using SendObject
  242. input
  243. Insert into Date field
  244. Append Export to Text Doc
  245. Conditional Command Button
  246. Code gives an error, can't trace the cause
  247. Need help with VBA code sample
  248. Common Dialog Box (LaunchCD) Options?
  249. HELP PLEASE: importing from text files
  250. Office Object Library differs on NT machine