View Full Version : 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
  1. Data-Entry option error
  2. Replication Manager 3.5
  3. Replication Manager 3.5 is not synchroning
  4. Almost there...
  5. how to send e-mails automatically at varying dates
  6. How do you execute a SQL DTS???
  7. A2003 App in A2000?
  8. Wondering why "TYPE MISMATCH"
  9. Merging 2 copies of a database
  10. Looking for suggestion of database security implementation
  11. Form Header does not show in Form View
  12. Scrolling Multiple Subforms
  13. update a text box using combo box
  14. Acs2k DatePart Question.
  15. Regional settings - prevent changes
  16. ADP - Input Parameters from more than one form
  17. A point of nostalgia
  18. calling stored procedure from access query
  19. Server Filter By Form
  20. ADP - Insert Data Using Cmd Button
  21. Web Browser Control problem
  22. schema help
  23. How to compute number of days using a single entry of Date ?
  24. How to compute number of days using a single entry of Date ?
  25. How to compute number of days using a single entry of Date ?
  26. Copy & Paste Report Control
  27. FYI - Access Functions
  28. How are other people accessing these forums?
  29. Linking Subform to Combobox and Textbox
  30. Removing X number of characters starting at begining or end
  31. Programmatically binding a checkbox to it's option group
  32. Open type fonts in reports
  33. Filter By Form using LIKE clause
  34. Help! External Databases
  35. sql returning max of a field?
  36. Access2K vs Access2002 Sums
  37. Append from a recordset
  38. Selecting the first record of a subform in datasheet view?
  39. massive bug in MSAccess
  40. How to open a form and make its height vertically max (as the height of the display)?
  41. SQL insert string problem
  42. [WebBrowser] Add new Line
  43. help
  44. #Deleted displaying for ODBC linked tables
  45. Looking and storing values of data of its own
  46. Reports
  47. Filter by selection in a runtime application.
  48. Percent Format in a Control
  49. Autonumber control doesnt update in adp
  50. Parse Out "-" in SSN Field
  51. Invalid Operand for Operator: =
  52. import txt file not creating new lines
  53. Securing a table without restricting form usage
  54. Using one subform to control another subform
  55. query with time range parameter doesn't work
  56. Passing a date value
  57. Can I use FindFirst with multiple keys?
  58. How to view TIF on Access form?
  59. Find Dates For Sunday and Saturday
  60. Programming Credit Question
  61. Data Access Page - Validation Rules
  62. Refresh Subform from Main Form
  63. Send Object invoking email program
  64. Trouble saving of record
  65. Rs.Addnew
  66. Running a report from an external database
  67. Running a report from an external database
  68. Sometimes another record gets deleted !
  69. Field Mapping tool for queries
  70. Transfer Multiple Excel Files
  71. Testing Calculated Form Field.....
  72. WindowsXP and ASP
  73. DirDataCopy error message during conversion of Access 2003 to 2000
  74. installing Access 97 Runtime on Citrix Server
  75. comm port programming
  76. "NOT IN" statement not working in MS Access?
  77. VB access incrementing a text box
  78. VB access text box
  79. VB access incrementing a text box
  80. updating a text box in VB
  81. updating a text box in VB
  82. disable rolling by mouse
  83. Corupted database file
  84. Error at a Query about more than one Tables (with ODBC)
  85. Still get the same issue
  86. Accessing global variables within a form
  87. Combining Fields Question
  88. Access 2003 while viewing code doesn't scroll
  89. Access 2k image control error
  90. Queries, Forms and Initilization?
  91. One to many relationship "disappears" in frontend
  92. MSAccess Query Criteria
  93. lebans calendar
  94. Access 2003
  95. Access 2003
  96. DLookup uses twice the SEQUENCE numbers
  97. After adding two new tables the disable shift key codes don't work
  98. Populating Table With Calculated Report Values
  99. query on multiple queries (no relationship)
  100. Append records to a selected Table with code
  101. DBCS and MS Access
  102. Progress indicator
  103. Merge with Word - Email merged records - one record at a time Please help
  104. Filling In Blank Field Information
  105. Will "Random AutoNumber" reuse deleted values?
  106. Problem filling an ADO recordset from SQL Server
  107. Number of items selected
  108. Constant data corruption with Access 97
  109. Length of a variant string
  110. Change the default 'Save' behavior to 'Don't save' when a report is closed.
  111. Change the default 'Save' behavior to 'Don't save' when a report is closed.
  112. Change the default 'Save' behavior to 'Don't save' when a report is closed.
  113. Delete query
  114. Split function
  115. trace info in Access 97
  116. inserting data into an autonumber column
  117. What the *&^% Have They Done to Google?
  118. Finding Median - Gouped by field
  119. Runtime error 3061
  120. Unchecking Checkbox
  121. Exporting report to RTF
  122. why do you have to declare currentdb?
  123. currentdb
  124. Repeat value of previous record field into current corresponging field
  125. Scrollbars Not Showing in Subform
  126. Access Database Auditing
  127. Outlook (Contact Information) and MS Access
  128. Reading .csv files (but they were missing)
  129. collect data from exteranl ms acess tables
  130. Access Conditional Formatting
  131. Pay stub stock?
  132. Access 97 DSNless connection to SQL server
  133. Removing Multiple objects
  134. Access to Word - Save Word document as
  135. What's New on the Web : Today
  136. Access Comparison Operators
  137. Access ADO Helptext Missing
  138. Find Sunday and Saturday
  139. Find Sunday and Saturday
  140. Form cannot open anymore
  141. Report Nulls
  142. Divided Spacing on Reports:Acc97
  143. Access 2000 unstable queries
  144. Date Queries
  145. Howto get Rowsource property in Access 2k db?
  146. Filter records without using query
  147. how to get the OrderDetailID of a record I sellected in Orderdetail subform?
  148. Access database comparator tools
  149. bookmark problem
  150. Mixed case input mask
  151. Report: 2 Invoices in the same page
  152. How to refer to the RecordsetClone
  153. How to Shift-Load application programmatically
  154. Controls on Subreports
  155. Not the right Constraint_Name = szRelationship in Access
  156. Reports: Access97
  157. How Do I Set a Query to Run Every Hour?
  158. Soap 3.0
  159. TransferDatabase
  160. Converting access to application
  161. Programmatically sending Access Reports to PDF
  162. Combox box and derive rates problem
  163. Object comparison program for tables, queries, forms, modules etc
  164. How do I force a write of the data to a table?
  165. MS Internet Transfer Control
  166. System.GUID
  167. ONE MORE TRY....
  168. Remote connection to Access
  169. subforms
  170. subDatasheet setup on query behind form not being remembered
  171. How to set up database logon in a shared folder
  172. How do I check if a file exists (A97)
  173. Date/time, multiple location problem
  174. Coding a function to return a value
  175. Trying to speed-up report based on saved query (the SQL is posted here too)
  176. Closing a database without leaving
  177. nice buttons
  178. Inserting records into a table
  179. Am I crazy or just not doing this right?
  180. Call Function
  181. run macro on subform
  182. #Name? on Form
  183. Fixed width export strips leading zeros...bad
  184. Export to Excel, recordset is empty sometimes
  185. Eraser97 - anyone have a copy?
  186. VBA to close an HIDDEN occurence of Excel
  187. Return to the same date in calendarcontrol
  188. SQL (ALTER TABLE doesn't work)
  189. PRINTING textfile + vba
  190. Access Macro
  191. Function to round time by a specified number of minutes
  192. Formatting help
  193. Back End on Linux?
  194. Record Numbering
  195. Auto Number or Identity Seed on Oracle Database
  196. Need help on the Oracle Sequence Number
  197. Need help on the Oracle Sequence Number
  198. File management functionality
  199. Syntax of control on tab controls
  200. Access 97 On WXP Refuses to create MDE on OpenDatabase line
  201. Multiple Tables Query: Returning a Result When One Table Is Empty
  202. Access totally failing
  203. Replace one section of code instead of replacing the whole form
  204. Class Scheduling Query
  205. 'Pushing' Status of Access Application to another Access App
  206. PRINTING textfile + vba
  207. Database Structure
  208. Generating PDFs undesirably leaves files open
  209. Selection in combo box disappears after filter is applied to form
  210. Hiding mouse pointer
  211. Report Label
  212. Suddenly get error : Microsoft Access was unable to create the Database window
  213. Create link between access and SQL
  214. Creating an Adobe PDF over intranet from Access
  215. Prevent security message while sending message using vba
  216. Message for Joe Foster- Importing from excel
  217. Put Data Into Text File
  218. Access 2000 Form Does Not Return Data After Upsize to Project
  219. Reports
  220. my database is very corrupted
  221. Is this syntax correct in a query criteria??
  222. Report stretching/reducing
  223. How to prevent a non-entry in a field.
  224. MySQL, Access, ODBC, Replication
  225. Form cross-field edits
  226. Access db to SQL Server
  227. List Box Multiple Selections Generating Reports
  228. MS-Acces and Active Directory
  229. Sub Reports
  230. Converting Access 2k to Web
  231. Size limitation with MSAccess 2k image control
  232. Microsoft Office XP Installation
  233. Consolidating rows in a DB?
  234. Qurey question
  235. 3146 ODBC - call failed......an urgent task for my boss ARGH!
  236. Professional Data Recovery Book (World's First Book on Professional Data Recovery Programming)
  237. Using "Hyperlink" OR "OLE Object" Datatypes in VB/VBA
  238. How to enter a value in a field to be calculated and stored
  239. Importing from Excel
  240. Updating a related table
  241. Error message on combobox
  242. How to pull all transactions into 1 record
  243. HTML Help stored on the Web
  244. Lookup Question
  245. Message box Code
  246. lookup problem
  247. Creating new record with default values
  248. programatically create primary key
  249. Sort/find minimum value in row entries
  250. ADP Related Query
  251. How to admin a remote hosted Access db
  252. Callback function to populate listbox with filelist
  253. Multiple categories
  254. Sorting a recordset?
  255. Database in an unexpected state
  256. Converting messy Word doc to Access 2000
  257. Passing parameters to a sub form's recordsource
  258. Decompile
  259. Table Structure for Parts and Products...(long)
  260. Run a Public function from a macro
  261. sample data base source
  262. DateDiff, Sum & Negative numbers?
  263. Report object "visable or not visable. That is the question"
  264. Blank Pages
  265. Access 2000 - Query HELP!: Why does it not sum credits/negative dollar amounts?
  266. Access ducumentation program
  267. DAO; weird crash of MSAccess
  268. Graphics On A Form Or Report
  269. testing - plz ignore
  270. ASP ContentType
  271. Add label when exporting report to PDF
  272. Report Sum
  273. sequential numbering in a query
  274. Union queries
  275. Run-time error '3011' in select statement in access2002
  276. highlighting searched word in field
  277. Electronic Data Interchange
  278. DCount problem
  279. Access application on the Web
  280. Redefine field data type
  281. Trying again...
  282. Randomize fields
  283. Current/System date in Access
  284. Help Calculating Compounded Interest for a Missed Payment with Interest Rate Changing
  285. Record Update
  286. Toggling .Visible for controls in Subform footer
  287. access 2003 is dead
  288. How can I password protect access to a form?
  289. Findfirst + multiple criteria ???
  290. Neat database diagrammatic documentation scheme
  291. different rates for diffrent categories
  292. .ldb file size
  293. Access ADP's
  294. Email client within Access
  295. How to learn Office Automation with Access?
  296. Data synchronisation Issue - SQL server
  297. programing AllForms button onto toolbar
  298. what's wrong with this findfirst?
  299. Automatic updating record from VBA with data not displayed on a form
  300. MS-Access Database via Perl
  301. one question about report
  302. Repost - InetTransferLib Http download problem with zip files
  303. Calling function with arguments from external VB application
  304. Disable criteria of a query based on checkboxes
  305. Which page am I on?
  306. How best to attack this problem? Sorting and summing transactions by date
  307. updating data in a table after calculated field
  308. Formatting subreport "report" headings
  309. Make button visible/invisible on a per record bases in subform
  310. determine fields of query based on form checkbox
  311. Command buttons visible in subform on a per record bases
  312. Reading Order
  313. RTF to HTML and reverse...!
  314. returning modified data BACK to table after calculating
  315. Linked Tables
  316. ASP charts
  317. View/Print Summary Portions of Report Only
  318. Help! Wierd Report. Summarizing Data.
  319. Linking to temporary tables from an Access Project
  320. Query Results of Age less than 1 year?
  321. DLookup in TabControl in Form
  322. How to TransferDatabase from Access to MySQL
  323. Use parameters from a multi select list box in a query
  324. datetime query with parameters problem
  325. Change Report Header for Different Sections
  326. Strange behavior
  327. Apply filter
  328. bug in MS Access/XP Pro
  329. Formatted Text
  330. DLL returns char *
  331. Trapping invalid characters - table driven approach?
  332. Continuous form button captions....
  333. best way to test for an empty recordset?
  334. Searching on a text field as integer
  335. TransferDatabase wont kick-start!
  336. saving rpt as snapshot (HELP!)
  337. Can Eval evaluate a date arithmetic expression?
  338. Security problem in Access 2000 - Admins user can't change query design
  339. How to clean up this simple query?
  340. Subtracting time past midnight
  341. Delete All Lines
  342. application crash when i click checkbox
  343. Text Import Wizard Problem in XP
  344. Access Data Project Query (Access 2002)
  345. Display an image using an expression?
  346. Week Numbers in Stephan Leban's MonthCalendar
  347. White space under subreport
  348. simple query results, yet a difficult way to get to them...
  349. Export report to Excel with code?
  350. MS Access 97/2K personal contact management & knowledge base app
  351. Daily Devotion
  352. Using Form instead of message box
  353. problem with relationship between tables
  354. Looking for a full page calendar control or API needed
  355. How to start the default email program WITHOUT sending a message
  356. PULL REPORT WITH LATEST DATA FOR INDIVIDUAL RECORDS
  357. Different no of records
  358. convert access database for use with pda
  359. Access application for PDA
  360. Access 2002 cannot view code...
  361. Difficult copy recordset
  362. Can I use "on click" event to cause all characters in field to beselected?
  363. Microsoft Office 8.0 Object Library
  364. Formatting Time
  365. WHAT IS THE ASPNET_CLIENT FOLDER
  366. Custom Menu Code In Form??
  367. Problem with crosstab query
  368. OpenRecordset problem
  369. Unlock table
  370. Access - Excel communication
  371. Combobox On A Custom Menubar
  372. Variables Now(), Date() and Time()
  373. Date Comparison problem in SQL
  374. Help Converting DAO to ADO Calls in Access 2000
  375. constants as row headings
  376. Wish list vent
  377. Parsing a copy buffer full of Excel spreadsheet rows?
  378. WIN API Calls from VBA
  379. constants as row headings
  380. Parse Text from a .txt file
  381. Calculated Field To Show 1/3, 2/3 And 3/3
  382. Access select field value AFTER a date
  383. Share a database
  384. creating relationships
  385. Programmatically Import Toolbars
  386. self join query in access
  387. Tab control.. hierarchies and the like.
  388. Linking relational db
  389. Is there an online text database without server components
  390. Force an empty form to get inserted, in background (without changingfocus, selection, etc.)
  391. InetTransferLib Http download problem with zip files
  392. Access "Pages" as a way to set up web based applications
  393. SQL Server Linked Table Insert Record Problem
  394. Importing Records to SQL Server
  395. Using Hyperlinks
  396. About OpenSchema(27) and rstSchema("FK_COLUMN_NAME")
  397. Union query updatable or not
  398. Title Case Access 97
  399. DAO
  400. Has anyone tried this VBA to .NET converter?
  401. Crash on acOutputTable
  402. Inserire nuovo record stile exel
  403. Help please! New user to Access
  404. Access 2002: Form_Dirty does not fire
  405. Export Access table to excel
  406. Access Formular
  407. DoCmd.OpenForm Statement
  408. duplicate record issue
  409. How to Refresh List Box - Sounds Simple???
  410. Printing a text file?
  411. Convert Windows System Cloours to RGB Colours
  412. Help Again: Need to Count Occurances
  413. Wish List Item
  414. random execution of stored procs in ADP
  415. CREATE PROC syntax in ADP
  416. COUNT(CASE WHEN...
  417. Query for records with no matching records in another table?
  418. Can't see all of the queries when merging to MS Word and can't get to reports
  419. Images As External Files
  420. TreeView -- Programmatically Selecting a Node
  421. Hyperlink
  422. Run-Time Error 13 when trying import a spreadsheet
  423. Show HTML Message
  424. EPSON TMT88
  425. SQL Question - I am nearly there!
  426. Help with controls on a form
  427. Conversion problem 97->2000
  428. change data then it does not satisfy criteria in the underingly table
  429. find selected record on form
  430. query using dates
  431. Type Mismatch error in sql statement containing "Like"
  432. Referential Integrity failure -- any ideas?
  433. Help! Problem on the final stage of a restaurant database
  434. Show record count from a SQL Server Temp Table used in a form recordsource
  435. Access Data Project using procedure with IF statement, condition
  436. Calling Help.chm from Access
  437. Passing and using option values in code..
  438. Replication
  439. query by form
  440. Simple htm vbscript snippet for appending database record
  441. Can I control how user exits access?
  442. Can someone help with this combobox question?
  443. [test] testing...
  444. problme exporting a table as a text file
  445. Design Question
  446. ADP or Access link SQL Server tables?
  447. can update query or whatever make this possible?
  448. NOVICE question...
  449. Find Open Windows and Close using VBA
  450. Reinstall Access 2000 after doing 2003 install?
  451. Konvertierungsproblem 97->2000
  452. MS Access calendar 9.0 to pick dates on a form
  453. SendObject problem
  454. Not sure how to phrase this
  455. Help! which function to use to identify repeated items in a table?
  456. snapshot from access97 ?
  457. Get Directory of Current DB
  458. Changing Size Of Scroll Box Control Through Apperance Tab In Desktop's Right Click Properties Option ---- I think Mr. Arvin Meyer Can Help Me
  459. Novice question: how to make changes in an Access database
  460. Link Table Manager
  461. replication
  462. How to Dim
  463. Date Math for Access 97
  464. Got Focus Control Name and Value?
  465. Got Focus Control Name and Value?
  466. Got Focus Control Name and Value?
  467. LIST BOX
  468. Adding Web Cam Images To Access
  469. Can't get Multiselect listbox code to work for report
  470. counting unduplicated student IDs
  471. Help Compiler - for Access 97 on Windows XP
  472. entry defaulting to previous entry
  473. Lebans Highlight Selected Row
  474. Joining a Query and Table while Excluding some results
  475. What Book/Manual or WebSite do you use?
  476. A97 - Date error in Runtime
  477. Zero Filling Autonumber Fields
  478. How did my users do this?
  479. How do I loop through records
  480. Why does this SQL not work?
  481. Consuming web services
  482. Question involving OLE DB, recursion, and filtered views
  483. GrayJay's code for dynamic combo box that sub-selects the sourcebased on characters entered
  484. Creating ODBC table links
  485. Reports with percentage
  486. the jungle of text files - CreateTextFile in unicode
  487. Can not insert new record
  488. Form with info check from other tables
  489. I found this great little site
  490. ADP Login
  491. counting unduplicated records
  492. Entering Data for New Records
  493. test - looks like messages for last 5 hours not appearing
  494. Import Corrupts DB?
  495. can access be compiled?
  496. Passing parameters to action stored procedures using ADO, in Access Project
  497. All I Need to Know is if Atleast 1 Matching Record Exists
  498. Multi User issue?
  499. Data Entry From Remote Locations
  500. Does Snapshot still work with Service Pack 2
  501. Autonumber
  502. Is an upgrade possible?
  503. Outlook contacts and Access
  504. FileSearch
  505. Automatically updating info in tables
  506. Multiple Printers
  507. Access 2003 file format
  508. Day part of Date
  509. Access to WEB (why so complex?)
  510. Importing data from an External DB & Efficiency
  511. Browes button
  512. FindFirst: quick suggestion
  513. Storing JPG files
  514. Access and SQL Server Books
  515. Custom Autonumber
  516. New to Code - Syntax for Running a Sub or Function
  517. Size of the Main Access Window
  518. Formatting a date to be used in a date range
  519. Excel to Access export - query possible?
  520. Sybase goes read only
  521. What version of DAO does Access 2002/2003 have?
  522. Excel or Chart Wizard
  523. Help with Data Comparison: Sample VS. Population
  524. Snapshot and Email from Reports problem
  525. comp.databases.ms-access
  526. SubForm going blank
  527. Setting Page numbers on copies of a report
  528. Problem with combo boxes
  529. One Record to Capture Login and Logout
  530. Access 97 picture suggestions
  531. HOW TO: Summary Page for Month-by-Month Report
  532. Change printer in vba code
  533. Anyone have a list of HTML colors in Hex, Long and Named format?
  534. autonumber issue in access 2000 (it's a database backend for webapplication) - seems to increment by 2 sometimes
  535. toolbar position
  536. 2003 and Long Binary Data
  537. Print report from form record
  538. BETWEEN and AND statements
  539. WebBrowser Control thumbnails tiles icons list details
  540. Moving from Accesss97 to SQL Server 2000
  541. Was the thread title boring?
  542. Fractional Font Size? e.g. 8.5
  543. inconsistent error importing data
  544. Alphabetising a report
  545. Is there a way to lock down the database?
  546. Exporting from Access2000 tables with OLE objects
  547. Need some guidance on school database project
  548. renaming field names in a query table
  549. Data Transposition
  550. Data Transposition?