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