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 122

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