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. How do I restrict my results?
  2. Body for e-mail
  3. Reconcile Query Wizard Add-In For Access 1.2
  4. SQL Help (Please)
  5. Playing Sound Clip
  6. comp.databases.ms-access
  7. Strange behaviour on startup when project is signed
  8. Open a 2nd form from a 1st form and keep the same rs and current record
  9. database worksheets?
  10. Access help!
  11. USING DLOOKUP TABLES
  12. RECORD LOCKS
  13. UPPER CASE
  14. csv export file and international settings
  15. Query With Many Checkboxes
  16. Need to send a directive to linked database
  17. Like Clause
  18. rolling average
  19. Access on the Net ?
  20. What Access Runtime files are needed to deploy? (2002/XP)
  21. Please help: How to concatenate fields in querie??
  22. Columns
  23. Hoogste waar de in een kolom
  24. Problems with HTML Imports
  25. MyControl.text in form without record
  26. How do I disable automatic save of my project as I build my database in access?
  27. lost mdb
  28. Sorry ....Using Access 2002 object lib. in Access 2000...
  29. Using the 2002 Access Lib. in Access 2003 .....
  30. Table Index Construction
  31. An NT Security Gotcha that looks like a Jet Security issue
  32. Requery a subform from a lbo - how?
  33. Help with validation feature`
  34. Function to return quoted value?
  35. Postcodes
  36. Using data from one Access database in another
  37. security: user level vs. group level
  38. A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field
  39. Does not import all data?
  40. PDC2005: Anything new for access?
  41. ldb file and Exclusive Access question
  42. Condition Format in Multiline Textbox
  43. Multiple Date Ranges in a Report
  44. Check to see if a button has been clicked on a form
  45. Union Query and Filter By Form, Access crash
  46. Remove dash from soc sce #
  47. Finding a specific record
  48. public variables
  49. No Current Record
  50. SQL multiple statements?
  51. Access not working (can't query or create report)
  52. Help with Report Design
  53. MSAccess query error
  54. A97 - 5 records in a recordsource query cause 5 pages to print out
  55. A97 question regarding closing a report
  56. docmd.openform where condition problems
  57. Changing a Label Caption in a report
  58. Conditional Format With VBA
  59. Keeping empty subreport visible
  60. Very basic problem
  61. math problem with dates.....
  62. Exploring use of Dir("\testdir\nul")
  63. Looking for users of a niche product
  64. modified snaking columns
  65. ODBC--call failed
  66. Access Runtime/Access Full Version
  67. How to transfer *.dbf (many files)
  68. listbox in endless form
  69. Manually changing a linked table location
  70. How can I set value in function that returns array?
  71. How to remove last digit for inputted value?
  72. Appending records to a table from a form filtered recordsource
  73. Using Code
  74. report errors
  75. report error
  76. report error problem
  77. report error problem
  78. Print Tree View
  79. Help Needed With Corruption Problem
  80. Using Unbound Textbox as parameter
  81. Font Size in Query SQL View?
  82. A2002: Activate Event
  83. Security settings for downloaded databases
  84. Hyperlink
  85. Issue with Make-table query - Will this HURT?
  86. Autonumber Oddity
  87. Synchronize SQL Server with Access MDB?
  88. Help with filter
  89. Converting positive number to negative number
  90. I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
  91. concatenate two records in same table
  92. concatenate two records in same table
  93. Problems with Date conversion from text format into date/time...
  94. How to remove Lookup property from table field with VBA?
  95. shorten time to attempt to connect to back end
  96. OnNoData
  97. UCase not working in A97 runtime installation...
  98. 2 questions
  99. Linking Images using VBA code
  100. Conflict with Webroot's Spy Sweeper
  101. Intermittent missing reference problem
  102. Decimal places.
  103. Credit card number rounding?
  104. Output Stored Procedures as text problem
  105. Unable to set subdatasheet to None
  106. Error "You don't have the license required to use this ActiveX control"
  107. problems dealing with dates in my queries/SQL code
  108. Partial Replication of Data
  109. Access 97 and counting the occurrences in a string
  110. Reports opening differently on client/my machine
  111. Email reports?
  112. Searching a Field containing OLE Objects Returns Inconsistent Results?
  113. Adding to lookup list automatically
  114. Help with error message
  115. SQL - JOIN or nested query?
  116. Refer to class-properties (A97)
  117. Linked tables in a query giving no results
  118. Linked tables in a query giving no results
  119. Managing controls on subform
  120. How to unhide a specific form or database window in A97?
  121. A97 closes down each time I open a particular report. Anyone know the meaning of this?
  122. Access Developer's Handbook 2002: Tagged Values
  123. Problems migrating to XP
  124. Looking for a copy of ODE97
  125. Update foreign key before appending records to central database
  126. ONLY NUMBERS
  127. How to read .iif file of Quickbooks using vb or any code
  128. Themed Tab Control work-around
  129. combo boxes
  130. default value taken from other filed
  131. How to read .iif file of Quickbooks using vb or any code
  132. no data on a form
  133. SIMPLIFYING WORDS IN A TABLE
  134. Multiple Record Copy Transaction...
  135. time attandance system
  136. Embedded Images
  137. Concatenate 3 lines of text into a "Paragraph"
  138. Stored Procedures?
  139. VBA functions to create a PDF rectangle with a shadow
  140. Problem with form
  141. Help for C# Interview questions and career decision
  142. joining queries
  143. Code for finding name of relationships
  144. How to programmatically determinae the field name referenced by query param?
  145. Automatic backup's Access 2003 database
  146. Change a lot of words in a table
  147. DCount.
  148. A97 error #3067 occurs when it really should not
  149. How to fill a for automaticly(just some boxes)
  150. I need a personal code library
  151. Null Values or Wierd Behavior based on a user's profile
  152. Form for 2 tables
  153. Alternative to lookups in tables - questions
  154. Transactions for linked SQL Server Tables?
  155. Saving ODBC SQL database to "local" mdb?
  156. Include word doc(s) in report
  157. Data Access Page problem
  158. problem - open recordset - ADO
  159. question about % in reports
  160. DAO 3.51 and DAO 3.6
  161. Access Treeview - Is it Safe Yet?
  162. MDAC
  163. How to use parameterized query with DAO Recordset?
  164. Change Focus triggers Before Update
  165. PostCode-Zipcode
  166. compare tables
  167. Linked Tables, access security help.
  168. "Too many Fields" error running query with <255 fields
  169. Use not local admin Outlook Fails
  170. ie 6.0 and Access2k
  171. Understanding ODBC connections...!
  172. Using nested subform
  173. Linking Tables in Access
  174. A97 - How to automatically export a table to ms excel data-file from within code?
  175. Invisible Query Head-Scratcher
  176. numeri
  177. Upsizing
  178. How to supress message when dynamically setting Report recordsource
  179. Problem deleting ldb file
  180. Foreign Key with multiple columns and null value
  181. exporting access data to excel for calculations and reporting
  182. Unlock/edit a database...
  183. Like criteria
  184. requery a subform on a form
  185. Generating an Index
  186. How to get a query to pick up the value of the active form
  187. A2003 Backend opens in read-only intermittently
  188. &Relationships Bug - workaround
  189. How to set Startup Properties in MDE?
  190. In trouble! Db locked with exclusive access
  191. How to put controls on a form with VBA code
  192. If a field is keyed in, then delete other fields
  193. setting fields based on values of other fields
  194. Table Structure - Using Query with Form for Input
  195. compare two tables using this module?
  196. Ordering fields in query based on current date
  197. How to send emails from ms access..
  198. Modems and Access2003
  199. How to parse CITY ST ZIP+/-4
  200. Allowbypasskey property
  201. Append to master replication table
  202. Open a DB from the switchboard of another DB
  203. Only add Valid Payments on a Report.
  204. Calculate Number of Years, Months and Days between 2 dates
  205. Oracle 9.2 attached table real slow and data incorrect with Access 2003 SP1
  206. Lock an access db
  207. Printer / Report issue with Office XP over Network
  208. Can't Import a .dbf File
  209. Default combo box line
  210. Setting field properties in code
  211. REPOST: Unique connection ID not name.
  212. Creating new field in code
  213. Using combo boxes to fill in other bound controls not working..
  214. restoring default printer
  215. Trouble moving Access tables to SQL back End
  216. Enter Parameter Value showing up when already defined
  217. Assign textbox value from command button
  218. How do I refresh a control
  219. How to handle with "&" in text
  220. A97: MediaPlayer.MediaPlayer.1 control on a form - how do I use it to play a .wav file
  221. A97 - I've been looking for a position counter to display on a form the current character position of cursor
  222. Payroll DB
  223. Won't let me remove tables
  224. A97 overflow error returned when trying to calculate 192/(24*60*60) - why?
  225. A97 - how to format time lapse to appear as "4-minutes 12-seconds"?
  226. combo box choices
  227. How to speed up reading input from a text file?
  228. Split master table into smaller tables
  229. DoCmd.SendObject acSendNoObject Inserting Hyperlink in message containing a space.
  230. Need help to read database contents - very tricky
  231. How to Update ignoring validation rule
  232. A97 variable length string declaration - how to do?
  233. check box changes subform operation
  234. acCmdInsertHyperlink defaults "Browse for" File
  235. Catastrophic noob... can anyone help?
  236. ComboBox source query: run at Form_Open
  237. Access hanging periodically
  238. How to display multiple pictures per record in an Access database?
  239. Cancel Click Of Check Box
  240. 'Invalid bookmark' or 'database engine stopped the process' errorswithout corruption?
  241. Unique connection name?
  242. Mixing two Image samples by Lebans
  243. Access and vba in excel
  244. FE & BE Version Control Tips?
  245. Determinaition of Paramatric Queries
  246. using query results to populate a list or form
  247. Combo Box - NotInList Event - need help
  248. How do I link a control to the value in a form?
  249. Help needed w/Crosstab Query and Col Values
  250. Finding the current computer name in VB?
  251. AddItem not adding columns to listbox
  252. How to compute age in a query?
  253. Simple question about Cancel Event
  254. Accessing list of files from disk
  255. MDE Don't work
  256. Preparing for .NET Interviews
  257. How can I run an insert query on report
  258. Second Request - Can I return a value from an ACCESS report to VB?
  259. OpenRecordset & 3027 read only error
  260. Set a variable equal to the result of an sql query
  261. Question about moving Access app to web
  262. format for naming recordset field
  263. Display a report in a form...
  264. Determine if user has local admin rights in VBA
  265. Please Please Help!
  266. Find how many similar records..
  267. File already in use
  268. Problems Subclassing in Donors/Donations DB
  269. How to use static variable to exit function?
  270. How can an AutoNumber field start at some other value
  271. Put four queries into one
  272. Using combo-box as a user filter - trying to use format to display text "all" for null values
  273. Effects on RST in Calling Proc
  274. How to influence two tables with one form
  275. Access 2000 date range using today's date
  276. Build comma-delimited list from table
  277. Outlook mailitem
  278. Evaluating Complex Recordset Field Statements
  279. Compute Name , Is it a good idea to use it for copy protection?
  280. Predifined text and starting from the last record(in a form)
  281. Does ACCESS have the MINUS keyword
  282. Form_Dirty is not firing
  283. Parameter Query and Date calculations....
  284. Slow Update Queries
  285. Check box controls subform control source formula
  286. Subform not allowing creation of new record
  287. user permission
  288. MS Access Database with Remote Desktop - Multiple
  289. Error trapping code
  290. A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
  291. converting ACCESS to Stata using Stat/Transfer
  292. dirDataCopy error message when converting to Access 2000
  293. Comverting Dates
  294. Left Join Not Supported - translated from legal SQL statement
  295. Tables Queries Criteria oh my!
  296. Transferspreadsheet File Name Limit
  297. Tree view adding duplcate keys
  298. Is it possible to open an Access Macro as a recordset in VBA code
  299. VBA to Word problem
  300. Running code in one form from another
  301. Duplicate query recordset
  302. Lock Down Titlebar in Form
  303. Keywords
  304. Access 97, XP and 3170 Couldn't find installable ISAM
  305. Full menus
  306. Trouble working with not between
  307. mail merge
  308. mail merge
  309. mail merge
  310. Importing Excel Spreadsheets Into Access 97
  311. Date format cannot be controlled
  312. Date format cannot be controlled
  313. Problem with inner join
  314. Set and restore permissions using VB?
  315. Calculating the dwell time between two Records
  316. Control format property in OnFormat event
  317. Can A2k co-exist on a Machine Running A2k3
  318. edit word document
  319. How do I refer to a series on an MSgraph in access?
  320. Concatenating text fields with a WHERE condition
  321. Anyone use Visual Studio Office Dev Extensions?
  322. How to open default email program when I store some email addr. in a field?
  323. hiding record navigation button in forms
  324. raport and null problem
  325. IIf Function based on field value of continuous form
  326. TransferText
  327. Drawing objects in Access 2003 - can it be done on forms?
  328. delete all text starting with ..
  329. Help with counting occurances of similar text
  330. Before Update
  331. Help with an SQL query (opposite to a union query - if it exists)
  332. File Not Found error when importing forms from another database
  333. Adding Incremental Records
  334. Date Conversion
  335. running an update query from form...can I just use the sql cmd
  336. subform question
  337. backend corrupt
  338. Handling Apostrophes
  339. can someone tell me what I am missing with strings
  340. Need check box to change formula used in subform source
  341. Combining two queries
  342. Display one to many records in a mail merge
  343. I used to see a menu item/short cut menu to translate macros to code
  344. locking down tables
  345. Blank Form
  346. Adding a column in report
  347. Help with simple database concept
  348. Open the Outlook Addressbook in VBA
  349. Exporting To XML File
  350. AppHelpFile key and context-sensitive help
  351. Tab Form and 'cannot open more tables error'
  352. Report in Table Format?
  353. Help with VBA syntax please
  354. New Access / SourceSafe Bug Discovered
  355. Query Corrupted? - Access 2002
  356. Need help writing a double click event procedure
  357. Attaching Document
  358. Memo field not large enough
  359. Creating ODBC Data Source automatically?
  360. how to check list box
  361. Need help parsing a string - reverse Val?
  362. Check box changes formula used in subform
  363. how to open code builder for default when click on event builder in forms
  364. Export Query To XML
  365. Form colors in Access XP look goofy when converting
  366. Importing Excel
  367. Displaying and modifying 1:N data in forms?
  368. How to delete the missing References for VBA
  369. Some fields of a table are not visible in the design view
  370. Accessing a Report properties without opening it
  371. Option Button bug?
  372. Control Reference
  373. Aggregate function error
  374. Arvin Meyer's Good Article For Beginners
  375. Elookup vs Dlookup, Error 3048
  376. ComboBox using SQL code
  377. Migration to Postgres
  378. Front end grows when saving
  379. Cannot Delete access file
  380. [ODBC] How to compact a base ?
  381. continuous form buttons with different images (from table)
  382. Pr4int Preview Vs Print
  383. Help? Subdatasheet bug 'You can't hide a control that has the focus'
  384. How much to charge
  385. Missing references in VBA code
  386. Missing references in VBA code
  387. the form jump after a AfterUpdate Event
  388. How can I disable a reference library with VBA code
  389. We aim to please
  390. How do i hide a group footer if it's the only group?
  391. Database as Variable for Param query
  392. Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
  393. Protect MS ACCESS DATABASE
  394. Trim/Remove Unwanted Spacing In Text
  395. Linking to an external library with VBA code
  396. How can I concat the name of a control in a way that I can refer to it in code?
  397. Read Outlook emails using Access
  398. Anyone wrote VBA for calc'ing determinant of 3x3 matrix?
  399. Combo Box Display Problem
  400. posting 20050827
  401. repost calling a subform from another form(not main form)
  402. calling a subform from another form(not main form)
  403. How do you boot connected users from your database ?
  404. Repost : Reading a Text File
  405. Wont find infomation from table
  406. Verify Jet SP
  407. Sort Is Not Working
  408. PDF
  409. Requery
  410. Queries/joins with more than 2 tables
  411. generating sequencial numbers
  412. Concatenate text fields in query
  413. ER diagramming wish list: send a request to Microsoft
  414. Microsoft Scripting Runtime
  415. Problem with my chart in MS Access 2002 using a form and VB
  416. opening and closing IE
  417. Combo-box not displaying all entries
  418. Weird parameter prompt appearing after creating a subreport
  419. how to print (or not) the contents of a textbox in a report
  420. Embedded Pictures
  421. record lookup
  422. postcode finder, lookup,search
  423. Disk or network error
  424. Current concensus on using WSH libraries from Access
  425. Text too large to be in a field
  426. How to move to item in ListBox?
  427. permissions to import after a new workgroup file?
  428. making and refreshing local lookup table
  429. How to increase the response time by working with linked tables
  430. RE-linking to back end
  431. Annotated Calendar
  432. Microsoft Scripting Runtime Reference
  433. Ownership ?
  434. Conversion Map for Field Type and Field Format
  435. How to automate this import
  436. Need Help Checking Values in one table against two min max values in another
  437. Generate String and output to textbox in report
  438. Returning a number from a hex value.
  439. Reference Error: Difference between UK office and US office?
  440. Change f-e links to replica?
  441. Strange Problem doing DOS Dir Command in VBA Help Please
  442. checking input in inputbox
  443. DLookup Problem
  444. Access 2000-repeating data for labels based on # in a table
  445. Tossing someone off of the internet.
  446. Macros and fields in a table
  447. Does the physical path of a library matter as long as it's registered?
  448. problem with a LIKE query
  449. Group BY - Maximum Fields
  450. How to sort an array of string
  451. Finding an Installable ISAM
  452. Any known issues with UTF8 and UCS2 unicode???
  453. Setting Updatable Property of QueryDef to False
  454. Conditional display of records based on user's multiple selections
  455. Calculated total on subform will not display on main form
  456. Displaying (scrolling to) a specific record in a continuous form with VBA
  457. Access 2k/2003: Touble with delete query using WHERE EXISTS
  458. Updating records in a related table
  459. 'VB in Access' and SQL: Library Management
  460. 'VB in Access' and SQL: Library Management
  461. copy comment from access-table
  462. NULL data increases table size
  463. A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
  464. ARGH! Type Mismatch on Set Recordset
  465. MDI background color (detail) - XP
  466. Accounting
  467. Dumping query result into Excel spreadsheet
  468. Why this 2467 error?
  469. How to test the contents of a field or control?
  470. field is wiped out without warning
  471. No underlying data to support subform
  472. Is there an easy way to enlarge an Access report ?
  473. No underlying subform data to go by
  474. Extracting format info from database
  475. Form design for staff schedules that vary..
  476. ListBox displays values, identical ComboBox does not
  477. Picture
  478. Problem programaticaly importing tab delimeted xls file
  479. Change default table colors
  480. Change default table colors
  481. Form/Subform
  482. Problem turning off action messages in runtime - append query not working
  483. Assigning Values to Imported Data
  484. A2K - how to extend default cursor position to ALL textboxes?
  485. Bypass entering password to ODBC data sources
  486. Not returning Memo field
  487. .mde on different Office versions
  488. ActiveX demos
  489. Enter Key Behaviour
  490. dbo qualified name error in Access 2003
  491. Consensus on using PDA software with Access
  492. How to limit records displayed in ListBox?
  493. Who is in my database?
  494. How to tell if a form is open?
  495. Registering MPE with Access 2003
  496. Open Form when DB starts
  497. Acess developer researching non-Access web based database
  498. IsNothing() IsEmpty() : Why i can not find it in Access 2003 Visual Basic For Application?
  499. Problem with AutoExpand - Still Need Help
  500. API to Access Active Directory Organizational Unit Membership
  501. Change icon in task bar - Please help!
  502. Criteria For Subform Combobox Rowsource
  503. matching with duplicate references
  504. 60 GB IPOD deal found
  505. Toolbox
  506. Prevent Custom Menu From Appearing
  507. Verify Existence of Field Names before Opening Form
  508. "VBA project is corrupted", Access2003--Access2002
  509. Disabling menu option
  510. Recordset problem due to corruption?
  511. Can corruption cause this?
  512. Exporting data to excel via macros
  513. Error sending email
  514. Opening a file
  515. Extract information from various web sites
  516. FORM function no longer work after upgrade from 97 to 2003
  517. Code Issues
  518. Trivial query?
  519. UPDATE query results not written to database
  520. determining dimensions of image in a layer
  521. Access to CSV translation/Conversion Programmer needed...
  522. Mailmerge via Automation in Access.
  523. ADODB Connection String with password
  524. Create Custom Expression Builder / Calculation Engine
  525. Populating fields from a separate table
  526. UPDATE query not happy with date fields
  527. Adding Appointment to Outlook Public Folder
  528. Simple Running Tally
  529. Letter Search for field
  530. Keeping total of items entered
  531. Assigning an access key to a command
  532. How can I remove hard returns (CR + LF) in a memo field string?
  533. 'Data type mismatch error' using Mid function in a query
  534. Concurso
  535. add record for each text box entry
  536. Problem w/AutoExpand in Combobox
  537. Assigning Values to Imported Data
  538. Display image on form via network path.....
  539. Pass through query to stored procedure
  540. adding records to table from text box values
  541. running Access Read Only
  542. Auto FE updater - Wkrgrp problem.
  543. Subform creates duplicate records in Main Form
  544. Filter a form on a field in a subform two levels deep
  545. Toolbar launch of the Print Dialog
  546. Strip File Name & Folder Name from path.....
  547. How to use DAO 3.6 DLL
  548. AccHelp future development - discussion please
  549. SendObject & Thunderbird
  550. Accessing a DB on a file server through ASP on the Web Server