PDA

View Full Version : Modules & VBA

  1. adding calendar to form
  2. to find duplicate records from the table and mark them latest based on revision no.
  3. Find out the current user in an Access database
  4. insert a criteria in a queries using code?
  5. Deleting from Memo fields?
  6. Checking to see if multiple versions of db are open
  7. Report generation help needed in VBA
  8. to find duplicate records from the table and mark them latest based on revision no.
  9. Error in find duplicate query, table not found
  10. Linking "chains of Information
  11. Resize multiple images
  12. Find recs,count and take decision
  13. Use "click" to open image window
  14. subforms, textboxes, variables
  15. subforms, textboxes, variables
  16. TransferDatabase acExport
  17. generate Word report with pictures
  18. Connection Strings (ODBC)
  19. Date Function
  20. Check to see if 2 fields are filled in?
  21. How to programatically convert access 2.0 database to access 2000/2003
  22. TransferDatabase command
  23. Plan B
  24. Working with multiple records with strict criteria
  25. Directory Search for String
  26. Directory Search for String
  27. Compare different data tables for similarities
  28. Out of context in watch window
  29. open form when data is added
  30. Stop "File now Available for Editing" box from openning
  31. IsLoaded Error
  32. Syntax for repetitive code
  33. Open objects
  34. 2 databases access update
  35. Data type mismatch when opening a table??
  36. Send pic emails?
  37. Dynamic Formula...
  38. Big problem
  39. Conditional statement assist
  40. Switch between spreadsheets (embedded)
  41. View or query a recordset
  42. Cleaner way to disable multiple controls?
  43. A slightly different Mouse Wheel problem
  44. Changing the current record of a form
  45. Macros to VBA
  46. installation path
  47. Update form connected to Visual FoxPro with ADO
  48. Why????
  49. File path
  50. Extracting Data From A Table Using SQL inside VBA Module
  51. Export Several Queries to Excel sheet and specify which cells
  52. ADOX Column - Default value
  53. Error "Operation must use an updateable query"
  54. Using combo box to open subform
  55. Exporting Menu Bars
  56. Cannot copy all data from a query to a table
  57. Function
  58. Security Question
  59. Select Case Help
  60. Cycling through a table
  61. Open Recordset
  62. adding multiple values to a text box
  63. Is it possible to create a generic module available to a number of databases?
  64. Field Mapping
  65. if statement problem
  66. Preventing anyone from changing data
  67. Sending email from a database
  68. DAvg in Dynamic Crosstab report footer
  69. Need some help with code and SQL
  70. Memo field text into a string
  71. Need to increment a Value in a table.
  72. making subform visible
  73. Remove Record and Control Source
  74. to get a specific type of table in output from other table
  75. Sending Meeting Request to Outlook
  76. Access 2000 VBA and SQL Server Stored Procedure
  77. Update query as SQl problem
  78. Passing variables to a popup Form
  79. Wherecondition being ignored
  80. Setting Recordsource for a form
  81. Writting Data onto Table from Code
  82. Please help building up SQLs, for separating out Year, Quarter and Month data
  83. set method question
  84. min id
  85. Change addresses in report
  86. Import last n records from a text file
  87. Record already exists
  88. reading exif information?
  89. stLinkCriteria to compare 2 fields?..is this possible?
  90. Returning query value in VBA
  91. Need a little help
  92. Reseting autonumber to start again from 1
  93. Personalising Input Mask Error Messages
  94. Can't work out loop logic
  95. Want to export only single row of table - any ideas?
  96. CANCEL like cancel selected value
  97. Highly inefficient code
  98. transformation code, simple, i am just too new to this
  99. Send email using default outlook template
  100. Why does this IF statement fail?
  101. Using ""
  102. using dlookup
  103. strange error message
  104. Next line
  105. VBA LOOP USING A QUERY & TABLE
  106. Help a monkey fix a farly simple if statement
  107. Automatic Mail Tamplate
  108. Date Filter DoCmd.OpenForm Problem
  109. Easy code - dumb question but need help
  110. Print Report Dialog Box...
  111. Custom CopyFile
  112. Change list to combo box
  113. Having trouble creating an MDE file
  114. data from query
  115. form elements and events
  116. Excel code in access
  117. AND - problem with "s
  118. Save As Command Dialog
  119. true false values
  120. Copying records using VBA
  121. Dao
  122. Set Report's sorting and Grouping in VB
  123. Class Modules - Need Help
  124. exporting from access to MySQL
  125. Dowloading/Uploading data from MySQL using secure tunneling (SSL)?
  126. Naming a table usign a variable from input
  127. Build Excel Pivot table in Access (Columns)
  128. can this be done?
  129. just a little VBA Automation to Word
  130. Using 'truncate' in VBA
  131. Moving between recordset tables
  132. using a variable to refer to a form element name
  133. trim
  134. Capitalising first letter
  135. Unticking a box - in bulk
  136. OpenReport and specifying criteria
  137. Running after_update event
  138. dynamic crosstab report - updated to ADO, works, but needs tuning, plz help
  139. Combo not requerying
  140. Weird printer selection
  141. "Object Required" Error
  142. syntax error in date in query expression
  143. Populate unbound form with recordset
  144. Column Count
  145. Percentile Function -1004 - Unable to access worksheet error!
  146. String variable's value containing "s
  147. Routine to identify 67 character string
  148. search form using checkbox
  149. Global error handeling
  150. How to delay
  151. Can't get listbox link to form right
  152. Urgent Help with Error "Too Few Parameters, expected 2"
  153. Finding Printer Port
  154. Problem with closing app
  155. Does anyone know how to do it
  156. Stop my Nag Messages on "archived" records
  157. Tree View Object Model
  158. Problems transferring a database from acsess2000 to access2003
  159. record count help
  160. do not display the email
  161. converting numbers to words
  162. Adding 2 numbers from variant array
  163. How to program a custom paper size?
  164. Recalling snapshot documents
  165. CheckBox.Visible = False
  166. Finding correct path
  167. Code after DoCmd.Close
  168. Memo field "" anomoly
  169. Ranking values per record
  170. Reference Custom Access Function via Excel
  171. "Object required" error
  172. Compile Error
  173. syntax for calling a sub...
  174. Required field in a form
  175. Variable included in Exported Report Name?
  176. public variable
  177. Global variable with value
  178. xml and truncating
  179. Suppress Error Message 2110
  180. Automatic date problem
  181. Transfer query results to a table in another database
  182. Copy value to another field
  183. scada_form
  184. How do I get Link Table Information?
  185. Help with VBA SQL Wildcard
  186. Variant Array Split() Syntax
  187. Need function to calculate startdate + x working days =
  188. Find recs and put them into a memo as string
  189. Passing an array to function
  190. updating multiple records
  191. Me.Recordset.Clone
  192. skipping confirmation msg when adding/deleting rows
  193. A little help?
  194. Creating Public Function
  195. Using Normal Distribution in access VBA
  196. Database Properties issue
  197. Saving the Form output in a text file
  198. Opening a password protected word document
  199. Rank registration events in asc time order
  200. Adding Payments Due for family members in query.
  201. Embedded Excel OLE - need to ZOOM!
  202. if else prob
  203. Using DAvg
  204. Automating Outlook find.
  205. Running Product
  206. Conditionally select data in a SELECT statement
  207. something wrong with this statetement, can
  208. Populating the text box’s that relate to the chosen combo box’s with the sum of a cal
  209. Clearing Default text; MS Word
  210. Making a Listbox display a list from a single field (cell)
  211. Controlling Windows Task Schdeduler from VBA
  212. Help with objWord
  213. Compound Filter
  214. updating records from code
  215. Changing Property depending on another property
  216. error handler and routine
  217. Specail Characters
  218. Using variables as query names
  219. Incrementing variables
  220. Visio Driver
  221. Setting table field default property in VBA
  222. nesting IIF(isNull(exp), "" , (exp) statements
  223. creating an Outlook distribution list from the table
  224. Creating new table in VBA
  225. custom access 2002 sql function not working
  226. Storing a column name as a variable?
  227. hide application
  228. Stored Query
  229. Public Variables and CurrentUser()
  230. Find latest date in a recordset
  231. Stumped on backup code
  232. VB, SELECT queries, Inner Joins, and trouble!
  233. Assigning text values, use Form_Current()?
  234. Enable code
  235. SQL To Copy Data To Holding Table
  236. Date Retrieval
  237. Launch Help File?
  238. 97 to 2003 conversion problems
  239. More Calendar Questions
  240. getting windows explorer to open a folder specified in a field entry
  241. Constant Variables
  242. Use SELECT CASE statement in UPDATE query in VBA
  243. Sending files through Lotus Notes on XP
  244. Error
  245. vba reading from excel
  246. need code to place date on check box or button click
  247. SQL and Like
  248. one value based on a many values
  249. Email Mailmerge to multiple recipients
  250. avoid creating an error table when using DoCmd.TransferText