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. Send return to a form field from VBA
  2. Loop not reading last record in Query
  3. Passing a date variable to an SQL stored procedure
  4. how to duplicate a record which is selected by a query using a button
  5. variable uses an automation type
  6. Is it possible to disable the CTRL-A key in Access 2013
  7. Filter a query, based on multiple lines of text entered into a text box.
  8. OpenReport using a field name from a query
  9. Need a msgbox to display when a record is not found
  10. Updating MS-Access Table using SQL Query
  11. Email Report using Send Object and recordset
  12. Application Focus Lost when returning from Access Modal Dialog
  13. Message box to alert if changes are being made on a form/subform
  14. Parameterizing top N in query MS-access 2007
  15. Add pictures to an access report for parts where pictures are store in a directory
  16. Report from the Switchboard will not print
  17. If Then Statement Looking at a Field with Multiple Values
  18. print a ms-access 2007 report on an image in memory
  19. Is it possible to create a message box in a macro to display comments but not require
  20. Fingerprint database interpretation
  21. How to move multiple records about same person to one longer record?
  22. MS Word Drop-Down List with MS Access Data
  23. Display zero as dash on form while retaining the value of zero?
  24. Choosing between subreports in a report
  25. Disabling Close Button Temporarily
  26. Join Table to another Crosstab Query
  27. Dynamically changing the control source of a field
  28. How to Lock Form only excluding subform TabCtl in Allen Browne's Locking Bound Contro
  29. Trying to combine two pdf using access vba...
  30. Automating adding attachments to email based on MS Access query
  31. Clear Form Fields and ReQuery
  32. Issue with locked multi value comboboxes
  33. How to generate sequential code
  34. Writing an IIF Access statement with an embedded IsNull statement
  35. Looking for an efficient way to build a report
  36. crosstab query dynamic colums date range in days
  37. Undefined function 'Date' in expression.
  38. Retrieve table name from a list box rowsource
  39. How to loop through a dynamic jagged array?
  40. lookup
  41. iif statement involving a check box
  42. Pulling unique values from a query to use in a form to run a report...
  43. Trying to change data type from number into Autonumber
  44. Passing a recordset to SQL
  45. Error: No current record (with array)
  46. Microsoft Forms 2.0 frame - adding images
  47. Need to get rid of the green color"the number in this cell is formatted as text"
  48. Optimum Batch Size Selection
  49. Find Records in Main Form Based On Subform Data
  50. Include fields from 2 tables on single form
  51. Strip Ole Object header and get picture out of it.
  52. Getting a table name from a listbox/combobox with variable tables
  53. count filterd records
  54. Setting the Value of a Checkbox with VBA
  55. Stumped by the Calendar
  56. Unique Identifier
  57. How to ignore certain Customer Numbers and increase a certain kind incrementally?
  58. Single value INSERT from code produces no result
  59. BeforeUpdate Issue
  60. Loop through the cell and give the anser
  61. Minimum Value (Date)
  62. Total hours in Report over 24 hours
  63. Invoking Crystal Report from Access 2007 causing error
  64. Running a stored procedure from Access to populate a local table
  65. Changing date format In MS access from d/mm/yyyy to ddmmyyyy
  66. Help writing IF/ Else statement in Access SQL query
  67. MS Access returning a value from a stored procedure
  68. Embeded Macros or Events
  69. Handling multiple units..!!
  70. Troubleshooting NonOutlook Email Code
  71. Insert logo into E-mail from Access VBA
  72. VB Code to create email from different outlook templates
  73. Possible Coding Problem - Need Help
  74. Dir() giving odd results
  75. To repeat a record 'n' number of times
  76. Store different groups of multivalue lists in a field of a table in MS Access 2013
  77. Return the Greater of 2 Dates in a single column
  78. How to use Input Mast in SQL Statement
  79. current record lost
  80. Passing an entire array to a query
  81. Auto Number Module for Query
  82. To Quit or not to Quit
  83. adding new record using VBA into existing access database
  84. bank holidays on Monthly Calendar
  85. Transfer MS Word Form data to MS Access Tables
  86. Part 2: Macros/VBA created in Access 2003 not working in Access 2013
  87. Combo box linked to foreign key displaying field in primary key table?
  88. Ranking on multiple fields
  89. how do I force the first letter to be a capital letter in access?
  90. ms access 20103 filter or search cannot support khmer unicode
  91. Module Compiling Issues
  92. Repaint onCurrent not working
  93. Macros/VBA created in Access 2003 not working in Access 2013
  94. Problem with running balance
  95. Select Case Help
  96. unique comboboxes
  97. global Database
  98. VBA Module(Access) exe32-not-closing-in-task-manager
  99. How can I get a VBA module to export the results to Excel
  100. skip duplicates
  101. Expression
  102. open query or report with docmd
  103. work with two recordsests
  104. Records Incomplete status
  105. How to synchronize a main form with its sub form
  106. HHCtrl.Ocx Errors in Rich Text message Box
  107. To control excess Inventory Posting
  108. empty recordset
  109. print form
  110. how group dates to min groups
  111. filterd continuous form
  112. how to make "12/02/2016 6:00" as "12/02 6:00" thanks! ;)
  113. Inputbox in Access Report to open only once
  114. Combo box that stores values in multiple fields.
  115. Union or Otherwise Combine Multiple Delete Queries
  116. Appending Consistent Number of Blank Rows to Report
  117. Who is logged on to BE database?
  118. Linked table in BE Database
  119. Structured form
  120. Access 2010 Transpose Help Needed
  121. Hide a Row @ Report ( Access 2010 )
  122. VBScript import data table Employee using odbc connection and save as msaccess data
  123. Macro is failed to find specific record on the second try - Access 2013
  124. How to sum up the time more then 24 hours
  125. copy selected part and past in other field
  126. Query two tables and duplicates with wildcards
  127. Unable to get results using criteria in same field in multiple tables
  128. Transpose data while repeating the Product Names
  129. 2501 SendObject Error - Error Trapping Not Working
  130. Make search result records clickable
  131. How could the ESC key triggers private sub( cmdCancelRecord_Click()-for example)
  132. How to Count the number of fields in a form when form is updated or filtered
  133. I need a code to enter "1" into a field in my table when a toggle button is clicked i
  134. Auto fill a field in unbound sub-form datasheet
  135. How to filter using combo box
  136. What is the code to open a new form upon a commandbutton
  137. Moving an Excel formula to calculated field in Access
  138. Any suggestions of where to learn Access?
  139. How To Continuously Update an Excel Spreadsheet at the end of each shift
  140. MS Access Datasheet Views with a different look
  141. How can I export multiple files from a single table using a field name as the file na
  142. Who is logged on?
  143. how to get result in year month and day between two dates?
  144. Controlling Excel through Access VBA
  145. VBA - Random Cell Filler from String List
  146. Instr not working ???
  147. VBA Create Delete relationships
  148. How do I fix my too many fields defined Problem?
  149. Excel to Access
  150. Access beginner: Have Access show prompt window when duplicate entry already exists
  151. Complex join problem
  152. Need Help on Various Small Issues
  153. Table showing number or records in each report for each day
  154. auto complete
  155. pass paramter for recordset
  156. Can't see memo fields lists as available for combo box
  157. Enter a text from Form to another Form
  158. Automatically create records between two numbers
  159. How do I calculate overnight hours in Microsoft access?
  160. Easy Update Option Group
  161. Code found not sure how to use it exactly
  162. Attachment Fields - How to Query Them
  163. Multiple back ends, single front end
  164. How to compare 2 tables to update price and to find extra parts in either table
  165. How to make your form browse through records on your table?
  166. Problem with listing recent opened records
  167. Gmail via CDO with clickable button
  168. how to view large preview of an attachment?
  169. Run 64bit MS Word from 32bit access
  170. Date format from VBA Added to Table not correct and date is changed.
  171. Why is the first record of my subform not saving?
  172. why is my cursor in my subform on the first record and clearing it
  173. Is it possible to set the value of a yes/no field based on dates?
  174. Count Iif with Not Like in Access Report
  175. Invalid Character when exporting to XML
  176. VBA Date Problem
  177. Form to filter reports
  178. Open Report based query which based on Values in Form
  179. Rich Text Message Box Cursor problems.
  180. Result of DAO expression visible as a new column in a table/query
  181. How to determine that any report is active/open or not?
  182. How to add a custom command button tho the default shortcut/right-click popup menu?
  183. Unstable Access
  184. Show a tab of a custom ribbon in ms access only when a report is opened...
  185. How to filter list box so it eliminate items selected before
  186. Access Form is becoming selective on fleld data it adds
  187. email link in field only working on 1 of 3 forms on same database
  188. Problem with Union Query
  189. Get RecordSource of closed report.
  190. Applying payments to invoices to report outstanding debts
  191. Numbering duplicate StockCodes
  192. To create students attendance form in access 07
  193. non standard text import
  194. referencing a non-bound column in a combobox in a macro
  195. Bad Outlook on Access
  196. Report Filtering: How do I Manage 100s of Filters?
  197. Macro/VBA for selecting a value from a bound combobox
  198. Reporting on single gift and cumulative gifts
  199. Leading zero's variable number length and variable number of leading 0's
  200. How to create an in form Calculater
  201. convert Multiple rows (same name) that have many collumns of data. convert this to 1
  202. Characters truncated when using Allen Browne's function "ConcatRelated"
  203. working with external databases
  204. Clear Contents of unprotected Specific Range in a protected sheet
  205. Removing Blank Cell info when save as xml data
  206. Joining Multiple Tables with "LIKE" Data
  207. Reverse page printing
  208. Report page chronology is not maintained with the data table
  209. Program Crash
  210. Update query - missing table field name drop down list
  211. Multiselect list box as query criteria?
  212. Has Anyone Attempted a Report for a Class Attendance Log?
  213. Report - Sort by Percent of Total
  214. Open file like textbox entry
  215. Problem with updting forms
  216. Format zip code in numbers
  217. Basing a query of a text field and combo box in a form
  218. Hyperlink Problem
  219. Convert
  220. Keeping historical Records based on the changes one field
  221. multiple Dlookups for looking on values in multiple tables
  222. Specific Query not loading after bloat
  223. Setting Automatic Dates from a roll in Interval
  224. Finding a piece of code
  225. how to consolidate or merge two rows of data into one row in query result
  226. How to merge tables?
  227. Need help with combo box loop/open report
  228. MS Access text field in form is autopopulating but shouldn't be
  229. Date() not recognised
  230. best way of doing a double query?
  231. How to open Access from the old drive?
  232. Help! I am trying to share a database between 10 users
  233. Subform linked to 2 separate tables
  234. Can you put a button and a toggle to lock and unlock for a certain field in access
  235. Call Tracker MS Access Template
  236. MS Access 2007: 15 years Of Contract
  237. Syntax Error in data validation
  238. Search form with combobox
  239. Elegant way of getting multiple results
  240. MS Access database grow issue
  241. Updating an open form after entering new records
  242. Filtering a report from a sub form
  243. Help with counting visible rows after filter in excel
  244. Filtering Table field in Form using Check Boxes
  245. Group by data found in multiple fields
  246. Need help with SQL statement for copying subform data to a new table
  247. Tab Control Loses Sections after Switching Pages
  248. Properly creating a form without using a subform
  249. Using a Form
  250. Optimize Query
  251. Selection Criteria using multiple combo boxes on form witha subform
  252. Excel backend database and HTML frontend
  253. Database search form / query not sure what I need
  254. multiple search in a single field
  255. Auto birthday reminder in access 07
  256. query with more than one table
  257. Textbox Calendar Limiting
  258. Checkboxes in Forms
  259. Text box in Access report with controlsource from form only shows up on first page.
  260. Expected line or label statement or end of statement
  261. How to calculate the number of working hours each month in a Access query?
  262. Copy field contents to another field based if a totally different field = true
  263. Copy field contents to another field based if a totally different field = true
  264. Cursor position in subform
  265. Cascading comboboxes does not allow selection of all values
  266. adding hours + minutes with dateadd function
  267. Database diary, start of the week is Sunday how to change to Monday
  268. Run Time Error 3075 in my SQL Insert Into
  269. Is there any alternative way to write this query because it causes ms access to stop
  270. Function and Nested loop
  271. How to remove quick access toolbar from access application
  272. Lookup field linked to access database not refreshing
  273. Daily Number and Date
  274. How to remind the user to re-enter the correct date
  275. Code to replace SendKeys in My Code
  276. Update a Field in One Table if There is Data in Another
  277. Access 2013 Runtime
  278. Help about Round() function
  279. Subform doesn't show any records
  280. Send SMS via Access through Internet?
  281. Help in report
  282. dcount or DAO.recordset?
  283. How to open a record inside a horizontal tab with a subform in it.
  284. I need help with Microsoft Access
  285. Validation rules for two clculated fields in a form
  286. calling a sub from another sub and assigning value
  287. ComboBox modification of Table
  288. On.Click button updatte field in open form
  289. AES Question - VBA/Excel
  290. Invisible tabs in Access 2013 runtime
  291. Form not accepting data entry (sporadic)
  292. How to Select the Highest Number or Date
  293. How to Display Intermediate Cumulative Sum By Page Footer
  294. "Make Accde" fail...
  295. Table Loop and New Column in the same Table
  296. Code Worked as Macro but not completely as VBA
  297. How to Reset a report back to default state before closing report
  298. Passing a PK to another table
  299. Changing MDI Background in Access 2010
  300. Sharing a Microsoft Access reference with multiple databases
  301. Export data from a split form to excel or pdf...
  302. Declaring API functions in 32 or 64 bits
  303. Please help me with recordset!
  304. VBA to Populate Table (Update)
  305. If statement to run Message Box
  306. Membership database - need to update usage with Check In button
  307. Error using script to select and print reports in Access 2007
  308. Search function using multiple non-consecutive keywords
  309. SQL query in ms access VBA creation from MS Access Form using Multiple Table Fields
  310. Missing operator in query, DLookUp()
  311. Advice on Normalizing Database
  312. Multiple If statements
  313. Looping an OnError until duplicate error clears.
  314. Format Autonumber
  315. update multiple records
  316. Filter A record with date lower than MaxDate
  317. Using a command button to change state of a value in a field
  318. Countdown box on a form
  319. Aggregate functions
  320. Display a Number from a Report into a Text Box
  321. How to display SQL query results
  322. Many to Many Database - Displaying query results as one entry with multiple categorie
  323. Call calendar from code.
  324. query Double Id's on partial match
  325. Counting values in a table row
  326. Populate form from specific cells of table
  327. 2015 was a year with 53 weeks
  328. Separate month and year input to become one field
  329. Relating a primary key to two fields in another table. Can I then query either?
  330. Changing Lattitude and longitude specficness
  331. Show Multiple Columns from ComboBox on Report
  332. Force my Database to Open with Runtime Only
  333. Data entered via a Form not "sticking"
  334. Query, to obtain only last record from child table.
  335. ListBox Sort Records - With out using Command Buttons
  336. Random selection of questions from tables.
  337. Grouping time in intervals using Partition Function
  338. Daily Averages Crosstab, non-standard day
  339. Using last date with beginning and ending date
  340. Else with out End If Error not clear.
  341. Create table in Word Document From Access using VBA
  342. Combobox to fill Listbox
  343. Adding a field to existing table in access using vba
  344. Access 2010 run-time error 3201 cannot add or change record
  345. How do you reliably use RecordsetClone function?
  346. Button to fill field for report
  347. Using one access form column to filter another.
  348. Open blank form (dataentry), but have existing data still searchable
  349. Crystal Report parameters with discrete value dialog box pop up.
  350. Error when testing condition of CheckBox
  351. I cannot get this Access query to run. Can anyone help?
  352. Update data automatically in form.
  353. aggregate / subquery help
  354. Preventing Duplicate Entries in a database
  355. Button to fill Word Document
  356. I need a solution similar to the Microsoft Customize Quick Access Toolbar dialog
  357. Search Form
  358. Yet another insert syntax error 3134
  359. Clear Command Button then Requery Subform
  360. Extracting data form HTML using vba in Access
  361. Declaring a variable used in multiple reports
  362. Tree Code (Element not found error)
  363. checkboxes on form to run query
  364. Click a button and search a query based on item in datasheet
  365. how to make a query doesn't show the records (null) ?
  366. Checkboxes and BeforeUpdate Event
  367. Create a Standalone Access Database
  368. Automatic update of data to minimise errors
  369. how to combin two tables ??
  370. The object doesn't contain the Automation object....
  371. add fields to a form from a table with criteria
  372. Order/Stock Control Database System
  373. Comparing Related Records
  374. Cancel SetFocus on Text Field When Hitting Exit Command Button
  375. Displaying Records in X Rows and X Columns on a form
  376. In VBA Access receiving a feedback from the printer that report page # is printed out
  377. how to only show the records that entered today???
  378. Sum Across Columns in Crosstab
  379. mousehook dll is missing the program to fix this problem
  380. how to filter a certain record to view in a report ??
  381. how the access report shows only the last record in the table ??
  382. How do I count gender if a checkbox in another field of a table is checked in access
  383. How to lock textbox after the file is loaded on it
  384. Normalizing a database for the first time.
  385. how to view report single record per page
  386. Send 2 Queries in 1 Email with DAO recordset
  387. VBA Code to verify data
  388. Complex Search for words in descriptions
  389. Why does VBA code work after "Save" but then not after Exit?
  390. Syntax for the table to get the bin code and qty
  391. MS Access 2013 - Custom Ribbon won't work
  392. how to filter report based on the list you selected from listbox in a form?
  393. How to assign an Outlook task with Access
  394. Inner Join Openrowset in VBA for AS400
  395. Export Query to PIPE delimited text file
  396. How do I set a query's "Use Transaction" property to NO?
  397. programmatically update linked table locations?
  398. Read Log and assign Logout time
  399. How to add details from form to existing row in the access table?
  400. Calculating Project Hrs to Employee
  401. Using Recordset to edit a table
  402. Simple login form w/ different permissions?
  403. Subform report with parameters
  404. Query not updatable...
  405. Update table in as400 using table in excel worksheet
  406. error 3048 can not open any more databases ms access query opening
  407. Inmate Confined List Hide Old Records from Current Ones
  408. Drop feature of the Hyperlink box not working on form in MS-Access
  409. calculation fields acts abnormal
  410. delete reverse duplicates
  411. Does anyone have a favorite Units Conversion Function written for VBA?
  412. Row Source Query in Navigation Subform
  413. How to update/replace values in one table with values from another?
  414. Print button set to default printer setting
  415. How to find a record containing latest date?
  416. Join multiple tables with a query?
  417. Display current records from Continuous form in Report
  418. Exclude carriage returns from expression if they are not needed?
  419. How to change combobox query on click?
  420. Ignore blank columns and line space in query return?
  421. Adding a subform to a Data Entry main form... subform greyed out
  422. Auto log users in w/ AD credentials?
  423. Like operator with unbound text boxes
  424. Separate table for IP Addresses??
  425. Importing data from multiple Excel Worksheets
  426. Dlookup works on all forms, except one.
  427. Report Filtering Issue
  428. Expanding a number range from AC data entry form into table
  429. My iif statement won't work in access - trying to write a simple iif statement
  430. how to convert text to number in excel query
  431. dsum returns null value in a text box
  432. MS Access Calendar - Need help with parameters
  433. modify a form and subform
  434. Select lowest two prices from item list grouped by item id
  435. Only One Record Showing on Report
  436. Table Gridlines Turning Green
  437. Main form ID to subform using Access 2010 vba code
  438. Rich Text MsgBox
  439. Union Form Alternative Image Controls
  440. Modify records from form
  441. Update incremental values in one table from fields in multiple tables
  442. Too Few Parameters Error Confusion
  443. Access Multivalue Lookup field - query works... until called from a Form
  444. Difficulty to create a search box
  445. Loop through records in a bound form
  446. specify folder for save as pdf from print preview ribbon
  447. Change Font in Form's Caption
  448. why i get sometimes the message
  449. Macros, VBA, etc disabled. How to call 1 of 19 subforms from a main form combo box?
  450. how to unhide a hided module in an Excel file?
  451. Is access the best for administering quizes?
  452. Macro pop up reminder
  453. Date search error
  454. Generate primary key with actual date & increment number
  455. Clearing a Javascript Message Box from VBA
  456. Near Surrender! Can't "lock down" database.
  457. Wildcard Fields in VBA
  458. Display an Image on a Report using OnCurrent Event?
  459. Very little Access experience -- Need to keep newest or last line of information whil
  460. Totaling columns of dates and then dividing by the number of
  461. Import CSVs and location from multiple folders and sub folders
  462. Combo Boxes on subform not syncronising
  463. How to add fields, that are not database fields, to an XML out put file
  464. How do I make a connect string for a iSeries Access ODBC?
  465. Need help clicking an HTML button in VBA
  466. FindNext for multiple criteria not working
  467. Insert textbox in Word Document VBA
  468. Need to Split 12-Digit Number Field into 12 Separate Fields
  469. update code for use 64 bits systems
  470. Auto populate empty field
  471. loop through records then add record if none exists based on 2 criteria
  472. search matched and unmatched records
  473. Compare 2 Tables and show how many records do not match using specific criteria
  474. changing control formating if it's value changed in form
  475. DISTINCT not working as expected
  476. Parsing HTML to find format of each word
  477. Formulating Join statement
  478. Record Not Showing in Query When One Field Contains No Value
  479. Single Handler for the Click Event in Multiple Controls of a Form
  480. Function Cycles Multiple Times
  481. How do I make an email with attachments go to the Outlook instead of popping up?
  482. ...as expr1,
  483. MS Access VBA OpenReport on screen does not use Grouphead0 and run Select Case
  484. match full field from 1st table to first 9 characters in second table
  485. Menu Bar Formating
  486. Handler for multi Command Button, to make the code shorter
  487. Error Changing DB Properties
  488. Convert large IIF Expression into a Function.
  489. Saving query results into Source
  490. error in sql
  491. Filtering/searching through records
  492. Multiple Searches
  493. Date Functions
  494. Schedule Access Macro to Run Weekly
  495. SQL doesn't recognize a Form Control
  496. How to: Combobox text inserted as part of a texbox standard message.
  497. create function
  498. How can I select line items from a query and append them into another table?
  499. create view duplicate
  500. Automatic Numbering of Records in a Form
  501. Queries Totalling Balances Based on Time/Date
  502. MS Access 2007 VBA: How to go through records in one table and compare to another (bo
  503. Update query (VBA SQL) to replace part of the field
  504. code works in one form but not another
  505. SEARCH without Continuous Form
  506. Add criteria from counting more than 2 field
  507. How to Sum Combo Boxes in the Web App?
  508. Adding Multiple Records to SubForm
  509. Multiple Forms or Hide Controls?
  510. Microsoft Access Forms: Japanese writing Write Conflict how to fix
  511. DLookup Expression for a Form controlled by a table that has ProjectNo controlled as
  512. Drag-n-Drop Filenames with special characters () into ListView
  513. Count different 2 field in 1 table at Access Query
  514. Showing Individual Calculated Values in Query
  515. Convert a database from accdb to accde
  516. Copying Control in Continuous Form
  517. Memo field will only hold 50 char in subform, but more as form or table
  518. Change Form Record Source
  519. Converting decimal to time
  520. Please help. ref sending multiple emails in access
  521. Hide & Display Splash Form
  522. Partial string match two columns
  523. Runtime Error '2501'
  524. Closing all open objects
  525. database access deny error when VBapplication
  526. Requery Combo Box Automatically From A Query
  527. better display of results
  528. Add a year to formula in MS Access 2003
  529. How do I set a checkbox to equal a text value?
  530. error in UPDATE statement
  531. Multiple criteria from same fileld with combos in Form
  532. Changing Image Based on Field Option
  533. Outlook Linked Access wont quit
  534. Need to have a button disabled until a field is populated on a form
  535. dlookup in form that returns the closest value
  536. Barcode 39 fonts
  537. refresh/requery data in subforms
  538. Deploying a Multi-User Access Database with Different Needs on Different Front Ends
  539. Referencing a public variable in MS Access
  540. I want to use the value in a text box on a form that is unbound to a bound field of t
  541. Pull file details and extended details into a form.
  542. Access VBA to Address1 & Address1 but Check for Partial Match
  543. messge box for certain codes on data entry into a form
  544. Append Query
  545. DIR() throwing run time error 52
  546. how to close the form after the last record?
  547. Subforms
  548. Filter a form based on two fields from click of button
  549. Error Number: 3010
  550. How to fix "has a function containing the wrong number of arguments" error?