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