PDA

View Full Version : Modules & VBA

  1. Problem with Form to Subform Code
  2. Help with a text field & a Date field, please
  3. insert into problem
  4. Searching for a word within a record
  5. Opening a link
  6. create a specific list of data
  7. Using query results in code
  8. Code Creates Lingering Process
  9. Closing a form without a 'save prompt'
  10. Can Access view HTML code from IE?
  11. Dynamic Form properites
  12. Help with Hot Sync control
  13. isnull/notnull??
  14. Filtering a report
  15. Deleting Excel file from Access
  16. Subform and FindRecord
  17. SQL Update query not running (might be confused by if statement)
  18. Simple Button Problem
  19. Linked Tables
  20. Microsoft Outlook Objects
  21. Shell with acrobat reader
  22. Over My Head...Please Help If Possible.
  23. Disable print in form
  24. cc: on an automated lotus notes email.
  25. Find missing numbers based on user inputted variable
  26. backup SQL Server database w/o Ent. Mgr.
  27. Declaration error
  28. Faulty searching with VBA,SQL and forms
  29. creating formfield on run time in ms word
  30. Dates, Recordsets, SQL HELP!!
  31. Create Folder and copy in it
  32. Filter
  33. Keeping focus
  34. Cannot access public property of a subform
  35. Open a website in access
  36. Import TXT files not csv nor tab
  37. Export to Excel
  38. Special Character in INSERT INTO query
  39. Having a records calculated field get info from previous record
  40. listing all tables / fields
  41. File Integrity - obtain checksum
  42. include template when sending mail
  43. Number of weeks in a month
  44. Run-time Error 2169
  45. Achiving/Moving a single record at a time
  46. 3264 "no field defined--cannot append tabledef" on create temp table from query
  47. Another missing reference thread
  48. Create Menu Bar with VBA
  49. Open Form When Access Window Become Hide
  50. Start OnClick event outside the form
  51. Filter subform based on combo box selections
  52. Cant delete last record
  53. Relinking an Excel Spreadsheet
  54. Holding down a key to confirm an action
  55. Permission Denied from Switchboard
  56. "Browse" Button Needed
  57. Multiple Users add new row in Table
  58. TransferSpreadsheet command - use of Ampersand in Worksheet names
  59. Action at set time
  60. Error Handling
  61. "unrecognised database format"
  62. Non-Event to trigger a wav file
  63. DoCmd.CopyObject when not only user
  64. Running a SQL string
  65. The White Screen
  66. need basic code for a message
  67. auto enter site info from one excel to other excels
  68. help to take value into a variable
  69. Time Calculation
  70. Date formats
  71. FileCopy overwriting files
  72. Mail Merge problem - Word cannot open data source
  73. Email from Access
  74. Refresh Queries
  75. Attachments
  76. Copy rich Text to Outlook
  77. Quick Question About Combo Box
  78. Control is null in VBA
  79. connecting databases and comparing fields
  80. Make read-only recordset updateable
  81. Set Calendar Control Date other than Today
  82. Loop with unknown number of elelments
  83. Inactivity Timeout
  84. Environ
  85. tablesdefs.count is returning an incorrect value, way off!?
  86. Audit Trail Version: 2003
  87. Error help
  88. Exclusive Mode
  89. Query with Paramater
  90. Access to .Net
  91. VBA - Skype
  92. Changing form properties based on group permissions
  93. Save en closing all open Excel-files
  94. Backup Dbase at a specified time
  95. 5 Text Boxes...Need to display DB info
  96. Pop-up with Available id only
  97. Searching
  98. Can You Guys Help Me?
  99. Using a part of a var, last 3 or 4 letters
  100. Returning last character of a string
  101. Alternatives to FileCopy?
  102. Access email Body, Data Access Page
  103. Monitoring Data Change
  104. Writing to table in VB
  105. Hide Access Window
  106. Searching a field for a value using IIF
  107. Capturing UserName and Populating a Name Field
  108. Requery and Bookmarks for Recordsets
  109. Invalid or Unqualified Reference
  110. Parser help needed
  111. Not able to pass array as an argument to Let Property
  112. using sql in the code window
  113. Optimize Recordset update - speed
  114. Importing Data and Transformation
  115. Updating a recordset
  116. Simple programming question about creating fields
  117. DLookUp and Parameterized Query
  118. All Records from a query and only matching from another
  119. Delete only one column from table
  120. Change active tab in a tab control using VBcode.
  121. Email to names in table.
  122. To call a form with details from a table through a search criteria
  123. Validation of Form based on three fields
  124. Supress 'Printing...' dialog
  125. Sending email to a table
  126. Delete temp table in VBA
  127. Navigating data in a subform
  128. Something to Share for a little help
  129. Now() but! always the 1st
  130. query (on the fly) doesnt show empty records
  131. Saving and calling a variable from a field
  132. Code Help
  133. Going to New Record
  134. Emailing current record/screen, if poss?
  135. complex(?) code?
  136. Exporting XML with predefined hierarchy and attributes
  137. syntax error- Rrequire help
  138. Comma woes
  139. Please try and help
  140. submit button should be deactvated before entering the password
  141. DLookup on 3 numeric fields
  142. Transferspreadsheet Range option in regards to worksheets in excel.
  143. Urgent Help with VBA and Design!
  144. Generate 100 records in one go
  145. Using variables in SQL update
  146. Problem Using Array
  147. Import multiple excel csv files into access
  148. Verify first 2 digit of zip code
  149. DSN less Connections
  150. Dlookup and Checkbox
  151. GoTo Record in subform datasheet from a search on main form
  152. command bar sub menu problems
  153. stock code
  154. Leading zero in automatically assigned number
  155. Problem while adding values to Listbox
  156. Help with IF statement
  157. Referencing combo boxes
  158. Problem with query results when called from code
  159. Label Captions
  160. Need help for Complex VBA
  161. shade excel cells grey depending on another cells data?
  162. Masking Password
  163. locking excel cells after data is entered
  164. Error Trap Linked Tables at Startup
  165. Me.Controls
  166. IIf function evaluates falsepart when truepart found
  167. Backup and Restore Data
  168. Establishing Record Number
  169. Importing text file
  170. conditional formatting
  171. GoToControl
  172. Recursive method problems
  173. Bring minimized form back in focus
  174. suppress error messages (2)
  175. Set Part of SQL String
  176. Automating Access from Outlook
  177. Stop execution of code while a FORM is open
  178. Unable to validate other user names and passwords from the Domain or Network.
  179. Using Data Entered as variables for multiple queries
  180. How to use excel fields in access forms
  181. Importing Excel Spreadsheet to a table
  182. Using The Date Class
  183. how do I change the value of a field
  184. common dialog
  185. For... Next code not working?
  186. Requerying Data
  187. Stop second import
  188. runtime error 1004
  189. Difficulty with INSERT INTO, query
  190. Update SQL - What am I doing wrong
  191. Importing text files into Access
  192. DELETE Functions!
  193. INSERT w/ VBA
  194. Append with VB
  195. SQL statement works in query, but on command button
  196. Error Closing Form Runtime 2585
  197. Best way to automatically add records to a table (i.e. trigger)
  198. Calling the SynchronizeNow Menu Command
  199. Listbox .additem
  200. Loop
  201. Help With Code
  202. Getting current user name (not signon name)
  203. Transfer of application from VBA to VB.net
  204. Critical Errors in Access2003
  205. Moving to objects
  206. Code to create graph gives a runtime error
  207. Problem adding to time
  208. DSum and Between
  209. Accessing MySQL tables using FTP
  210. loop problem
  211. Want to Initate a Mail Merge
  212. quick tab nav question
  213. select statement
  214. Clump dates into one pay period
  215. Indexed property
  216. Formatting issues
  217. Option Group Issues
  218. Problem with .listcount
  219. Listbox .Requery
  220. Query in VBA Syntax!
  221. Best event to update everytime
  222. Listbox .additem
  223. Obtaining the Name of the Active Control
  224. Problem with If Then...
  225. No Data on Reports
  226. Concatenating Multiplr If's
  227. Open Report from Form
  228. Resolve Dynamic Reference
  229. Database Exit
  230. Run VBA Script on Link
  231. Access properties of file programmatically
  232. When Double Clicked Enters Todays Date
  233. Line function in reports
  234. Updating backend oracle tables from MS Access
  235. "IF" code needed
  236. Insert Object only from a specific folder
  237. help with on-the-fly query as source for recordset
  238. Multi-Select List box via function
  239. Timer and countdown
  240. Correction of password code
  241. New programming standard for Access VBA
  242. MS SQL 2000 tables linked to Access 2000
  243. How do you display &
  244. Rnd generates same number after closing and reopening the database.
  245. Incrementing a value
  246. How Do I............
  247. Would like help with error checking/validation (I think)
  248. Custom ActiveX Component in MSACCESS2003
  249. How to run function at any worksheet changes?
  250. Access on network