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