PDA

View Full Version : Modules & VBA

  1. Available Com Ports List
  2. Trapping system errors or Warnings
  3. Hide objects in report based on text in text box.
  4. Filter code in Access 2007
  5. Inserting graphs in powerpoint
  6. Filter SubForm by changing query criteria
  7. Parse Strings
  8. onClick Event - Search Using Dynamic Query
  9. Recordset question
  10. Date/ format function...
  11. Immediate Window
  12. Code Modification
  13. Using access to send multiple emails with lotus notes
  14. Trying to design a 'page' subform module
  15. close works sometimes
  16. Looping a Query changing it as it goes !
  17. Assigning a query result to a variable
  18. Progress bar
  19. Function for extracting portion of file path
  20. DMax Null Error
  21. Search/Match a Field
  22. Createing a Date
  23. Please someone explain...
  24. CurrentDb is nothing!
  25. Can't update a query
  26. Multiple email recipients
  27. API Calls: How to translate from C/C++ to VB
  28. Public variables lose value on subforms
  29. Putting the last record from a table into a variable
  30. macro and pivottable
  31. Trouble Connecting to Excel w ADO
  32. Password deletions
  33. Ambigious Name Help
  34. I'm pretty sure there is a better way...
  35. Handling form loading with Dates and Checkboxes
  36. Refresh Data from Excel Sheet
  37. Calculate the last working day of current month
  38. Type mismatch
  39. Backup 2
  40. Code To Check If An Application Is Running
  41. creating a report from a form
  42. Which line did error occur on?
  43. delete a control
  44. Error When Debugging?
  45. Private Function help
  46. Control IE download dialog?
  47. VBA - Creating Table From Query and Connecting to A Linked Table
  48. Need help with DLookup syntax:
  49. Polling the Google Maps API from VBA - possible?
  50. Old module names
  51. Numbers into lines
  52. Microsoft Outlook Macro - Selecting a different mailbox
  53. Get the name of current control
  54. what am i missing?
  55. For each control on a report
  56. What to do about " signs
  57. Code causing crash
  58. Using variables when refering to controls
  59. Any idea why this returns no records?
  60. Export a table column to a single Word table cell
  61. SendObject and Dlookup error
  62. change values of a report
  63. If Statement using les than and more than
  64. Query and Date Problems
  65. Loop, then add 1 to the value...
  66. First time poster to this board...Looking for some feedback.
  67. Write / Append Recordset From A Table To Textfile
  68. Help Reading in Query and Setting to Variables
  69. Runtime error 3075
  70. copy values
  71. Date field subtract and insert it into a number field
  72. I think VBA is making memory problems and changing query values
  73. Object variable not set...
  74. commas
  75. Programming Enter Key Behavior
  76. setting a time interval timing for backup
  77. save textbox values to a record
  78. why is my Beep function silent?
  79. Insert SQL Statement If a New Record is being Created
  80. Display commas in Word Merge from Acess
  81. tabledefs beginning with "~tmp"
  82. Cannot find object
  83. Format data in excel using a query table from an ODBC connection
  84. Pricing Lists
  85. Import selected Excel cell contents into Access
  86. parentheses in field text stop email from sending
  87. Check table to see if record exists, if not -INSERT
  88. RecordCount
  89. get array of values into textbox
  90. Array Help Requested
  91. List table, field, properties objects in table
  92. Barclays Bank Statements
  93. Loop order
  94. TreeView control
  95. DCount Problem?
  96. Eval Function - Recursive call?? Routine Being Called Multiple Times
  97. Creating New Tables With VB and Populating With Recordsets
  98. Code for resetting a password
  99. Determine if Object Property is Set
  100. Export Report ACCESS vers Excel
  101. VBA on Subforms
  102. SQL statement not time stamping field and closing window
  103. Appending objects to collections
  104. String Value Is Not A Date
  105. vb6 and ADO syntax error
  106. Start at beginning, change Rec, Stop at End
  107. Reading File Attributes using FSO
  108. Return number of records affected by Query
  109. Use a Control's Datasheet Caption or Associated Table Column in VBA
  110. Me alternative Reference in a Public Function
  111. Assign a value from a report calculation to a table field
  112. SQL With String TableName
  113. Rename Exported File?
  114. Show image IF record is a certain value?
  115. Outlook from Acess using DAO
  116. How to Select a Row in a Datasheet
  117. Count current records entered on data input screen.
  118. Run Method not working as expected
  119. Autonumber sequence incorrect
  120. Is there a way to make this work faster?
  121. How to hide a subreport?
  122. Problem with hiding control/setfocus
  123. TransferText Changing Data Type
  124. security problem
  125. Meaningless error messages
  126. Sending E-mail from Access (Full Automation)
  127. Removing "Seconds" From this time code
  128. Run-Time error '3075'
  129. Error 3274 External File Not In Expected Format
  130. VB editor views
  131. Text Entry for Query
  132. Sorting characters within a string
  133. Enquiry about coding explantion
  134. Delay Running a module
  135. Simple copy module
  136. Problem when checking if memo field is empty
  137. Excel for combo box using Access Tables
  138. VB Help
  139. SQL to generate Reports
  140. DoCmd Question
  141. Complex Problem
  142. Complex Problem
  143. Complex Problem
  144. Code to avoid overlapping date entries in Products/Rates tables
  145. ComboBoxes ??
  146. Copy Tables with Relationships?
  147. Syntax for Defined Variables used in DoCmd.RunSQL
  148. Run time Error 3061.
  149. change from 7 to 07
  150. Searching and returing info based on user input
  151. Trouble populating forms from table within db
  152. Example of getting effective dated rows and doing math on some fields??
  153. Add Condition to If ElseIf Statement
  154. VB Conditional Formatting
  155. ComboBox and TextBox combination
  156. Export multiple excel file base on fosUsername()
  157. create a progress bar in VB
  158. Backup
  159. Command button that will auto enter fields into table
  160. Carriage Return in code for email
  161. Insert Image
  162. Help with IF Statement
  163. Powerpoint/Access 2007 Automation Issue
  164. Export to CSV
  165. DoCmd.TransferText + Concatenating Results
  166. Gurus: Conditional Printing
  167. Help with ElseIf function please
  168. Access info to outlook Calendar
  169. Access cant find my control ???
  170. If Than elseif this is to difficult
  171. Converting Macros to Code/Modules
  172. SQL server login from Access
  173. Convert Access Date to Unix Timestamp
  174. can i run a select statement in module?
  175. Type mismatch in report
  176. page up command?
  177. acc 07 runtime question
  178. Convert action to Function
  179. Audit Trail - Allen Browne - prob with insert
  180. Remove Hours, Minutes, Seconds
  181. REPAIR TYPE to return value
  182. retrieving username fails . .
  183. Opening the Database Window
  184. Help with SQL statement in VBA
  185. send contents of textbox to excel
  186. Message When Field Is Null
  187. More Word/TXT fun!
  188. Check a file has records in it
  189. why does Update statement in VBA work incorrectly?
  190. Deleting a row via a cancel button
  191. Formula assistance
  192. Select Case
  193. Hi All...should be an easy one
  194. DCount and "For Each" record help
  195. Code to automatically trigger a command button when a form is opened
  196. How to Square a number?
  197. Getting report to open with where clause
  198. Link to Outlook, small query
  199. compare date in vba
  200. Altering RecordSource property
  201. Frozen Select Case
  202. how to capture the input data for a query of a form and pass it to vba code
  203. Set Warnings Learning Experience
  204. Which Event to Use?
  205. please help me with my password textbox
  206. Limit the input
  207. Delete a record specified in a combo box
  208. Error 3464 - Data type mismatch
  209. emailing with access
  210. Array Loop - Need Help
  211. Query help needed
  212. Electronic Signature insert???
  213. Linking tables via VBA
  214. excel to access worksheets
  215. Run-Time Error 2448
  216. Text Box Message In IF Statement
  217. VBA in query criteria
  218. Average of partial records in a field
  219. basic things
  220. Please Help With DLookup Error
  221. Trouble opening a new instance of Access
  222. Criteria in DCount
  223. Shell Function
  224. Randomizing a Resultset 2
  225. Field Names in SQL
  226. Current Control
  227. Adding a record to subform
  228. Duplicate Control...
  229. VB for Search in Tables
  230. EOF error again (sigh...)
  231. Import Module
  232. Dynamic Fliter in Query or Form
  233. Convert Metric Date
  234. Open excel form access
  235. PasteSpecial
  236. Max number of characters
  237. What is wrong with this code?
  238. time out for connection
  239. VBA code to set taskbar to autohide
  240. Update/Insert Code
  241. Copying cells to Excel as I want them
  242. I need to create a custom aggregate function
  243. What event happens when jumping from form to form?
  244. Best way to empty a variable
  245. Event query
  246. Excel backcolor cell from Access
  247. SQL statement error on certain computers
  248. Dlookup remembering...
  249. Looking in a table
  250. runtime 6, overflow