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. How to hide tables from the Import Wizard
  2. Disappearing forms!
  3. Please Help Passing Variable from Form to Query
  4. !!FAQ! for Date: 20031219 - New Users Look Here! [Last Updated November 30, 2003]
  5. wanted: database publishing tool for MS Access
  6. Setting Controls from a Table in Access 97
  7. Shrink the size of a field
  8. Check Box Size
  9. Duplicate values
  10. Screen Preview differs from Print Out
  11. How to pass multiple arguments when calling Function?
  12. Trouble with Access Like Query in ASP
  13. Update a Form Field
  14. urgent : access sub-reports as popup
  15. Spaces in Field Names?
  16. Find Front End
  17. Automating queries by using a reference date.
  18. Moving data to SQL Server
  19. Access 97 on PC with more than 1 GB of RAM (Terminal Server)
  20. Problems with Access XP and SQL Server
  21. Memo datatype got trucated
  22. I want to make a web interface for my database...
  23. DllRegisterServer in MSFLXGRD.OCX failed
  24. SQL: INSERT INTO without specifying any column
  25. 100 Day Statistics for comp.databases.ms-access
  26. Statistics for comp.databases.ms-access
  27. Access Word 2003 Automation
  28. need help with vertical (columnar) datasheets
  29. Time-keeping with Access 2000
  30. Access 97 Database converted to Access 2000 - Controls do not work
  31. PivotTable date groupings
  32. emailing from a form
  33. Application Icon Location
  34. Viewing table as subform and seeing linked items
  35. Call query design view from code
  36. When does Does "On Open" execute?
  37. Passing Discontinuous Range (Array) of Values to User-Defined Function
  38. Iif Statement Returns Error in Form
  39. Send a draft message to mailing list
  40. multiple append queries using VBA
  41. !!FAQ! for Date: 20031218 - New Users Look Here! [Last Updated November 30, 2003]
  42. Importing Tables from SQL Server to Access with Keys and Indices preserved
  43. Searching for the right word to encompass 'Supplier' and 'Consumer'
  44. Automating queries by using a reference date.
  45. Is 2.3 MB too big for a simple database?
  46. Selecting from Text File Truncates String
  47. Is this possible?
  48. 255 Column Limit using Microsoft Access
  49. Selecting from Text File Truncates Long Strings
  50. Get the name of the function or sub from within code?
  51. Non-Duplicate List Of Products
  52. Display date with 4 digit year
  53. update combo box
  54. Access 2002: Replication question
  55. Stephen LeBans JustiDirect text justification
  56. Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
  57. Larry, for you . . .
  58. Save a record programmatically from a form's module
  59. Updating Linked Table - why is action query failing?
  60. Can't update a recordset after filtering
  61. Update Inventory
  62. One customer gets #error
  63. Determining where a control is on a form; header, detail, or footer
  64. Conditional state of a record
  65. VB - Question for OpenForm Criteria
  66. Assistance needed with a small piece of code
  67. The Paperless Office is Now!
  68. No $ for Currency fields
  69. How do I?
  70. Populate control in another form
  71. Redemption Not Blocking Latest Security Prompt
  72. Acc 97, expressions
  73. SQL - joining 5 tables - not all records retrieved
  74. help with unbound fields
  75. !!FAQ! for Date: 20031217 - New Users Look Here! [Last Updated November 30, 2003]
  76. Paste Into A Combo Box
  77. Tabellen von verschiedenen DBs in eine DB kopieren
  78. Combo Box inital value to display
  79. DateValue
  80. What this query return ERROR?? :(
  81. Access 2002: Bar code problem
  82. Get the name or HelpContextID of a Toolbar Object?
  83. Problem retrieving printer information for this object
  84. Help: batch method to get .MDB table names ???
  85. A2K2 AllowAdditions
  86. Cannot import .xls file (Access 2k)
  87. Problem with Check Box use to Change Field Values
  88. Struggling with linked database problem
  89. Labels Dialog Box Enhancement
  90. Justdirect text justification
  91. Control Of What Is Printed In Page Footer
  92. Register a dll
  93. addresses
  94. I'm rusty on my Access...can anyone help with a Query question?
  95. Viewing linked entries in a subform
  96. How to loop through a record set.....?
  97. Problem Duplicating Forms in Access 2000
  98. Modifying an import specification doesn't work.
  99. Best way to handle distributing runtime installables from the web??? (slightly O.T.)
  100. Is there a trick to not have a cross-tab query sort the column headings?
  101. how I protect my DB with serial number disk?
  102. Report in Access project
  103. The above post is a forgery. Ignore
  104. MetaData Repository Standards?
  105. Parameter Value in IIF
  106. Using access to complete company forms
  107. problem with my code
  108. Sync Access with Palm PDA
  109. Adding a New Field to an existing Form
  110. Double Merge in a Access Report Possible??
  111. Getting User Name form Login (System enviroment variable?)
  112. A97: Get the month, day, and year from a date field in a table
  113. concatenated form fields
  114. !!FAQ! for Date: 20031216 - New Users Look Here! [Last Updated November 30, 2003]
  115. The IsNull function requires 2 arguments
  116. Help with DCount function and filter
  117. Lookup field created with VBA ?
  118. Protecting your work
  119. Access 2003 pivot-table view gone?!?
  120. form field validation
  121. MSFT Access Unable to create MDE
  122. Iterate through all queries in database and set description
  123. Using Access with LDAP
  124. labelling
  125. Filter Sort Wild Card?
  126. A97 - Detect Idle Time
  127. How do you create a Report or query for the # last days?
  128. Date field
  129. Access 2002: Updating 2 same database
  130. Group total in distinct field
  131. Copy field with DoCmd
  132. Changing field types with Excel as linked table
  133. Can I use VBA to import/link tables?
  134. SQL INSERT INTO a table using information from two other tables
  135. Possible fix for Pivot Table grayed out or no row or column sight problem in Access 2002 XP
  136. Uninstall
  137. Access 2000 - Use ADO.Recordset as Report Recordsource
  138. Replace text in a field?
  139. Go To Current Record
  140. How to Lock and Hide Access Tables?
  141. Creating report using ASP with MS-Access
  142. Beginner: Open Main Switchboard Item in Datasheet view?
  143. Do NOT click on ANY URL's posted in CDMA
  144. changing a form to a subform (VB problems)
  145. BEWARE LINKS POSTED FROM SODOMIZERS!
  146. Access 97 Complication
  147. How to merge two distinct records into a single record?
  148. Alternative row color with a sub report
  149. Text Box Assistance
  150. Access freezing while printing
  151. Changing Colors of fields on a report
  152. Beginner: Mde error- couldn't make changes
  153. Any way to record the progress of a query while it is running in Access 2000?
  154. Finding Login Name for a Group Login
  155. !!FAQ! for Date: 20031215 - New Users Look Here! [Last Updated November 30, 2003]
  156. Database window appears when it should not!
  157. Access Run Time: Alternative Version
  158. foxpro compared to access......can they do the same thing
  159. records in report disappear after design viewing
  160. FTP with Login and Password - what is wrong with this?
  161. Problem with DoCmd.OpenForm
  162. Dialog Box Not Dialogging
  163. parameter query
  164. Connect to back end for non logged on user
  165. Relationships and Cascading Updates problem
  166. Relationships
  167. Display of Menu bar while access is starting
  168. Table column is automatically populating itself
  169. SQL utility form for Access
  170. <<HELP>> Getting rid of part of a text field
  171. One Step Merge Document and E-Mail to a Group
  172. Update MS Access table from another table
  173. BEWARE LINKS POSTED FROM ANONYMIZERS!
  174. Subreport question
  175. How to: Filter Against Fields
  176. Access 2000 Missing Wizards
  177. Invalid Procedure Call or Argument (Left, Mid, etc.)
  178. !!FAQ! for Date: 20031214 - New Users Look Here! [Last Updated November 30, 2003]
  179. Problem retrieving printer information
  180. How to SELECT hyperlink.htm FROM table?
  181. Error on opening a database: MS JEt database says someone tries to modify the file
  182. Use Access 97 or Access 2003
  183. Do I use Nz
  184. Access & system settings
  185. Error on opening a database: MS JEt database says someone tries to modify the file
  186. Sample files
  187. updating/adding to another table
  188. Send email - capture ProfileName from MAPI
  189. Microsoft Access license to distribute runtime components
  190. Get actual text of error trapped by Form_Error?
  191. Quieres ganar dinero extra para pagar tus deudas lee esto......
  192. Different Versions of Access on Same Computer
  193. a2k - weird code behaviour I can't explain...
  194. Updating Yes/No Fields !
  195. Time formats
  196. MS Access '97 and MS-Office XP-SBE, would it work?
  197. Parsing some text data into records...
  198. update blank table record field
  199. Forms and Form
  200. !!FAQ! for Date: 20031213 - New Users Look Here! [Last Updated November 30, 2003]
  201. Report Writer question: can I do a "top ten"
  202. Re-entering combo boxes
  203. Beginner: Can a form edit identical data from more than one table?
  204. Installer problems
  205. Save files attached to an email
  206. Access data through MS query in Excel.
  207. The meaning of "Me!"
  208. Sudden shut down when saving a Query
  209. make modules and tables invisible bt code
  210. Office 2000/XP Menu items
  211. Another SQL Question - Update Value with Column Name
  212. Referring to a variable field using SQL
  213. Calling Procedure on other form
  214. Log user on opening
  215. Specifications - limit on # of rows?
  216. Help with Access XP Error 2001 "You canceled the previous operation"
  217. Outlook automation from Access?
  218. Printing a Word Document from ACCESS
  219. Opening the main toolbar in VBA
  220. PHONY FAQ
  221. Problem w/MSINET.OCX in Acc97 runtime
  222. Saving Email Attachments To A Folder
  223. Run time error, "The data has been changed."
  224. Listboxes
  225. Access and Calendars
  226. Close report without save prompt after setting input parameters
  227. !!FAQ! for Date: 20031212 - New Users Look Here! [Last Updated November 30, 2003]
  228. [vba] looping through an array
  229. Access Service Patch version thru VBA
  230. How Do I create a new record from an existing record
  231. DHL or FedEx Track Links in SendObject Body For outlook?
  232. File Open Dialog Box
  233. Dim MyDbs As Database
  234. How to calculate time duration?
  235. Replacing data in a table WITHOUT changing the numbers created from a running sum..
  236. Call One Access Application from Another
  237. Text Files
  238. ODBC call-failed error
  239. VBA Code learner Please Help
  240. Help on Access... 2.0! Really! And on 2003...
  241. Help on Access... 2.0! Really! And on 2003...
  242. help with combo box requery
  243. Using an Access app without Access?
  244. Column Names
  245. Conflicting Versions
  246. Another database bloat question.
  247. Imorting Excel sheets e-mail attachments
  248. Time stamping on a network with no dedicated servers
  249. CompactDatabase fails with Invalid Argument error
  250. Printer/Page setting disappear when front end MDB copied to another PC
  251. Data Input Database Design Help
  252. OutputTo Macro problems...
  253. Freeze Columns
  254. multiple user access on shared network drive possible?
  255. Field type with greater than, less than signs
  256. Intellisense Window Closes too Quickly
  257. Corrupted file A2002 ???
  258. Subform and button on parentform
  259. Something to be said for a moderated newsgroup
  260. Select top 100 from table1 does not work? Is there another syntax?
  261. Show if a parent record has a child record.
  262. Sequential numbering
  263. Creating a Query in VB
  264. CPU Type in Access VBA?
  265. Tool for finding references to and from tables/queries/reports/forms/objects
  266. URGENT--PLEASE HELP
  267. Secure Database Object
  268. Do Loop provides incomplete data
  269. !!FAQ! for Date: 20031211 - New Users Look Here! [Last Updated November 30, 2003]
  270. Web based reporting software?
  271. Turn off the Office Assistant through Access VBA
  272. Removing Security?
  273. How do I do this?
  274. Out of memory error Access 97/XP Home with > 512 megs of RAM
  275. Assigning a value to a "Form" variable: Dim vFrm as Form
  276. Using import/export specs with ADP projects
  277. Word Automation
  278. I need help!
  279. Use the File Open Browse box
  280. Automating the import of an OLE object
  281. How to save variable values for future use?
  282. Access Virgin!! please help
  283. Access 2002: Selecting necessary data from several tables
  284. view result differs from the result in SQL Server
  285. Update Your Front End on the Network Easily
  286. Query speed anomaly
  287. Ms Access Database to web page
  288. Why does UPDATE query change data type?
  289. use of autonumber
  290. Auto fleet manager
  291. SQL statement problems
  292. Cleanup with Erase after Split?
  293. Jet or MSDE
  294. Query syntax, can it be better than Paradox?
  295. print preview problem
  296. App name ideas
  297. Count in Access
  298. Setting control properties
  299. Error Handler best practices
  300. Microsoft Oracle ODBC
  301. Finding Links that are not in Links Window
  302. problem with creating a duration field
  303. Q: Regarding back-ends, is it better to have one or several linked dbs?
  304. Sort Order in SubForm, Access 97
  305. Access 2000: Forms -- Getting a form/subform linked properly
  306. Shared network database
  307. Display weekday name of the date entered
  308. Multiple Record Sources
  309. Birthday Report
  310. Shared database
  311. help with display day(date)
  312. application developer required
  313. Automating report in a different MDB ( Question #2 )
  314. Ffield Size Problem
  315. Printing forms
  316. Subreports / Reports with Multiple Detail Sections
  317. error on inserting records to subform
  318. Send a pop up box behind a report
  319. DAO efficiency question
  320. Snapshots -vs- .pdfs
  321. Access 2000 Developer Tools
  322. Create report from Crosstab query w/dates as column headings
  323. Change cursor position of active control
  324. bank sort code issue
  325. Passing trough table
  326. error 3464 Data type mismatch error!! ??
  327. Changing the data type of a field in a table thru code
  328. Access Help
  329. How to add index with CreateIndex ?
  330. table name with spaces in RunSQL instruction
  331. Calculating Rows
  332. Query based on a Complete Field in a Table
  333. Unix Time
  334. error message!
  335. The images of boys' bare butts stayed with me as fantasy material for
  336. Data can't be saved to the field
  337. Simulating Combo Box AutoScroll on a subform list?
  338. GIVE IT UP DON MELLON
  339. Does Access know WebDAV?
  340. Error when executing SQL statment
  341. Problem with the mouse scroller
  342. Apply ValidationRule Before Update Method
  343. Text Box Formatting Based on Data
  344. sequential numbers
  345. !!FAQ! for Date: 20031209 - New Users Look Here! [Last Updated November 30, 2003]
  346. Compatibility Access 2000 and 97
  347. Compatibility Access 2000 and 97
  348. Access 2000 Distributing
  349. Access 2000 Redistributing
  350. Problem in programming waiting list for day care database
  351. REQ: Question about access. Please read inside. Thanks.
  352. A97 Graph question
  353. function calling
  354. Deleting in vba code
  355. a2k - real quick help needed on report printing out too many times
  356. system.mdw/default/secured mdw etc.
  357. Mystery bat file - A97
  358. How to get number of servers attached
  359. Navigating between forms, flickering
  360. update table
  361. Problem with Validate rule and Combo-box
  362. sql statement wildcard in fieldname
  363. Many 2 many forms. Shirfting data from 1 listbox to another ...
  364. How to move to specific record in Datasheet?
  365. Help - Unable to use ADO recordset as Form's Recordset
  366. OLE to Store Outlook EMail Objects in Access
  367. Access query fails if run through ODBC
  368. Change backgroud color for record listed in subform in continuous mode
  369. VBA - ACCESS 2000
  370. Copying permissions to a newly created mdb file
  371. How to not trigger dirty event when initializing control on form through VB?
  372. Programmatically identifying event properties
  373. Formatting data within a text box
  374. Substituting a variable in a form control
  375. Open Form from external database
  376. Adding current time in field with toggle button
  377. replication
  378. Calculationg & Avg time in a report
  379. Database to a:\
  380. Table entry from combo box
  381. try it in english maybe i am more lucky
  382. Empty lines in report
  383. why does that thing doesn't work??????,
  384. Emailing pages of report
  385. !!FAQ! for Date: 20031208 - New Users Look Here! [Last Updated November 30, 2003]
  386. Access : VBA
  387. a2k - graphics with transparency
  388. The beloved David Fenton in his own words
  389. Replication Manager
  390. Enforce rules with code or database design?
  391. Is it possible to switch content in a field upon choosing a certain field?
  392. record is not moving to next record on the dropdownlist
  393. How to convert Text dates to Date format?
  394. changing font color within column on form
  395. SQL statment for muliplie tables including the count function .
  396. Access wizards
  397. error when selecting data from the dropdown list
  398. Subreport Totals
  399. AddNew - Pocket PC
  400. Install that update from the Microsoft Corporation
  401. Default query parameter values
  402. AddNew from table A into table B - Pocket Access
  403. Finding records by date range?
  404. OpenRecordSet ...
  405. Importing only NEW RECORDs in MS-Access!
  406. byPass Shift Key in Access 2002
  407. Listbox does not allow me to detect a null value
  408. Report with a Control Filter?
  409. version?
  410. a2k - irritating RI message
  411. Conversion from Access 97 - 2000
  412. Conversion from Access 97 to 2000
  413. 2nd repost: Auto FE-Utility Access 2.0
  414. David Fenton is a valued member of this newsgroup
  415. Update txtbox with value from listbox
  416. Compact on Open
  417. !!FAQ! for Date: 20031207 - New Users Look Here! [Last Updated November 30, 2003]
  418. Hiding Group Footers & Headers
  419. Validation rule trouble - ensuring values held in one field are less than those held in another field
  420. Automatically Updating data end of month
  421. Import Excel graph to Access
  422. Remove Ctrl Keyboard Shortcuts
  423. Dcount Help
  424. Create Custom Toolbar AND Menu Bar for Same Form
  425. query to define current week?
  426. Form Closing and Adding Record
  427. Using an auto-number as a primary key
  428. Creating custom forms with a form...
  429. sql update/access query
  430. Capitalising names
  431. DLookup problem
  432. using relationships between tables
  433. WROX Beginning Access 2000 VBA
  434. Information System based in Access for a Small Bussiness
  435. Access Procedures
  436. !!FAQ! for Date: 20031206 - New Users Look Here! [Last Updated November 30, 2003]
  437. Only 1 user can login
  438. Accounts Payable Form 1099-Misc Report?
  439. Picture It! / Windows 2000
  440. How to get number of tables in a database
  441. How to specify alpha array(a-z)?
  442. Recordset without Connection
  443. Data Type Conversion - How to?
  444. Conversion from 2.0 to 2000: Admin has no Administer rights on forms
  445. need a db written ~ in exchange I offer . . .
  446. Pass through query for subreport?
  447. Form Closes and Adds Record
  448. Can't see the database window in Access
  449. hyperlink from access form to JPEG file
  450. Link from database form to .jpg file on server
  451. multiple cross tables in one report from survey questions
  452. Query influenced by combo box value
  453. Basic "For... To... Loop" question
  454. wrong RecordCount
  455. How to sum the textboxs in a report
  456. Totals In Crosstab Query
  457. Problems Starting Access
  458. perl against ms access
  459. !!FAQ! for Date: 20031205 - New Users Look Here! [Last Updated November 30, 2003]
  460. Need Help with Subforms
  461. Convert Access 97 to 2000
  462. Select all Items in list box
  463. subquery help
  464. Access / Picture-It!
  465. Access files into a webpage
  466. Event? to know when form is already open in background
  467. sequential number help
  468. Adding Data To Tables Via A Form
  469. prob with ordening in report...
  470. problem with msgbox and macro
  471. Add ALL to Combo - Unique Problem
  472. basic CreateObject syntax question
  473. Keep users from going to design view
  474. Deleting total content of a range in a linked table
  475. Queries and ODBC
  476. Change part of a form while keeping the rest of the form the same
  477. Make form maximized unable to minamize
  478. Use queries within IF...THEN
  479. how to use basic Common Dialog Box
  480. problem with macro with msgbox
  481. Problem to update record
  482. Is it possible to run Access on Linux?
  483. Buttons don't work if form is opened on startup
  484. Q: Null values and NZ() in crosstab query
  485. Set Form Recordset as ADO Recordset
  486. Accessing Outlook 97 personal address book
  487. Importing a file into Access...
  488. Best method of remote access?
  489. help with table design/relationship
  490. Text to Columns in Access
  491. insert into statement
  492. Copying data from field to field in form automatically ?
  493. Problems with combo box and data entry form
  494. Empty report grouping
  495. Procedure Assistance Requested - Dates
  496. Calling a function built in access in a query to Oracle through ODBC
  497. Strange corruption A2k
  498. Setup Error 915 - Object 5 using A97 on Win2K
  499. validating data for 2 field at the same time
  500. !!FAQ! for Date: 20031204 - New Users Look Here! [Last Updated November 30, 2003]
  501. How to query a website from a form
  502. Mailing Labels
  503. [vba] Getting a filename?
  504. Custom Menu Bar Missing
  505. Professor needs help - Using Access Table Guid to ascertain if student cheated
  506. A lost field
  507. bug in access query saves?
  508. Query influenced by combo box value
  509. The replace function (simple question)
  510. 2 Access XP/2002 Issues
  511. ODBC in Access
  512. Use of ldb File ??
  513. Access SQL with *
  514. Help with function in Access
  515. Sort Order in Access 2002
  516. How To Read Records From a Table to Populate in a List Box on a MS Access Form
  517. sql problem - how to write this in sql
  518. How to get Outlook Calendar data into Access?
  519. Simple Array question
  520. Error 3011 - Pasting From Excel 2002 To Access 2002
  521. Form_Error DataErr=3200 happens once in subform, twice in Form+Subform
  522. Jet40 and Oracle
  523. Count of records by group
  524. Access XP: Create total records from table
  525. Access 2002: How to select only first two numbers
  526. Form title bar Icon
  527. How to delete an actual table through vb (not all records)
  528. Current Month Query and Back up question
  529. Access 2000 Having Boxes BOTH Minimized and Maximized at the same time
  530. How do I create a table to log users that the application has booted out
  531. Print Preview toolbar
  532. How do I: Replace hyperlink with button in search result
  533. This group is dead
  534. Open Back end exclusively (but only sometimes)
  535. To the Homophobe
  536. CDMA Alert: Buggers criticize judge
  537. a2k - quick one for you string gurus
  538. Access 2000 on Office XP?
  539. Sequential Numbering in Query
  540. Help between to dates
  541. Populating form controls using the DLookup function
  542. Capturing Word Events from Access
  543. access97: date string
  544. grocery list in access
  545. Table Importing
  546. seeking ideas on how to determin a specific value with varied
  547. Ideas on how to determin a specific value with varied parameters
  548. Access Developers Needed
  549. Replace Function in Access 2000 Report Text Box Control Source Expression Quits Working in Windows 2000
  550. Help!! Insert into a table using VB