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. Using IIf in Criteria for a query
  2. getting query result to show in sub form.
  3. Report Based On Crosstab Query Question - A2K
  4. Macro condition: how to determine if a column exists?
  5. Convert minutes to hour and minute in MS Access 2000.
  6. Single INSERT statement creates Duplicate Entries!
  7. Modal Form & Minimizing Access
  8. Looking for testers for mdb
  9. Explosion
  10. Derived Columns in one to many relationships
  11. displaying table names based on tabledef properties
  12. Creating a variable from an expression
  13. Creating a variable from an expression
  14. Help vs Online Help
  15. REQ HELP: Batch Print Multiple Reports to Pdf file(s)
  16. Help with pre-printed form
  17. CreateQueryDef and Execute
  18. Rounding time
  19. !!FAQ! for Date: 20040817 - New Users Look Here! [Last Updated February 05, 2004]
  20. Key-assignment
  21. Validation Rule for Date (1/1/yyyy or 12/1/yyyy)
  22. most recent date
  23. activeX component can't create object
  24. ftp into access
  25. Access Instant Messenger
  26. Come on you MVPs...Access to Indexing Service...can it be done?
  27. Undefined function Format
  28. Date and parameter issues with dynamic SQL creation
  29. Get recordset from an open query window
  30. Runtime when usin Win98
  31. Need SQL for Joined Tables
  32. Popup Forms
  33. Barcode reader using Access
  34. Store List Box values
  35. Missing Help Files
  36. VBA or VB.NET?
  37. More Data Type Mismatches - It Makes No Sense
  38. Restricting output
  39. overwrite ADE file when application is opend at client pc
  40. Format a specific time in Access
  41. [SUBCLASS] Problem on A_XP
  42. Problem with automatically sending an Outlook appointment generated in VB in Access 97
  43. sub form scrolling
  44. !!FAQ! for Date: 20040816 - New Users Look Here! [Last Updated February 05, 2004]
  45. Web Page
  46. How to change orientation in ms word with vba
  47. List Box Column to Memo truncates at 255 characters
  48. format query expression from dialog as percent
  49. What issues can I have with an large Access database
  50. Access and Newer Development Platforms
  51. MS Access 2000 corrupt's databases
  52. ODBC Linking
  53. Security in Access installation
  54. VBA in MS Word and MS Access different (use of external COM objects)
  55. POS printers (point of sale)
  56. VBA - Get Open Windows
  57. !!FAQ! for Date: 20040815 - New Users Look Here! [Last Updated February 05, 2004]
  58. Doubt in ado control
  59. Picture Problem
  60. printing checks
  61. Creating HTML Pages from Access 2000
  62. Calculations on a report
  63. scrrun.dll version 1
  64. Problem with a Union of two criteria in a query
  65. VBA Run Query and Prompt forQuery Parameters
  66. Font problem in Report...help wanted.
  67. Spaces in query output names
  68. !!FAQ! for Date: 20040814 - New Users Look Here! [Last Updated February 05, 2004]
  69. Group By
  70. SQL - how to expand this via sql only please?
  71. General SQL Question
  72. Asking for database password
  73. columns in reports
  74. Comparing Tables
  75. How can I erase a linked field of a record
  76. Wininet And WinXP SP2 Heads Up
  77. RE-NUMBER KEYS WHEN NEW KEY ADDED
  78. Access 2003 upgrade question.
  79. Question on Queries & Forms
  80. Access File Exports
  81. Outlook Appointment in VB
  82. Dev Avishs Internet Transfer Library & Logging in
  83. !!FAQ! for Date: 20040813 - New Users Look Here! [Last Updated February 05, 2004]
  84. Input Data from Text File - Checking for Data Already in DB
  85. Best way to convert query to VB SQL?
  86. Report conditional formatting based on recordset comparison
  87. How to do Query by Form?
  88. Default Field Size question?
  89. Combo Box Drop Down without the focus
  90. Dcount function, return dates in last year in criteria
  91. a2k Turning a single-user app into a multi-user app
  92. Latest Date Query
  93. Missing properties in VB
  94. Report parameter not working
  95. Database Efficiency
  96. Extracting embedded OLE documents from Access
  97. Trim/RTrim not stripping trailing space characters in Access 97
  98. Update Query
  99. Run-time A2003. Edit path to wrkgrp file.
  100. Searching on a text field
  101. import a textfile with vba
  102. MS Access on PDA's
  103. help with DoCmd.Close
  104. Subform load order and "Invalid reference to the property Form"
  105. Subform load order and "Invalid reference to the property Form"
  106. Access Lotus Notes Email, Changing Sent By Name
  107. Graphs working in 2000 and 2002, but not 2003
  108. selecting multiple records to edit
  109. Structuring question - many attributes per person in table
  110. Run a procedure on multiple rows
  111. MS Works 6.0 to Access 2000
  112. Reorganising the contents of a list box
  113. Trouble sorting a column by month
  114. Date field manipulation
  115. Need better argument for using bound forms
  116. Recordset operation seems to hang
  117. How to print a report to a PDF file via code?
  118. !!FAQ! for Date: 20040812 - New Users Look Here! [Last Updated February 05, 2004]
  119. Access with word mail merge
  120. updating a field on a particular day.
  121. dao reference confusion: access 97 to 2003
  122. opening a form with a large recordset at a specific record
  123. Query Specific Years
  124. Order of the tables searched
  125. Tab Control - Slow opening
  126. Work with XP but not 2000? Access 2000
  127. (dhl) Who using database
  128. NotInList - NewData split over 3 Fields
  129. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  130. Combo Notinlist - add new item
  131. SQL Help - Selecting first, second and so on
  132. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  133. list box as query criteria
  134. Subform Problem
  135. Combo Box Update Table
  136. Text File Import
  137. Graphical Report Examples?
  138. Row data transfer between tables using a form interface
  139. Snaking columns subreport not snaking when added to main report
  140. How can I pad a number to make sure it's 5 chars in length?
  141. Access 97 Compile Error---any other suggestions?
  142. Recordset update is skipping every other record
  143. DataGrip Director Fatal Error - Need Advice/Help
  144. DoCmd.TransferSpreadsheet
  145. Pass report name to module
  146. Module works, can't open it in Macro
  147. Access 2000 connect to Outlook Inbox
  148. Dealing with ties in ranking code
  149. Reading a text file
  150. Copy Displayed info from a Form to Table
  151. Copy Displayed info from a Form to Table
  152. Running queries via forms
  153. Output Graphics
  154. How do I uninstall 2003 Run-time app
  155. Row Height
  156. report+2 labels
  157. Counting the periods ( "." ) in a large block of text???
  158. Connecting
  159. Data type mismatch error - why?
  160. Why should I use VBA instead of queries?
  161. Notinlist Event
  162. Simple Question?
  163. Quicker/automated way to process single quotes in an INSERT statement?
  164. Printing Reports with Bitmaps
  165. t-sql UDF syntax error help!
  166. Inserting results of a recordset in Chunks
  167. MS Access Forms problem
  168. Report/Subreport Question
  169. help in importing excel spreadsheet !!
  170. Automating a Compact
  171. referencing a DLL from a ms access 2000 database?
  172. Creating report from listbox data?
  173. On Row Data Bind?
  174. Method 'Form' of object '_SubForm' failed
  175. Interesting Combo Box question
  176. Maximum bytes that can be stored in a string variable?
  177. Please help! A2K Memo field showing error "Too much text to edit"
  178. Missing Controls on Form
  179. Sorting form records on the unbound column in a combo box on the form
  180. How to design dynamic table (Unknown number of cells)
  181. HELP WITH REPORT TOTALS
  182. Data Source - Tab Control
  183. createdatabase creates wrong version of access db
  184. report subform print control
  185. VBA Programming Ported over to Excel
  186. Automation Error
  187. Problem with Deleted Records
  188. How do I programmatically set macro security to Low ?
  189. Compare Tables Between Databases
  190. Split database slow over the network
  191. !!FAQ! for Date: 20040810 - New Users Look Here! [Last Updated February 05, 2004]
  192. Table design
  193. Help Needed to Create Special Records
  194. Documentation for various refernces appearing in VBA compiler - "FundWare"
  195. Documentation for various refernces appearing in VBA compiler - "FundWare"
  196. easy data entry?
  197. Compact database error
  198. Need a combo box with only certain numbers
  199. InputBox date prompt gives wrong month
  200. HELP! Old ODBC Drivers on Windows XP
  201. Problem using an interlocked WHERE-Clause
  202. Can't open database in A2k
  203. smtp emailing - aspemail, vsemail, other dlls...
  204. Time Stamp
  205. Return average of non zero values in query
  206. How to Compare Autonumbers and Return the Larger Value, and try to Assign it to a Bound Field
  207. VBA or qry
  208. combo dropdown
  209. Table Hyperlink
  210. spell check in Access is not working
  211. Help Coding Unique Numbers for Primary Keys
  212. Access 2003 Report log
  213. Microsoft Access build management
  214. Formatting calendar type report
  215. Using the OrderBy property on an unbound ComboBox column
  216. Locating a legal copy of Office 97 Developer Edition in Spanish
  217. Access and web pages
  218. Multi-Select Listbox
  219. Pivot Table
  220. FTP/CGI Code?
  221. !!FAQ! for Date: 20040809 - New Users Look Here! [Last Updated February 05, 2004]
  222. .mdb file locks up at times. Permission settings question
  223. recover deleted records
  224. Fill field with chosen value from a drop down combo box
  225. Linked DB2 table in Access 2000 shows #Deleted on every record
  226. Is this Query inefficient?
  227. One process cant read data inserted by other process. Why?
  228. Converting 97 to 2000
  229. A strange delay in interaction between 2 subforms
  230. Distribute Access .mdb file
  231. Automated entries in form
  232. Why can't I delete from an updatable query
  233. Recalculate Calculated Control on Form
  234. Adjust Control Height/Width Precisely
  235. Type safety vs late binding and class polymorphism
  236. Report - Output to Snapshot ... then Email as Attachment using Outlook Express !
  237. Suppress Zero values in a Cross Tab report
  238. Strange problem with secured database--Urgent HELP Needed
  239. Get The Decimal Part Of A Number
  240. MOD Operation
  241. Validate Time in MS Access 2000
  242. tab out subform01 to subform02
  243. Sorting Table Data (Yes, I know I should have used a query!)
  244. calculating days
  245. !!FAQ! for Date: 20040808 - New Users Look Here! [Last Updated February 05, 2004]
  246. Help with Totals in Report
  247. Date & Time Field
  248. Using a key based on 2 fields
  249. getrows problem with a dao recordset
  250. getrows problem with a dao recordset
  251. Mystery can't add new Records
  252. when or Where do you use a union query ?
  253. OnOepn event in report
  254. Mystery can't add new Records
  255. SQL query question
  256. Capitalizing first letter of each work
  257. Installing a 2002 version DB on a A97 system
  258. Access Database To Web Server
  259. Require some feedback regarding using tree - list- view in Access XP
  260. !!FAQ! for Date: 20040807 - New Users Look Here! [Last Updated February 05, 2004]
  261. Database opening slowly
  262. Exporting Euros To Excel
  263. Optional arguaments and IsMissing function
  264. Where to find small fonts
  265. CA issues million dollar challenge to open source community
  266. Storing JPEG Thumbnails
  267. File does not exist (?!)
  268. Display an image if a field has data or not
  269. When should Activate happen?
  270. spell check in Access greyed out
  271. Some SQL is *Much* Faster Than Other
  272. Subform updating
  273. Multiple Entries per field
  274. importing data
  275. DAP -update frame from table value?
  276. !!FAQ! for Date: 20040806 - New Users Look Here! [Last Updated February 05, 2004]
  277. 3 SubReports with date parameters
  278. table linked to text file producing extra rows
  279. RunningSum in Report not re-setting by group
  280. Validation rule
  281. Invalid procedure call in query - why!??!
  282. Print a file in a database
  283. Calendar control
  284. Report / Subreport sum
  285. Normailising Tables
  286. ADP - Walk the collection
  287. SELECT COUNT - How to get this value to a variable in VBA???
  288. ChangeRegister?
  289. Mail merge problem
  290. access 2002 and vba
  291. How to get Graphs from MS Access and use them in MS Powerpoint
  292. please help to create a table with relationships
  293. Sorting based on field not in table
  294. Limits of Access 2003 using ADP on SQL Server Express BE?
  295. What is crashing Access 97 (SR-2)?
  296. the expression builder
  297. Query to select latest date among several
  298. muddle with security
  299. Printing report programatically while the report is still processing
  300. Record number - on Form - always defaults to 1
  301. Comparing tables in MS Access
  302. Writing GetUserName value to table
  303. error from getting value from a text box
  304. Date function
  305. Using DMax "a hard one"
  306. Report header question
  307. Database gone amok
  308. Open Main form - MAXIMIZED.
  309. Outlook Click Yes - Reference problem???
  310. !!FAQ! for Date: 20040805 - New Users Look Here! [Last Updated February 05, 2004]
  311. ADP text box issue: Backspace deletes ALL text.
  312. table deletions
  313. Requery Subform From Another Subform
  314. Problem with Index using Seek method
  315. Updating Tables in Stock Database
  316. regrouping data in large dataset
  317. Outlook content to access
  318. Need recommendation for beginner's Access book for client
  319. Looping SQL SELECT and INSERT INTO query
  320. Access 2000 failing to activate "mailto: " hyperlink
  321. saving records with "enter"
  322. Datensatz speichern nur durch RETURN
  323. How to retrieve User name and group of a secured db vis VBA?
  324. Query problems when using Nz
  325. executing stored procedure in vb Access97
  326. lock record on a form
  327. Oracle vs Access
  328. Excecute VBScript from Access
  329. Access database corrupted - Relationship between related tables LOST
  330. Inner Join Conundrum
  331. Program won't run from CD
  332. Export to csv having issue with import to SQL(Remedy)
  333. Total Access Analyzer Support
  334. I need a non-example-specific description of how to do dynamic crosstab reports
  335. Does using Filter vs. RecordSource for Report create more network traffic?
  336. how to handle locked objects?
  337. Problem with new records in subform
  338. Searching for DB Objects within an ADP
  339. Filtering records in a form based on data in a subform or another query.
  340. !!FAQ! for Date: 20040804 - New Users Look Here! [Last Updated February 05, 2004]
  341. text box visibility in report
  342. Won't open Common Dialog Box using API call
  343. report+truncate
  344. calculated form
  345. Open new instance of Word from mdb.
  346. Import outlook custom form fields data into access
  347. Download
  348. Access - web forms
  349. Adding Multiple records using Relational Tables
  350. Trying To View JPEGS: Microsoft Access Doesn't Support The format of the file
  351. Questions, Questions...
  352. Set sort order in MS Access 2000 report
  353. margins setup
  354. Clear Database
  355. Delete duplicate data in Access
  356. a2k recovered from corruption, missing relationships
  357. Auto Assign Value Based On Another Field's Value
  358. Counting Problem
  359. New to VB -- how to open an Access table?
  360. Help with Reporting
  361. Report based on crosstab query
  362. FORMS - Give consistent visual appearance to all.
  363. interest calculation
  364. Date format range
  365. Continuous Forms
  366. !!FAQ! for Date: 20040803 - New Users Look Here! [Last Updated February 05, 2004]
  367. Problem with Access2002 app made on localized version and run under US version - Please help
  368. Referential Integrity - How to update a table?
  369. Tab control within another tab control
  370. Database Repair Services
  371. ADPs, Integrated Security and Selective Permissions
  372. INSERT INTO confusion
  373. Advance Query..Urgent
  374. Anyone have experience with dbUpgrader or other ways to upgrade back end?
  375. Query on month
  376. Email Invoice
  377. Can't .Undo Date control
  378. Snap shot viewer
  379. query needed to subtract values
  380. RecordSource Property Unavailable
  381. Printing Reports to Multiple Printers
  382. SQL query referencing field values + wildcards
  383. Auto populate a second field
  384. ?Issues using DLOOKUP & both negative / positive lookup values?
  385. Database Management System
  386. Mysterious Behaviors of the Combo Box
  387. SQL query fails
  388. !!FAQ! for Date: 20040802 - New Users Look Here! [Last Updated February 05, 2004]
  389. Rename Files in a Directory
  390. SQL Delete statement
  391. a2k detect identical records
  392. Transfer Text from Union Query
  393. How do I run a sumation matching database.......
  394. VBA reference question
  395. Subform won't show data selected from Combo Box
  396. working with forms
  397. Export Records to a text-file
  398. elegant solution to many-to-many table/form problem
  399. planning access
  400. Switchboard?
  401. Abfrage definieren: [Katze, Katze, Hund,Hund, Hund, Vogel,....] --> [Katze, Hund, Vogel]
  402. Error converting from Acc97 to Acc2000
  403. Importing a .txt file into an existing database
  404. mail merge to word
  405. missing lines in reports
  406. Synchronising forms
  407. FTP from MS Access?
  408. starting one database with another
  409. Centre a Report at Runtime
  410. sending emails
  411. mail merge to word
  412. group options and tab stop in a form help
  413. group options and tab stop in a form help
  414. How Can aBound Combo Box be Used as a Record Selector?
  415. Replacing Forms w/Unbound populating w/Query
  416. Bookmarking Record for return
  417. ask me a question ms access databases
  418. !!FAQ! for Date: 20040801 - New Users Look Here! [Last Updated February 05, 2004]
  419. opening an image viewer
  420. Summing columns in two separate queries
  421. MDM.EXE on startup menu
  422. Reference to use 'fIsAppRunning' in Access 2002
  423. export a query/mail merge To MS Word from Access In code
  424. appending prefix to a report field
  425. Filtering a subform
  426. question: automatically generating field names from record values
  427. Access 2000 Stability
  428. !!FAQ! for Date: 20040731 - New Users Look Here! [Last Updated February 05, 2004]
  429. Programatically Close any form that hasn't got focus
  430. Testing for an open recordset
  431. Problem with err.raise
  432. Win 2000 and access pecularities
  433. Looping Structure to change field data
  434. Relocating Columns in QBE Grid
  435. 2 checkboxes and a continuos form
  436. calculated fields in tables/ queries
  437. Followup: Module Problem with CODE
  438. Relinking tables to Multiple "Back-ends" (using multiple OS's!)
  439. SQL searches and ODBC to Oracle database
  440. Auto-populate a field
  441. WAV Files
  442. !!FAQ! for Date: 20040730 - New Users Look Here! [Last Updated February 05, 2004]
  443. "Query is too complex" error
  444. Programatically Create Query for tables
  445. Change the field name
  446. VB "Call" syntax vs command-style syntax
  447. Rankings
  448. printing Yes, No, Maybe from the numbers 1, 2, and 3 using an Access report
  449. Help! How to Loop through Recordsetset, create web page, ASP, and save it ??
  450. Run EXE File via Shell command + Arguments
  451. Access not releasing Excel
  452. MS Access asking for password
  453. Printing Report with embedded bitmap
  454. Access 2000 Find Inbox at Runtime
  455. Merge two record in two different column in one column with space between
  456. A little headache
  457. Displaying averages in a database
  458. Acess2000 vs Access2003
  459. DWF: REVEALING PICTURE!
  460. Connecting to online database?
  461. Help Please: Logging Transaction Activity while Updating Quantity
  462. Unbound control problem
  463. Page Break and Extra Page Headers
  464. Automating Mail Merge from Access using xls file as datasource
  465. Scheduled import of text file
  466. Database Splitting error
  467. Need help on fetching column values and populating a combobox.
  468. Problem setting tabledef from a form's RecordSource
  469. Referencing a form within a report
  470. Inserting a Carriage Return in a Textbox
  471. !!FAQ! for Date: 20040729 - New Users Look Here! [Last Updated February 05, 2004]
  472. Duplicating data and all related data for next year
  473. Comparing Records
  474. Determine if A: drive is empty
  475. One sub form linked to another
  476. Deployment information needed for Access 2003
  477. Auditing, highlight changes made between rows
  478. Access Excel Automation Formatting Problem
  479. Drop-Down list, forms and exporting
  480. Drop-Down list, forms and asp.
  481. Get CustomerID of New Record After Recordset.Addnew
  482. Printing/exporting list of fields/data types from table design mode??
  483. Rankings
  484. Updating recordset programmatically : <Item not found in this collection.>
  485. Performance on access queries with conditions
  486. MS Access and wav files
  487. Table View refresh
  488. Extracting Street Number
  489. Mulitselect and ADP
  490. Horribly Slow Query
  491. SQL help
  492. Updateable query
  493. Create/update table from multiple queries
  494. Conditinal Format
  495. Defining and Navigating recordsets in VBA
  496. Problem by design - MS-SQL Server 2000 and MS-Access 2000 project.
  497. creating a record lock to ensure that only one user is updating records at a time
  498. Aligning Labels: not the text but the label itself.
  499. Sharing a single .mdb and problems associated with it
  500. Access conversion from 97 to 2000
  501. Access MS Money
  502. !!FAQ! for Date: 20040728 - New Users Look Here! [Last Updated February 05, 2004]
  503. looping thru table properties will I have to loop twice?
  504. Database window omits project views and procs
  505. populate text box when user enters data in another text box
  506. comparing records
  507. A server for SQL Server
  508. Validation Rule
  509. Import data (not tables) from one Access database to another?
  510. How to format column imported database?
  511. TREEVIEW: Won't show record set data that is copy/pasted
  512. Dropping back-end connection
  513. check server is available?
  514. MS-Access Project- Print Attribute in Stored Procedures
  515. ACCESS/PROJECT
  516. access/project
  517. Data with Max Qty and Date ?
  518. Max qty with date?
  519. Runtime acc2000 asks to confirm (at delete, insert etc.)
  520. Extracting parts of strings with query
  521. Answer: Access creates ADP database in MSDE only with SQL Server mode authentication
  522. how can I run a code/macro in a different database
  523. 'Help - How can you run 2 versions of Access on 1 pc'
  524. Passing parameters to a Select Query in VBA
  525. Disappearing Table Fields
  526. Control page numbering in Access Reports
  527. Office 2003 Service Pack 1 Released to Public
  528. Books for leaning Access VBA?
  529. FTP Site
  530. VB code help for Select Case
  531. Date Parameter problem (2nd Post)
  532. Exporting date data
  533. How does access store table data internally..?
  534. Form Timer
  535. comparing records
  536. How to multiselect a combo box
  537. summary reports/queries
  538. !!FAQ! for Date: 20040727 - New Users Look Here! [Last Updated February 05, 2004]
  539. Open Form From Table
  540. Another question about populating cells
  541. reading/using rowsource properties in VB6
  542. Can a pass-through query to create a table?
  543. problem with large databases
  544. Reserve Error(0)
  545. Referring to controls on closed forms
  546. Documentation of database
  547. Problem while opeing the Access DB
  548. HELP!Unable to run macros in ms access database FROM VB
  549. Windows Installer loads when i use my Main form
  550. Why can't Access create an ADP project in MDSE?