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. Multiple Vehicle Mileage Calculation
  2. In case you ever get an error 2455
  3. How do I change the keyboard input language from within Access 2000?
  4. File Transfer Animation
  5. Find Primary Key field
  6. Linking Checkboxes to values in a table for a Report
  7. Automatically printing to Adobe Acrobat
  8. OraOLEDB.Oracle provider missing
  9. Getting data from excel spreadsheet column into access table
  10. Report Help
  11. run sql query for each record in a contious form
  12. Ok this is a strange one
  13. SET NOCOUNT ON; Multiple Recordsets; ADO Command Text
  14. Look at this
  15. Curious about Access 12 Report Formatting
  16. Circular relationship nightmare
  17. print ourt labels
  18. Import Paradox database into mdb issue
  19. Automate printing reports to PDF
  20. Automating a command button to do a Get External Data command
  21. Super easy word merge
  22. DLookUp Problem
  23. database variables problem
  24. set up two criteria in one command button
  25. Finalizing the dialogue with newsgroup Megalomaniacs (change of Subject...)
  26. HELP - Using GoToControl in subforms
  27. Remove Filter/Sort
  28. Database security (crosspost)
  29. Encrypted database
  30. Conversion: Access 2000 to Access 2003
  31. Subtracting Dates
  32. Multipage Form
  33. Active X controls problem
  34. Dumb Question
  35. Edit format of field in a form that can be populated by a lookup
  36. How to extract just the time portion of DateTime
  37. Validation q's - subform BeforeUpdate event (and SQL)
  38. Code not producing desired result
  39. TransferText and Missing/Skipped first line - Solution
  40. Drop Down List
  41. Navigation buttons
  42. sql password with access query
  43. multiple selection
  44. multiple selection
  45. Can't update data in a query
  46. Word and Excel Objects in Access Reports
  47. Evals("myPublicVariable") do nor work: have you any alternative way?
  48. I am gathering the date of my customer..
  49. Dialogue with newsgroup Megalomaniacs (change of Subject...)
  50. is the access database able to be converted to SPSS date?
  51. subquery problem
  52. Display full name in combo box
  53. Get list of custom properties
  54. Switching between two columns in a form viewed as datasheet
  55. Horizontal grouping
  56. Multiple Recordset from a Stored Procedure
  57. From ListBox to Subform -- , how to add SQL statement?
  58. the switch statement has got me a little confused..can someone clear this up for me please
  59. Mailing Labels
  60. Select INTO ListBox
  61. Form border color
  62. Confirm/commit insert in ADP project
  63. Help with a list box
  64. ODBC: SQLTables does not return data for an Access database?
  65. OpenRecordset help needed
  66. Aiuto per formato data
  67. filtering and edit
  68. Error occurs when MS Access open Excel document and trigger the assigned macro in Excel
  69. SHELL handling a switch.....
  70. Explanation???
  71. Form opens SLOW when "Allow Addtions" set to No
  72. How to connect MS Access form to MS SQL Server
  73. I'm trying to completely unsecure an A97 app
  74. Please Help --Adding a Primary Key to a Table with over 180K records
  75. Pasting multiple lines of data into text box - how do I divide it into seperate strings??
  76. Query works in Access but not with exec call from .net
  77. A message to Self-Appointed-NewsGroup-Netiquette-Enforcers... PLEASE LEAVE US ALONE!
  78. Load Form?
  79. Need help on seeing data in form
  80. MS Access Query Export Error "Too Few Parameters. Expected 1"
  81. QBF problem with multiple combo boxes
  82. If Statemet
  83. What kind of replica?
  84. closing a db with an error
  85. MS access: Book recommendations
  86. Import data and changes from access to access
  87. editing data in pivot table
  88. Help please! Add or remove from field value through a form
  89. Text Field default value based on function...
  90. Programaticaly populate a sub-form
  91. Pass Through Query Nightmare (Access 2K --> SQL Server 2000)
  92. How can I stop people have access to my MS Access Tables and Queries via Import?
  93. Learn SQL?
  94. Mappoint app or activex control?
  95. beginer with problem
  96. Simple MS Access Update ... Wont Update
  97. Plot a data series along a secondary value axis
  98. Intel Software to boost Access' performance
  99. Re-appearing dlls and type libs.
  100. Field for Number of records in a query
  101. change form property using SetValue
  102. Query to display number count
  103. Browse and Store Filename
  104. Browse and Store fileaname
  105. clsReadTextFile
  106. Access 2k3 / WinXP Issue = kooky join
  107. Keeping track of jointly owned assets
  108. 50,000 Ft Question
  109. query
  110. Test
  111. How are you connecting to this group?
  112. Email data from input-screen
  113. Partial replica: which tables are synchronized
  114. Alternatives to expensive Wise/Installshield/Sagekey?
  115. Deleting from the query's datasheet view, from both tables?
  116. Query by User
  117. How to sort Commands in Menu Builder (Customize)
  118. How to convert/transform txt to DB
  119. Access date validation driving me nuts
  120. How to determine what system DLLS are running in one screen?
  121. Selling Access app to general public?
  122. COMCAT.dll difference in Packaging Wizard.
  123. Error 3075 when in stalling Package Wizard set up file (XP)
  124. Access 2000 Delete ADDs a New record? Help
  125. Delete Record Woes Access 2000
  126. export problems
  127. Problems Sending Attachments
  128. Hyperlink Properties
  129. Changing caption content in a Table or Form
  130. upload excel file into sql server
  131. zTest.htm Ever hear of it?
  132. form timer stops firing until mouse or keystroke event
  133. Get SQL Data (DNS Less)
  134. date value issue
  135. ARG! Help! Path/File error using Access XP ODE P&D Wizard
  136. Retrieve global constant string from another database
  137. Linking Two Subforms
  138. combobox dropdown
  139. Access 2000 query problem - Help!
  140. Relative Recordset Position
  141. Prevent Design View
  142. form sizing
  143. Blank page after report header
  144. TransferText and First Record in Text file
  145. Printing sheet of labels not working
  146. Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
  147. O.T. - I'm not sure - Anyway, its a sort algorithm question
  148. Access does not like Mysql
  149. WARNING: Relationships not imported with data
  150. copyfromrecordset does not work on different machine no errors reported
  151. Address Label Problem
  152. Is this a bug?
  153. Access database on Windows 2003 server is excrutiatingly slow
  154. Memo Text Truncation during Excel Export
  155. Adding last record to another table with Append Query
  156. I confess
  157. How do you determine if anyone is logged onto a BE database?
  158. Change table date/time field to text field in code
  159. Urgent Help on Australian dates on spreadsheet saving as American dates on a text file.
  160. Access 2000 database and Office XP compatability?
  161. macro, control on form
  162. Has anyone posted code to convert longer HEX numbers to DEC strings?
  163. Prevent minimising application. Possible?
  164. ADO new record #Error why??
  165. Date criteria
  166. Help handling string length overflow?
  167. All caps font for A97 report
  168. Re-logging into An Oracle Database
  169. Form Backgroud colors
  170. fDesign
  171. Help With Expression Please
  172. Difficult SQL Query with multiple records detail
  173. SQL code not returning correct data
  174. Report sometimes prints in grayscale -- problem and solution
  175. Window on toolbar
  176. Report
  177. How to make a condition for making a SUM - Correction
  178. How to make a condition for making a SUM
  179. Help with Golf DB
  180. DLookup syntax when there are two primary keys
  181. Automate WinZip self-extract
  182. Evaluating References in Code [Long]
  183. How to Consume a Web Service from Microsoft Access
  184. Access Hangs during spell check (Caught in loop)
  185. dcount syntax
  186. ADP and T-SQL Problem
  187. Need a Flowchart type Calendar for a lodging reservation application
  188. subform combobox filter problem
  189. 2006 Calendar Available
  190. subform combobox filter problem
  191. zipcode
  192. Msgbox Icons?
  193. wininet and urlmon in use during A97 runtime rollout
  194. Help with Charts
  195. Problem printed multiple instance reports
  196. Help with MS Access Report: Repost
  197. Enforcing no duplicates in multiple textbox controls
  198. Help needed with query syntax
  199. Two Query Questions
  200. How Do I mail merge one instance of every person???
  201. XML and special characters ...
  202. Click on Map area to chose filter for Query
  203. Publishing Web reports - can you
  204. are ado questions allowed here?
  205. Form data entry history
  206. Single item inventory?
  207. Macro
  208. Query Creates Read-Only Recordset
  209. Outlook Toolbar in Access
  210. MS Access Reports
  211. Access 97 - Reports
  212. MS Graph in Access 97
  213. Changing Stubborn Data Type
  214. Spontaneous loss of subform bookmarks
  215. Spontaneous loss of subform bookmarks
  216. filling up blank fields
  217. Update a 2nd Table
  218. Report Creation With Query
  219. Exporting Report to PDF without save prompt on Windows 98
  220. Query to ignore other conditions
  221. Stubborn front-end bloat in Access 2002
  222. Unique with empty records?
  223. Navigational / lookup combo boxes
  224. Run Time Error 3075 Missing Operator
  225. delete a record with required fields
  226. printing
  227. Add a query and print after filling out a form
  228. Setting focus to an external application
  229. MultiSum SQL Syntax
  230. Calling Access 2003 from cmd file via Windows Scheduler
  231. To populate Excel sheet
  232. Mailing List Auto Content
  233. Custom Menus Question (Remove 'Type a question for help').
  234. Date Parameter when using Intl Date Formats
  235. you cancelled prev. operation error
  236. Passing date as a parameter and regional settings
  237. HELP: how to recover deleted record from a Table
  238. Print Publisher document
  239. Reorganize MS Access Table
  240. AutoNumber Issue
  241. using database from different versions
  242. How to use UNION ALL and SORT BY
  243. Limit of Access
  244. Adjusting Report Properites via code
  245. Bringing Custom Toolbars back to Acc rt
  246. refresh/redraw flicker on mouse over of lable control
  247. data base
  248. data base
  249. data base
  250. access database
  251. User Roster for a secured backend
  252. Help! Referencing containers!tables specific item without looping
  253. Is it possible to refresh records displayed in an open table from a form?
  254. make single line records into multiple lines - tricky
  255. How to track down 3075 error "Unknown"
  257. appending to text files
  258. Can't refresh link to an SQL table
  259. Opening old MS Access Files
  261. How to enforce pessimistic record locking?
  262. How to open a chm help file prepared with "HTML Help Workshop"
  263. Error Number
  264. can't exclude zeros from my report
  265. can't exclude zeros in my report
  266. create relationship between two tables
  267. Deleting a hidden file
  268. Compile error causes MDE creation to fail in A97???
  269. Kill all text files except those starting with ~$
  270. Return codes with reports
  271. EER Diagram advice
  272. storing a scanned document...
  273. Reports
  274. Send to user in database
  275. Reports - Running total not working properly
  276. MS Access 97 / UNION / SELECT INTO
  277. Combobox Requery Onchange
  278. Looping table structure
  279. Access 2003: How to default to full menus?
  280. Displaying photo files in a continuos form.
  281. Foriegn Key update
  282. acc 97 sendobject
  283. Exit code when certain criteria is met
  284. Not shure how to make specific application
  285. Forumla to get part of the string
  286. Can I change the rowsource bound column for existing data
  287. Checking admin rights on registry?
  288. ADP bound form - force record save, recordsetclone not populating after requery
  289. Mobile Access
  290. Mobile Access
  291. VBA: Easy Way To Export Fixed Width Text File For A Table?
  292. Open sub-form based on combo selections
  293. Access 2003 crashing while creating a drop down list
  294. How To Use VBA To Get The Size Of A Text Field
  295. Timeline Control?
  296. Streets mapping system
  297. Unhide Specific Fields on basis of Selection on combo
  298. Object List
  299. Send text file to logged in users network folder
  300. How to control an Excel.Chart.8 object in an Access form?
  301. Access 12 RAD strategies
  302. Access 2003 Runtime
  303. What's New in Access 12 Blog
  304. content of a field into a command line or module
  305. A Suggestion for the Community
  306. ODBC API
  307. Compile at runtime?
  308. Randy Harris
  309. mail merge with multiple detail tables
  310. Data subset in report header
  311. Run On Close Form Event If DB is Closed
  312. Ran a batch file or an MS Access macro shortcut without opening another instance of access
  313. What are a pass through and union queries for?
  314. Database Design
  315. Proper way to run an Action Pass Through Query from Access 2000
  316. Not shure which query have to use
  317. Access Multiple Criteria OpenForm
  318. MS Access 2003 problem
  319. Pie Chart won't work
  320. ERROR starting
  321. help needed plz
  322. Mutliple timers on one form
  323. Setting a simple condition for a field
  324. Can IE be automated?
  325. Multiplying query columns
  326. subquery acting up
  327. Problems with 1) Office links sending Access report to Word and 2)send to mail recipient
  328. Strange Access/SQL Error
  329. making a footer visible=false in a report
  330. XP SP2 Screen Updating Problems
  331. synchronizing excel and access
  332. dCOUNT DATE
  333. Working with continuous form....
  334. how to create automatic backup
  335. How to open browser from link in Access
  336. CanShrinkLines hung up by debugger
  338. Honey, I shrunk my sig!
  339. Easier, more straightforward way for VBA to determine if live connection to web exists?
  340. A qiuestion for the community
  341. Shrinking object
  342. database examples?
  343. linked form instead of subform - 1 to many relationship
  344. Browse button in database
  345. SELECT TOP question?
  346. Choose latest data for report
  347. How to include field names as first row of selct query?
  348. Choose latest data for report
  349. Reset Increment number on new month
  350. Create New Parent and Child Records from Old
  351. understanding North Wind Stock control
  352. Reporting
  353. in front end application and back end tables
  354. Get value from a table to a form
  355. Getting around file lock with Symlink or other means via JDBC?
  356. Calculating Specific Lines On a Report
  357. Database form lockout
  358. Can I use VBA to send text to Microsoft Sam (Win XP) from Access 97 to 'speak' the code in modules?
  359. Sorting and Grouping - page break error
  360. Best way to tell if X is between two values? A97
  361. Security
  362. Grpah report is very slow
  363. DbSee Changes
  364. Combo box dropdown problem
  365. Freeze Record after entry
  366. how to pass a variable in insert
  367. date string
  368. If...then...else?
  369. SQL - Left Join not working as intended
  370. ORDER BY ..... in Union Query
  371. sending fax
  372. Changed fields/values on a form
  373. At what point is a Report added to the Reports collection?
  374. PV function in Access
  375. Page setup
  376. Option group Question
  377. Subform new record specific field
  378. Deleting Duplicates
  379. altering field properties in code
  380. Incremental Number
  381. Unicode and VBA
  382. duplicate 20 records
  383. Looping through records
  384. Serializing a class with a Collection
  385. comments on stephan lebans' A97SnapshotToPDFver746.mdb?
  386. Does Access have to be installed on the server?
  387. Am confused as to what Date = Date + 1 means?
  388. Reaching a new record in as sub form
  389. Corruption from MCCAFFE 10
  390. Need Help Urgently with Strange Problem
  391. Query question
  392. Problem with Trim command
  393. Hiding a table contents using security
  394. How to quick-check SQL connection
  395. What is wrong with my connection.
  396. Common Code in Access - Excel - Power Point Programs
  397. Common Code in Access - Excel - Power Point Programs
  398. Add a Class property dynamically at run-time
  399. Limit 'many'Records in 1:many Form/Subform
  400. using access to update a sharepoint (SPS 2003) list
  401. Carriage return in label?
  402. Enumerating Textboxes
  403. Memo fields and performance/db corruption issues; best practices
  404. Access friendly stored procedures transportable?
  405. Getting Access to auto creat letters for a mailing list
  406. Can I make a form goto a specific record using SQL?
  407. Denormalize Data?
  408. select multiple values from a combo box
  409. Data collisions
  410. Delete Query help (A2003)
  411. Can VBA be used in A97 to make setting to other windows programs?
  412. Date formats when exporting to excel via VB
  413. too many fields in a table... over 255
  414. Problem with FROM Clause in Query
  415. Looking for Easter Egg Pong style game Code
  416. MS Access 97 DB Corrupts after Compact
  417. DB design using expiry date in products
  418. OLE information from OLE field
  419. incorrect OREDR BY results when reading from access DB using fields in different charset
  420. Inventory Control.. This is more COMPLEX than I thought!
  421. Recordset Type in ADP
  422. Advice on upgrading 97 runtime app to 2003
  423. Help with If Then statement
  424. Optional Parameter for Querydef with Default Built In
  425. Access 97: Use VBA to find selected column in subform (datasheet view)
  426. open source solution for extracting data from MS Access on Linux?
  427. RunSQL Delete is locking up/taking forever
  428. performing an unusual record search
  429. Last recorded record based product
  430. Option Group Options Not Checking
  431. Custom Row Functions: Access vs. SQL Server
  432. finalizing ideas
  433. Emailing report via access without outlook prompting user!
  434. Severe DB bloat after importing excel records
  435. Printing form with current record
  436. querydefs in 2000 vs 2003
  437. relationship problems
  438. Wrong Weeknumber
  439. Pie-chart printing quality in Access Report
  440. Design Flaw?
  441. Pivot charts in Access
  442. A97 vs.A2003
  443. Print Report with 2 subreports while maintaining different image backgrounds
  444. How to sum columns with code?
  445. Passing information from a form to SQL
  446. OLE information from OLE field
  447. Update syntax
  448. saving records
  449. Print a record from a form
  450. Using combo box values to select query fields
  451. Remote ADO connection to SQL Server (MSDE)
  452. order by property in a table
  453. How do you do calculations in Access?
  454. Best Way to Get At Data in Another mdb
  455. Problems with Code on machines with latest corp image
  456. VBA Question: Is There an Easy Way to Trim All Fields in a Table?
  457. Student Record System in Access
  458. Microsoft Access Secrets?
  459. Form to Subform Linking
  460. Report Driving Me Crazy!!
  461. Query problem
  462. tables and relationships
  463. tables and relationships
  464. tables and relationships
  465. How to refer to the control on the second subform
  466. Simple Password Form
  467. creating a help file
  468. ActiveX Component can't create object
  469. Help! Client's request beyond my Access capability
  470. Problem with Sub-Form and SQL-Server Back End
  471. Query on Formula
  472. OT. Funny story about passwords. I wonder how many people do this
  473. Error 2465 - Can't find field 'forms' ???
  474. Building SQL query when table is two words...
  475. VBA to Add or Remove a Field From a Table?
  476. upgrade A97 or stay put
  477. Automatically Generate Number On Form
  478. Remote ADP connection to MSDE
  479. populating an access database...
  480. How Do I Remove Security
  481. Records getting lost
  482. First Time Portrait ...
  483. ActiveX Error
  484. internationalization of an application
  485. How to split report on Group data.....
  486. in subform different query
  487. in subform different query
  488. NoData event happening when there _is_ data.
  489. make .mde with A2k2 runtime
  490. Importing table to replace existing table
  491. PivotChart with dual scale
  492. Upsize to SQL Server
  493. access report
  494. gray-out and lock one subform record among many in datasheet view... HOW?
  495. Need code to update tables on server database
  496. Need Access Clipboard help ...
  497. Need Help With Query
  498. Relationships reappearing in query design
  499. Delete relationship
  500. Help for Acc. 2003 dev. extentions needed
  501. Private versus public variables and error handling
  502. stupid report question
  503. creating Multiple subforms
  504. Help with ADO Connection needed please
  505. Table Structure help
  506. Table normalizing help/suggestion
  507. Date search problem
  508. Running in Runtime
  509. Open form to Pivotchart view
  510. Open form to Pivotchart view
  511. Problem with exporting/importing
  512. access replication problem
  513. Compatibility
  514. Combo box for a parameter query
  515. Properties Submenu For Custom Men Won't Come Up
  516. Create a Query on a Hyperlink
  517. Help with calculation in MS Access
  518. date reference from loaded form
  519. Joe Celko Nested Sets
  520. Report
  521. Importing Text File
  522. Help with table design
  523. data has been changed error message
  524. Multiple formats in query
  525. Fill out a PDF Form from Access
  526. Help with building an access database.
  527. Why won't Access Run this Query?
  528. Resize Form Controls and Subform Controls at the same time
  529. DB Structure help
  530. PLEASE HELP... SQL SERVER Query in Access
  531. Form resize alse requeries?
  532. Populating Recurrsive TreeView in ADP using ADO
  533. Menus overwritten "bluetooth device not found"
  534. Linking a different table hyperlink to each form record
  535. Active Directory and DFS
  536. Backup database access
  537. relatively new to database
  538. adding a column to a linked table
  539. WinXP-A97: Can't start mailsession
  540. Access Security?
  541. Disconnected mapped network drive
  542. Slightly more complex SELECT query syntax in A97
  543. Error looping through controls on form in Access 2003
  544. Reset Auto Number Fields
  545. Is this valid syntax (A97 VBA)?
  546. Trying to show data in report columns by year
  547. Strange symptom - Auto switching to Chinese keyboard input
  548. I need advice on some Stephen Lebans' code
  549. Change Text Box Display in Reports
  550. Displaying the Input mask when entering a control