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. Change default controls in "stock" dialog
  2. Bill and Microsoft Making an Impact on Cyber Crime
  3. summing records
  4. memo records don't copy complete
  5. Report Size
  6. Dont show blank pages in print preview in report
  7. Is there a faster way
  8. total or sum function?
  9. Simple Query question
  10. Really confused about Digital Certification for Access Apps. Advice?
  11. Really confused about Digital Certification for Access Apps. Advice?
  12. Selection by non-alphanumeric characters
  13. normalizing help
  14. Populate combobox
  15. Replacing non-alphanumeric characters
  16. Need help designing an update query
  17. Understanding Recordsets
  18. Record selection with combobox and record navigation buttons
  19. Update query
  20. Disable Application Restore Button
  21. Open .pdf without warning
  22. A simple example of reattaching one table by VBA
  23. Variable # of columns being output by a Crosstab query
  24. Downloading large table
  25. Large text boxes
  26. Using Japanese vs. US version of Access
  27. Printing a record from a current form
  28. Drop List Question
  29. VBA question - how can i retain the double quotes from a text file after opening it through a recordset?
  30. Reference a field labels caption?
  31. Dynamic Crosstab...SOS
  32. Interesting Problem......... or not so for the advanced, lol
  33. Combining databases
  34. Could someone point me in the right direction to use DAO to list all forms, their textboxes and two properties for each textbox?
  35. Securing both front end and back end
  36. interesting question - module - chart - form
  37. calculated text box
  38. data entry forms writing directly to the tables?
  39. How to prevent Access app from closing with X button?
  40. ODBC access driver
  41. Programmatically copy custom shortcut menu bars (command bars)?
  42. Multiple users, selecting unique record from table
  43. Store Array to Access w/o Parsing Each Row
  44. Showing the difference between two times in Hours, Minutes and Seconds
  45. Where are the Access Developers?
  46. Best alternative to MS Access on a shared drive
  47. If Statement in an Access Report
  48. Clear a combo box on error?
  49. import or link from Excel disfunction
  50. MSACCESS.exe process does not stop when user exits Access (revisited)
  51. Checking For Internet Connection
  52. Cannot open a database created with a previous version of your application (Office 2003)
  53. Access Form: lock user on text field ...
  54. StartRow in Import/Export Specifications
  55. Methodology
  56. On record change
  57. Union Query
  58. Kallal-printercode - works with Citrix?
  59. Access to Arcview 8.3 GIS link
  60. A97 InputBox controls - how to limit?
  61. Simplest recommendation for filtering records returned in a combo box on a form?
  62. Allen - Your report list box
  63. Set Subform sourceobject and recordsource
  64. Mysterious "Sub or Function not defined"
  65. Report: how to get rid of border
  66. help on converting front end for web/browser access
  67. Run an ArcGIS VBScript in MS Access
  68. E-mail from within Access
  69. Passing Information
  70. Preview a PDF?
  71. Sql Server 2005 and Access 2005?
  72. A2003 corrupts - 97 didn't
  73. declaration
  74. MS Graph versus pivot graph?
  75. If Clause
  76. comparing arrays
  77. Contents of a Hyperlink Control
  78. Decimal Data type in Jet DDL SQL?
  79. A few more questions - saving, canceling, object control
  80. A2K - update query needed
  81. Multiple Instance of a form limite
  82. Editable query / continuous form with aggregate fields: how?
  83. Filtering in Sub Report
  84. SubForm is not visible
  85. How to determine whether module is class module?
  86. Is there a "browse" dialog? not to be confused with Open File
  87. A2K - limit on lines that can be printed in immediate window?
  88. Jump from a Form to a control (filed) in a SubForm
  89. query
  90. Insert a space into postcode
  91. Whats the best way to add a bit of a help file into an access file
  92. Track date of Updated records
  93. VBA in SQL -- finding near duplicities
  94. Sub-groups in a field
  95. making virtual fields along with real fields in select statement
  96. filtering a query by values in multi-select list box ?
  97. The Wizard is unable to create your report
  98. e-mail link in form
  99. Displaying MEMO fields
  100. Displaying MEMO fields
  101. Need Help around
  102. report with different structure
  103. problem with Update query that has to fetch the values from another table
  104. Yes/No field
  105. Commit : database changes in Ms access.
  106. Commit : database changes in Ms access.
  107. SELECT MAX(field) FROM table BUT MAKE SURE IT IS NOT LESS THAN 2000
  108. Programmatically changing RecordSource - too risky?
  109. Combining two text field into a long list
  110. Calculating Strait Line Depreciation
  111. Combo Box design question
  112. Selected controls on a form in design mode with VBA
  113. ODBC: How to install Access 2.0-Drivers when Access 2003 is installed
  114. Email list into BCC field
  115. OLE automation: Excel Template question
  116. Intrinsic Constant Definitions
  117. how to import text field from MySQL db to MS Access 2003 using ImportXML
  118. official certification
  119. open database
  120. Update new Password to table via Forms & Macro
  121. A2K - how to create my own unique internal employee id
  122. 'X' button on the form top right
  123. Record x of y
  124. information about ActiveX controls
  125. MDB file bloats while updating records
  126. locked table
  127. How big can an Access table be?
  128. A2K - simple append of one record to another table needed
  129. How to display a query in a list box using a record set?
  130. Seems simple - But how (Stored procedures)?
  131. Removal of Internet (web) bar at the top of the window
  132. mail merge date problems
  133. problems with totals in pivot tables and poivot charts
  134. File system error
  135. Why not use lookup wizard?
  136. Getting the user profile folder
  137. 2 data files for mail merge into WORD?
  138. Wonder how to open debug-window from A97 VBA?
  139. Printing to hDc in VBA
  140. Date time picker - findrecord based on value
  141. Screwed up syntax
  142. Combining Columns
  143. Copy a string to clipboard via VBA
  144. summing on a form
  145. Misbehaving text box
  146. Combo box, command button placement questions
  147. Ecology and Access
  148. Missive
  149. INSERT Question
  150. Setup: One Serial and Multiple Installed Software
  151. Printing a detail of a single record (ie report)
  152. Scheduling Query/Clashing Events
  153. Print a external file
  154. Access and FTP
  155. Changing Password using forms without userlevel security
  156. automating the import of a xls file
  157. I didn't know this could be done (rename the Detail section of aForm)
  158. HELP NEEDED ASAP - Updating table row by row (ADP)
  159. Access query
  160. query criteria
  161. Making choices in a subform
  162. Append Query problem
  163. Sub keeping ACCESS.EXE open
  164. [odbc] Retreiving full unicode data using Access ODBC driver.
  165. Suppressing popup message after a TransferText
  166. building a custom query using check boxes on a form
  167. Hyperlink to jpg files - nothing happens (?)
  168. mousemove over subform
  169. Help! Trying to change code to use Application Object
  170. OnTimer event interval - I need to run it when form is opened
  171. Including all cases
  172. Link an image on the web to appear on a form
  173. Listbox - how to tell if item unselected?
  174. Behaviour of the form filter option in the toolbar
  175. enable controls on tab control form
  176. Event When User Clicks On A Control On A Tab's Page
  177. Count query
  178. Conditional Formatting in a Form
  179. Building an Activity report
  180. A97 changes the link child and link master fields on a subform control w/o consulting or informing me
  181. Should I repaint subform or mainform?
  182. Building Access Apps with User Definable Fields
  183. Is there a way to display current date and time on form?
  184. A fairly dense form needs real estate. Don't have it. Want to resize ONE control only
  185. center a form on display
  186. Table of Contents stopped working (MDB -> ADP)
  187. append question
  188. maximaal aantal records uit query laten zien
  189. Enter line feed in Search+Replace?
  190. Why would a DCount of FieldName in saved query return a number greater than number of rows in qry?
  191. textbox cursor placement
  192. Placing the Same Value In Multiple Forms
  193. Report error
  194. Relinking problem
  195. Access table OutPutTo Word bookmark
  196. Complex Query Keeps Running Not Returning Data
  197. Complex Query Keeps Running Not Returning Data
  198. Add picture to Wrd Doc
  199. Compacting on A2K vs A2002
  200. table relationships
  201. Experience with Visual Studio Tools for Office?
  202. Problem using mixed data from Excel
  203. creating a delete button
  204. Run code in report
  205. Speed benefit calling source db from query?
  206. Convert Text to Int
  207. Mystery number 9360 in report
  208. DLookup("[PVIN]", "tblPreliminaryVINs", "[PVIN]=Forms!frmVINODO!SerialNum")
  209. mixed languages and JET sp8 ...
  210. Removing "marks" from database
  211. Turning Excel data into a 1-M relationship
  212. Adding new records in bulk
  213. Connecting to Outlook PST or Exchange in a distributed application
  214. Arcmap
  215. Tricky Scneario
  216. FORMATTING THE FONT OF AN EMAIL MSG
  217. run access.exe on server side
  218. Redmoving a spreadsheet and replaicing it through Access
  219. help with a difficult query
  220. highlight keywords in search result
  221. Maximize form on open
  222. NotInList problems
  223. Access to ASP/VB.net converters
  224. Bypassing a dialog
  225. Linking Forms
  226. Can't repoint linked tables
  227. Subform and .dataentry property issue
  228. First MACRO executed in an Access application
  229. Now()
  230. numbers rounding up in table
  231. A2K3- quick SQL help needed
  232. Transferspreadsheet Trapping Error for Duplicate records
  233. Help Creating Small Table In Memory
  234. Dlookup problem
  235. new record
  236. A97 - how to transfer a file from https?
  237. Why is it a bad idea to create new databases or tables every year??
  238. page breaks, printing and vba
  239. Summary query causes Access to crash
  240. Displaying a Cross Tab query on a Form
  241. Updatable query - Many to Many
  242. Need configuration help
  243. Group Data/Copy Row Two Field to Row One Field
  244. network error connection
  245. Why does fso.MoveFolder fail with "Permission denied"?
  246. Find the last number of a record
  247. simple function record into array
  248. Access VBA project locked
  249. SQL Server - Filter
  250. Whut I dew?
  251. Array Help
  252. Array help
  253. SQL Format leading zeros
  254. form layout
  255. struggling with a query
  256. Array help
  257. Default Survey in AT YOUR SURVEY form
  258. Access links, hyperlinks and headaches!
  259. field that uses the now expression for date and time does not enter the data into my table. Why?
  260. ucase or an expression that makes lowercase letters turn to uppercase automatically
  261. ucase function
  262. General sort order
  263. MS Access 2002 problem: linked form fields in ODBC queries
  264. Outlook Contacts
  265. Compact db corrupts link to another
  266. Search for plain text variables in word document
  267. Locate plain text variables <*> in word doc
  268. Back Style Property on Tab Controls: Disabled?
  269. access field merging
  270. How to change the properties of Text box depending on the value of combo box.
  271. Locate plain text variables <*> in word doc
  272. Search for plain text variables in word document
  273. Help needed on picture files in access
  274. Search for plain text variables in word document
  275. Database Schema
  276. Corrupt VBA project in the database
  277. Cannot access form fields from VBA
  278. AppPath in A97?
  279. run-time error 3073
  280. A2K3: design for pupil incidents database, help needed
  281. Week number to date??
  282. Create A List Of Dates In A Month
  283. How to control scanner from Access?
  284. New to ODE 97 Help Workshop Utility - How to compile a short test topic file?
  285. Transparent background of image on A97 report becomes opaque when printed. Hmmm?
  286. Lookup Date Table for Mising Date
  287. Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB
  288. How do I setup a Countdown Field in Access 2003 Form
  289. Is a txt file Read-Only?
  290. Date Countdown Field
  291. linear Interpolation of data in a tabel
  292. Seeking opinions on code that utilizes internal represention of dates
  293. Maximizing Access Report From VB
  294. append issues: clear table code?
  295. How do I handle this referential integrity situation?
  296. How to use OutputTo with named query?
  297. Autonumber Format/Reset/Etc.
  298. Continuous Form
  299. Indexing Service and Access Files
  300. SQL query - combine sum() with getting latest record by date field
  301. radio button/combobox focus
  302. Insert OLE object in Access 97
  303. Graph/Range help needed...
  304. copy value from previous record!
  305. Access database used as OS interface?
  306. Linking Databases - Methods?
  307. linear Interpolation of data in a tabel
  308. cannot lock database
  309. Automatic Date Entry
  310. windows dialer and access
  311. Query and display record number only in a webpage
  312. a97 - problem transfer file from server with https
  313. Could Not Lock File Error 3050
  314. Week form
  315. Screen resolutions needed for development enviroment
  316. Could Not Lock File Error 3050
  317. WeekDay help
  318. Access Report to multiple PDF files
  319. merge with word using query with user entered paramiters
  320. Why does Alt-Return bring up properties sheet?
  321. Putting MS Access on the Web
  322. Why did Access just close when I tried to save a form
  323. POST to website with authentication
  324. replace Rs.AddNew with INSERT
  325. Passing search parameters with hyperlink to an ASP page
  326. odbc timeout
  327. SQL syntax - leading zeros
  328. Merge to MS Word
  329. Export Filtered Form to Excel
  330. Digital Signature for Access 2003 Project
  331. Changing Data Type - Text to ReplicationID
  332. Data Entry Only Form
  333. help with funtion (expression builder)
  334. graph
  335. design question
  336. One table or three?
  337. Modules Access 2003
  338. Modules Access 2003
  339. Interpolate data from tabel
  340. Update Links
  341. Autogenerating chart
  342. A funny problem to have
  343. Set background color of a column in a subform in datasheet view
  344. sorting between two spreadsheets
  345. Change "lookUp Method" to code used in a linked table
  346. How to have the face of button changed when pressed?
  347. Images w/ transparent background in Access?
  348. Which hardware upgrades are more important
  349. Create folder inside Queries & Forms Tab?
  350. Where can I find reference documentation for Access?
  351. Problem with Query data in report
  352. A2K - how to detect any change to a database to avoid unnecessary code execution
  353. Can I read the value of a textbox control on a report?
  354. Converting student scores to grades not that easy?
  355. "docking" forms
  356. Strange problem loosing data based on physical machine
  357. A2003 - Tab to Tab Focus
  358. how to update new password to existing table in a custom login form using macros or query?
  359. which approach? (cofused with tables)
  360. Creating dynamic sql
  361. form controls not really null??
  362. Line intercept - mschart
  363. Using combo box element as search criteria
  364. reading data in to Access From Excel
  365. How to automate PaperPort?
  366. availability of Jet DB engine on Win 200, XP, Server 2003
  367. Weird NotInList behaviour
  368. availability of Jet DB engine on Win 200, XP, Server 2003
  369. availability of Jet DB engine on Win 200, XP, Server 2003
  370. Search multiple MS Access database files via asp.net web application
  371. Basic query question regarding parameters and grouping.
  372. Autoincrement versus GUID
  373. Programatically accessing "object groups"
  374. Multiple database problem in A2003
  375. Report/Form event "On No Date"
  376. Queries with identical SQL code behave differently (one is expandable)
  377. Add column color in datasheet view
  378. Add a defined number of records to a table
  379. creating email attachments
  380. Access to Quickbooks
  381. Add record in grouped data access page
  382. Is David Fenton right about error handling? (re-post?)
  383. Access autopopulating field based on condition
  384. Is David Fenton right about error handling?
  385. Tooltips not working
  386. reselect random items
  387. Linking databases using ADO
  388. setfocus and report creation problem
  389. Best solution? (too few parameters. Expected 1.)
  390. Problems while making MDE
  391. export to excel with criterias
  392. #Name? Error... trying to link two fields in same form
  393. MS Access to Oracle Database Conversion
  394. Subreport visible property
  395. Field on Form = next record
  396. Validating "Orders" form
  397. Subvalues -- like submenus? How can I do it?
  398. No fields selectable for report
  399. calling C# .Net dll from VBA
  400. Create table from query?
  401. How to add a record in ms access
  402. How to add a record in ms access
  403. Unbound Nested Subform Simulating Continuous Form
  404. different permission for different users for password using tables and forms
  405. Need help with accounting database
  406. Active X not in Toolbox
  407. Which is best - recordsets/VBA V SQL statements for updating data
  408. How do you record multiple values into a column??
  409. File Name in Add-In Manager?
  410. Moving data from one list box to another via a button
  411. ??? for Wayne Gillespie on FTPClient Class Module.
  412. MS Access: a true RDBMS
  413. How to get cursor focussed on field field after new record?
  414. After closing Design View, the table appears instead of form
  415. Autonumber ID not yet visible when starting new record
  416. attaching picture to table
  417. Happy New Year
  418. Erl
  419. Change event trigger
  420. detail section in a report
  421. Licensing versus Customization
  422. Importing Text File that is vertically oriented
  423. After insert of date how to auto jump to next field
  424. Only get 1st record viewed in Report.
  425. DAO peculiarity in A97?
  426. Calculate Date Difference and display message box
  427. rendered date
  428. VBA for ACCESS
  429. Find and Replace against set of rules in 2nd table
  430. Carry data over to new record...
  431. =Iff(([Me]![Gender])="M","Male","Female")
  432. Edit multiple tables with one form per record
  433. Help with blank fields
  434. Help needed with ONLY VBA Code or Query
  435. Year Numbers
  436. Report / Query Problem
  437. Reports
  438. Using MZtools Freeware for VBA
  439. Run Update Query silently in background
  440. Run Update Query silently in background
  441. Create Macro to import fixed width text from clipboard or text file and update table
  442. reset number on new year
  443. Runtime error has occurred
  444. Creating Runtime DBs with Access
  445. move relationships from dev to production db
  446. How can I Display Visio Drawing?
  447. one to many howto????
  448. ComboBox Progressive Requery
  449. Minimized Database window moving way off screen
  450. merging tables
  451. navigate form with arrow keys
  452. calculating age from DOB and adding to table
  453. close form macro
  454. slow query
  455. Combo Box Progressive Requery
  456. How to increase the performance by working with linked tables
  457. Help with SQL query
  458. Clearing a combo box
  459. Hyperlinks inside an Office Assistant bubble?
  460. Hyperkinks inside an Office Assistant bubble?
  461. SendKeys help required
  462. subform refresh
  463. How to import..
  464. Adding a range of numbers from a form to a table
  465. datepart problem in VB code
  466. Problem with DateDiff
  467. add one to string in sql query
  468. Access 97 / XP sharing problem
  469. 2 Beginner Access question
  470. Reversing a COlour Code
  471. Sorting a SubForm
  472. Trouble with order by clause in report
  473. Off Topic - Access to Postgres
  474. TransferDatabase problem
  475. Nulling field in subform
  476. Tips to document Access program
  477. Lebans ReportToPDF solution Help
  478. Date Validation: IF's vs Case
  479. Probably a very simple problem, but it's got me...
  480. Adobe Acrobat & pdf.ocx - The Paperless Office
  481. failure in saving new added field
  482. A very basic search form in access
  483. 2 queries OK by themselves, FAIL in Union
  484. How to store folder path as Hyperlink?
  485. VB code to perform custom query of MS access table and display alert
  486. Run-time error
  487. Access Report is giving extra blank pages
  488. data in a tex field on an unbound form
  489. trying to copy an Access 2003 pivot table to excel or word .... or something
  490. 'Converting Varchat to Int' problem
  491. Relationships
  492. Not sure I understand what Response.buffer is really about
  493. MS Access adding dates
  494. Create Dynamically Built Data-Entry form to enter data into two tables
  495. Timeout while DDE linking to a VB application.
  496. query not working when i add an alias
  497. Runtime version overwrites full access
  498. calling excel function LinEst from VB
  499. Access to VB
  500. How to do a hyperlink inside of ...
  501. Choose Month & Year when giving report criteria
  502. Synchronising/replicating access with sql server
  503. serialize/deserialize Access report object
  504. Choose Month & Year when giving report criteria
  505. Pivot Tables Access vs Excel
  506. Use Select Query variable against a table and return value to same select query
  507. DeleteDuplicateRecords
  508. Progress Meter does not refresh during series of OpenQueries
  509. How to join two fields
  510. Left(field,Numchar) or Right not found
  511. Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
  512. NZ always returns a zero-length string when used in a query expression?
  513. backup databases
  514. Access 2003 unable to link to ODBC but 2002 on same machine can
  515. Duplicate record check
  516. Hyperlinks
  517. Sending SMS from Access
  518. UserForms
  519. forms only show primary key
  520. Scroll bar strangeness on subform
  521. Calendar Control turns white on new record
  522. automatically append new records
  523. OldValue not set
  524. form property for subform
  525. Help required formatting a date field in a SELECT statement results
  526. A2K3 & object dependency refresh
  527. What's with ADO?
  528. Assigning common id based on evaluation of two columns
  529. Select ALL from an unbound form for query parameters
  530. Totally lost on Date Sort
  531. Crosstab Query: Sort Column heading based on other column sort
  532. Cross tab Query: Sort Column Heading based on other column Sort order
  533. Split Database Security Problem
  534. Query has a problem with December??
  535. error -2147217904 - how to fix :o( ?
  536. A2K - passing more than one value into a popup form
  537. MS Access, PostgreSQL 8.1.1, connection string
  538. ODBC, connection pooling
  539. Using seek to find if a record exists
  540. error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
  541. Can lines collection be used to assist me in automatically numbering lines?
  542. GetSetting function breaks when code-signing
  543. Invisible textboxes on subform
  544. Database design question
  545. Filtering on a form
  546. Checkboxes verses field list boxes
  547. How to pull the newest record for each student out of a table
  548. after update not triggered
  549. OT. Happy Holidays to you all
  550. Opening form in datasheet view