View Full Version : Modules & VBA



  1. Password part of a Form and...
  2. Convert Numbers to Test
  3. Module to tell button even to exit sub?
  4. doCmd.sendObject stops
  5. Function for current drive & directory
  6. Insert File Path
  7. Creating ADOX tables
  8. Need help on my function (dates)
  9. Error 3061: Too Few Parameters. Expected 2
  10. Getting rid of error
  11. Running a select query string.
  12. Who can help me to pick up the last record ...
  13. adding & losing records Help
  14. Error 2001: "You cancelled the previous operation"
  15. how to test blank text boxes
  16. Using the Kill Statement
  17. data from combo
  18. open report
  19. Can you query a record set?
  20. Simple Question
  21. Inefficient way to update table
  22. Paths
  23. running a routine from another form
  24. installing activeX control (MScomct2.ocx)
  25. Option Buttons and Combo Boxes
  26. Very very light security
  27. paragraphing in expressions
  28. Making Previous Form Invisible
  29. code for command buttons on forms
  30. Recordset error
  31. SendKeys - EnDash
  32. Finding, and editing, text in a Word document?
  33. Easy one
  34. Sum column of calculated data on sub form in a module?
  35. hide the close "X" and "max." of Acces
  36. Help
  37. set path in global variable
  38. Brackets in VBA code
  39. File Size
  40. problem with my SQL??
  41. Authenticate password on pressing enterr
  42. Function doesn't run, i'm despair
  43. set Rs problem
  44. Import CSV but splitting the import data into two tables
  45. Invalid Null
  46. help my code won't work!
  47. Password and...
  48. Reading the name of f iles
  49. Something about calculating - I need HELP
  50. Run time error: '3464' and MSAccess
  51. I need another COUNT help
  52. Form-SubForm-Subform-Form-SubForm-Subf.....
  53. Printing fields from Access in VB
  54. VB6 Forum anywhere?
  55. Use for double quotes
  56. Need help with understanding how the modules work in access
  57. Can a form have a section that is password protected
  58. Passing variables from form to form
  59. Set user's cursor
  60. Zero Value
  61. Date function not working
  62. Proper Case question
  63. setting default value of a field in a table (not on a form)
  64. exporting to Password Protected Db
  65. Printing a report from an homemade inputbox
  66. PrevRecVal Question
  67. Quit but don't save
  68. Audit Trails
  69. Code or Macro
  70. Stringing & Concatenation !!!!!
  71. Passing variable back from form (help)
  72. Drawing A Picture
  73. Couple questions about programming excel objects in access
  74. How to call Sub of another Form
  75. Finding out what drives I have
  76. can I change the height/width of the Access Window
  77. I need to draw a line on a form
  78. Error handler
  79. Call?
  80. common dialog box
  81. Save Changes to Report?
  82. Set File Name and set destination folder relative to Database Folder?
  83. DAO recordSet query
  84. Opening form read-only
  85. OpenCurrentDatabase
  86. Cannot Get Replace Function To Work
  87. calculating end dates
  88. Can not get my code to save muti selection
  89. Keycodes
  90. Replacing Foreign Characters and Deleting Duplicates
  91. listing queries in a macro by code
  92. Dynamic query for Report
  93. Field Encryption
  94. Table Field properties in ADOX
  95. Dynamic Query and Report Header
  96. Copy fields data
  97. How to display from one table and insert into another
  98. Not sure what's wrong with my code
  99. VBA or macro
  100. Ask for PW if file does not exist
  101. Stock control
  102. running a queryDef query???
  103. First added record being overwritten by 2nd
  104. import from a file in FTP server
  105. Recordset from interdependent queries
  106. Ranking
  107. TCP connector for access
  108. Disable/Remove "New Record" button when a Form is activated
  109. txt to txt
  110. trying to link access to windows search command
  111. Error trap this code
  112. If else then.... statement help
  113. Execute commands on a Remote connection to Unix box
  114. Help with Treeview
  115. MsgBox Based on Text Box Value
  116. Numbering the Lines of a Vb project...How?
  117. MsgBox Based on Text Box Value - More Help Needed
  118. Validation for Linked fields
  119. Variable not defined?
  120. SubForm Problems
  121. List Box Problem
  122. SQL syntax in VBA
  123. Removing all rows from ListView
  124. Delete table or query only if it exists
  125. Identifying which version of Access is being used
  126. Enter value in control
  127. Please can you help!!! :(
  128. Back again...merging tables
  129. Unexpected break mode
  130. Visibility issues with a button.
  131. For next loop
  132. How to: Dynamc Pivot "IN" statement
  133. Trasfer data from Ascii File
  134. ms access 2000 run-time error 13
  135. Synchronizing Combo Boxes
  136. Does Anyone Know How To Label Or Number Lines Of VB Code
  137. Message box for finding records
  138. Keeping record of a field when changed
  139. Insert/Append Data to a Table
  140. Creating A Help Screen
  141. ActiveX library
  142. using code with a report.
  143. UseOA parameter in TransferSpreadsheet action
  144. how to change number after report run
  145. I can't decipher this visual basic code, can anyone help me!
  146. Make Variable a File Path
  147. Problem with my 1st ever module
  148. Why wont this code work!!
  149. password/login
  150. Clear Fields..
  151. close forms!????
  152. Caption Source....
  153. ConvertCurrencyToEnglish
  154. Display an MS Word File as a Popup Form
  155. count(*) in subform footer returning #error in mainform when no records in subform
  156. Please Help with Code
  157. Please Help with Code
  158. Passing a variable from 1 db to another
  159. Database object won't Dim
  160. Trying to open a recordset - Run-time error '3601'
  161. Export to xls from ADP
  162. Create new database and open report!
  163. Passing null arguments to a function
  164. Nested For Each statements
  165. let user select default for each report
  166. Chopping a url with code
  167. Requery List box?
  168. size cursor in VBA
  169. logos in VBA
  170. TransferDatabase help, PLEASE!!
  171. remove non integers from a string
  172. How to Create dBase4 file from .txt
  173. Using .Range(cells()) instead of Range("XY")
  174. SQL to crosstab lookup
  175. Comparing User Input To Records
  176. need a bit of code figured out
  177. recordset looping problem
  178. Report Detail Section - Incorrect Decimal Places
  179. Error 3061 Too few parameters.
  180. Delete Record based on PK selected from query
  181. storing string
  182. A1=IF(C1="something";B1;0)
  183. linking combobox to subform.
  184. Concatenate field in many side table
  185. Save rst changes and display on form
  186. Can anyone help?
  187. Connecting to Access 2000 from 97
  188. Audit Code
  189. Emailing of Completed Access Data Input Forms
  190. prompt for Attachments
  191. DLookup doesn't pick up string if there is a space in it
  192. Updating MSProject
  193. Simple if, then problem
  194. Assigning value to Public variable?
  195. Table names
  196. Data doesn't satisfy criteria
  197. Outlook automation
  198. Help importing text files with line breaks
  199. Create a scheduler in Access
  200. Calendar on multiple forms
  201. Help saving record
  202. Combo/Textbox control
  203. Query result into a variable
  204. Return the name of a month????
  205. Excel import problem and date conversions
  206. Currupt: The VB for Applications Project
  207. Simple SQL Problem
  208. Order by a subform field
  209. AfterUpdate - If function on calculated txtbox on form
  210. Displaying information as code is processing
  211. Can not find project or library
  212. Network Security
  213. Closing A Form - VERY BASIC!!!
  214. Link Table Path
  215. Too Few Parameters error
  216. Disable close window button on datasheet
  217. autonumber for Billing Paper
  218. Using OR in an IIF statement
  219. functions
  220. Recordset from query based on combobox
  221. Checkdigit
  222. VBA to automate pdf process (from html)
  223. How many decimal places
  224. import spec isn't working right
  225. Copy Record
  226. Modules??
  227. code help !!!
  228. Hyperlink Subaddress
  229. Sendobject
  230. GotoRecord after delete
  231. New Error Message
  232. Synchronizing Pop Up Form with main form
  233. Print job by date
  234. Compile Error
  235. Report Preview - Fit
  236. VBA & SQL error
  237. Forms popup dependant on user specified dates
  238. VB Books
  239. dynamically update the fields
  240. Open Form - urgent
  241. create setup for a MSdb Access
  242. Which control has focus?
  243. Anybody use Rich TextBox Controls?
  244. Sql??
  245. No Value error
  246. Cancelling tab action
  247. basic question! or ?
  248. Assign with SQL Statement
  249. Is this possible?
  250. Print # Statement