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