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