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. Access 2010 conversion bugs?
  2. If-Else help - multiple conditions
  3. How can I enter DATE Critera to Crosstab Query
  4. Format Template to show Beginning Year Balance & Monthly Expenses
  5. Looking for a way to get event's arguments without using [Event Procedure]
  6. How to export an Access 2007 report to Excel via VBA
  7. Converting Julian date to Gregorian date Gregorian date (Access 2003)
  8. VBA Dlookup with two criteria not working
  9. Effective rate per Material/Product
  10. Subform in Subform - invalid reference
  11. Update statement doesn't update
  12. Call records not showing attendance date
  13. change color of part of text in textbox?
  14. Can you modifiy the text in a dialog box?
  15. Database Password
  16. Copy & Paste ACCESS Report Design
  17. SQL Transform Statement
  18. Export Datasheet to Pdf with a caption
  19. Backup my database
  20. How to resize a Popup Form
  21. Large or Top from List of scores
  22. Creating MDE in MS 2003 will not hide my Forms etc
  23. Button Command - Copy and Paste {Excel}
  24. How to disable and enable the secondary menu bar if the user is false
  25. Microsoft Access form
  26. Form SQL or Query Limit? Error 3276, Invalid database object reference
  27. help on subform and textbox
  28. access table field update
  29. Trying to use the status bar as a progress monitor
  30. Delete and archive to a table!
  31. Search using multiple keywords and update query
  32. Getting error from OnClick Macro
  33. Is there a way to bind the ms access record selector to an unbond text control.
  34. Cannot sort Months in a report by Oldest to Newest Order
  35. Ranking in Access Table/Query/Report
  36. Help with a where condition
  37. Database with table naming issues
  38. Access window gets lost
  39. How to detect On Mouse Move when mouse key is pressed?
  40. Function not available
  41. reading text from images...
  42. Set Colour for Current Record
  43. Continuously run report for display in Access 2007
  44. Search Engine issue
  45. Too many nested IIF's
  46. Import picture from folder into a form without bounding
  47. Calculate data
  48. Display data in report from top to bottom and left to right
  49. Need Unbound Textbox fed from crosstab query to insert/delete table data
  50. Suggesting new values based on varying historical values
  51. Copy from "field2" to new record "field1"
  52. Display data in grid view for access 2003
  53. How to replace "the value you entered isn't valid" with a custom message
  54. Problem for report printing's color
  55. Subform Columns and Data Appearance
  56. Validation rule in MS access validating only part of data
  57. Signature Images are not showing when sending email from MSAccess
  58. how do i create an executable file in access 2010
  59. Access to Outlook without security warning, without SMTP
  60. Percent Difference From
  61. How to change the height of the 'detail' part of a form?
  62. Attaching multiple documents to an email
  63. Accommodating several one to many relationships in a single form.
  64. How to publish access2007 file to the web?
  65. How to Iterate through all Controls with a Particular Tag
  66. How to disable the home menu in access 2007
  67. Enter parameter value
  68. Details (Adress) in a textbox related to a selection in a combo
  69. Sort Query
  70. A problem with an IIf statement in Access query
  71. why is my loop not picking up the next value?
  72. Creating a Dynamic Chart in a Form
  73. How to clear input boxes once save button clicked
  74. Append a recordset to multiple fields in another table on request
  75. Showing data when zero records returned
  76. Date Formatting in Excel VBA
  77. how to calculate due dates of premium and update status for future
  78. Concatenating 2 ID FK fields into 1 text field
  79. Evaluate Null values
  80. Add new row in subform from another form
  81. How to avoid (undesired, intermittently-occurring) exclusive locks?
  82. CopyfromRecordset DAO issues
  83. Run-time error '91', Object variable or With block variable not set
  84. Access 2010 Security
  85. 3043 Disk or network error.
  86. Is it possible to open a form to a blank record?
  87. How can I set a form data column to allow value to be entered but not updated?
  88. Embedded Excel in Word VBA
  89. Ms access query cannot pop up on top
  90. Open form automatically if 1 record found?
  91. Automatic case numbering in Access
  92. Problems with FindFirst, Access 2002
  93. Associate and Filter Data
  94. What causes a front end to work for me, but run out of stack space for another user
  95. Create an add/edit form in access 2007
  96. How should I link husbands, wives, and kids to each other?
  97. Log-in Network
  98. convert total seconds to minutes and seconds. Access 2010
  99. Reusing existing Access 2007 application in a different context
  100. Set report format, different SQL query underlying the data
  101. Access 2007 calendar
  102. How to store options ?
  103. Adding textbox in forms if the specified data is entered
  104. Help with Cascading Combo Boxes my code info included.
  105. Security for Access Database
  106. Complex calculations in Access
  107. Show Report Details Horizontally (Access 2007)
  108. Check for Null with comboboxes
  109. How to put a running count on a report in the format of 1st, 2nd, 3rd etc
  110. How to incorporate multiple fields using the same lookup?
  111. Add a category to drop down list
  112. How to automatically have the 1st day of the week entered in a text box on a report?
  113. Multiline in Access 2007? Need a line feed on a text box.
  114. Can I "move" a child record from one parent to another?
  115. rs is not updating
  116. Need Help with Multiple Search in a Form...
  117. How can I add the report name to a report in Access 2007?
  118. Add Values in Table of Existing Data
  119. Bound and Unbound Checkboxes
  120. query is too complex
  121. VBA: Auto fill in form of open website
  122. How can i split a cell in ms access query using any one of it's letter
  123. Converting a Report to PDF (2007)
  124. Future Date
  125. How do I create an advanced search form?
  126. dbConnection.Execute fails after I installed sql 2008
  127. Data showing in Layout View but not in Print Preview
  128. Use checkboxes to Print/Save multiple hyperlink files
  129. Deselect all checkboxes in Access 2007 form
  130. Overflow error
  131. Importing only some columns of an excel file to access
  132. Password Command button on a switchboard
  133. How to create query for attachment
  134. Handling/Linking tables in access
  135. Copy from a subform to a text field in the main form
  136. Input mask for date on textbox
  137. Financial Year-End Periods
  138. Partial Display of List Items
  139. Barcode reader and access form
  140. output file error
  141. Performance impact of using of like vs excluding
  142. How to Filter formatted Date fields in MS Access?
  143. Average of multiple numbers
  144. How to Hide Database Read-Only Database Message
  145. how to update a field in a table with the sum value of a field in another table
  146. Set Query Criteria based on Control values
  147. Access - Form list Box data to table
  148. Insert Month
  149. How to change a field from a value list to a lookup?
  150. Populate an MS Access List box manually from a VB String value
  151. Run an Excel macro after exporting an Access report
  152. exporting unicode strings from Access with VBA
  153. How to ensure data integrity if the user closes Access
  154. Loop on All Forms; List All Form Properties As Each Form Is Found
  155. How to create a chart object in a report using VBA
  156. Automatic reminders via email
  157. Customer Receipts
  158. Loop through all list boxes to pull all selections- Passing variable control name
  159. Form Filter not working on Cambodian unicode
  160. How to set field format as percentage
  161. My first multidimension array- Can I set up each line at once?
  162. From Access 2003 to 2007 and command is not working
  163. Alternative to .Send
  164. show all record in form
  165. Subscript Outside of Range
  166. how to give a value of textbox in query
  167. Handle query with errors
  168. How can I force a table update?
  169. assign value to textbox from somewhere else
  170. Excel 2010 locks reference list in Access 2003
  171. Combo Box Menu will display the next text value
  172. Open a form passing a value
  173. How to set AllowAddition properties in form
  174. prompt before moving to next record, if no dont move, if yes then save and move
  175. How to write an If statement where Variable Equals Neither X Nor Y
  176. Stop Interim Tables from Opening when running multiple queries in MS Access
  177. SQL query to find covering staff - Syntax error
  178. Row Source
  179. Auto defrag database when size exceeds 20% of last defragmented size
  180. Disable ctrl + dot(.) in access
  181. how to "fill data series" in Access?
  182. Automating Pivot Charts
  183. Date Calculations in Access
  184. How to insert barcode in access 2007?
  185. how to undo data on a parent form
  186. Images Stored in an Access Database
  187. How to make my databases sturdier?
  188. Creating a slope formula for Access
  189. Convert a date range to number of days!
  190. How to have a mass upload feature in my MSAccess Database
  191. Running SQL from a web page?
  192. How to link master and child fields using VBA in MS ACCESS 2003
  193. How to consolidate multiple records from a subform onto 1 line in a report
  194. VBA modify a table with the SQL Alter Statement Syntax Error
  195. How to Requery query result window by keyboard shortcut?
  196. Problem Filtering combo on subform based on M:M
  197. Page numbering conundrum
  198. Expression Entered Refers to Object that is Closed or Doesn't Exist
  199. How to convert month number to month name
  200. How do I delete a record on a subform?
  201. calculating the sum of a calculated expression field from a subform
  202. Query to Show all Date Records as well as Gaps
  203. Controlling priorities or interrupting an application
  204. Taking all values from a column and putting them together with a "; " separator
  205. How do I update Access table fields from Excel file
  206. How to make a button in/visible depending on a control's value?
  207. Getting run-time 3009 error on "DoCmd.TransferDatabase acExport" statement
  208. Best VBA option to have users run a variable list of procedures
  209. Run-time error '3075'
  210. How do I prevent a form's being closed based on some of the control values?
  211. System.Data.OleDb.OleDbException :(
  212. How to insert value into database
  213. How to capture the procedure name in error trapping.
  214. Transfer Control to new form using previously entered account info
  215. Keep the focus
  216. Custom Primary ID ( not Autonumbers)
  217. How can I make this function work
  218. copy a field from a table to another field of another table in 2003
  219. How to time a 'while' loop?
  220. How to write a code to "click" a button on form B?
  221. How to Search and Manipulate the contents of a Word document in Access 2007
  222. Missing Operator
  223. Query combining results from multiple tables, data cannot be modified
  224. Why do some of my records fail to find their children?
  225. query criteria based on form not working in other computers
  226. Can I insert data from a query or report directly into the body of an email
  227. Other option than OR
  228. Help with Excel RoundDown Function
  229. Populate a subform date control based on main form date range controls
  230. access 2007 Database read only
  231. Converting Rows to Columns
  232. How to sum a calculated field in Access Report?
  233. Import HRM files to Access
  234. Update query with Dlookup function results in conversion error
  235. A Calendar integrated into MS Access 2010
  236. How do I make my query stop asking for a field that no longer exists?
  237. How do I add a sequential row number to a textbox in subform and subtract rows
  238. query filter using dynamically populated IN() function
  239. Select blank line in multiselect list box and retrieve related data
  240. What do you use for Fonts in Access?
  241. Less 3 business day
  242. MS access has encountered a problem and needs to close
  243. How to see all records in table
  244. Convert decimal to 36-base system
  245. I can't enter any more new records into my access form
  246. Continuous subForm: Scrolling "hides" top record
  247. opening outlook from vba shell() I get error "cannot open your default email folders"
  248. Crosstab Query
  249. How to add a sequential row number to query
  250. MS Aceess 2003 changes Query SQL
  251. How to generate a random number for lucky draw from a query
  252. Sum and IIF function in Access 2010
  253. How to write an if statement in an update query.
  254. Get text data from web
  255. How can I add up a value to the current recordset value when editing a table?
  256. Access VBA to browse for pdf, attach path to field, and create functioning hyperlink.
  257. Mac users cannot input data to FrontPage form which feeds info to Access database
  258. Save record before it is changed.
  259. How to write SQL subquery to combine related subrecords?
  260. Access VBA to format Excel - Date Format
  261. Retrieve records from another recordset
  262. Image display problem
  263. How do you get a form to load and stay visible in access 2003?
  264. Form (inc Subform) - Locking all records
  265. Subform : Copy selected fields from current row to new row
  266. Subform : Increment time in new records [from last record]
  267. Audit Trail not working in subform...
  268. Finding value Table 1 near value from Table 2
  269. Selecting Weekday
  270. Populate lstBox dynamically on a report -
  271. Evaluate a String for a Machine Readable Value and Replace w/ VBCRLF
  272. Find record
  273. Had my first database corruption
  274. SQL to show records from 2 tables in single listbox
  275. How to count and total check box values
  276. =function() On Click Event refusing to work - on a subform...
  277. Convert string to Date
  278. How to create a report in letter format
  279. Stamping a time field with the equivalent 15 minute interval
  280. How to pass X,Y MouseMove vars to a function THRU .OnMouseMove?
  281. Report with 2 sections based on different set of records
  282. How to Auto update EmployeeName
  283. Having issues searching the record when the field is in number
  284. How do I code a query to sum fields at different levels of key data?
  285. How do I create a calculated sum field in Access form?
  286. How do i add a new record with specific values in a subform when a new record is adde
  287. Using global variables in report calculation.
  288. Import project to access without the lines from external predecessors
  289. How do I convert date yyddmm to mmddyyyy
  290. Is it possible to adjust the size of an image based on the value in a text box?
  291. UPDATE statement where table name is based on unbound textbox (VBA/Access)
  292. Code to parse out selected fields of .txt to new table
  293. Lookup and match usrname to it corresponding password
  294. How to Use a Global Variable in a Report's Format Header Event
  295. Inputting data from a form into a linked table
  296. Run-time error '438' (Help with VBA coding)
  297. How to print all reports in click?
  298. Is Report is limited only for 22 inches in height?
  299. Import 50 rows from text file of 300
  300. How to use data from a form's unbound control in the query & report?
  301. How to access the user's input (to a crosstab query) as a field?
  302. Call function from form event: arbitrary behavior
  303. Club Database and daily attendance date recorded
  304. Massive record loss in Access 2003
  305. Combining multiple records into one record
  306. Importing a CSV file with a Date/Time field, the field nulls itself out
  307. Restart from 1 AutoNumber field
  308. base64 encoding an image
  309. How to select TOP X results of a field for each value of another field?
  310. Search for a word in a comment field
  311. How to hide field/s depending upon the value in other fields of same form in Access
  312. When using macro to close form, how do I force the 'prompt' on save?
  313. Passing date parameter from Form to Query
  314. I upgraded a database to 2007 and now cannot make changes to a query?
  315. Excel.exe instance in task manager error
  316. how to link a key on keyboard to a function
  317. Can I create an autoinstall to choose the version of MS database required?
  318. how to add and subtract in access?
  319. Problem with Euro formatting (123.456,78) on Microsoft Access Report
  320. Add sound when subtracted value = 0 in subform
  321. How to limit/exclude characters in a txtfield in a form using EITHER OR
  322. Complex(?) conditions query
  323. Handling null values in a query
  324. Check for records before inserting variables using SQL Statement
  325. if statement problem
  326. Check for a value on a form across a network
  327. File Importing Problem
  328. User prompt to make selection from lookup table
  329. acCmdDeleteRecord does nothing?
  330. Create Recordset Function error: Invalid Use of Property
  331. After update for date field.
  332. What is the best software to convert an Access DB to a Server app?
  333. DLookUp problem works in Debug but not on the form?
  334. Microsoft Excel - pulling data from multiple tabs to a single tab
  335. Can I refresh the database using VBA?
  336. how do you write validation rules for a field that uniquely identifies record
  337. How to Use 'Between' in SQL Statement?
  338. access forms open as program
  339. Data Type Mismatch in an IIf function
  340. Error 3071: Expression too complex
  341. Trouble deleting record from form
  342. Check if record exist in table Not working
  343. securing open access file sent via email
  344. How do I write a validation rule?
  345. Record Is Deleted
  346. How to Save Query's Pivot View (MS 2007)?
  347. Moving MS Access 2007 database from one to another computer
  348. How to organize my Record Sources & Control Sources in subform data entries
  349. VBA: Export query to Excel and format as table
  350. calculate sum in table subform then show in mainform
  351. Import Export
  352. Proper syntax for using an update query in VBA?
  353. help with error 13 type mismatch
  354. Error using findfirst
  355. How can I set the Index and use seek command?
  356. Whats is the Transactional difference between Docmd.RunSQL and CurrentDb.Execute SQL?
  357. the project window is missing
  358. Summing fields from on Tab subform to another Tab subform on the same main form
  359. Adding multiple records into my access-2003 tables
  360. how to make joined fields automatically filled on a form based on value in other?
  361. Creating message box
  362. how to automate HTML encoding file export/ save options using VBA?
  363. Date field on Report #Error
  364. Send a report from one access database via another access database
  365. How to lock an Access entry with a button
  366. Precision of values
  367. Insert query using values and query
  368. select case not working
  369. How to Make DB Objects Read Only?
  370. About Update statement with table variable
  371. String Split into Recurring Fields that can be either active/inactive
  372. Too few parameters. Expected 1
  373. SQL Update Query that references another query and another table
  374. How can I make my Access DB automatically save a copy on Exit?
  375. Merging Access Databases
  376. Connection string to access SQL Server stored procedure not working
  377. Help come up with a good db design for student
  378. Display Date that is X number of Months from Today
  379. Start up form
  380. Trim function not removing trailing spaces?
  381. Similar Columns, Variable Choice to update
  382. use for each in subform
  383. Access report to pdf, split by company grouping and e-mailed to company
  384. Add page to TAB CONTROL
  385. Continued/Discontinued ? Terms by query in access
  386. How do you filter an Access Sub-Report
  387. How to set the values of SourceObject,LinkChildFields,LinkMaster fields at Runtime?
  388. How to write a "where" condition for a report?
  389. How to format SQL Server data in Access report
  390. Can I change the text for the required property warning?
  391. Date Validation
  392. Prevent warning message
  393. data from one form to another form..
  394. Trouble using select query with linked table using ODBC to link.
  395. This recordset is not updateable when using filter or ado recordset
  396. How do I make a field set focus after each entry?
  397. For split form, how to I add a Text Box with label in form & control in datasheet?
  398. how to set the field with no zero in the beginning
  399. combo box multi selection with start date and end date
  400. How to add gif image to startup screen?
  401. How do i get a total from subform on purchase order?
  402. How and where do you do a simple update from value entered on form
  403. how to make fully related database? having trouble
  404. With report .print, how do I set text box width?
  405. How to change form to allow control of saving record changes?
  406. Expected array
  407. How do you update units available on Table "Stock on Hand" from value entered on form
  408. How to modify the code to search by one word that field contains
  409. Set default value as blank for calculated field
  410. change the date format in sql query, mm/dd/yyyy to dd/mm/yyyy (SQL)
  411. Question about entering numbers without 0 in the beginning
  412. Hide buttons when form is open in read only mode
  413. How do I get this unbound contol to lookup a password based on a parameter?
  414. Command to Duplicate Record in a Form gives error "PasteAppend isn't available now"
  415. Open form based on querie with parameters
  416. How to copy field information from deleted records selected in datasheet view
  417. Open form based on parent form - auto add PersonID
  418. Autonumber each new record per ID
  419. Computing dates from multiple tables
  420. JSON From Excel/Word/Access
  421. How to get the Percent for each row?
  422. Capture debug.print of users logged into database
  423. How do I use a textbox to search a listbox?
  424. How do I open a report based on a ComboBox selection?
  425. Importing excel files into Access with spaces and delimiters
  426. Screen painting freezes in Access 2007/2010
  427. MS Acess Cannot Distinguish Between Capital and Small Letters
  428. Using a continuous form's filter to generate a report?
  429. how to format decimal amount without commas?
  430. Access and Keyhook? Will it work?
  431. Calculating future date
  432. How to compare and get the maximum value of four fields?
  433. How can I save Running Total in Access 2007???
  434. Finding all records before todays date - 5 Days
  435. Syntex Error, Update Multi - colomns - multi feilds in one query .
  436. Derive Field Based on 2 other fields
  437. How to have a different "first page" from "other pages" in a report?
  438. How do I keep the Navigation Pane from Access 2007users ?
  439. Can I have an unbound field that will retain the date entered in it until changed?
  440. Solved: Masking credit card numbers in a mixed field
  441. Run-time error '3075'. Inserting text with apostrophe
  442. Cost of Sale, Stock calculation, Running Totals
  443. Creating Users
  444. inserting dynamic controls in a form , one overlapping the other
  445. Syntax Error on a DLookup Criteria
  446. Access 2003 Need to make command buttons enable / disable based on other controls
  447. How do I import dates from Excel to Access?
  448. How to use excel 2007 vba function in Access 2007??
  449. How to Open a Form Synchronously
  450. using combobox for value input
  451. How to Throw an Alert 1 Month before License Expiry Using VBA Code
  452. How to set the fields in a row to be non-editable, on a multi row subform
  453. How to reference a control on a form in a DCount on the same form?
  454. How to put a negative sign on a number based on the selection of a drop-down list?
  455. I am trying to get the Median for Groups within a Table
  456. Run Time Error 3022 when there are no duplicates
  457. how do i delay the start of button function by 5 sec
  458. SQL Data Type Mismatch
  459. Specific input masks
  460. data is getting updated properly only reopening the application
  461. Help with sending emails from Exchange using CDO in VBA
  462. How do I write the value of a variable to a new table from a VBA sub?
  463. What causes Inconsistent Behavior of VBA Global Variable?
  464. Exporting an Access Report to a Text file, can the formatting be maintained?
  465. Show Result from Text Box in continous form
  466. Set focus to a subform in a tab control
  467. Sorting a complex query in ascending order
  468. Some help with Do__Loop and Arrays
  469. How to flow a memo field to another page in a report?
  470. Can anyone explain how to add a search box on a form in Access?
  471. Problem with Import Specifications
  472. Creating a username field
  473. Why are my records not displaying in the Switchboard
  474. SQL Advanced Query Outputting to Excel
  475. "Out of memory" error when compiling
  476. Getting Rid of an #ERROR returned if Field is null
  477. Filter by selection problem
  478. Multi-Select Statement with Multiple Conditions
  479. how do i make a query appear in a table and form?
  480. Grouping files
  481. How do I retrieve multiple records from a VBA Query - I only retrieve 1 record
  482. Aggregate Function Error ???
  483. Can I set a memo field so that so that it can retain its old & new values?
  484. Lookup combobox not recognizing list values when typed into text box.
  485. Sorting Data in MS Access
  486. I want to update a field in subform from another subfrom
  487. How to prevent subform closure on main form window resize
  488. Why not to change the datatype of standard procedures
  489. Interpolation VBA / Access??
  490. Can anyone explain Private vs. Public properties in Class modules
  491. I want to view the VB code of my MS Access Database 2007?
  492. How do I update a textbox after closing a query?
  493. Inventory Form that adds/subtracts from current inventory number in table
  494. Calculate RunningSum as a function of day, but within groups
  495. Run If all records selected have same value in a field... Problem?
  496. Select item in ComboBox by using arrow-keys and pressing [Enter]
  497. How to run an update query on a multiselect list box
  498. DISTINCT different files
  499. how to prevent running OnExit procedure, if pressing Cancel Command?
  500. How to multigroup a report without any condition? Access 2007
  501. Combobox showing Staff with relevant qualifications
  502. populate textbox from two combo boxes
  503. How do you populate a listbox based on a combo box selection in ms access?
  504. Developer error
  505. Access SQL error "Overflow"
  506. More than one query to a form?
  507. Is this a Access 2007 bug or is it me
  508. manually updating text box causes primary key problems
  509. Insert multiple records in Access 2003 using one INSERT statement
  510. Batch file doesn't run through Access
  511. VBA with multiple strSQL strings- need help to improve
  512. DMAx code not working
  513. #error in text box fix
  514. Aside doing it in macro, how to assign form to appear first in opening access07 prog?
  515. Access 2007 - VB If, then, else query issue updated
  516. O2010 - when I move a linked back-end, and re-link, the FE wont open?
  517. How do I search on 2 fields in MS Access?
  518. How to create controls in an excel worksheet which has been opened from access module
  519. Time Interval Overlapping (MS Access 2003)
  520. SQL code for returning this weeks salesdata
  521. How to Create Automatic Dynamic Union Query
  522. How to create report out of raw text file?
  523. How to make database file readonly ? Access 2007
  524. Combination graphs in Access
  525. I have database in access 2003 and have prices stored in a table
  526. Transferring a form to a tab control page problem
  527. When exporting a table to text using DoCmd, some fields disappear.
  528. Currentdb.execute using string variable
  529. How to calculate running sum in VBA based on an ordered input table
  530. Error when running the Package Solution Wizard
  531. Add records to subform1 based on criteria and data in subform2
  532. Is there a calculation in VBA code to work out distance between uk postcodes?
  533. Hot to print vertical text on a report with Me.print
  534. How to use Visio in Access forms?
  535. Hyperlinking From MS Access
  536. How to add a record to a table?
  537. Is converting a finished database to SQL a good idea for a beginner?
  538. Can I assign Word 2003 macros hotkeys globally over a network?
  539. Problems dividing by a null value to find a percentage
  540. How to export current record on a form to a PDF file?
  541. Importing a CSV file? Erroring out
  542. How do I carve out holidays from date calculations?
  543. Date Validation
  544. How to loop an append query
  545. How do i set a conditional formatt on my subform base on the main form value?
  546. Avg text box set to default 0 when not in use
  547. Condition in report? Access 2007
  548. Record Saving issue
  549. How to Summarize a Report?
  550. how to SUM and return distinct ?? or Distinct SUM ?? Access 2007