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. Make Reports Open 100%
  2. Help needed with a complex query
  3. Need Some Help
  4. Updating back-end
  5. Multiple Search Criteria
  6. Make Products/Orders Query Updateable.
  7. Adding users to secured database
  8. Hiding zero values in text boxes?
  9. How to check user input for illegal characters?
  10. IsNull Or IsNotNull problems
  11. storing a variable
  12. ..SendObject...[help]
  13. Display Record number is a Control
  14. Why can't I Kill temporary database?
  15. Selection Does Not Appear In Combobox
  16. Conversion from Access 97 to Access 2000 (or XP)
  17. !!FAQ! for Date: 20031001 - New Users Look Here! [Last Updated July 24, 2002]
  18. ? about adp and connections
  19. Query Expression to Return a Part of a Field
  20. Printing multiple reports!
  21. Select multiple items from drop-down list
  22. Form won't open correctly if there is no data
  23. SQL Query
  24. Recently edited records
  25. Crosstab with month/year ... count and average
  26. Access Special Keys
  27. Need help: How do check the -FULL- Access version number in vb??
  28. Counting with and comparative list
  29. SQL Query looses order after UNION in A97
  30. Access 97 - Update Multiple Tables from one form
  31. variable (long) as criteria for Dlookup
  32. DoCmd.OutputTo acOuputQuery -- Eats Query! Where did all my SQL go?
  33. Contradiction between TOP and ORDER BY in a ranking query
  34. changing code by code
  35. where_condition in Sub-Reports !!
  36. "exclusively in use" problem
  37. Changing a Library Reference
  38. Compiling Access XP to run under Access 2000
  39. Code to select a record
  40. Word not opening properly during a mailmerge
  41. Selecting in a Listbox an Unbound column
  42. Security - mdw or different interfaces?
  43. Report line spacing.... a property?
  44. help - why doesn't OpenRecordset work for a Query..??
  45. How do you tell A2K developer the default location for the application?
  46. Version Conflict with Package & Deployment
  47. The ONE scenario never addressed in books
  48. VBA array basics - how to test for value?
  49. Trapping a next record event in subform
  50. Combobox value is wrong
  51. sendobject to multiple recipient...help
  52. dropdownfield
  53. Transfer Date of Structure Only?
  54. Install Access 2000 on Windows XP that has Office 2002?
  55. Access Queries vs Tables in ASP pages
  56. Upload of database to ftp-server
  57. Between [Enter Start Date] And [Enter End Date] in QRY Problem
  58. !!FAQ! for Date: 20030930 - New Users Look Here! [Last Updated July 24, 2002]
  59. Access 2000: Need a count of entries by state.
  60. Commercially producing a product
  61. populating textfield from multiple records
  62. access won't close after conditional formatting
  63. errors in my calculation text box
  64. Calculating time difference
  65. Retrieve list of objects in a group on the database window
  66. Need help on a query
  67. how to create stored procedures & triggers in MS Access?
  68. Access form to ASP.NET
  69. Subreport Page Header Problem !
  70. Change from access 95 to 2000
  71. Changing Account on Outlook
  72. Application.Run or not as the case may be.
  73. Auto number field display question
  74. problem creating recordset from two tables
  75. Is there a way to find objects ?
  76. Runtime Access 2002 crashes under Windows 98
  77. Access and VBA
  78. duplicate records - based on different fields
  79. Filter Form through sub-form values
  80. any idea where to start looking for code that is somehow causing 9's to be printed in the immediate window???
  81. Help!! Absolutely baffled ...
  82. Kick Em Off
  83. Create Multipal Times...
  84. Difference from .mdb to mde?
  85. Keeping Sub Reports Together
  86. Currentdb in access 2000
  87. Access 2002 Conflicting Access 97
  88. Macro to Module
  89. Pivot Table Sort Order
  90. Weird Import Request
  91. Log Users both compteted and failed...
  92. Network Headache with transferdatabase
  93. VB rounding solved....problem converting back to text field
  94. how do i query a non active student list ?
  95. Putting records in Ascending or Descending Order in a Form
  96. Regsvr32 with TSISOON.dll fails on WinXP
  97. Create pre-designed report from an existing form
  98. !!FAQ! for Date: 20030929 - New Users Look Here! [Last Updated July 24, 2002]
  99. Sorry -- Creating Option Buttons ... 2nd thread
  100. Urgent Help Pls : Can not update Import Specification in ACCESS 2000
  101. Access 2003 file - how to read it in Acc2000
  102. Access/Citrix
  103. Raclette and Time stamping
  104. connecting ms access with sybase
  105. unqueried fields have effect on results
  106. Question: anyone know a way to get a 'CanGrow' feature to work for images in a report?
  107. Corrupt database - 1 step forwards....
  108. Twist on 'Tabbing to the next record' bug
  109. Synchronising Acces DBs over the web
  110. Access 2000 and Unicode support
  111. Additional Wizards for MS Access 2000 and Excel 2000
  112. Lost mdw security file in Access 97 files - commercial vendor referral?
  113. UPDATING FIELD ENTRY ON ANOTHER TABLE
  114. Advice on Synchronization
  115. Form List Box
  116. Report Headers - Auto Populate
  117. not null
  118. duplicates
  119. How to check for empty field?
  120. Open Pivot Table in Pivot Table View
  121. Access RT problem
  122. Automation to 2 Word Documents
  123. Class Grades
  124. Function In Query Criteria
  125. Conditional If
  126. Invoicing table structure question
  127. is this a subquery problem?
  128. a simple lookup or a subquery!?>
  129. Internet Transfer Control
  130. Building a simple database for school, please help
  131. Linking two databases on a net
  132. Syntax Error in Query Expression - Help
  133. importing data
  134. Open database window from a button in code
  135. Query Parameter using Function
  136. Recordset Error
  137. Continuous form behavior
  138. OT Problems reading some threads in this group
  139. Query on a Switchboard ?
  140. Report sorting and order of fields problems
  141. Creating custom labels design question
  142. Relationship view - can't select table
  143. SetFocus problem when in "OnExit" event
  144. If and End If
  145. Function Error in Query Expression
  146. Password protect backend
  147. Re Acuring Data in Forms
  148. file attachment in vb 6 and access 2000
  149. Limiting users
  150. Converting DBF to MDB
  151. problem with global variables
  152. Access not finding linked tables
  153. How to Pass an COLLECTION as an Argument to a Procedure (PART 2)
  154. Understanding Dlookup function ...
  155. Sequential numbers
  156. protecting VBA codes
  157. duplicate query
  158. Max Size of an Access DB?
  159. help building a db for monthly billing?
  160. String query
  161. Subclassing entities
  162. Filter and sort a form
  163. connection string
  164. SQL - counting various tables and various records in one query
  165. Q: How to sort on multiple selection in continuous form
  166. Split database (single front end w/ multiple backends)
  167. subform problem
  168. Sub-Query chaos!
  169. SQL and VBA
  170. min/max values from one table to another
  171. Conditional Report Group Footer/Header using VBA
  172. Costum Alpabetic Sorting in Access
  173. Relation / Table Structure Question. Location Heirarchy. Please help.
  174. Weird query, need to copy information...
  175. Win XP Screen Resolution (also ACG SOFT)
  176. List of best athlets and not best scores. Problem with SQL command
  177. Opening a Report does not update OLE Excel object
  178. Would like to tabulate occurrences of words in a table
  179. Printing report of subform data
  180. office 2004 question
  181. Determine dates occupied
  182. DSum Assistance for Building Expression
  183. Display information that is based on other fields
  184. Automation error on combo box creation
  185. How To Pass A Collection To A FUNCTION ??? (Access 2000) Sample Code Included
  186. end date
  187. Access 2003 - database file limit
  188. Stephen Lebans' CanGrow function (Access97)
  189. Method error when adding a control object using VB
  190. Multi Exporting
  191. Keeping an eye on . . .
  192. Delay or Wait Subroutine
  193. Date Formatting Problem
  194. Error Handling
  195. database table/form design
  196. How to export a wide report to text
  197. Prompted for parameter on OpenReport
  198. Access 2002 Performance Issues
  199. Nested function
  200. Simplifying code in a Function Module.
  201. SQL performance: Nested SELECT vs. INNER JOIN
  202. Problem with limiting content from one Combo box to another.
  203. RunningSum options: Query or Report?
  204. Menu Button Error Woes
  205. Flexgrid control - No License error. Eh?
  206. join question
  207. Check if memo field is empty
  208. save query crashes access
  209. sql string questions
  210. Have you guys/gals been keeping an eye on MySql/MaxDB?
  211. Linking form and continuous subform
  212. How do I...?
  213. Creating report with current record only
  214. Access Query and Invalid Argument Error
  215. Keeping the internet connection alive
  216. Tables-default value
  217. Insert Ole Object Error 2793
  218. Web-based editor?
  219. Microsoft Jet 4.0 Service Pack 8?
  220. Mods have slowed the database
  221. Detecting names of Tables and Queries in Catalog
  222. Access 97 Data entry form questions
  223. Finding no detail record....
  224. MS Access 2k Switchboard alternative
  225. ACCESS 97, Pessimistic Record level Locking!???
  226. intenret transfer control - keeping connection alive
  227. Combo box in access project
  228. left join bug (?) in MS-Access 2000 SR-1
  229. Access 2000 app not working on winxp
  230. Internet transfer from behind a proxy
  231. Progress bar needed during Excel macro call from MS Access.
  232. Open Word from Access problem
  233. DoCmd.SendObject leaves recipient field blank?
  234. COUNTING YES/NO FIELDS
  235. Find/Replace On Form
  236. Recordset basics - How to set Form Recordset?
  237. New Access 2K Bug?
  238. Open File in other folder
  239. Export Numbers to text
  240. Using Make Table Query - Do I do this in the .be database, or the regular one
  241. How do I paste a VLS (very long string) into a textbox control on another form?
  242. Hyperlink Problem
  243. ADP Table import error
  244. CRM database
  245. !!FAQ! for Date: 20030924 - New Users Look Here! [Last Updated July 24, 2002]
  246. Sort query from Form
  247. I can't set Text property for a TextBox control to a string???
  248. Deleting Relationships...
  249. Calculate age in yy/mm/dd format
  250. Finding pointers to recordsets inadvertently left open...
  251. Crosstab as subreport data source
  252. Module Code Windows: Setting Tabs
  253. Find a field in hundreds of tables
  254. Outlook "notifying" Access of an incoming email? Opening an attachment?
  255. duplicates
  256. DSum Assistance
  257. vba reports and queries
  258. Spaces and path
  259. Error zero
  260. Problem inserting to an Access database
  261. Database building
  262. Database connection over wireless network
  263. Compacting a BE with both 97 and 2K
  264. Combobox dropdown on every record change
  265. You can't assign a value to this object
  266. How to to put the result of a query into a variable?
  267. Using IFF statement in Access
  268. Filter Report on multiple selections in a list box
  269. inet control problem
  270. Can this be done?
  271. How to change fixed path?
  272. Visual Basic Help error in Access 2000
  273. Dynamic Link Library
  274. Front end larger than back end in Access 97
  275. Auto populate previous Saturday's date
  276. pass parameter to query in vba
  277. Listbox - Impossible Problem
  278. BoundColumn not accessable with VBA ?
  279. condition
  280. Access 2000 corrupting pattern - diagnosis please?
  281. The Second Commandment (of Access)
  282. Queries - using the AS clause with functions, field names
  283. HOWTO: access a form outside of MS Access
  284. referential integrity error in access table is not throwing an exception in VBA
  285. Filtering records in a form based on records in subform or related tables.
  286. Left join problem
  287. Updating Mutilple Fields with a Single Combo box
  288. Access97 to Oracle8i odbc-problem (SQLSetConnectAttr failed)
  289. Access on Citrix - memory usage
  290. Identifying opend forms
  291. Advice needed: Move Access application to web application
  292. Reference of SQL commands in Access?
  293. linking on null value fails
  294. Tab Control question
  295. Personal follow-up to "Open Question" thread
  296. looking for office 2k developer package
  297. Microsoft Office 10.0 Object libary reference not working??
  298. report lay-out & reading data from txt-file
  299. Registration of software code
  300. Built-In Functions in Access?
  301. Can I assign the value of a variable to a filename ?
  302. Problem Using TransferText
  303. Database window problem
  304. Modify Code
  305. show different colors on a continous form
  306. Force form resize bigger than screen?
  307. Time Duration Problems
  308. Updating a forms underlying recordset.
  309. Permissions
  310. ODBC Connection to Oracle Server Failed
  311. Trun off Access warning message when sending email from Access
  312. X=Shell("C:\Windows\wordpad.exe c:\cr\docs\packets\ntrolttr.rtf", 1)
  313. Test for a table
  314. Update table with out duplicates
  315. !!FAQ! for Date: 20030922 - New Users Look Here! [Last Updated July 24, 2002]
  316. Creating Option Buttons or check boxes with Access 2000 using VB
  317. Keeping a record of repeating invoices
  318. sql delete
  319. Adding and updating records based on results of a query
  320. Winsock
  321. SQL chr(10) & chr(13)
  322. MkDir Method
  323. Parent and child information on one form
  324. Fill blank field with data
  325. Count Files In A Folder
  326. Criteria In Date Field
  327. Get first letter of each word in a string
  328. Is it a safe assumption? - email addresses duplicates automatically deleted
  329. Merge Text Files
  330. Selecting a record and calling up a separate form
  331. HELP! Retriving field names and properties from MS Access database using ASP
  332. !!FAQ! for Date: 20030921 - New Users Look Here! [Last Updated July 24, 2002]
  333. Exactly where is it that I get kicked out of a Do Until ... Loop while traversing records in DAO RecSet???
  334. Best design for replicated database
  335. Can the error handler be made to return code line number being processed when execution was sent to handler?
  336. Word doc history
  337. Adding elements to listbox
  338. Two Field Integrity
  339. problem updating a database with result from query
  340. Table relationship question
  341. Remote access - TS, pcAnywhere?
  342. Help required to unravel databases engine related Error Message
  343. Access 2002 crashes my 2000 db
  344. Upsizing MS Access - lessons learnt - Part 2 (Testing) + Insert Into SQL table
  345. Unable to track error 3058 (LinkChildFields in subform)
  346. Converting Access Desktop Application to Client Server
  347. !!FAQ! for Date: 20030920 - New Users Look Here! [Last Updated July 24, 2002]
  348. JDBC-ODBC date updates
  349. SQL Serv Syntax Error or Access Violation
  350. Upsizing MS Access - lessons learnt - Part 1 (Tables)
  351. Security in Access 97 - Secure a controll
  352. RDBMS server engines - an overview?
  353. Freeze Column
  354. To OOP, SQL DOM or DCOM?
  355. Concatenation produces calculation instead of concatentation
  356. Setting properties at runtime access2k
  357. Using words with apostrophes in filter
  358. Multiple default values - how?
  359. Unlinking a subform
  360. Auto Fill Forms
  361. Q: How to open subform to particular record
  362. SQL and Access 2000
  363. Report Shows the "Return" Character
  364. problem with program autorunning an .mdb
  365. Access-XP - ADP Should I or shouldn't I???
  366. Exporting to Word and including graphics
  367. Opening with Thumbnail view in com
  368. !!FAQ! for Date: 20030919 - New Users Look Here! [Last Updated July 24, 2002]
  369. Security--users losing permissions they once had
  370. Date query
  371. How to display Images from a table in MS Access onto asp form
  372. strange behaviour?
  373. Help combine two records
  374. Visual Basic connecting to Excel
  375. joining and linking 2 tables coming from a make table query
  376. Auto Detect New file On FTP Site
  377. Access irc channel
  378. Can't delete "lock" file
  379. how close excel object
  380. Access 2000 MSI Wizard
  381. Comparison Operator for Date
  382. Sorting 'n grouping records in a report = easy. How about trying to sort 'n group those same recs fed to a Function???
  383. Switching to a specified open application window...
  384. Updating A Chart On A Form
  385. Date problems in Access97 developed Apps
  386. Overwrite duplicates
  387. ADO and finding control names
  388. Unrecognised command in Win2000 but not in Win98
  389. Memo and Text data type combined.
  390. Pass Parameter to Query using Function
  391. pivot table issue
  392. No 'real' relational databases?
  393. !!FAQ! for Date: 20030918 - New Users Look Here! [Last Updated July 24, 2002]
  394. Including a Blank Field in a Key
  395. /decompile and updatable recordset
  396. Update A Chart In An Unbound Object Frame
  397. Printing to File
  398. sample "ledger" access database
  399. Hyperlink won't work
  400. ODBC Microsoft Access Driver] Could not update; currently locked Error
  401. Creating Snapshot of a Report in A2002
  402. Snapshot Viewer
  403. Which is the corresponding of "\n"?
  404. combobox contents from db
  405. sql concatenate
  406. search and separate a string within another string?
  407. Copying and pasting into a memo field - how can I split at line breaks?
  408. Fine-grained security in Access (record-level)
  409. Access and Russian an azerbadjan caracteres - any problems?
  410. To MLH
  411. Updating A Linked OLE Object
  412. finding form control names
  413. Sub Form Control Events
  414. How can I set the Windows Shortcut 'Start in' Parameter from Access?
  415. field name length exporting to .dbf
  416. Any better alternative for MS Graph
  417. OLE Object Linking
  418. Dotmatrix page length on XP
  419. Access 2000 on a Flash Drive
  420. Sql Server 2000 linked server to Access 97/2000 incompatability
  421. Compact on close - bad idea?
  422. Can't combine memo & Text fields in a query.
  423. Updating a record with Value from a combo box
  424. Closing objects vs setting to nothing
  425. ConstructionEstimatingDatabase
  426. What happens when Office 2003 gets released?
  427. Determining Position In ItemsSelected Collection
  428. Join expression not supported - using Access 2000 and CF
  429. Permissions Issue when linking to MS SQL 2000 DB from MS Access XP
  430. Basic help (i think)
  431. Access 2002 #ERROR
  432. Seeking reliable Add-In or other solution to create RTF files from A97 & A2.0???
  433. 80040e14 Syntax Error (missing operator)
  434. !!FAQ! for Date: 20030917 - New Users Look Here! [Last Updated July 24, 2002]
  435. Strange way of optimizing a query
  436. new..want to have a cell give result (a number) of all 'yes' s in another field
  437. Form/Report Problem
  438. Validating field on the basis of the value of another field
  439. Percentiles
  440. What am I doing wrong that I never receive any reply??
  441. Sub Report Name Displaying Instead Of Data
  442. Old DOS guy seeks help...
  443. MDE
  444. OLE Images and Forms
  445. Autonumber rows in reports
  446. Error 2467:The Expression you entered refers to an object that is closed or doesn't exist
  447. Fields formatted as short time shows date on enter
  448. Annoying Locked Record
  449. Background picture problem
  450. How to Tab to controls on the form footer?
  451. coding a command button
  452. Access not saving form design changes but saving code
  453. Last Active Control
  454. Dim problem
  455. Where is un-bound data coming from?
  456. Using Send in WordPad, shelled to from Access...
  457. DAO or ADO in an MDE data base?
  458. Date Update
  459. SHELLing out to WordPad?
  460. Date Query using the NOT operator (Access 97)
  461. problem query
  462. Word 97 and Word 2000 createobject problem
  463. Pervasive SQL or Btrieve -> MS Access
  464. Exporting the maximum characters.
  465. Printing a Word document on a report via Hyperlinks
  466. Automation Error: Catstrophic Failure [Long]
  467. Sub or Function not defined
  468. !!FAQ! for Date: 20030916 - New Users Look Here! [Last Updated July 24, 2002]
  469. Linking to SQL Server 2000
  470. InSrRev( ) problem
  471. problem query
  472. Automatically switching pages in Form
  473. Can SendObject be used to send more than a single attachment?
  474. Query is too complex
  475. Visual Foxpro program to create a table archive (stores last month's data which isn't needed for this month's report), use visual basic to write??? possible? how?
  476. Embedded Object Frame in Access - editing text contents???
  477. Removing data in a query.
  478. Help with MSCAL 7 calendar control
  479. Calling a subform function from a main form
  480. Q330994 applies to Outlook Express. I'd like to remove part of its functionality???
  481. How could a database spontaneously loose it's indexes?!?!?!?
  482. Suggestions for Date and Count?
  483. Problem Mapping a NetworkDrive
  484. Union Query Question
  485. Double Click for Open Form Failed
  486. Errors in Currency Rounding
  487. Automation of key strokes
  488. MS Access and Digital Cameras - (Without the Typo)
  489. Dialog Form for Report Not Working
  490. Sending parameters?
  491. DataDirect Server Wire vs. MS ODBC
  492. Blanks in ColumnNames causes ODBC-Error
  493. How to set line indent in Word with VBA (Access)
  494. Relational Database Design Question
  495. Creating Excel objects causes Automation Error
  496. MS Access to HTML Conversion
  497. Report footer on separate page; optionally hide it, reduce total page count by 1, and don't print last (blank) page
  498. Calling up OutLook Express from Access Basic in Access 2.0?
  499. OutLook Express prompt...
  500. Access 97 /Runtime Causing Locked by User Preventing Other Users From Logging In
  501. Update query using Subquery Not working
  502. automating email from Access 2.0
  503. Changing ODBC password in MS Access
  504. Missing default values in form bound to a linked Sql Table
  505. deactivate event fires every OTHER time
  506. Hiding field names
  507. an access query for a confused banker
  508. HOWTO: use RowSource property of a field in MS Access table
  509. Records visible in Access 2K not visible in XP
  510. databas 2000 transform to 1997
  511. Importing text files in to Access
  512. which table design is more correct?
  513. Checking if another MSAccess database is currently running
  514. Now function
  515. Who is in the database?
  516. Problem getting data from a form
  517. Help with CASE button problem
  518. Recordset access and pin-point record question
  519. A97 FileSearch Object - problem
  520. Error-trapping question
  521. Form Command Button Difficulty
  522. Can't open secure Access97 db
  523. Can't open secure Access97 db
  524. Automatic removes data
  525. Connectivity problem using file DSN
  526. Dialog Form, ComboBox, Filter and Report Blahs
  527. Drop down table
  528. Report problem
  529. Thanks Allen and other access guru's (was how to fill a bound text box automaticlly)
  530. Add Kernel32.dll to access references
  531. Access 2000 query not working same as Access 97
  532. Function in QBE grid not returning correct data(?)
  533. Multi-Section List Box
  534. OLE Error
  535. Running Report Wizard From a Button
  536. Getting a Duplicate Primary Key Error
  537. Hiding a table using VB. Also Registry entries
  538. Winzip command line add-in
  539. Kill Statement
  540. column definitions
  541. Date displaying
  542. SQL query
  543. How to prevent Error 3052 ?
  544. Automatisk ID nummer (sammeslags og cpr.)
  545. How to pass data from a ms access form into a new Word document
  546. Query on the fly?
  547. Open question - leverage all features liberally, or be selective?
  548. A2K - changing control property at runtime - is this possible?
  549. Possible to query distant Access database?
  550. Access on the web