View Full Version : Modules & VBA



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