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. Is there a way for Access to read CRC from other files?
  2. Synchronizing two forms
  3. Need help displaying photographs
  4. Access Has Broken - Help please
  5. Hide Permanetly the Windows Menu
  6. Working with report wzard
  7. Problems with Form fields using Linked Outlook Contacts Table
  8. Query where used diagram
  9. Should I use a crosstab for this?
  10. Referring to a form control in an update query
  11. How to convert form with vb code to html file?
  12. display one thing in field while allowing something else to be typed
  13. Does Number Contain Decimal Point?
  14. How to query by date?
  15. Search up and search down behave differently when using Find?
  16. A97 Font / Report question
  17. use of Me. gives RunTime error
  18. the first sunday of a month
  19. SENDING FAX
  20. Making same report appear twice on one page
  21. Problem with skv files
  22. Daily normal and overtime rates
  23. A97 How to force uppercase alpha chars in a textbox on a form?
  24. Link to Outlook Address Book
  25. ADO Recordset: Undefined Function 'NZ' in expression
  26. Get status bar text
  27. Can anyone help me turn this into code?
  28. Error Importing Text files. Error #3011
  29. run VBA code in something other than debug mode?
  30. updating bound & unbound controls on a form?
  31. Combo box display problem
  32. Can I set index properties on compound fields?
  33. Opening Access2003 and printing reports problem
  34. Can a query "look" at whats already in 2 table fields before appending a rec w/ redundant values in those two fields?
  35. File name on a form
  36. Out of memory in Access97?
  37. SQL Connections
  38. Trying to calculate a Sum
  39. A97 update all Command Button and Textbox Caption properties?
  40. String Concatenation
  41. Updates from external datasource
  42. Validation Rules
  43. Disabling form when a new form is opened
  44. import field names from fixed width text
  45. UNIQUE FOREIGN KEY Constraint?!?!
  46. autoincrement problem
  47. Split Database Poor Performance
  48. Function to count workdays
  49. Summarizing values for "duplicate" records
  50. Code To Prevent Printing A Subreport
  51. Report with totals only, no details
  52. user function in a query
  53. Authentication Failed Message????????
  54. Problem with linked tables
  55. Identifying Access Databases with tables linked from other Databases/Files
  56. Attach Files to Emails generated in Access VBA
  57. TransferSpreadsheet using a Query
  58. Combo Box to Filter Records in a Continuous Form
  59. Open Form in Ms-Access from a hyperlink by using dhtml control
  60. Table rounds all numbers to whole integers
  61. limit data to textbox
  62. copy data from a selected table to another fixed table
  63. Deleting a field
  64. Setting an autonumber programatically
  65. I can't get the "path" description to work for synchronizing 2 forms
  66. Exporting a Report to Excel
  67. Limiting Database - is this a good idea?
  68. Report Help: Reading Records From Same Field
  69. copy a record
  70. Crystal Reports active x control documentation
  71. adding a memo field programatically
  72. Subform loses recordset - shows #Name?
  73. Parameter Query
  74. API Viewer
  75. Excellent Resource!
  76. that's all we need
  77. printing problems with A97 on XP Pro and A03
  78. DoCmd.Applyfilter
  79. refering to a subform control
  80. Need VBA for file requester please
  81. Subform AfterUpdate goes to first parent record
  82. A97 table design?
  83. wininet vs. ftp script
  84. How to avoid ftping data all the time
  85. Mail Merge
  86. distributed database library
  87. Set Toolbar Combobox items when Toolbar is called?
  88. Access 2k3 Forgetting my code? :(
  89. Global variables are slowing down the query
  90. Connecting to SQL Server
  91. "numeric field overflow" only on linked tables...
  92. MS access coding standards.
  93. Thanks a lot experts!!
  94. Is there OpenArgs for Report?
  95. Formating numbers: I want '9' to be '009' and '19' to be '019'
  96. test
  97. CommandBars in Access 2002/2003
  98. What do the field type numbers returned in the debug window mean?
  99. Data Exporting
  100. Viewing Reports
  101. Limiting the number of records.
  102. Exporting Data
  103. printer settings
  104. Hard return in unbound textbox printing in report
  105. Need archtectural advice. DB server or File server.
  106. How to compact the database in VBA?
  107. Database w/ client access (online) and estimator
  108. How to compact the database in VBA?
  109. tricky problem :-) - self references & direction
  110. FTP with the WinInet dll.
  111. Database linking
  112. Losing Import Specifications - Access 2002
  113. database linking
  114. Database linking
  115. Simultaneous Insert
  116. query on different tables
  117. Plotting Data
  118. Access 2003 cannot print help please
  119. Retrieving Autonumber
  120. form speed up
  121. Combo Box Rowsource set at GotFocus
  122. Access/VBA Conditional Statement
  123. Access/VBA Conditional Statement
  124. update record event
  125. How to delete all the records in a table in VBA?
  126. Query Error Message
  127. Open Shortcut Menu from VBA?
  128. SQL select records NOT in both tables
  129. Auto quit database after inactive period?
  130. Filter on/off toggle
  131. How to emulate the action caused by 'Esc' button is VBA?
  132. Linked table manager
  133. Where is the daily post of our charter?
  134. Schema set up issue
  135. Performance with combined key in junction table
  136. Is there a way to change screen resolution in VBA
  137. Backing up an entire db
  138. Bisarre join problem.
  139. Adobe GoLive 5.0
  140. Insert string (insert without duplicates???)
  141. Insert string (insert without duplicates???)
  142. Temporary tables in A2K/ADO
  143. Temporary tables in A2K/ADO
  144. DataBase linking
  145. DataBase linking
  146. Question about creating replica
  147. Question about creating replica
  148. ADH 2002 FormResize
  149. ADH 2002 FormResize
  150. Repost: Connecting a table to itself?
  151. Repost: Connecting a table to itself?
  152. Query: Count (amount of (xDates later than GivenDate))
  153. Query: Count (amount of (xDates later than GivenDate))
  154. Access Bug with SQL Server identity columns
  155. Access Bug with SQL Server identity columns
  156. How to add a blank entry in a Query based combobox?
  157. How to add a blank entry in a Query based combobox?
  158. How to use the criteria on a calculated field?
  159. How to use the criteria on a calculated field?
  160. Advice for an Online Calendar
  161. Advice for an Online Calendar
  162. OLE Linking to Word?
  163. OLE Linking to Word?
  164. Highlighting Records
  165. Highlighting Records
  166. References, Sub forms, Picture boxes, Bald spots
  167. References, Sub forms, Picture boxes, Bald spots
  168. Go Back to the previous FORM
  169. Go Back to the previous FORM
  170. Select/Update Query
  171. Select/Update Query
  172. Showing all records in a table in the details section of a form
  173. Showing all records in a table in the details section of a form
  174. Troubles with Threads and Suns jdbc-odbc Bridge Driver?
  175. Troubles with Threads and Suns jdbc-odbc Bridge Driver?
  176. Embedded Excel Chart
  177. Embedded Excel Chart
  178. Access 2000 Menu customization
  179. Access 2000 Menu customization
  180. Access Loses my Forms and Reports
  181. Access Loses my Forms and Reports
  182. Subdatasheets. subforms and record selection
  183. Subdatasheets. subforms and record selection
  184. Subdatasheets. subforms and record selection
  185. Subdatasheets. subforms and record selection
  186. Access won't commit (to SQL Server linked table)
  187. Access won't commit (to SQL Server linked table)
  188. Invalid Dates
  189. Invalid Dates
  190. Change Datasource of embedded Excel Unbound Object Frame
  191. Change Datasource of embedded Excel Unbound Object Frame
  192. Need Ideas For Layout Of Form
  193. Need Ideas For Layout Of Form
  194. scrolling control source...any way to fix or disable this ?????
  195. scrolling control source...any way to fix or disable this ?????
  196. Forcing a Form View
  197. Forcing a Form View
  198. If Statement
  199. If Statement
  200. A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
  201. A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
  202. Access2003 Crashes when Filtering
  203. Access2003 Crashes when Filtering
  204. How to find out if a form exists?
  205. How to find out if a form exists?
  206. Error Handling
  207. Error Handling
  208. Capatalise the first letter of every word
  209. Capatalise the first letter of every word
  210. TabControl in .net
  211. TabControl in .net
  212. Recursive File Search VBA vs VB
  213. Recursive File Search VBA vs VB
  214. Database size increase
  215. Database size increase
  216. Supress Default Primary Key Message
  217. Supress Default Primary Key Message
  218. Question on SELECT TOP 3?
  219. Question on SELECT TOP 3?
  220. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  221. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  222. Print report by filter
  223. Print report by filter
  224. Stop current record from moving to another record
  225. Stop current record from moving to another record
  226. Numbering Labels
  227. Include record related bitmap in report query
  228. Include record related bitmap in report query
  229. Numbering Labels
  230. Module Help!
  231. Module Help!
  232. Lining up columns on subreport with main report
  233. Lining up columns on subreport with main report
  234. Unexplained behavior in Windows 2000 Adv. Server environment
  235. Unexplained behavior in Windows 2000 Adv. Server environment
  236. Self-Referencing tables
  237. Self-Referencing tables
  238. Change the autonumber of a table
  239. Change the autonumber of a table
  240. AccessXP Startup switch /ro
  241. AccessXP Startup switch /ro
  242. MS Access Shell use to call external application with audio
  243. MS Access Shell use to call external application with audio
  244. "Overflow"
  245. "Overflow"
  246. /cmd problem
  247. /cmd problem
  248. Access 97 bogus duplicate records
  249. Access 97 bogus duplicate records
  250. Publish with MS Word problem
  251. Publish with MS Word problem
  252. Jet SP8 installed but still requested
  253. Upsizing MDB to SQL server
  254. Unwanted American date format problem
  255. NETWORK INVENTORY
  256. Refresh/Reconnect to SQL Server
  257. Using UNION of 2 or more saved queries
  258. Run as is it possible ??
  259. Use of "Max" in query grid
  260. IMPORTING QUERIES FROM ANOTHER APP
  261. How to use extracted table with base table?
  262. focus from main form to sub form
  263. turn off warning
  264. form is not allowing me add data
  265. Space at the end of the field
  266. xls MACRO help
  267. Listing all users in a combo box.
  268. Query problem
  269. missing operator in query expression
  270. Customised Dropdown ComboBox
  271. Summing text field containing blanks
  272. Etiquette about reposting a question
  273. newb seeking help with form
  274. Strange corruption problem
  275. looping through toolbars
  276. Simple Update Query
  277. Access 2003 security
  278. Consolidate data in head office
  279. Differences between Access 97 and Access 2000/2003
  280. Setting recordsource for subform
  281. Easter function explanation Part II (long)
  282. Help with Registry Patch
  283. HTML Help
  284. Please Help - Combo Box Question...
  285. "Connection Failure"
  286. MSDE Upgrade question
  287. Add xls Macros to existing Module.
  288. Access Books
  289. basing a form on a RWOP query
  290. Linked Table Manager Macro
  291. Access books
  292. Custom toolbar problem
  293. Do I understand form optimization correctly?
  294. Read only version of a form.
  295. Report Group Footer not displaying the total that I want
  296. Como Box
  297. Application crashes after a call to DaoObject->CommitTrans
  298. generating a seriel of serial no
  299. hide pagefooter
  300. Locally using Access and IIS
  301. Help needed with frustrating menu bar problem.
  302. controling which report to print in VB
  303. Left Join behaving like Inner Join - Access 97
  304. How to use variable to reference rst!Item?
  305. Rolling Average Calculation Problem
  306. SQL error "Arguments are of the wrong type ..."
  307. Copying records
  308. Report Group Section Footer displaying Totals
  309. Upsizing questions
  310. Macros and queries
  311. Getting Totals From Two Different Tables In A Query
  312. Auto Number
  313. Creating new Fields in code
  314. Sequencing Problem using an MS Access Query
  315. Looking for 3rd Party Developers
  316. A97 graphing (x,y) coord's - how to do it?
  317. A97 tables needed containing geodata for USA state boundaries 'n city loc'ns
  318. Rounding Frustration
  319. Focus on tab control instead of first field
  320. archive macro
  321. can Access 2002 or 03 import multiple worksheets?
  322. Tracking Changes in Access
  323. Dynamically Renaming Fields?
  324. Import XML with Attributes
  325. Reading Text Files - Dev
  326. Advice On Random Sample
  327. EVERY "on open" gives "expected end of statement" error-->SOLUTION!
  328. OnDirty only working once
  329. Access database suddenly increased in size
  330. Merging several lists into one, with different field names
  331. how to pad zeros to the left of a field in a table and KEEP them there?
  332. how i connect my comp.databases.ms-access with jsp in tomcat3.3
  333. When will a query run?
  334. Problem with ActiveX
  335. currency format in a textbox
  336. currency format in a textbox
  337. No Current Record
  338. Send Object on WinXP
  339. record-locking?
  340. Using NOW() to display long date in a report
  341. report "too long"
  342. How to make all access to linked table read-only
  343. Variable Pointers
  344. Quick help with extracting a value
  345. Security in Access 2003
  346. How to interrogate through OLEDB for space to be freed by compaction?
  347. Right Clicking a form gives users wrong power
  348. no suitable driver found exception when getting connection with access
  349. Locking controls locks another form up...why?
  350. Access backup software
  351. creating pivot tables in Excel from Access
  352. Problem with Embeded Queries
  353. Workgroup file (system.mdw) problem
  354. Word truncates Memo field when using Automation from Access
  355. Create report in MS-ACCESS
  356. How many subforms can I have in Access 97?
  357. Any resolution for Err 3734 "Database has been placed..."
  358. DCount, by customer
  359. Updating Multiple Access Tables with Single Excel File
  360. How to 'dump' all standard and class module code lines into an Access table
  361. Multiple product classes table design
  362. Time and Attendance Recording
  363. How to set up read-only accessibility to an existing .mdb
  364. AllowByPassKey error
  365. Access Wizards don't see table
  366. Call Function by string
  367. fGetControl (strMyControl) as Control
  368. Multi-column report needs word Continued
  369. Permission problems with Access and SQL
  370. Row handle referred to a deleted row -- error message
  371. Help with totals in access
  372. Tools for record locking
  373. Top 10?
  374. Access 2003 runtime confusions
  375. Form field visibility -
  376. Passing a parameter as a form control (or not!)
  377. Looping through every oject for Application.SaveAsText
  378. SQL asp select syntax help
  379. Application.Name
  380. Unselecting items in a Listbox (HOW?)
  381. I want to examine each procedure in my class modules and standard modules (A97)
  382. Creating Groups and Users
  383. Multi-user, Multi-computer MS-Access.
  384. Distinct problem
  385. Distinct problem
  386. Help. How to enable the confirmation of save on changing table/query?
  387. Using Listboxes to enable multi-select
  388. Combine 2 memo fields and insert a blank line
  389. Automate compact and repair/backup database
  390. Query type for asp page?
  391. Primary Key question
  392. Menu Bar Startup Options via VBA
  393. Bringing up the Expression Builder
  394. AIUTO: Collegamento tabelle MySql ad Access
  395. want to about ms access
  396. Record Locking in Access 2000 DB
  397. Report view
  398. Create dynamic hyperlink in Access 2000
  399. Fried brain by 10am - wierd "fake" hang problem
  400. Multiple criteria on filter
  401. memo field auto-expanding?
  402. Get runtime error "94" with 1st character capitalization script
  403. lock records on edit detection
  404. Awful performance and millions of packets transferred
  405. super quote
  406. ADO parameters queries and stored procedures - and Connections
  407. supporting text fields >255 in Access 2003
  408. RecordsAffected reporting the wrong value
  409. Need advice on table structure and on creating subforms
  410. Mail Merge Problem
  411. Problem with limit on maximum number of textboxes on a form or report in MS-Access
  412. Access, ASP, DATE problems!
  413. Persistent recordset error 91
  414. toolbar diappeared
  415. subform name on control tab weirdness
  416. Running a Database on a USB Flash Drive
  417. curious about command buttons
  418. Search button / form
  419. stumped - 'field too small to accept....' (err number 3163) error only with MDE on production server
  420. Query to XLS
  421. How to Compact a "Table"
  422. Snapshot Viewer on Macs?
  423. multiselect problem
  424. Need help on user input decision for Form
  425. Form Not Painted / Visible !
  426. Larry Linson
  427. Calendar
  428. How to calculate the sum of a colon
  429. Accounting in Access for small businesses
  430. DISTINCT problem in query?
  431. Implementing row-level security (SQL/AD)
  432. mouse scrolling problem
  433. I could use some help with a query using mulitplication
  434. one to many & many to many relationship
  435. Object variable question
  436. Checking a condition to be true over 9 consecutive months
  437. Help....Frustrated with Forms
  438. Navigating main form with subform
  439. Why code unhiding database window in A97 unhides hidden form too?
  440. new record detection
  441. A97: Can't import a text file to an Access 97 table?
  442. A97: Is it a feature or a beature of Access compiling code on the clipboard?
  443. Mail Merge
  444. postgreSQL temporary tables and MS Access
  445. A97: Is there a way to exclude certain modules from being compiled?
  446. A97: Q re ShellWait?
  447. A97: Copying HELP text is flaky.
  448. A97... not important, just curious (2 if's or select case)
  449. Add "All" to Combo Box and Use "All" as Criteria in Query
  450. Further adventures in Jet database compaction
  451. Love the SQL, can't seem to get a combo box to use it...
  452. locking subforms
  453. recordset for reports ?
  454. stopping every acknowledgement
  455. Aggregate two fields
  456. Document Tracker
  457. Access Modules
  458. ADODB connection can't open. Database locked.
  459. Show all record using combo box
  460. avoiding reference problems when distributing apps
  461. Looking through date in SQL
  462. SQL Problem
  463. Control form movement
  464. Parsing out SQL statement
  465. search access table throught webpage helppppppp
  466. Why does A97 show a number like -2147483630 as the ForeColor property of a control?
  467. Seeking alternative for suspending code execution with acDialog parm in A97...
  468. Saving Modules in Access
  469. Access 2003 Reports
  470. SysCmd acSysCmdInitMeter
  471. 2 records per detail in Report
  472. Has anyone ever wished for a fixed version of Access rather than a new and improved version?
  473. A97... SysCmd, what are the 4 possible values and what do they stand for?
  474. Trying to make a form not sure how to do it
  475. A97... If I run Me.Visible = False in a form module, should Unhide be an option under "Window" menubar option?
  476. Automating user changes to database
  477. Application crashes upon trying to commit a transaction
  478. Refresh a Form
  479. how can I open table in mdb access database without running form
  480. How to have filled data in field started with CAPITAL?
  481. Terminal Services
  482. Multiple pastes
  483. formatting listbox
  484. how to move to a specific record after the form is refreshed?
  485. Accessing as lookup column
  486. Filtering data entry in forms
  487. Create tables Using VBA
  488. How to Ask a Question Here
  489. Update Query VERY slow! Please help :(
  490. Database Deployment
  491. How to avoid default "can't save form at this time" message?
  492. references
  493. Properties for a custom class (not a collection)
  494. Help with Access template
  495. Code to Unzip file from Outlook message
  496. An experience in linking Blackboard learning system backend to Access
  497. Releasing Object Variables
  498. calculation with msaccess
  499. external data from internet
  500. access summery reports
  501. Only my form
  502. MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000
  503. An FAQ?
  504. references question
  505. Access 2003 missing the intranet or the website
  506. Active Directory?
  507. flaky events in A97
  508. How do I force MS Access to stay minimized?
  509. ensuring certain code runs when returning to a form...
  510. A2K Record-Level Locking
  511. Select diff value from drop down in subform, it changes all occurences in DB
  512. A97's Activate event - reasons why it does not occur after opening a form?
  513. Adding Multiple Records
  514. TransferText
  515. Why is Me.Hide not a valid statement in A97?
  516. Is Name Autocorrect fixed in Access 2003?
  517. Recreate/Reset Data Behind Form Data
  518. Privileges, Security & Database Design Issues
  519. Stopping/preventing Access from continuing onto another process/action
  520. filter on form with VBA
  521. Grand Total
  522. Access 2003 Corruption
  523. Is this a job for access or SQL?
  524. Riportare un record precedente
  525. Calculating date differences from a table?
  526. Unique Fields
  527. Export Excel file on mapped drive
  528. Record Y of X question
  529. form jumps to the top
  530. Instance of Access hangs
  531. Reference for ADO.net
  532. Advanced Access Security problem
  533. To WITH or not to WITH?
  534. Workgroup MS Access 2003 Windows XP
  535. Running Split Access2000 db on Network
  536. Filter and Index
  537. Recommended data access model
  538. Code To Run WinZip?
  539. Users ADP files suddenly adding DBO extension and not working properly
  540. How to access data from a subform
  541. Text Box With Validation Rule
  542. Does Any One Knows how can i learn this language?
  543. Combo Boxes and Selecting Everything in a Query
  544. Microsoft Outlook 2000 Blocks Access File Attachment
  545. Access Report Control ??
  546. Access Report Control ??
  547. Interesting issue with compaction. Any ideas to eliminate?
  548. Access 2002 Security on multiple workstations
  549. Position a commandbar
  550. SELECT clause and LAST function causing problems