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. Flicker
  2. How to prevent to enter duplicate record?
  3. Unbound text box, text>255, MS Access/PostgreSQL
  4. #error in form footer sum
  5. update from using ms access query
  6. Used SQL Upsizing Wizard, Application No Longer Runs
  7. Or in the Of clause
  8. Need help with connection string in OpenDatabase
  9. Jet 4 Replication Service Pack
  10. combo / form help please
  11. linking tables to different databases
  12. Help with schema.ini file
  13. Need to change LASTNAME, FIRSTNAME MI to FirstName M. LastName
  14. How to establish connection to TCP port 13 on a remote server from within VBA?
  15. Again...problems with date settings in IsDate function
  16. Best practices for canceling out of a report?
  17. A97: I want a simple text capture on a website (IE, Edit, Select All, CTRL-C)
  18. Oracle Automated Login via MS Access
  19. Walk Multi Select List Box A2003
  20. saving database to winzip file
  21. Help~
  22. Refreshing Page
  23. How can i make a fiels reset on every date change,and auto increasing?
  24. Scheduling beer trucks into timeslots with sufficient performance
  25. How can i make a fiels reset on every date change,and auto increasing?
  26. New record from a join query
  27. Data Access Page?
  28. How best to set current system date/time in A97?
  29. source of CURRENT event for subform?
  30. adsfsadfsadf
  31. sadfdsaf
  32. function to convert word document into HMTL
  33. Creating custom Input Masks...
  34. How can I call a form's event using a string
  35. How to create a access runtime?
  36. Unduplicated count of a table
  37. Cash register Access database
  38. forum
  39. PT Tables
  40. csv file line length limit
  41. Ask before saving record
  42. Appending from 2 multiselect listboxes
  43. Using a button to populate another form's auto# field.
  44. Record Selector Macros
  45. Regarding input masks
  46. Form Should open Maximize
  47. Access Validation Rule Question. Help Greatly Appreciated.
  48. Access and word mail merge
  49. UI Metaphors for complex criteria selection
  50. txt to mdb
  51. Open form as Data Entry with Customer Info
  52. Linking Relationship tables problem
  53. Damaged File/Print... menu option
  54. How can I input a name into a reprort
  55. How to have field values transported to fields in another form?
  56. Access using .Net Datagrid
  57. Encrypted password field in Access database
  58. Encrypted password field in Access database
  59. Help!
  60. Access Run Time Error 6 Overflow
  61. IIF acting funny
  62. ODEUNST.EXE???
  63. Is it difficult for a hidden form to check for user activity every 15-seconds or so?
  64. A-97 Alzheimer moment... what were the basic components of securing an app?
  65. Can not open database file
  66. Update Query with User-defined function?
  67. Query base on a changing table
  68. Sendin emails through Microsoft Access
  69. Copying a value from subform to main form
  70. Bang vs. Dot - final answer
  71. Output To vs. Transfer Text Options
  72. Reading and Writing Folder Properties
  73. Question on Error Message
  74. Access to ASP
  75. Will Stephan Lebans answer questions about his Calendar 'control'?
  76. How to copy a value from one form to another by button?
  77. Open a different Word doc for each record?
  78. How to join 2 different database files?
  79. Quick, simple question with Access Database Form
  80. Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
  81. running vba code in a loop
  82. Time Picker Control
  83. A2K networked DB "already opened exclusively by another user"
  84. Access12
  85. Strange Time-Formating Problem
  86. access and sql server via odbc
  87. A2K Subreport disappears in Access XP
  88. OT NNTP in VB
  89. How to Remove <BR> in Fields
  90. Strange Email Problem
  91. RAM USAGE
  92. What does this query do?
  93. Looping A Specified Number Of Times
  94. distinct records
  95. Subform with Query
  96. visible flag: datasheet versus form view
  97. sorting a crosstab query
  98. Changing to owners permissions using VB
  99. Subquery Sum by Date Range
  100. Making a button appear pressed in?
  101. AUTOMATE EMAIL ADDRESS IN ACCESS?
  102. adding empty rows to the end of a report
  103. reference subroutine from another form
  104. Modify Access MDB Application
  105. double prompt for value in report
  106. Over the years, I've used query wizard to list duplicate entries...
  107. Macro security level
  108. Macro Data Entry in a multi-row Subform
  109. linking subform master/child fields problem
  110. Problem linking Child/Master fields correctly
  111. Run-time error 2465
  112. Read Only
  113. Use other value from table
  114. Filtering report and subreport from form
  115. Field type corruption?
  116. Can a multi user Access db be used via Terminal Services?
  117. Default Fonts
  118. Creating sample data & MDB file size?
  119. Error 430, CopyFromRecordset with DAO 3.6
  120. Slightly O.T. - seeking documentation of the microsoft user interface specification
  121. Linking form - Report
  122. Query criteria - limiting the records - question
  123. Sequential numbering of a record collection
  124. code doesn't work on some PC's; does on others
  125. GROUP BY problem in access
  126. circular dependency between subforms, problem cased by subform loading order
  127. Continuous Form: Changing .BackColor depending on value?
  128. validation rules
  129. mde
  130. Using wildcards in Crosstab Queries
  131. Overdue warnings in Access
  132. Can a control on a Datasheet have a scrollbar?
  133. Error msg when adding a new record to a subform
  134. Removinc and installing A97
  135. Pages In Subform
  136. adding Record autonumber problem
  137. OLAP Server Problem
  138. OLAP Server Problem
  139. Exporting From Access to a Dbase iV. via Object. Fails with error The Microsoft Jet Database engine could not find the object
  140. Number of users opened MS-Access.
  141. Consecutive Invoice Review
  142. Help on report..
  143. Mail Merge to an existing document
  144. Tough SQL objective - pulling data from 4 different tables
  145. field in subform
  146. Why do IT guys hate MS Access?
  147. Help wanted - how to merge two tables with different information.
  148. Programatically Populate New Database With Tables
  149. Missing Parameters in report
  150. MouseWheel event does not trigger
  151. Appending? Creating? Help!
  152. error 3021 no current record, only sometimes
  153. assigning a listview control to a listview object
  154. Insert Object- Scanner recognition
  155. Slightly O.T. - need a printer I can use on a specialty database app
  156. Field Totals
  157. Weird combobox error in subform
  158. Conditionally select fields in SQL statement. Possible?
  159. Error at last record in form while displaying count
  160. Saving datasheet layout in .mde
  161. Find the faq
  162. How to enumerate every record in the subform?
  163. Simple listbox question
  164. Convert string expression to value?
  165. fatal error trying to close form from subform via code
  166. fatal error trying to close form from subform via code
  167. Custom Error Message Fails to Work
  168. How to do a Transfer Text Batch Group
  169. Greenwich Mean Time (GMT) in Microsoft Access 2003
  170. Looping through forms then the controls.
  171. Referencing an object description in VB
  172. lost page tab
  173. Programmatically Import Toolbar
  174. Access 2003 Possible Corruption?
  175. Recordset problem
  176. Runtime Report Editing
  177. crostab query
  178. Summing Queries?
  179. Yes No field on form and query
  180. tab control record/ data exchange
  181. Scrolling back records on a data entry form...
  182. Report footer
  183. Data Transformation among Microsoft Products
  184. Rant
  185. Automatically add new records
  186. Automatically add new records
  187. Add a cell formula in Excel via vba from access
  188. Autonumber
  189. Report size
  190. Add rows to top of existing spreadsheet
  191. Relationships decision to be made...
  192. How do I find the MSAccess.exe file path??
  193. Read dBase IV
  194. Looking for matches, adding to match table
  195. Form/New Record
  196. XY (Scatter) Chart
  197. notepad file to ms-access compatible file
  198. Multiplication formula
  199. OLAP Problems in Windows Environment
  200. Code for controling FTP from Access VBA
  201. How can I interact with MS Access using a programming language like Perl?
  202. Help with parameterized queries
  203. Reading Global Address List in Outlook (CDO)
  204. submitted data not updated promptly with ms access
  205. I need help w/ Queries
  206. Date Query?
  207. Login in form text fields are filled out..
  208. Printer properties
  209. SubReport on Main Report Page Footer - Didnt think it would be so hard.
  210. Hide Duplicates flag?
  211. Access / ASP hacked insert
  212. Select query that won't run as Update query?
  213. Can A97 Be Installed On A WinXP Machine?
  214. How to work on home laptop, then update client's Front End?
  215. Comparing one date against a list of dates
  216. CutePDF. Pass file location?
  217. RegisterDatabase for AS400
  218. Open source "Tanning Salon" Application
  219. filtering the last date
  220. Using an SQL statement to convert date format where the field is NULL???
  221. Listbox: Use SQL + constant text string to assign values
  222. Total Access Analyzer?
  223. splitting text into characters ... HELP ME SPLIT
  224. Looping Query Defs
  225. Problema per creazione Rubrica...Help me!
  226. almost got the mail merge to work one problem
  227. Thanks for help today - new problem with recordset
  228. no read permission
  229. Run-time error '424': Object required - can't work out why
  230. Select multiple date fields from one table
  231. Picture on page
  232. IsNull() - I can't get it to work properly..
  233. The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
  234. A97 SQL capable of showing data from 2 different table records in a SINGLE output record in dynaset?
  235. Dynamic Crosstab Report Problem
  236. Change Caption Of Label In External Database
  237. Changing table permissions in VB Code?
  238. Using a picture (Form Template) as background in a report?
  239. A97 query question
  240. Snapshot viewer and Access 97 reports And Emailing
  241. Database Permission Question
  242. Text Box and 255 character limit
  243. The .Value of a Check Box
  244. Removing Items from a Listbox with Multi-Select enabled
  245. Adding Excel Object Library Reference Programmatically
  246. UI: Combo Box Max Records Recommendations?
  247. Update Query
  248. Creating self-join table
  249. disabled startup
  250. Globals and system instability
  251. Random Number in Query?
  252. report page layout help
  253. autonummering in table gives problems
  254. Autonumbers: Retrieve unused no's
  255. how to skip runtime error
  256. Printer Orientation and PrtDevMode MSDN example not working
  257. ORDER BY a SubSelect?
  258. Database creates another file when first opened? What causes this?
  259. help with update table
  260. Access 12 screenshot (my style)
  261. Relationship Link
  262. Run-Time error 3146
  263. DoCmd.RunCommand Equivalent for acFormBar, 7, 6, 0, acMenuVer70
  264. Using Vendor ActiveX Grid in MSAccess
  265. Set myTableDef = myDB.TableDefs(myTable) is so slow ....
  266. is stupid
  267. richtextbox loadfile problem
  268. Public variables reset on error, what's up?
  269. Find Primery Key
  270. Linked images don't refresh
  271. Pivot-Table Form vs MS Graph?
  272. Access Database through ASP
  273. Run-time error..
  274. Type mismatch error
  275. Compact a password protected MDB from a front end MDE
  276. Find and Replace special characters in a field
  277. How to stop an Access form from automatically saving a record?
  278. Formal Complaint
  279. Need a little guidance (beginner)
  280. Rename Table/subform Field Names
  281. OLE OBject Source Doc
  282. Linking table/query SQL
  283. Access Report
  284. How to check the status of a sub form
  285. Check on empty record set in VBA
  286. How to Lock the Page Setup in reports
  287. Display One-To-Many records in a Mail Merge
  288. Enter control
  289. Conversion to SQL Server backend
  290. Open images after double clicking them on form
  291. Custom table property to prevent overwrite?
  292. Moving a text box in a report at runtime
  293. Rotating label text in A97? Is it possible?
  294. error message 3343
  295. How do I write code to allow user of a runtime distro to select a DEFAULT printer?
  296. Input Parameter Query Window - Duplicated?
  297. problems compiling with Listview control
  298. Unable to create new records on linked tables over network
  299. Mail Merge Access 97 and Word
  300. Sum Subform Records in Mainform contol
  301. How to break out of loop from error handler?
  302. Sorting report by Quater
  303. Update Table
  304. Expression error
  305. Need Church database for small church
  306. Select top on 2 tables based on date?
  307. update, append query Joins being deleted.
  308. Unable to make form visible again
  309. export temp table to text file user side
  310. Users being locked out, unable to open file
  311. Application.Version
  312. Access 12 screenshot
  313. Help with DLookup
  314. DLookup return date from database
  315. CreateReport(, templateName) not coping report properly
  316. How do I restrict my results?
  317. Body for e-mail
  318. Reconcile Query Wizard Add-In For Access 1.2
  319. SQL Help (Please)
  320. Playing Sound Clip
  321. comp.databases.ms-access
  322. Strange behaviour on startup when project is signed
  323. Open a 2nd form from a 1st form and keep the same rs and current record
  324. database worksheets?
  325. Access help!
  326. USING DLOOKUP TABLES
  327. RECORD LOCKS
  328. UPPER CASE
  329. csv export file and international settings
  330. Query With Many Checkboxes
  331. Need to send a directive to linked database
  332. Like Clause
  333. rolling average
  334. Access on the Net ?
  335. What Access Runtime files are needed to deploy? (2002/XP)
  336. Please help: How to concatenate fields in querie??
  337. Columns
  338. Hoogste waar de in een kolom
  339. Problems with HTML Imports
  340. MyControl.text in form without record
  341. How do I disable automatic save of my project as I build my database in access?
  342. lost mdb
  343. Sorry ....Using Access 2002 object lib. in Access 2000...
  344. Using the 2002 Access Lib. in Access 2003 .....
  345. Table Index Construction
  346. An NT Security Gotcha that looks like a Jet Security issue
  347. Requery a subform from a lbo - how?
  348. Help with validation feature`
  349. Function to return quoted value?
  350. Postcodes
  351. Using data from one Access database in another
  352. security: user level vs. group level
  353. A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field
  354. Does not import all data?
  355. PDC2005: Anything new for access?
  356. ldb file and Exclusive Access question
  357. Condition Format in Multiline Textbox
  358. Multiple Date Ranges in a Report
  359. Check to see if a button has been clicked on a form
  360. Union Query and Filter By Form, Access crash
  361. Remove dash from soc sce #
  362. Finding a specific record
  363. public variables
  364. No Current Record
  365. SQL multiple statements?
  366. Access not working (can't query or create report)
  367. Help with Report Design
  368. MSAccess query error
  369. A97 - 5 records in a recordsource query cause 5 pages to print out
  370. A97 question regarding closing a report
  371. docmd.openform where condition problems
  372. Changing a Label Caption in a report
  373. Conditional Format With VBA
  374. Keeping empty subreport visible
  375. Very basic problem
  376. math problem with dates.....
  377. Exploring use of Dir("\testdir\nul")
  378. Looking for users of a niche product
  379. modified snaking columns
  380. ODBC--call failed
  381. Access Runtime/Access Full Version
  382. How to transfer *.dbf (many files)
  383. listbox in endless form
  384. Manually changing a linked table location
  385. How can I set value in function that returns array?
  386. How to remove last digit for inputted value?
  387. Appending records to a table from a form filtered recordsource
  388. Using Code
  389. report errors
  390. report error
  391. report error problem
  392. report error problem
  393. Print Tree View
  394. Help Needed With Corruption Problem
  395. Using Unbound Textbox as parameter
  396. Font Size in Query SQL View?
  397. A2002: Activate Event
  398. Security settings for downloaded databases
  399. Hyperlink
  400. Issue with Make-table query - Will this HURT?
  401. Autonumber Oddity
  402. Synchronize SQL Server with Access MDB?
  403. Help with filter
  404. Converting positive number to negative number
  405. I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
  406. concatenate two records in same table
  407. concatenate two records in same table
  408. Problems with Date conversion from text format into date/time...
  409. How to remove Lookup property from table field with VBA?
  410. shorten time to attempt to connect to back end
  411. OnNoData
  412. UCase not working in A97 runtime installation...
  413. 2 questions
  414. Linking Images using VBA code
  415. Conflict with Webroot's Spy Sweeper
  416. Intermittent missing reference problem
  417. Decimal places.
  418. Credit card number rounding?
  419. Output Stored Procedures as text problem
  420. Unable to set subdatasheet to None
  421. Error "You don't have the license required to use this ActiveX control"
  422. problems dealing with dates in my queries/SQL code
  423. Partial Replication of Data
  424. Access 97 and counting the occurrences in a string
  425. Reports opening differently on client/my machine
  426. Email reports?
  427. Searching a Field containing OLE Objects Returns Inconsistent Results?
  428. Adding to lookup list automatically
  429. Help with error message
  430. SQL - JOIN or nested query?
  431. Refer to class-properties (A97)
  432. Linked tables in a query giving no results
  433. Linked tables in a query giving no results
  434. Managing controls on subform
  435. How to unhide a specific form or database window in A97?
  436. A97 closes down each time I open a particular report. Anyone know the meaning of this?
  437. Access Developer's Handbook 2002: Tagged Values
  438. Problems migrating to XP
  439. Looking for a copy of ODE97
  440. Update foreign key before appending records to central database
  441. ONLY NUMBERS
  442. How to read .iif file of Quickbooks using vb or any code
  443. Themed Tab Control work-around
  444. combo boxes
  445. default value taken from other filed
  446. How to read .iif file of Quickbooks using vb or any code
  447. no data on a form
  448. SIMPLIFYING WORDS IN A TABLE
  449. Multiple Record Copy Transaction...
  450. time attandance system
  451. Embedded Images
  452. Concatenate 3 lines of text into a "Paragraph"
  453. Stored Procedures?
  454. VBA functions to create a PDF rectangle with a shadow
  455. Problem with form
  456. Help for C# Interview questions and career decision
  457. joining queries
  458. Code for finding name of relationships
  459. How to programmatically determinae the field name referenced by query param?
  460. Automatic backup's Access 2003 database
  461. Change a lot of words in a table
  462. DCount.
  463. A97 error #3067 occurs when it really should not
  464. How to fill a for automaticly(just some boxes)
  465. I need a personal code library
  466. Null Values or Wierd Behavior based on a user's profile
  467. Form for 2 tables
  468. Alternative to lookups in tables - questions
  469. Transactions for linked SQL Server Tables?
  470. Saving ODBC SQL database to "local" mdb?
  471. Include word doc(s) in report
  472. Data Access Page problem
  473. problem - open recordset - ADO
  474. question about % in reports
  475. DAO 3.51 and DAO 3.6
  476. Access Treeview - Is it Safe Yet?
  477. MDAC
  478. How to use parameterized query with DAO Recordset?
  479. Change Focus triggers Before Update
  480. PostCode-Zipcode
  481. compare tables
  482. Linked Tables, access security help.
  483. "Too many Fields" error running query with <255 fields
  484. Use not local admin Outlook Fails
  485. ie 6.0 and Access2k
  486. Understanding ODBC connections...!
  487. Using nested subform
  488. Linking Tables in Access
  489. A97 - How to automatically export a table to ms excel data-file from within code?
  490. Invisible Query Head-Scratcher
  491. numeri
  492. Upsizing
  493. How to supress message when dynamically setting Report recordsource
  494. Problem deleting ldb file
  495. Foreign Key with multiple columns and null value
  496. exporting access data to excel for calculations and reporting
  497. Unlock/edit a database...
  498. Like criteria
  499. requery a subform on a form
  500. Generating an Index
  501. How to get a query to pick up the value of the active form
  502. A2003 Backend opens in read-only intermittently
  503. &Relationships Bug - workaround
  504. How to set Startup Properties in MDE?
  505. In trouble! Db locked with exclusive access
  506. How to put controls on a form with VBA code
  507. If a field is keyed in, then delete other fields
  508. setting fields based on values of other fields
  509. Table Structure - Using Query with Form for Input
  510. compare two tables using this module?
  511. Ordering fields in query based on current date
  512. How to send emails from ms access..
  513. Modems and Access2003
  514. How to parse CITY ST ZIP+/-4
  515. Allowbypasskey property
  516. Append to master replication table
  517. Open a DB from the switchboard of another DB
  518. Only add Valid Payments on a Report.
  519. Calculate Number of Years, Months and Days between 2 dates
  520. Oracle 9.2 attached table real slow and data incorrect with Access 2003 SP1
  521. Lock an access db
  522. Printer / Report issue with Office XP over Network
  523. Can't Import a .dbf File
  524. Default combo box line
  525. Setting field properties in code
  526. REPOST: Unique connection ID not name.
  527. Creating new field in code
  528. Using combo boxes to fill in other bound controls not working..
  529. restoring default printer
  530. Trouble moving Access tables to SQL back End
  531. Enter Parameter Value showing up when already defined
  532. Assign textbox value from command button
  533. How do I refresh a control
  534. How to handle with "&" in text
  535. A97: MediaPlayer.MediaPlayer.1 control on a form - how do I use it to play a .wav file
  536. A97 - I've been looking for a position counter to display on a form the current character position of cursor
  537. Payroll DB
  538. Won't let me remove tables
  539. A97 overflow error returned when trying to calculate 192/(24*60*60) - why?
  540. A97 - how to format time lapse to appear as "4-minutes 12-seconds"?
  541. combo box choices
  542. How to speed up reading input from a text file?
  543. Split master table into smaller tables
  544. DoCmd.SendObject acSendNoObject Inserting Hyperlink in message containing a space.
  545. Need help to read database contents - very tricky
  546. How to Update ignoring validation rule
  547. A97 variable length string declaration - how to do?
  548. check box changes subform operation
  549. acCmdInsertHyperlink defaults "Browse for" File
  550. Catastrophic noob... can anyone help?