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. trapping the untrappable ?
  2. Query writing help
  3. date+order
  4. Error in module from XP to NT
  5. Using a combo box to look up values and to enter new values
  6. MS Graph Completely Useless in A97?
  7. Email a report in MS Access
  8. exclusively open, locking the database
  9. Merging and deleting duplicate records
  10. Draw Lines and Boxes Better explained
  11. Drawing lines and boxes
  12. Using a Japanese Access '97 database under Windows XP
  13. Step by step how to open a popup calendar on the main form?
  14. #Name Error for Calculated Field on a Form
  15. Date/time problem
  16. Numbering help
  17. Endless output using OUTPUTTO MsWord
  18. ListBox doesn't change focus with form navigation
  19. Problem with Import External Data
  20. Query grouping problem
  21. Link Tables problem....Way too slow to operate.
  22. Error 2024
  23. In-Operator and global variable
  24. Database Access
  25. Error handler add-in
  26. Re-write of Allen Browne's "OnHand" function -- opinions?
  27. Colour values form a bitmap
  28. access select query
  29. Help Using Text Box to fill a Listbox
  30. Validating imported data
  31. button to import .xls to access
  32. Access 2002 discontinued?
  33. filling combo box based on previous combo
  34. Begginers' problems
  35. Rank function
  36. execute SP from ms access
  37. Accessing webservice from access
  38. Pulling data w/ date parameters only when a past field value is null
  39. Override Access update with stored procedure
  40. Calculate the median
  41. Adding a Duplicate Record
  42. Can't get around temp table in front-end
  43. Hiding Toolbars with code
  44. Using mdb databases
  45. Importing new entries only from .csv file
  46. Export Data to Excel
  47. Looking for suggestions for "How to Develop"
  48. Resizing code
  49. Help+invoice+numbering
  50. Inputing date to separate tables while retaining links
  51. Retrieving data from an AS/400 stored procedure
  52. Audit Users/Login databases/tracking
  53. Auto writing Excel spreadsheets from Access (97 & 2K) fails to releaseExcel
  54. MSAccess 2003 - Digital Signature
  55. MSAccess 2003 - Package Wizard
  56. Printing to a specific printer
  57. Linked tables in ms access asking for login/password
  58. Gauge or timeline control for continuous forms
  59. debugging classes
  60. good syntax with if statements
  61. Mental block - text box binding and queries
  62. Changes to data from a query
  63. Point-Of-Sales
  64. Exporting result of a query to a db3 format?
  65. Selecting only one page out of a several-page report for printing - how to route in Access?
  66. What operation have I cancelled?
  67. Excel Linking
  68. InputParameters
  69. Need ActiveX control for JPEGs in Access 97
  70. Unbound Combo Box Record Selector Question
  71. HELP! Web update of memo field crashes Access, errors repeatable. HELP!
  72. ado recordset field becoming NULL
  73. MSSQL Views a tine problem they may help with.
  74. SQL DELETE and Me.Requery in Access
  75. any ideas for boolean yes/no field in table
  76. day of week
  77. Getting 2 counts() of 2 foreign keys
  78. Sorting or Grouping problem
  79. Any Add-on for this?
  80. Tools for access similar to Red Gate SQL Compare, SQL DataCompare and SQL Packager
  81. Need help with reports
  82. Random Record
  83. Need to overwrite a table that is already being used. Is this possible?
  84. Error after 380 CreateObject("MAPI.Session")
  85. Bug in Access 2003 ? Error after 380 CreateObject("MAPI.Session")
  86. Standardfiltern von Datensätzen komfortabel gestalten
  87. sharing data on acc2k
  88. Counting distinct Surnames on report
  89. How do I do this?
  90. DoCmd.TransferDatabase
  91. can this be done with one query?
  92. Year-to-Date Totals
  93. RUN Crystal Reports in MS ACCESS
  94. MS Access ERROR ! plz help !
  95. How enable Aligment and Sizing toolbar
  96. display messages
  97. calendars in reports
  98. Manipulating Date
  99. Problem.. Report?
  100. thoughts on table setup
  101. Criteria
  102. Concatenate multiple rows into one string
  103. Use result from Inputbox in query
  104. Security Challenge
  105. Help with a query
  106. How do I do this?
  107. The truth about SQLFetchScroll() and the cursor library? (ODBC / MS Access 4)
  108. Access crashes when adding linked tables to query grid
  109. pushing data from unbound text boxes
  110. Help with code
  111. Units Conversion in Data Entry Field on a Form
  112. HELP: Access record ID's corrupted by WWW insert and updates, memo field may be culprit
  113. Limit number of users
  114. VB Editor Error - desparate!
  115. Report From Table - Unique Records in Several Tables
  116. New Be Need help with date.
  117. Editable Views (Queries)
  118. Import Text - Problem With Limits
  119. problem of drawing round and others
  120. In-house server to WAN and T1 environment
  121. Snapshot Format not a SaveAs/Export choice in Access 97
  122. new to access, but not to visual basic
  123. Print the current record of a form
  124. Couldn't find file 'System.mdw'
  125. Gathering workstation data
  126. ODBC Driver for .adp
  127. How to Obtain the Height of a Form?
  128. Delete all objects from database other than tables
  129. How to Automatically Resize Form Controls When Resizing a Form
  130. Date problems yet again - sorry Gurus !
  131. Autonumber mess, figure out the number
  132. Stuff a string
  133. Parameters in QryDef in Acc2000
  134. Form error
  135. suddenly "on Error" doesn't work anymore
  136. how do you know where the call is coming from
  137. Detect adp connection state before opening
  138. To Complex of a query
  139. importing Data from access
  140. I Cant Return a Next Due Date based on two items of criteria?
  141. Reports and If()
  142. VB error: this will reset your project do you want to proceed anyway
  143. Sending a Form by e-mail
  144. Putting fields on the first label...
  145. Code : DoCmd.OpenQuery - and bring result back to form front
  146. Print report to .pdf
  147. How to Re-parent a Record
  148. Opposit of a maketable query
  149. Print MS Word Merge Document from Access?
  150. Change focus between Property Sheet and Form Design
  151. notification of upcoming date; filling in form letters automatically
  152. Het zal toch niet zijn wie ik denk dat het is?
  153. Determine Compile Status / Compile Target db using Vba
  154. Determine Compile Status / Compile Target db using Vba
  155. Importing data from text files of non-standard layout
  156. using access as a front end, building a stand alone exe
  157. PLEASE HELP!- Linking multiple forms to ONE record
  158. Date format confusion
  159. event sinking with Word question
  160. Jet engine install
  161. access 97.out of memory error..help. tia
  162. Help! Creating Reports Using Multiple Tables
  163. Access 97 vs XP
  164. Good source to learn ADO?
  165. Form Timer event fails to fire on heavy database access: Access 2003 bug?
  166. Accessing the New entry portion of an access form
  167. Is it possible to "remember" log in credentials? (Many MDB's sharing one MDW)
  168. Query takes ages to run...
  169. Table data issues
  170. docmd.openform not working
  171. deleting duplicate records with only one field different
  172. Select Query
  173. E-mailing a form using Lotus Notes
  174. Application-defined or object-defined error in Access 2000
  175. Access 2003 Conversion Errors
  176. Adding Time
  177. Setting an object to existing form generates 'can't find form' error
  178. Recording locations of an object.
  179. invoices from 2002 & not from 2004
  180. Arjen Jongeling, een oude bekende
  181. Check Box Problem with Make Table Query
  182. Colored Background in Command Buttons. Is it Possible?
  183. Nur ausgewähle Spalten/Felder aus Formular drucken?
  184. Table Value Setting..conditiontal
  185. docmd.runsql
  186. What is the future direction of Access?
  187. Change Screen Resolution using VB
  188. Minimizing forms in a dll
  189. List Box on Form
  190. There was an error executing the command
  191. Question about Field names
  192. backup/recovery: compression command line multispan utility
  193. Open an exclusively opened mdb, any way?
  194. Converting Back to Access 97
  195. Having trouble importing an XML file
  196. HelpFile F1
  197. Lookup textbox within form ( Parameter Value error )
  198. Count by date/id across tables??
  199. Excel functionnality in Acces
  200. FileMaker 5.5
  201. Tony Toews Performance FAQ
  202. can this be done
  203. you must specify the name the macro's macro group was last saved under
  204. Access && JET
  205. using location in report parameters
  206. Query-Dates and duplication
  207. Rounding Up problems
  208. Network error, Access 2003
  209. Need help with extracting table data into database from web
  210. Subquery
  211. Afterupdate & execute problem
  212. database over internet?
  213. Help with reports
  214. Trciky DB tables question
  215. Constant variable: How? Where? Help!
  216. A problem occured while Microsoft Access was Communicating with the OLE or Activex Control
  217. Input mask
  218. updating people's FE by sending them the recently modified objects
  219. expression built sting / Parsing text field
  220. sub-report loses its sort
  221. Selecting sub-reports by date criteria
  222. Access lookup's
  223. Better error messages for Input Masks
  224. A "Gradient" for Form Sections
  225. Updating Queries, Forms, Macros, Modules
  226. Table design question
  227. Autonumber in query
  228. inputbox and dlookup issues
  229. hacking to the core of access
  230. Database Copyright
  231. Loading from web
  232. ComboBox RowSourceType containing UDF => call back oddities
  233. Multiple instances of the same database...
  234. Assistance with Posting Inventory Average Weighted Cost
  235. concatenating two fields - problem with leading zeros
  236. databases that grow like cabbage
  237. SQL Statement Help
  238. Call Function On Main Form to Sub Form
  239. empty screen opening Access 2000 database
  240. Call Subform Function From Main Form
  241. help!cannot lock the subform
  242. Multiple instances of the same database...
  243. Access 2000 forms
  244. Joins !!
  245. Query Question
  246. Autonumbering
  247. totals
  248. Delete Query - Criterion in unrelated table
  249. Example of a University database
  250. Access 2000 ----> Access 97
  251. Service accesing a remote access database
  252. auto update
  253. auto update
  254. ADO Cursor performance
  255. How to create MDB file according to the version of the Access installed
  256. Opinions on Software called ViewPoint
  257. What's wrong with this simple code?
  258. Problem deleteing linked tables
  259. JET/DAO tables bound to forms in Access 2000 ADP: Anybody doing it?
  260. copying controls from a form to a tab control
  261. Bizarre problem referencing form by name
  262. Which choice did he make?
  263. How to make Command Buttons 'pretty'???
  264. COM Add-ins
  265. Unbound listbox in continuous subform
  266. Date Problem
  267. Exporting Colours from Access to Excel
  268. Just how good are you really?
  269. sum number of rows in different queries?
  270. Connecting Access Db on Solaris
  271. Access & Security
  272. Copy one column to another???
  273. Can I use wildcards in TransferText import?
  274. Access Data to Outlook
  275. Sending One Field To The Printer
  276. displaying the data of three tables in one form
  277. Query set within a specific amount of days
  278. VBA.Trim() and long varchar columns
  279. Cost Center Time Reporting Application
  280. Event procedure using iif for line breaks.
  281. Form controls
  282. Question about Primary Key
  283. Re. Embed or save ms word into OLE field
  284. where I made mistake on compact the current database?
  285. Please Help
  286. Data Sheet Row Colors?
  287. Compare 2 tables and only show the changes in result sheet
  288. Open source alternative for MsAccess?
  289. Active Directory - Access XP
  290. Query to list near neighbours
  291. How to get directory for CurrentDB
  292. how to flatten sql query?
  293. Deleting Workgroups
  294. What's the 'best' was to print a complex calculated field on a report?
  295. Limitations in exporting to Excel?
  296. Moving stored procedures
  297. Access 2k database keeps changing security permissions
  298. How to set Enabled property - wont allow if control has focus
  299. Strange annoying problem - long chunk of code
  300. Strange annoying problem - long chunk of code
  301. Form freezes.
  302. ACCESS 2000 Question
  303. Add record to Subform when not on Mainform
  304. Me Statment Help
  305. Waiting for MVP Happy Dust?
  306. Length(field_name) in Access?
  307. A way to use crosstab query fielld names as column headings?
  308. embed or save ms word file into ole field table
  309. Data Access in multiple history tables across multiple mdb's
  310. Missing Records
  311. break points in Load_Form event in Access 2000
  312. MDE Creation on Win98 & WinXP
  313. access 97: ftp code problems
  314. Locked data base? Please help
  315. change load order of form/subform
  316. MSDE Error on attempting to create new Access 2000 project
  317. Mini Labels
  318. Access Project - Primary Key / Foreign Key question
  319. Pages In Access
  320. cancel as integer and the like: why and how
  321. Continous Form constantly moving when loading
  322. Your small effort make big change
  323. Unbound Data Entry Problems
  324. Enabling Tab Stop Makes Form Control Disappear
  325. Close Button Problem
  326. Database Form Question
  327. variables in use
  328. should i index linked fields
  329. spellcheck on exit?
  330. Report Header in Mailing Labels...
  331. how do you programmatically create a relationship WITHOUT creating an index?
  332. Upsizing to SQL 2000
  333. Quirky Record
  334. could not update; currently locked by another session on this machine
  335. Want updates in .mdb file to update other .mdb file too
  336. Using lookups or rates problems
  337. conditional formating
  338. Access97 on 1 GB+ System
  339. Strange Characters in Memo Boxes
  340. I want to change the spezification for transferText Delim
  341. Constant ODBC Call Fails
  342. Convert embedded Word docs to linked
  343. Need to send an email in code
  344. Calling a text box in Code Editor
  345. Computer Books, Inc MS Access Books - up to 80% off
  346. Could not find installable ISAM
  347. First Field in Multi-field PK of Linked Tables not displaying in Unmatched Query Wiz
  348. Problem Setting A Field To Null
  349. Uosing different rates for employees in various stages
  350. Looking up values
  351. Can't read MS Access databse
  352. View only selected fields
  353. Report from a single record
  354. Replacing Characters in the Field
  355. Compare tables
  356. I need to trick a requirement of an exclusive access in Access 2000
  357. Subform
  358. Stopping before EOF
  359. Preventing running automacro from VBA
  360. A2K - prevent "/" being input
  361. Importing Excel to Access
  362. List Box
  363. How to send a picture with outlook via access
  364. DoCmd.OpenReport RPT_TEST, A_PREVIEW, QueryAsFilter fails in A97
  365. Help! cannot delete records in the table "PRODUCTS"
  366. Can Access do this..?
  367. Cancel Change In Option Group
  368. auto update
  369. A2K - note field in report not fully expanding
  370. Error when trying to download using ftp module
  371. default values
  372. Adding a new field to an existing form
  373. left join driving me crazy
  374. Access + Postgres SQL
  375. Code Help PLease
  376. SQL server classes in St. Louis Area
  377. Unable to open / design saved form in Access 2000
  378. book on stored procedures for SQL Server 2000
  379. Adding a table column using VBA/ADO
  380. Database Held Hostage!
  381. Back End/Front End Puzzle
  382. How do I cause a "record find" to open before a form?
  383. Form_BeforeUpdate procedure
  384. O.T. First time ever for me to have an eCommerce site...
  385. use a word file as my form for my database
  386. Access 2000 adds brackets [] to queries
  387. Running At? (OT) - DAPs and ASP
  388. Subform
  389. Error 2001 You canceled the previous operation
  390. Creat an MDE file?
  391. HELP, HELP, HELP........plz: Finding and displaying records
  392. Cancel Change In Option Group
  393. Unable to return data for some views in Oracle Applications using Access and ODBC
  394. alternatives to #if ... #else ..... #end if statement
  395. Mid function perhaps??
  396. how can I speed up this function with a dcount in it?
  397. Make Table Query - unique records from other two tables
  398. More Queries...
  399. Remove identical records from the same table
  400. Data Across The Network
  401. Network Down
  402. what is wrong with the goto command?
  403. what is the difference between attributes and properties in things like fields?
  404. I have a global var named WhichFormOpenedMe. Its value is "frmMainMenu". What syntax do I use with the variable to perform this: [Forms]![frmMainMenu].SetFocus
  405. when to use indexes
  406. When is it a look up table and when is it an real entity?
  407. Loop doesn't find all occurences of search, need help with recordset
  408. Deleting Records
  409. Help with Totals in Report
  410. Automatic update of linked ODBC tables
  411. Developer Extensions Question
  412. Help - Log Transaction
  413. 2 databases & synchronization....
  414. Multiple Users
  415. Using wild card in Iif statement
  416. Linux
  417. Two Databases
  418. Any way to check current On Error status
  419. Disable Outputting message popup
  420. Error 3220 - Function Is Not Available In Expression In Table Level Validation Expression
  421. Expression builder and Loaded Forms folder
  422. Listbox with checkbox displayed
  423. Copy/Paste Extra
  424. Mini Inkjet Labels
  425. Access2003/OL20003 BCM
  426. How to make a search engine in a form
  427. RunSQL vs Execute rehashed
  428. Access won't close after using DLL
  429. increasing and changing the tick box
  430. testing for Key Violation
  431. determining a report's page orientation with VBA
  432. Wierd Access behavior while deleting a record
  433. Aligning Form/Report Controls in Access 2003
  434. Emails With access 97 BUT NOT OUTLOOK
  435. GetString method
  436. Using Listbox contents as query parameter
  437. Conditional formatting with subforms
  438. 99% CPU Usage...but for real this time...
  439. E-Mailing A word attachment using Access
  440. Access Developer's Edition
  441. Open Reports & Fit
  442. Query and pulling out certain parts of a field
  443. Delete button is not working
  444. parallel reports after random selection
  445. Problem in a report?
  446. AC97 - Replication - File Sharing Lock Count Exceeded
  447. Access + MySQL = ODBC-call failed... sometime
  448. Combining multiple records into one
  449. Report printing
  450. Access and SQL server
  451. Easy q: Moving data in 1 field to data in another field (all records at once)
  452. No Current Record message
  453. how do you get a file off of a web server?
  454. Split information in fields
  455. split information in fields
  456. modifying lay-out of word-document with automation
  457. Dire need of Help!
  458. Recordset in subform based on field in parent form
  459. happy Sonday (spider)
  460. MS graph changing min and max axis values
  461. Access 2000: Is this corruption or not?
  462. Excel to Access - code issue HELP!!
  463. Form records to Report
  464. Access 97 - is this possible?
  465. how to put text under a key
  466. Ms Access Reports Letters and Envelopes
  467. Over-riding autonum
  468. Automatically join MDW
  469. Check Status of SetWarnings
  470. TransferText truncates Double datatype to 2 decimal places
  471. Query slow for one user, not others
  472. DateTime Access bug?
  473. How to avoid clip board message when duplicating record
  474. Selected Property MS ACCESS 2000
  475. Calendars
  476. Error: 429 ActiveX component can't create object with Outlook 2003 automation
  477. Query Quandry
  478. Open Form from Previous Navigated Form
  479. This is odd!
  480. Requerying a list box - but not seeing the updates applied on requery!
  481. How to test if cursor is in text box?
  482. using form control values in queries
  483. Add 1 to Serial Number
  484. Subselect from 2 tables from 2 different databases
  485. Procedure exits prematurely
  486. Is Access Dead?
  487. Unbound Textbox Character limit
  488. Docmd.SendObject, Lotus Notes and Exchange
  489. How do I parse XML files?
  490. Help! Another report criteria stumper. "The field is too small to accept the amount of data..."
  491. Help! Table locking issue in report with no sub report etc.
  492. Help! I have a table locking issue in report with no sub reports
  493. OLE File Associations
  494. almost the same name
  495. DCOUNT and DateRange Parameter
  496. syntax help for the gotorecord Method
  497. syntax help for the gotorecord Method
  498. Time BETWEEN function
  499. Behavior Problems with MySQL
  500. emailing from access
  501. Report to List All Objects Modifieds After Spec Date/time
  502. DoEvents?
  503. Sending Mail
  504. 100% CPU Usage + "This action will reset...."
  505. Data Access Page - an introduction
  506. Use server log on name
  507. Where do companies like Yahoo get their mapping information from?
  508. Exporting to a text file
  509. Front end comparison
  510. Format problem on entry
  511. My Access applications are getting messy.
  512. String Intersection
  513. Booting people out of a front end
  514. Disconnected ADO recordsets lose their data
  515. Records *not* in a set
  516. Mics: String matching, Zip code - alternative city names
  517. Control visiblilty of a text box on a Tab Control
  518. Multiple Users
  519. Help! Packed app can not run on other computers
  520. Migrate Raima embedded database (7) to Access
  521. Need a combination - top 3, and group by...
  522. How do I detect that there has been no activity on a form
  523. string with quotes
  524. Report Problem
  525. access-vb problems...
  526. Data Access Pages From Forms
  527. Send Object with No Col Headings
  528. delete a record in a subform?
  529. Listboxes and long items
  530. hi
  531. Always on Top MakeTopMost
  532. Conversion from Access 97 to Access 2000
  533. Changing a text box to a combobox on an open form.
  534. Query and Table Problem
  535. system call
  536. MSFlexGrid and data from spreadsheet
  537. creating an HTML library of objects
  538. datediff function
  539. Tab Forms with Multiple Rows
  540. Off - Topic... need help recovering inadvertently deleted mdb file off Windows XP machine
  541. datediff question
  542. Compatibility issues
  543. Query current record
  544. Help with sharing a database! Error 2501
  545. Change security message
  546. Converting backend to SQL
  547. Need script to populate Northwind.mdb
  548. Function name stored in a variable
  549. SQL Problem
  550. timing response times in milliseconds