View Full Version : Microsoft Access VBA Modules

Pages : [1] 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

  1. Change VBA code from a form
  2. How to Select a JPG and copy (renamed) to a directory
  3. Using SOAP in XML
  4. Open report from multivalue fields
  5. Delete left string from space value
  6. email multiple attachments from a folder that i choose
  7. error on update table WHERE date comparison
  8. How to connect to a BE database?
  9. Non Default Outlook Calendar
  10. 2501 The OpenQuery action was canceled.
  11. importing data
  12. Attachments vs. Linking in 2007 and 2010
  13. random assignment
  14. 3008 error by using memo format
  15. Message from Access 2007 on sub function
  16. Sorting on Calculated Field in Reports
  17. acquisition image from scanner machine then automation save imagespecepic folder
  18. JOBBOSS - User-defined Reports
  19. Access 2003 versus Access 2007 Excel Import
  20. Re: Replace, but ignore certain characters
  21. Pull a random number more often
  22. Inserting attachment, as opposed to attaching with VBA Module
  23. Sending email to a distribution list specified in Outlook
  24. How to change Pivot Table external data source (MS Access Database)by VBA
  25. relate tables - please help
  26. How to pass a form event parameter to a function without using [Event Procedure]?
  27. Import mutiple name text files into Access 2003
  28. Import Text File Into Access
  29. Shortcuts for VBA procedures in Modules of MS Access
  30. Access VBA for Page Setup in Excel
  31. Create a Table with Multiple Values Listbox
  32. Why Does My Button Code Copy To "General" Object Window From "[My Button Name]" Objec
  33. Up For Reviewing Complex-ish Button Automation Code? Here Ya Go...
  34. SQL for report
  35. Why Does Macros Dialog Pop-Up When I Try To Run Code In VB Editor?
  36. Can't pass Recordset?
  37. Trying to tableize emails from user folders in outlook
  38. Compile application
  39. Security in MS Access forms application
  40. Run-time error 3061. Too Few Parameters. Expected 2.
  41. SQL statement needed
  42. Access 2003 db window
  43. Very strange problem when hovering a parameter in debug mode
  44. How To Run Sub In Exported From Access To Excel Table?
  45. Allen Brown's audit log code "insert" problem
  46. Add an "ALL" option to a Combo Box
  47. ms access 07 list box select to vba sql query
  48. VBScript to run MS Access form as admin
  49. Copy data from one databse tabel to other database table
  50. Updatable ... not
  51. Adding a Hyperlink to a local file in a forum
  52. unbound OLE PDF Object in Access Report doesn't update
  53. Compile Error "Variable Not Defined" - Access 2007 - Word 2007
  54. using mulltiple criteria in strfilter
  55. Run-time Error '424' Object Required
  56. VBA Corrupt
  57. run-time error '-2147417851 (80010105)'; Method 'PasteSpecial' ofobejct 'Shapes' failed
  58. System resource exceeded
  59. Filter by date range for any one of three dates.
  60. Including blank fields in results when filtering a report
  61. How to list the names of forms and reports of an .mdb database by VBA
  62. Improting multiple OLE Obejcts problem
  63. Microsoft exam suggestion ?
  64. Inserting values into individual Excel cells
  65. Run-Time Error '440' Method 'Run' of object '_Application' failed
  66. Add Voting button to Email sent through Access Vba
  67. Algorithm for computing Excel PercentRank
  68. Acc2010 - Filtering Report based on Subform Filter
  69. How to only allow user to select only one record
  70. How to Requery Sub form from another sub form
  71. FindFirst quit working
  72. VBA Documentor code
  73. Excel hangs. Why?
  74. csv Import into Access db
  75. inventory software
  76. Recidivism
  77. Set Default Date to European Format without changing Regional settingof the PC
  78. How to Return Only the Numbers in a Text Field (Plus the Decimal)
  79. How to deactivate a command button if record in a query
  80. TransferText Question
  81. attempt reconnect on connection failure
  82. Re: Centering Report on screen
  83. Re: modulesdaovba site question?
  84. mp4
  85. MS Access
  86. Output To flush data?
  87. Re: Column Name in Excel Export
  88. Query: Hide columns with VB/VBA
  89. Re: Union Query as Rowsource for list box on form
  90. How to format specific records in Datasheet view
  91. Object Name does not follow Microsoft Access object-naming rules
  92. Using access table to set search criteria in Google, Bing or Yahoo
  93. Distribute Shares from single record to multiple records
  94. Distribute shares from single record to multiple records
  95. Delete files on web server by FTP
  96. Module that caculates the difference between times
  97. Set warnings set to no, but won't work when file goes to excel
  98. How to dynamically set the lower and upper limits of the axes scaleson a MS Access xy-chart
  99. Noob Question
  100. Convert "OutputTo" to vba code
  101. 2007 Access error 2455 on Filesearch
  102. Insert Into?
  103. Creation controls in Report
  104. Strange Problem with Scripting.FileSystemObject
  105. Re: Populating a Selection List
  106. Re: Populating a Selection List
  107. How to get a date field to appear as a date field and not a textfield
  108. Re: disable double click to change window size
  109. Re: disable double click to change window size
  110. Change control in dialog form
  111. Access runtime ribbon - export to word option missing.
  112. Insert Into -- expected end of statement error
  113. Assistance with Output
  114. Set Variable to lookup field
  115. Sendkeys "{ESC}"
  116. OLE, INK and Reports
  117. Allen Browne's Calendar97.mdb
  118. If this correct use of Select
  119. show number of records updated
  120. "%" character
  121. Re: Checking for Null & Select Case
  122. Form Name as Variable
  123. Calendar control conversion issue
  124. run query message
  125. Public variable
  126. "item not found in this collection"
  127. VBA Reference Libraries-Access 2003 vs 2007
  128. create a form that collects parameters
  129. populate a text box with multiple records based on combo box selec
  130. Like operator case sensitive
  131. Running a continuous VBA loop while allowing the user to click but
  132. SQL statement with LIKE need to show Numeric paceholders
  133. access form not listed in access class object
  134. Create Table with Date Appended
  135. Code Event Criteria
  136. Error messages as if "Option Explicit" were declared, but it isn't
  137. Re: Filter Records after FindRecord
  138. Access 2000 to 2003, get error 438
  139. What is the meaning of the "$" in say the left$ function
  140. Get Displayed Text of a ComboBox
  141. Complex query problem
  142. Help with vba autorunning macro?
  143. How to delete embedded Word object?
  144. Re: Modules
  145. Setting a subform to a member of a collection
  146. Re: Auto FE Updater
  147. Copy Photo To Clipboard
  148. Can I Share a MDE (which only has VBA Code) with other apps?
  149. How to Export VBA Code to a text file
  150. how do i bypass an access module password
  151. HELP! VBA Code Stopping on Open
  152. random number generation
  153. acDialog - Form Invisible?
  154. VBA To Access Multi-Value Lookup Field
  155. Unable to Reference a Subforms Properties/Controls
  156. Query by Form-TJ
  157. Security option missing-TJ
  158. Empty subforms-TJ
  159. Re: Subreport On No Data event
  160. Change form property at runtime
  161. Re: Syntax Error: Japanese Character in VBA Editor
  162. Re: Split Database Distribution Errors
  163. more on VBA function name change
  164. When I double-click on a hyperlink in Access it opens in HTML
  165. Record (row) count by Table in Database
  166. Requery without visibility change
  167. Windows 7 problem
  168. Automating Excel report Using Data from MS Access
  169. Determine the drive letter of BE database...
  170. does anyone have a simple central warehouse inventory database
  171. A Great Big Thank You!
  172. Need Tab Control Advice
  173. Windows 7 automatic clicks
  174. Format- problems
  175. RE: Need Tab Control Advice
  176. RE: Determine the drive letter of BE database...
  177. portrait and landscape in one report?
  178. RE: Saving Report to PDF without using DLL OCX
  179. Invalid use of the .(dot) or ! operator or parentheses
  180. Complimentary migration kit for MS Office 2010 web apps
  181. Alter Label in Report Section Header When Section Continues to Additional Page
  182. Saving Report to PDF without using DLL OCX
  183. Congratulations! Its a bouncing baby pass-through query!
  184. Re: Integrating Access with Map Point
  185. Re: Test if the same form isLoaded.
  186. Display Report Header/Footer
  187. Re: Disable button on custom ribbon
  188. Why does code Loop
  189. hiding tables....
  190. Undo not working?!?
  191. Combo box refresh with limit to list = no
  192. Append Records without Duplicates
  193. PDF Form Field Values
  194. making check boxes into an array
  195. Re: Module for searching multiple .doc files on multiple terms?
  196. GoToRecord for a subform
  197. Browsing for file name
  198. Utilizing Recordset field in vb Requery Command Verbiage
  199. Message box
  200. Re:
  201. VBA function changing its name
  202. VBA function changing name
  203. Append 2 tables with variable names
  204. Can I use a variable for a table name in an SQL statement using VB
  205. Access 2003 & VBA Debug->Compile
  206. saving a report to a text file without decimals
  207. Re: Continuous form problem
  208. The database cannot be opened...
  209. field properties in queries - "description" <property not found> even though description entered
  210. How to approach this process?
  211. Making Form Read only based on Windows User - Code correction requ
  212. Re: Get an array from a function
  213. Access 2007 DB and VPN issues
  214. VBA - Dmax Criteria or work around
  215. VBA push to Excel issue
  216. bulk copy to Excel
  217. Can I use a variable for a table name in a SQL statement using VBA
  218. Variables in SQL-TJJ
  219. combo box in inputbox
  220. combo in input
  221. Overflow Error
  222. Re: Append page of standard text to each page of a report
  223. Access 2003: Loop Through Records
  224. Sort Columns
  225. Auto Check/Uncheck boxes based on checking 1 of 30 boxes
  226. Using a variable to refer to a control in VBA
  227. Compile Error
  228. How do I see existing users and add/remove them?
  229. Deleting/Creating a relationship between two tables -----> Help Pl
  230. View "AllowByPassKey" property
  231. Re: Date range
  232. flexibility in searching by adding “search by” combo box
  233. RE: Date range
  234. Double click Image to view full .JPG File
  235. OutputTo PDF error 2501 The OutputTo action was cancelled
  236. Query criteria set by unbound form textboxes
  237. publish to pdf
  238. make table in back end, then link
  239. Merging Reg Files
  240. Re: Copy record code
  241. access to pdf to powerpoint
  242. Problem with DBengine.SetOption dbMaxLocksPerFile
  243. Can I validate data in a combo box vs another table?
  244. Re: Median and Quartiles - Speeding Up The Calculations
  245. Create Trusted Location Via Code
  246. Multiple Delimiters in Array
  247. IIF Statement
  248. Refresh Not Refreshing
  249. Delete Field in Backend Database
  250. Count records added in current week
  251. Exit Do problem
  252. How to display only date as year (yyyy) in txtbox?
  253. Installing Snapshot Viewer via Office 2007 Setup
  254. Loop Question
  255. How to display only year as date in txtbox
  256. Re: MS-Access 2007 Minimize/Maximize Ribbon
  257. Filecopy
  258. designing form for inserting records into separate table
  259. Filecopy
  260. design problem
  261. browse for folder code
  262. Multivalue Field in Access 2007...
  263. autodial
  264. VBA code required.
  265. Scanning Through "Memo" Field Is Very Slow
  266. FIND/EDIT Commands in VBA CODING
  267. Accessing information from Mapquest
  268. Re: Issue with DoCmd.Transferspreadsheet acExport
  269. RE: Issue with DoCmd.Transferspreadsheet acExport
  270. Using Acces To Paste Visio Drawing Into Power Point Issue
  271. searching and finding records from separate tables
  272. check date if it falls within a month
  273. Adding PowerPoint slide to Access Form
  274. Two VB Codes for changing conditions
  275. cannot update. DB or object is read-only 3027
  276. Keep subreport with no records?
  277. Delete/import a table from csv; wait for no users?
  278. Accessing the content of an excel sheet
  279. Re: Setting path through VBA
  280. expired date
  281. Create Table of Contents
  282. Creating a botton to update data from a Form to Table
  283. VBA combo code filter in 2000, 2003 not working in 2007 or 2010 be
  284. Multiple criteria selected using checkboxes determine query result
  285. E-mail query to recipients in table - performance and security
  286. Getting value from previous record
  287. Pass multiple selected values from list box to table
  288. Sequentially Increment a Text Field Based on Select Criteria
  289. Print an external file
  290. Treeview rebuild
  291. creating a simple view
  292. Obtain Sub-Folder Names with VBA?
  293. Code for Access Help
  294. dlook finding NULL
  295. Pull form in view mode from drop down menu
  296. Re: Set focus problem
  297. Enable Conditional Formatting Access 2007
  298. Populating a list box with images
  299. 5 minute time increments
  300. RE: Count records in a query
  301. Access12 getobject fails
  302. Re: Error Handling
  303. Re: Restore not working
  304. pivoting query
  305. brackets in a sql statement
  306. Re: Using VBA to automate a reporting process
  307. Closing Form causes a requery?
  308. Elapsed time with only 1 column
  309. Can Access 2007 discern which folder it lives in?
  310. How to do it
  311. Access can't find form "frmWarning" in macro or code
  312. RE: Splitting Database
  313. RE: Splitting Database
  314. Re: Splitting Database
  315. Waiting for subform to load...
  316. Programmatically running SQL Query
  317. Search only on current field to unchecked
  318. Find First
  319. Unable To Read Certain fields in Linked Excel Sheet to Access
  320. reading win 7 event logs
  321. Programmatically determining recordset names in database
  322. Re: Stamp date for every record change
  323. Trailing "-" for Neg Number
  324. Populate XL cells with values from a user defined type
  325. Limiting data in a report
  326. if statement = if number is between
  327. Re: Stamp date for every record change
  328. Re: Unable to automate excel chart from access
  329. Retrieving Outlook Message Text
  330. Storing a Per User Per Session Variable
  331. Change unbound text box in Report using VBA language from form
  332. Problem with vba code to export query result in excel
  333. Credit Card Processing
  334. Coding Problem
  335. Tutorials on Access Programming
  336. Import Specs Changed "Magically" in Midst of Loading Sequence
  337. Link Tables and Select Link
  338. Change column to Required = no and Drop all table relationships
  339. Multiple User Access
  340. Creating a string from a query in vba
  341. budget figure in actual field if blank
  342. Error Exporting Access Query Results to Excel
  343. Global variable not working
  344. Data Defnition Query
  345. Send PDF document via Send Command
  346. 2010 2007 compapibility
  347. Access 2007 help file
  348. Adding a back page to every report page?
  349. checking if an item exists in a custom collection
  350. checking if an item exists in a custom collection
  351. checking if an item exists in a custom collection
  352. checking if an item exists in a custom collection
  353. checking if an item exists in a custom collection
  354. Re: Access 2010 x64 Development
  355. Running parameter queries from VBA, suppressing parameter prompts
  356. Re: Shortcut menu for a control?
  357. PLEASE HELP: Columns not sorting properly when I import from text
  358. mainform/subform another user is editing...
  359. How to modify the Expression1 or 2 of an existing FormatCondition?
  360. Type - End Type
  361. Recordset in Access 2007
  362. Multiple User Access
  363. Automated Access Reports E-mailed with Outlook in Remote Desktop E
  364. Re: VBA question confused
  365. Function w/ Dlookup
  366. Unload Me
  367. Assigning Text Box Value to Variable?
  368. Re: Duplicates phone numbers and extensions
  369. Array basics!
  370. Strange Julian Date Phenomenon
  371. mySql insert statement using date
  372. Report Printing
  373. Automating a Find and Replace.
  374. Can VBA amend data in tables
  375. Date Comparison
  376. access 2007
  377. Microsoft Access Help Function Sample
  378. Msg - could not update; currently locked by another session
  379. Removing OrderBy from Tables and Queries in VBA
  380. Editing more than 1 table at a time with SQL.
  381. Multiple User Access
  382. PLEASE HELP: automate process to import tables from notepad to acc
  383. Error with Dlookup
  384. Which form event triggers a procedure ....
  385. Conflict in Reference Function
  386. Print a PDF
  387. Help explain to me
  388. Re: OpenCurrentDatabase with runtime environment
  389. Re: Linked Table Manager
  390. Listbox and combo problem
  391. Getting Compile error
  392. access 2007 vba report checkbox
  393. RE: Linked Table Manager
  394. VBA Error
  395. Logos stored in database
  396. Turn off Help
  397. Re: create a report using vba to select the names for the report
  398. Re: DCount
  399. Re: Query a non-MS/non-Active Directory LDAP Server
  400. Re: MakeSchedule function
  401. Program Database to send Notifications to Outlook Inbox
  402. Check for similar phone types.
  403. Re: Query a non-MS/non-Active Directory LDAP Server
  404. RE: MakeSchedule function
  405. Lookup record in a different databse then current
  406. Check for installed printer???
  407. Access 2007-Create Custom Menu
  408. Rename database Object from another Database
  409. sum weekly data into monthly
  410. openreport errors
  411. View a control's name
  412. Help with custom search form - should I use rec
  413. Command button on a continuous form
  414. Run query before closing database
  415. Crosstab with subquery as source to another query
  416. Re: dlookup function
  417. Compile Error - Don't know WHY?
  418. exporting multiple tables
  419. Can a form with drop down menus search in other forms?
  420. decimal issue
  421. Re: neatcode.mdb
  422. List Box on main form
  423. Re: $B$F$9$H(B
  424. Re: neatcode.mdb
  425. Conditional Formating and SetFocus Question
  426. Access 2007 development in Access 2010
  427. Customized display order for fields
  428. Assign control source in code
  429. fisprogramrunning
  430. A New Law Could Change the Way You Build Database Applications
  431. Set field focus in a subroutine
  432. Re: find date last used, deativate if older than 12 months
  433. Timer not being dispalyed and not able to use form??
  434. ADO Connection Opens as Read Only
  435. Re: Programming Question
  436. Re: Programming Question
  437. VBA Code Help
  438. Programming in .ASP
  439. Run delete query instead of report...
  440. I want use accounting software in INDIA so pls help me for use
  441. Converting old code
  442. Opening client form with apostrophe in name
  443. Execute SQL Stored Proc from Access
  444. Multiple User Access
  445. Flex Grid Control
  446. Open form in another database
  447. Compile Error: Type Mismatch
  448. Browse for Folder
  449. FileSystemObject - Compile Error Invalid use of property
  450. Link fields if primary is found
  451. access app as a service
  452. Search box of the Record Selector
  453. HELP really needed to change combo box to list box for multi selec
  454. CompactDatabase vs CompactRepair
  455. RE: Function to return path to current mdb
  456. Listbox Order by not sequntial
  457. RE: Function to return path to current mdb
  458. Re: Function to return path to current mdb
  459. Switch board error - hyperlink
  460. Assistance with vbYesNo
  461. Northwind Sales Dialog box- change combo to list box
  462. Compact & Repair Code - File Permissions question
  463. Changing combo to list box for multi select values
  464. Re: Launching Excel fro within Access 2007
  465. SubForms
  466. ideas on how to make a test suite
  467. Dcount operation
  468. Invalid Operation on a querydef
  469. AfterUpdate event procedure
  470. DateDiff
  471. RE: Opening report in a different mdb
  472. Please Help: compare values in two columns present in seperate tab
  473. Check Box on form
  474. VB Event proc puts spacing between 1 and s in 1stQueryList.
  475. RE: set excel cell value
  476. RE: set excel cell value
  477. sorting problem
  478. remove filtering problem
  479. Randomly select a record in a table
  480. RE: set excel cell value
  481. Convert Excel code to work in Access
  482. how can I activate a hyperlink address from the vbOKOnly button
  483. Days and Nights
  484. Obtain a list of all files in one sub-directory with VBA?
  485. Re: RecordsetWrapper
  486. RE: Split Function Wrong Number of Arguments
  487. PivotTable: Type Mismatch
  488. RE: RecordsetWrapper
  489. How to Keep Combos requeried when viewing and editing records.
  490. Adding filter to query
  491. Under the gun, HELP!!!
  492. Problem filtering and opening a report
  493. Saving Excel from Access
  494. Re: Convert data type text into number
  495. My (final) 2 cents on continuous form design
  496. Problems with MS Access reading dates as US, not British formats.
  497. Can't get this code to work properly to print
  498. Import table into database Access 2007
  499. Problem with deleting record
  500. How can you generate an Excel file from a query that has parameter
  501. RE: Check a field and show a popup
  502. How do I create a clear filters button in a form?
  503. Queries
  504. Problem rounding down Access 2000
  505. Percentrank
  506. User defined type not defined?
  507. Formating Percent with VB
  508. Opening another Access DB from a Form Button
  509. email automaticly
  510. Retreive Variable Value from Module
  511. VBA Project Deleted
  512. Command Button - to pull all
  513. Re: Text or Sub-report on even pages of a report
  514. I can not sort hyperlink field in the query
  515. exporting xml from access 2000 query
  516. Commit/Save Record
  517. Custom Date Partition Function
  518. Need to get the Up/Down Arrow Keys Working
  519. Connect PHP to Access database error
  520. Make Table v. Append to Table: Need Some Expert Design Inputs
  521. VBA Editor skips lines and moves to other part of code
  522. Adding timeframes to database
  523. Creating conditional clause in a module
  524. The memory could not be "read" error
  525. RE: message to wait
  526. Re: message to wait
  527. RE: Code disappeared
  528. Access 2003: Need module to add dates to report.
  529. Object to use for sending URL / retrieving XML
  530. VB Code for form filter with different Data types
  531. running query every day is slower
  532. Dowload file from URL with VBA
  533. Compact and Repair database
  534. How to Change Value of Active Control
  535. Accessing a database access file without a driver
  536. Error 3144 syntax error in UPDATE statement
  537. VBA Opening Access Table from Excel - Permission Error
  538. Application-Defined or Object-Defined error 287
  539. Navagation Pane frozen
  540. Can an Access accounting database be linked to a bank account?
  541. Re: Audit Trail Code
  542. RE: Audit Trail Code
  543. Edit/Manipulate PDF
  544. RE: Audit Trail Code
  545. Linking in Access to a specific Outlook email
  546. VBA and Javascript
  547. Re: vba,xfer
  548. Oper Arges
  549. How do I paste a graphic from Access datasheet to Excel using VBA
  551. Linked databases
  552. Linking to specific Outlook item
  553. Re: Unmatched Problem
  554. RE: Ask help to speed data processing
  555. Appending to Sharepoint List From Access
  556. Hide a Folder
  557. "#Delete" in memo field
  558. Developer Extensions for Access 2003...
  559. DoCmd.SendObject TemplateFile
  560. Adding report with another
  561. migration from Access 97
  562. email attachment pop up network problem???
  563. Custom Ribbon and Reports
  564. Etat Access : mise en page non enregistrée
  565. Fill-in PDF Form using Access Data
  566. your 2 cents on this form design
  567. Recreate VLookup in MS Access 2003 Form Using DLookup.....
  568. Jet engine and multiple processors
  569. control reference change bet. 2002 & 2003?
  570. Import using schema.ini file
  571. How to view Outlook 2007 from Access 2007 form?
  572. EMailing a report in Access 2003
  573. Using Dlookup in VBA
  575. Search a data (EmployeeName) from all the tables in the database m
  576. Blank Report
  577. Leave workgroup on Exit
  578. Message Box to Display a count of Records
  579. Creating Memo from data
  580. RE: Passing a value from one event to another
  581. Can you collect data into access 2007 using barcode scan guns?
  582. RE: Extracting first letter of last name in name field
  583. Deleting sheet from a template
  584. RE: Extracting first letter of last name in name field
  585. Re: Extracting first letter of last name in name field
  586. calling objects method
  587. display criteria as a field in returned data
  588. Re: Cannot Kill Excel File
  589. #Delete Mark in Bound Memo filed
  590. How to create the manual in Access database
  591. Arvin Meyer's database
  592. Which is easier to use for this project?
  593. Unable to Programically Total Values
  594. Where should the backend be installed
  595. Problem with FindNext in Recordset object
  596. Problem with divided by zero
  597. cloning records
  598. Environ(x) doesn't work for 1 user
  599. Closing Excell from Access
  600. Open another database...
  601. enable a combo box in one form based on input in another form
  602. Get records with a negative value anywhere in the table.
  603. Querry run time display
  604. DSN Less Connection
  605. Help with a batch file please
  606. Add Events
  607. VB code stopped working?
  608. Multiple ComboBoxes but one must be Checked
  609. Collapsing All groups in the Navigation Pane
  610. Retrieve an External File, pdf, txt, jpeg... etc
  611. Issue Refreshing/Requery Subform/combo box
  612. Using expression builder object
  613. Using OUTPUT TO in VBA, then how to modify the XLS from Access?
  614. How to display thumbnails using Access 2007 VBA on Windows XP
  615. How to create an email in a client's default mail client
  616. Application Installation Dilemma
  617. Array to String
  618. Re: Looking for example VBA code for MS Access DB sync
  619. Paramater box pop up even if customer selected in combo box
  620. #Delete appear in field
  621. Re: add record
  622. RE: add task form access to outlook
  623. Re: Looking for example VBA code for MS Access DB sync
  624. combo box method or data member not found??
  625. VB Code to copy linked table to local
  626. Mail Merge from Access with datasource being a password protected
  627. WHERE statement in VBA
  628. RE: Cannot run module in macro
  629. Setting excel to landscape and setting print area from access
  630. Re: conditional formatting syntax
  631. Outlook Outbox not responding
  632. Locking Tables - MS Access '07
  633. Re: Email from subform
  634. Re: Transfer Spreadsheet Method
  635. Revision conversion to a number suggestions ?
  636. ERROR# DSUM
  637. Access To Word Mailmerge - One step only Office 2007
  638. open two different Access reports
  639. Re: change property on subform
  640. Re: Transfer Spreadsheet Method
  641. Close Database
  642. RE: Transfer Spreadsheet Method
  643. Like '*' or Is Null
  644. referencing the same class objects in two forms
  645. Bypass hyperlink prompt in VBA?
  646. error message 2465
  647. Month problem
  648. Error: 2003 vs 2007 Object or class does not support the set of e
  649. Unable to update/add records in connected SQL Server tables
  650. Create Multiple Index
  651. Query excel temproary file from Access
  652. Re: .createfield and OLE Object
  653. Control de Print Dialog Control
  654. vba to crop a picture
  655. PLEASE HELP: Display results in footer section of a split form
  656. Re: Parsing imported csv data
  657. Refer to a form instance
  658. Open Word Document With Modify Password
  659. Send Email "Operation Failed"
  660. Removing character
  661. anther date question
  662. Check dates
  663. RE: Not In List
  664. If field value has changed allow an audit - if not allow form to c
  665. Combining records by date
  666. Attachment image as image picture
  667. Error 52: Bad File Name (Chinese characters)
  668. If in side of If Problem
  669. Autofill field based on values from another table
  670. Form repeatedly becoming corrupt
  671. building a string in a public function
  672. How to clean up MSysObjects
  673. HELP: Display search results in footer section in a split form
  674. CDOSys.dll and Basic Authentication
  675. passing boolean variable value into SQL string
  676. Front End being locked
  677. use global variable and email a form
  678. Format text box as bulleted list
  679. Have values in Not In List sorted after new addition
  680. #name error text box
  681. Set focus to MS-Access
  682. Access 2003 and/or 2007 copy in objects from another mdb
  683. Rollback doesn't work!
  684. No Data on Form Open
  685. #error in text box
  686. Email the files in the Attachment Field from Access 2007
  687. Autofill new record
  688. Hidden toolbar unable to get to show
  689. beginner VBA to create 2 columns
  690. Lapsed Time when 1 date is null
  691. Encoding string to UTF-8
  692. DoCmd.TransferDatabase run-time error 2501
  693. Reference PivotChart view properties?
  694. Re: Run-Time Error 438 Outlook
  695. transferring data in rows of one table to columns of another table
  696. DLookup
  697. ListCount
  698. Programmatically listing Relationships of ADP file
  699. Reading SQL Server Extended Properties
  700. One to many help
  701. saving as text to remove corruption of forms
  702. Can't hide Property Sheets
  703. Input Mask
  704. Re: where in recordset
  705. Embedded Macros
  706. Re: where in recordset
  707. Re: Query the last 5 dates
  708. Re: Query the last 5 dates
  709. Automating CompactRepair--"db in use" error
  710. Pass the results of a query to a variable
  711. Append and Loop Code
  712. left and right functions not found on specific computer
  713. SendObject behavior different after today's Windows XP updates
  714. Deleting Import Error Tables
  715. How to Split Related Records in Two if Greater than 15
  716. Highlight Records That Are In Use By Another User
  717. Copying and pasting rows from one wksht to another based on cell v
  718. Code to delete rows excluding Header if not = to
  719. How to combine several excel files into one access table?
  720. Tables Refuse to 'Hide'
  721. Disable MS Office Button & Navigation Pane
  722. How to determine if an object is still open
  723. Custom Ribbon Using SQLServer Backend
  724. Evaluate execution time
  725. Re: Clarification: the copy should be the bound column not the displayed
  726. Assigne Macros to a Single Command Button
  727. Database Expanding out of Norm
  728. Import Historical Stock Data from Yahoo-Finance
  729. Filling drop list
  730. Use of DSum, DCount, DLookup, etc in form after splitting
  731. Determine if an object variable is set
  732. Mutliple Databases Open for Some Users
  733. Table to Array
  734. Run Time Error 3027
  735. UTF-8 Encoding
  736. assignin time values to a variable
  737. RE: DLookup function
  738. How can I run a ".cmd" command string from within MS Access?
  739. Re: What's wrong with using GOTO ?????
  740. RE: What's wrong with using GOTO ?????
  741. 4 day work week
  742. Re: What's wrong with using GOTO ?????
  743. Supress Access Error in Field Validation Routine using BeforeUpdate
  744. PLEASE HELP: Develop a custom screener in access
  745. Disallow null/allow null depending on the selection of another fie
  746. Error - Record(s) can't be read, no read permissions on
  747. cancel parameter without error?
  748. SQL pass thru query from code always propting for DSN
  749. 2000 Runtime
  750. Using VBA to set up a query in acViewPivotChart