View Full Version : access answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 [103] 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121

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