PDA

View Full Version : Modules & VBA

  1. Closing A Spreadsheet On Another Users Machine
  2. Use of < and >
  3. autonumber field in txt format
  4. Stopping Duplicate Value Entries
  5. Me. and DCount
  6. @@IDENTITY keeps returning 0
  7. update query in SQL
  8. How do you access an open Excel app
  9. Replace a word in a Word Document
  10. VB Script Help!
  11. Help with Word Automation in Access 2003
  12. how to execute a module from a macro?
  13. Open report based on DAO recordset - with parameters
  14. Open form, filter = last record.
  15. Get the "Most recently changed control on a form" and update my textbox with it. How?
  16. How to SUM values using VBA
  17. Incremental number
  18. Read XML data
  19. function to convert pounds and pence to pence
  20. DoCmd.TransferText Runtime error '3001' Invalid argument
  21. linking Outlook calender to Access
  22. Dlookup help?
  23. Suppress System Message
  24. A File for Each Group
  25. Query specific column name from a list box via code
  26. Query with criteria needing "All" through function
  27. Query with criteria needing "All" through function
  28. Import multiple Excel Spreadsheets into one table
  29. Write conflict in subforms! HELP!
  30. Dmax type mismatch error
  31. Extract date to odd number string
  32. Read Only Access (error Trapping)
  33. Help With IF THEN ELSE statment
  34. Help with list boxes
  35. Using the same form as different sub forms on a single main form
  36. autonumber when table is created
  37. automation problem
  38. Comma-delimited list - Query
  39. A strange error...
  40. Calling a SQL query
  41. Advanced Search in Form
  42. ListBox Clear...
  43. Programmatic SQL PARAMETERS...
  44. Add Record command button
  45. Search for a folder
  46. New record - Not "goto new record"
  47. Asynchronous Forms...
  48. CurrentDB and ODBC Direct
  49. Invalid use of NULL
  50. Calling a Function?
  51. Dcount problem 97 to 2k
  52. Change menu language
  53. GoTo Done ??
  54. OpenDatabase, dbRunAsync..
  55. Assigning a string value from parent form
  56. ODBC Connection Strings...
  57. ADODB Parameterized Queries
  58. ADODB.RecordCount
  59. FetchProgress Event...
  60. Iterate thru folder process each file?
  61. Adodb errors...
  62. Help With 15 Minute Issue
  63. Excel Help Please
  64. Copying tables between databases
  65. List Box Search with Query Criteria!??
  66. Column heading height using datasheet view
  67. Error 1004 Application Error
  68. At wits end on Excel memory leak.
  69. DAO vs Static Query..
  70. Excel Function PercentageRank in MS Access
  71. QueryDef Accurate RecordsAffected...
  72. Sending text messages to mobile phones
  73. Record data time in a text box
  74. problem with returning multiple values from a query to a text box!
  75. Problem finding correct record in recordset
  76. SQL statement in Report
  77. Run another application after Access exit
  78. Automatic Field Update based on date
  79. Flickering tab controls
  80. Use VBA to get one record from a table
  81. Delete database before creating a new one
  82. Simple question
  83. VBA Help - to run one function based on another
  84. VBS / Access 2k script question
  85. Please Anyone help with relationship
  86. Not in List
  87. How do you determine the User Name
  88. Change text to dates in access xp
  89. Creating Records
  90. Running select query from vba module
  91. Application.Filesearch does not work in Access 2007, workaround?
  92. difference between opening a query
  93. Table Field Names
  94. populate control.value - should I use SQL or VBA?
  95. ADO vrs DAO
  96. debugger help
  97. open and filter report from vba
  98. $ Functions...
  99. Appending/merging records with VBA?
  100. Put it in DataSheet view
  101. VBA to refresh,reload,requery a report?
  102. Help with modifying VB to print in black only
  103. Retrieve Value From other table
  104. Access populating Excel worksheet Q
  105. A little help for a new user?
  106. Wait for multiple processes.
  107. Comparing records in a Recordset
  108. Challenge...Complex Code/Task!
  109. Emailing PDF attachment
  110. Step Through a Text Document
  111. Compile Error Help
  112. Vba help to do this
  113. Formating and Excel Worksheet
  114. Help, please
  115. refreshing excess sheet from access
  116. Form Validation (Experts Needed)
  117. help:export SELECT statement to MS-Excel
  118. Update record in table
  119. Highlighting the Active Contol in an Option Group
  120. Workspace & Security codes?
  121. OutputTo filter or alternative
  122. How to transfer records from recordset to a table directly
  123. IE open and automatically fill the field
  124. Highlighting
  125. Dynamic SQL statement
  126. Open form with and argument
  127. Validation Rule to accept Alphabetical Characters Module Problem
  128. Still module problem
  129. lock controls
  130. Help with a search form's VBA
  131. MD5 Hashing
  132. Save text field directly to table.
  133. outputto template
  134. rename works/send object ???
  135. sql insert into
  136. Adding/Subtracting from previous/next row
  137. Function Not Found External DB...
  138. Function in Query Criteria
  139. About Automation Object K
  140. System Resources Exceded...
  141. Followhyperlink excel
  142. VB coding problem
  143. Writing data to two places simultaniously
  144. Help with SQL query error
  145. Vba Condtion Error
  146. Conditional Mail Merging
  147. Output via Excel with Name saving issues
  148. Creating a module
  149. Changing variable in e-mail template...
  150. Adding a file / adding an attachment to a record
  151. how to check form open
  152. SELECT COUNT(*) INTO '" & strCounter & "'
  153. access behaviour
  154. Code doesn't work: db.OpenRecordset
  155. Linked table manager
  156. Mail merging codes
  157. Multiple field search
  158. LIke vs InStr()
  159. If statement does not work
  160. Copy some values from one table into another one??
  161. Showa "loading" message while a report/query is still running
  162. email VB code need some help
  163. Assign the IS NOT NULL to a variable
  164. Complicated Function...Very Slow...
  165. Next Line in a Document
  166. Would this be a IFF then Statement?
  167. SQL INSERT INTO....error message
  168. Finding first instance of value in table
  169. Word Mail Merge Bookmark Problem IF Problem
  170. Copying Tables With Custom Name
  171. Deleting Files on exit
  172. Deleting Files on exit
  173. Checking if a File exists
  174. If statement not recognising a combo box
  175. I've been looking for hours...
  176. Comment Box in excel
  177. Double Click on Subform
  178. 424 Object Required
  179. Need help...my noodle is baked
  180. Running Excel macro produces error
  181. File Import Question - Please Help
  182. How can I send an object (table) to certain folder or ftp server directory?
  183. Need quick help on vba date controls..
  184. Ongoing DAO error finding .msi
  185. Record Count - What am I doing Wrong?
  186. FindLast method
  187. Ok, I screwed up a long time ago, now what
  188. multiple word doc styles
  189. Apps and Security Please help,
  190. Cannot bulk update tables with VBA code
  191. VBA variables
  192. DAO & "Like" Operator
  193. Object Variable or With block variable not set
  194. How to send different reports to different Lotus Notes recipient
  195. transferspreadsheet
  196. CSV Import Routene
  197. Pop-up form based on time since a query last opened
  198. Upgrade from 97
  199. Unbound Forms
  200. Default setting
  201. reference a control on a form
  202. File Browser to Import Dbase
  203. SendObject unusual syntax: want to adapt but don't understand it!
  204. SendObject unusual syntax: want to adapt but don't understand it!
  205. Remove lines of code from source code?
  206. Trap Code Interruption?
  207. Seperate a varibale into two variables
  208. last letter -s
  209. Calculating labour time, incl. VAT, excl. VAT and VAT amount
  210. dynamic query
  211. Expression error
  212. date 40-April-2006, must be wrong
  213. how to check if table is empty?
  214. Checking the records in table
  215. Table name Query
  216. Object does not support this property or method
  217. Field does not exist: MsgBodyText in subform as value for SendObject method
  218. Appending Queries
  219. Run Time '13' error Type mismatch Why?? why??
  220. Run Query from a Form Help with field filter
  221. Start/Stop
  222. Problem with importing an excel file!
  223. Module Connecting Access to Outlook Public folder
  224. Set global variable for login
  225. Selecting Records from a List Box
  226. Problem declaring arrays
  227. Modul for checking the values in the table row
  228. Get started whit VBA
  229. Me.OpenArgs question
  230. Delete ALL forms?
  231. strSQL doubt
  232. Passing Parameters
  233. ProperCase function for sentences...
  234. List Box Double Click
  235. Tick box (multiple ticking button)
  236. onClose event for query - does it exist?
  237. VBA and Queries
  238. Format function question
  239. Naming Tables In VB
  240. Table names as an array
  241. Sort within a query
  242. What can prevent focus being set?
  243. Large String value
  244. Forms in DataSheet View
  245. Union Queries and Group by
  246. Create function
  247. "IsIconic" Api call not working in 2000
  248. The seek command is not identifying my autoNumber
  249. Docmd.sendobject / E-mail with form values syntax error
  250. SQL in VBA recordset returns 0 records, in query returns 2