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. Synchronization - help me please I'm lost
  2. Opening Schema
  3. SysCmd as late binding?
  4. Group By DateValue fails in Access 2K
  5. Loss of Data Converting Text to Number
  6. What is the Best Way to Copy a Recordset?
  7. Multiple Table Form Error
  8. Lowest cost migration of VBA -Access '97 accounting source code? To what?
  9. 2 forms
  10. Subreport in .adp does not work.
  11. in DLookup I get Error 2001 - says I cancelled previous operation. Huh?
  12. Multiselect listbox and SQL
  13. foutmelding
  14. COMBO BOX, FILTER TEXT BOX AND NEW RECORD
  15. LONG POST: Class Module Property Let Statement "Hangs"
  16. Difficult SQL Query
  17. Combining numbers
  18. start a PDF - file from access (2000)
  19. lookup questions
  20. R+D+B+M+S minus D+B+M+S equals R, right? Or, am I wacko?
  21. How to sort records in a subform control?
  22. Flexibility in scrolling through continuous forms (no scroll bars)?
  23. Access Session logon problem
  24. Count Value Across Multiple Fields
  25. Access 2k/ XP code 429 problem
  26. making new field that combines three other fields?
  27. Access 2000 and wav files
  28. Trying to create a database in a MS Access DB via JDBC drivers
  29. Use of INSERT INTO
  30. Access 2K/XP Report with subreport print error
  31. How to prevent delete ?
  32. Arnold Schwarzenegger Commits Suicide
  33. Open Form Problem
  34. Nested if - in an query
  35. Best method to selectively lock/disable controls on a form.
  36. SQL DDL to rename table and rename field
  37. TSI Soon problem with A2K2
  38. Regional Settings Currency Format
  39. Form Focus for search
  40. Database Query Help Needed Please
  41. Take the last letter off contents of form combo box
  42. multiple subforms problem
  43. Populating a second field based on what was entered in the first field
  44. Index Search using Seek
  45. Dynamic Query bombing w/ multiple users
  46. How To Position A TreeView?
  47. Radio Button or Check Box and Event Procedures
  48. From Outlook to Access
  49. Finding "older" duplicates
  50. Using Access for crunching Phone bills
  51. Import Text Wizard Problem
  52. CDO--Failure transmitting PDF as attachment via email from VB, VBA
  53. Reserved error
  54. Acc97: Problem with Find Dialog and Sub Form
  55. Requery Sub after update of another sub both on an unbound form
  56. Font CharSet - MSAccess Tables
  57. Error "data type mismatch in criteria expression"
  58. Error "data type mismatch in criteria expression"
  59. Strip all non alpha characters from a string
  60. 1 + 1 sometimes = 7.8
  61. Order of elements after Split()
  62. form before update event
  63. Mutli-user Update using Recordset.AddNew and mutliselection ListBoxes - 3 questions
  64. MOD SR1 Installation Error
  65. datasheet mode
  66. Starting A New Project
  67. Week Numbers
  68. noob needs help with join/union/sub-select
  69. Unbound form throwing error on close.
  70. Setting a default date with multiple criteria
  71. Selecting from a master table based on info in a detail table
  72. Noobish Question
  73. Linking to Excel
  74. Parsing text from memo field
  75. Current Date Appears as 06/24/1894
  76. OpenReport and Subreport problems
  77. Is this query possible? Please Help!
  78. Reserved Error (-1517): There is no message for this error.
  79. delete query
  80. Frequency Distribution
  81. Table Design
  82. For combo specialists
  83. Graph against "Operator Characters"
  84. How to set Row Source in Combo Box in VBA based on a variable?
  85. Bin type lookup in access similar to vlookup?
  86. Update an MDA file when converting to Acc2K
  87. select a number from a form, add 1 and write it in a Field on the form
  88. Access 2003: Message when I open database
  89. incorporating a search into a form
  90. Multiselect Listbox & SQL Server --
  91. CDMA Personnel Changes
  92. Populate 2nd list box from 1st list box choice
  93. Test for file to KILL
  94. query problem - recordset not opening / runtime error 3709
  95. DoCmd.RunSQL() not reading variable from combo box
  96. Combo drop down list anomality
  97. Formating Outlook Email Body from Access
  98. Multiple designers
  99. Multiple designers
  100. Mysterious disappearance of buttons in form view
  101. Changing query to access different tables
  102. Can this be done in a query? Probably easy for some of you.
  103. Adding New Field To Access Table
  104. filtering a form
  105. converting access 97 to access 2000 and dao.recordset
  106. Can you check for Windows File-type Association
  107. TreeView Behavior: "The object invoked has disconnected from it's clients"?
  108. VBA doesn't recognize @ sign
  109. MS Access 2002 to generate flow diagram
  110. Requery / recalc / ..... How to update combination field content in form after row source table is altered?
  111. Linking between two tables
  112. Access 2000 to 2003
  113. exporting data to excel
  114. Obtain OS username
  115. Updating the current record with a popup form
  116. Access 2003 - Expressions in Textboxes
  117. REQ HELP: Problem eliminating duplicates
  118. Prevention of form corruption
  119. lock records in paradox
  120. Example of creating simple PDF on-the-fly from Access 97
  121. Updating table values through a form from another table.
  122. SendObject and Filename Change
  123. Reg: How to store text of length more than 255 characters in column?
  124. VB, Access and text file manipulation
  125. Primary key of SQL Server linked View in an Access Database
  126. Conditional command Button?
  127. Macro opens popup form but displays all records or no records
  128. Nulls
  129. Phantom Relationships
  130. File Already in Use
  131. a2k - offering a Cancel option
  132. Indirect String Reference To Subform
  133. Return records where count is > 1 (?)
  134. How to Verify SQL Update Succeeded
  135. complicated expression
  136. SourceSafe
  137. Gif animate nei bottoni
  138. Trouble with line spacing and Can Shrink/Can Grow
  139. problem with dates
  140. Automatically entering table values through a form into another table
  141. problem with exporting a table and compacting/repairing a DB
  142. Security
  143. Access importing from oracle
  144. Memo text in report
  145. Problème access import successif
  146. Date & Time Picker Control
  147. populating a table from two listboxes
  148. Checklist Data
  149. Checklist data
  150. this recordset is not updatable
  151. Automatic VPN Connection
  152. Issue with visual basic syntax in HTML code
  153. Need help with Inserting/embedding functionality
  154. Terminal Server: Enough included w/MSDN?
  155. how do i automatically update a column list box after user enters two codes?
  156. Retrain Key Fields from prevrious record in new record
  157. Can I enter parameter values for a query into a form?
  158. Custom Autonum values
  159. Form programs allowing output to look like the orignial form.
  160. Update SNAFU with Access 97
  161. Sort Table; Then Assign Sequential Numbers
  162. Include todays date as part of file name
  163. Multiple graphs on a report
  164. Averages / Formulas
  165. update/replace field data
  166. Relink table problem
  167. How to Count Dates with a Criteria
  168. SNPP Messages
  169. near duplicates
  170. Limited characters in a text box
  171. One form - 2 tables?
  172. Two Subforms on One Main Form Question
  173. Complicated Recordsource problem
  174. Probably a very easy-to-answer question...
  175. calling a macro/function in another database
  176. SQL statement to return n records after a time
  177. how to make a form stay on top
  178. Cannot update simple MSSQL join view in A2000, but ok in A2003
  179. Calculated Field in Access Query
  180. Anyone have a Meal Planner example? I wish to report a week's menu.
  181. Need help using datagrid
  182. MS Access on Terminal Server.
  183. Refresh on mainform/subform
  184. Maximum length of an If Then line in VBA
  185. Is it possible to specify a specific printer in the vba code?
  186. Is it possible to specify a specific printer in the vba code?
  187. Dialer in AccessFAQ.exe?
  188. Continue to lock record in main form while editing subform records
  189. two nested select statements
  190. Faxing Reports on the Fly
  191. String Manipulation
  192. Systemically OutPut Access Report To PDF
  193. Wierd error when editing an Access Memo field.
  194. LARGE report problem
  195. Scrolling problem with php web page - problem with IE or PHP?
  196. How come I sometimes get this?? "Run-time error 3211: can't lock table. "
  197. Synchronizing Table definitionns in one mdb file with those from a second mdb file
  198. How to compare fields from similar tables
  199. Works to Access
  200. I need HELP with error "Too few parameters..."
  201. where can i find a script
  202. How to convert php script to access
  203. Design Question
  204. is the byte on or off
  205. Programatically Enter Data Into main Form And Subform
  206. printing odd pages of reports / duplex printing in Access 2002
  207. Filtering text boxes from two comboxes
  208. Filtering text boxes from two comboxes
  209. Reset Field Autonumbering
  210. printing subforms
  211. update to second table?
  212. Division in Access does not match Excel.
  213. OPTIMIZING A FORM?
  214. DAO problem in Access 2003 - Can't find .Edit method for recordset
  215. MSACCESS.exe process does not stop when user exits Access
  216. Help: Using a Checkbox to Control a Date's Value
  217. Query based on form parameters
  218. How to go through a bunch of text boxes in a form.
  219. What's the best way to do this in Access2000?
  220. Continuous Form locking after sorting
  221. Why can't I use Database object in code?
  222. Make active page name on tabbed form BOLD - A97
  223. Any suggestions
  224. Disadvantage of Access as front-end
  225. how to force form to load in datasheet view
  226. what event is fired when you move to next record in form
  227. Duplicates
  228. A validation rule question
  229. database for internet - compacting
  230. Need help with validation rule
  231. 2 quesitons about forms
  232. report rowsource query
  233. Mailmerge problems - how to solve?
  234. Which Code run faster in MS Access SQL or DAO
  235. How do I time out (auto exit) an MS Access 2000 application if no activities after a certain time?
  236. Rectangles on a form
  237. query problem - recordset not opening
  238. Processing Fees based on Percentage
  239. XML-Import in Access2002
  240. Can't change data in query after adding table
  241. What is the best setup program generator for a commercial Access application?
  242. wifi hotspot directory available in MS Access format
  243. You'd think they'd have used ...
  244. Format a report with rows and columns
  245. Parameter query via value in form - driving me mad
  246. The visual basic for Applications project in the database is corrupt
  247. Adding Item to Combo Box
  248. Time isn't on my side
  249. Programatically Enter Data Into Another Form
  250. Copy data from subform1 to subform2
  251. Run Macros without MS ACCESS loaded
  252. Auto Data Entry
  253. split reattach code question
  254. Beginner Help Again - Queries
  255. Update combobox from table.
  256. Help needed with databases + asp problem
  257. Weird actions after upgrading from 2.0-2000
  258. Shareware documentation?
  259. FROM RELATIONAL TO FLAT
  260. Custom message box on NotInList - don't want to add new value
  261. Open Form WIth Calendar Control To Specific Date
  262. Report Layout Help Required
  263. Subform OnExit Not Enough
  264. Passing Value from the form to a report query
  265. Line 1: incorrect syntax near '!'. in a macro with asp
  266. calculating totals in a query
  267. ADPs /// idull thoughts
  268. Questions about Reports.
  269. Problem with Queries and Cartesian Product Joins
  270. Highlight the background color of data on conditions
  271. Limited Characters in a Text Box
  272. Reference Menu Captions in VB
  273. Dsum Use In Query
  274. Filling in null fields from previous records
  275. Forms in Access
  276. MS Access to vb.net/ASp.net migration
  277. Entering A Transaction
  278. Pasting records in Access front end using MySQL backend
  279. Access2000 database on the internet
  280. how to improve the speed of reading from access using dao
  281. 'Allow Additions' Causing Unexpected Results
  282. 2 tables 1 with duplicates
  283. Automatically populate foreign key in query?
  284. Simple Access 2000 Query won't work in XP
  285. editing entries in a table using textboxes and a listbox
  286. Need some help fixing my UNION statement
  287. Upgrading to SQL Server
  288. Text File Export
  289. archiving
  290. Download Access templates
  291. a2k - implementing simple popup form to main form
  292. PivotTable and recordset
  293. How to Link MS Access Report in VB
  294. query help
  295. Horizontal Report problem
  296. Databases for translating English-French and English to Spanish
  297. select aus einer Tabelle in ein Textfeld
  298. Seeking freelance programmer for simple project
  299. XP - 97 lockup
  300. How do i set up a query?
  301. Filling null records with previous value--loop?
  302. Acc 97 .Bookmark Property
  303. Access 2000 Calculations
  304. GTRR; If no Related Record, Create New In 2nd Form
  305. Row-level security and MSSQL
  306. GTRR; If no Related Record, Create New In 2nd Form
  307. ACCESS 2000 - bad input
  308. Make Table query on ODBC table changes NULLs to empty strings in Access 2002
  309. Remapping the keyboard up/down arrows for tab stops
  310. Need a Search String Routine
  311. Wierd Query Question
  312. Display automatic update field on a form without being able to edit
  313. ** MS Access support in Unix ? **
  314. Opening Backend DB faster
  315. HELP
  316. Can access tell me if I'm using a table or query?
  317. Call Database in ADO For Table Linking
  318. Powerpoint from Access problem...any ideas?
  319. I need help from VB/VBS experts: exporting Access OLE object (Word document) to a file
  320. Finding near matches
  321. Assign values based on Count(field_name) in query
  322. Server.CreateObject works on IIS 5.x / WinXP Fails on IIS 6.x / Win2K3
  323. The Year() Function and Update Queries
  324. date format problem
  325. A2K db is read-only for the others
  326. Automaticall linkin external Paradox tables - based on the pathnames.
  327. Using AllowSpecialKeys property
  328. Sub report
  329. Null values in a query
  330. Wie kann ich aus einem Formular aus Daten selektieren und in ein Textfeld schreiben?
  331. My FE updater - whadya'all fink?
  332. Subform Form.RecordSource inconsistent?
  333. Basic question on database size - does an empty row take up space?
  334. Beginners help for Mail Merge
  335. Correctly sum a column of currency in a report -- rounding issues???
  336. Cannot Set Bound TextBox Value
  337. Need Assistance with Error Handling
  338. HELP!: "Object doesn't support this property or method"
  339. Access database for rental properties
  340. Hyperlinks don't update with new record using VB code: Access 97
  341. Data loss in Access-97
  342. Hyperlinks don't update with new record using VB code: Access 97
  343. Problem Setting Value
  344. Problems with Setting Value
  345. Items included in one list but not in the other
  346. Online Performance - Snapshot Viewer
  347. need help on simple(?) query
  348. Singling out fields on Continuous Forms
  349. built-in filter functions failing when form recordsource is set to recordset
  350. Menu Bar Has Disappeared - Can't Get It Back
  351. Timestamp - Digital Signatures
  352. Filtering form by combo box
  353. Timestamp - Digital Signatures
  354. Simulate "Circular Queue" structure
  355. Problem on a report..,?
  356. Full Email Address Outlook Access
  357. Access 2K - Read-Only Forms
  358. Trying to combine Two queries into One Query.. Need Help!
  359. Function to determine if form is loaded returns strange value
  360. ADP Test (Multi-Posted)
  361. Menu callback function in Form's code module
  362. Count query - how to use the result in VBA?
  363. 1 x front end & 3 x back ends
  364. Global Variables and Terminal Services
  365. Addition von Zeiten
  366. Licensing and availability of VBIDE
  367. Accessing MS-Access from Solaris and AIX
  368. Filtered by form - differences between totals.
  369. PFS Professional File System 2.0
  370. How to add long items and scroll bars to combobox?
  371. Next / Previous Record Buttons
  372. Changing rowsource when dropdown the combobox
  373. filter adp report where record source uses aggregate functions?
  374. Access 2000 - Field Color Changes
  375. Need to return latest record when there are duplicates
  376. Combobox lookup function gives syntax error
  377. Page Break in Report (Access 97)
  378. Subcategory lookup tables
  379. Please Help With This Access Question
  380. distinct + sum
  381. one to one relation
  382. distict and sum
  383. Limit result set to top 10
  384. Are Access 2002 and 2003 compatable
  385. Access 20003 and 2003 compatability
  386. populating a combobox
  387. Excel automation causes runtime error 1004 on second attempt
  388. NORTHWIND questions
  389. Is access suitable?
  390. HELP...Exporting/Extracting an Access OLE object (Word document) to a Word document file
  391. How Do I Transfer Data From One Table To Another
  392. Combobox Question
  393. Mouse Wheel Subforms (again!)
  394. Ambitious report idea......... "Favorites"
  395. cdo scheduled task runs as user1 but not user2 ?
  396. select aus einer Tabelle in ein Textfeld
  397. Update query help
  398. Searching for connecting access to the web
  399. Resources for intermediate user?
  400. Assigning Default Value
  401. Close Button
  402. Load event of active form fires when Access closes
  403. REQ HELP: Upper Case "C" replaced Lower Case "c" in Table
  404. Query textbox value on a form
  405. Upgrading to newer version
  406. DCount question
  407. using control source on query result
  408. selheight question
  409. Editing object description properties with VBA
  410. Opening a word document or PDF file
  411. what sql string has to be?
  412. Synchronizing Microsoft Access
  413. Same date data for 12 months how?
  414. Two questions about Access 2000
  415. record update to a record in another table..?
  416. Secure Database Systems
  417. Importin a MySQL database into MS Access
  418. Update query doesn't work
  419. Best way of updating a table, based on the results of a query
  420. Error 3197: Deadlock?
  421. simple email from access
  422. Calendar Control question
  423. 1 ZIP code 2 Cities
  424. Report CAN GROW problem with Memo field
  425. Search Multiple Tables at once.........?
  426. (dhl) Exporting Table to Excel
  427. Update query in access - based on data in different table
  428. Access 2000: how to create a query based on a form parameter -- Please HELP!!
  429. Access 2000: How to query the fields in a table
  430. Access Query help!!
  431. Revisions
  432. Talking between forms.
  433. Default Value set the same as last valus for field
  434. Track the User logged in the Shared MS Access Database
  435. Email from Access to Outlook express
  436. Listbox problem
  437. User Level Security - Change of password...
  438. Help - Date Tracking
  439. Search for text in a text field
  440. Updating 2 tables in 1 to Many
  441. can't sort after filtering
  442. filtering form by combo box not really working
  443. 'Password to view project properties' in MSAccess 2000
  444. long strings in vba
  445. how to pass recordset object to procedures/functions?
  446. VBA - MailMerge error 2046
  447. Error 2427 upon opening a form/subform?
  448. The Expression "On Load" you entered....
  449. Please Help Acc97 Database has Got the Better of me
  450. Importing dates like 01JAN2003 from txt file
  451. parameter querie basics
  452. Access References Using UNC
  453. Winzip (wzzip.exe) via access
  454. Unknown function Date()
  455. Printing Properties
  456. how to track object modifications
  457. Access 97 Report crashes under Windows XP but OK on Win2K
  458. "one user account fits all" in a secured database?
  459. How do I group weekly dates, based on a Calender Table?
  460. Forms using linked tables fail
  461. Difficulty with combo box selection TO keep cursor focus
  462. vb.net and stored procedures on SQL Server 2000
  463. Can't edit the results of a query
  464. How could a three dots become a bolded vertical line in a textbox in MS Access 2000?
  465. A2K: Report formatting issue grouping on "Fld<>'Value'"
  466. check for identical input
  467. database servers rent
  468. whitespace string as primary key
  469. Multiple queries in a combo box
  470. query group calculation
  471. Simple Query Help
  472. Insert new data in subform
  473. Runtime Security
  474. Query table by the date
  475. Condittional formatting
  476. If blah blah blah #AND# If Not blah blah blah produce same results. Why?
  477. Help needed w/Runtime, XP, and "Can't be started…" error
  478. a2k - creating salary totals
  479. a2k - creating salary totals
  480. SendObject creating 2 attachments WHY?
  481. Farid writes:
  482. Output Excel File (dhl)
  483. Hyperlink captured in e-mail
  484. scrolling through report
  485. date query
  486. Can't acces the right excel sheet with vba
  487. PASSING KEYS
  488. Creating tables in another table of the same directory
  489. Normalisation Question perhaps?
  490. Date Query Grouping Help!
  491. Sort Table Through VB by multiple columns
  492. Need help with placing value into subform
  493. Code Just Stops
  494. Searching Database
  495. Custom Events / Application properties ?
  496. Validate fields.
  497. report not showing all data?
  498. Case sensative
  499. OT - Sharing Revenue
  500. File List Creator
  501. days between two dates
  502. Runtime security
  503. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  504. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  505. MS Access Trial version 2002
  506. Trying to find text within a text string
  507. Custom MsgBox Message
  508. "Opened Exclusively" message on same machine with 2 of 3 Windows users
  509. Dev Ashish acc 97 set page setup margins at runtime VB
  510. An expression question
  511. Is data secure within an MDB/MDE file?
  512. parameter query not working as expected
  513. Multiple Sub queries in a SELECT statement
  514. Difficulty with combo box selection
  515. Append Query/Memo Truncation
  516. Editing question: locating a charter within a string!
  517. Obtaining Table name from error message 3200
  518. how to Locate cell in the datagrid control
  519. Auto Fax when "printing" a Report
  520. Writing to CD from within A2003 VBA
  521. Help - Close Date and Effective Date
  522. a2k - quickest way of checking for a value in an array?
  523. Row handle invalid/referred to a deleted row or row marked for deletion
  524. Subform dissapears when adding a new record to main form
  525. I don't remember carriage and return
  526. Executing multiple sql DDL statements
  527. Highlight the date on the calendar control
  528. Change background/tab colour of tabControl?
  529. Recordset confusion
  530. Appending boiler plate records w/o having a relationship - Pleasehelp
  531. Acc 97 page setup
  532. Problems making new records through the form wizard
  533. Using Crystal Reports in MS-Access & Use of timer event
  534. How to strip out sender address and originating IP address from received eMails
  535. Please help with treeview
  536. Multiple Queries - 1 date range
  537. Problems making or deleting records through a form control button
  538. admin info
  539. Application for "Find a Dealer Near You"
  540. Form scrolls down a bit when opened
  541. Changing table structures in Access
  542. dialog print on report
  543. Larry--Access 97 Question
  544. Possible for Column Height in Row Source
  545. Probably an easy answer - Form and update question
  546. access problem on date conversion please hlp
  547. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  548. Move instead of delete
  549. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  550. Simple Expression Too Complex