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. Import text to a variable
  2. Disposing of Old data
  3. Assistance with Query to Consolidate Records
  4. Request suggestions for streamlining distribution process
  5. SQL Help
  6. Handling Hex Values
  7. inputbox to textbox on bound form
  8. ACCESS accessibility from a C++ process launched from an ACCESS form
  9. trouble with access / sage
  10. Copy result of query to new table
  11. Problems Opening Access 2003 mde Files In Access 2002
  12. Add fill characters to ConvertCurrencyToEnglish code
  13. Multi Select List Box options to text boxes
  14. Copy all tables from one database to another
  15. Images in export to HTML, help!
  16. Dynamic Pricing Application
  17. Split a list in two
  18. Table Relationshp Question
  19. Select qry works - delete qry fails
  20. linking front end to back end
  21. Flexible Reports
  22. create new table - no duplicates
  23. referencing forms / modules without opening them
  24. User Level
  25. Thanks to three people who responded to a post...
  26. A strange error message...
  27. delete a table in an external database
  28. How can I go to specified entry from a Windows shell command ?
  29. Word form can link to Access db, as a data entry form?
  30. Updatable Queries using Access 2003
  31. Keeping elements of a report together.
  32. Query criteria based on 2 different form controls
  33. Keep together in reports
  34. Q: Chart in form on demand only
  35. Borrar una linea en un TXT
  36. Select only item in dropdown box
  37. Opening a form with 'openargs'
  38. creating check boxes at run time?
  39. Query to delete duplicate records in staging table
  40. Attaching SQL Tables - Unique Key
  41. Reading my Access database before tomorrow
  42. Compacting a database
  43. Parameters in a SELECT DISTINCT doesnt work
  44. FYI - Sql for splitting a delimited concatenated string into separate strings/rows.
  45. Connect to Access database that resides on web server via Visual Basic?!
  46. Rum time error - Command rejected
  47. Need Insight to Delete Query Method
  48. Access Object common properties.
  49. Can Grow/Can Shrink
  50. Dynamic number of fields in an Access 2000 Report
  51. Creating a new report in exisiting Access database
  52. Need Assistance to Resolve Query Syntax Error
  53. Database locks
  54. dubliacted record or clon record
  55. Report field limitations
  56. TreeView controls and the like
  57. LEFT JOIN with a subquery (?)
  58. Access 2K export to Excel - too much data
  59. Grouping by Dates in a Report
  60. Schema/User Name Oracle/Access linked tables
  61. Are there any forms open?
  62. Navigating Records
  63. Solution for cmd.CreateParameter and Access memo field types
  64. Converting from Access97 to Access 2003
  65. An intranet interface for Access
  66. Access Memo type and ADO createparameter
  67. repost: Access 2003 runtime
  68. delete query frustration
  69. Bug with TreeView control
  70. Find Duplicates Query
  71. Checking for an application in Code - URGENT
  72. How to export colors from MSFlexgrid to excel ??
  73. Help converting flat table to relational.......
  74. Reports - Work on one PC, not on another
  75. Probably a simple question....
  76. How many ActiveX controls can I have? Stack overflow problems...
  77. Access Menus
  78. Main/subform. Subform works but main form doesn't.
  79. Question on duplicates
  80. Distibute an application to many users -- Replication? MDE?
  81. Ask Password
  82. "Implying" entries
  83. Passing values between forms
  84. looking for db design book
  85. What does an NZ funcion do?
  86. Listbox gotfocus error that is driving me mad
  87. photo and images
  88. Split a field based on a character
  89. Access 2003 .NET Code Generator
  90. Dr Watson Access violation error following conversion to Access 97 from A2k
  91. Terminal Server and Printer
  92. Edit Textbox using KeyPress vba code in Access
  93. Help Needed With Bizarre Database Behaviour In Access 2003
  94. reports with images(the error in format or size?)
  95. refreshing records
  96. delete all records ?
  97. How to Avoid or Trap a Syntax Query Error
  98. Access to VB
  99. Access to VB
  100. Error Message : "Object Required"
  101. how can i get access to use search engines and return simple results?
  102. Microsoft Access Calculated Fields
  103. field types
  104. Import Specification changes
  105. Donde encargar o solicitar rutinas de Visual Basic
  106. odd page up/down problem
  107. Update Query Overwrite?
  108. Sorry, Q&A 5.0 need Urgent
  109. access 97: select into/insert into sql question
  110. subreport problems
  111. Navigate through combobox
  112. help with form data synchronising required
  113. Form Problem
  114. Very strange??
  115. visual Foxpro
  116. ADO in Access 2K and Grid Controls
  117. Pausing between forms
  118. Update Query which counts the occurrence of duplicate records
  119. saving table to excel
  120. OrderBy closes and reopens the report
  121. linking to a password protected database
  122. Brand new install of Office 97 -> 'Builder' and 'Add-In' errors???
  123. All you geeky buggers talk about is databases
  124. Access is denied
  125. Save a forms position
  126. Multi-Duplicates OK-Primary Keys
  127. Calculating Moving Average For Previous 12 Records
  128. What is best way to get access to Access?
  129. Synchronized Comboboxes in a continuous form
  130. Question about the QEB
  131. Access ?
  132. Saved Query Works in Access but not when called by ASP
  133. PROBLEM_WITH_MASK
  134. access97: parsing data question
  135. A.I. and automatic searching and retrival from online search engines using Access ?
  136. Security question
  137. Dumb question - took my stupid pill too early
  138. FileSearch object in Access 2002
  139. invoicing question
  140. File - Get External Data - Import - Text Type - Advanced - Specs PROBLEM
  141. How do you guys work?
  142. Getting the right record
  143. Close database window
  144. ToggleButton
  145. barcodes
  146. date troubles
  147. Update Query Confirmation
  148. Problem with Multi-Select List Boxes
  149. at wit's end about corrupted Access 2k records: followup
  150. Ms access email through Lotus Notes
  151. Cannot create MDE
  152. Acccess and Outlook 2003 User Defined Field
  153. Creating a Calendar from Reservations Dates
  154. Return Values from a Crosstab Stored Procedure
  155. Active forms
  156. Duda en campo importe en euros
  157. Process Records In A Table In Groups
  158. Combine four table fields into one record
  159. Problema al exportar datos a txt, y formato de numero.
  160. Date Format ???
  161. Compare Data In Two Tables
  162. Access 2002 mde in 2003 runtime environment
  163. Strip document name
  164. Linear update / make table query..
  165. PEAR DB 1.6.0 has been released
  166. User new addition to combo box with related fields that need to be populated.
  167. queries - simple, joint and multiple
  168. Acces Class Module from outside Access
  169. escape char for access
  170. Export Errors in Macro
  171. Adding one month to a date -- no as easy as it appers!
  172. How to clear an ActiveX-Control
  173. Impact of changing field property in Table
  174. import picture to Access2003
  175. How to make procedure non-reentrant?
  176. Delete spaces of fields in access table
  177. Winzip self-extract for Access Runtime install problem
  178. Passwords & Forms - Access 2000
  179. how to calculate man hours for different project ?
  180. Generic menu handling code
  181. Warehouse stock location tracking
  182. Report from Crosstab Query
  183. pdb file
  184. Numbering in Report
  185. Opening MDE Application using File Associations.
  186. general db design
  187. Virtual Memory
  188. Concatenated column in a report
  189. List box using tables
  190. Access Forms
  191. Error 3061
  192. Problems Caused By Several Users Using A Single Frontend
  193. query does not extract records if blank fields are included
  194. Generate PDF with VB code in Acrobat 6.0
  195. fenton-linson sf wedding
  196. updating a field with code
  197. Access 2.0 Multiuser Application
  198. Unique index works but...
  199. what is wrong with this?
  200. Can A2002 Reports have multiple Groups on total database records???
  201. Double combined Search
  202. Combo box choices using query
  203. HEEELLP - No Value given for one or more required parameters - Win2000 & XP French version
  204. Create Shortycups in MS-Access ADP
  205. How to filter on a report?
  206. Certain Functions Have Stopped Working
  207. Reserved Error (-7711); there is no message for this error
  208. Reading a record set, code reads date as American not English
  209. Create .mde from .mdb with code or command line
  210. Sending an email from Access
  211. Access and DB2
  212. Comparing data in ms access
  213. Querying table using duel date fields
  214. Query Puzzle Access 2000
  215. Access 2002 conversion back to Access 1997 error
  216. looking for a tutorial or detailed infos on how to work with arrays??
  217. Implementing A Junction Table
  218. Lost the plot in design
  219. DAO and database corruption
  220. Updating an Addin
  221. Passing Query Results to Form
  222. Random AutoNumber - Is 0 possible?
  223. displaying data in multiple columns
  224. Does any body know where I can get a list of english words?
  225. Can't display embedded OLE object as icon
  226. Subform Record Pointer Resetting on Requery
  227. looking for online zipcode database and program
  228. Fails to navigate to the proper record WITHOUT a MsgBox
  229. HELP! HELP! HELP
  230. Getting data into Access Table from SQL
  231. Outlook events
  232. Help with automaticallly adding weekly charge
  233. Network Computers Suddenly Can't Access Database?
  234. Just converted to A2002, querries not working - please help
  235. AUTOMATICALLY UPDATE TABLE FROM FORM
  236. RTF2Control/divide text into several paragraphs
  237. Text Box Control Source problems.
  238. Increment Total on Second Table from Form
  239. forms - control tip text
  240. Generalization in Microsoft Access
  241. Length of Formatted String
  242. Query Causes Hard Crash
  243. Set required field to Null
  244. saving [enter a value] in update query
  245. Need help with delete query
  246. DLookup questions
  247. removing last letter in data for a report
  248. excel
  249. What the hell is wrong with the Update statement!
  250. Limit the number of 'Selects' in Multiselect
  251. help with query revised from post (help with query (month as Text) up to given Month) 14/02/2004
  252. Problem with calculations!
  253. unique table property
  254. Word Table to Access
  255. Export to Excel
  256. Text string search query
  257. list box validation
  258. I'd like to get rid of new record so that user doesn't notice it.
  259. field-reference in msAccess Report (SQL server backend)
  260. Update Combos using vba
  261. Numbers in Listbox
  262. Replication with Split database
  263. Error accessing the OLE registry
  264. Problem with Query Date Parameter Selection
  265. Reports - Line Spacing in Detail Section
  266. XP Developer Packaging Wizard Error
  267. Access 97 Runtime - application icon doesn't appear
  268. Parameter Like Statement Criteria Problem
  269. Opening Access 2002 mde Files In Access 2003
  270. Upgrading from Access 2K to ...?
  271. "Query by Search Form" Question...
  272. report building
  273. Upgrade from O97 to O2K --OR-- O2K3?
  274. Error: Enter Parameter Value
  275. Label Wizard - Loses margins
  276. Convert null to 0 in crosstab query...
  277. Access vs. SQL
  278. Dialogic Board / Saving Audio files / Dictation
  279. Good relational database design
  280. combo box after update question
  281. Problem trying to replace a Form using the Macro CopyObject command.
  282. Help!! Calculations
  283. Form problem
  284. OLAP cubes
  285. Scroll in subform only down, UP NOT possible (with mousewheel)
  286. Call Logging
  287. Import Wizard Puzzle....
  288. Corrupted(?) Menus in Access 2000
  289. wrong order of images in printing reports
  290. Object invaliad or no longer set error after onverting from Access 97 to 2000
  291. Exporting to excel csv and how to set the cell to wrap text
  292. images in reports doesn't refresh
  293. Help needed: Wrong strTbl in fRefreshLinks
  294. Complicated problem
  295. Reading forms and reports information in .adp
  296. prohibit double booking in room hire database
  297. text to column
  298. How can I get all table names from MS Access
  299. Printing documents from an Access form?
  300. Brick Codes
  301. Calling vb from other application
  302. #include
  303. very tricky sql statement
  304. Delete query problem
  305. Bound form, SQL server, opening in wrong mode
  306. thin drivers for ms-access ?
  307. Why to be careful declaring variable As New ...
  308. changing field names
  309. How to query for multiple criteria?
  310. Attach a recordset to a subForm?
  311. Slowwww printing on inkjet using DoCmd.Printout
  312. looking for online zipcode program and database
  313. Access 2000 VBA help file
  314. report and print a5 landscape
  315. Running Button Method from Another Form
  316. Need To Create A Master Record
  317. If...Then...Else
  318. Disc catalog to Access table
  319. Error from Office 2000 to Office XP
  320. Access 2k ActiveX treeview control
  321. How to replace a .mde file when many users are connected to the file
  322. Security--permissions not working properly
  323. Dlookup function gives "You canceled the previous operation" errmsg
  324. Scaning Documents Thru Access
  325. Script for Access FTP
  326. Cannot link table from SQL Server 2000
  327. Updating multiple tables with one form
  328. Using a Recordset to Send Emails in Outlook
  329. Calculating fields in query
  330. Cannot link tables from SQL Server 2000
  331. Code to convert a Number to a spelled out number
  332. Office Delovoper
  333. Building a report
  334. Searching in VB
  335. List plus "Unknown" in Combo Box
  336. Access fails when clicking on a subform
  337. Highest Record?
  338. Filters and sorts in datasheet view
  339. Open Access Maximized
  340. Fremdschlüsselbeziehungen anzeigen lassen?
  341. Parameterized Query
  342. Building a report
  343. Easy one
  344. Acc2K FE, SQL Svr 2K BE, Slow form display?
  345. OT - NewsGroup Personality - Gilbert And Sullivan
  346. nz function with where clause
  347. Save Contents of Unbound Field
  348. Getting into secured old databases
  349. sorting difference query-report
  350. progressive number
  351. Nested IIF function
  352. default keypress
  353. Question on multiple forms and referencing data
  354. Error: User-Defined Type Not Defined
  355. Err.msg: You canceld the previous operation ????
  356. Reading excel file and writing to access table
  357. Sample database
  358. Access 97 to XP Access Conversion Error
  359. Can we use Office Document scaning utility into Access as ocx ?
  360. Access <- > SQL Server
  361. Locking records
  362. How to make/package a mde/mdb file so it can be run on a PC without MS-ACCESS installed...TIA
  363. Setting the recordsource of a report
  364. Help needed to store quiz solutions from db to VB
  365. Adding Data to a N:N relationship
  366. Reservation system in Access?
  367. Can we display a report without print preview? General queston
  368. after update handling
  369. adp connection
  370. Rdb to MDB
  371. Error Accessing File - Network Connection May Have Been Lost
  372. sorting mixed data types in field
  373. Another update problem?
  374. Continuous forms, highlighting specific record
  375. ODBC and Access Database Online
  376. Requery every subform?
  377. Screen resolution problem
  378. ODBC
  379. how to declare only once
  380. help with query (Month as text ) up to given month
  381. Print multiple copies
  382. 32x32 form icon while taskswitching
  383. Access 97 to XP error Japanese Characters
  384. Zip Function
  385. Sharing Access 2000 Files Between Computers
  386. Saving a record in a suborm with code
  387. Forms and Subforms - Many Calculations
  388. Access 2000 - the right choice?
  389. Access 2003 linked table manager not displaying tables
  390. /runtime + compact on close + references = crash?
  391. Senior Microsoft .NET Programmer/Analyst needed
  392. at wit's end about corrupted records in Access 2k table!
  393. Selecting Data to get a value
  394. Sending date to query problem
  395. Inserting a record & adjusting form?
  396. 3 page "Detail Section" - is it possible?
  397. Execute/Insert into method works sometimes??
  398. Referring to subform
  399. Displaying information in Access - general question
  400. OLE IMages in Access DB
  401. problema di sviluppo
  402. How do I declare a variable that allows data to be added to it without losing its existing value?
  403. vexing decimal problems
  404. How to attach an SQL statement to an unbound control????
  405. Need Asssitance with On Delete Code
  406. Can't Open Anymore Databases
  407. MDE
  408. "Catch all"
  409. Dates
  410. ADO not registered anymore
  411. Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)
  412. relating queries to tables
  413. Linking to Act
  414. Replication ID /CustomerID problem
  415. How do I create an Icon in a form to Print a report
  416. MouseHook and Tab Controls
  417. Readable lables in a Pie Chart...how can I?
  418. Network Update Data,Information needed
  419. form fields and problems with recording data into the table from the forms
  420. Forecast Report
  421. how to retrieve 'quick launch toolbar' folderpath help!
  422. Calculating subsequent field values in table
  423. append property
  424. Need autonumbering help (novice level)
  425. Access to MySQL
  426. Access 2002 Database Design Help
  427. Display updated Totals
  428. Query Help
  429. Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)
  430. Beyond my scope =-(
  431. Can't change admin. password because tools menu missing
  432. queries doesn't return new records
  433. Anyway to change the "style" of an existing form??
  434. Count distinct occurences
  435. Re-use report by using a query to filter
  436. Jumping to row in Subform
  437. Are drop-down menu itmes stored in table?
  438. Sympathy for Starwars :)
  439. Method to Display Future Popup Messages
  440. Prevent Deletion of Keywords in a Combo Box Table
  441. query with criteria on two fileds in one table
  442. Updating records in related tables...
  443. mde
  444. MS ACCESS Reports
  445. How to create own tab delimited file
  446. Create Read-only file in MSACCESS
  447. Word files import to access database ...?
  448. how to refresh the "other" data base window
  449. Microsoft Progressbare V.6 how to use it ?
  450. Link To Selected Fields
  451. Running Access 97 on Windows ME
  452. invalid arguement when updating memo field -- size limit?
  453. Access VB6 Integration
  454. Please help
  455. Date Conversion From Text
  456. Determining Field Type and Loops
  457. BackColor On TextBox
  458. acting on null recordset
  459. Help with Function to redisplay a cost price...
  460. Publish to web, Local option only enabled?
  461. ? about closing this popup form
  462. value substutition
  463. One last question about using GetObject...
  464. Force Textboxes to new page in Reports --- Help
  465. Forcast Report
  466. Average Payment in Days
  467. Adding a column to an existing table with data
  468. Access 2000 and Calendars
  469. VBA Event Procedures in Form Module Lost Association to the Control on Form
  470. Wanted - report writer to access ms-access databases
  471. Creating a Timesheet
  472. Average Payment in Days
  473. requery problem
  474. Windows 2000 Server Listed as a User in an Access XP Dabase
  475. Access 2002 deployment
  476. LIstBox vs Combo Box for looking things up
  477. Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08
  478. Table Relation Question
  479. Adding Records using DAO and variables derived from queries.
  480. time based message box question
  481. Is there a way to speed up execution of this code?
  482. Concept Question
  483. Code to duplicate records
  484. Help with pictures
  485. Calculate in Text Box speed
  486. user input to query
  487. Writing to a file with VBScript/ASP sometimes gets truncated - why??
  488. Advise please
  489. Outlook Express <-> Access97
  490. Help with dlookup required
  491. Access Forms flow--> Visio
  492. How to distribute app with Jet binaries?
  493. should this ng become moderated?
  494. Median in a Query
  495. Upsizing question
  496. Print quality varies with Access version
  497. Building an expressions where parts are unknown at design time
  498. References
  499. How to access a control through code?
  500. datepart to get mmddyy from date/time formatted mm/dd/yyyy problems
  501. Problems With Access 97 Falling Over
  502. MSDE 2000
  503. download data from access ????
  504. How can access desktop access database from my unitech pt930(s)
  505. Text criteria weirdness
  506. Web Enabled Access 2000 Database
  507. OnNextRecord
  508. HOW DO I ADD a vertical row of values in Access 2000??
  509. More getobject help, please
  510. Security Issues In a Multiuser Environment
  511. query to combine two tables
  512. Mapi Fails on MapiSession.Outbox.Messages.Add
  513. I Am Really Crazy
  514. Acess 97 toolbar help wanted
  515. Bibliographic formatted references
  516. Forms Format
  517. Strange "Mystery Record" Behavior
  518. sql server pass through query
  519. Supress Automatically opening modules
  520. Building ODBC Connect strings that work
  521. How to use SQL queries in a report????
  522. ADO recordfind help
  523. Can't compile anything????
  524. =Format$ field doesn't work after copying database to new computer
  525. Subtract one year accurately?
  526. Groupwise Email from MS Access 2000
  527. Calling a function, basic question
  528. How to know if instance is already running
  529. Access 97 less available records
  530. How to put a menu bar DIRECTLY on a form.
  531. How to print tab in the middle of string in a report?
  532. Backwards Conversion
  533. Storing Only One Value?
  534. Future of MS Access......
  535. 401K Account Fees
  536. Link Code Modules instead of Import Access 2000
  537. Check for a Date then do something....
  538. Payroll Hx Table and Reports
  539. "The field is too small to accept ..." error for a bound control on a form
  540. Update Query - Finding and Updating Maximum Order Number
  541. Sympathy for Starwars :(
  542. please help me -microsoft access help reqired
  543. function(s) to split an e-mail address into user and host
  544. getobject
  545. access 97: duplicates in query
  546. Editable mde ...
  547. Form letter question
  548. Form Controls Colors
  549. Import table
  550. Interland MS-SQL Hosting - somewhat OT