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