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 122

  1. How to return multiple values from an aggregated dataset to a textbox?
  2. Search Form
  3. How can I make a combo box value on a subform based on the combo value on a main for
  4. Access 2003 Update query help
  5. Trying to use field data in Hyperlnk
  6. access report
  7. How to loop through a table, check for values, and insert if they don't exist?
  8. spreadsheet
  9. Access Database Query Help
  10. How to save an Access report to pdf with filename based on fieldname
  11. Duplicate entry warning and display data
  12. Syntax problem using DLookup
  13. Automatically creating tables from spacing deliminated fields
  14. Query Help
  15. Count Distinct in access while totaling up values
  16. How to change/alter datatype of a field from a linked table in MS Access?
  17. access in vb
  18. Software that does MS Access Data Documentation
  19. Access 2007- Find a Record Command Button on Form Doesn't Work
  20. No Current Record Error in Access 2010 while using a self join
  21. Calculating percentage with subquery
  22. Access crashes except when stepping through code
  23. Time difference from end time of record to now.
  24. Discerning unmatched query from multiple tables
  25. Calculate date when I only have the week number and year
  26. Why does my Code Work - but Only Sometimes
  27. Left Join in a subquery not working in access 2010
  28. Issues with Parameter Query Subform in Access 2003
  29. How to create report showing just the current record in form
  30. How to protect fields for passwords?
  31. Preventing a control from losing focus
  32. Filter rows on each category and reappear!
  33. How to use Input mask for general date with milliseconds added
  34. VBA project is corrupt
  35. Avoid Navigation Pane to enlarge
  36. "Variable not defined"; VBA and Intellisense using outdated table schema
  37. VBA using SQL
  38. Runtime Error '3077'
  39. How to Filter Data using a Search Box?
  40. access forms
  41. how to calculate distance based from lat long
  42. How do I make an UPDATE query with subquery?
  43. Link an excel cell to an access field by click
  44. Ribbons in Access
  45. Combine data rows on condition and delet if null
  46. Access 97 license doesn't carry over to new computer
  47. Single Criteria With Multiple Parameter Query With A Twist
  48. best way to retreive data from table to form
  49. Excel 2003 Userforms Date
  50. Insert images and chage in bound form based on each employee record using VBA
  51. How do I create a record in a table using information in form controls?
  52. retrieving query results from SQL server
  53. memo field get truncated while exporting into excel with docmd.transferspreadsheet
  54. Printing Current Page on Form
  55. Select query doesn't show all records after join
  56. Query calculations when some records don't exist
  57. Extract month and year from filename into MS Access SQL query
  58. Add a new line of list boxes in form view
  59. Multiple Listboxes, concatenate into Single Textbox
  60. Problem in Access Development
  61. Mixed page orientation with subforms
  62. How to make a local table based on results of a remote sql stored procedure
  63. finding data for duplicates in one field only
  64. How to Use SHA2 Algorithm Function
  65. Access database stopped working
  66. Print Report based on Form Sort Order
  67. Gaining percentage value from a query
  68. Proper table design
  69. Autopopulate
  70. Query on Yes/No to show all records
  71. Identify clicked record in continuous form
  72. Access forms
  73. Logic Error when using DCount
  74. Is this an array?
  75. insert into syntax error while using a variable containing quotes
  76. Blank Combo Box hair-pulling conundrum.
  77. Spooky Command Button Behavior
  78. Count the Number of Days per Month in a Date Range
  79. How to export a row from Excel and save as a new CSV file?
  80. VBA problem in access
  81. Using greater or less than symbols in query by form fields
  82. Combine Every Other line from 2 fields
  83. How to filter on an expression in a report?
  84. Resizing an Access 2010 report to print 1 page wide
  85. Why will Month() work, but MonthName() won't work in my textbox?
  86. How to alert user of data changed when adding or deleting record in SubForm?
  87. Multiple criteria access query
  88. Error 3075 missing operator in query expression
  89. Database design with different group of data
  90. Convert Currency to Text
  91. Excel graph on Access report
  92. Unable to update combo box using list box selection - error 2115
  93. Access Loop Combo
  94. Format time to display hh:mm AM/PM in the calendar block area
  95. Issue with data change confirmation using Me.Dirty function
  96. how can I have a value show on a form based on a query
  97. Extract Query from Access to Excel with abillity to Select Folder and Filename
  98. Combo box within a form
  99. Clearing checked check boxes in Access 2003 Table
  100. Access 2003 Report Printing
  101. Restricting users from main database
  102. SQL Syntax: IIF(Between (select x from a) and (select y from a),"yes","no")
  103. Calculating overtime
  104. How to insert values into a textbox in MS Access 2007
  105. Import csv into access table to update values
  106. How do I find the user name of the person currently logged into Windows?
  107. VBA Importing Data from Web into Excel2007
  108. Extract string into column data
  109. Error - Creating Report from combo-box on Form
  110. What is the best way to prevent a subform from being updated before the main form?
  111. If else end if mismatch error--"else without if"
  112. Synchronous Scroll
  113. How to Disable or Reroute Export to Excel Button in Ribbon?
  114. Iif false enter any date
  115. Access 2007 on Win 7 64 Bit - Errors
  116. Dim or Disable specific sub-menu items using VBA?
  117. Ctrl+P prints the Form not Report being Previewed
  118. Help with Database Design
  119. error " data type mismatch!!!!
  120. Populating a Field with info from another table
  121. Including text from an Access report in the body of an email
  122. How to post data from Access form into a twitter account?
  123. Find record in subform on Tabcontrol
  124. Building an Access 07 DB for logistical needs
  125. Button for Selecting an Image from a Folder
  126. How do I capture Form Variables before editing them
  127. How do I Disable or Dim Sub-Menu Items Based on UserName
  128. How i can stop users running MDB file from another location?
  129. MS Access Subform Problem
  130. Deleting an Outlook Appointment in VBA
  131. How to Create Selective Autofill TextBoxes
  132. Record Selectors Event
  133. Extract Letter From Field
  134. Subtotal in Report
  135. Multiple Conditions across 4 fields
  136. Rank calculated values
  137. Filter Function Results
  138. Can I Import Information from Excel into Linked Field in Access?
  139. How to use Date in criteria
  140. Select case with public variables
  141. display query results in subform
  142. Using a public variable as a Record Source within a table
  143. Access has encountered a problem
  144. left/right position of a horizontal scroll bar on a subform datasheet
  145. IIF (term exists in a table, "true","False")
  146. Converting Text column with a date/time to a Date column with only the date.
  147. Access Runtime 2010 intermittently CRASHED in application.printers
  148. Looping Query or Constantly running Query in Access
  149. Creating a unique id in Microsoft Access
  150. Define field name by textbox content or value
  151. Queries to Compare Two Tables
  152. Missing References for VBA
  153. From Subform, refer to a control on a Mainform
  154. trouble with FindFirst and variable
  155. how to list content of a query result in a form
  156. Getting into the backend of a DB
  157. debug Access Vba Code
  158. Wide Calendar w/Switchboard
  159. How to add Criteria 'rows' in a Query?
  160. Sql server stored procedure output parameter to ms access vba
  161. Import Specifications
  162. How do I Import Multiple Excel Files' Data Using Filters
  163. Horribly Slow Query on Large Linked Table
  164. Update Query Using Min(Date)
  165. Report Width Stuck
  166. Field with Text format needs to be converted to Short Date Format
  167. Ms Access has stopped working?
  168. Creating a Unique Employee ID
  169. E-mailing excel files from an access module
  170. Adding password to exported excel files from access
  171. Problem with an Update statement
  172. Calendar Thread - Where does the Code tell the DB to put Info in "dayblock"
  173. How do I Pass Values to Forms
  174. MS Access 2003 - Can't View Database Window
  175. Command button to open a form meeting two WHERE conditions by Expression Builder
  176. How do I use MD5 hash class module
  177. Why printer properties change in Access reports when appl is run from different pc?
  178. Vary label BackColor and image in continuous subform
  179. How to edit and update recordset
  180. How do I Use DLookup() to Check a Logon
  181. Counting names by first letter of alphabet
  182. How do I Ensure Value is Entered Before Proceeding
  183. Trying to obtain a public declared Variable in a Form
  184. How do I Avoid Error 3021: No Current Record
  185. how to display names in Combo Box as you type...
  186. Use Unbound Text Box to View/Import/Update Record in Access 2007
  187. How to Combine Entries from 2 Separate Tables
  188. How do I Count Only DISTINCT Values of a Field
  189. How do I write a query expression with MAX?
  190. Error running DoCmd.RunSQL
  191. populate a field with 'yes' after you enter a date in another field
  192. SHA1 Hash for Access/VBA
  193. Sub Form do not show records
  194. Edit record in cross table query
  195. How to lookup data from a "lookup form" to a subform within another form
  196. Having trouble with Append query
  197. Login form for MS Acess Database
  198. If item selected from dropdown activate check box ?
  199. delete non matching records access 2003
  200. My date field displays pound signs instead of numbers
  201. Syntax error (missing operator) in query expression...
  202. How do I Write Expression to Convert 1,2,3 to String Values
  203. Multiple Criteria for an IIF Statement in Access
  204. Easiest way for user information and user entered values to populate table?
  205. VBA Access display label
  206. How do I make a form show up when I am exporting from access to excel?
  207. How to set form textbox default value by event using INSER INTO statement
  208. How do I disable toolbars but allow copy/paste right click?
  209. Copying form data into a table
  210. How do I Make Control Required
  211. How do I Mandate the Tab Order for a Control within a Subform's Form
  212. Cascading ComboBoxes
  213. Excel: How do I Refer to a ListBox Object in a User Class.
  214. QueryDef and recordset using parameter on forms
  215. Use variable to set label backcolor
  216. Keyup/KeyDown/KeyPress events in Access SubForm
  217. How do I Check if Periods Overlap
  218. Combobox Showing unexpected conjoined data
  219. the expression you entered has a field, control, or property name that...
  220. Populating a listbox from a formatted array.
  221. Why is the "sunken" special effect disabled in Windows 7 and how to fix
  222. Why won't my query work when I add the sum function?
  223. How can I check if my highlighted field is selected !
  224. filter data in textbox based on criteria
  225. How do I find Error in my Database Design
  226. Too few parameters. Expected 1
  227. How to create a summary report of all queries
  228. Whats the proper way to use an external DLL?
  229. Access cannot find object "*"
  230. Customized ID Numbers
  231. Decimal value problem in access 97 Report
  232. Why won't my combo box go to some records but not all?
  233. How do I do a query with the criteria being all values in a combo box?
  234. Conceptual question on table design
  235. Create a link to an Access DB - opened to specific form and record.
  236. Access error: parameter value for field
  237. Copying an existing form
  238. Looking up Data in Access
  239. Flagging a range in Access
  240. Use a control on a Form as the Record Source for a control on a Different Form?
  241. Stop User From Opening MDE File Twice
  242. Conditional Format in Report Limit
  243. warn before entering duplicate records
  244. Ms Access Err - Run-time error '3027': Cannot Update. Database or object is read-only
  245. How to add leading zeros to value in listbox
  246. How to insert computed value in listbox on a per item basis
  247. How to flag records based on certain reporting conditions?
  248. Sync outlook contacts linked table with universal table
  249. subforms based on main form field
  250. How do I Find Count of Matching Items
  251. Help with Subform and GoToLast command
  252. Any way to populate table fields by dragging down values from previous record?
  253. How to Clear the Debug Window
  254. Copy Report with Filter
  255. limit answer in access calculated field
  256. Double Click event and loading a form
  257. How do you set a variables for controls in a subreport?
  258. Filter Loop with OpenReport
  259. Delay Display in Access Reports
  260. linking data in 2 fields
  261. Display text on a form based on a combo box
  262. IIF(OR possible in Access?
  263. view excel sheet in access every 3 min
  264. How Do I Convert a Date in Access to a Serial Number
  265. Pass Value from One Form to Another
  266. Form based on LookUp Field
  267. Access. MultiSelect for dummies
  268. Nested If with DateAdd
  269. Access Database - Date Stamp when field populated
  270. Edit forms in a front end database.
  271. MS Access total the results of a query
  272. Excel: VBA Copy Files from One List as Another List
  273. Different spreadsheet in one Excel from one query
  274. Set CheckBox Values From Other Tables
  275. Formula to figure hourly pay
  276. Running a query and referencing some of its values in VBA
  277. How to use keydown with code and cancel on completion
  278. Open a form based on a value associated with text in a field
  279. Data Prompts from Report using Access 2007
  280. How to import sharepoint data to Access using macros??
  281. Attachment Field on forms only works in admin mode
  282. How can I center Access 2007 switchboard opened to full screen?
  283. Access Search Form
  284. Filtering trouble with Access Report split into mutliple PDF's
  285. MS Access Switchboard
  286. How Do I Link Two Tables with Only a Partial Match
  287. Open scanned document from access form
  288. Access Filter Report with Field Name
  289. Excel: How do I Skip Blank Cells
  290. Combo box Access
  291. AfterUpdate to populate field after data entry into two other fields.
  292. Dbl click a form field to open another form based on value
  293. how to ignore # when export hyperlink from access to excel?
  294. Data Entry in Access ( Monthly Flying Hours)
  295. VBA ODBC Connection through proxy
  296. Remove items from combo list when used
  297. 2101 The setting you entered isn't valid for this property
  298. Combine two fields into another field within SAME table
  299. How to trigger an event when a table is opened or a field updated?
  300. Date Format query in Access for SQL database
  301. How to split a list of random numbers equally
  302. Access 2 Fields Relationship
  303. VBA Argument Lists
  304. Expression to count number of times event occurrs
  305. Error: Can't build a link between unbound forms
  306. Department Count in report header/footer
  307. Create a dynamic listbox which gets updated on the basis of user input
  308. syntax error, missing operator
  309. delete duplicates after import
  310. Inconsistent ImportXML Runtime Automation Error
  311. Keyboard move after enter
  312. Disable a Button If a Textbox is empty
  313. Can I use a button on a form to save and go to new record at the same time on click?
  314. Help on complex IIf statement please!
  315. main form mouse wheel scrolling disabled when subform control is active
  316. Help with the "BrowseTo" command
  317. Subform leaving a blank row after requery
  318. pass through parent's foreign ID to child table
  319. Can two image subforms use the same module?
  320. Browse for a file from a Form
  321. MS Access File Read Only
  322. How do I display additional hidden choices when a selection is made?
  323. Event proc using vbYesNo with if then statement
  324. VB and MS Access
  325. Multiple Items from Multi-Select ListBox into TextBox
  326. Find the missing numbers
  327. Subform datasheet: select one record to update form?
  328. Return from MsgBox to Form Stalling
  329. Table autonumbers in a Query
  330. access form control source automatically changes to expr1015
  331. Colon as a Delimiter
  332. Equation in a Form not Transferring to Table
  333. Save does not stay on current record in access 2007
  334. MS Access A Different Between Dates Problem
  335. Creating something similar to a Pivot Table in Access 2007?
  336. Page Header in 2 Column Report
  337. Bind a form with data from a table in another database?
  338. Search text fields for keywords given a priority list
  339. Using an EXISTS function to determine if a column exists in a table query
  340. Need to calculate a number of values and display values to user
  341. Generating a query of top n by sum of a variable
  342. MS Access - Writing SQL to count for conditions
  343. Access on a Mac
  344. Setting ControlSource in VBA (Syntax Problem)
  345. Syntax Error in Query
  346. How do I Produce a Running Sum
  347. reference to field on form via a query - not working
  348. How to use a variable for field name in vba
  349. Subquery help 4 queries produce one results
  350. Text to Number, then sum in a query
  351. SetFocus in a Find Command Button (Access 2003)
  352. EXCEL -vb - Spin Button - Focus
  353. How do I use an IIf statement in an update query?
  354. How do I Access all the Past Email Addresses I've used in Outlook 2007
  355. How do I delink tables
  356. How to hardcode order by
  357. Convert SQL code to VBA code
  358. Do while loop find value and update another table
  359. Display only Top / Max Revision
  360. Custom report detail showing blank space
  361. Autopopulate Linked Field for Subform
  362. Parameter syntax error
  363. 3705 "operation is not allowed when the object is open" in vb6 + ms access
  364. How to fix code for Run-time Error 52, Bad file name or number?
  365. Change background of Web Browser Control
  366. Access database for Crystal Report Graph Summary
  367. Access Sum If help
  368. Line Feeds In Text Box - How to Enable?
  369. A dynamic ribbon dropdown?
  370. How do I Make ComboBoxes Visible in Report Header
  371. Multi Report selection
  372. How do i add Live video streaming on a form
  373. Table with only one row
  374. Copy and pasting entries from one sheet to another based on Column Value
  375. Can I push from Access to MS Project (with error checking)?
  376. Northwind 2007 database
  377. Make Access db trialware
  378. Ms Access - How to use query to track employee weekly attendance
  379. Form Filter doesn't work for all data
  380. Best Way to Sync Parent Form With SubForm Filtered Records
  381. about date add in access
  382. Problem with exporting text files to system folder in Access 2010
  383. How can I count unique values in a report?
  384. Best way to handle A4 and letter paper size
  385. Text Box appearing after Combo box selection is made
  386. Hiding/Unhiding form from menu bar and by clicking a button
  387. Hyperlink default folder
  388. Best Way to Connect to Oracle Database from MS Access
  389. How to update one field by summing two other fields
  390. access 2010 username and passwords
  391. records affected by synchronization
  392. Access 2007 - write a report to a PDF format
  393. Maybe Array? Check for a block of numbers within other blocks
  394. Works in Access 2007 but not 2010
  395. Different Languages(Fonts) in same field in Datasheet view of Subform?
  396. How do I use VBA to Swap Data Between a Field in Two Different Records - Access 2003
  397. Setting textbox width in VB
  398. How to Print Selected Record Only
  399. How to find current backend file and rename it with VBA
  400. Repeat of row parameter
  401. How to apply code process to all forms from single onclick
  402. Protect my work
  403. Duplicate records from one table in a query
  404. Procedure Too Large Error
  405. How do you map Access fields and Excel columns before importing
  406. Syntax Error in Query Expression
  407. Microsoft Access - Formula help
  408. how to give a textbox value taken from calling form
  409. Export data from Access to Excel
  410. add working days in access 2007
  411. How to add VBA filters to reports
  412. Problem with ConcatRelated() Function
  413. Connecting to a SQL database or Linking
  414. Need a function to select a file, before importing from Excel
  415. Select a record from a report OnClick using vba
  416. Data Entry Using One Control (ComboBox)
  417. MSAccess Freezes and suddenly unfreezes.. not sure why
  418. Access Code in showing values of combo box to a report getting from the table/query
  419. How do I Set or Clear the Visibility of the BCC Field in a MailItem using Outlook VBA
  420. Creating multiple Excel sheets (same workbook) from Access
  421. delete from multiple tables
  422. "Save As export:" function to have the option of naming the file before exporting.
  423. Replacing character with non-printing character
  424. Calculating percentage (%)
  425. How do I export multiple queries ?
  426. How do I get my strSQL criteria to work in a if then else statement?
  427. How to get Query to Filter/Count in Table
  428. How do I make months appear to be like 1-12 (first year of my database) and so on?
  429. Image missing in HTML view in Access 2007.
  430. How to transfer a 2d array into a table
  431. Duplicates in a query
  432. setting date format.
  433. Create string from selected controls on a form
  434. Union Query to select same tables from different databases?
  435. How to Use SQL Server 2008 Database as Back-End for Access 2007 Database
  436. Select All column with Distinct on two column
  437. Why doesn't my count field work?
  438. Invalid procedure call or argument
  439. bypass odbc connection
  440. How to change/update records in a query?
  441. Invoice Print Preview
  442. Loop then string form responses
  443. Access 2007 multiple queries to specific Excel Worksheet/cells
  444. Is there a way to calculate % in a query?
  445. Help with Database Design
  446. Deleting records from just one side of a join
  447. How to Synchronise Parent and Sub Forms
  448. Looking up / Searching for a record in a form (to be displayed in another form)
  449. How do I assign a default date value to one control based on the date of another??
  450. Form Conditional Formatting Re-evaluation
  451. How Do I Reset BorderColor of a Control?
  452. AfterInsert Event not Triggered as Expected on Pasted Records
  453. DMax Function Not Responding on Pasted Records
  454. memo field in form will not allow unlimited text entry
  455. SQL Connection String in VBA
  456. Outputto error when trying to create a PDF
  457. How to I create my Export to have "Save Exported File As:" ?
  458. Have a query prompt for input on different fields based on which button selected on
  459. how can i make a help file?
  460. Increment field in Query
  461. Help finding the Median using MS Access
  462. Join Expression not Supported in Access 2000
  463. Access 2003; Can I use a combo box to generate a text field?
  464. To populate listbox in subform from value selected in parent form
  465. How to Export into Multiple Worksheets in Same Workbook
  466. How to display Current Year in formula WITH dates that are blank
  467. Pause TimerInterval Property in Access
  468. Pull date that is less than or equal to another date field
  469. How to show entered criteria from a query on a report?
  470. Using different versions of Access on the same database
  471. Concatenate values and group by sectionID
  472. count number of rows related to another table
  473. Exporting Access Pivot tables to Excel
  474. truthlover calendar
  475. Access exporting wizard`
  476. Cannot add fields to a table
  477. Using replicas with mixed 2007 /2010 users
  478. Running Total in query
  479. CrossTab as Record Source for a Subreport
  480. Opening 2nd database speeds print report by 3 x
  481. Help with update query
  482. How to create Year to date totals for each row item in an Access report
  483. Transferring data from form to table
  484. Criteria in a dlookup to look at part of a cell only
  485. Access 2003 form-copy address tick box
  486. Using MOD to see if numbers divisble by 6
  487. Records in a table
  488. How do I count the number or entries in a certain month?
  489. How can I change this code to update a table only on the last of a series of entries?
  490. Identify Ties
  491. Data mismatch message
  492. title and pathname in Word (office 2007)
  493. Display a countdown Timer on a report
  494. SQL WHERE Query
  495. How can my form allow the user to select fields to sort on?
  496. Check box automatically checked if certain fields in the table contain data
  497. Prevent data field movement in subform
  498. How to edit an existing record instead of adding a new one using VBA?
  499. SELECT TOP 3 Within a GROUP BY
  500. Finding the size of a variant
  501. How to filter a current date in a query?
  502. How to Suppress UNC Replacement in Hyperlink Objects
  503. Record Performance within my Database
  504. Auto fill date question...
  505. InputBox to select records
  506. Printing current form record
  507. passing an input from one query to a subsequent docmd.OpenForm
  508. Insert records into table using result of a query
  509. how to add 1 minute based on previous record in same field in access
  510. SELECT Record From Group With Max Value
  511. Cascading ComboBox Issue
  512. referring to a control
  513. IIf statement problem
  514. Suddenly receiving Error #3270 - Property Not Found
  515. Time and Attendance in Access 2007
  516. How do I use a query to "add" two text fields together?
  517. Database has been opened as read-only...
  518. "invalid sql statement expected 'delete' 'insert'" (Query Problem)
  519. Time trigger doesn't work
  520. Is it possible to take input data from criteria and use it to replace name of a pdf?
  521. Error when emailing a parameter query report
  522. Syntax Error
  523. How to update date when doing record updates
  524. Ranking number
  525. Access database replication
  526. Access 2010 Ribbon - Disable Design View?
  527. What Criteria to enter for a field "Service Date" and filter by this date and after?
  528. Summing Values of a Subquery
  529. How to Restrict access to tables in MS access if they are not an admin
  530. Why won't my "requery" command sort the results?
  531. Ranking within Access
  532. How do you login with your NTID username and password
  533. Path File Access 75 error on Open strHTMLFile for Output As
  534. Randomizing records retrieved from a query
  535. Code Help to make a Check Box Functional
  536. How to remove stock from inventory using values from another table
  537. checking data entry with multiple conditions
  538. Using query criteria to look at two different forms
  539. Select columns based on user input range
  540. where to get icons for forms?
  541. Snake contents of a field across and down 3 columns in a sub-report
  542. How do I Reverse the Format of a Date
  543. How do I let a CheckBox make a TextBox Visible
  544. prevent changes to control on combobox afterupdate
  545. how to select only checked box records for labels?
  546. Criteria for Query in code instead of query itself
  547. VBA code to look in table and open form
  548. Create link from access to outlook to open a specific form and record
  549. How to get cascading combo boxes to work properly?
  550. create a recordset then count the number of records