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. Query Results of Age less than 1 year?
  2. DLookup in TabControl in Form
  3. Use parameters from a multi select list box in a query
  4. How to TransferDatabase from Access to MySQL
  5. datetime query with parameters problem
  6. Change Report Header for Different Sections
  7. Strange behavior
  8. Apply filter
  9. bug in MS Access/XP Pro
  10. Formatted Text
  11. DLL returns char *
  12. Trapping invalid characters - table driven approach?
  13. Continuous form button captions....
  14. best way to test for an empty recordset?
  15. Searching on a text field as integer
  16. TransferDatabase wont kick-start!
  17. saving rpt as snapshot (HELP!)
  18. Can Eval evaluate a date arithmetic expression?
  19. Security problem in Access 2000 - Admins user can't change query design
  20. How to clean up this simple query?
  21. Subtracting time past midnight
  22. Delete All Lines
  23. application crash when i click checkbox
  24. Text Import Wizard Problem in XP
  25. Access Data Project Query (Access 2002)
  26. Display an image using an expression?
  27. Week Numbers in Stephan Leban's MonthCalendar
  28. simple query results, yet a difficult way to get to them...
  29. White space under subreport
  30. Export report to Excel with code?
  31. MS Access 97/2K personal contact management & knowledge base app
  32. Daily Devotion
  33. Using Form instead of message box
  34. problem with relationship between tables
  35. Looking for a full page calendar control or API needed
  36. How to start the default email program WITHOUT sending a message
  37. PULL REPORT WITH LATEST DATA FOR INDIVIDUAL RECORDS
  38. Different no of records
  39. convert access database for use with pda
  40. Access application for PDA
  41. Access 2002 cannot view code...
  42. Difficult copy recordset
  43. Can I use "on click" event to cause all characters in field to beselected?
  44. Microsoft Office 8.0 Object Library
  45. Formatting Time
  46. WHAT IS THE ASPNET_CLIENT FOLDER
  47. Custom Menu Code In Form??
  48. Problem with crosstab query
  49. OpenRecordset problem
  50. Unlock table
  51. Access - Excel communication
  52. Combobox On A Custom Menubar
  53. Variables Now(), Date() and Time()
  54. Date Comparison problem in SQL
  55. Help Converting DAO to ADO Calls in Access 2000
  56. constants as row headings
  57. Wish list vent
  58. Parsing a copy buffer full of Excel spreadsheet rows?
  59. WIN API Calls from VBA
  60. constants as row headings
  61. Parse Text from a .txt file
  62. Calculated Field To Show 1/3, 2/3 And 3/3
  63. Access select field value AFTER a date
  64. creating relationships
  65. Share a database
  66. Programmatically Import Toolbars
  67. self join query in access
  68. Tab control.. hierarchies and the like.
  69. Linking relational db
  70. Is there an online text database without server components
  71. Force an empty form to get inserted, in background (without changingfocus, selection, etc.)
  72. InetTransferLib Http download problem with zip files
  73. Access "Pages" as a way to set up web based applications
  74. SQL Server Linked Table Insert Record Problem
  75. Importing Records to SQL Server
  76. Using Hyperlinks
  77. About OpenSchema(27) and rstSchema("FK_COLUMN_NAME")
  78. Union query updatable or not
  79. Title Case Access 97
  80. DAO
  81. Has anyone tried this VBA to .NET converter?
  82. Crash on acOutputTable
  83. Inserire nuovo record stile exel
  84. Help please! New user to Access
  85. Access 2002: Form_Dirty does not fire
  86. Export Access table to excel
  87. Access Formular
  88. DoCmd.OpenForm Statement
  89. duplicate record issue
  90. How to Refresh List Box - Sounds Simple???
  91. Printing a text file?
  92. Convert Windows System Cloours to RGB Colours
  93. Help Again: Need to Count Occurances
  94. Wish List Item
  95. random execution of stored procs in ADP
  96. CREATE PROC syntax in ADP
  97. COUNT(CASE WHEN...
  98. Query for records with no matching records in another table?
  99. Can't see all of the queries when merging to MS Word and can't get to reports
  100. Images As External Files
  101. TreeView -- Programmatically Selecting a Node
  102. Hyperlink
  103. Run-Time Error 13 when trying import a spreadsheet
  104. Show HTML Message
  105. EPSON TMT88
  106. SQL Question - I am nearly there!
  107. Help with controls on a form
  108. Conversion problem 97->2000
  109. change data then it does not satisfy criteria in the underingly table
  110. find selected record on form
  111. query using dates
  112. Type Mismatch error in sql statement containing "Like"
  113. Referential Integrity failure -- any ideas?
  114. Help! Problem on the final stage of a restaurant database
  115. Show record count from a SQL Server Temp Table used in a form recordsource
  116. Access Data Project using procedure with IF statement, condition
  117. Calling Help.chm from Access
  118. Passing and using option values in code..
  119. Replication
  120. query by form
  121. Simple htm vbscript snippet for appending database record
  122. Can I control how user exits access?
  123. Can someone help with this combobox question?
  124. [test] testing...
  125. problme exporting a table as a text file
  126. Design Question
  127. ADP or Access link SQL Server tables?
  128. can update query or whatever make this possible?
  129. NOVICE question...
  130. Find Open Windows and Close using VBA
  131. Reinstall Access 2000 after doing 2003 install?
  132. Konvertierungsproblem 97->2000
  133. MS Access calendar 9.0 to pick dates on a form
  134. SendObject problem
  135. Not sure how to phrase this
  136. Help! which function to use to identify repeated items in a table?
  137. snapshot from access97 ?
  138. Get Directory of Current DB
  139. Changing Size Of Scroll Box Control Through Apperance Tab In Desktop's Right Click Properties Option ---- I think Mr. Arvin Meyer Can Help Me
  140. Novice question: how to make changes in an Access database
  141. Link Table Manager
  142. replication
  143. How to Dim
  144. Date Math for Access 97
  145. Got Focus Control Name and Value?
  146. Got Focus Control Name and Value?
  147. Got Focus Control Name and Value?
  148. LIST BOX
  149. Adding Web Cam Images To Access
  150. Can't get Multiselect listbox code to work for report
  151. counting unduplicated student IDs
  152. Help Compiler - for Access 97 on Windows XP
  153. entry defaulting to previous entry
  154. Lebans Highlight Selected Row
  155. Joining a Query and Table while Excluding some results
  156. What Book/Manual or WebSite do you use?
  157. A97 - Date error in Runtime
  158. Zero Filling Autonumber Fields
  159. How did my users do this?
  160. How do I loop through records
  161. Why does this SQL not work?
  162. Consuming web services
  163. Question involving OLE DB, recursion, and filtered views
  164. GrayJay's code for dynamic combo box that sub-selects the sourcebased on characters entered
  165. Creating ODBC table links
  166. Reports with percentage
  167. the jungle of text files - CreateTextFile in unicode
  168. Can not insert new record
  169. Form with info check from other tables
  170. I found this great little site
  171. ADP Login
  172. counting unduplicated records
  173. Entering Data for New Records
  174. test - looks like messages for last 5 hours not appearing
  175. Import Corrupts DB?
  176. can access be compiled?
  177. Passing parameters to action stored procedures using ADO, in Access Project
  178. All I Need to Know is if Atleast 1 Matching Record Exists
  179. Multi User issue?
  180. Data Entry From Remote Locations
  181. Does Snapshot still work with Service Pack 2
  182. Autonumber
  183. Is an upgrade possible?
  184. Outlook contacts and Access
  185. FileSearch
  186. Automatically updating info in tables
  187. Access 2003 file format
  188. Multiple Printers
  189. Day part of Date
  190. Access to WEB (why so complex?)
  191. Importing data from an External DB & Efficiency
  192. Browes button
  193. FindFirst: quick suggestion
  194. Storing JPG files
  195. Access and SQL Server Books
  196. Custom Autonumber
  197. New to Code - Syntax for Running a Sub or Function
  198. Size of the Main Access Window
  199. Formatting a date to be used in a date range
  200. Excel to Access export - query possible?
  201. Sybase goes read only
  202. What version of DAO does Access 2002/2003 have?
  203. Excel or Chart Wizard
  204. Help with Data Comparison: Sample VS. Population
  205. Snapshot and Email from Reports problem
  206. comp.databases.ms-access
  207. SubForm going blank
  208. Setting Page numbers on copies of a report
  209. Problem with combo boxes
  210. Access 97 picture suggestions
  211. One Record to Capture Login and Logout
  212. HOW TO: Summary Page for Month-by-Month Report
  213. Change printer in vba code
  214. Anyone have a list of HTML colors in Hex, Long and Named format?
  215. autonumber issue in access 2000 (it's a database backend for webapplication) - seems to increment by 2 sometimes
  216. toolbar position
  217. 2003 and Long Binary Data
  218. Print report from form record
  219. BETWEEN and AND statements
  220. WebBrowser Control thumbnails tiles icons list details
  221. Moving from Accesss97 to SQL Server 2000
  222. Was the thread title boring?
  223. Fractional Font Size? e.g. 8.5
  224. inconsistent error importing data
  225. Alphabetising a report
  226. Is there a way to lock down the database?
  227. Exporting from Access2000 tables with OLE objects
  228. Need some guidance on school database project
  229. renaming field names in a query table
  230. Data Transposition
  231. Data Transposition?
  232. renaming field names in a query table
  233. Identifying if Office 2003 is installed
  234. VBA to VB.Net Conversion tools
  235. How to use string variable as a variable?
  236. Opinions on db structure
  237. update query with multi fields
  238. How does a primary key become a negative number?
  239. generic dataview flexgrid ?
  240. Moving an Access database online
  241. Offshore outsourcing of access databases?
  242. canadian postal code lookup
  243. Combo box filter
  244. Automatically associate value from one table to another table
  245. Run a report based on a 1 month range
  246. Running totals in a query?
  247. long binary data
  248. dynamically removing entries from a list
  249. Autokeys Macro not Working
  250. School Lunchroom Admission
  251. complex expression builder
  252. How do I create a query to link unrelated items between dates.
  253. Getting location of OLE object via VBA
  254. How to do ALTER TABLE after a DML sentece in the same transaction.
  255. A question about Northwind traders Database
  256. Using GUID Autonumers pros and cons
  257. A note about Component-Based Development
  258. Carriage Return Issue
  259. Creating Reports based on hierarchical XML file
  260. Random fuctions - a problem to solve
  261. pasting multiple lines in MS Access
  262. Checking AllowZeroLength property in ADO
  263. Access 97 runtime
  264. Application Title is not saved
  265. Marking an attendance
  266. IsNull or IsNotNull Puzzle
  267. Snapshot Report From Access To Outlook
  268. Excel Pivot linked to Access
  269. Lookup tables - alternatives
  270. Problems with OCX Control on FrontEnds
  271. Dynamic Hyperlinks in a Form
  272. to make a special column
  273. 3001 Arguments are of the wrong type
  274. "kicking" users from a database
  275. How do I identify the user locking a record
  276. Uppercase problem
  277. Help: how to ensure that data inserts/updates are occurring without fail
  278. After inserting a record a different record is displayed
  279. ordering records
  280. Alternatives to Lookup Fields
  281. unicode characters to VB
  282. How can I use today's date as a variable?
  283. printing forms with filter (multiple subforms)
  284. Importing text into multiple tables
  285. Find an ID number not present in a linking table
  286. Control sequence of objects in main window
  287. How do I Create an Index of a Report in Access
  288. Return value from a field of a query in VBA access
  289. Saving design changes
  290. 41585 Mining the Web: Jacobian Matrix Constructs with eigenVectorSearching 41585
  291. Using NoData Event in Access 2003 Report
  292. Replacing characters
  293. Un-accent characters
  294. variable file import question
  295. Access 2000 files with Access 2003
  296. Run .reg file for all users of a network
  297. FREEware Access 97 mdb readers available?
  298. RADiest Client for SQL Server
  299. Combobox in data access pages
  300. Importing a CSV file; imports all but one field
  301. Code for query to "Export to Excel" as pivot
  302. halo
  303. converting to a standard
  304. Keep getting errors running database on Terminal Server
  305. Dlookup #error message
  306. Calculate by Date (non date fields)
  307. giving access on a subset of data filtered by user login?
  308. Pulling data to another form...
  309. selecting from a table with multiple records
  310. Problem w/OLE Server or ActiveX Control
  311. Using MROUND or ROUNDDOWN in MS Access 2000
  312. No decimal currency format
  313. Formatting Zero Value $ fields in a report
  314. Remote desktop
  315. Access Reports into Powerpoint
  316. Mail Merge limit of 255 charachters per field
  317. how to create a query.
  318. Looking for ways to generate unique ids for a user's PC
  319. DSN-less connection - Trusted_Connection=no doesn't stick
  320. query w/ two criteria
  321. Persistent Object Reference
  322. Format x column of Combo Box/ List Box as a phone number – (xxx) xxx-xxxx
  323. Possible to email a Pivot/Query results?
  324. Appending Tables:
  325. Opening multiple instances of a form in A2K: Gotchas?
  326. Can't find project or library
  327. Grabbing data from an online source and copy to local database?
  328. Database results - activating links within memo fields
  329. Multi-Select list box
  330. Joining strings from fields with null values
  331. Annoying ACCESS 2000 RUNTIME installation triggered
  332. Spell Menu Dimmed?
  333. ACC97 on a Network environment
  334. School Year Months as 1 to 10
  335. Drop down box not populating fields
  336. Copyrighting an Access database
  337. Export MS-Access report output
  338. Geneology tracking
  339. File Sharing Lock Count Exceeded
  340. Combo box help
  341. pivot?
  342. remove cursor from textbox
  343. What does normalise mean?
  344. Single row labels in a column based report
  345. Automatically create records
  346. send group mail to adresses based on a query or filter
  347. specify results of query containing only whole numbers
  348. How to Print Very Large Fonts
  349. ADP - Slow Response --
  350. Sort Records into a Random Order
  351. Access 97 Capasity
  352. Basic Q: DBA role
  353. How to connect two subforms
  354. Algorithm for adding up value of a string?
  355. White space under sub-report
  356. What's the simplest method to install a runtime database app across the web?
  357. 'Where' referring to any field
  358. relational database: how to make a related record automatically
  359. Is DevelopersDex Hijacking Usenet?
  360. DAO rst Methods in OnCurrent Event - Unwise?
  361. Copying fields from one table to another
  362. Default Database folder question
  363. API call
  364. A97 Emailing Reports Problem
  365. Resource grabbing Access - Jet - ODBC - SQL Server problems.
  366. Linking external table with ODBC using code
  367. setting up Data Access Page
  368. How do you model a family?
  369. A2003 Subform Dataentry = False Causes Crash
  370. Single Form-Continuous Form
  371. highlighting in an access table
  372. making your query results into a table
  373. autofilter of table in Access
  374. How to maintain cursor insertion point after DoCmd.DoMenuItem acFormBar, acFile, acSaveRecord?
  375. Looking for suggestion or help
  376. MS Access, send email from web host
  377. Updating Street Address Parser
  378. Drag & Drop Hypertext Headaches and Image Instability
  379. How to maintain appearence of selected text when subform loses focus?
  380. Before OnCurrent
  381. Access 2000 Combo Box is blank when form firsts loads
  382. do I need to re-link my linked tables?
  383. Form Question - How to Avoid Too Many!
  384. Not Enough Horizontal Space in Report
  385. Need help with FindFirst
  386. Update Query from List Box selection
  387. Sequencing/Counting Records in Query
  388. Updating recordsets via query
  389. Change Background Properties of Rectangle
  390. Send Immediate Window contents to form textbox.
  391. Zero Length Strings
  392. need help with query
  393. format data type
  394. Maximum code size
  395. SQL like statement in VBA
  396. Query problem
  397. Latency in DB-update using Jet
  398. data input on access forms
  399. Help File: Empty Screen Or Menu Item
  400. Query using joined tables
  401. HTML Help file
  402. Editing form-bound records with DAO (Access 97)
  403. a2k - populating listbox using array - is there a better way?
  404. Conditional formatting problem
  405. Excel Application.Quit doesn't
  406. Access 97 - Multiuser databases and corruption
  407. How can I get rid of this error
  408. Unhide Database Window
  409. Need some help
  410. Access Runtime Queries Via DSN Failing
  411. Select Query Problem/question
  412. Anyone have experience with FMS products for Access?
  413. OT - View PDF files from withing Word?
  414. Question
  415. Apply Filter to A Report
  416. Delete Page 2 of Report, Which Is Blank
  417. Apply Filter to A Report
  418. Dynamic combo box - limit selection based on user entry
  419. access error logging/troubleshooting ideas
  420. How to send a report that's password protected?
  421. ODBC Link from Access 2000 & XP to SQL 2000 problems
  422. Warning Messages Opening Access Pages
  423. On Click Bug
  424. Output as outlook e-mail group
  425. Data Replication
  426. listbox doesn't update table
  427. DSN-less pass-through queries with Oracle driver
  428. Repost Creating a comparative report
  429. Form Design slowness in Access 2003
  430. Access97 RTF vs AccessXP RTF output
  431. Dependent combo boxes
  432. 32 bit unsigned integer field?
  433. logisk model access komponenter
  434. dividing two numbers
  435. Refer to subform from query
  436. Security again.....Sorry
  437. Saving from one form to multiple tables
  438. Can Grow problem with Access 2000 report
  439. Select query problem/question
  440. When did Microsoft quit supporting Access 2.0?
  441. Error handler problem...
  442. Fields in 1 form based on another table
  443. help wanted
  444. user insert a .bmp image into form
  445. Advanced Filter/Sort window -- where is it?
  446. Class Module Issue - Property Set Statement
  447. A wrapper for DAO! Well, almost...
  448. funky scrolling behavior in subform (continuous forms)
  449. Query problem
  450. Query problem
  451. How to Set ODBC Timeout Property in ADOX Stored Query
  452. Copy Stephen Lebans RTF2 control in report
  453. Netscape and SendObject problem
  454. Looking for old Microsoft Access 2.0
  455. Update Query: Getting a Count From a Related Table???
  456. Another problem...
  457. SQL Query: where LIKE pattern is from another table
  458. Copy of table gets emptied with original table
  459. Microsoft Access 2.0
  460. OpenForm command...
  461. Can I even create this form???
  462. Adding item numbers to a listbox programatically
  463. Rounding time less that 10 minutes so it shows as 2 digits
  464. which control has the focus
  465. opening ole db databases in access
  466. Database Splitter
  467. Is access 2000 able to work with XML???
  468. [OleDbException (0x80004005): Access 2003/VS 2005 Web Beta 1
  469. List Boxes - VBA
  470. How can I Sort Reports and Forms Excel Style
  471. Read Only DB Access 2003
  472. Disable Access query rewriting
  473. chords database for musicians
  474. New field added in Table to appear in Form
  475. How do I wait for a query to complete?
  476. Hide Record
  477. Add Field
  478. Email filtered report
  479. Designing an employee holiday / vacation database
  480. Web services
  481. Detect Access version from script
  482. sub-form: 3246 Operation not supported in transactions
  483. Excel VBA Query Using Access Database Hangs on 2nd Execute
  484. "Module not found" problem in Access 2k but not in Access XP
  485. Empty Combo Box
  486. Make Table Query Question
  487. How to show both Yes/No in a query?
  488. Detecting an empty query result
  489. Acc97 Advanced Filter - Capturing the Filter for report Filter
  490. Combining fields in a table
  491. Input-Form-Building Problem
  492. Access2003 security warning
  493. Format field to 'Date'
  494. dynamic subforms
  495. Import data
  496. Import data
  497. Log out/Change user?
  498. date problem
  499. Eliminating Duplicates in MS Access while updating them
  500. Represent a Continuum
  501. 97 - Quick Email Question
  502. Adding data to subform
  503. VBA- Help!
  504. Help system for an Access 2000 app.
  505. Re-linking tables could not find installable ISAM
  506. Analyze It with MS Excel
  507. dropdown lists not progressively filtered in MS Access 2003 filter by form
  508. Error 3061 Too few parameters. Expected 1 from Access 97
  509. Append query rounding error
  510. Form Building Problem
  511. "module not fount" problem
  512. Access 2000 under Win XP crashing after long term use?
  513. Fundamental MDB bloat issue
  514. Snapshot and RTF problem
  515. Creating a comparitive report
  516. Test for URL
  517. Automation question
  518. Tracking Arrivals & Sending Email Notification?
  519. Finding workstation NTID
  520. Dynamically assign Recordsource to subform
  521. Comparing Database technologies
  522. hidden fields on query design view???
  523. Deployment Issues
  524. Deployment issues
  525. lebans report utilities question
  526. changing form dimensions in vb.
  527. PARAMETERS FOR STORED PROCEDURES (UPDATE, APPEND)
  528. select tablename.fieldname yet error 3079
  529. Problem in Installation
  530. Running a Query from a form
  531. Access database for non-profit basic human needs agency
  532. Asset Management template
  533. default query to snapshot
  534. Compact on Close
  535. building an expression
  536. Including a link to a graphic
  537. Filter on date in date field with default value Now()
  538. JET4.0 Downgrade - confusion
  539. export snapshot in word
  540. AutoID PROBLEM wnats to recount after 10 records
  541. VBA?
  542. Access 97 Problem with hyper links
  543. C'mon, Join with Me -- an Access 95 Easter Egg of blessed memory....
  544. Developing a system
  545. Access Developer's Version
  546. A2000 Auction database - need help
  547. Delete Info from a Table
  548. Estimating the value of a db
  549. IF Statement
  550. MsAccess Update query command in Form not updating all fields