View Full Version : 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
  1. Field type corruption?
  2. Can a multi user Access db be used via Terminal Services?
  3. Default Fonts
  4. Creating sample data & MDB file size?
  5. Error 430, CopyFromRecordset with DAO 3.6
  6. Slightly O.T. - seeking documentation of the microsoft user interface specification
  7. Linking form - Report
  8. Query criteria - limiting the records - question
  9. Sequential numbering of a record collection
  10. code doesn't work on some PC's; does on others
  11. circular dependency between subforms, problem cased by subform loading order
  12. GROUP BY problem in access
  13. Continuous Form: Changing .BackColor depending on value?
  14. mde
  15. validation rules
  16. Using wildcards in Crosstab Queries
  17. Overdue warnings in Access
  18. Can a control on a Datasheet have a scrollbar?
  19. Error msg when adding a new record to a subform
  20. Removinc and installing A97
  21. Pages In Subform
  22. adding Record autonumber problem
  23. OLAP Server Problem
  24. OLAP Server Problem
  25. Exporting From Access to a Dbase iV. via Object. Fails with error The Microsoft Jet Database engine could not find the object
  26. Number of users opened MS-Access.
  27. Consecutive Invoice Review
  28. Help on report..
  29. Mail Merge to an existing document
  30. Tough SQL objective - pulling data from 4 different tables
  31. field in subform
  32. Why do IT guys hate MS Access?
  33. Help wanted - how to merge two tables with different information.
  34. Programatically Populate New Database With Tables
  35. Missing Parameters in report
  36. MouseWheel event does not trigger
  37. error 3021 no current record, only sometimes
  38. assigning a listview control to a listview object
  39. Appending? Creating? Help!
  40. Insert Object- Scanner recognition
  41. Field Totals
  42. Slightly O.T. - need a printer I can use on a specialty database app
  43. Weird combobox error in subform
  44. Conditionally select fields in SQL statement. Possible?
  45. Error at last record in form while displaying count
  46. Saving datasheet layout in .mde
  47. Find the faq
  48. How to enumerate every record in the subform?
  49. Simple listbox question
  50. Convert string expression to value?
  51. fatal error trying to close form from subform via code
  52. fatal error trying to close form from subform via code
  53. Custom Error Message Fails to Work
  54. How to do a Transfer Text Batch Group
  55. Greenwich Mean Time (GMT) in Microsoft Access 2003
  56. Looping through forms then the controls.
  57. Referencing an object description in VB
  58. lost page tab
  59. Programmatically Import Toolbar
  60. Access 2003 Possible Corruption?
  61. Runtime Report Editing
  62. Recordset problem
  63. crostab query
  64. Yes No field on form and query
  65. Summing Queries?
  66. tab control record/ data exchange
  67. Scrolling back records on a data entry form...
  68. Report footer
  69. Data Transformation among Microsoft Products
  70. Rant
  71. Automatically add new records
  72. Automatically add new records
  73. Add a cell formula in Excel via vba from access
  74. Autonumber
  75. Report size
  76. Add rows to top of existing spreadsheet
  77. Relationships decision to be made...
  78. How do I find the MSAccess.exe file path??
  79. Read dBase IV
  80. Looking for matches, adding to match table
  81. Form/New Record
  82. XY (Scatter) Chart
  83. notepad file to ms-access compatible file
  84. Multiplication formula
  85. OLAP Problems in Windows Environment
  86. How can I interact with MS Access using a programming language like Perl?
  87. Code for controling FTP from Access VBA
  88. Help with parameterized queries
  89. Reading Global Address List in Outlook (CDO)
  90. submitted data not updated promptly with ms access
  91. I need help w/ Queries
  92. Date Query?
  93. Login in form text fields are filled out..
  94. Printer properties
  95. SubReport on Main Report Page Footer - Didnt think it would be so hard.
  96. Hide Duplicates flag?
  97. Access / ASP hacked insert
  98. Select query that won't run as Update query?
  99. Can A97 Be Installed On A WinXP Machine?
  100. How to work on home laptop, then update client's Front End?
  101. CutePDF. Pass file location?
  102. Comparing one date against a list of dates
  103. RegisterDatabase for AS400
  104. Open source "Tanning Salon" Application
  105. filtering the last date
  106. Using an SQL statement to convert date format where the field is NULL???
  107. Listbox: Use SQL + constant text string to assign values
  108. Total Access Analyzer?
  109. splitting text into characters ... HELP ME SPLIT
  110. Looping Query Defs
  111. Problema per creazione Rubrica...Help me!
  112. almost got the mail merge to work one problem
  113. Thanks for help today - new problem with recordset
  114. no read permission
  115. Run-time error '424': Object required - can't work out why
  116. Select multiple date fields from one table
  117. Picture on page
  118. IsNull() - I can't get it to work properly..
  119. The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
  120. A97 SQL capable of showing data from 2 different table records in a SINGLE output record in dynaset?
  121. Dynamic Crosstab Report Problem
  122. Change Caption Of Label In External Database
  123. Changing table permissions in VB Code?
  124. A97 query question
  125. Using a picture (Form Template) as background in a report?
  126. Snapshot viewer and Access 97 reports And Emailing
  127. Database Permission Question
  128. Text Box and 255 character limit
  129. The .Value of a Check Box
  130. Removing Items from a Listbox with Multi-Select enabled
  131. Adding Excel Object Library Reference Programmatically
  132. UI: Combo Box Max Records Recommendations?
  133. Update Query
  134. Creating self-join table
  135. disabled startup
  136. Globals and system instability
  137. Random Number in Query?
  138. report page layout help
  139. autonummering in table gives problems
  140. Autonumbers: Retrieve unused no's
  141. how to skip runtime error
  142. ORDER BY a SubSelect?
  143. Printer Orientation and PrtDevMode MSDN example not working
  144. Database creates another file when first opened? What causes this?
  145. Access 12 screenshot (my style)
  146. help with update table
  147. Relationship Link
  148. Run-Time error 3146
  149. DoCmd.RunCommand Equivalent for acFormBar, 7, 6, 0, acMenuVer70
  150. Using Vendor ActiveX Grid in MSAccess
  151. Set myTableDef = myDB.TableDefs(myTable) is so slow ....
  152. is stupid
  153. richtextbox loadfile problem
  154. Public variables reset on error, what's up?
  155. Find Primery Key
  156. Linked images don't refresh
  157. Pivot-Table Form vs MS Graph?
  158. Access Database through ASP
  159. Run-time error..
  160. Type mismatch error
  161. Compact a password protected MDB from a front end MDE
  162. Find and Replace special characters in a field
  163. How to stop an Access form from automatically saving a record?
  164. Need a little guidance (beginner)
  165. Formal Complaint
  166. OLE OBject Source Doc
  167. Rename Table/subform Field Names
  168. Linking table/query SQL
  169. Access Report
  170. How to check the status of a sub form
  171. Check on empty record set in VBA
  172. How to Lock the Page Setup in reports
  173. Display One-To-Many records in a Mail Merge
  174. Enter control
  175. Conversion to SQL Server backend
  176. Open images after double clicking them on form
  177. Custom table property to prevent overwrite?
  178. Rotating label text in A97? Is it possible?
  179. Moving a text box in a report at runtime
  180. error message 3343
  181. How do I write code to allow user of a runtime distro to select a DEFAULT printer?
  182. Input Parameter Query Window - Duplicated?
  183. problems compiling with Listview control
  184. Unable to create new records on linked tables over network
  185. Mail Merge Access 97 and Word
  186. Sum Subform Records in Mainform contol
  187. How to break out of loop from error handler?
  188. Sorting report by Quater
  189. Update Table
  190. Expression error
  191. Need Church database for small church
  192. Select top on 2 tables based on date?
  193. update, append query Joins being deleted.
  194. Unable to make form visible again
  195. export temp table to text file user side
  196. Users being locked out, unable to open file
  197. Application.Version
  198. Access 12 screenshot
  199. Help with DLookup
  200. DLookup return date from database
  201. CreateReport(, templateName) not coping report properly
  202. How do I restrict my results?
  203. Body for e-mail
  204. Reconcile Query Wizard Add-In For Access 1.2
  205. SQL Help (Please)
  206. Playing Sound Clip
  207. comp.databases.ms-access
  208. Strange behaviour on startup when project is signed
  209. Open a 2nd form from a 1st form and keep the same rs and current record
  210. database worksheets?
  211. Access help!
  212. USING DLOOKUP TABLES
  213. RECORD LOCKS
  214. UPPER CASE
  215. csv export file and international settings
  216. Need to send a directive to linked database
  217. Query With Many Checkboxes
  218. Like Clause
  219. rolling average
  220. Access on the Net ?
  221. Please help: How to concatenate fields in querie??
  222. What Access Runtime files are needed to deploy? (2002/XP)
  223. Columns
  224. Hoogste waar de in een kolom
  225. Problems with HTML Imports
  226. MyControl.text in form without record
  227. How do I disable automatic save of my project as I build my database in access?
  228. lost mdb
  229. Using the 2002 Access Lib. in Access 2003 .....
  230. Sorry ....Using Access 2002 object lib. in Access 2000...
  231. Table Index Construction
  232. An NT Security Gotcha that looks like a Jet Security issue
  233. Requery a subform from a lbo - how?
  234. Help with validation feature`
  235. Function to return quoted value?
  236. Postcodes
  237. Using data from one Access database in another
  238. security: user level vs. group level
  239. PDC2005: Anything new for access?
  240. Does not import all data?
  241. A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field
  242. ldb file and Exclusive Access question
  243. Condition Format in Multiline Textbox
  244. Multiple Date Ranges in a Report
  245. Check to see if a button has been clicked on a form
  246. Remove dash from soc sce #
  247. Union Query and Filter By Form, Access crash
  248. Finding a specific record
  249. public variables
  250. No Current Record
  251. SQL multiple statements?
  252. Help with Report Design
  253. Access not working (can't query or create report)
  254. MSAccess query error
  255. A97 - 5 records in a recordsource query cause 5 pages to print out
  256. A97 question regarding closing a report
  257. docmd.openform where condition problems
  258. Changing a Label Caption in a report
  259. Conditional Format With VBA
  260. Keeping empty subreport visible
  261. Very basic problem
  262. math problem with dates.....
  263. Exploring use of Dir("\testdir\nul")
  264. Looking for users of a niche product
  265. modified snaking columns
  266. ODBC--call failed
  267. Access Runtime/Access Full Version
  268. How to transfer *.dbf (many files)
  269. Manually changing a linked table location
  270. listbox in endless form
  271. How to remove last digit for inputted value?
  272. How can I set value in function that returns array?
  273. Appending records to a table from a form filtered recordsource
  274. Using Code
  275. report errors
  276. report error problem
  277. report error problem
  278. report error
  279. Print Tree View
  280. Help Needed With Corruption Problem
  281. A2002: Activate Event
  282. Using Unbound Textbox as parameter
  283. Font Size in Query SQL View?
  284. Security settings for downloaded databases
  285. Hyperlink
  286. Issue with Make-table query - Will this HURT?
  287. Autonumber Oddity
  288. Synchronize SQL Server with Access MDB?
  289. Help with filter
  290. Converting positive number to negative number
  291. I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
  292. concatenate two records in same table
  293. concatenate two records in same table
  294. Problems with Date conversion from text format into date/time...
  295. How to remove Lookup property from table field with VBA?
  296. shorten time to attempt to connect to back end
  297. OnNoData
  298. UCase not working in A97 runtime installation...
  299. 2 questions
  300. Linking Images using VBA code
  301. Conflict with Webroot's Spy Sweeper
  302. Intermittent missing reference problem
  303. Credit card number rounding?
  304. Decimal places.
  305. Output Stored Procedures as text problem
  306. Unable to set subdatasheet to None
  307. Error "You don't have the license required to use this ActiveX control"
  308. problems dealing with dates in my queries/SQL code
  309. Access 97 and counting the occurrences in a string
  310. Partial Replication of Data
  311. Reports opening differently on client/my machine
  312. Email reports?
  313. Searching a Field containing OLE Objects Returns Inconsistent Results?
  314. Adding to lookup list automatically
  315. Help with error message
  316. SQL - JOIN or nested query?
  317. Refer to class-properties (A97)
  318. Linked tables in a query giving no results
  319. Linked tables in a query giving no results
  320. Managing controls on subform
  321. How to unhide a specific form or database window in A97?
  322. A97 closes down each time I open a particular report. Anyone know the meaning of this?
  323. Access Developer's Handbook 2002: Tagged Values
  324. Problems migrating to XP
  325. Looking for a copy of ODE97
  326. Update foreign key before appending records to central database
  327. How to read .iif file of Quickbooks using vb or any code
  328. ONLY NUMBERS
  329. combo boxes
  330. Themed Tab Control work-around
  331. How to read .iif file of Quickbooks using vb or any code
  332. default value taken from other filed
  333. no data on a form
  334. SIMPLIFYING WORDS IN A TABLE
  335. Multiple Record Copy Transaction...
  336. Embedded Images
  337. time attandance system
  338. Concatenate 3 lines of text into a "Paragraph"
  339. Stored Procedures?
  340. VBA functions to create a PDF rectangle with a shadow
  341. Problem with form
  342. Help for C# Interview questions and career decision
  343. joining queries
  344. Code for finding name of relationships
  345. How to programmatically determinae the field name referenced by query param?
  346. Automatic backup's Access 2003 database
  347. Change a lot of words in a table
  348. DCount.
  349. A97 error #3067 occurs when it really should not
  350. How to fill a for automaticly(just some boxes)
  351. I need a personal code library
  352. Null Values or Wierd Behavior based on a user's profile
  353. Form for 2 tables
  354. Alternative to lookups in tables - questions
  355. Transactions for linked SQL Server Tables?
  356. Saving ODBC SQL database to "local" mdb?
  357. Include word doc(s) in report
  358. Data Access Page problem
  359. problem - open recordset - ADO
  360. question about % in reports
  361. DAO 3.51 and DAO 3.6
  362. Access Treeview - Is it Safe Yet?
  363. MDAC
  364. How to use parameterized query with DAO Recordset?
  365. Change Focus triggers Before Update
  366. PostCode-Zipcode
  367. Linked Tables, access security help.
  368. compare tables
  369. Use not local admin Outlook Fails
  370. "Too many Fields" error running query with <255 fields
  371. ie 6.0 and Access2k
  372. Understanding ODBC connections...!
  373. Using nested subform
  374. Linking Tables in Access
  375. A97 - How to automatically export a table to ms excel data-file from within code?
  376. numeri
  377. Invisible Query Head-Scratcher
  378. Upsizing
  379. How to supress message when dynamically setting Report recordsource
  380. Problem deleting ldb file
  381. Foreign Key with multiple columns and null value
  382. exporting access data to excel for calculations and reporting
  383. Unlock/edit a database...
  384. Like criteria
  385. requery a subform on a form
  386. Generating an Index
  387. How to get a query to pick up the value of the active form
  388. A2003 Backend opens in read-only intermittently
  389. &Relationships Bug - workaround
  390. How to set Startup Properties in MDE?
  391. In trouble! Db locked with exclusive access
  392. How to put controls on a form with VBA code
  393. setting fields based on values of other fields
  394. Table Structure - Using Query with Form for Input
  395. If a field is keyed in, then delete other fields
  396. compare two tables using this module?
  397. Ordering fields in query based on current date
  398. How to send emails from ms access..
  399. Modems and Access2003
  400. How to parse CITY ST ZIP+/-4
  401. Allowbypasskey property
  402. Append to master replication table
  403. Open a DB from the switchboard of another DB
  404. Only add Valid Payments on a Report.
  405. Calculate Number of Years, Months and Days between 2 dates
  406. Oracle 9.2 attached table real slow and data incorrect with Access 2003 SP1
  407. Lock an access db
  408. Printer / Report issue with Office XP over Network
  409. Can't Import a .dbf File
  410. Default combo box line
  411. Setting field properties in code
  412. REPOST: Unique connection ID not name.
  413. Creating new field in code
  414. Using combo boxes to fill in other bound controls not working..
  415. restoring default printer
  416. Trouble moving Access tables to SQL back End
  417. Enter Parameter Value showing up when already defined
  418. Assign textbox value from command button
  419. How do I refresh a control
  420. How to handle with "&" in text
  421. A97 - I've been looking for a position counter to display on a form the current character position of cursor
  422. A97: MediaPlayer.MediaPlayer.1 control on a form - how do I use it to play a .wav file
  423. Payroll DB
  424. Won't let me remove tables
  425. A97 - how to format time lapse to appear as "4-minutes 12-seconds"?
  426. A97 overflow error returned when trying to calculate 192/(24*60*60) - why?
  427. combo box choices
  428. How to speed up reading input from a text file?
  429. Split master table into smaller tables
  430. DoCmd.SendObject acSendNoObject Inserting Hyperlink in message containing a space.
  431. Need help to read database contents - very tricky
  432. How to Update ignoring validation rule
  433. A97 variable length string declaration - how to do?
  434. check box changes subform operation
  435. acCmdInsertHyperlink defaults "Browse for" File
  436. Catastrophic noob... can anyone help?
  437. ComboBox source query: run at Form_Open
  438. Access hanging periodically
  439. How to display multiple pictures per record in an Access database?
  440. Cancel Click Of Check Box
  441. 'Invalid bookmark' or 'database engine stopped the process' errorswithout corruption?
  442. Unique connection name?
  443. Mixing two Image samples by Lebans
  444. Access and vba in excel
  445. FE & BE Version Control Tips?
  446. Determinaition of Paramatric Queries
  447. using query results to populate a list or form
  448. Combo Box - NotInList Event - need help
  449. How do I link a control to the value in a form?
  450. Help needed w/Crosstab Query and Col Values
  451. Finding the current computer name in VB?
  452. AddItem not adding columns to listbox
  453. How to compute age in a query?
  454. Simple question about Cancel Event
  455. Accessing list of files from disk
  456. MDE Don't work
  457. Preparing for .NET Interviews
  458. How can I run an insert query on report
  459. Second Request - Can I return a value from an ACCESS report to VB?
  460. OpenRecordset & 3027 read only error
  461. Set a variable equal to the result of an sql query
  462. Question about moving Access app to web
  463. format for naming recordset field
  464. Display a report in a form...
  465. Determine if user has local admin rights in VBA
  466. Please Please Help!
  467. Find how many similar records..
  468. File already in use
  469. Problems Subclassing in Donors/Donations DB
  470. How to use static variable to exit function?
  471. How can an AutoNumber field start at some other value
  472. Put four queries into one
  473. Using combo-box as a user filter - trying to use format to display text "all" for null values
  474. Effects on RST in Calling Proc
  475. How to influence two tables with one form
  476. Access 2000 date range using today's date
  477. Build comma-delimited list from table
  478. Outlook mailitem
  479. Evaluating Complex Recordset Field Statements
  480. Compute Name , Is it a good idea to use it for copy protection?
  481. Predifined text and starting from the last record(in a form)
  482. Does ACCESS have the MINUS keyword
  483. Form_Dirty is not firing
  484. Parameter Query and Date calculations....
  485. Slow Update Queries
  486. Check box controls subform control source formula
  487. Subform not allowing creation of new record
  488. user permission
  489. MS Access Database with Remote Desktop - Multiple
  490. Error trapping code
  491. A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
  492. converting ACCESS to Stata using Stat/Transfer
  493. dirDataCopy error message when converting to Access 2000
  494. Comverting Dates
  495. Left Join Not Supported - translated from legal SQL statement
  496. Tables Queries Criteria oh my!
  497. Transferspreadsheet File Name Limit
  498. Tree view adding duplcate keys
  499. Is it possible to open an Access Macro as a recordset in VBA code
  500. VBA to Word problem
  501. Running code in one form from another
  502. Duplicate query recordset
  503. Lock Down Titlebar in Form
  504. Keywords
  505. Access 97, XP and 3170 Couldn't find installable ISAM
  506. Full menus
  507. Trouble working with not between
  508. mail merge
  509. mail merge
  510. mail merge
  511. Importing Excel Spreadsheets Into Access 97
  512. Date format cannot be controlled
  513. Date format cannot be controlled
  514. Problem with inner join
  515. Set and restore permissions using VB?
  516. Calculating the dwell time between two Records
  517. Control format property in OnFormat event
  518. Can A2k co-exist on a Machine Running A2k3
  519. edit word document
  520. How do I refer to a series on an MSgraph in access?
  521. Concatenating text fields with a WHERE condition
  522. Anyone use Visual Studio Office Dev Extensions?
  523. How to open default email program when I store some email addr. in a field?
  524. hiding record navigation button in forms
  525. raport and null problem
  526. IIf Function based on field value of continuous form
  527. TransferText
  528. Drawing objects in Access 2003 - can it be done on forms?
  529. delete all text starting with ..
  530. Help with counting occurances of similar text
  531. Before Update
  532. Help with an SQL query (opposite to a union query - if it exists)
  533. File Not Found error when importing forms from another database
  534. Adding Incremental Records
  535. Date Conversion
  536. running an update query from form...can I just use the sql cmd
  537. subform question
  538. backend corrupt
  539. Handling Apostrophes
  540. can someone tell me what I am missing with strings
  541. Need check box to change formula used in subform source
  542. Combining two queries
  543. Display one to many records in a mail merge
  544. I used to see a menu item/short cut menu to translate macros to code
  545. locking down tables
  546. Blank Form
  547. Adding a column in report
  548. Help with simple database concept
  549. Open the Outlook Addressbook in VBA
  550. Exporting To XML File