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. Error Handling
  2. Error Handling
  3. Capatalise the first letter of every word
  4. Capatalise the first letter of every word
  5. TabControl in .net
  6. TabControl in .net
  7. Recursive File Search VBA vs VB
  8. Recursive File Search VBA vs VB
  9. Database size increase
  10. Database size increase
  11. Supress Default Primary Key Message
  12. Supress Default Primary Key Message
  13. Question on SELECT TOP 3?
  14. Question on SELECT TOP 3?
  15. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  16. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  17. Print report by filter
  18. Print report by filter
  19. Stop current record from moving to another record
  20. Stop current record from moving to another record
  21. Numbering Labels
  22. Include record related bitmap in report query
  23. Include record related bitmap in report query
  24. Numbering Labels
  25. Module Help!
  26. Module Help!
  27. Lining up columns on subreport with main report
  28. Lining up columns on subreport with main report
  29. Unexplained behavior in Windows 2000 Adv. Server environment
  30. Unexplained behavior in Windows 2000 Adv. Server environment
  31. Self-Referencing tables
  32. Self-Referencing tables
  33. Change the autonumber of a table
  34. Change the autonumber of a table
  35. AccessXP Startup switch /ro
  36. AccessXP Startup switch /ro
  37. MS Access Shell use to call external application with audio
  38. MS Access Shell use to call external application with audio
  39. "Overflow"
  40. "Overflow"
  41. /cmd problem
  42. /cmd problem
  43. Access 97 bogus duplicate records
  44. Access 97 bogus duplicate records
  45. Publish with MS Word problem
  46. Publish with MS Word problem
  47. Jet SP8 installed but still requested
  48. Upsizing MDB to SQL server
  49. Unwanted American date format problem
  50. NETWORK INVENTORY
  51. Refresh/Reconnect to SQL Server
  52. Using UNION of 2 or more saved queries
  53. Run as is it possible ??
  54. Use of "Max" in query grid
  55. IMPORTING QUERIES FROM ANOTHER APP
  56. How to use extracted table with base table?
  57. focus from main form to sub form
  58. turn off warning
  59. form is not allowing me add data
  60. Space at the end of the field
  61. xls MACRO help
  62. Listing all users in a combo box.
  63. Query problem
  64. missing operator in query expression
  65. Customised Dropdown ComboBox
  66. Summing text field containing blanks
  67. Etiquette about reposting a question
  68. newb seeking help with form
  69. Strange corruption problem
  70. looping through toolbars
  71. Simple Update Query
  72. Access 2003 security
  73. Consolidate data in head office
  74. Differences between Access 97 and Access 2000/2003
  75. Setting recordsource for subform
  76. Easter function explanation Part II (long)
  77. Help with Registry Patch
  78. HTML Help
  79. Please Help - Combo Box Question...
  80. "Connection Failure"
  81. MSDE Upgrade question
  82. Add xls Macros to existing Module.
  83. Access Books
  84. basing a form on a RWOP query
  85. Linked Table Manager Macro
  86. Access books
  87. Custom toolbar problem
  88. Do I understand form optimization correctly?
  89. Read only version of a form.
  90. Report Group Footer not displaying the total that I want
  91. Como Box
  92. Application crashes after a call to DaoObject->CommitTrans
  93. generating a seriel of serial no
  94. hide pagefooter
  95. Locally using Access and IIS
  96. Help needed with frustrating menu bar problem.
  97. controling which report to print in VB
  98. Left Join behaving like Inner Join - Access 97
  99. How to use variable to reference rst!Item?
  100. Rolling Average Calculation Problem
  101. SQL error "Arguments are of the wrong type ..."
  102. Copying records
  103. Report Group Section Footer displaying Totals
  104. Upsizing questions
  105. Macros and queries
  106. Getting Totals From Two Different Tables In A Query
  107. Auto Number
  108. Creating new Fields in code
  109. Sequencing Problem using an MS Access Query
  110. Looking for 3rd Party Developers
  111. A97 graphing (x,y) coord's - how to do it?
  112. A97 tables needed containing geodata for USA state boundaries 'n city loc'ns
  113. Rounding Frustration
  114. Focus on tab control instead of first field
  115. archive macro
  116. can Access 2002 or 03 import multiple worksheets?
  117. Tracking Changes in Access
  118. Dynamically Renaming Fields?
  119. Import XML with Attributes
  120. Reading Text Files - Dev
  121. Advice On Random Sample
  122. EVERY "on open" gives "expected end of statement" error-->SOLUTION!
  123. OnDirty only working once
  124. Access database suddenly increased in size
  125. Merging several lists into one, with different field names
  126. how to pad zeros to the left of a field in a table and KEEP them there?
  127. how i connect my comp.databases.ms-access with jsp in tomcat3.3
  128. When will a query run?
  129. Problem with ActiveX
  130. currency format in a textbox
  131. currency format in a textbox
  132. No Current Record
  133. Send Object on WinXP
  134. record-locking?
  135. Using NOW() to display long date in a report
  136. report "too long"
  137. How to make all access to linked table read-only
  138. Variable Pointers
  139. Quick help with extracting a value
  140. Security in Access 2003
  141. How to interrogate through OLEDB for space to be freed by compaction?
  142. Right Clicking a form gives users wrong power
  143. no suitable driver found exception when getting connection with access
  144. Locking controls locks another form up...why?
  145. Access backup software
  146. creating pivot tables in Excel from Access
  147. Problem with Embeded Queries
  148. Workgroup file (system.mdw) problem
  149. Word truncates Memo field when using Automation from Access
  150. Create report in MS-ACCESS
  151. How many subforms can I have in Access 97?
  152. Any resolution for Err 3734 "Database has been placed..."
  153. DCount, by customer
  154. Updating Multiple Access Tables with Single Excel File
  155. How to 'dump' all standard and class module code lines into an Access table
  156. Multiple product classes table design
  157. Time and Attendance Recording
  158. How to set up read-only accessibility to an existing .mdb
  159. AllowByPassKey error
  160. Access Wizards don't see table
  161. Call Function by string
  162. fGetControl (strMyControl) as Control
  163. Multi-column report needs word Continued
  164. Permission problems with Access and SQL
  165. Row handle referred to a deleted row -- error message
  166. Help with totals in access
  167. Tools for record locking
  168. Top 10?
  169. Access 2003 runtime confusions
  170. Form field visibility -
  171. Passing a parameter as a form control (or not!)
  172. Looping through every oject for Application.SaveAsText
  173. SQL asp select syntax help
  174. Application.Name
  175. Unselecting items in a Listbox (HOW?)
  176. I want to examine each procedure in my class modules and standard modules (A97)
  177. Creating Groups and Users
  178. Multi-user, Multi-computer MS-Access.
  179. Distinct problem
  180. Distinct problem
  181. Help. How to enable the confirmation of save on changing table/query?
  182. Using Listboxes to enable multi-select
  183. Combine 2 memo fields and insert a blank line
  184. Automate compact and repair/backup database
  185. Query type for asp page?
  186. Primary Key question
  187. Menu Bar Startup Options via VBA
  188. Bringing up the Expression Builder
  189. AIUTO: Collegamento tabelle MySql ad Access
  190. want to about ms access
  191. Record Locking in Access 2000 DB
  192. Report view
  193. Create dynamic hyperlink in Access 2000
  194. Fried brain by 10am - wierd "fake" hang problem
  195. Multiple criteria on filter
  196. memo field auto-expanding?
  197. Get runtime error "94" with 1st character capitalization script
  198. lock records on edit detection
  199. Awful performance and millions of packets transferred
  200. super quote
  201. ADO parameters queries and stored procedures - and Connections
  202. supporting text fields >255 in Access 2003
  203. RecordsAffected reporting the wrong value
  204. Need advice on table structure and on creating subforms
  205. Mail Merge Problem
  206. Problem with limit on maximum number of textboxes on a form or report in MS-Access
  207. Access, ASP, DATE problems!
  208. Persistent recordset error 91
  209. toolbar diappeared
  210. subform name on control tab weirdness
  211. Running a Database on a USB Flash Drive
  212. curious about command buttons
  213. Search button / form
  214. stumped - 'field too small to accept....' (err number 3163) error only with MDE on production server
  215. Query to XLS
  216. How to Compact a "Table"
  217. Snapshot Viewer on Macs?
  218. multiselect problem
  219. Need help on user input decision for Form
  220. Form Not Painted / Visible !
  221. Larry Linson
  222. Calendar
  223. How to calculate the sum of a colon
  224. Accounting in Access for small businesses
  225. DISTINCT problem in query?
  226. Implementing row-level security (SQL/AD)
  227. mouse scrolling problem
  228. I could use some help with a query using mulitplication
  229. one to many & many to many relationship
  230. Object variable question
  231. Checking a condition to be true over 9 consecutive months
  232. Help....Frustrated with Forms
  233. Navigating main form with subform
  234. Why code unhiding database window in A97 unhides hidden form too?
  235. new record detection
  236. A97: Can't import a text file to an Access 97 table?
  237. A97: Is it a feature or a beature of Access compiling code on the clipboard?
  238. Mail Merge
  239. postgreSQL temporary tables and MS Access
  240. A97: Is there a way to exclude certain modules from being compiled?
  241. A97: Q re ShellWait?
  242. A97: Copying HELP text is flaky.
  243. A97... not important, just curious (2 if's or select case)
  244. Add "All" to Combo Box and Use "All" as Criteria in Query
  245. Further adventures in Jet database compaction
  246. Love the SQL, can't seem to get a combo box to use it...
  247. locking subforms
  248. recordset for reports ?
  249. stopping every acknowledgement
  250. Aggregate two fields
  251. Document Tracker
  252. Access Modules
  253. ADODB connection can't open. Database locked.
  254. Show all record using combo box
  255. avoiding reference problems when distributing apps
  256. Looking through date in SQL
  257. SQL Problem
  258. Control form movement
  259. Parsing out SQL statement
  260. search access table throught webpage helppppppp
  261. Why does A97 show a number like -2147483630 as the ForeColor property of a control?
  262. Seeking alternative for suspending code execution with acDialog parm in A97...
  263. Saving Modules in Access
  264. Access 2003 Reports
  265. SysCmd acSysCmdInitMeter
  266. 2 records per detail in Report
  267. Has anyone ever wished for a fixed version of Access rather than a new and improved version?
  268. A97... SysCmd, what are the 4 possible values and what do they stand for?
  269. Trying to make a form not sure how to do it
  270. A97... If I run Me.Visible = False in a form module, should Unhide be an option under "Window" menubar option?
  271. Automating user changes to database
  272. Application crashes upon trying to commit a transaction
  273. Refresh a Form
  274. how can I open table in mdb access database without running form
  275. How to have filled data in field started with CAPITAL?
  276. Terminal Services
  277. Multiple pastes
  278. formatting listbox
  279. how to move to a specific record after the form is refreshed?
  280. Accessing as lookup column
  281. Filtering data entry in forms
  282. Create tables Using VBA
  283. How to Ask a Question Here
  284. Update Query VERY slow! Please help :(
  285. Database Deployment
  286. How to avoid default "can't save form at this time" message?
  287. references
  288. Properties for a custom class (not a collection)
  289. Help with Access template
  290. Code to Unzip file from Outlook message
  291. An experience in linking Blackboard learning system backend to Access
  292. Releasing Object Variables
  293. calculation with msaccess
  294. external data from internet
  295. access summery reports
  296. Only my form
  297. MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000
  298. An FAQ?
  299. references question
  300. Access 2003 missing the intranet or the website
  301. Active Directory?
  302. flaky events in A97
  303. How do I force MS Access to stay minimized?
  304. ensuring certain code runs when returning to a form...
  305. A2K Record-Level Locking
  306. Select diff value from drop down in subform, it changes all occurences in DB
  307. A97's Activate event - reasons why it does not occur after opening a form?
  308. Adding Multiple Records
  309. TransferText
  310. Why is Me.Hide not a valid statement in A97?
  311. Is Name Autocorrect fixed in Access 2003?
  312. Recreate/Reset Data Behind Form Data
  313. Privileges, Security & Database Design Issues
  314. Stopping/preventing Access from continuing onto another process/action
  315. filter on form with VBA
  316. Grand Total
  317. Access 2003 Corruption
  318. Is this a job for access or SQL?
  319. Riportare un record precedente
  320. Calculating date differences from a table?
  321. Unique Fields
  322. Export Excel file on mapped drive
  323. Record Y of X question
  324. form jumps to the top
  325. Instance of Access hangs
  326. Reference for ADO.net
  327. Advanced Access Security problem
  328. To WITH or not to WITH?
  329. Workgroup MS Access 2003 Windows XP
  330. Running Split Access2000 db on Network
  331. Filter and Index
  332. Recommended data access model
  333. Code To Run WinZip?
  334. Users ADP files suddenly adding DBO extension and not working properly
  335. How to access data from a subform
  336. Text Box With Validation Rule
  337. Does Any One Knows how can i learn this language?
  338. Combo Boxes and Selecting Everything in a Query
  339. Microsoft Outlook 2000 Blocks Access File Attachment
  340. Access Report Control ??
  341. Access Report Control ??
  342. Interesting issue with compaction. Any ideas to eliminate?
  343. Access 2002 Security on multiple workstations
  344. Position a commandbar
  345. SELECT clause and LAST function causing problems
  346. How to set background color in pushed button of Option Group.
  347. How to make in Find Record the Match tool setting "Any Part Of Field" default
  348. Trapping Error 2501
  349. Linked Tables - Identity column needed ?
  350. Help: Is there a line break in Report
  351. Group By with Multiple Fields
  352. Group By with Multiple Fields
  353. Group By with Multiple Fields
  354. Group By with Multiple Fields
  355. How to Populate "To:" field in Outlook with Access query results.
  356. Can't Get Echo To Work
  357. 2003 Developers Edition?
  358. unable to update via form - relationship problem?
  359. Copy records from form as new records
  360. Help: How to prevent moving to the new record when sub form is null?
  361. Inserting Strings into a text box
  362. Access 2003, Question concerning Adobe Acrobat
  363. Getting the results of a report calculation or data field
  364. user defined error
  365. Hiding a Label with a Sub report
  366. Help with query syntax please
  367. format of column heading in crosstab query
  368. Replica-manager: deleting old replicas?
  369. Subform Question
  370. Function vs Sub /Public vs Private
  371. MDE front-end on network share?
  372. Recordset for MS Graph (Chart) through VBA ?
  373. access and postrgresql
  374. Using MSACESS for translations?
  375. date help appreciated
  376. relation 0:1
  377. scroll subform with mouse
  378. Summarize Text
  379. IT Studies
  380. Using any value in multiple columns as query parameters
  381. Combining multiple columns into 1.
  382. Combining multiple columns into 1.
  383. Read this if you dare
  384. Read this if you dare
  385. access 2k print problem
  386. access 2k print problem
  387. Displaying hyperlink contents in reports
  388. Displaying hyperlink contents in reports
  389. fun quotes for the day
  390. fun quotes for the day
  391. Error 3014 and 3518
  392. Error 3014 and 3518
  393. A2K - possible to have fading colour effect on labels or textboxes?
  394. A2K - possible to have fading colour effect on labels or textboxes?
  395. Another joy of ADO
  396. Another joy of ADO
  397. Plesae help with this query
  398. Plesae help with this query
  399. How to refresh data on a MainForm
  400. How to refresh data on a MainForm
  401. Radio button groups are null
  402. Radio button groups are null
  403. F11 doesn't bring back DB window
  404. F11 doesn't bring back DB window
  405. F11 doesn't bring back DB window
  406. F11 doesn't bring back DB window
  407. ADO Question
  408. ADO Question
  409. MultiTable runtime parameter
  410. MultiTable runtime parameter
  411. Help With Table Design
  412. Help With Table Design
  413. Eliminating Blank Rows In Reports
  414. Eliminating Blank Rows In Reports
  415. Subform Question. Please help!
  416. Subform Question. Please help!
  417. Excluding records where two tables have the same id
  418. Excluding records where two tables have the same id
  419. References in Access and VB
  420. References in Access and VB
  421. Accessing Access mdb via ODBC - how to return autonumber
  422. Accessing Access mdb via ODBC - how to return autonumber
  423. Help With Table Lock, Please.
  424. Help With Table Lock, Please.
  425. currency data type
  426. currency data type
  427. syntax error for Update Query
  428. syntax error for Update Query
  429. how to disable the 'next' navigation button to new records on conditions?
  430. how to disable the 'next' navigation button to new records on conditions?
  431. Help. Button: copy value from field, followed by start ext. application.
  432. Help. Button: copy value from field, followed by start ext. application.
  433. I finished the application - - - now what?
  434. I finished the application - - - now what?
  435. Generating Numbers automatically
  436. Generating Numbers automatically
  437. Importing Tables Question
  438. Importing Tables Question
  439. Trouble setting hyperlink string with code
  440. Trouble setting hyperlink string with code
  441. how to specify a common spellcheck dictionary
  442. how to specify a common spellcheck dictionary
  443. OnApply Event doesn't act as documented
  444. OnApply Event doesn't act as documented
  445. The app's been built, now what?
  446. The app's been built, now what?
  447. VERY simple application fails to start
  448. VERY simple application fails to start
  449. J-Integra for COM (Java COM interoperability)
  450. J-Integra for COM (Java COM interoperability)
  451. Help with a C++ library
  452. Microsoft throwing curve balls at Access Developers! ARGH!
  453. OutputTo
  454. OutputTo
  455. Populating One Dropdown based on the Results of Another
  456. multiple users
  457. Exiting A Multi-level Procedure From the Lowest Level
  458. Find duplicate records on two fields
  459. Nav Bar on Form doesn't work
  460. How to renummer ID (now contains holes), even when table is full of records.
  461. making a logfile
  462. Forcing ODBC-Autocommit
  463. Acquiring some sort of unique machine ID?
  464. RecordsetClone only retreives 100 records in ADP
  465. date/time fields to just dates
  466. Time to migrate from Excel to Access?
  467. Queries...any way to disable/lock a column?
  468. FindFirst and query not finding records - date values
  469. 3-year Comparison YTD
  470. SQL required for delete
  471. Tab pages
  472. Strange SP Problem
  473. Conditionnal formating
  474. Table sql in acces is not updatable
  475. Turn off File, Edit, View, etc...Menu
  476. Referencing Forms
  477. Online Form -> Email -> Access database
  478. Maximising a switchboard form when it loads.
  479. Compare query
  480. Compare query
  481. auto delete in windows xp
  482. How to put/edit VB script what hightlight buttons on mousemove?
  483. Corruption of Back End
  484. Button closing database AND exit Access, how?
  485. Why can I only do a record search from two fields and not more?
  486. Replace Subform
  487. Dynamic form possible?
  488. Calulate time between different records
  489. Option Group: Values only nummeric, how to perform for all characters?
  490. Stand Alone Database Application
  491. Can Access 97 emulate Windows Find Command?
  492. How to Date Filter on a Group By Month query
  493. Selecting into a variable
  494. Using EVAL() in a Query with a nested Field Reference
  495. Skip to Next (in a for each next loop) if condition is met
  496. text box dependent on other text box entry
  497. Secure Database Code
  498. 1st character of field Uppercased only with input mask?
  499. How to make button filling in the present date in a data field
  500. VB code that uses recordset logic and split function runs very slow
  501. Monthly Attendance Report
  502. Input mask field is _______: I do not want them visible / mouse cursor not to 1st
  503. Error in Visual Basic closes the database
  504. How should I use NotInList for this application?
  505. Delete table and associated relationships
  506. works at home but not on host servers
  507. crosstab queries formatting question
  508. multiple selection
  509. multiple selection
  510. Variable Field not wanted in Access Queries
  511. Sending email with atachments in Access 2003 (vb)
  512. selecting a subset of choices based on a first choice
  513. I know it can be done now!
  514. Transparent Background on Subform
  515. I was pleased to see a couple of ttf files in my runtime distribution fileset
  516. ADODB and Access Reports
  517. Relationships confusion
  518. Set Recordsource
  519. Pulling info from linked table based on text box entry
  520. A97's 2427 error - Why does it occur when refering to a textbox control?
  521. Making access 2002 fill in the city from a zip code tbl
  522. ADODB Connection String - Prompt for Password?
  523. Another Mail Merge Question
  524. How to put the ID back to 1?
  525. Refresh sub form after entry
  526. Opening Access 2003 dumps copy buffer
  527. Open Form Smaller
  528. Question about mde
  529. Open a form to the position of the mouse
  530. Open a form to the position of the mouse
  531. Forms, Reports align on decimal
  532. unexpected prompt in report
  533. Transform string : "c;b;a;e;d" -> "a;b;c;d;e" ?
  534. Query Problem
  535. How do i create a validation rule in a table
  536. Two or more Access Reports -> a Single Snapshot file
  537. Embarrassed to put this on the forum - but here goes anyway - can't see controls on form
  538. 50 forms later, I forgot to set the form captions...
  539. Dates: Using a query result in another query
  540. Method 'Range' of object '_Global' failed
  541. Multiple sql statements in insert query
  542. Can someone tell me what is wrong with the syntax of this WHERE clause?
  543. Statement works in Access 2000 but not Access 2003
  544. Invalid argument
  545. Need help with building database
  546. Gather information from Excel PivotCache
  547. Question on Dcount -
  548. A97 procedure causes keyboard CTRL key to get stuck. Why?
  549. Excessive Calculations Please Help
  550. Some SQL trouble