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