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