PDA

View Full Version : Modules & VBA

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