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. Problems with 1) Office links sending Access report to Word and 2)send to mail recipient
  2. Strange Access/SQL Error
  3. making a footer visible=false in a report
  4. XP SP2 Screen Updating Problems
  5. synchronizing excel and access
  6. dCOUNT DATE
  7. Working with continuous form....
  8. how to create automatic backup
  9. How to open browser from link in Access
  10. CanShrinkLines hung up by debugger
  11. ADO-SQL LIKE
  12. Honey, I shrunk my sig!
  13. Easier, more straightforward way for VBA to determine if live connection to web exists?
  14. A qiuestion for the community
  15. Shrinking object
  16. database examples?
  17. linked form instead of subform - 1 to many relationship
  18. Browse button in database
  19. SELECT TOP question?
  20. Choose latest data for report
  21. How to include field names as first row of selct query?
  22. Choose latest data for report
  23. Reset Increment number on new month
  24. Create New Parent and Child Records from Old
  25. understanding North Wind Stock control
  26. Reporting
  27. in front end application and back end tables
  28. Get value from a table to a form
  29. Getting around file lock with Symlink or other means via JDBC?
  30. Calculating Specific Lines On a Report
  31. Database form lockout
  32. Can I use VBA to send text to Microsoft Sam (Win XP) from Access 97 to 'speak' the code in modules?
  33. Sorting and Grouping - page break error
  34. Best way to tell if X is between two values? A97
  35. Security
  36. Grpah report is very slow
  37. DbSee Changes
  38. Combo box dropdown problem
  39. Freeze Record after entry
  40. how to pass a variable in insert
  41. date string
  42. If...then...else?
  43. SQL - Left Join not working as intended
  44. ORDER BY ..... in Union Query
  45. sending fax
  46. Changed fields/values on a form
  47. At what point is a Report added to the Reports collection?
  48. PV function in Access
  49. Page setup
  50. Option group Question
  51. Subform new record specific field
  52. Deleting Duplicates
  53. altering field properties in code
  54. Incremental Number
  55. Unicode and VBA
  56. duplicate 20 records
  57. Looping through records
  58. Serializing a class with a Collection
  59. comments on stephan lebans' A97SnapshotToPDFver746.mdb?
  60. Does Access have to be installed on the server?
  61. Am confused as to what Date = Date + 1 means?
  62. Reaching a new record in as sub form
  63. Corruption from MCCAFFE 10
  64. Need Help Urgently with Strange Problem
  65. Query question
  66. Problem with Trim command
  67. Hiding a table contents using security
  68. How to quick-check SQL connection
  69. What is wrong with my connection.
  70. Common Code in Access - Excel - Power Point Programs
  71. Common Code in Access - Excel - Power Point Programs
  72. Add a Class property dynamically at run-time
  73. Limit 'many'Records in 1:many Form/Subform
  74. using access to update a sharepoint (SPS 2003) list
  75. Carriage return in label?
  76. Enumerating Textboxes
  77. Memo fields and performance/db corruption issues; best practices
  78. Access friendly stored procedures transportable?
  79. Getting Access to auto creat letters for a mailing list
  80. Can I make a form goto a specific record using SQL?
  81. Denormalize Data?
  82. select multiple values from a combo box
  83. Data collisions
  84. Delete Query help (A2003)
  85. Can VBA be used in A97 to make setting to other windows programs?
  86. Date formats when exporting to excel via VB
  87. too many fields in a table... over 255
  88. Problem with FROM Clause in Query
  89. Looking for Easter Egg Pong style game Code
  90. MS Access 97 DB Corrupts after Compact
  91. DB design using expiry date in products
  92. OLE information from OLE field
  93. incorrect OREDR BY results when reading from access DB using fields in different charset
  94. Inventory Control.. This is more COMPLEX than I thought!
  95. Recordset Type in ADP
  96. Advice on upgrading 97 runtime app to 2003
  97. Help with If Then statement
  98. Optional Parameter for Querydef with Default Built In
  99. Access 97: Use VBA to find selected column in subform (datasheet view)
  100. open source solution for extracting data from MS Access on Linux?
  101. RunSQL Delete is locking up/taking forever
  102. performing an unusual record search
  103. Last recorded record based product
  104. Option Group Options Not Checking
  105. Custom Row Functions: Access vs. SQL Server
  106. finalizing ideas
  107. Emailing report via access without outlook prompting user!
  108. Severe DB bloat after importing excel records
  109. Printing form with current record
  110. querydefs in 2000 vs 2003
  111. relationship problems
  112. Wrong Weeknumber
  113. Pie-chart printing quality in Access Report
  114. Design Flaw?
  115. Pivot charts in Access
  116. A97 vs.A2003
  117. Print Report with 2 subreports while maintaining different image backgrounds
  118. How to sum columns with code?
  119. Passing information from a form to SQL
  120. OLE information from OLE field
  121. Update syntax
  122. saving records
  123. Print a record from a form
  124. Using combo box values to select query fields
  125. Remote ADO connection to SQL Server (MSDE)
  126. order by property in a table
  127. How do you do calculations in Access?
  128. Best Way to Get At Data in Another mdb
  129. Problems with Code on machines with latest corp image
  130. VBA Question: Is There an Easy Way to Trim All Fields in a Table?
  131. Student Record System in Access
  132. Microsoft Access Secrets?
  133. Form to Subform Linking
  134. Report Driving Me Crazy!!
  135. Query problem
  136. tables and relationships
  137. tables and relationships
  138. tables and relationships
  139. How to refer to the control on the second subform
  140. Simple Password Form
  141. creating a help file
  142. ActiveX Component can't create object
  143. Help! Client's request beyond my Access capability
  144. Problem with Sub-Form and SQL-Server Back End
  145. Query on Formula
  146. OT. Funny story about passwords. I wonder how many people do this
  147. Error 2465 - Can't find field 'forms' ???
  148. Building SQL query when table is two words...
  149. VBA to Add or Remove a Field From a Table?
  150. upgrade A97 or stay put
  151. Automatically Generate Number On Form
  152. Remote ADP connection to MSDE
  153. populating an access database...
  154. How Do I Remove Security
  155. Records getting lost
  156. First Time Portrait ...
  157. ActiveX Error
  158. internationalization of an application
  159. How to split report on Group data.....
  160. in subform different query
  161. in subform different query
  162. NoData event happening when there _is_ data.
  163. make .mde with A2k2 runtime
  164. Importing table to replace existing table
  165. PivotChart with dual scale
  166. Upsize to SQL Server
  167. access report
  168. gray-out and lock one subform record among many in datasheet view... HOW?
  169. Need code to update tables on server database
  170. Need Access Clipboard help ...
  171. Need Help With Query
  172. Relationships reappearing in query design
  173. Delete relationship
  174. Help for Acc. 2003 dev. extentions needed
  175. Private versus public variables and error handling
  176. stupid report question
  177. creating Multiple subforms
  178. Help with ADO Connection needed please
  179. Table Structure help
  180. Table normalizing help/suggestion
  181. Date search problem
  182. Running in Runtime
  183. Open form to Pivotchart view
  184. Open form to Pivotchart view
  185. Problem with exporting/importing
  186. access replication problem
  187. Compatibility
  188. Combo box for a parameter query
  189. Properties Submenu For Custom Men Won't Come Up
  190. Create a Query on a Hyperlink
  191. Help with calculation in MS Access
  192. date reference from loaded form
  193. Joe Celko Nested Sets
  194. Report
  195. Importing Text File
  196. Help with table design
  197. data has been changed error message
  198. Multiple formats in query
  199. Fill out a PDF Form from Access
  200. Help with building an access database.
  201. Why won't Access Run this Query?
  202. Resize Form Controls and Subform Controls at the same time
  203. DB Structure help
  204. PLEASE HELP... SQL SERVER Query in Access
  205. Form resize alse requeries?
  206. Populating Recurrsive TreeView in ADP using ADO
  207. Menus overwritten "bluetooth device not found"
  208. Linking a different table hyperlink to each form record
  209. Active Directory and DFS
  210. Backup database access
  211. relatively new to database
  212. adding a column to a linked table
  213. WinXP-A97: Can't start mailsession
  214. Access Security?
  215. Disconnected mapped network drive
  216. Slightly more complex SELECT query syntax in A97
  217. Error looping through controls on form in Access 2003
  218. Reset Auto Number Fields
  219. Is this valid syntax (A97 VBA)?
  220. Trying to show data in report columns by year
  221. Strange symptom - Auto switching to Chinese keyboard input
  222. I need advice on some Stephen Lebans' code
  223. Change Text Box Display in Reports
  224. Displaying the Input mask when entering a control
  225. Preventing Users From Viewing A Record That Is Being Edited By Another User
  226. Prevent Access from closing
  227. share an access03 database sitting on server2003
  228. Check for field value from within a report OnFormat?
  229. Having trouble creating a deployment disk for an access program
  230. Import Text Wizard Doesn't Work in Access 2003
  231. Showing photos in forms or reports
  232. Better way to test for field being left empty
  233. Saving Pivotchart as an image
  234. Qutting Access when a dialog box is open
  235. Using =Sum([x]*[y]) in a Report control (ADP)
  236. Help Query, two table, look for figure between start and end Version: Any Version
  237. How to maybe save tenths of a second
  238. Printing a UTF-8 encoded XML file
  239. Using MSDE automated with code.
  240. Counting recordsets
  241. Crosstab report Null and Zeros
  242. Resetting the Recordset while within the Form - how?
  243. #Error in query
  244. Checking for group membership?
  245. Sorting Numbers within A String
  246. Ongoing problem with Unknown Function Replace
  247. Align numbers right in list
  248. Easier / different way to do this
  249. Error loading DLL?
  250. O.T. - trying to sync w/ nist time server...
  251. Problem with passing a string to a function
  252. Options - Confirm Actions
  253. Too few parameters expected 2 error occurs after migrating "MS Access 2000" to "MS SQL Server"
  254. Microsoft Access Applicatiion Doesn't Close in my XP machine
  255. The Access 12 Blog/RSS
  256. Access Sorting problem - please help! (also in comp.databases)
  257. count checkbox values
  258. Problem concatenating memo fields in MS access database
  259. Specifications for a development PC
  260. Compile/ADE Weirdness
  261. double data entry with msgbox function?
  262. Mailmerge from MDE not working
  263. Little Help With Update & Subquery?
  264. filter by form/subform
  265. BXOR
  266. Multi-Select Listbox: Loop through, ignoring duplicate items
  267. auto populate field
  268. License question: .MDB files in .NET applications
  269. OpenForm based on combo box in a continuous subform.
  270. DAO (Instantiate as Object or use the Data Control)
  271. Many global vars in an A97 app - good or bad? Why?
  272. Datasheet views
  273. combo box - requery question
  274. Access 2000/2003
  275. Access 2K Macros Appear from Nowhere?
  276. Replace and Update
  277. Order of events - delete record in subform
  278. Any good book for MS Access 2003?
  279. Show current users
  280. time increment query
  281. Date Variable in DSum function
  282. Dirty Event for Form is not "firing".
  283. ado connection with excel pivotcach-problem compact db
  284. Using NetWorkdays Worksheet Function
  285. Insert records to a related table when an option is selected from list
  286. Problem pulling value of OpenArgs into report InputParameters
  287. Launch switchboard from desktop icon
  288. MCACCESS AND WINFAX
  289. Value displayed incorrectly in Recordset
  290. MS Access ODBC -- Connect failed!!
  291. Running DTS package from Access
  292. Using SQL to update control properties...possible?
  293. Combobox value not saved - why
  294. DatePicker
  295. refencing page tab
  296. Locked out of old mdb...help
  297. Incorrect data on opened form based on SQL View
  298. Problem with quotation marks in code
  299. Combo Box
  300. Access stucks in Before Update
  301. Getting Information to Subform
  302. The future of various DB connection technologies and related technoloies
  303. Security Warnings
  304. A97 error #2109 ?
  305. access 2003 using sql view to write reports
  306. access 2003 using sql view to write reports
  307. Closing ADO Recordset created by Execute
  308. Busines Related Links?
  309. trouble with the IIF
  310. Too long combobox
  311. Creating Queries in DAO vs ADOX
  312. import excel with macro and truncate 1000s off of time
  313. Access to automatically send email with excel attachment through outlook
  314. A97 - Can I trap 'n handle error #3315 inside my own error handler?
  315. Automation Weirdness with Outlook
  316. Help with add/subtract
  317. Export to Excel multiple existing sheets
  318. need help in date code..find all product that expired in the month
  319. Restricting selections on form based on live updating query
  320. Link tables by code
  321. migrating old access database over to a new one
  322. User selectable color spec in data fields on printed reports
  323. How to reference the MS Graph control place inside an unbound object frame
  324. Upgrading to 2003
  325. Suppress 'Save changes to layout of query...'?
  326. Field captions in Queries
  327. Verify Format
  328. Problem with filling in Bookmarks in Word
  329. date query
  330. No valid bookmark - no bookmarks present
  331. Join with intermediate table
  332. :?: Need advice on how to create searchable database :?:
  333. MSAccess Freezes, double-click on statusbar helps
  334. Changing query for MS Graph
  335. What happens in procedure 1 the very instant sub procedure 2 is called?
  336. Old ms Acess App
  337. Bitmap prints differently on different computers (repost)
  338. Regression Testing tools
  339. frequent crashing on network
  340. Seperate Totals Based Upon Criteria
  341. SQL SUM Questions
  342. Listing users of a database
  343. Error 3027: cannot update: database or object is read only
  344. Binary data stored in SQL Server: can't read from ASP.NET, *can* read from Access?
  345. Need code to import files
  346. Simple Query Help Needed
  347. Fields do not shrink on the report.
  348. Error trying to change permissions
  349. OT? Recruiter Hell
  350. Help:creating a new invoice?
  351. Unlinked subreport (as TOC) won't display
  352. Import file from a website into a table
  353. How can I hide the Date when I post a message
  354. Data input and tables
  355. Possible to run code in one form from another form?
  356. Combo Box "Not In List" VBA code to Add item to table
  357. Tab Control Sub-report with Different Sized Pages
  358. Dlookup - Determining what table to lookup based on value in certain field
  359. Generate report for different departments in a list
  360. Yet another Query Linking Question
  361. Dividing currency in half?
  362. Help with SQL please..........
  363. Moving a picture from one form to another
  364. Remove orderline from subform when returning order
  365. Detect When Entering New Record
  366. Like problem in SQL
  367. Multiselect ListBox - Active/Inactive Items
  368. Request for Steve Jorgensen
  369. Access Freezes
  370. Inventory History Report w/ Balances
  371. Announcing Data Swap for MS Access
  372. Export to Excel Template gives Error - HELP!
  373. Documenter in adp?
  374. Autoupdate Time Zone in Access
  375. Global Const (MY_VERSION$) 's value will not display in textbox
  376. Connect using file DSN in code using a DAO function
  377. show certain record first in subfrom
  378. Help - Populating a field in a datafeed based on values in another field
  379. Form Losing Data
  380. A97 - easiest way to have a look at a value entered into a textbox during the BeforeUpdate event?
  381. New Computer Groups
  382. Why does tracing (debug) yield different results?
  383. How to transfer info automatically from an excel data?
  384. automatic export with layout in excel....
  385. Finding the maximum value across several fields in a query
  386. Table with 230 Fields....what's a better alternative?
  387. 2nd Try: Access Data in Subform
  388. Viewing Data Access Pages (DAP) - Internet Explorer Protecting Your Security
  389. Runtime DB?
  390. Strange new runtime error. Please advise!
  391. MS Access Create form / report with multiple pages using different background images
  392. A97 bound controls not showing default values in form view on new record?
  393. VBA332.DLL and AccessXP And Getting Current Folder
  394. Moving a picture from one form to another
  395. Formal Complaint
  396. Access 2000 view Outlook 2000 Inbox error
  397. Access to Auto Export in HTML format at specific time intervals
  398. Handbase + MS Access
  399. Installing Visual Basic 6 "downgraded" Jet 4.0 to Jet 3.5. How to fix?
  400. Complicated Append Query
  401. How to transfer info automatically from an excel data base to a word document OR an excel
  402. Conversion Access MDB to ADP & MSDE 2000
  403. VB6 code converted to VBA / Access2003
  404. Append 2nd, 4th, 6th line of a text file to the 1st, 3rd, 5th line as a table
  405. How to add a filter in Acess in VB
  406. How to add a filter in Acess in VB
  407. Sort table, not with SQL!
  408. Help- How do I insert objects in a table in bulk?
  409. Registry patch question
  410. How to show the System Name
  411. Trouble with navigation
  412. Problem with HOST_NAME Function with Linked View
  413. Hierarchical Database Systems
  414. Programmatically unchecking Show Hidden Objects at DB-launch
  415. How to update a graph in a subform
  416. Totals query for the last date
  417. Date input mask.
  418. Use of Parameter Query in Code
  419. Creating Object (Outlook.Application)
  420. Run Time Error Question
  421. Deploying access database
  422. Command Button to Unhide Fields
  423. Compact/Repair
  424. Strange report error message - control must have focus
  425. Reference If Statement Result
  426. DoCmd.OpenForm Problem
  427. Put Item from One List Box BACK into Source List Box and Using Field data
  428. Print Code for non-Working Form
  429. Query witt parameter used as Table in SELECT * FROM. Howto?
  430. select count by group?
  431. how to see vba "compiled" code
  432. If Statement Unbound Text Box
  433. multi selection
  434. Linked excel spreadsheet - multiple cells
  435. Lix count (readabillity) / Flesch-Kincaid
  436. Calendar
  437. open report in a succession
  438. record source
  439. Trapping Click With Calculated Check Box
  440. Callback function in ADE file
  441. Interpret Error And Provide Cure
  442. MS Access + HanDBase Synchronising
  443. Create DSN and Link SQL Table in Access - Solution
  444. Trying to filter data as I summarize in Query
  445. query question
  446. Using Access 2003 to Send Outlook Emails
  447. Copying down a column in Microsoft Access
  448. "Sorry, Access has to close now for some reason or another..." msgs in A97
  449. Activate Event question
  450. Automated Time Card System Recommendations
  451. filter field for report - access97
  452. PC Donation Database
  453. search by form question
  454. @ to go down a line in message box prompt
  455. Form Optimization
  456. Access 97 - hyperlink
  457. Access 97 automatic purge records
  458. Access 97 automatic purge records
  459. Looping variables - Integer vs Long
  460. Performance by working with linked tables
  461. Seeking latest 5-digit zip database floating around out there?
  462. Encryption method desired...
  463. How to re-provide password to encrypted linked tables?
  464. Parsing an email address from a string? (A97)
  465. Questions about tables upsized db from access to sql
  466. on delete cascade problem
  467. Getting three highest values
  468. How do I use Insert Into with parameters in .net
  469. Using part of a field to fill in another field?
  470. Help! Run-time error 3358 cannot open Workgroup Information File
  471. Remotely set a db password?
  472. How best to set up relationship between city - county tables?
  473. Help files
  474. Group by Month
  475. Formatting Date As YYYY-MM instead of YYYY/MM?
  476. Using FileStream and XmlSerializer: Gives me the error:The instruction at "0x635e0719" referenced memory at "0x00000000". The momory could not be "read
  477. Date Format
  478. Error 3167 record deleted
  479. automatically entered filter criteria
  480. never can get this right....going from one inbedded subform to another for a value
  481. Data Validtion using a table of SQL statements
  482. Access VB help
  483. Programtically create mdw file
  484. Producing an age profile for members of a club
  485. using access 97 mde file
  486. Locked record message
  487. Using Google Maps In MS Access
  488. License Required to use this ActiveX Control ?
  489. Setting Report Properties at Run Time
  490. Help with Expression Builder
  491. DoCmd.PrintOut .... Doesn't
  492. Turn off View Hidden and System Objects in code
  493. Getting rid of spaces in fields
  494. Access on Citrix: will global vars come back to haunt me
  495. automate import of encrypted Paradox tables?
  496. Access 97 - Working with Chart Wizard
  497. Problem with Totals on Sub Forms and Main Forms
  498. Need to increment a non-standard number
  499. Project problem..........
  500. Creating PDFs from Access 2003 on Windows XP
  501. Creating PDFs from Access 2003 on Windows XP
  502. Why is sorting in the database view bad? (Form Properties > Datasheet View)
  503. activating Date and Time Picker
  504. Breaking up a report or looping through?
  505. Date Format Issue
  506. Duplicate Value error with Single Table across multiple tabs
  507. NZ Example from MLH
  508. Installing Access on XP Home
  509. Action Queries In Series
  510. How to have capital characters not changed into lower case?
  511. Running LIKE SQL in VB CODE
  512. Formula required
  513. Listing fields in a table
  514. rs.FindFirst question
  515. Toolbar button to open Windows printer selection window
  516. Access - Email
  517. Set Up A Workgroup In The Command Line
  518. Creating a unique number from a text string
  519. Can I get the highlighted row from a dropdown?
  520. Problem with MID function
  521. CALL FOR SHORT ARTICLES - Proposal Deadline: 15 Nov 2005 (Extended)
  522. DBEngine.CreateWorkspace Error 3002 Could Not Start Session
  523. Link SQL table through VB Code
  524. First Function - One Problem!
  525. The specified field could refer to more than one table error with curious but inadequate fix
  526. Class with custom event as subform wrapper
  527. Deselect a Radio Button at Lotus Note
  528. Help needed for Programming
  529. Help with setting Access Memo field restrictions using DDL
  530. Automatic timed deletion of tables
  531. Popup window is hiding whole screen
  532. Changing Tab Index of Form Controls
  533. Error message when opening a database
  534. date problem
  535. Access Developers Handbook
  536. Find and Replace
  537. Finding the true binary structure and contents of MS-Access files
  538. Security Restrictions for Signed Databases in Office 2003
  539. Creating EMAIL from VBA (behind a form)
  540. problem with relative paths for references
  541. VB.NET conversion
  542. "The command or action 'xxxxxx' is not available now" Error
  543. Preferences for loading unbound data?
  544. Conditional Formatting
  545. "Jet engine" error in A2000
  546. Date Calculation - same field, different record
  547. simultaneously access
  548. ADP database name?
  549. Access 97 -- how to get to VBA code?
  550. Access 97 .mdws with Access XP databases