PDA

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