View Full Version : Modules & VBA



  1. AutoFill SignIn&Passwords from Access records to IE
  2. Listbox - ItemsSelected
  3. Dlookup error...Aghhhh
  4. Dynamically set me
  5. Commanbar combo boxes
  6. Send Object Question (EASY)
  7. How to import several rows of TXT data file?
  8. Validation Rule
  9. docmd.sendobject not modal
  10. Mail Merge Multiple records into Existing Document
  11. Passing a variable to a query
  12. Help Please - Problem with Function that opens DB
  13. Getting values from text boxes
  14. Minimize Form
  15. VB Code
  16. How to manage the formatting of a Report programically in VBA
  17. I need Help with Case Statement
  18. Passing a password from one database to another
  19. Crosstab query and If Then statement?
  20. Problem passing data
  21. Strange bug with creating recordset
  22. CTRL + F Mods
  23. Combo populated from value list (browse directory) -- Only want to sort list.
  24. Query or Code ??
  25. OnLoad -versus- OnOpen
  26. Exiting a loop while printing
  27. Deleting files
  28. Can this be made into a table?
  29. data not being truncated
  30. Hotmail
  31. Reload a subform OnChange
  32. Selecting a Text Box based on a Variable
  33. Cleaning Data
  34. Explorer box popup
  35. Message box for no data
  36. Altering linked tables
  37. Start a Folder in a Specific directory each time a new Enquiry is started
  38. commandbars - window cascade
  39. Avoiding duplicate records
  40. problem importing module
  41. Creating a text box using a command button
  42. Manipulating table data using VBA
  43. "Load" a Form
  44. lots of "and"s in if statement
  45. VBA code to append data
  46. Checking for date
  47. game golds here in the game
  48. Syntax Error in INSERT INTO Statement when using Dbs.Execute
  49. Using Query Output in VBA
  50. Using Query Output in VBA
  51. need help in VB Code
  52. Search on single word within a string
  53. exporting to an excel sheet
  54. Recordsets, referencing tables and correlating data
  55. multiplying a global variable
  56. Update column from select
  57. Taking information form a label when clicked
  58. requering a subform on an instance of the parent form
  59. Date Time Picker (No Object found in this Control)
  60. Type Mismatch if not DAO
  61. Access Help for AcCommands?
  62. saving a value for reference, open a form by using HWND
  63. Query must have at least one destination field- running pass through query
  64. SQL Server Functions & Access ADPs
  65. export form data to xml using a command button!
  66. Need help with enabling a sub form
  67. want to automate importing files from dbf file
  68. Import Multiple Excel Files into Access 2003
  69. Exporting Access table to excel table
  70. TransferText seems to modify the data
  71. Is there a faster and better way?
  72. Omnis DSN-less connection string
  73. find out form index number with vba
  74. requery a form by using window handle (hwnd) of that form
  75. Filling data from a list box to a text box
  76. switchboard calls wrong path
  77. can't get open file dialog to work
  78. Now I've gone and Done it HELP!!! Compile Error:
  79. DoCmd.TransferSpreadsheet
  80. table won't load into the Recordset
  81. opening report & passing parameter to filter
  82. problem with FollowHyperlink ExtraInfo
  83. Appreciate the help
  84. Help with extarcting data from text file
  85. Record Level Locking in Continous Form
  86. Quoting wild card (*) in SELECT statement
  87. Code to concatenate and stick result in field
  88. Macro
  89. Need VBA Code help
  90. adding controls - possible or not
  91. Error message when trying to import files
  92. Excel.Application error
  93. Live Monitoring
  94. Querydef Help!
  95. automatically copy pwd to a new db??
  96. Finding unique field values across multiple records
  97. The expression is typed incorrectly or is too complex
  98. Access VBA Function - is number? required
  99. error with the Eval() function
  100. Time Diff Module
  101. Error while assigning a value to text box
  102. XML Code
  103. Exporting to Wordpad/Notepad/Word etc
  104. Fixing a missing reference automatically?
  105. Read Receipts for e-mails
  106. Unwanted code formatting help.
  107. caller id in access
  108. Simple Code Formatting...
  109. Search In VB
  110. Determine which day of the week
  111. VBA code prompts for primary key instead of auto-populating from form?
  112. Exporting Data to Word
  113. open file dialog box - access 2000
  114. Err msgbox hit twice on exit from function
  115. Disabling fields / form based on CurrentUser()
  116. If Statement Against a Check Box
  117. Veeeery slow response time through VPN while updating records... F1!!
  118. storing window handle
  119. Modifying an addnew record button in two control form
  120. Open Windows Exporer
  121. Converting column data to rows
  122. Using a Inputbox in a filter for a report
  123. Derive birthday from field and pop-up.
  124. barcode to retrieve a record automatically.
  125. deleting data that is 2 weeks old
  126. Extract julian date file extension to determine what directory to copy file to
  127. Outlook Email from MS Access, a new one.
  128. Max function in VBA?
  129. Best way to log changes to db??
  130. Scheduling equipment StartDate & EndDate
  131. scroll top
  132. check if text files exist before import to tables
  133. Disable taskbar close option
  134. How to access and use data from records?
  135. Pass email address from a Form to a Send Object Module
  136. problem with '.' becoming '#"
  137. username and password
  138. SQL in access,
  139. HELP:::trigger email to email addresses in table
  140. Dialog box acting weird
  141. Checking for duplicate prior to appending
  142. Email query results.
  143. Bypass database password using VBA code
  144. Appending Data from SQL Server into Access
  145. Updating database
  146. Add Object Libraries with code
  147. Return browser file path and TransferDatabase
  148. IP Addresses
  149. Open A File Using Command Button
  150. I need help from the big boys.. Insert and Resize Photo.
  151. Insert into external table using vba
  152. Retrieve User List From Active Directory
  153. need help with nested loop to export to excel
  154. formatting in Excel using Access VBA
  155. Extra ' in excel
  156. Opening files from listbox
  157. compact database on exit
  158. can't reference object unless focus is set ?
  159. Auto Outlook Export
  160. subtracting time
  161. setting FrozenColumns value
  162. multi-column listbox
  163. Getting an error with my switchboard
  164. Using VBA to modify normal alphabetic sort order in a table
  165. exporting to Excel (format of cells)
  166. setfocus problem
  167. Listbox
  168. create new database method
  169. Voting Buttons on email
  170. Reading a string from right to left
  171. update query one record at a time
  172. Random set
  173. Extract AutoCAD Attribute
  174. Convert number to words Indian system
  175. Unwanted update when form closes
  176. Create Table with VBA
  177. Show Thumbnails when opening File Open Browser
  178. Barcode
  179. Changing RecordSource Based on Password
  180. Can someone help with this Code ?
  181. Auto update FE database - Help with Batch
  182. Network connection lost
  183. MS Object Libraries
  184. Returnig String from Function 255 char limitation
  185. VBA Code to get data from 2 relational tables
  186. combo box values in Detail section on a form
  187. Recordset taking long Processing
  188. VB code conenction with OBDC to database
  189. TransferSpreadsheet for import, Error 3011
  190. Changing public variable via form
  191. Removing double quotes
  192. vba on Access 2002
  193. Update Table
  194. using a textbox value as a string in a file name
  195. Field Property "DisplayControl"
  196. Printing files through VBA
  197. can't edit Excel
  198. SQL-SELECT-Urgent help
  199. will references work on every computer?
  200. Concatenate text and Linebreak in VBA
  201. Character limits in mailto strings in Access 2003
  202. Referencing a Global Variable with a Variable
  203. open mdb file with Access 97 exe using vbscript
  204. code problem on open directory
  205. recordset to Array
  206. Access 2002 Critical Fault (GDI, KERNEL, USER) in Win98SE
  207. Error on field beforeUpdate property
  208. Reset field value
  209. cannot open multiple Excel documents
  210. Excel sheet without cell borders
  211. trouble with VBA between Access and Excel
  212. saving the calculated value of a control to a table
  213. A date range form-Populate my table with each date in the range (exclude sat/sun)!
  214. Is it this easy?
  215. Import XML - autonumber and foreign keys
  216. updating data with diconnected recordset
  217. Need something like Macro Substitution
  218. Append ADODB Recordset to table
  219. Clear the form
  220. The Sum of Time
  221. using vba from Access to change Excel worksheet
  222. Modifying text boxes from a module
  223. References not saving
  224. Access had detected corruption
  225. Working with dates in vba...
  226. Importing unopened Excel files
  227. Export a custom Toolbar
  228. Need Urgent Help in passing Connection String using ADO to connect to Access DB
  229. check first character
  230. opening different forms for different users
  231. Import newest created text file only
  232. Subform recordsource / why can't i change it?
  233. Open a excel file
  234. network drive paths as strings - access 2000 import files
  235. Open second database while closing first
  236. excel stays in task manager ?!
  237. Import specific columns in Excel into particular Access table column by VBA?
  238. Random Selection From a Table
  239. Loop Syntax
  240. yet an other newbee... (syntax question)
  241. Help with SQL code
  242. Data Extract from text file report
  243. Problems with VBA & Queries...!!?
  244. Importing text File to BackEnd using Front End VBA
  245. Transfer Object method locked
  246. AutoExec but is there an AutoCloseExec?
  247. please help, "member already existis..." error
  248. search from form
  249. Searching equal records
  250. auto format date, eg 1 into 1st, 2 into 2nd .. etc