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

  1. AccHelp future development - discussion please
  2. SendObject & Thunderbird
  3. Accessing a DB on a file server through ASP on the Web Server
  4. Using DHTML exit control for ie5
  5. Can you fill a query parameter from a list ?
  6. Find a word or phrase in a report in Access
  7. adding strings to a table based on their entry into another table
  8. Hidden fields become visible when filter by form--how to prevent
  9. Referencing enumerated fields in sub-forms
  10. Input multiple line text file into one access record
  11. VBA SQL Select stmt multiple rows found but not getting RecordCount > 1
  12. SQL Query to Calc Gas Mileage
  13. Snapshot Viewer Control in Continuous Form
  14. Trying to copy a record within a table
  15. Internet explorer
  16. query criteria for >today?
  17. Custom Pivot forms
  18. How to lock tables with vba code?
  19. At random selection
  20. manipulating the values from expression builder and inserting in fields
  21. Automation Problem Office 97 In Windows 2000 SP4
  22. Oko IDDE and DB-manager now shareware
  23. Alternative To Treeview Control
  24. Trying to open Access 97 application with non-admin NT user
  25. MDI FORM in MSACCESS
  26. Transfertext Specification Name *.ini
  27. Keeping running total of part numbers entered into seperate fields
  28. Access Caching data?
  29. FORMS!reference too complex to run SQL query error
  30. Best way to import and update tables?
  31. Code to Search Tables Collection for a Specific String
  32. Query to Determine which record is not part of a Master Record Table
  33. from access to oracle
  34. Clear 2nd Combo on form (MS Access 2003)
  35. Reports preview ok, but print in top-left 1/16 of paper
  36. Access application with linked table to MSSQL server, data not updateable
  37. search VBA code from button-click on Form
  38. Opening MS Access from a webpage.
  39. deleting a column adox
  40. Deleting a field
  41. Excel Automation: I am confused
  42. Format field data
  43. Locate folders & files on network server through form....
  44. SQL syntax: How to insert srting with double quotes?
  45. late binding ?
  46. Sub-Subform Problem
  47. Duplicate tab delimited text file
  48. How to confine user SQL to imported tables?
  49. Easiest way to display properly formatted US 10 and 7 digit phone numbers?
  50. How can I display the group header every time there is a new page of detail records?
  51. Access security
  52. Export Query To XML
  53. XML
  54. Linked form question
  55. exporting memo field from access97 to excel97 truncates after 255 chars
  56. Report the numeric position of the 1st character in a string
  57. When is MS going to improve the Relationships module?
  58. Unable to move to different record in continuous form
  59. I don't want to use "Bankers Rounding"
  60. How to automatically fill in a web page form field?
  61. calendar activex control
  62. form formating question
  63. One table link breaks every time
  64. Auditorium setup & equipment 8/22/05
  65. missing references
  66. Audit Trail
  67. capturing web data thru access...
  68. DDL syntax for dropping relation
  69. Create Self-Join Query In Design View
  70. calendar
  71. list with file names
  72. extract table field value
  73. report grouping by week, month, year ..
  74. Print new record to label printer
  75. Execute dbFailonError & Cascade Delete
  76. #Error issue
  77. Import records from one database table to another
  78. Can A Single SQL Be Written
  79. Can't Compact DataBase
  80. distributing Access
  81. Linking 2 forms
  82. Access very slow
  83. Validation Macro
  84. How to convert an integer to a string
  85. Having a report going across the page - with a heading at the start of the row, then values going across...
  86. Displaying a temporary recordset
  87. Normalization Question
  88. CONVERT MONTHS NUMBERS TO ALPHA CHARACTERS
  89. Access 2003 code corruption problems
  90. Get MS Outlook Version Info
  91. Tab control Question
  92. combo box AtoZ ordering
  93. Access Project - Lookup in table
  94. Digital Signatures
  95. How to create relationships with DAO?
  96. Printing list of fields
  97. Making white sections of a picture (used in a report) transparent.
  98. Repeat A String In A Textbox
  99. I get an error back when I pass a SQL statement using Nz function to Access
  100. apiPlaySound
  101. requery question
  102. Why doesn't A97 cancel the click event?
  103. main form disappears after paste-append action using VBA
  104. Result of INSERT statement not showing up in following SELECT statement
  105. Text convert Code please
  106. Referring to SubForm/SubSubform controls
  107. Timing a form
  108. Criteria for Access 97
  109. BiskyMisky
  110. Is there a 'break' or 'continue' in 'Do Unitl'... 'Loop'?
  111. I posted this question 5 minutes ago. But it doesn't show up.
  112. Is there a way for Access to read CRC from other files?
  113. Synchronizing two forms
  114. Need help displaying photographs
  115. Access Has Broken - Help please
  116. Hide Permanetly the Windows Menu
  117. Working with report wzard
  118. Problems with Form fields using Linked Outlook Contacts Table
  119. Query where used diagram
  120. Should I use a crosstab for this?
  121. Referring to a form control in an update query
  122. How to convert form with vb code to html file?
  123. display one thing in field while allowing something else to be typed
  124. Does Number Contain Decimal Point?
  125. How to query by date?
  126. Search up and search down behave differently when using Find?
  127. A97 Font / Report question
  128. use of Me. gives RunTime error
  129. the first sunday of a month
  130. SENDING FAX
  131. Making same report appear twice on one page
  132. Problem with skv files
  133. Daily normal and overtime rates
  134. A97 How to force uppercase alpha chars in a textbox on a form?
  135. Link to Outlook Address Book
  136. ADO Recordset: Undefined Function 'NZ' in expression
  137. Get status bar text
  138. Can anyone help me turn this into code?
  139. Error Importing Text files. Error #3011
  140. run VBA code in something other than debug mode?
  141. updating bound & unbound controls on a form?
  142. Combo box display problem
  143. Can I set index properties on compound fields?
  144. Opening Access2003 and printing reports problem
  145. Can a query "look" at whats already in 2 table fields before appending a rec w/ redundant values in those two fields?
  146. File name on a form
  147. Out of memory in Access97?
  148. SQL Connections
  149. Trying to calculate a Sum
  150. A97 update all Command Button and Textbox Caption properties?
  151. String Concatenation
  152. Updates from external datasource
  153. Validation Rules
  154. Disabling form when a new form is opened
  155. import field names from fixed width text
  156. UNIQUE FOREIGN KEY Constraint?!?!
  157. autoincrement problem
  158. Split Database Poor Performance
  159. Function to count workdays
  160. Summarizing values for "duplicate" records
  161. Code To Prevent Printing A Subreport
  162. Report with totals only, no details
  163. user function in a query
  164. Authentication Failed Message????????
  165. Problem with linked tables
  166. Identifying Access Databases with tables linked from other Databases/Files
  167. Attach Files to Emails generated in Access VBA
  168. TransferSpreadsheet using a Query
  169. Combo Box to Filter Records in a Continuous Form
  170. Open Form in Ms-Access from a hyperlink by using dhtml control
  171. Table rounds all numbers to whole integers
  172. limit data to textbox
  173. copy data from a selected table to another fixed table
  174. Deleting a field
  175. Setting an autonumber programatically
  176. I can't get the "path" description to work for synchronizing 2 forms
  177. Exporting a Report to Excel
  178. Limiting Database - is this a good idea?
  179. Report Help: Reading Records From Same Field
  180. copy a record
  181. Crystal Reports active x control documentation
  182. adding a memo field programatically
  183. Subform loses recordset - shows #Name?
  184. Parameter Query
  185. API Viewer
  186. Excellent Resource!
  187. that's all we need
  188. printing problems with A97 on XP Pro and A03
  189. DoCmd.Applyfilter
  190. refering to a subform control
  191. Need VBA for file requester please
  192. Subform AfterUpdate goes to first parent record
  193. A97 table design?
  194. wininet vs. ftp script
  195. How to avoid ftping data all the time
  196. Mail Merge
  197. distributed database library
  198. Set Toolbar Combobox items when Toolbar is called?
  199. Access 2k3 Forgetting my code? :(
  200. Global variables are slowing down the query
  201. Connecting to SQL Server
  202. "numeric field overflow" only on linked tables...
  203. MS access coding standards.
  204. Thanks a lot experts!!
  205. Is there OpenArgs for Report?
  206. Formating numbers: I want '9' to be '009' and '19' to be '019'
  207. test
  208. CommandBars in Access 2002/2003
  209. What do the field type numbers returned in the debug window mean?
  210. Data Exporting
  211. Viewing Reports
  212. Limiting the number of records.
  213. Exporting Data
  214. printer settings
  215. Hard return in unbound textbox printing in report
  216. Need archtectural advice. DB server or File server.
  217. How to compact the database in VBA?
  218. Database w/ client access (online) and estimator
  219. How to compact the database in VBA?
  220. tricky problem :-) - self references & direction
  221. FTP with the WinInet dll.
  222. Database linking
  223. Losing Import Specifications - Access 2002
  224. database linking
  225. Database linking
  226. Simultaneous Insert
  227. query on different tables
  228. Plotting Data
  229. Access 2003 cannot print help please
  230. Retrieving Autonumber
  231. form speed up
  232. Combo Box Rowsource set at GotFocus
  233. Access/VBA Conditional Statement
  234. Access/VBA Conditional Statement
  235. update record event
  236. How to delete all the records in a table in VBA?
  237. Query Error Message
  238. Open Shortcut Menu from VBA?
  239. SQL select records NOT in both tables
  240. Auto quit database after inactive period?
  241. Filter on/off toggle
  242. How to emulate the action caused by 'Esc' button is VBA?
  243. Linked table manager
  244. Where is the daily post of our charter?
  245. Schema set up issue
  246. Performance with combined key in junction table
  247. Is there a way to change screen resolution in VBA
  248. Backing up an entire db
  249. Bisarre join problem.
  250. Adobe GoLive 5.0
  251. Insert string (insert without duplicates???)
  252. Insert string (insert without duplicates???)
  253. Temporary tables in A2K/ADO
  254. Temporary tables in A2K/ADO
  255. DataBase linking
  256. DataBase linking
  257. Question about creating replica
  258. Question about creating replica
  259. ADH 2002 FormResize
  260. ADH 2002 FormResize
  261. Repost: Connecting a table to itself?
  262. Repost: Connecting a table to itself?
  263. Query: Count (amount of (xDates later than GivenDate))
  264. Query: Count (amount of (xDates later than GivenDate))
  265. Access Bug with SQL Server identity columns
  266. Access Bug with SQL Server identity columns
  267. How to add a blank entry in a Query based combobox?
  268. How to add a blank entry in a Query based combobox?
  269. How to use the criteria on a calculated field?
  270. How to use the criteria on a calculated field?
  271. Advice for an Online Calendar
  272. Advice for an Online Calendar
  273. OLE Linking to Word?
  274. OLE Linking to Word?
  275. Highlighting Records
  276. Highlighting Records
  277. References, Sub forms, Picture boxes, Bald spots
  278. References, Sub forms, Picture boxes, Bald spots
  279. Go Back to the previous FORM
  280. Go Back to the previous FORM
  281. Select/Update Query
  282. Select/Update Query
  283. Showing all records in a table in the details section of a form
  284. Showing all records in a table in the details section of a form
  285. Troubles with Threads and Suns jdbc-odbc Bridge Driver?
  286. Troubles with Threads and Suns jdbc-odbc Bridge Driver?
  287. Embedded Excel Chart
  288. Embedded Excel Chart
  289. Access 2000 Menu customization
  290. Access 2000 Menu customization
  291. Access Loses my Forms and Reports
  292. Access Loses my Forms and Reports
  293. Subdatasheets. subforms and record selection
  294. Subdatasheets. subforms and record selection
  295. Subdatasheets. subforms and record selection
  296. Subdatasheets. subforms and record selection
  297. Access won't commit (to SQL Server linked table)
  298. Access won't commit (to SQL Server linked table)
  299. Invalid Dates
  300. Invalid Dates
  301. Change Datasource of embedded Excel Unbound Object Frame
  302. Change Datasource of embedded Excel Unbound Object Frame
  303. Need Ideas For Layout Of Form
  304. Need Ideas For Layout Of Form
  305. scrolling control source...any way to fix or disable this ?????
  306. scrolling control source...any way to fix or disable this ?????
  307. Forcing a Form View
  308. Forcing a Form View
  309. If Statement
  310. If Statement
  311. A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
  312. A97 removing value from textbox after CancelEvent (DMVFileNo_BeforeUpdate frmENF264ProcessingForm)
  313. Access2003 Crashes when Filtering
  314. Access2003 Crashes when Filtering
  315. How to find out if a form exists?
  316. How to find out if a form exists?
  317. Error Handling
  318. Error Handling
  319. Capatalise the first letter of every word
  320. Capatalise the first letter of every word
  321. TabControl in .net
  322. TabControl in .net
  323. Recursive File Search VBA vs VB
  324. Recursive File Search VBA vs VB
  325. Database size increase
  326. Database size increase
  327. Supress Default Primary Key Message
  328. Supress Default Primary Key Message
  329. Question on SELECT TOP 3?
  330. Question on SELECT TOP 3?
  331. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  332. Error: Field 'F1' doesn't exist in destination table. I've created import Specs but still get same error...
  333. Print report by filter
  334. Print report by filter
  335. Stop current record from moving to another record
  336. Stop current record from moving to another record
  337. Numbering Labels
  338. Include record related bitmap in report query
  339. Include record related bitmap in report query
  340. Numbering Labels
  341. Module Help!
  342. Module Help!
  343. Lining up columns on subreport with main report
  344. Lining up columns on subreport with main report
  345. Unexplained behavior in Windows 2000 Adv. Server environment
  346. Unexplained behavior in Windows 2000 Adv. Server environment
  347. Self-Referencing tables
  348. Self-Referencing tables
  349. Change the autonumber of a table
  350. Change the autonumber of a table
  351. AccessXP Startup switch /ro
  352. AccessXP Startup switch /ro
  353. MS Access Shell use to call external application with audio
  354. MS Access Shell use to call external application with audio
  355. "Overflow"
  356. "Overflow"
  357. /cmd problem
  358. /cmd problem
  359. Access 97 bogus duplicate records
  360. Access 97 bogus duplicate records
  361. Publish with MS Word problem
  362. Publish with MS Word problem
  363. Jet SP8 installed but still requested
  364. Upsizing MDB to SQL server
  365. Unwanted American date format problem
  366. NETWORK INVENTORY
  367. Refresh/Reconnect to SQL Server
  368. Using UNION of 2 or more saved queries
  369. Run as is it possible ??
  370. Use of "Max" in query grid
  371. IMPORTING QUERIES FROM ANOTHER APP
  372. How to use extracted table with base table?
  373. focus from main form to sub form
  374. turn off warning
  375. form is not allowing me add data
  376. Space at the end of the field
  377. xls MACRO help
  378. Listing all users in a combo box.
  379. Query problem
  380. missing operator in query expression
  381. Customised Dropdown ComboBox
  382. Summing text field containing blanks
  383. Etiquette about reposting a question
  384. newb seeking help with form
  385. Strange corruption problem
  386. looping through toolbars
  387. Simple Update Query
  388. Access 2003 security
  389. Consolidate data in head office
  390. Differences between Access 97 and Access 2000/2003
  391. Setting recordsource for subform
  392. Easter function explanation Part II (long)
  393. Help with Registry Patch
  394. HTML Help
  395. Please Help - Combo Box Question...
  396. "Connection Failure"
  397. MSDE Upgrade question
  398. Add xls Macros to existing Module.
  399. Access Books
  400. basing a form on a RWOP query
  401. Linked Table Manager Macro
  402. Access books
  403. Custom toolbar problem
  404. Do I understand form optimization correctly?
  405. Read only version of a form.
  406. Report Group Footer not displaying the total that I want
  407. Como Box
  408. Application crashes after a call to DaoObject->CommitTrans
  409. generating a seriel of serial no
  410. hide pagefooter
  411. Locally using Access and IIS
  412. Help needed with frustrating menu bar problem.
  413. controling which report to print in VB
  414. Left Join behaving like Inner Join - Access 97
  415. How to use variable to reference rst!Item?
  416. Rolling Average Calculation Problem
  417. SQL error "Arguments are of the wrong type ..."
  418. Copying records
  419. Report Group Section Footer displaying Totals
  420. Upsizing questions
  421. Macros and queries
  422. Getting Totals From Two Different Tables In A Query
  423. Auto Number
  424. Creating new Fields in code
  425. Sequencing Problem using an MS Access Query
  426. Looking for 3rd Party Developers
  427. A97 graphing (x,y) coord's - how to do it?
  428. A97 tables needed containing geodata for USA state boundaries 'n city loc'ns
  429. Rounding Frustration
  430. Focus on tab control instead of first field
  431. archive macro
  432. can Access 2002 or 03 import multiple worksheets?
  433. Tracking Changes in Access
  434. Dynamically Renaming Fields?
  435. Import XML with Attributes
  436. Reading Text Files - Dev
  437. Advice On Random Sample
  438. EVERY "on open" gives "expected end of statement" error-->SOLUTION!
  439. OnDirty only working once
  440. Access database suddenly increased in size
  441. Merging several lists into one, with different field names
  442. how to pad zeros to the left of a field in a table and KEEP them there?
  443. how i connect my comp.databases.ms-access with jsp in tomcat3.3
  444. When will a query run?
  445. Problem with ActiveX
  446. currency format in a textbox
  447. currency format in a textbox
  448. No Current Record
  449. Send Object on WinXP
  450. record-locking?
  451. Using NOW() to display long date in a report
  452. report "too long"
  453. How to make all access to linked table read-only
  454. Variable Pointers
  455. Quick help with extracting a value
  456. Security in Access 2003
  457. How to interrogate through OLEDB for space to be freed by compaction?
  458. Right Clicking a form gives users wrong power
  459. no suitable driver found exception when getting connection with access
  460. Locking controls locks another form up...why?
  461. Access backup software
  462. creating pivot tables in Excel from Access
  463. Problem with Embeded Queries
  464. Workgroup file (system.mdw) problem
  465. Word truncates Memo field when using Automation from Access
  466. Create report in MS-ACCESS
  467. How many subforms can I have in Access 97?
  468. Any resolution for Err 3734 "Database has been placed..."
  469. DCount, by customer
  470. Updating Multiple Access Tables with Single Excel File
  471. How to 'dump' all standard and class module code lines into an Access table
  472. Multiple product classes table design
  473. Time and Attendance Recording
  474. How to set up read-only accessibility to an existing .mdb
  475. AllowByPassKey error
  476. Access Wizards don't see table
  477. Call Function by string
  478. fGetControl (strMyControl) as Control
  479. Multi-column report needs word Continued
  480. Permission problems with Access and SQL
  481. Row handle referred to a deleted row -- error message
  482. Help with totals in access
  483. Tools for record locking
  484. Top 10?
  485. Access 2003 runtime confusions
  486. Form field visibility -
  487. Passing a parameter as a form control (or not!)
  488. Looping through every oject for Application.SaveAsText
  489. SQL asp select syntax help
  490. Application.Name
  491. Unselecting items in a Listbox (HOW?)
  492. I want to examine each procedure in my class modules and standard modules (A97)
  493. Creating Groups and Users
  494. Multi-user, Multi-computer MS-Access.
  495. Distinct problem
  496. Distinct problem
  497. Help. How to enable the confirmation of save on changing table/query?
  498. Using Listboxes to enable multi-select
  499. Combine 2 memo fields and insert a blank line
  500. Automate compact and repair/backup database
  501. Query type for asp page?
  502. Primary Key question
  503. Menu Bar Startup Options via VBA
  504. Bringing up the Expression Builder
  505. AIUTO: Collegamento tabelle MySql ad Access
  506. want to about ms access
  507. Record Locking in Access 2000 DB
  508. Report view
  509. Create dynamic hyperlink in Access 2000
  510. Fried brain by 10am - wierd "fake" hang problem
  511. Multiple criteria on filter
  512. memo field auto-expanding?
  513. Get runtime error "94" with 1st character capitalization script
  514. lock records on edit detection
  515. Awful performance and millions of packets transferred
  516. super quote
  517. ADO parameters queries and stored procedures - and Connections
  518. supporting text fields >255 in Access 2003
  519. RecordsAffected reporting the wrong value
  520. Need advice on table structure and on creating subforms
  521. Mail Merge Problem
  522. Problem with limit on maximum number of textboxes on a form or report in MS-Access
  523. Access, ASP, DATE problems!
  524. Persistent recordset error 91
  525. toolbar diappeared
  526. subform name on control tab weirdness
  527. Running a Database on a USB Flash Drive
  528. curious about command buttons
  529. Search button / form
  530. stumped - 'field too small to accept....' (err number 3163) error only with MDE on production server
  531. Query to XLS
  532. How to Compact a "Table"
  533. Snapshot Viewer on Macs?
  534. multiselect problem
  535. Need help on user input decision for Form
  536. Form Not Painted / Visible !
  537. Larry Linson
  538. Calendar
  539. How to calculate the sum of a colon
  540. Accounting in Access for small businesses
  541. DISTINCT problem in query?
  542. Implementing row-level security (SQL/AD)
  543. mouse scrolling problem
  544. I could use some help with a query using mulitplication
  545. one to many & many to many relationship
  546. Object variable question
  547. Checking a condition to be true over 9 consecutive months
  548. Help....Frustrated with Forms
  549. Navigating main form with subform
  550. Why code unhiding database window in A97 unhides hidden form too?