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. Output Excel File (dhl)
  2. Hyperlink captured in e-mail
  3. scrolling through report
  4. date query
  5. !!FAQ! for Date: 20040706 - New Users Look Here! [Last Updated February 05, 2004]
  6. Can't acces the right excel sheet with vba
  7. PASSING KEYS
  8. Creating tables in another table of the same directory
  9. Normalisation Question perhaps?
  10. Date Query Grouping Help!
  11. Sort Table Through VB by multiple columns
  12. Need help with placing value into subform
  13. Code Just Stops
  14. Searching Database
  15. Custom Events / Application properties ?
  16. Validate fields.
  17. report not showing all data?
  18. Case sensative
  19. OT - Sharing Revenue
  20. File List Creator
  21. days between two dates
  22. Runtime security
  23. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  24. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  25. MS Access Trial version 2002
  26. Trying to find text within a text string
  27. Custom MsgBox Message
  28. "Opened Exclusively" message on same machine with 2 of 3 Windows users
  29. Dev Ashish acc 97 set page setup margins at runtime VB
  30. An expression question
  31. Is data secure within an MDB/MDE file?
  32. parameter query not working as expected
  33. Multiple Sub queries in a SELECT statement
  34. Difficulty with combo box selection
  35. Append Query/Memo Truncation
  36. !!FAQ! for Date: 20040705 - New Users Look Here! [Last Updated February 05, 2004]
  37. Editing question: locating a charter within a string!
  38. Obtaining Table name from error message 3200
  39. how to Locate cell in the datagrid control
  40. Auto Fax when "printing" a Report
  41. Writing to CD from within A2003 VBA
  42. Help - Close Date and Effective Date
  43. a2k - quickest way of checking for a value in an array?
  44. Row handle invalid/referred to a deleted row or row marked for deletion
  45. Subform dissapears when adding a new record to main form
  46. I don't remember carriage and return
  47. Executing multiple sql DDL statements
  48. Highlight the date on the calendar control
  49. Change background/tab colour of tabControl?
  50. Recordset confusion
  51. Appending boiler plate records w/o having a relationship - Pleasehelp
  52. Acc 97 page setup
  53. Problems making new records through the form wizard
  54. Using Crystal Reports in MS-Access & Use of timer event
  55. !!FAQ! for Date: 20040704 - New Users Look Here! [Last Updated February 05, 2004]
  56. How to strip out sender address and originating IP address from received eMails
  57. Please help with treeview
  58. Multiple Queries - 1 date range
  59. Problems making or deleting records through a form control button
  60. admin info
  61. !!FAQ! for Date: 20040703 - New Users Look Here! [Last Updated February 05, 2004]
  62. Application for "Find a Dealer Near You"
  63. Form scrolls down a bit when opened
  64. Changing table structures in Access
  65. dialog print on report
  66. Larry--Access 97 Question
  67. Possible for Column Height in Row Source
  68. Probably an easy answer - Form and update question
  69. access problem on date conversion please hlp
  70. Move instead of delete
  71. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  72. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  73. Simple Expression Too Complex
  74. MS Access 2002 replication problem
  75. combo box (optional add to list )
  76. Append query not setting Yes/No flag
  77. Data dictionary for Access?
  78. Add_in Manager
  79. any springsteen fans - need database will trade
  80. #Deleted In All Fields When Linking SQL Server Table In MS Access
  81. Replication Manager 4.0 - Changing IP Addresses (HELP)
  82. Are select queries with inner joins updatable?
  83. [Field name] returned as data in query results
  84. Search multiple fields (80!) in a query
  85. Can I label queries so the can be copied with VBA? Confused!
  86. corrupt db and MSysObjects
  87. my query doesnt work
  88. Provide a Recordset to a report from VB via COM API?
  89. Coding No Related Records?
  90. Question: How to launch a Module of code on startup
  91. Create New Record In Different Form
  92. Help with modules I think
  93. Uploading to website
  94. Trouble Importing Data
  95. Importing Data to Access.
  96. !!FAQ! for Date: 20040702 - New Users Look Here! [Last Updated February 05, 2004]
  97. getting "n" records using RND()
  98. Getting External Data into Access.
  99. Enumerate controls in a runtime environment.
  100. fields containing * ?
  101. I can make databases in Ms Access on order
  102. Wykonam projekt na zlecenie Bazy w Ms Access, programy w Delphi6 lub Builder5
  103. Open subform on Tab Form, with criteria
  104. Show images in a control within Access
  105. Make help in Access database
  106. RS232 data to Access database - general approach
  107. Combo box list question
  108. Access to Excel PasteSpecial Values
  109. Variable Row Source for graph on subreport
  110. Slow Searches in Access
  111. Searching for files and extracting contents
  112. Live Updating Excel - Access Links
  113. Determining which folder is a shared folder
  114. Cascade delete
  115. How to sum up total time logged in by a given member in tblMemberLogins having Login & Logout Date Type fields
  116. Report with null values
  117. Report - Extra blank page problem.
  118. "This recordset is not updatable" - why not?
  119. No access to .dbf files in access 97 after installing access 2003
  120. Query Design View - set default window state
  121. Need Help with counting weekly dates. One more time.
  122. find file, copy and save under new name?
  123. Replace function - odd problem
  124. Date problem with not american format
  125. Question of syntax
  126. Database design question...
  127. NEED FIND BUTTON TO RETURN MSG "NO RECORDS FOUND"
  128. Edit, Delete, Update ... Error :-(
  129. locking records on a form
  130. Concatenation Error in Access 2000 report
  131. Constraint
  132. Old Value - A97
  133. I need to "hack" into an MS Access program - help!
  134. Printing a record on a report depending on a record in another table
  135. Verhindern von ScrollBars in einem Unterformular
  136. Getting an IP address.
  137. Help on DAO in ACC2000
  138. burning JOIN question
  139. Code To Check a Folder For any Files
  140. Record is not locked, although Edited Record locking is set
  141. Connecting To FoxPro
  142. Oracle with Access?
  143. Access window - once minimized, won't maximize
  144. Access window - once minimized, won't maximize
  145. Corrupted form/control
  146. Multi Select Listbox control - SO SIMPLE BUT WHERE IS IT!
  147. Displaying Subform
  148. Delete query help
  149. Item's Indes in multiselect listbox
  150. Was the item selected or deselected?
  151. Crosstab query reports (unknown fields in reports) What about sorting?
  152. Find record causing failure on Insert statement
  153. Multiselect Listbox
  154. Blank Field Problem
  155. Blank Field Help?
  156. Blank Field Help?
  157. Access XP strange behaviour
  158. VBA quick question
  159. convert from 2000 to 97
  160. Access RunTime
  161. Autocreate records and print them
  162. Connecting to Microsoft Index server service from Access
  163. textboxes updating from a listbox
  164. Cascade delete of indirect children records
  165. Repost: Union query truncating field
  166. iif statement dealing with nulls
  167. Want to easily copy selected object between databases
  168. Array error when passing to Sub
  169. Syntax Error in SQL Statement
  170. Tool to identify unused objects?
  171. User Account Locking
  172. Hardware tracking solution
  173. Joining 2 queries for 1 report
  174. 180 day rollover of records
  175. Corruption when "Compact on Close" active
  176. Need SQL help - Select Distinct, Count, Group By
  177. Varchar2 fields limit
  178. Button Pictures
  179. How to capture data change...
  180. TransferSpreadsheet seems to corrupt spreadsheet
  181. Security at Runtime Problem
  182. Re - post..Date/Time
  183. SQL error
  184. Multiple Names In A Mail Merge Field
  185. Setting date condition
  186. Query Records from a specific Date Range
  187. Updating and Deleting a number of records at the same time.
  188. A Totals Query That Doesn't Total
  189. Date Selected query parameter
  190. VBA datatype mismatch error 13
  191. VBA
  192. Printing underlines on subreport data
  193. Best book for my skill level?
  194. !!FAQ! for Date: 20040629 - New Users Look Here! [Last Updated February 05, 2004]
  195. ???? Macro security question
  196. Report Setup
  197. Highlighting individual records on a continuous form
  198. LDB files and file names
  199. Best way to let users input picture/drawing to each record?
  200. Form-subform links - am I breaking the rules?
  201. Acc 97 - Set place/numbering in continuous form by code
  202. Table - Import / Link Wizard...
  203. Right Justify in list box
  204. Number of lines in a sub-report
  205. Report Problem
  206. Re-dimensioning string variable that has already been globally dimensioned...
  207. Form and query
  208. ERROR: "Method 'Connection' of object '_Current Project' failed.
  209. ERROR: "Method 'Connection' of object '_Current Project' failed."
  210. Date/Time Conversion woes
  211. Date/Time Conversion woes
  212. Workdate calculation Access 2000
  213. Is there a way to delete every record in a table without selecting all the rows
  214. Form and queries
  215. Access 2003 - importing PDF files as part of a record
  216. Image doesn't work after extracting from MSAccess
  217. How do I avoid "File Sharing Lock Count Exceeded (Error 3052)"
  218. SQL with special characters...
  219. Found Text but Can't Extract from Word Doc
  220. Organizing lead files
  221. Queries on tables from different data sources
  222. fast
  223. VBA editor changes keyboard layout.
  224. Select an item in a combobox
  225. Access 97 - how does it import database objects from other databases?
  226. Copy new db
  227. Suppressing Not In List msg in combo box
  228. passing filter to sub report
  229. Combobox & null
  230. a2k - rounding of figures, comments?
  231. Dates
  232. Help on FE, BE, Linked tables and Bloating Concepts and some advice on how i should construct my database
  233. Access MySql ODBC strategy
  234. security problem
  235. How to rotate text
  236. !!FAQ! for Date: 20040628 - New Users Look Here! [Last Updated February 05, 2004]
  237. Access OnNotInList sooo Frustrated
  238. Syntax error in Create Table statement? Why
  239. Access 2003 problem
  240. Delete message - Can is selectively be turned off?
  241. Hide friendly ODBC connection error message
  242. Missing .OCX files after 2003 upgrade
  243. Typing SQL Tables in by hand, in Access
  244. Seeking syntax for pass-through query to delete SOME table records
  245. Updating Hyperlinks
  246. frequent database corruption
  247. How do I set a shortcut key to a save function
  248. memo fields blur in acc '97
  249. Mouse Wheel ON/OFF Subforms - Lebans MouseWheel On/Off
  250. requery listbox as you type
  251. New CDMA Awards 2-DVD Set!
  252. Crosstab ColumnHeaders
  253. Restart Autonumber
  254. Problem with use of calculated form field in query
  255. !!FAQ! for Date: 20040627 - New Users Look Here! [Last Updated February 05, 2004]
  256. attaching forms
  257. date, default value
  258. Problem opening a Form
  259. How to make access import special chars correctly?
  260. SQL Question
  261. how to set a form that is a subform
  262. Foreign Key Won't Enter In Subform
  263. High Order Zeros Edit Issue
  264. Need help with aggregate function query
  265. Commerical App ....but no relationships??? Normal??
  266. Image not longer shows up in database record-windows reinstall
  267. If you have connected to FoxPro tables via ODBC, please read/help
  268. !!FAQ! for Date: 20040626 - New Users Look Here! [Last Updated February 05, 2004]
  269. Foreign Key - Replication Code or Integer Long?
  270. Toolbars and Security
  271. Would like to somehow link specific eMails in my message store to MS Access database
  272. SQL quandry
  273. Setting Hot Keys in MS Access 2000
  274. Problem with OutputTo
  275. JD Edwards to MS Access
  276. Add records programmatically?
  277. when to use ENUM and when to use Public Const
  278. JD Edwards to MS ACCESS
  279. chinese characters in fields
  280. Definition of Database Map?
  281. Acrobat Distiller 6.0, VBA and MS Word
  282. Read-only Forms in a SQL .adp file
  283. Maximized form Distorts on recordset update
  284. input mask on date field
  285. Entering data through a web page
  286. Thanks to Pieter and to Paul
  287. Pieter Linden - Thank You
  288. ODBC and MDAC. ????
  289. Make a forced new page be an odd number
  290. Transfering Data: from end of year/season to beginning of next
  291. SQL User Defined Function
  292. !!FAQ! for Date: 20040625 - New Users Look Here! [Last Updated February 05, 2004]
  293. Synch then find conflicts
  294. How to make unique hyperlink URL for each form record?
  295. Report Manipulation
  296. Copying new records
  297. how to query values from different fields using different criteria?
  298. Access Help viewing webpage
  299. Load Flat File
  300. Code changes from XP to NT
  301. Check for Flat File
  302. Hyperlink problem
  303. ai ai ai
  304. run time error 2202
  305. Cant Get a Date Field to return correct date?
  306. How to disable MS Access 2000 screen design from the user
  307. Using Multiple Forms and a single query
  308. Office 2003 - Digitally Signed Databases problem - URGENT!!
  309. SQL or VBA?
  310. How to Trigger Macros in a Access DB from Another Access DB
  311. database sharing
  312. Problem with Incremental Search box
  313. Retrieving images from Access table PLEASE HELP
  314. MDE AutoNumber problem
  315. How to email errorlog table.
  316. Relationship question
  317. A2K3 Turn off Help Combo Box?
  318. carrying date into new records
  319. A few Access questions
  320. word forms, access, and indefinite numbers of entries
  321. sorting short dates, without using years
  322. Feldnamen aus String's zusammensetzen für Abfrage
  323. !!FAQ! for Date: 20040624 - New Users Look Here! [Last Updated February 05, 2004]
  324. Tab control pages
  325. Issues with Search Form = IIF Statements
  326. form not copying field to subform
  327. New user question on forms
  328. Between Peredicate
  329. Split Database Issues
  330. Updating DATES
  331. Count in a Text Box Control Source Property
  332. Query counting records for pre-defined ranges
  333. Aggregate Query problem
  334. Creating ODBC data source fails
  335. Table relationships
  336. When is a boolean not a boolean?
  337. Collection object help - driving me crazy
  338. Query Criteria Help
  339. Revisiting mdb/adp files as libraries
  340. Retrieving information from tables
  341. Turn mouse scroll off.
  342. Possible to link digital photo to OLE type field in bound frame in a form?
  343. Access project database - failed to create database on MSDE
  344. database sharing help
  345. Expanding a Series
  346. Rotate Text
  347. How to remove "Type a question for help" box on menubar
  348. Access 2002 Issues
  349. Need help on Grouping by Week or DatePart function in ACCESS?
  350. complicated query... help needed
  351. Query across three history tables
  352. Tab from list box to subform control, Access 2000
  353. Opening Another Database from WITHIN a Database
  354. Conditional Format Based on a Different Cell
  355. Storing directory names in a table
  356. Charts: Change in Y
  357. Script not working
  358. VBscript not working
  359. listbox question
  360. PDF Creation
  361. Connect to Copied SQL Database
  362. !!FAQ! for Date: 20040623 - New Users Look Here! [Last Updated February 05, 2004]
  363. order of query
  364. Pass Calendar Value into subform?
  365. Programatically printing Access reports from pdf995 using VBA
  366. Turn mouse scroll off.
  367. Export Access Data to Oracle
  368. Looking for Peter Miller - PKSolutions...
  369. copying and changing fields to another table can you change description at this time?
  370. Help - Table Field Properties
  371. I make Database in Ms Access at order
  372. Bazy w MS Access na zlecenie
  373. Alpha characters
  374. Append Data From Report
  375. ALTER Table in ODBC
  376. Automated Directory/Folder Creation
  377. Search invalid forms and reports after design changes in tables
  378. Print Word doc to lower tray - Access 2003
  379. NZ Function Not Support via ODBC
  380. Access 2002 Error 3625 in converted database
  381. custom message box
  382. trapping the untrappable ?
  383. Query writing help
  384. Error in module from XP to NT
  385. date+order
  386. Using a combo box to look up values and to enter new values
  387. MS Graph Completely Useless in A97?
  388. Email a report in MS Access
  389. exclusively open, locking the database
  390. Merging and deleting duplicate records
  391. Draw Lines and Boxes Better explained
  392. Drawing lines and boxes
  393. !!FAQ! for Date: 20040622 - New Users Look Here! [Last Updated February 05, 2004]
  394. Using a Japanese Access '97 database under Windows XP
  395. Step by step how to open a popup calendar on the main form?
  396. #Name Error for Calculated Field on a Form
  397. Date/time problem
  398. Numbering help
  399. Endless output using OUTPUTTO MsWord
  400. ListBox doesn't change focus with form navigation
  401. Problem with Import External Data
  402. Query grouping problem
  403. Link Tables problem....Way too slow to operate.
  404. Error 2024
  405. In-Operator and global variable
  406. Database Access
  407. Error handler add-in
  408. Re-write of Allen Browne's "OnHand" function -- opinions?
  409. Colour values form a bitmap
  410. access select query
  411. Help Using Text Box to fill a Listbox
  412. Validating imported data
  413. button to import .xls to access
  414. Access 2002 discontinued?
  415. filling combo box based on previous combo
  416. Begginers' problems
  417. Rank function
  418. execute SP from ms access
  419. Accessing webservice from access
  420. Pulling data w/ date parameters only when a past field value is null
  421. Override Access update with stored procedure
  422. Calculate the median
  423. Adding a Duplicate Record
  424. !!FAQ! for Date: 20040621 - New Users Look Here! [Last Updated February 05, 2004]
  425. Can't get around temp table in front-end
  426. Hiding Toolbars with code
  427. Using mdb databases
  428. Importing new entries only from .csv file
  429. Export Data to Excel
  430. Looking for suggestions for "How to Develop"
  431. Resizing code
  432. Help+invoice+numbering
  433. Inputing date to separate tables while retaining links
  434. Retrieving data from an AS/400 stored procedure
  435. Audit Users/Login databases/tracking
  436. Auto writing Excel spreadsheets from Access (97 & 2K) fails to releaseExcel
  437. MSAccess 2003 - Digital Signature
  438. MSAccess 2003 - Package Wizard
  439. Printing to a specific printer
  440. Linked tables in ms access asking for login/password
  441. Gauge or timeline control for continuous forms
  442. debugging classes
  443. good syntax with if statements
  444. Mental block - text box binding and queries
  445. Changes to data from a query
  446. Point-Of-Sales
  447. Exporting result of a query to a db3 format?
  448. Selecting only one page out of a several-page report for printing - how to route in Access?
  449. What operation have I cancelled?
  450. Excel Linking
  451. InputParameters
  452. Need ActiveX control for JPEGs in Access 97
  453. Unbound Combo Box Record Selector Question
  454. HELP! Web update of memo field crashes Access, errors repeatable. HELP!
  455. ado recordset field becoming NULL
  456. !!FAQ! for Date: 20040620 - New Users Look Here! [Last Updated February 05, 2004]
  457. MSSQL Views a tine problem they may help with.
  458. SQL DELETE and Me.Requery in Access
  459. any ideas for boolean yes/no field in table
  460. day of week
  461. Getting 2 counts() of 2 foreign keys
  462. Sorting or Grouping problem
  463. Any Add-on for this?
  464. Tools for access similar to Red Gate SQL Compare, SQL DataCompare and SQL Packager
  465. Need help with reports
  466. Random Record
  467. !!FAQ! for Date: 20040619 - New Users Look Here! [Last Updated February 05, 2004]
  468. Need to overwrite a table that is already being used. Is this possible?
  469. Error after 380 CreateObject("MAPI.Session")
  470. Bug in Access 2003 ? Error after 380 CreateObject("MAPI.Session")
  471. Standardfiltern von Datensätzen komfortabel gestalten
  472. sharing data on acc2k
  473. Counting distinct Surnames on report
  474. How do I do this?
  475. DoCmd.TransferDatabase
  476. can this be done with one query?
  477. Year-to-Date Totals
  478. RUN Crystal Reports in MS ACCESS
  479. MS Access ERROR ! plz help !
  480. How enable Aligment and Sizing toolbar
  481. !!FAQ! for Date: 20040618 - New Users Look Here! [Last Updated February 05, 2004]
  482. display messages
  483. calendars in reports
  484. Manipulating Date
  485. thoughts on table setup
  486. Problem.. Report?
  487. Criteria
  488. Concatenate multiple rows into one string
  489. Use result from Inputbox in query
  490. Security Challenge
  491. Help with a query
  492. How do I do this?
  493. The truth about SQLFetchScroll() and the cursor library? (ODBC / MS Access 4)
  494. Access crashes when adding linked tables to query grid
  495. pushing data from unbound text boxes
  496. Help with code
  497. Units Conversion in Data Entry Field on a Form
  498. HELP: Access record ID's corrupted by WWW insert and updates, memo field may be culprit
  499. Limit number of users
  500. VB Editor Error - desparate!
  501. Report From Table - Unique Records in Several Tables
  502. New Be Need help with date.
  503. Editable Views (Queries)
  504. Import Text - Problem With Limits
  505. problem of drawing round and others
  506. In-house server to WAN and T1 environment
  507. Snapshot Format not a SaveAs/Export choice in Access 97
  508. new to access, but not to visual basic
  509. Print the current record of a form
  510. Couldn't find file 'System.mdw'
  511. Gathering workstation data
  512. !!FAQ! for Date: 20040617 - New Users Look Here! [Last Updated February 05, 2004]
  513. ODBC Driver for .adp
  514. How to Obtain the Height of a Form?
  515. Delete all objects from database other than tables
  516. How to Automatically Resize Form Controls When Resizing a Form
  517. Date problems yet again - sorry Gurus !
  518. Autonumber mess, figure out the number
  519. Stuff a string
  520. Parameters in QryDef in Acc2000
  521. Form error
  522. suddenly "on Error" doesn't work anymore
  523. how do you know where the call is coming from
  524. Detect adp connection state before opening
  525. To Complex of a query
  526. importing Data from access
  527. I Cant Return a Next Due Date based on two items of criteria?
  528. Reports and If()
  529. VB error: this will reset your project do you want to proceed anyway
  530. Sending a Form by e-mail
  531. Putting fields on the first label...
  532. Code : DoCmd.OpenQuery - and bring result back to form front
  533. Print report to .pdf
  534. How to Re-parent a Record
  535. Opposit of a maketable query
  536. Print MS Word Merge Document from Access?
  537. Change focus between Property Sheet and Form Design
  538. notification of upcoming date; filling in form letters automatically
  539. Het zal toch niet zijn wie ik denk dat het is?
  540. Determine Compile Status / Compile Target db using Vba
  541. Determine Compile Status / Compile Target db using Vba
  542. Importing data from text files of non-standard layout
  543. using access as a front end, building a stand alone exe
  544. PLEASE HELP!- Linking multiple forms to ONE record
  545. Date format confusion
  546. Jet engine install
  547. event sinking with Word question
  548. access 97.out of memory error..help. tia
  549. !!FAQ! for Date: 20040616 - New Users Look Here! [Last Updated February 05, 2004]
  550. Help! Creating Reports Using Multiple Tables