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. Help please with query
  2. Need some help please
  3. Print All retrieved Data from Access Database using ADODC
  4. Query Problem
  5. Access compatible query does not work in asp
  6. Check the first character if its not zero then insert otherwise not
  7. Run my query it prompt which i dont want
  8. Export table from old Access 2002 Database to create a new database
  9. table setting with vba
  10. trouble refering to one subform from another
  11. Subforms...
  12. Access - Header Code
  13. Form/Subform - Navigation in Access 2003
  14. Count nr of unique group of records
  15. Alternative to VBA Update Query
  16. Use TransferText to update a field in table?
  17. Set 2 fiels to same value
  18. Totals problem with subform
  19. Update query
  20. programatically Batching PDF's
  21. Copying forms and displaying 'todays' date
  22. Import Interface File
  23. Basic Date Function, Need Help
  24. Refreshing a form - automatically
  25. Importing from Excel - Cannot maintain Cell type
  26. data access page
  27. FIltering a crosstab query on a date- urgently need hlep
  28. LINK TWO TABLE WITH QUERY
  29. Report in 100 Zoom
  30. Remove the Restore Down button from the Main Access window
  31. Sub-SubForm Reference Problem
  32. Tools to repair a corrupt Access database
  33. (no subject)
  34. Record source problem
  35. Shows results on webpage based upon the user IP address
  36. Restarting database
  37. Bring to front - by VBA code
  38. Making categories
  39. Calculating Number of hours worked by an employee
  40. Remove filter
  41. Field Formatting Help
  42. Filtering a Combo box on a form
  43. help with copying data from one table to another
  44. Multiple Query
  45. Insert zero before number(as a first character) of type text
  46. Indexing problem with Make Table query and Create Index code (repost)
  47. Am I Over-Complicating this?
  48. Copy and Paste Fields
  49. MS Access Graph
  50. finding a row in access database
  51. Open Report with Where Condition
  52. Code changes from this code to print queries necessary to print out macro definitions
  53. Copying forms
  54. Array problem when resetting after breakpoint
  55. Deleting temporary tables
  56. Changing relationships in form
  57. Cursor Jumping
  58. Index and Null values
  59. Mouse Wheel in Text Box w/Scroll Bars.
  60. RichTextBox control - error - Not supported
  61. Validating emails
  62. UI Question: Protecting Critical Delete?
  63. Boolean Expression in Query Access vs vb.net (Please Help!)
  64. Drag and Drop - copy file, hyperlink
  65. Getting Access vba connection string to identify the user
  66. Querying records for the last 2 weeks
  67. c = a + b how can i do this
  68. Refreshing a form
  69. E-mail a message from Access via Outlook
  70. Fw: Access/SQL Programmer wanted in NY/Westchester Area
  71. Absolute beginner question - Factor1?
  72. error #3259? A97
  73. LookUp columns
  74. Aliases in access2003
  75. What does Me mean?
  76. Command to change the data type of a field in a table
  77. Link Corel Draw in OLE object in Access automatically?
  78. MS Access Reports
  79. Invalid field or expression problem
  80. Changing borderstyle of nodes in Treeview control
  81. Access Database Template
  82. when i select a 26 digits ,the sql doesn't work ,why?
  83. If...ElseIf....statements
  84. Count() Function Help
  85. 'Data Type Mismatch In Criteria expression' Error
  86. Managing table Links from MDB To SQL 2000
  87. OT. Printer Problems
  88. Change Private Function to Public Sub/Function
  89. Access 2000 crashing...
  90. moving the BE db
  91. Select multiple criteria within a field - pass to report filter
  92. invoice printing
  93. Using one report for different queries
  94. New e-mail Message - access 2000
  95. design a forum that posts multiple choice questions
  96. Q on the Array function...
  97. Find a record when Form opens
  98. How to process an array of fieldnames and fieldtypes in FN creating table
  99. detect locks
  100. Combine 2 records in one
  101. subform getting data from other subform
  102. O.T. ==> PING discussion
  103. Importing Excel data to Access
  104. Page count in group
  105. 'delete event' in tables?
  106. TreeView: Sort Dynamically?
  107. load data from XML files to the existing Access tables HELP
  108. Reports - can I create an index?
  109. List report
  110. White page from form filter...
  111. Link table structure
  112. Union Query and retrive fromVisual basic
  113. Using MS Access to send Email
  114. VB Functions Dont Work with Workgroup Security
  115. "Shell"ing to Adobe update question
  116. ANSI vs Unicode and the character map
  117. Double entry
  118. Listing Two Fields
  119. ? Fill form fields from a separate table???
  120. combo box display
  121. Summing a Query
  122. Importing partial data to MS Access Table
  123. combo box
  124. help with access
  125. DoCmd Open Form Issue
  126. Null vs. nothing
  127. If Statement Against a Check Box
  128. Resort Form based on click
  129. Concatenating fields
  130. Show on Access form the last modified date of an Excel workbook
  131. Broken Query?
  132. "ZH"+Str([MyNumericField]) adds a space
  133. ADP project
  134. JPEG Exporting Utility
  135. Access 2000 needs to be repaired EVERY day
  136. How to disable Add New Record in the code?
  137. Search through list box on form open
  138. Help with large database
  139. decimal point problem
  140. Lock File
  141. Locating Chart Source Data
  142. Undo command
  143. Sending Email with Attachment in Access97 using Outlook Express
  144. Different background colors in a continuous form
  145. Recording WIF users against their entries
  146. Subform challenge
  147. Drop down lookup problem
  148. Shell command for Adobe 7
  149. Referential Integrity and Indexes
  150. Strange indexing problem with Make Table query and Create Index code
  151. Access best database for this application?
  152. Choose table to append records to
  153. Adding new record in continuous form appears to produce records
  154. Storing Query Results in Sequenced Conditional Statement
  155. Currentdb doesn't work with adp file
  156. adding a text string to data from one field in one database to another
  157. Last Updated By Field in Access
  158. Query Works in A97 and Not in A2003
  159. Is MS Access 2003 compatible with Crystal Reports Version 9?
  160. Is MS Access 2003 compatible with Crystal Reports Version 9?
  161. Code for making SOAP Call to our ESB
  162. REQ Help: Adding a new record to a table which is related to a selected record
  163. Novice help with list boxes
  164. Paper size selections in A97
  165. copying multi column listbox data to another multi column listbox
  166. Importing 4 separate records from one line of an import file
  167. Count Function
  168. Preventing Duplicate entries
  169. help with disaster/recovery procedures
  170. Using filter value to default for new records
  171. Access 97 on 64 Bit system (Windows Server 2003)
  172. Print hyperlink documents
  173. Utility: Splash screen with version information
  174. Ms Access database error."Could not update.Currently Locked"
  175. problem with number and char formatting..
  176. Strange behevior! The same code gives different results on same type of machines!
  177. Problem with Saving a Form
  178. How to link table of sql server to access database using ado
  179. Temp Child Tables
  180. Report format problem
  181. *** Access Programmer Available ***
  182. Trouble With "For Each" and "Next"
  183. Prevent Automatic Repair after crash
  184. Listing two fields
  185. Dataview subform options
  186. UI For Primary/Secondary/Tertiary Sort Keys?
  187. Creating Form
  188. Using DAO to access binary data in Sql Server 2005?
  189. Find Image File Size
  190. Problem with Pivot Tables in MS Access
  191. Vertical Bar Codes
  192. Running a database via the Internet
  193. three field conditional HELP!
  194. When i copied database to cd and i run it............
  195. page footer STUMPER
  196. Simple Query Question
  197. sql server 7, access97, different results when using a pass through query
  198. Database Structure Question ... Serious Help Only Pls
  199. Listbox query -show all records
  200. lost focus after update
  201. adding values within query
  202. sql server dates in access
  203. Pulling data from Access database into Intranet?
  204. Record-Level Security
  205. Syntax Error - Right join
  206. print reports on click
  207. What's Wrong with this code
  208. MAX NUMBER
  209. Access Query with Conditional Lookup. How?
  210. OpenReport option
  211. Contact database
  212. help with string issue
  213. transfertext imports incorrectly - weird values
  214. Update old record date when user click on D_Status
  215. Checking for doubles
  216. Releationship diagram goes haywire
  217. It won't work after converted from 97 to 2003
  218. Declare sql or not?
  219. Declare sql or not?
  220. Why Background of Tab Control is White
  221. A report where I want a record showing when a tick is not in place
  222. Prevent query-dialogs from popping up
  223. Display current record in a report
  224. Update query that adds 1 to a previous value
  225. DAP Adding an option group
  226. Update Query or Filter Table based on another Table
  227. Open MS Word and Insert Data
  228. Reading, writing and deleting records in access database, PLease help
  229. Graphs in Reports
  230. Macro: TextTransfer and overwriting
  231. Building Kits with Access
  232. custom log-in
  233. Putting values on clipboard
  234. Save Attachments to the Database
  235. Calculated field with age
  236. How to run a module using a menu bar
  237. Getting tired of being single?
  238. Help With Delimiting Text
  239. specifying path names on windows mobile
  240. Union select with All need to order by number
  241. Query Joining Four Tables, Return Rows from One Table Only
  242. Search number in a string
  243. SQL Query to lookup values from table into multiple fields
  244. More information on managed code UDF's in SQL Server 2005
  245. Table with Data in Uppercase that needs to be "Proper" case
  246. Database update problem
  247. form with Combo box with Parameter query report problems
  248. Tough (for me) Query question
  249. How long does recordset stay open?
  250. Do I need to set object = nothing?
  251. Report showing yes/no for overdue
  252. Counting in update query
  253. Names of textboxes on tab-pages within a tab control?
  254. Preferred method for SQL in VBA
  255. Locked dataase
  256. Setting OrderBy For Chart
  257. Distribution
  258. adding new employees and allowin the user to choose most fields from a combo box..
  259. Help with Report?
  260. HELP needed, cannot see table name
  261. Rank within a category (Sql)
  262. problem after load images in database..
  263. Sql - Rankproblem
  264. Autofill Listbox
  265. call 'procedure' from table view
  266. What's the best installation method for A2K2 application?
  267. Number of Concurrent Users?
  268. Working around not being able to update a union
  269. ms-access
  270. Problem with .follow method
  271. Change table property 'subdatasheet name' via code
  272. Set Access ComboBox Default Value to First in List
  273. Replicating excel function LinEst in Access VBA
  274. Checking for opened form
  275. Peformance issues on Win 2003 Server
  276. TransferText - Permission Denied
  277. Hitting Escape while Previewing Report
  278. A2K3 help vs predecessors
  279. Problem with conversion from 2000 -2003
  280. Dealing with Duplicate Information
  281. TransferDatabase passing variables
  282. requery subform
  283. personal finances
  284. using requery on subform
  285. Can you search a table name in queries?
  286. Programaticly Save As dBASE-5 format
  287. requery subform
  288. Can't Backup database
  289. Save a query as .csv
  290. saving query info in a table via a form
  291. Message Popup based on ID
  292. Access database Design
  293. Pass Parameters into report
  294. Simple query with "like" not working >:(
  295. Value from 1 form into another
  296. Distinct Query Help?
  297. Type Mismatch Error Fixed when Move ADO reference up - Why?
  298. Muti page report question
  299. Display values from another table into a continous form
  300. complex merge conditional on access field content
  301. How do I rank numbers by using Sql
  302. Getting certified in MS Access XP
  303. Using a pop-up for advance searching & populating a form
  304. Concatenate question
  305. Forms...
  306. Help Designing Speaker Evaluation Database
  307. If query has not records -"no records found" to be output in query out/report
  308. Text Box to List Box
  309. Check value by DLookup
  310. Percentage Stored As Double: Edit Formatting?
  311. form refresh
  312. collection question
  313. collection question
  314. State loss...
  315. Update query on the basis of three variables
  316. Open File using Variable Path?
  317. Set Control Source based on day of month (1st through 31st)
  318. On SetFocus, the text in the textbox get selected. I want the prompt to be AFTER the text
  319. Multiple queries in a report
  320. Utility: Find-as-you-type
  321. select max value from a table in ms access
  322. Report footer at bottom of last page
  323. "No Current Record" question
  324. Deleting a table - timing conflicts
  325. File parsing
  326. Simple Deployment Question
  327. Comparing 2 like tables
  328. Query and Report Parameters
  329. Can I link a Flash Main menu with Access database
  330. Access SQL version of CASE?
  331. Data entry validation
  332. configure field as random between 2 numbers?
  333. Oganization Problem
  334. Coditional Formatting in Form
  335. upsizing data issues
  336. MS Access Database File Size smaller then previous version
  337. Form returning incorrect data in ControlSource field
  338. Range dates on Acess report
  339. Using Access with FrontPage
  340. passing record information from one form to another when there's a subform
  341. Using Access with FrontPage
  342. passing record information from one form to another when there's a subform
  343. In a Query Listing one record several times
  344. How do I leave an Access Workgroup file?
  345. Is it considered best practice to distribute FE databases as MDEsrather than MDBs?
  346. What SQL query ?
  347. Help-How to delete a .mdb file?
  348. Help! Please. How can I erase this????
  349. Count Distinct
  350. Open a drop down on the basis of two options checked
  351. How do I...Calculate a field based on two other values entered in a form
  352. Please help! You do not have excluisve access to the database at this time
  353. How do I append a series of numbers from...to?
  354. Checkbox Form
  355. Updating form1 when changes are made to form 2
  356. Syntax of DLookup
  357. Wk Range Across Multiple Years
  358. how can I rotate a table so some of the current rows become column headings?
  359. Image problem in Search results - Access 2002
  360. subquery in a select statement?
  361. Images on continuous forms
  362. Combine 2 different Reports
  363. VB in Module to access Query Results
  364. Convert column result to rows
  365. Access database on Apache Web Server
  366. Problem with ControlTip Text on form/sub-form
  367. Which table's records get deleted?
  368. Duplicate Values
  369. ASP Search form refinement
  370. query to append and update?
  371. Populating table from webform
  372. Report need data from table 2 different ways
  373. set text box default value to be the current value
  374. Search form with realtime update as user print in letters
  375. building a multi level report
  376. publish database
  377. Menu Oddity, A2003
  378. combo to list box
  379. Form that does not have menu nor can be minimized
  380. User chooses field and value in query
  381. How do I make a field with multiple values
  382. Delet query with joined tables
  383. DSNless ODBC from Access 2000 database gets password not valid error
  384. Using Access for a multi user system
  385. Why do two queries on same table with same criteria return different dynasets?
  386. Remove Spaces
  387. How to find a record from values in another form.
  388. Complex Query?
  389. fields and forms
  390. Forms
  391. spliting the address line!
  392. Registry patch to set Microsoft Word 11 to Medium or Low Security
  393. Field on report visible or not depending on current date
  394. Error Procedure too large
  395. Report sums based on record dates
  396. to few parameters error working with recordset
  397. Client-Server databases
  398. Opening macros in design mode with code
  399. Compile-error. User defined type not defined? - A97
  400. How to know the total number of records
  401. Having issues trying to copy an array
  402. Random failure of Access 97 Application on XP
  403. subform.form reference problems (A97)
  404. how query delete
  405. Object Question
  406. Displaying a count of records that have been processed
  407. brackets added to pass through query
  408. Cant find project or library
  409. A couple of questions
  410. Procedure for filtering records displayed in a subform control...
  411. Checking for empty [xls] files BEFORE attempting the import
  412. Missing DAO 2.5/3.5 Compatibility Library
  413. Mailing
  414. MailMerge from a command button
  415. Access 2000 Report - trouble with data entered in subforms
  416. Thanks
  417. Query for records before paydays
  418. reference field on subform on tab control
  419. multi-lingual support in ms access
  420. Speed problem
  421. Ensuring non-null values in subdatasheet on record exit
  422. Are arrays in VBA stale, or I'm wrong?
  423. Table decimal places
  424. Property enable colour changed to grey how do I change it to another color
  425. User Documentation - Access Quirks/Features
  426. Buy a copy of access 2003?
  427. Pivot-Table Alternatives?
  428. Cross Tab Query Column head is primary key autonumber.
  429. Run Report Multiple Times With Different Parameters
  430. Access Calendar Control 11.0 12/1899 Date Problem
  431. Forms with Union
  432. Adding a combobox control to a shortcut menu
  433. Nesting queries
  434. SendKeys equivalent for MouseClick?
  435. How to combine date and time in the database
  436. Printing a particular part of a form
  437. type changing on a linked table
  438. Nested query bug?
  439. Post Code Lookup
  440. How can I use a value from a table as a criteria in a Query
  441. Copy data from one FORM to another FORM
  442. Fill recordset based on more than one combo box entry
  443. Name of query/table from where values are pass into table
  444. Lame String Parsing Question
  445. PLEASE HELP with Query
  446. Syntax Error in Query
  447. Primary key insertion/sorting of linked tables
  448. Error accessing file?
  449. Access APD question.
  450. Link Tables to Lotus Database or View?
  451. Conditonal formatting
  452. If statement for an Open Event if button click
  453. Form is link with another form
  454. How to macth a record everytime a form is open
  455. scrollbars
  456. Wasteful fields
  457. Reuse Report and Query and OutputTo - Must be a Way!
  458. Cmd Button enabled based on combo box
  459. Have form not navigate out of current form
  460. Reports by choosing date
  461. Need help with sorting by date
  462. Synchronized combo boxes, dependent field not showing all options after migration of data
  463. finding out system date settings on workstation
  464. VB Program with Jet db engine - SQL2005 Express or rewrite in Access?
  465. Date Query
  466. Printing problem
  467. Remove access message during update
  468. CurrentDB openRecordset search failed....
  469. Error message
  470. Auto fill
  471. Export portion of Access table to Excel
  472. On Line Test Website
  473. QBF search criteria to report
  474. What version of jet
  475. Call by reference
  476. Remove Data Control from form
  477. Insert into a database
  478. call Form by button
  479. Is there a way to secure/locked data after submit?
  480. VBA code to save file from http to hard drive?
  481. help with deleted switchboard form?
  482. Link form another database table into current database
  483. Help write a SQL in VBA
  484. Group and Count
  485. Call form from another databsae by button
  486. Input Mask:>C;; ValidationRule=In("T","F"," ") AutoTab:Yes ;-(
  487. Filter-by-form + date range filter
  488. Two databases
  489. changing textboxes in a report at run time
  490. Tab Order Add-In?
  491. Object Required
  492. count feature (group by)
  493. Query Problem
  494. Link Tables to SQL Error
  495. select unique identifiers
  496. MS Query - STANDARD DATE to YEAR-MONTH
  497. Can't edit data in a subform
  498. how to i run the update query on the table
  499. Form wont 're-open' if opened from macro using menubar
  500. Changing values
  501. Query stuck
  502. ODBC problem with Access Queries to linked tables to SQL Server 2000
  503. querydef........
  504. Shell to Word and load a specific document
  505. option Group
  506. Fill Colour in Conditional Formatting does not print.
  507. Please participate in a non-profit academic research
  508. Is it possible
  509. How to set query parameters from VBA
  510. Function to remove zero-length strings in MS SQL
  511. Adding 1 to the previous highest value in a field
  512. database not allowing multiusers
  513. Access and Apache
  514. Query to calculate liquid used from a tank
  515. Show certain data
  516. Access Beta 2007 - your thoughts..
  517. Sorting clients by incremental number in Report.
  518. Shared form on network not retaining values?
  519. Deselect all checkboxes by one query
  520. time card example question Access ADP SQL Server 2005
  521. OLE bound photographs
  522. Try to set values of a text box thru code
  523. Linking to Access 97 Database on net
  524. Distributing an Access program
  525. Value shows only in debug mode in form
  526. Bind the whole method with a text box
  527. Calculating 55th Bday from DOB over 1500records, exporting to new field
  528. How can I find out where a table is being used in my access db?
  529. Updating Data from a form
  530. Creating Delete Query Where Related Data is Null or Empty on the Other Table
  531. How to reference every record in Continuous forms?
  532. Coloured box in report when matching a certain string or character
  533. Repeat same value in the text box
  534. Help with counter condition!
  535. Help in query
  536. Bound text filed
  537. Creating Page in the Form View
  538. Error data type mismatch
  539. Report Totals
  540. Unique Number for each row
  541. Simple question - excluding a groupby
  542. Need maximum date
  543. Copy values
  544. list of tables in mdb file
  545. Save/Write record while still in form
  546. Type Mismatch
  547. Unique Records Question
  548. Stop to Scroll the whole form
  549. Create a mirror from 1st subform variable into 2nd subform variable.
  550. Lookup