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] 122

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