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. A97 - what would you do 99 times out of a hundred?
  2. MS-Access 2003 & SQL Server
  3. Access 2000 Disable Close and Minimize Buttons
  4. Table names in combo box
  5. Looking to have one field based on two other fields.
  6. Client/server tip - inconsistent collation order betw. Access & Server
  7. Copy all objects to another db
  8. Counting records returned in a combo-box on a form
  9. 'create table' not coping with /
  10. A97: Might I need to set reference to Find and Replace 8.0?
  11. Installing an OCX or adding an mdb using references other than the BASIC-3
  12. How to open a protected access file and shorcut keys
  13. Error Handling : Is it possible to raise the culprit record & field ?
  14. Postcard
  15. Opening another Access application from an Access ap;ication
  16. Excel Link - Can no longer update - Legal issues
  17. summary by date range
  18. Date Conversion
  19. Type Mismatch Error
  20. Access 97 References
  21. O.T. - How to print msconfig STARTUP list?
  22. copy relationships
  23. A97: problem with Set rst = dbs.OpenRecordset("tblMyTable", dbOpenTable)
  24. class module & continuous forms
  25. Need help with Input Mask
  26. References to ado210.chm keep popping up since yesterday... can't shake it.
  27. MS Office Access 2003 (simple forms)
  28. Problems in calculations in MS Access 2003
  29. A97: Dim dbs As Database yields error "user-defined type not defined"
  30. Error 2465 with Year Function
  31. changes in the subform
  32. Exporting query results to excel max 255 characters
  33. Disable the close buttons
  34. Setting Macro Security using VBA
  35. Access skipping parameter input box
  36. problems in speed
  37. Append records from a set to another table.
  38. text Box Exit event
  39. Begin writing from the right....
  40. ms access project 2003
  41. Form controls have vanished...researched to no avail!
  42. Access 2003 Listbox scrollbar -- won't appear
  43. Using IN operator with LIKE operator
  44. Dates: Just MM-YYYY?
  45. MsgBox,InputBox formatting
  46. Allow users without Access 97 ability to view data and search data in tables.
  47. Convert Access 2003 Report to Acrobat 7.0
  48. Alpha-> Numeric conversion????
  49. Normalization Question
  50. Problem closing form
  51. Email With attachment woes
  52. Non-programmer needs help with VB code to locate file on hard drive
  53. Reports-Twist to Running Totals - How?
  54. Error 3075
  55. Datasheet view questions
  56. Weird Report Problem - Access 2003
  57. How can I update forms and tables in a shared Access database?
  58. Median Query
  59. query works in querybuilder, not in VB
  60. show only last item per ID
  61. Printing reports from different trays without locking the db in design mode
  62. Trigger e-mail when new data entered in table
  63. Restrict a toggle button to a single click
  64. Can't convert to MDE after adding refresh links functions
  65. Update form formatting on FLY?
  66. rename control in the subform
  67. percetage calcultion from table
  68. Synchronising access and sql server
  69. Check it Out!
  70. Query to select just one product or all products
  71. Query
  72. Nz(variant[, valueifnull]) - Just thought of this 2 minutes ago, wondering if anyone else has ever considered. it...
  73. Just changed to Access 2003
  74. Data mapping with a DAO.Recordset?
  75. Unable to Delete a Record
  76. Age Calculation in the future
  77. A97: Set dbs = CurrentDb Set rst = dbs.OpenRecordset(MySQL) 2nd line yields error "Too few parms"
  78. Query in vba
  79. Invalid use of NULL
  80. lil help for incoming bithday
  81. trap hyperlink error
  82. cascading combo-boxes and data structure
  83. Membership & attendance db - table structure?
  84. Can I link to an mdb in a Web Folder?
  85. need help in this query
  86. Find the first date from other table
  87. Difficult Query ?!
  88. Using the Office file selector common dialog exposed by Access
  89. checking data in one table before updating another
  90. checking data in one table before updating another
  91. COM s'ware that isn't working for me
  92. Statistical add-in for Access
  93. Select Case vs. ElseIf
  94. When is NOTHING better than nothing?
  95. A97 - always necessary to encapsulate ampersands in spaces?
  96. need help
  97. TypeOf and Date Time Picker control
  98. Please, help I need expression
  99. To Larry Linson, please help
  100. I need expression, please ( MS Access )
  101. Please, help! MS Access
  102. cant get recordcount property to work
  103. RecordSource OnOpen
  104. Terminal Server Question - Passing Parameters
  105. DoCmd.RunSQL can execute code in VBA module?
  106. I have ODE - A97 flavor and a complete set of the tools that came with it
  107. Master link to more than one child
  108. Menu Bar
  109. Send report to Excel
  110. Protect Back-End Tables in Desktop Db - How?
  111. Taste beim öffnen eines Formulars abfragen
  112. A97 dialing numbers via writing directly to the COM port
  113. Set ExpiredTime on KeyDown
  114. emulation of MS Access on Linux ?
  115. Store MS Access Modules in Visual Studio?
  116. Unsatisfying syntax
  117. Exporting without carriage returns in memos
  118. More Specific Access Performance Questions
  119. Order by dlookup in query
  120. large recordset - error -2147217887 (80040e21)
  121. Loop for importing text files
  122. Form Help---Weekday
  123. OLAP Cubes
  124. Problem with ListCount
  125. Count of the selected items
  126. DAO 3035 error, update problem under Windows XP x64; "system resource exceeded"
  127. Simulate slow bandwidth WAN
  128. Call form's event from a library database: is it possible?
  129. Normal Distribution Table and Graph
  130. ADO Copy Table to new MDB Help!
  131. Version Compatibility?
  132. dynamically set a textbox control form...apostrophe gets in the way
  133. Can Access create folders?
  134. Backwards compatibility
  135. Prevent Duplicate records based on multiple fields
  136. Keyboard move after enter
  137. Permissions
  138. Permissions
  139. Runtime problem
  140. a2k - clash of beforeUpdate event and changing tabs on a subform
  141. TransferText and Runtime Error 3011 (solved)
  142. Help! Access 2000 modules disappeared but still there?!?!?!?!
  143. Exporting a report to Excel, some data is wrong
  144. Master database
  145. Disable mouse scroll in subform
  146. SetFocus to a form
  147. Checkboxes and Option Groups
  148. move a file (document) from an unbound object frame to a folder
  149. X but no move/close in Access form
  150. Clear a text box after event cancelled.
  151. Automatically create new record to related table on update
  152. Programming for all fields in a table
  153. Customizing form's Control Box
  154. Form Slow, Then Fast
  155. What techniques are key to Access performance with separate front-endand back-end Access implementation via a LAN?
  156. Hyperlink Field in ASP
  157. Query for List Box - WHERE Clause
  158. DataBase over WAN: ASP vs. Terminal Server Costs?
  159. what I am doing wrong in this query
  160. Unwanted hilight of text
  161. delete all related records from other tables too
  162. change value when other textbox's value changes
  163. Procedure Attributes
  164. Simulating rollover effects
  165. mouse scroller not working in Visual Basic window! my fault?
  166. Determine Windows XP Style or Windows Classic Style
  167. Connecting Access MDBs to SQL databases
  168. Working with Sliders and Ratios
  169. THANK YOU
  170. Help with combo box
  171. Launching MS/Word from VBA
  172. Function to calculate number of days in a month
  173. how to set focus
  174. on delete add qtyOnHand again in product table
  175. form closing
  176. groupby in query and then pass to expression as recordset..IS THIS POSSIBLE?
  177. Correct datetime syntax for MSSQL?
  178. How to Prevent Table Updates in a Form
  179. Toolbox is ignoring me
  180. Importing multiple Excel workbooks from Access
  181. MS Access Report to PDF
  182. Create a recordset based on another recordset
  183. Merging Records
  184. Docmd.openreport
  185. Sort of a mail merge question
  186. apiSHFileOperation preventing Folder deletion
  187. Linking to record in an outlook message
  188. subform recordsearch don't work
  189. Opening MSWord
  190. Using OutputTo command with NoData Report event
  191. Exporting memo columns to separate files
  192. Running windows functions without using OCX ?
  193. Data being lost?
  194. Eric Rucker hints that Sharepoint is driving Access/Jet features?
  195. convert rows to columns
  196. automate from-fiels in outlook
  197. Backup solution created using Access dB
  198. Importing nested XML structures into Access 2000
  199. Using a field from a previos record for a calc
  200. Using a field from a previos record for a calc
  201. Bind a Subform to a Query
  202. Order of Update Query?
  203. Help with SQL
  204. TreeView
  205. Showing decimals in Access pivot table
  206. crosstab quey fails in case of table.field syntax is used in subquery
  207. Updating textbox control on form from code won't reflect new value
  208. Problem getting new record from subform to appear on subreport
  209. Combo and text box
  210. Help me in this report
  211. Jet and MySQL
  212. Access Date Hell
  213. HIDING AN IMAGE BASED ON COMBO BOX VALUE
  214. User Deleted Secured.mdw - now what do I do?
  215. Get Query Parameters from Report's RecordSource?
  216. Compact on Close + mda or mde reference = CRASH
  217. Problems Querying Max Values From 2 Tables
  218. Time to go from Access 97 to Access 2003
  219. More Function Joy
  220. Help with understanding order of For Each Control
  221. Access 2002 corruption
  222. I want a msgbox to display BIG and LITTLE instead of YES and NO
  223. a2k - properties dialog not appearing anymore, for anything!
  224. I have a 2-field table I want to trim strings off of one of the fields...
  225. Multiple Functions
  226. How To Use The Len Function To Count A Space
  227. Transfertext with ADO Recordset created in Runtime
  228. MS Access ODBC -- Connect failed!!
  229. Help - need Cross Tab to Sum AND Count
  230. ahtCommonFileOpenSave Shortcut extensions lnk url
  231. Will this SQL work to find records with hard returns in one of the text fields?
  232. waring message
  233. Does Access have a mind of its own?
  234. Surveying out to the field
  235. Relationship between "Me!" and "The control or subform control is too large for this location"
  236. Starting a form maximized
  237. Sort a month
  238. Access 2002 Packaging Problem
  239. How to create a multiple column unique constraint
  240. Change Linked Table links on run time?
  241. Check for Multiple Instance not working in Access 2003
  242. Check for Multiple Instance not working in Access 2003
  243. Composite Primary Key
  244. Access 2002 - Datei umbenennen
  245. SQL Update
  246. "Order by" in my own order
  247. Text in toolbar text field not committed before clicking toolbar command button
  248. Duplicate Name Alert
  249. Deploying Data Access Pages (DAPs) via RDS in 3-tier environment
  250. I'm confused about encryption
  251. Can I prevent the loss of the values assigned to global variables after an untrapped run-time error?
  252. Fast opening form
  253. I don't know how Resume Next is configured to work
  254. Report question
  255. I don't understand the answer! Doh!
  256. Freeze the MS Access window size
  257. Call printer by name via code
  258. can an update query do different values
  259. MS Access, Oracle 9i, security, and pass-thru update queries
  260. Wouldnit be nice if the new version of Access.....
  261. Browse your gothic lovers' photos and chat with them online!
  262. How to stop timeout message box appearing
  263. email selected contacts from access
  264. Browse your gothic lovers' photos and chat with them online!
  265. columns header and joins
  266. The wisdom of a access-MVP please !
  267. extremely long directory paths
  268. VB Scripts in Access Tables
  269. Where can I get a VBA code diagramer!
  270. Not so Much a Question!!
  271. Testing against a blank field
  272. Any good Form Resizing code?
  273. how to format xml/xls web report for specific paper size and orientation?"
  274. Custom Macros
  275. Web based Access Applications
  276. here
  277. IsNull runTime: Invalid Use of Null
  278. visual basic combo boxes??
  279. Can I export the ReportML with a report to xml doc on web site?
  280. form/subform and calculated control
  281. Data Access Pages DAPs
  282. Find - Search - Match: Any Part of Field
  283. SQL group by with delimiter
  284. adding mailto automatically after email address inputed
  285. Query Help for Inventory Tracking
  286. Trying to create an email with form data.
  287. value on the base of 2 textboxes
  288. Syntax
  289. Exported date format is changed by Excel
  290. Import New Data File - Archive Now Old Data File
  291. Hide Access Close buton but show Min/Max
  292. Hide Access Close buton but show Min/Max
  293. Set all objects in a form to invisible.
  294. Creating a query using a variable field name
  295. HTML and XML
  296. Turn Error Handler back on.
  297. General Approach to Updating Via Forms
  298. Help with Cross tab query
  299. Access and Office 12 ?
  300. TS experts - help me out here
  301. HELP! Having trouble with Workspace
  302. link tables and remote connections to access
  303. Can I perform a DCount of records returned by SQL statement (not a saved query)
  304. Sample DB
  305. Can someone tell me how data entry to a specific site might be accomplished
  306. Update query with select statement
  307. Make Table Un-editable
  308. Find the differences
  309. Simple Query
  310. databases.ms-access ....soft download
  311. fnd matches
  312. A97 columnar (and tabular) form wizard are not placing all fields on the new form
  313. Form opening/switching bug
  314. Creating UniquePrimary key in table
  315. A97 runtime error 29013?
  316. Building Access Tables from SQL server
  317. Force Data Entry In Combobox First
  318. About rept footer
  319. How to display multiply records in query?
  320. Accidently opening 2 instances of A97 and opening the same database...
  321. Back End Update
  322. Problem with IIf statement in the OR clause
  323. Access Report Group Header Question
  324. special duplicate query
  325. Can not use find and replace right now
  326. VB query from a DAP button
  327. Concatenating strings
  328. Combo boxes that delete
  329. Publish Access Data / Forms - Intranet
  330. Data disappearing - without apparent cause
  331. #NAME? displaying in linked tables (Access 2000) after DB2 migration.
  332. Seeking A97 code snippet to programatically delete table field decriptions
  333. DAO Rs Update with SQL ODBC linked table
  334. shortcut to open mdb read-only
  335. append combobox values
  336. Restricting A97 form to editing only?
  337. Ever experienced loss of ability to 'grab' the slide control at the bottom of your A97 database window?
  338. A97 trying to set shortcutmenu=false for all forms
  339. Select lowest number from multiple rows in SQL
  340. Booting users out of Access?
  341. Standard value for a field?
  342. Access awake after 7 years?
  343. compare 2 fields, return w/ nonmatching values
  344. Help Needed With How To Stop User Resizing Form
  345. Comboboxes and record deletion
  346. MS Access 2000 Password Recoverer
  347. How To: Use a field value from a table to call a function
  348. Execute function at db startup - how?
  349. Reading XML file by VBA code and saving the tag-value combination in a table
  350. transfertext acimportdelim/acexportdelim problem with field names
  351. Execute a function at database startup ... how?
  352. Saving Text Editor Color choices
  353. dynamic param for WHERE ...IN ( @param )
  354. compare two strings - - - for the guru's
  355. Preserving wordwrap in MS Word (rtf) exports
  356. Exporting with text qualifiers - number data
  357. Double Quotes In Data?
  358. joining tables
  359. 2003 not saving VBA coding
  360. How to fix subreport?
  361. Adding a character to a Combo Box value
  362. Going through the field list !
  363. Check if Microsoft Outlook is installed as default mail cleint
  364. help - can't create file
  365. Access Still Sees QueryDef Deleted During a Session?
  366. Reference a Text Box from another Form displayed on a Tab Control
  367. displaying the right side of a text field
  368. DoCmd.TransferText to import text from a large text file
  369. Add Fields to a Split Database Table
  370. Record locking on Terminal Services
  371. Access2K vs 2003
  372. Increment a table field value by 1 - SQL fails to do so
  373. IsUserAnAdmin not working
  374. exporting results of a query to a new table
  375. How many fields in a table
  376. removing rows that meet certain aggregate criteria
  377. Trying to paste sub procedure into A97 global module - code lines show up red
  378. MAPI / A97 question...
  379. Please help with this code
  380. References- How to get rid of them!
  381. Format Data Access Page
  382. Clear Button to Ignore Alerts
  383. Need HELP / Increment ID (number) for each unique text string
  384. Exporting Access -> Excel
  385. sending email with multiple records
  386. Antsoft Best domain software
  387. ListBox Not Showing Rows?
  388. Splitting an Access db - the next step
  389. import doubt?
  390. merge two tables problem
  391. Toggle button on the toolbar
  392. Truncating a Field
  393. Gantt Chart
  394. Getting max length
  395. Date Criteria Problem
  396. inserting email address into a form
  397. How to keep a selected item in a list highlighted
  398. Paste from clipboard to report
  399. Mail Merge and save individual documents
  400. Form in chart view
  401. How to add 2 text boxes if one one them have no value
  402. Security: some default system.mdw files can get into the app without prompt
  403. Cannot open anymore databases
  404. Combo box
  405. How can I input the same data many times in a form
  406. Excel stays in RAM after DoCmd.TransferSpreadsheet
  407. Linked Listboxes
  408. Regarding saving database objects as text files and importing them...
  409. MS Access-Show Occurence Count
  410. Relationship Link
  411. Simple math
  412. Suppress line feed in detail section of report
  413. problem with setbar function
  414. Database bloat - general discussion...
  415. Qry Deleted after running macro.
  416. User-Sequencable List Control?
  417. Mundane A97 Workgroup Administrator question
  418. How many modules is too many?
  419. Loading Various Image Types into Image Controls
  420. Display a series of records with mixed forms
  421. Update of field list PivotTable or PivotChart (Data Access Pages)
  422. Export to Excel and open the worksheet
  423. Tarpping changes to a field
  424. Flicker
  425. How to prevent to enter duplicate record?
  426. Unbound text box, text>255, MS Access/PostgreSQL
  427. #error in form footer sum
  428. update from using ms access query
  429. Used SQL Upsizing Wizard, Application No Longer Runs
  430. Or in the Of clause
  431. Need help with connection string in OpenDatabase
  432. Jet 4 Replication Service Pack
  433. combo / form help please
  434. linking tables to different databases
  435. Help with schema.ini file
  436. Need to change LASTNAME, FIRSTNAME MI to FirstName M. LastName
  437. How to establish connection to TCP port 13 on a remote server from within VBA?
  438. Again...problems with date settings in IsDate function
  439. Best practices for canceling out of a report?
  440. A97: I want a simple text capture on a website (IE, Edit, Select All, CTRL-C)
  441. Oracle Automated Login via MS Access
  442. Walk Multi Select List Box A2003
  443. saving database to winzip file
  444. Help~
  445. Refreshing Page
  446. How can i make a fiels reset on every date change,and auto increasing?
  447. Scheduling beer trucks into timeslots with sufficient performance
  448. How can i make a fiels reset on every date change,and auto increasing?
  449. New record from a join query
  450. Data Access Page?
  451. How best to set current system date/time in A97?
  452. source of CURRENT event for subform?
  453. adsfsadfsadf
  454. sadfdsaf
  455. function to convert word document into HMTL
  456. Creating custom Input Masks...
  457. How can I call a form's event using a string
  458. How to create a access runtime?
  459. Unduplicated count of a table
  460. Cash register Access database
  461. forum
  462. PT Tables
  463. csv file line length limit
  464. Ask before saving record
  465. Appending from 2 multiselect listboxes
  466. Using a button to populate another form's auto# field.
  467. Record Selector Macros
  468. Regarding input masks
  469. Form Should open Maximize
  470. Access Validation Rule Question. Help Greatly Appreciated.
  471. Access and word mail merge
  472. UI Metaphors for complex criteria selection
  473. txt to mdb
  474. Open form as Data Entry with Customer Info
  475. Linking Relationship tables problem
  476. Damaged File/Print... menu option
  477. How can I input a name into a reprort
  478. How to have field values transported to fields in another form?
  479. Access using .Net Datagrid
  480. Encrypted password field in Access database
  481. Encrypted password field in Access database
  482. Help!
  483. Access Run Time Error 6 Overflow
  484. IIF acting funny
  485. ODEUNST.EXE???
  486. Is it difficult for a hidden form to check for user activity every 15-seconds or so?
  487. A-97 Alzheimer moment... what were the basic components of securing an app?
  488. Can not open database file
  489. Update Query with User-defined function?
  490. Query base on a changing table
  491. Sendin emails through Microsoft Access
  492. Copying a value from subform to main form
  493. Bang vs. Dot - final answer
  494. Output To vs. Transfer Text Options
  495. Reading and Writing Folder Properties
  496. Question on Error Message
  497. Access to ASP
  498. Will Stephan Lebans answer questions about his Calendar 'control'?
  499. How to copy a value from one form to another by button?
  500. Open a different Word doc for each record?
  501. How to join 2 different database files?
  502. Quick, simple question with Access Database Form
  503. Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
  504. running vba code in a loop
  505. Time Picker Control
  506. A2K networked DB "already opened exclusively by another user"
  507. Access12
  508. Strange Time-Formating Problem
  509. access and sql server via odbc
  510. A2K Subreport disappears in Access XP
  511. OT NNTP in VB
  512. How to Remove <BR> in Fields
  513. Strange Email Problem
  514. RAM USAGE
  515. What does this query do?
  516. Looping A Specified Number Of Times
  517. distinct records
  518. Subform with Query
  519. visible flag: datasheet versus form view
  520. sorting a crosstab query
  521. Changing to owners permissions using VB
  522. Subquery Sum by Date Range
  523. Making a button appear pressed in?
  524. AUTOMATE EMAIL ADDRESS IN ACCESS?
  525. adding empty rows to the end of a report
  526. reference subroutine from another form
  527. Modify Access MDB Application
  528. double prompt for value in report
  529. Over the years, I've used query wizard to list duplicate entries...
  530. Macro security level
  531. Macro Data Entry in a multi-row Subform
  532. linking subform master/child fields problem
  533. Problem linking Child/Master fields correctly
  534. Run-time error 2465
  535. Read Only
  536. Use other value from table
  537. Filtering report and subreport from form
  538. Field type corruption?
  539. Can a multi user Access db be used via Terminal Services?
  540. Default Fonts
  541. Creating sample data & MDB file size?
  542. Error 430, CopyFromRecordset with DAO 3.6
  543. Slightly O.T. - seeking documentation of the microsoft user interface specification
  544. Linking form - Report
  545. Query criteria - limiting the records - question
  546. Sequential numbering of a record collection
  547. code doesn't work on some PC's; does on others
  548. GROUP BY problem in access
  549. circular dependency between subforms, problem cased by subform loading order
  550. Continuous Form: Changing .BackColor depending on value?