Home : Bytes IT Community / View Full Version : MS Access

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

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