PDA

View Full Version : Modules & VBA

  1. opening excel after transferSpreadsheet
  2. Problem using EVAL function
  3. Truncated dynamic SQL using ADO/DAO
  4. Windows XP
  5. Concatenating strings for recordsource
  6. Auto update option group
  7. Count Input Box Word
  8. creating reports from filtered lists
  9. Variables... Complex ones!
  10. Apply Filter when Form Loads
  11. Run code refering table
  12. DDEPoke
  13. VBA Newbie, please help!
  14. create a field in code and assign it a value
  15. Search Form Code Help
  16. Docmd.RunSQL problem
  17. Select Query using VBA
  18. Import and replace table
  19. Do comments take their toll
  20. stuck in a loop
  21. Change View to Stored Procedure
  22. Updating Recordset after new record
  23. DAO locating a specific record w/in recordset
  24. Hyphens in the Social Security Field
  25. OR rather than AND
  26. Conditional Boolean
  27. Yikes, this is taking an age...
  28. Trapping in code when a report is printed
  29. Why won't my code work
  30. ADODB Recordset
  31. Help strategy
  32. A little help with string manipulation please.
  33. A question about ADO Recordsets
  34. SendObject and Send To Problems...
  35. Very simple VBA question - Move to field
  36. Users with no permissions and save record
  37. Setting Yes/No values in Code
  38. database security
  39. DLookup w/ rs as domain
  40. temporary screen size
  41. Creating new table with user specified name
  42. Selecting Printers
  43. Arrays
  44. OpenRecordset Error
  45. Access 97 export to Excel 2000 problem
  46. dates in combobox
  47. Using Msgbox
  48. Using VBA to get data from a table
  49. VBA Newbie...Help with ADODB.Recordset
  50. Updating records in Listbox
  51. Treeview problem
  52. Message box with API
  53. Call a module from Macro
  54. Opeining Excel from Access
  55. E-mail Report Problem
  56. Opening/Closing Forms using Code
  57. FileSystemObject
  58. Simple Sub Procedure for Form operations
  59. Grab Text From Messenger Service....
  60. Creating multiple records
  61. Sending automated mail with voting buttons
  62. Does anyone know how to create a temporary table??
  63. Copy record at once
  64. problems calling a sub routine "variable not defined" etc
  65. Sending file automatically without headers?
  66. How Can I Change The Print Device For A Report Using Code
  67. Dlookup
  68. Loop Not Looping
  69. Getting rid of the "do you want to append" message
  70. SetWarnings Method
  71. Testing Bookmark for not found
  72. Excel Adding Alternate Rows
  73. Dlookup
  74. DEL key in listbox
  75. INSERT INTO not inserting
  76. Running Macro In Another Database
  77. VBA Newbie...Discarding Form Changes
  78. Select a field from a Query with VB Code
  79. passing a form as a parameter to a module
  80. HighLight Multi Word In One String,,,,,
  81. problem with '.selected' property
  82. Import Flat File
  83. FindFirst...
  84. Inserting and removing records
  85. path/file access error
  86. This code kills access. Why?
  87. Using Strings variable to call form controls
  88. Automated form
  89. Voting Responses
  90. manipulating PowerPoint
  91. Network Security Permissions
  92. DAO .Close vs. set rs = nothing
  93. control AfterUpdate Method
  94. Trying to trigger "Append" error
  95. Please help with code???
  96. Module Error
  97. code resets form to first record
  98. function key
  99. Query Parameter
  100. Query Parameter
  101. change datatype programmatically
  102. Please Help If U Can In SelLength,,,
  103. Variable Name in Recordset DIM
  104. arranging 4 bytes into Long data type
  105. Help!!!! Multiuser Database
  106. Tab strips on a form
  107. How to import excel file into Access table?
  108. Order By
  109. Sorting Data By Date
  110. Creating AutoNumber field using VB code
  111. Help
  112. Default items to be added
  113. making a string form various things
  114. VBA Code (New to VBA)
  115. Combobox HELP!!!!!!!!
  116. Appending Data to a Table
  117. Searching string for value of another field
  118. recordset clone!
  119. V.urgent Help Please
  120. Code to modify query
  121. Securing a database using VBA
  122. Access Menus
  123. SQL Statement - Requery
  124. changing text box value
  125. Automated Delete File
  126. Passing 'FormReference' arguments.
  127. Writing recordset/Array value to report
  128. excel problem
  129. Vis. Basic Code Needed
  130. Altering table headings ??
  131. Critera Limitations
  132. Optimization question
  133. DAO with Access XP
  134. passing a database password to 'opendatabase' statement
  135. Using VBA to change the font color of a text box
  136. using variable name in lookup
  137. Can anyone help with Word VBA
  138. Rename label
  139. Need code to link to different drives
  140. tooltips and popups on vba entry
  141. Matchig Records Using VBA (3rd Revision)
  142. Selecting a ComboBox row by Index
  143. Same Public Procedure for Forms AND SubForms
  144. coding a dsn
  145. Splitting a name in vba
  146. Silly DAO question...
  147. need seq_# to increase by 1 every 200 records
  148. Set Timer When an action is to occur.
  149. Import .lis files as .txt
  150. Error Trapping Problems
  151. Kill Datase Error
  152. Switchboard Code
  153. BeforeUpdate Cancel event
  154. Filter by Form Code
  155. Run queries with VBA
  156. Copy Table Data 2 another Table
  157. Query a remote access DB and store results
  158. Make a linked table uneditable
  159. Using result of max query in Access VB
  160. Can't get calendar control to work!
  161. IN string syntax in Crosstab query
  162. importing test file
  163. Creating Charts in Word using a Module written in MS Access
  164. Examine directory & use results in label
  165. Access 97 Code that will not work in 2000
  166. Problem in Query / Module
  167. Mail Merge with Template Choice
  168. Grow/Shrink
  169. Want to generate a run-time error.
  170. Compiling A2k DB
  171. Escapism
  172. Keep form current
  173. Matching part of a variable with a list of codes
  174. Filtering A Query By Start And End Date
  175. Column headers in a crosstab query.
  176. dcount + intr
  177. Dim DB Problem
  178. Invalid use of null
  179. excel problem
  180. emails
  181. Filtering Code
  182. Really Stuck Here!!!!
  183. rs.update
  184. Trapping Null Value in Primary Key Field
  185. Like Operator
  186. Array/combo box problem, Please Help
  187. BuildCriteria and Filter Property Question
  188. Lotus notes "Who" property? --Urgent
  189. line input
  190. Using Recordset and saving changes
  191. URGENT....SaveMessageOnSend property of lotus notes
  192. Controlling the ESC key
  193. MsgBox code error...
  194. Recordset of a query
  195. SourceObject Question
  196. Custom Doodat for Desktop
  197. Send Email in HTML Format
  198. Function to check if a table exists?
  199. Urgent Help!!
  200. Append several tables with 1 record
  201. Is this a case for an Array?
  202. ActiveX Clock Control
  203. ActiveX component can't create object w/Lotus Notes
  204. Looping IN recordset and Displaying Resulst
  205. Recordser type mismatch
  206. Too few arguments?
  207. Addnew Record
  208. help with VBA in Access 2000
  209. Multi Select Code
  210. table location?
  211. Out of stack space???
  212. don't save report!!
  213. Type mismatch probs when deleting multiple records
  214. HELP!!! Compare input file
  215. Printer banner page
  216. Passing Value from form into VBA Argument
  217. File list to text
  218. Call Function Question
  219. filter on a form
  220. Notes email w/attachment
  221. database directory
  222. Programatically open bitmap and paste
  223. permissions problem using bypass key enable function
  224. Counting the number of tables
  225. OutputTo custom filename run time error 3011
  226. Length of SQL script.......
  227. Retreive the Modified Date
  228. Where to put oncurrent code
  229. Need help with code on Access 2002
  230. Data from forms to table - back to basics
  231. how does help work?
  232. Password for admin and user
  233. Creating a File.exe
  234. Sending Automating Sending Query Results as Attachments Using Redemption DLL
  235. VBA querie
  236. Code > Module / Class?
  237. Suggestions needed..
  238. Appy a Filter when opening a table from a Form
  239. MsgBox msg on multiple lines.. How?
  240. looping listboxes
  241. Sub folder list to text
  242. How to define buttons from a vbYesNoCancel MsgBox?
  243. Mail Merge to chosen template?
  244. BOF Problem
  245. Using a specific Lotus Email Account
  246. A quicker way yo delete thousands of records?
  247. Using a wildcard in VB
  248. referring to a stored querydef that requires a parameter
  249. quotes and apostrophes in coded query
  250. The last laugh