View Full Version : access answers


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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121

  1. Subquery to calculate the YTD amount
  2. How to reference subform from a popup form
  3. How to disable CTRL-S, but not CTRL-C/CTRL-V
  4. ERROR in combo box,
  5. ListBox, ComboBox criteria and query
  6. Looping through recorset to capture missing dates
  7. Currency number to stext string ?
  8. How do I export an Access report to excel with its format.
  9. Query for DUE DATE reminder
  10. why is MDAC not showing my list of ODBC drivers??
  11. Saving a form to a table in Access.
  12. How to select top recrod in a listbox by default
  13. How do I use the sum and if functions together to count reponses in a given quarter?
  14. Access 2003 - Combo Box Query Question
  15. Getting Value to Appear in Combobox
  16. Questions on Randomising
  17. Don't see reports in database. Is it possible they are set under hidden mode?
  18. Advanced search button on search form
  19. Recording Dates of Births on Access
  20. Get field value from related table
  21. A basic query that doesn't extract the null records?
  22. User logon form issue: Cancel button behaviour changing?!
  23. Complete Search Form For Access
  24. How to Open a form at the current record index without filtering
  25. How to pass a Range to a Function in VBA (In Excel)
  26. Access 2003 moving tables to sharepoint?
  27. Dim rs As ADODB.Recordset code returns error "user type not defined"
  28. Cannot remove error using Nz function
  29. Nz function not working
  30. Concatenating using Allen Browne's Code repeatedly
  31. Cascading Filtering
  32. Can a command button on an Access 2007 form be conditionally displayed?
  33. Integrating Access with Sharepoint
  34. DatePart Help Quarter AND Year
  35. How to delete records from MS Access table
  36. Unable to create MDE access file,
  37. Subform connected to stored procedure cannot be sorted twice...
  38. How to store only filename instead of entire path in a field in access 2007?
  39. How to delete a record from recordset but not from table
  40. Hunting down this error: object variable or with block variable not set
  41. Populate two fields with one combo box
  42. MS access open in edit only on sharepoint
  43. In access I do not want to duplicate items on a report.
  44. How Do I Create A Search Box?
  45. Creating delivery note in access
  46. help with how to Dcount two fields in one table
  47. How to import Excel data with one column containing PDF/JPEG files to access 2007?
  48. Limiting Row Source Property of Multiple Combo Boxes
  49. Close Current Form, Open a New One and vice-versa
  50. Notify access when the current access application looses focus to another program?
  51. [Excel VBA] Filter records within the time range
  52. Access 2007 / VBA subform syntax for criteria question
  53. How to search using filenames
  54. Clear Error Message from TextBox
  55. What is the VB code for looking up a value in a table?
  56. Is there a way to retrieve the response from accmdImportAccess?
  57. How to refresh multiple listboxes in a form based on the 1st listbox?
  58. How to combine five data fields into one string for a new field
  59. I'm having some issues with math functions in MS Access
  60. Using button to look at table before opening new form, otherwise open blank form
  61. Showing records with no data.
  62. Which form event fires after any field is updated?
  63. How to Sum and Divide two columns in a query
  64. How to determine end of subreport on main report
  65. How can I add the next consecutive letter?
  66. IIF statement in query....need help please
  67. VBA Boolean: Date is between two dates - T or F?
  68. How do I create a single form letter for individual data
  69. catch data type invalid error and convert it before system does
  70. How to Undo a new record
  71. Loop through multiple reports and combine as 1 PDF file
  72. Problem with Report/Subreport/Image
  73. Custom user security what other considerations before deployment?
  74. End of Day Procedure
  75. How to center content of a form on screen? Auto Center does not work.
  76. How to Export Excel Data to Textfile in a special format?
  77. something resetting status of select case or multi-line if statements
  78. Chart scales displaying same intervals on second/first Y axis
  79. Question about forms
  80. Use requery to get total of a subform
  81. How to disable "Right Click"?
  82. Syntax error (missing operator) when setting query sql
  83. [Excel/VBA ] How to Find and copy data(Mapped data) from another worksheet using VBA?
  84. How to detect the event change from outside the function of the built event?
  85. How to use command button to browse files and show picture in an access form?
  86. SubForm Filter
  87. Field Name Confusing in Business Days Function.
  88. HAVING and WHERE explenation
  89. Code to export new data from Excel to Access
  90. Access 2007 upgrade DAO references conflict
  91. Add users to security file from a form
  92. how to set page.visible to false in open or load event
  93. Query on the last element in a subtable
  94. Make table query in split database
  95. Hiding Design View from users
  96. Compile Error: Statement Invalid Outside Type Block
  97. set up another aspect to northwind
  98. How do you bold a portion of text entered into an unbound text box
  99. My macro is returning the wrong result
  100. Formatting report to page size
  101. Entering criteria into a query using VBA
  102. How to open form based on combo box selection.
  103. Using dates to search query records
  104. help with moving redundant data
  105. Access 2002 Developer's Handbook worth the buy?
  106. Help with tree view display of the form
  107. Code/macro to email all tables in DB?
  108. Import/Export access tables to xls file
  109. Pls Help for setting the special Member ID !!!
  110. I keep getting an error..Keeps say invalid use of ,;() in query expression
  111. I keep getting an error in this sql statement
  112. output/automate queries
  113. Set a Value on a form's bound field based on field in separate table
  114. requery my subform based on date criteria from the main form
  115. Backend file size jumped from 50mb to 200mb
  116. VBA IDE Object browser fails on MSComctlLib
  117. How do I calculate Overtime hours
  118. BeforeUpdate and error handling help needed
  119. Why does my code only work once when I open the form?
  120. VBA - Open a file with Shell if the filename contains a blank?
  121. Multiple search values in one text box
  122. Creating a Searchable Form for a Single Table Database in Access 2007
  123. Access forgetting my definition?
  124. Search Engine in Access using VBA
  125. Custom user login system edition
  126. How do I link back to a record from a reports results?
  127. Sending information from database over email at end of day
  128. double if condition in MS access query
  129. VBA excel: How to enable combobox selection
  130. sql and subquery syntax assistance needed
  131. Record Count?
  132. Can't get a report total and % to work when dates are made variable in query
  133. Setting recordsource of a report using openarg
  134. How do I Match Partial Keywords from "Table_GEO" with "Table_Main"?
  135. Facilitating data entry in a many-to-many relationship
  136. VBA excel userform
  137. Addiing checkbox control in a list box
  138. Storing all the stock items everyday?
  139. How to update table from same table?
  140. Search form to pull up records with values between two numbers
  141. VBA Code to ensure data just sent to Access from Excel are not duplicates
  142. Determine if Outlook Is Open - If Not, Open It
  143. How to make visibility one item dependent on choice of other
  144. Override form recordsource with filter
  145. My Birthday reminder fails to pop-up
  146. Delete Word in Field
  147. On Load Error: Return Without GoSub
  148. I wish to use IIf statement query criterion based on whether another form is loaded
  149. query for tot
  150. Need to view other word files in an Access 2007 form...
  151. Is it possible to perform calculations on auto populated fields?
  152. Export Access Query into Excel Worksheet
  153. Sql insert with inner join
  154. how to change font color in combo box based on criteria
  155. Capture tab control page name in control on subform
  156. Sql query: If a date exists for the record add the last one in.
  157. Is it possible to use the DMax fn on multiple fields in multiple domains?
  158. Multiline textbox: next line undone when control is locked!
  159. Email multiple contacts and attach a report specific to each contact
  160. Filter not working with "Select All" checkbox control
  161. Is it possible to have flexible formatting on date in filter?
  162. How to import an Excel Spreadsheet without specific column(s)?
  163. How do I code a command button
  164. Can I write a shell code in Access 2007?
  165. The command or action isnt available now. In sub form from main form
  166. How to import filenames and their paths for a selected Folder?
  167. How do you select which mail box to send from?
  168. Date format in Access or even Excel
  169. Disable Print Button
  170. Retrieve Records from Stored Procedure
  171. How to get total of product units in a query
  172. How to extract from Dropped Records using InsertQuery
  173. How to hide/unhide textboxes and combo boxes
  174. How to import multiple access files into one file
  175. How to apply filter to count in report
  176. How to Query Partial Match from Two Tables
  177. Error: This Object was saved in an invlid format and cannot be read.
  178. File DialogBox to Import Spreadsheet
  179. VBA opening a form, want to set focus, feels like everything have been tried out
  180. Array varying length Run-time error 9
  181. Password protection
  182. Pass value to second form from button click in recordset
  183. How to loop data from different tables in access
  184. Multiple parameter query; ignore blanks & have results match all parameters entered
  185. Data provider could not be initialized error help
  186. How to create a inventory database?
  187. How to include a subform subtotal on a report
  188. Database login / security general question
  189. How to Increase Combobox Limit
  190. Recordset is locked for editing (DAO)
  191. Selecting and updating a value
  192. i am designing an application for a company where i am an intern.i need to create an
  193. Will not restore a date
  194. Grouping Query details problem
  195. Weird filtering issue regarding opening form on specified record
  196. Autofill of a field based on another
  197. dlookup not working!!
  198. How to select the next upcoming date from a date field
  199. Access 2003 database layout questions
  200. How to open a report/form using 'where' condition(X field is not null AND ID = Me.ID)
  201. Is there an "IN" statement in VBA like the one in SQL Server?
  202. How to delete record from the main table if the subtable has no record using VBA
  203. Error Inserting String Value Into Table
  204. How to show groups of 10 records on a continuous form?
  205. How could I Track record changes?
  206. Which is Better for Returning Simple Value: View, Stored Proc or Function?
  207. Binding Form to Query or Recordset?
  208. I need to populate subfield
  209. using look up table with query
  210. Looking for a MSOutlook style Schedule Control
  211. Why is combo showing wrong value ?
  212. How to find bookings per weekday
  213. How to include form data in subject of SendObject
  214. How can I count the nmber of occurances of a word in a text file using Access VBA?
  215. Error Calling SQL Stored Procedure
  216. how to populate a combo box with canned queries and display results
  217. Access 2010 - Combo Box - Value not Valid...
  218. How to create a temp table?
  219. how to visualize records higher than 999 in progressive order in Tables
  220. How do u open a form automatically after the make-table query is done?
  221. How to Set different images based on cell value
  222. Export recordset to excel unbound column issues
  223. Inserting records and re-sorting
  224. vbscript window.open type mismatch error
  225. SQL Statement - Selecting between dates using dateadd() and dateserial()
  226. Using conditional statement to enable and disable cmd buttons
  227. Sum the value of unbound control in report footer
  228. Is it possible to pass the current form's Recordset to DoCmd.TransferText
  229. referring to continuous form?
  230. setting default values
  231. Requerying Recordset Based on Combobox
  232. How can I find and replace only certain instances of a word in a text file ?
  233. How to Update Query using Total Count
  234. Data access page customising new window open
  235. Debugging help. SQL/VBA fusion
  236. Best way to handle following case?
  237. How to create departmental pricing, Adding To A Form
  238. How to apply filter when opening a form
  239. project contains a missing or broken reference to the file 'OWC10.DLL' version 1.2
  240. Sum the value of unbound control in report
  241. Socket Programming in VBA
  242. Base the value of a control in a form on another calculated control of same form
  243. VBA Syntax for an IF statement using a subform
  244. How to use a variable within SQL code that is embedded in Visual Basic
  245. How to Link SQL Server Views to ACCDB
  246. How to Cancel with option Yes No
  247. How to query results on a report
  248. Access 2003 SQL Conditional SELECT Statement
  249. Base a subform on multiple combobox selection problem
  250. VBA code for Access to email PDF Attachment through LotusNotes
  251. rebilling and repeating date
  252. Send Email based on Query?
  253. Count Working Days
  254. How to create an access database with multiple information for each employee.
  255. Stop duplicate records on table?
  256. Find and Update Recordset
  257. Hide Datasheet View Using Docmd.Openquery
  258. Concatenate function in a query - struggling with character limitation
  259. Allen Browne form filter top n records?
  260. How can I choose random data
  261. Name Fields?
  262. Using a Macro to Add a Date in Access
  263. Cascaded many-to-many form question
  264. How to Count field values with criteria in Report
  265. Verify if a text box = 0 is has nothing in it?
  266. change Indexed field to "No"
  267. Validate another control based on selection.
  268. "Search key not found in any record" Error.
  269. How to create a query showing values that are 0
  270. TableDef creation, Rich Text Field (Access 2007)
  271. How to Update record from message box
  272. Problem Emailing From Access
  273. listbox to select products and calculate the sum in query
  274. How to Duplicate Table Entries by a Quantity?
  275. How to compare two date fields for num of days difference between?
  276. How to control which colums are displayed as output by using query?
  277. How can you run a Query using Active Directory values?
  278. How to Properly Open a Recordset in ADO
  279. Calculating and recording on the table from 12 fields in form
  280. How to search database and only search for parts of cells?
  281. How to resize forms in office 2007.
  282. How can i easily create a form that will search based on criteria in multiple fields?
  283. I want to use IF and Else Funtion in Query How I can use IF and Else funtion in Query
  284. Which is the best version control tool to be used for VBA code(access, Excel)?
  285. How to undoing a TextBox
  286. Problem with the Form TextBox value format
  287. How Can I Fax An Existing PDF File Via MS Fax From MS Access Using VBA?
  288. Trying to Change a Variable in Main Form from Subform
  289. data duplication in query
  290. Dlookup running very slowly
  291. Dlookup returning unnecessary decimal places
  292. Pulling User Environment Settings
  293. Storing values in fields based on other field with checkbox
  294. How to call a form name from a lookup table
  295. How to select values using a loop
  296. Question about "Quotes (') and Double-Quotes (") - Where and When to use them"
  297. Access query help needed !!
  298. How do I stop records with same field number showing?
  299. Form/Subform interaction
  300. Microsoft access reports/queries
  301. How to Order Records in Form in Access Project
  302. how do i send a word document as the body of an email in access 2003?
  303. How to Allow Multiple Users to Open Access File
  304. How can I make a Yes/No column to select email addresses to add to a new message?
  305. Problem assigning a dynamic name for an output text file
  306. Is is possible to run a Macro & Code in 1 Event Procedure
  307. Subform RecordSource Error 3008
  308. How to make a query run when textbox updates?
  309. Character Limit on file property value returned by getDetailsOf?
  310. Error 3167 - Record is deleted
  311. How can I make my database "Read only"
  312. how to sort oldest dates
  313. How to use VBA to add Attachments to Emails
  314. Type Mismatch error after compact and repair
  315. Making a Form save hidden boxes when Append Query runs?
  316. a Macro to loop a function
  317. A Macro to select every 3rd word after selection
  318. How to Use Allow Value List Edits in ADP
  319. How do I find missing ref for User Defined Type not Defined when not highlighted
  320. Save an embedded worksheet from a bound object
  321. compare excel and access table and update changes
  322. How do I close all open query results (tables)?
  323. Create Weekly Report in Microsoft Access
  324. Character that displays as a blank
  325. Insert animated gifs on Access forms
  326. Display Print Ribbon when report is in Report View
  327. VBA Function output
  328. 2 related access tables connected to one vb form, problem with saving data
  329. Creating An If Statement
  330. Sql count query
  331. Create lower case login from 2 Upper Case Fields
  332. calculating a mark up
  333. Info Disappears from query-bound Combo Box
  334. add record from a form to a table
  335. How to do a search for like *criteria* in vba?
  336. Why am I getting "Invalid use of property" - Access VBA "Kill"
  337. multiple identical table in microsoft access
  338. a macro to create a drop-down field
  339. Form For Edit & Delete
  340. Comparison-query does not return all records
  341. How can I disable Shift key on startup - PERMANENTLY
  342. How to customize the list of synonyms in Word
  343. How to query using criteria from two fields
  344. Uniform Formatting
  345. How to check for existence of a control label (without error handler)?
  346. "You cancelled the previous operation" Error on Dlookup
  347. How to select from 2 tables in 2 different accdb (Access) files.
  348. How to delete a record using an unbound form
  349. Table Design
  350. How to update related fields in two tables by one combo
  351. Summarized Count of Fields
  352. How to add a Record Based on Existing Record
  353. how to update many fields of a table of ms access using adodb commandtext in vb6.0?
  354. What is the best time to fire an onload event in data access page?
  355. How to only allow users to select from combo but not type in
  356. How do I reset database security
  357. How to subtract values between two queries if control value is the same (Access 2003)
  358. Issues with aggreagates again
  359. SQL Query with form elements
  360. Error 2105 with Access 2007 -
  361. MoveFirst seems to be MovingMiddle.... Please help
  362. How to access random number question (Not random at all)
  363. How to import data from one form to another form
  364. Form Problem in Access 2007
  365. How to add a page break to a report once it has too many items
  366. How to use a listbox inside a subform to move through subform records
  367. Update subform Pivot table off Listbox selection
  368. Linking subreports on empty string
  369. How to export text files using different character set than the machine locale is?
  370. How do I display a chart in an Access form?
  371. Is it possible to graph in a form rather than a report?
  372. Detecting login users
  373. Data access page. Can not update sub form until main record saved.
  374. Left Joins in access
  375. Matching several criteria for date and time
  376. How can I force a yes/no box to become checked if I check another one?
  377. Help With Find Replace in Access
  378. userfriendly filter?
  379. Run time error 1004 [Microsoft][Microsoft ODBC Access Error] Too few parameters
  380. How to refer to files that reside in a subfolder?
  381. I need to use the same item - But how?
  382. Anyone know how 2 import Excel forms (+ associated VBA code) 2 Access?
  383. Setting a value of the record based on date
  384. Making some fields of the form read only
  385. Ms access data base security
  386. Advanced Login System with Admin Privilege?
  387. How can I insert NULL values in an Expression in a Query?
  388. Importing primary key numbers from an old database
  389. Problem with invalidateControls
  390. Lock bound fields in form On Load
  391. Can I DoCmd attached to a query or table?
  392. Data access pages: " this page contains both secure/non secure items"
  393. How to Trust a Network Location
  394. need help: multiple (4) dependent combo boxes
  395. Can I populate a table's record from a calculation based on entries on a form?
  396. Percetile bucketing
  397. Socketwrench in Access sample code?
  398. How to access this array in the main form when I press a SAVE button
  399. Access Partial Filter
  400. Building, dynamically created controls, Event Handler
  401. How to attach as Source control to a checkbox in a form
  402. How to move multiple columns from list box to list box?
  403. Can I use the same item multiple times on a form?
  404. If- then statement to check if input is from a lookup column
  405. What is best way to integrate spreadsheets into an access database?
  406. Re-Selecting Listbox Items following Requery
  407. Update form from other form
  408. data access page, open with blank record without killing =date()
  409. Optimizing Access queries
  410. Problem with Split() and looping
  411. How to join tables in Ma access
  412. How to format a string value in VBA?
  413. How to stop Subreports overlapping/obstructing eachother?
  414. Getting Error(#Error) in Report ... after converting Access2003 to 2007
  415. Access DB security issue
  416. Trying to do a dcount with multiple criteria.
  417. Survey in Access
  418. Variables in Forms
  419. Pausing macro execution with if condition
  420. Using Multi-Value fields in a query
  421. graph / chart from query without summarising data
  422. VBA/ Replacing data in a table
  423. InfoPath to Access Database the dreaded memo field (idea!)
  424. i would like to know an SQL statement that display sum totals, item id and item Name
  425. multi-column report formatting question
  426. Microsoft Access and VAT?
  427. Is it possible to lock portions of a table?
  428. MS Access VBA making multiple tables from one base query
  429. Conditional Formatting question?
  430. Unsafe expression security message
  431. How can I calculate combo box selections after update?
  432. outlook object library - choose a category
  433. Combo Boxes in a Form change when entering new data
  434. Regarding Relative path in Macros
  435. {Excel} Regarding Relative Path in Macros
  436. What is this Expression doing?
  437. Grouping Data based on Dates in Access
  438. How to add a Suffix
  439. I wish a message to display at a certain time in access
  440. Auto database backup/ copying a file in use
  441. Select a Specific Report to print based on date range
  442. How to narrow a recordset by date range
  443. MS Access 2007/2003 Import Wizard Maximum Number of Fields
  444. Preview multiple instances of dynamically altered report
  445. Form will only display data if the form property "Record set type" is set to Snapshot
  446. Passed text doesn't appear until cursor is in Textbox
  447. Transactions - Error Handler
  448. Need to INSERT blank field into my database from Excel
  449. Hi, how can i select multiple items from a list box using check boxes?
  450. How to access to a variable's value implicitly?!
  451. Show/Hide fields based on info in a drop down field in access 2007
  452. INSERT INTO Query Error
  453. ws rollback dosent work
  454. Inventory Database Design Question
  455. Deleted Image displayed when in Runtime but not Full Access
  456. how to deploy MS Access with SQL Server on Citrix
  457. when creating a command button in a form, I can't set the open form by specific data.
  458. Killbit killed my VBA Winsck object
  459. MSySCompactError
  460. Access Security File Problem
  461. Verify file name exist from table field
  462. Access Report Displays Number from Drop-down vs. Text
  463. Access creating its own IDs.
  464. Selected items of a ListBox become deselect automatically!
  465. Error with custom navigation record count
  466. transferspreadsheet not capturing all records in worksheet
  467. Error 3049 and 53 in Access 2007
  468. Adding Items from a Multiple Select List Box to a Table
  469. docmd.transferspreadsheet freezes Excel
  470. Parse large xml file into excel using vba
  471. How can I use VBA to retrieve a pivot table value within a query?
  472. Print report of current data on form
  473. Error message running query : Can not open database
  474. How to find the active window using excel vba code?
  475. job history table
  476. Can i use the result of a Dlookup expression for a calculation
  477. files attachment using access - VBA
  478. Allowing different input into list box but not saved for future use
  479. Pass Unbound text data to a table
  480. Updating Mainform(SubForm1 from (SubForm2) )
  481. Getting Table/Field value to use in file path
  482. Fields auto filling based on dropdown selection
  483. NonProfit project can't be completed by jarhead
  484. Asynchronous ODBCdirect queries
  485. Checking to see if a table is empty
  486. SELECT 'NOT IN' question
  487. Help in excel to access database connectivity
  488. Winsock difficulties
  489. You cannot assign value to this object - Error 2448
  490. Order by aggregate function
  491. Tyoe conversion error in update query
  492. Updating the form after "Save" button is pressed
  493. project management program
  494. Mail merge to letter in Word 2007
  495. Help on wage program
  496. delete blank row at report
  497. delete all the records in the temporary tables automatically
  498. Filter Data based value in combo boxes
  499. run time Error : type mismatch
  500. Error with command button which opens form to specific record
  501. Create a procedure that writes a sequence
  502. Do not allow the user to change the contents of the cells
  503. Restore the contents of the active cell
  504. Do not allow the other user to change the contents of the cell
  505. Query between dates issue (inclusive)
  506. Export Query to Excel File
  507. Trying to calculate on query to pull a report
  508. Coding Drop down box to copy information
  509. How do i convert a report to a PDF?
  510. Using DSOFile to get custom property for current database
  511. close access application
  512. Finding out a ListBox values data type
  513. Access 2007 Cascading combo boxes question...
  514. Format Numbers in Query Text Field
  515. Autosave Access Forms
  516. get date and time value from timestamp
  517. retrieve value from a hidden field on asp.net page
  518. Totals based on date value
  519. Display/Edit Query Results in a tabbed panel
  520. Compatibility access 2010 to 2007
  521. use DSum in multi-value field
  522. How to add a Winsock Control
  523. SendObject Command Freezes if user cancels
  524. Write Conflict.... subform conflicting with parent form?
  525. Rotate Images on Form at Different Time Intervals
  526. Query criteria
  527. how to use group by method in vba code
  528. Access 2010 data macros convert to SQL Triggers
  529. using combo list
  530. TransferDatabase
  531. Issues with Database Design
  532. Make msgbox appear ontop of a form
  533. Calculating a field for a minus total
  534. Linking two tables based on date field
  535. Check if link in a table record is deleted (Error 3167)
  536. text to date/time
  537. Subreport A does not display, Subreport B repeats
  538. Add Filters to Form
  539. MS Access Subquery - two most recent Tables results combined
  540. Cannot open MS Access '07
  541. PaywarePC integration
  542. Latest Date in a group function
  543. Count records in a dao.querydef
  544. How to search in all tables via VBA
  545. How to show a promt for any change detected in excel sheet
  546. rounding up on .5
  547. Complex IF Statement in a plain Access Query.
  548. Alphanumeric auto number not incrementing
  549. How do I sort on a calculated field in a report in Access 97
  550. How can I dsiplay the number of records on the form (same as bottom left corner)