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. let and get
  2. Size Limits for latest versions
  3. let and get
  4. Reading first line of textbox Updating in AfterUpdate
  5. Office Assistant Won't Die
  6. FYI new version of Auto FE Updater
  7. why use a class module
  8. why use the word public in a function
  9. creating a timed event for table to save to .txt file twice a day
  10. Access 2003 Developer IN Which CD......
  11. First name and last name
  12. CreateObject("Excel.Application") on NT 4.0
  13. Get Data from SQL to Access - via Access
  14. Securing a Database
  15. Form trouble
  16. Programatically Delete Command Button
  17. Access 2003 - Country Code Not Like Canada or USA
  18. !!FAQ! for Date: 20040524 - New Users Look Here! [Last Updated February 05, 2004]
  19. Wrong record retrieved after move to SQL Svr
  20. MS Access questions
  21. Converting toolbars from Access97 to Access2000 throug VBA
  22. Populating Form fields with data from a seperate table
  23. ALTER TABLE ... ADD COLUMN with SQL Server
  24. UNDO/BACK on forms with successive filters
  25. Enabling/ Disabling Combo Boxes
  26. help required sending email attachments??
  27. crystal reports
  28. Use Enter key to Apply Filter
  29. SQL question
  30. "Replace" supported in 97?
  31. ldb and db corrupt
  32. updating a table from a form
  33. Invalid Character Value - Access97 Front with SQL Server 2000 Back
  34. MSSQL to ACCESS Problems
  35. Problems emailing from a specific computer
  36. help! How to make a mdb run in the windows without access?
  37. Problems emailing from a specific computer
  38. user permissions using VBA
  39. Runtime Packaging wizard question
  40. Packaging Wizard error
  41. HOW TO UPDATE A TABLE BASED ON CHANGES IN ANOTHER TABLE?
  42. form on open calculation problem
  43. Random Query??
  44. access back-end on the internet
  45. Frustrating data entry problem
  46. Race Hours
  47. Need regular expression for this
  48. Lebans Calendar open where last dragged
  49. Is a table open or visible
  50. Thermometer form does not repaint - Access looses focus
  51. Manage form + subform as a single record
  52. Adding multiple records to a subform using VB
  53. replacing text during output
  54. Closing form
  55. !!FAQ! for Date: 20040523 - New Users Look Here! [Last Updated February 05, 2004]
  56. error checking for DoCmd.GoToRecord acNext when it is the last record
  57. Backend Database on Web Server
  58. E-mail addresses in a table how to
  59. Run Time Version
  60. ACCESS 2000: Problem Calling Sub using the eval method
  61. is it that complex?
  62. Is Null pproblem
  63. Calculated fields 2
  64. Prevent Access DB from being opened twice
  65. Two chart questions
  66. Continuous Subform showing as Single form
  67. Number field need * added before and after the number for barcode font
  68. MS Access data going to Excel question
  69. !!FAQ! for Date: 20040522 - New Users Look Here! [Last Updated February 05, 2004]
  70. Create Table, Add fields, Relationship and Link
  71. Numbering of records
  72. sendobject as snapshot
  73. Code not working on network
  74. Outlook Automation and err 429 ActiveX component can't create object
  75. Permissions problem caused by compact
  76. Accessing text box value
  77. link to database file
  78. Filtering a listbox
  79. Click on SubForm record and populate main form
  80. Password
  81. LDB file
  82. Updating a combo box in a subform
  83. ISV Subscription
  84. SQL joins and MID function
  85. VBA vs Visual Basic
  86. Password Retrieval
  87. Stay OnTop - Query
  88. Iif & Checkbox
  89. select form on the background
  90. sorting problem
  91. !!FAQ! for Date: 20040521 - New Users Look Here! [Last Updated February 05, 2004]
  92. Deleting Forms in other Database stops with error 2051
  93. Tab Control display issue
  94. selecting a specific date range
  95. activeX controls don't call events procedures
  96. How do I define my db if I'm working on Access 2000 and also linking to SQL Server Enterprise Manager
  97. external image files on a report (continuation)
  98. Activex problem
  99. Can i use the reference Jet 2.5/3.5 in Access 2003 without any problems?
  100. What is 'Fetch Defaults' for?
  101. Where is Menubuilder in Access XP
  102. dropdown box similar to the start menu in windows
  103. Field in Form limited to 50 characters
  104. how to get the ID autonumber field to be added when importing
  105. Date problem with Access 97
  106. How do you create a mult-record update?
  107. Date and time format conversion problem (not the usual)
  108. best event for update code?
  109. SQL Criteria from a Form in Code
  110. How do you "look up" a value in an access subform?
  111. speed sql vs recordset
  112. Numeric Field Overflow error
  113. Runaway Scrolling In Form
  114. Form freeze (Access 97 and Access 2002)
  115. Union Query Problem
  116. HELP: Conditional Formatting with VBA Code
  117. Extra spaces in Access Records.
  118. add records to table with combobox ?
  119. Update a Listbox after making a change in a field
  120. Simultaneous VB.Net and Access on Jet 4.0
  121. DOS command in access
  122. Field into a continuous string
  123. DoCmd.RunSQL vs rs.Open
  124. Input Mask in Access 97
  125. Automatic update in form field
  126. Audit Trail
  127. Access/VBA irritants
  128. How To Make A VB prog. Resident in taskmanager tray
  129. !!FAQ! for Date: 20040520 - New Users Look Here! [Last Updated February 05, 2004]
  130. Disabling SHIFT Bypass Key for Users in MS Access 2k, but Not Network Administrators.
  131. Charts in Access Reports
  132. Can We Create A DialUp Connection Thru VB ??
  133. Access Skills for Job Interview
  134. How do you duplicate a record
  135. Outlook Automation and graphics
  136. Calling upsizing wizard from VBA
  137. Help please with importing data from xls.
  138. Storing Redundant Data Is Great!
  139. Storing Redundant Data Is Great!
  140. Increment a number field
  141. what is the limit to record size in access
  142. Where in form do I paste codes after copying
  143. duplciating record
  144. No input updating
  145. access front end
  146. tricky statistics problem
  147. Acc97: Code Will Not Compile on Another Machine
  148. Creating PDF Reports from Access 97
  149. Problem with "OnClick"
  150. auto write for read only users
  151. Access vs SQL
  152. Control Combo Box selection
  153. Report desn't open: error 2501
  154. Photodraw filter and MS Access 2000 error
  155. How to look-up a read-only subform via a linked field in a form...
  156. current record with conditional formatting
  157. Auto Update Month in Calendar
  158. Dim As Database
  159. DoCmd.TransferText acImportDelim
  160. error log
  161. error line
  162. error and exit statements
  163. Access Run Time in the MAC environment Err: object not set
  164. Alternate address book
  165. Field Totals??
  166. Outlook user property
  167. Is it possible to capture print output
  168. Using forms and queries.
  169. Access going slow on new server hardware setup
  170. .Net Class in Access 2000
  171. Get toolbars and menus back
  172. complex query question
  173. Access 2K query returns different results when run in code than whenrun manually
  174. Cannot Lock a Table via ADO
  175. using form to display a variable in a module
  176. Error in Office XP Developers Package and Deployment Wizard.
  177. protect access from altering/copying data, how
  178. ms-access db script creation
  179. How to store a date entered into a query?
  180. Help with the requery command
  181. Access 2002 vs Access 97 Performance
  182. variable sub form sum value
  183. Form Subform Invoice Question
  184. !!FAQ! for Date: 20040519 - New Users Look Here! [Last Updated February 05, 2004]
  185. really need some help writing some code in an access query
  186. The Many-to-Many Relationship
  187. Insert question
  188. Having a problem with the date field
  189. Help me write some simple codes... I am not a programmer
  190. Access XP issues
  191. New DB Compacts to half the size?
  192. Access - crash when moving to next record...
  193. Access 97 Bloat with Forms & Queries
  194. insert current date on a subform with Before Insert event
  195. Linking to MS Word
  196. data from text box to stAppName statement
  197. triple state toggle button problem (Access 97)
  198. Record and Print
  199. Constant error with calculation
  200. Changing "completed" records to "read only"
  201. Hyperlink on unbound control
  202. NT, CDO, SMTP
  203. Add numbers from multiple records...
  204. Importing xls file to linked tables
  205. error handling - a couple of questions:
  206. How to send email via code in an Access Project?
  207. Outlook Addressbook and Access ADP Project
  208. Need Help Query
  209. tiling two objects vertically
  210. Suggestions about a graph control
  211. Changing graph axis min max on report
  212. Linked Forms?
  213. Need Help Subform Data Sheet
  214. Limit Data Entry To Three Records
  215. Emailing a file using access
  216. access 97 backend with 2000, 2002, and 2003 front ends
  217. Access 97 idea files - question
  218. Printing with a dot-matrix printer question
  219. requerying subform
  220. Simple Report Codes... for a newbee
  221. Google groups email spider,Auction software, Directory PPC search engine software, email spiders - 5
  222. Using substitute function from Excel in Access
  223. Can table ownership be changed during upsize to SQL
  224. Default Table Size and Menubars
  225. need help writing some code in an access query
  226. SendObject
  227. SendObject text in body on 1 line
  228. Sending a report (generated by MS/ACCESS) as an email attachment
  229. Securing a split database without user level security
  230. Looping problems
  231. !!FAQ! for Date: 20040518 - New Users Look Here! [Last Updated February 05, 2004]
  232. Another run-time error 3061 issue
  233. Access 97 memory could not be written
  234. rotating a report design
  235. ADO Excel WorkSheet Naming WorkSheet Access Database Part 2
  236. ADO Excel WorkGroup Formatting Access Database Part 1
  237. Data Type text and string one field.
  238. VBA SendObject using Lotus Notes
  239. Is Access a RDBMS???
  240. Parenthesis doesn't work for referencing query fields
  241. Stored procedure problem
  242. how do I create a folder/file browser in Access 2003???
  243. truncated long filenames using kill etc.
  244. Dlookup Function giving error in SQL String
  245. On Click on Page
  246. Naming convention clarification
  247. Converting Access Database and/or tables to SQL 2000
  248. combo box conversion problem
  249. Importing excel into Access: Reports primary key violation when there is not!
  250. Guid
  251. Basic table lookup in Access 2000 combo boxes
  252. Refresh pass-through query ODBC connections?
  253. MSDE
  254. Checkbox code problem
  255. How to make this loop?
  256. Multiple Validation Rules in Form Field
  257. fund raising problem
  258. can you pass a function to a sql statement?
  259. subquery/nested query - do I need to redesign my query or my database?
  260. !!FAQ! for Date: 20040517 - New Users Look Here! [Last Updated February 05, 2004]
  261. Problem with Generating a schedule...
  262. Outlook Automation Late Binding
  263. Peripheral clock
  264. MS SQL to MS Access Stored Proc. for Deletes
  265. Wierd Access Crash
  266. A2K: Report hangs whith subreport on 2 pages
  267. Access DB Quotation Help - Remote Web access to DB
  268. Calculated fields
  269. Select Collating Sequence not supported by the operating system
  270. Unsure about Report Page Break Control.....
  271. Inital query from VBA code
  272. Autonumber problem
  273. truncated file using Dev's "Internet Data Transfer Library"
  274. Import with TransferText
  275. Linked tables and ADO
  276. how to prevent scrolling buttons
  277. Calendar Display
  278. A2K - trapping printer error
  279. Advice on an expanding Access project
  280. A97: Linking tables to SQL Server 2K
  281. Array basics - how to return index number?
  282. Printing current record of query result to a report
  283. "Access needs to close" when refreshing a form in Acc2002 but not in 2000
  284. tick multiple check boxes on multiple sub-form records
  285. !!FAQ! for Date: 20040516 - New Users Look Here! [Last Updated February 05, 2004]
  286. Please help a moron - Query of subforms
  287. Multiple Table Query using Sum Function
  288. Access and email
  289. Unmatched Query with Multiple Tables
  290. How to make form field content dependent on another field's content
  291. Searching for serial numbers
  292. Table Design
  293. delete all modules within the form
  294. Getting the text of a control with Windowclass OKttbx
  295. DoCmd.OutputTo produces Access XP hangs
  296. update from another form
  297. Labels on a Report
  298. text boxes with numbers don't total if one of the boxes is empty, if I add a zero then they total
  299. Trying to get info from form to a report
  300. Multiple-liine "OR" QBE vs. Single line "OR"
  301. NEed to duplicate a record in Access using SQL or maybe not
  302. handling tab key
  303. Consecutive numbers
  304. Consecutive numbers
  305. calculating Total in a textbox on a form, how can I calculate the total of several text boxes in another textbox on the same form?
  306. Run-time error 3155 ODBC insert on linked table failed
  307. Exporting To Excel From Access 2000 Syntax Question
  308. uodate simplified
  309. opening balance - closing balance
  310. TransferText question with decimal
  311. How to link to a website
  312. Filter within a filter
  313. How do you force a re-converting from A97 to A2002
  314. A Beginner
  315. Looking for a Creative Solution to a Group By Query problem.
  316. Determine form/VBA procedure from Access crash dump?
  317. Problem on adding new records
  318. Access report Q.
  319. Using API calls
  320. autonumbers, updating tables, and user entries
  321. Determine last record in a query and selection filter
  322. Using a Text file with Long Rows as an Input Data Source
  323. Hardcode Definiton
  324. query on report
  325. Form Doesn't Go To New Record
  326. How can I create an 'email merge?'
  327. Reading records into Crystal Report for export as Excel?
  328. Right click menu
  329. Form interaction
  330. Turning database into MDE
  331. problem with exporting to a text file: tricky
  332. Subquery looking for missing information
  333. confidence intervals
  334. "keywords like '*[forms].[frmsearch].[kwords]*' " <--whats wrong with this?????????
  335. Can you e-mail a report to an e-mail address stored in a Hyperlink field?
  336. Serial Communications with Access/vb
  337. problem getting values on a form
  338. Comparing Data with null values
  339. reading and adding in the same recordset?
  340. Disabling menu and toolbar items
  341. Formatting a Decimal number in Unbound field
  342. importing an RTF comma delimited file
  343. Access 2002 - missing indexes
  344. question about inventory
  345. Combobox item select problem
  346. Date function turning to date
  347. Problem printing report from VBA
  348. trap odbc errors
  349. Updating code/forms on working database while keeping data intact.
  350. Treeview and Access2K in multiuser environment
  351. relations in access
  352. runtime distribution A2000
  353. Serial Port Communication
  354. Determine lastRecord keynumber
  355. Control the position the API: Call Windows File Open/Save Dialog Box opens at
  356. The MenuBar
  357. Novice Question. NZ function
  358. connection problem after conversion 97 to 2002
  359. Delayed Updates....
  360. port sql2000 structure to access 2000
  361. Call VBA program in ASP
  362. Listbox works and then it doesn't
  363. Can VB or VBA code manipulate PDF files?
  364. Problems Printing Mailing Labels...
  365. Data taken from one record and placed into another record
  366. Date Query
  367. #error problem
  368. Combine Field from Multiple Records into One
  369. VBA Broken - Unable to Compile
  370. Add Current Date To Table After Mail Merge
  371. whatswrong
  372. is there a limit to array size?
  373. !!FAQ! for Date: 20040512 - New Users Look Here! [Last Updated February 05, 2004]
  374. Exporting html to folders
  375. Complex query question
  376. Access to SQL Server - Upsizing - dbo
  377. Breaking the 127 point font size barrier with MS Forms 2.0 OCX and VB6
  378. Application minimize VBA question
  379. one frontend different type of backends
  380. Compare two tables and give me results of fields that differ in new table.
  381. need help with append
  382. Second POST.. Help with report summary
  383. Converting databases tfrom an older to a later version
  384. How to track versions of a record?
  385. Missing ControlTip Text In Access 2003
  386. DoCmd.OutputTo Help...
  387. Opening report in design mode
  388. Update Query on 2 Tables? Bad Code?
  389. Custom Reports by Form input (user picks report options on Form and gets report showing options picked)
  390. DSN-less ODBC questions
  391. FileCopy - How to turn on/off Error Handling?
  392. images in reports ... only drawn sometimes
  393. dates
  394. Template for "Completed Project Database"
  395. Re-linking database through code
  396. Two Subforms - Same Record
  397. Connecting to Outlook Inbox - how to get to attachments
  398. using query to format date
  399. Autonumber foreign keys and subforms
  400. Changing the object name/report name of snapshot report based on a date range
  401. recover deleted records from backup, best approach?
  402. Form Does Not Go To New Record
  403. Table relationships problem. Difficulty Hard (for me anyway).
  404. DSum reference in a report
  405. !!FAQ! for Date: 20040511 - New Users Look Here! [Last Updated February 05, 2004]
  406. Easiest way to retrieve a file from website??
  407. Word won't hold ODBC data source
  408. linking fields
  409. Importing Same Name Tables into updated db
  410. Import dynamically named files using macro
  411. Copy form control value to table field
  412. ListBox multi selection string
  413. Overflow Error message
  414. Im new in this and I need some help
  415. query or module needed
  416. Import Data Problem
  417. CDR billing software
  418. Is it possible to delete the security protection of my own db
  419. class modules
  420. One column flashing on continous form
  421. Emailing from MS Access XP using Lotus Domino Objects
  422. Recovering table
  423. Field Formatting Problem in SubForm
  424. Option Group with literal argument
  425. close tapi dialer in XP after dialing number via access vba
  426. Error Handler Wizard -- Access 97
  427. Validation rule across tables using form's BeforeUpdate event
  428. Difficult Question Access 2000 Litwin Gibert and Getz book
  429. !!FAQ! for Date: 20040510 - New Users Look Here! [Last Updated February 05, 2004]
  430. Confused - Nwind.mdb
  431. Error numbers
  432. Autonumber field and some more
  433. Query help: need at least one row for each value in each of two columns
  434. Tab order and subforms
  435. Access creating faxes
  436. I need a command button on a report...any ideas?
  437. updating a table from a form
  438. How do i set the autonumber back to 1
  439. ASP.NET / Access query Problem
  440. Replication conflicts
  441. ocx versions 5 & 6 Incompatibilty
  442. ? Convert program to an EXE ?
  443. Problem with calculations...........
  444. txtbox position problem
  445. Access: Form heigh
  446. Automatic Tracking Number
  447. Secure Access 2000 database
  448. Controlling Dates in Access 2000
  449. How to delete a record
  450. recordset not updatable
  451. MSAccess - CrystalReports - delays
  452. Setting DefaultValue Property
  453. Percentiles in Access97
  454. Updateing Records
  455. Avoid Creating A Duplicate Record
  456. Subform slownes
  457. automatically filling up fields
  458. Requery unbound listbox on master forces requery of subforms?
  459. SQL Query
  460. Office XP Developer - Where's the beef?
  461. Goto E-mail
  462. !!FAQ! for Date: 20040509 - New Users Look Here! [Last Updated February 05, 2004]
  463. Search text files from within Access
  464. AC2000 - hitting enter after zooming a memo field closes the zoom instead of creating a new line
  465. Carry Field Forward
  466. I need a little help... INSERT INTO SQL Command
  467. Gala Database
  468. Gala Event
  469. Access and ASP issue
  470. inserting values from lookup table based on a combo box entry
  471. Command Button Wizard
  472. adding to the file menu
  473. Drag and Drop
  474. Adding pictures to my database ?
  475. Combo-Box Problem.
  476. Splitting applications in access (two applications sharing one DB) how to link applications?
  477. Why did autorun stop working for installing my custom application?
  478. Why did my "Autorun" suddenly stop working for installing my custom application
  479. Rich Text Editor
  480. compact and repair automatically a lot of ms-access db
  481. Menus
  482. Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number
  483. Licence No for end user
  484. Can I easily determine the data mode for an open form object?
  485. IIF Cirtiera in a qury
  486. Time Elapsed between two dates and two times
  487. VB Command Syntax
  488. Some Application Code Pertinent to Financial Planning???
  489. If And Statement not working
  490. sql
  491. Summarize a calculated field in a report footer
  492. Conditional Formatting Based on Control Break
  493. security worry on workgroup file
  494. Multiple Users & ODBC over a Network......
  495. special query
  496. Hiding a SP in Access under Query, but retain Execute on SP
  497. a query with wildcard
  498. HOWTO? determine selected columns in datasheet
  499. Opening a Word doc with Access
  500. how to secure adp project?
  501. Question?
  502. case never match
  503. Action on Error Condition with MACROS
  504. Autonumbering
  505. Update query
  506. security worry on workgroup file
  507. Is it possible for my database to change to fit a new mdw file?
  508. Jet Version
  509. Access 2000 and hard drive access
  510. Move/resize access application from VBA
  511. Search engine source
  512. App path
  513. Locked Record Indicator
  514. Take a hike, "Jerry Linson" - you're nothin but a useless troll!
  515. screens mixing up
  516. Time Syntax in query
  517. A2K - changing database password
  518. can not move mdw file
  519. Can options in Tools => Options be set programmatically?
  520. move to a particular record in a list box?
  521. Error 3190
  522. Error whenenver I open a database
  523. joinig or combining two tables in ms-acces
  524. Question about summing a total in a report
  525. Global Address List
  526. Run Time Import/Mapping Tool
  527. Sql manipulation ...
  528. repeat report
  529. DATE() does not work on Windows 2000
  530. Recordsets
  531. epos
  532. TransferSpreadsheet
  533. forms query
  534. go to specific record from data typed in text box
  535. requery subform
  536. A simple query problem
  537. User Input Licence No
  538. importing Xls file with a "Button"
  539. SQL Query question
  540. Convert access into ...
  541. DSUM
  542. RSA source code- (or some other) -please
  543. Shrink image in report-detail
  544. Runtime Error/OpenDialog box
  545. Encryption
  546. send query in xls format by email --- sendobject
  547. Saving calculated values, Please
  548. Need SQL Query to determine max value from fields in a row
  549. Anti-Sasser Worm Message
  550. ODBC Connection