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