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. graph
  2. design question
  3. One table or three?
  4. Modules Access 2003
  5. Modules Access 2003
  6. Interpolate data from tabel
  7. Update Links
  8. Autogenerating chart
  9. A funny problem to have
  10. Set background color of a column in a subform in datasheet view
  11. sorting between two spreadsheets
  12. Change "lookUp Method" to code used in a linked table
  13. How to have the face of button changed when pressed?
  14. Images w/ transparent background in Access?
  15. Which hardware upgrades are more important
  16. Create folder inside Queries & Forms Tab?
  17. Where can I find reference documentation for Access?
  18. Problem with Query data in report
  19. A2K - how to detect any change to a database to avoid unnecessary code execution
  20. Can I read the value of a textbox control on a report?
  21. Converting student scores to grades not that easy?
  22. "docking" forms
  23. Strange problem loosing data based on physical machine
  24. A2003 - Tab to Tab Focus
  25. how to update new password to existing table in a custom login form using macros or query?
  26. which approach? (cofused with tables)
  27. Creating dynamic sql
  28. form controls not really null??
  29. Line intercept - mschart
  30. Using combo box element as search criteria
  31. reading data in to Access From Excel
  32. How to automate PaperPort?
  33. availability of Jet DB engine on Win 200, XP, Server 2003
  34. Weird NotInList behaviour
  35. availability of Jet DB engine on Win 200, XP, Server 2003
  36. availability of Jet DB engine on Win 200, XP, Server 2003
  37. Search multiple MS Access database files via asp.net web application
  38. Basic query question regarding parameters and grouping.
  39. Autoincrement versus GUID
  40. Programatically accessing "object groups"
  41. Multiple database problem in A2003
  42. Report/Form event "On No Date"
  43. Queries with identical SQL code behave differently (one is expandable)
  44. Add column color in datasheet view
  45. Add a defined number of records to a table
  46. creating email attachments
  47. Access to Quickbooks
  48. Add record in grouped data access page
  49. Is David Fenton right about error handling? (re-post?)
  50. Access autopopulating field based on condition
  51. Is David Fenton right about error handling?
  52. Tooltips not working
  53. reselect random items
  54. Linking databases using ADO
  55. setfocus and report creation problem
  56. Best solution? (too few parameters. Expected 1.)
  57. Problems while making MDE
  58. export to excel with criterias
  59. #Name? Error... trying to link two fields in same form
  60. MS Access to Oracle Database Conversion
  61. Subreport visible property
  62. Field on Form = next record
  63. Validating "Orders" form
  64. Subvalues -- like submenus? How can I do it?
  65. No fields selectable for report
  66. calling C# .Net dll from VBA
  67. Create table from query?
  68. How to add a record in ms access
  69. How to add a record in ms access
  70. Unbound Nested Subform Simulating Continuous Form
  71. different permission for different users for password using tables and forms
  72. Need help with accounting database
  73. Active X not in Toolbox
  74. Which is best - recordsets/VBA V SQL statements for updating data
  75. How do you record multiple values into a column??
  76. File Name in Add-In Manager?
  77. Moving data from one list box to another via a button
  78. ??? for Wayne Gillespie on FTPClient Class Module.
  79. MS Access: a true RDBMS
  80. How to get cursor focussed on field field after new record?
  81. After closing Design View, the table appears instead of form
  82. Autonumber ID not yet visible when starting new record
  83. attaching picture to table
  84. Happy New Year
  85. Erl
  86. Change event trigger
  87. detail section in a report
  88. Licensing versus Customization
  89. Importing Text File that is vertically oriented
  90. After insert of date how to auto jump to next field
  91. Only get 1st record viewed in Report.
  92. DAO peculiarity in A97?
  93. Calculate Date Difference and display message box
  94. rendered date
  95. VBA for ACCESS
  96. Find and Replace against set of rules in 2nd table
  97. Carry data over to new record...
  98. =Iff(([Me]![Gender])="M","Male","Female")
  99. Edit multiple tables with one form per record
  100. Help with blank fields
  101. Help needed with ONLY VBA Code or Query
  102. Year Numbers
  103. Report / Query Problem
  104. Reports
  105. Using MZtools Freeware for VBA
  106. Run Update Query silently in background
  107. Run Update Query silently in background
  108. Create Macro to import fixed width text from clipboard or text file and update table
  109. reset number on new year
  110. Runtime error has occurred
  111. Creating Runtime DBs with Access
  112. move relationships from dev to production db
  113. How can I Display Visio Drawing?
  114. one to many howto????
  115. ComboBox Progressive Requery
  116. Minimized Database window moving way off screen
  117. merging tables
  118. navigate form with arrow keys
  119. calculating age from DOB and adding to table
  120. close form macro
  121. slow query
  122. Combo Box Progressive Requery
  123. How to increase the performance by working with linked tables
  124. Help with SQL query
  125. Clearing a combo box
  126. Hyperlinks inside an Office Assistant bubble?
  127. Hyperkinks inside an Office Assistant bubble?
  128. SendKeys help required
  129. subform refresh
  130. How to import..
  131. Adding a range of numbers from a form to a table
  132. datepart problem in VB code
  133. Problem with DateDiff
  134. add one to string in sql query
  135. Access 97 / XP sharing problem
  136. 2 Beginner Access question
  137. Reversing a COlour Code
  138. Sorting a SubForm
  139. Trouble with order by clause in report
  140. Off Topic - Access to Postgres
  141. TransferDatabase problem
  142. Nulling field in subform
  143. Tips to document Access program
  144. Lebans ReportToPDF solution Help
  145. Date Validation: IF's vs Case
  146. Probably a very simple problem, but it's got me...
  147. Adobe Acrobat & pdf.ocx - The Paperless Office
  148. failure in saving new added field
  149. A very basic search form in access
  150. 2 queries OK by themselves, FAIL in Union
  151. How to store folder path as Hyperlink?
  152. VB code to perform custom query of MS access table and display alert
  153. Run-time error
  154. Access Report is giving extra blank pages
  155. data in a tex field on an unbound form
  156. trying to copy an Access 2003 pivot table to excel or word .... or something
  157. 'Converting Varchat to Int' problem
  158. Relationships
  159. Not sure I understand what Response.buffer is really about
  160. MS Access adding dates
  161. Create Dynamically Built Data-Entry form to enter data into two tables
  162. Timeout while DDE linking to a VB application.
  163. query not working when i add an alias
  164. Runtime version overwrites full access
  165. calling excel function LinEst from VB
  166. Access to VB
  167. How to do a hyperlink inside of ...
  168. Choose Month & Year when giving report criteria
  169. Synchronising/replicating access with sql server
  170. serialize/deserialize Access report object
  171. Choose Month & Year when giving report criteria
  172. Pivot Tables Access vs Excel
  173. Use Select Query variable against a table and return value to same select query
  174. DeleteDuplicateRecords
  175. Progress Meter does not refresh during series of OpenQueries
  176. How to join two fields
  177. Left(field,Numchar) or Right not found
  178. Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
  179. NZ always returns a zero-length string when used in a query expression?
  180. backup databases
  181. Access 2003 unable to link to ODBC but 2002 on same machine can
  182. Duplicate record check
  183. Hyperlinks
  184. Sending SMS from Access
  185. UserForms
  186. forms only show primary key
  187. Scroll bar strangeness on subform
  188. Calendar Control turns white on new record
  189. automatically append new records
  190. OldValue not set
  191. form property for subform
  192. Help required formatting a date field in a SELECT statement results
  193. A2K3 & object dependency refresh
  194. What's with ADO?
  195. Assigning common id based on evaluation of two columns
  196. Select ALL from an unbound form for query parameters
  197. Totally lost on Date Sort
  198. Crosstab Query: Sort Column heading based on other column sort
  199. Cross tab Query: Sort Column Heading based on other column Sort order
  200. Split Database Security Problem
  201. Query has a problem with December??
  202. error -2147217904 - how to fix :o( ?
  203. A2K - passing more than one value into a popup form
  204. MS Access, PostgreSQL 8.1.1, connection string
  205. ODBC, connection pooling
  206. Using seek to find if a record exists
  207. error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
  208. Can lines collection be used to assist me in automatically numbering lines?
  209. GetSetting function breaks when code-signing
  210. Invisible textboxes on subform
  211. Database design question
  212. Filtering on a form
  213. Checkboxes verses field list boxes
  214. How to pull the newest record for each student out of a table
  215. after update not triggered
  216. OT. Happy Holidays to you all
  217. Opening form in datasheet view
  218. CurrentDb problem in report
  219. Need to add trailing 0's
  220. Problem with Left function
  221. Query Shows No Records
  222. Developing in Access 2003 with conversion problem
  223. setfocus to access application
  224. Packaging for multiple office versions
  225. MS Access Send To recipient (not as attachment but as HTML)
  226. A97 Runtime - I wish to disable F-11 key from displaying database window
  227. Sorting many fields in a form
  228. How can I enter several lines of text as a criterion and return several lines from my table?
  229. access 2003 validation rules
  230. lInking subforms
  231. Unable to edit form - Many-to-Many relationship
  232. What is a Library mde/mdb?
  233. on open and before exit events
  234. Access2000 data Entry Unbound Form With Subform
  235. Contingent formatting
  236. Developing in Access 2003 for Access 97 users
  237. Saving information on reprot to new table?
  238. How to stop library mde being reused
  239. Can't link forms
  240. An aid to inserting a Date, Small calender pops up
  241. Scroll bars are not appearing in certain situation.
  242. Customer keeping track of invoices received and paid.
  243. Access 97 Problem: only one printer shown in the printer screen
  244. Picture Importing
  245. TransferText dropping fractions
  246. Is Access smart enough to optimize this ?
  247. pasting records in datasheet-form: pass-through called twice ?
  248. Horizontal Scrollbar
  249. coloured lines of alist box
  250. Set Warning? Maybe?
  251. Need help on updating text box!
  252. video rental database?
  253. Making MS Access Form as a standalone form like in VB
  254. Can anyone recommend a Dot Matrix printer for my DB?
  255. Run external application script from access?
  256. problems with DSN for MS Acess database
  257. Reading image files from a URL location
  258. MS Access 2003 sending emails
  259. better way
  260. HELP 97 -> 2K and lost all relationships
  261. Help with a query trying to total!
  262. Subtract MULTIPLE time segments from a single time segment to calculate cycle time
  263. ControlTip Text
  264. Trouble With Left Join
  265. Dlookup
  266. mappoint looses forms focus
  267. Combo Box Recordsource When using CodeDB
  268. dcount, dsum, dlookup question (not syntax)
  269. Forms - pagebreak Visibility
  270. NetSearch the Business Intelligence Search Engine
  271. Creating a checklist from a table to indicate attandance
  272. hide form on startup
  273. Can't figure out error in simple dsum
  274. Data Conversion Error
  275. subform within a subform
  276. Help in generating a report
  277. make table query
  278. Can a variable hold 2 values simultaneously - a string value and a numeric?
  279. VBA Query code issue........
  280. Connect 2 subforms
  281. Dynamicaly created where clause for OpenForm
  282. Access versus MSDE versus SQL Server Express
  283. Database design - incorporate year of a certain event
  284. Error 3075 Function Not Available - but no missing references
  285. Strange findfirst behavior
  286. How to vary the number of copies of each record in a report in A97?
  287. Forcing Cursor To Specific Record/Field On Continuous Screen?
  288. Goodies in 2003?
  289. SQL Insert Into Error
  290. Parsing
  291. Transferdatabase
  292. how to determine whether any report is opened?
  293. I've never seen A97 combo-box wizard fail on a valid query until today...
  294. Key based on Login entry
  295. Listbox value does not change
  296. Properly using checkboxes in a datasheet form
  297. HIPPA - HealthCare Cliam Transactions
  298. Can you import images into access
  299. Export MS Access table via OBDC using VB
  300. real record in a subform
  301. mixing linked tables
  302. Input Mask for dateformat dd/mm/yyyy hh\:nn
  303. A97 - Forms - Rail Road Track layout
  304. Copying root directory
  305. Windows Explorer Switches
  306. 2 Combo Box Menu from Multiple Query
  307. pivot chart
  308. Sending report to a PDF File. Good link for Access developers
  309. Function DatePart(), how to subtract the month from a date field
  310. entering data from form into two tables
  311. Combo box dependent on another combo box, text part is blank
  312. gtotal
  313. attaching MsSQLServer(msde2k) tables to Access2k
  314. Trying to total a text box in report
  315. Update an account balance on a daily basis
  316. several questions regarding graphs
  317. recordset.MoveLast - "not enough space on temporary device"
  318. Backend on the internet?
  319. Execute database to Excel exportation stored procedure from VB
  320. query how to
  321. open excel file
  322. open excel file
  323. Updating combo box
  324. dynamically create Tab Control possible?
  325. Setfocus question
  326. default value help
  327. Table exceeding one million rows crashes Access
  328. Filtered Colum To Single Comma Delimited Value??
  329. MS Access forum
  330. Default sort order
  331. Analyze Tool & Lost Data
  332. Add value to subform from main form
  333. Datasheet View: Second Combo Box Criteria Based on First Combo Box Value
  334. Access Reading and writing emails
  335. ftp from Access: problems
  336. Help with a report field
  337. Subject: Access Reading and writing emails
  338. Access fails if printer is out of paper
  339. Removing duplicates from query, but not from table
  340. I have carried out the Keith Wilby stepwise approach to securing an MDB but I am not sure what I have achieved
  341. Loosing Db connection?!?!?!
  342. Text becomes available when check mark is placed
  343. How to Test Function in Immediate Window
  344. Self join. Employees and supervisors query.
  345. Access 97, W2K, "can't open the mail session"
  346. Help with query to extract next best product
  347. Securing only certain forms?
  348. Printing to a dot matrix printer
  349. Enhancing the FAQ. Please suggest enhacements....(new topic, getting closer...)
  350. VBasic window opens with references grayed out
  351. Sum of Sum in Totals Query
  352. Trouble with concatenated string function
  353. Opening one database always restores a minimised database
  354. vba to activate a command button in a different though open form
  355. invalid operation
  356. The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record
  357. Arrays in Access.
  358. Can't get subform on tab control to requery
  359. Query help!
  360. Forms: attaching labels to a combobox
  361. move next
  362. Need help with ValidationRule
  363. Suppression of auto-fill-out of MS-ACCESS
  364. Getting the right software without getting ripped off
  365. auto email
  366. Creating a dynamic form, how?
  367. I wish knowledge as to creat a Bibilical data index i.e. Genesis to Revelations not alphabetical!
  368. Form navigation buttons do not show correct position
  369. How to Compress/zip files from MS ACCESS and then send it by email?
  370. Returning orders
  371. how to know the record position shown in a form?
  372. configuring access for all users
  373. MOST recent date
  374. Help! Public variable not staying set - 3420 Object invalid or no longer set.
  375. Combobox Not In List Event
  376. Proper use of global variables for reports
  377. Report question?
  378. Syntax for password protectd database...
  379. #error in report w/linked tables
  380. Sending data to Excel
  381. Updating via internet
  382. Novice Question - I wish to modify the data in multiple feilds
  383. Leaving debug.print statements in a database intended for runtime?
  384. general db design question
  385. Different type conversion A2k and A97 ?
  386. Outdated help (feat. Access '97 and VB4)
  387. Delete existing before running Open "c:\MyFile.txt" For Output As #1 ?
  388. YearFrac Year Fraction Calculation
  389. Code compiles, mde creation fails
  390. error setting a subforms recordsource from another form
  391. Odd error setting a form's recordset property
  392. Any reason to favor calling a batch file VS running a CMD directly in A97 VBA?
  393. Query runs fast once, then very slow
  394. Database Password
  395. Changing relations with VBA code?
  396. Method for updating production backends with new tables/fields
  397. Find first and last element of a column in a table
  398. Display text field for current record only......
  399. Access as Automation Server - Problem declaring Form 'withevents'
  400. How to Recover your lost password for Microsoft Access 95/97/2000/XP/2003 database ?
  401. Access and Images - Linking image table to a record table
  402. Can I waste your time please
  403. Healing
  404. How do I set an Aggregate SQL statement result to a control?
  405. Linking to tables in Firebird or other db
  406. Listbox Question
  407. Tab Control Question
  408. Compatability of A2000 and A2003.
  409. Could use so code help!
  410. Bookmarking
  411. Container Graphics not acting as expected
  412. Relationships design
  413. Having a tough time re-deploying proper System.mdw
  414. How do you adjust a form to open from the top?
  415. Automation Slower Than Windows Explorer
  416. TO ALL SUPPORTERS OF ARNO R AND HIS GOONS
  417. wrong result from recordset
  418. Launching an OLE Application From a Form
  419. OpenRecordset method
  420. Help with microsoft access for making schedules
  421. Can a MDW file which relates to a specific app be deleted?
  422. Subforms and Search Function
  423. Checkboxes
  424. How to Zip Files from ms Access
  425. Strange one: A2K2 wont recognize break points
  426. How to zip files from MS ACCESS
  427. Looking for Access Reporting Add-ins
  428. disabling close button for application
  429. Database doubles in size, when forms deleted even when compacted!
  430. How to tell if there is no selection in a DataCombo box?
  431. Capturing FTP responses in VBA?
  432. Changing order of columns in a table
  433. Wanting to give users 3 options
  434. Microsoft Off 11/Off 9 Reference
  435. Copy selected records and save as new rec with user input
  436. Multiple recordsets continued
  437. Attachments lost/reset once public db variable is set to ""
  438. To link or not to link
  439. New to access. stumped on query. Column to Row conversion Any ideas?
  440. Local Table vs. Class for Public Variables with simple types
  441. Multiple Vehicle Mileage Calculation
  442. In case you ever get an error 2455
  443. How do I change the keyboard input language from within Access 2000?
  444. File Transfer Animation
  445. Find Primary Key field
  446. Linking Checkboxes to values in a table for a Report
  447. Automatically printing to Adobe Acrobat
  448. OraOLEDB.Oracle provider missing
  449. Getting data from excel spreadsheet column into access table
  450. Report Help
  451. run sql query for each record in a contious form
  452. Ok this is a strange one
  453. SET NOCOUNT ON; Multiple Recordsets; ADO Command Text
  454. Look at this
  455. Curious about Access 12 Report Formatting
  456. Circular relationship nightmare
  457. print ourt labels
  458. Import Paradox database into mdb issue
  459. Automate printing reports to PDF
  460. Automating a command button to do a Get External Data command
  461. Super easy word merge
  462. DLookUp Problem
  463. database variables problem
  464. set up two criteria in one command button
  465. Finalizing the dialogue with newsgroup Megalomaniacs (change of Subject...)
  466. HELP - Using GoToControl in subforms
  467. Remove Filter/Sort
  468. Database security (crosspost)
  469. Encrypted database
  470. Conversion: Access 2000 to Access 2003
  471. Subtracting Dates
  472. Multipage Form
  473. Active X controls problem
  474. Dumb Question
  475. Edit format of field in a form that can be populated by a lookup
  476. How to extract just the time portion of DateTime
  477. Validation q's - subform BeforeUpdate event (and SQL)
  478. Code not producing desired result
  479. TransferText and Missing/Skipped first line - Solution
  480. Drop Down List
  481. Navigation buttons
  482. sql password with access query
  483. multiple selection
  484. multiple selection
  485. Can't update data in a query
  486. Word and Excel Objects in Access Reports
  487. Evals("myPublicVariable") do nor work: have you any alternative way?
  488. I am gathering the date of my customer..
  489. Dialogue with newsgroup Megalomaniacs (change of Subject...)
  490. is the access database able to be converted to SPSS date?
  491. subquery problem
  492. Display full name in combo box
  493. Get list of custom properties
  494. Switching between two columns in a form viewed as datasheet
  495. Horizontal grouping
  496. Multiple Recordset from a Stored Procedure
  497. From ListBox to Subform -- , how to add SQL statement?
  498. the switch statement has got me a little confused..can someone clear this up for me please
  499. Mailing Labels
  500. Select INTO ListBox
  501. Form border color
  502. Confirm/commit insert in ADP project
  503. Help with a list box
  504. ODBC: SQLTables does not return data for an Access database?
  505. OpenRecordset help needed
  506. Aiuto per formato data
  507. filtering and edit
  508. Error occurs when MS Access open Excel document and trigger the assigned macro in Excel
  509. SHELL handling a switch.....
  510. Explanation???
  511. Form opens SLOW when "Allow Addtions" set to No
  512. How to connect MS Access form to MS SQL Server
  513. I'm trying to completely unsecure an A97 app
  514. Please Help --Adding a Primary Key to a Table with over 180K records
  515. Pasting multiple lines of data into text box - how do I divide it into seperate strings??
  516. Query works in Access but not with exec call from .net
  517. A message to Self-Appointed-NewsGroup-Netiquette-Enforcers... PLEASE LEAVE US ALONE!
  518. Load Form?
  519. Need help on seeing data in form
  520. MS Access Query Export Error "Too Few Parameters. Expected 1"
  521. QBF problem with multiple combo boxes
  522. If Statemet
  523. What kind of replica?
  524. closing a db with an error
  525. MS access: Book recommendations
  526. Import data and changes from access to access
  527. editing data in pivot table
  528. Help please! Add or remove from field value through a form
  529. Text Field default value based on function...
  530. Programaticaly populate a sub-form
  531. Pass Through Query Nightmare (Access 2K --> SQL Server 2000)
  532. How can I stop people have access to my MS Access Tables and Queries via Import?
  533. Learn SQL?
  534. Mappoint app or activex control?
  535. beginer with problem
  536. Simple MS Access Update ... Wont Update
  537. Plot a data series along a secondary value axis
  538. Intel Software to boost Access' performance
  539. Re-appearing dlls and type libs.
  540. Field for Number of records in a query
  541. change form property using SetValue
  542. Query to display number count
  543. Browse and Store Filename
  544. Browse and Store fileaname
  545. clsReadTextFile
  546. Access 2k3 / WinXP Issue = kooky join
  547. Keeping track of jointly owned assets
  548. 50,000 Ft Question
  549. query
  550. Test