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