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