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. Running database on differing OS machines
  2. distributing access database files
  3. ? Affecter une priorité à un contrôle d'access
  4. fastest way to call a function
  5. ?? TRANSFERDATABASE COMMAND
  6. dsum issue
  7. Print report/subreports based on each date in range
  8. What to delete new record started on Continuous Form
  9. Reformatting data into logical records
  10. 20 million records: Too many for an MS Access app?
  11. DateDiff Error
  12. Rolling Rates of Return: Data Structure?
  13. setstartupproperties doesn't work for xp mdb
  14. AccessCode must wait until excel closes. HOW?
  15. Need help formatting page footer please
  16. Applyfilter or form bound to query??
  17. Subform H*LL
  18. listing data in columns dependent on letter of alphabet
  19. listing data in columns dependent on letter of alphabet
  20. MS Excel IF Statement w/pictures??
  21. calculating time II
  22. Calculated field in subform
  23. Show database window from VBA
  24. Array element appears to lose value (Access 2002, XP SP2)
  25. MS Access Report
  26. Which Courses students have not taken query
  27. VBA control of field value match with excel value in cell
  28. On Format headache
  29. genealogy database
  30. Microsoft VBScript runtime error '800a01a8'
  31. VBCode Help for Beginner
  32. Can I display all the records of a DAO.Recordset in continuous forms textboxes?
  33. Putting Columns on a report
  34. Bank reconciliation
  35. How do I do a print preview using Access Automation in VB? Print works fine.
  36. Deploying Access 2003 runtime
  37. Expression Builder
  38. Important Access Client/Server tip
  39. Database size - problem
  40. Will Access 2002 Save As Access 97 ??
  41. Option Group Button Help
  42. Help with Form position after report preview
  43. multilevel hierarchy query
  44. Access Data Projects Uniqueidentifier problem
  45. Best way to make Access 2.0 code wait 10 seconds before processing the next line???
  46. Moving from one form to another and then back
  47. Report Total Line: Summing just two rows?
  48. Emailing from a form
  49. vba sql query passing to report
  50. Open file (from url)
  51. VBA code help Export Excel data to Access table
  52. Error 3048 Cant Open any more databases
  53. Error 3048: Can't Open any more databases
  54. Another Dlookup problem
  55. Database distant access
  56. Combo box query report
  57. Making Access work faster
  58. database tables and relationships
  59. Version issues
  60. Add data from a form into a table!
  61. How to save a record
  62. Q on weird subform skip behaviour
  63. How to ensure that on a continous form of 12 row only 1 tick box is checked??
  64. How to ensure that on a continous form of 12 row only 1 tick box is checked??
  65. Compact the database problem
  66. Changing Window States of Reports/Forms
  67. Difficult Graph Needed
  68. Integrating Crystal Reports into Access97 form
  69. Exam type questions
  70. Help With Query
  71. Record limitation when using Data Access Pages
  72. Finding the last record -10
  73. Record limitation when using Data Access Pages
  74. RowSource Issue
  75. Access: How to disable importing tables from my database to other
  76. Missing Pair Fields WHAT?
  77. Open a corrupt Access 97 db
  78. How to convert Date to Week #
  79. Help with Relationships - Query and Table relationship
  80. How to use a popup form to filter data on a main form?
  81. Calling C#.net .dll from VBA
  82. displaying a command button in the detail part of a form.
  83. Special Labels
  84. Help with Database Object
  85. Database Report field
  86. Database Report field
  87. Ascending number in query
  88. a2k - how to code a simple version check over the net
  89. Parameter in query to dropdown list
  90. Inserting a new Record in sub-table and ensuring valid relationship values
  91. Help with calculated control on form
  92. capturing the printing properties of a report of form when sent to a printer
  93. Downloading of data from access
  94. Command Buttons
  95. Reports
  96. Microsoft Access and Cash Drawer
  97. TreeView documentation
  98. Sub Form - Linked Child Field - Linked Master Field
  99. Multiple users changing the same record
  100. Design question
  101. How to round a number by 50s or 100s.
  102. Why do I always get -1 when I do Recordset.RecordCount
  103. Key Stroke
  104. Access Developers edition?
  105. Asp and access database--Long
  106. I Have a Query
  107. Change Text
  108. How to avoide the "Alert Messages" when using Queries
  109. ms access
  110. Excel error at web server
  111. Excel process doesn't shut down
  112. Assign value to Excel.Range
  113. DSum Help
  114. Public (Global) variables
  115. Late Binding??
  116. query design help for book index
  117. Base DS form on QueryDef?
  118. Output access to Word merge
  119. Where can I find the syntex of "formatnumber"
  120. Tab Caption Goes Away
  121. Exporting a Report As a Word Document
  122. Simple function sometimes works ... sometimes doesn't ?
  123. Code "Auto-Letters" ?
  124. What event occurs just before a record is written to table?
  125. Exporting text files without .txt extension
  126. date issue in .adp file
  127. OFF TOPIC Frustrated Rant
  128. Adding new users requires exclusive access to mdw!!
  129. Complicated Question
  130. Previous Business Day
  131. the Find Command Button
  132. Apply Filter in subform
  133. Listbox Updating
  134. Code to fix corrupt table
  135. Tables Duplicating Themselves with an underline and then a number
  136. Create IIf Statement for Query
  137. SendObject in Access2K works sporadically
  138. Change Textbox Width
  139. count and group by with OR
  140. Returning Focus to Main Form
  141. Automated Screen Print - Possible?
  142. Union Query Truncates Memo Fields
  143. Amount of time spent on a record
  144. How to make the Linked Tables in Access to Share only ONE connection?
  145. most recent, min/max query
  146. Remove multiple Chr(13) & Chr(10)
  147. Access 2002 runtime error for Windows XP
  148. I cannot figure out this query - I thought it would be simple but...
  149. How to use different data sources for different sections of a report?
  150. Using Excel data in query
  151. Update Query
  152. OLE Applications for JPG Files
  153. Using code to copy forms/macros etc
  154. Saving a set of reports in Word automatically
  155. Recommended Stretagy for Bi-Direction SQL DB Synchronization
  156. Using jpeg files as OLE objects Q2
  157. [ODBC] form linked to odbc tables with "high" number of record
  158. Problems Converting 97 Query into 2003 format
  159. Using JPG Files as OLE Objects
  160. Textbox, web browser control, and Unicode (got cutoff)
  161. splitted database crashes when adding records to linked table
  162. updating access 2000 mdb from asp.net Microsoft.Jet.OLEDB.4.0 ???
  163. Excel protect sheet macro problem
  164. Access and a VPN
  165. Access & a VPN
  166. Access & a VPN
  167. read only access database
  168. Reports In Visual Basic and Access
  169. Access DB Security
  170. Securing a single table - what are the options?
  171. My text field Criteria : "N/A" - How to resolve "/"?
  172. Best way to let users run SQL?
  173. Access unexectedly shutting down
  174. Web browser control, Unicode
  175. Call Function
  176. Subform Contro; Border
  177. Exporting Report To MS Word
  178. Buttons and Listboxes
  179. Access Books
  180. How to convert Date to String
  181. How to convert Date to String
  182. How to convert Date to String
  183. Search and Update - Difficult update query
  184. Hourglass status
  185. caselle di testo e formato ora
  186. me.cb.Type?
  187. Copy file from within Access 2003 project
  188. Two Lookup Combo Boxes on Same Form
  189. Microsoft Office Library Reference
  190. Multiple Field Search
  191. can't send Email from Access
  192. Question didnt seem to bump
  193. Linking table to multiple tables
  194. reports
  195. API Gurus - Alpha transparent popup a la Outlook 2002
  196. Commandbars Controls Collection
  197. Print Form to Report
  198. query based on lookup value
  199. Report performance question
  200. Multi-level GROUP BY Error 3612
  201. Problems loading a listbox rowsource from code
  202. Text box question
  203. Differences - Syntax & Form operations
  204. Combos with Tens of Thousands of Records
  205. Back -end Front-end
  206. Changing Table Names
  207. Next "Available" record ?
  208. Slow Access 2003 in Win XP with network connection
  209. Pad lines on a report
  210. Access/Jet Statistics
  211. Questionnaire in MS Access
  212. Text Box Issues
  213. Updating Records on Form through Linked Tables
  214. Go Back And Forth Between Functions
  215. MS Access and SQL bigInt
  216. Change in appearence of google group page
  217. How to do the Declare for a Delphi DLL
  218. how to change the owner of a table
  219. Security Manager Add-in Error
  220. Settle a disagreement with my boss re SELECT DISTINCT
  221. Creating a Backup Database
  222. Setting focus to textbox after clicking on multipage tab
  223. Comb Boxes within a Sub-form
  224. How to copy groups and users from old secury file .mdw into a new one?
  225. Tuning of group reports
  226. Database back end - SQL Server or Access
  227. Autoexec question
  228. Optimization technique
  229. Using same table for Lookup
  230. Won't sendObject from access 2000
  231. Highest Value For Each Person In the Database
  232. calculation visibility
  233. Where clause in SQL statement problem
  234. Can't open linked DB files
  235. Type conversion problems with Access Import Wizard
  236. Corruption Manifests In Access 2000 But Not In Access 2003
  237. OLE Image Problem in A2002
  238. Return to code section and loop before giving up on an error.
  239. Return to code section and loop before giving up on an error.
  240. Query of two tables
  241. show day (date) quickie
  242. Reconnect to DB back end - password
  243. seperate page/document for each record?
  244. Code problem with rowsource and SQL statement
  245. SETTING DIFFERENT RECORDSOURCES FOR ONE REPORT
  246. Please help me get started (Access on the Web)
  247. Simple question (I hope!!) on .FindFirst
  248. dynamic popup screen for multiple comments fields
  249. Help for Xbase to Access -Allen Browne may be
  250. Report including only days with value > 0
  251. scurity + form
  252. Need Loop Help - VBA novice
  253. Combo Box Problem
  254. Is it possible to join two queries together
  255. Retrieve Information about Access Version
  256. password enbaling form
  257. Problema con un report
  258. Filtering out unwanted characters from a mag stripe swipe.
  259. jet 4.0 error message
  260. Can't open my database - linked tables
  261. Change me.sourceobject
  262. A very specific problem involving duplicates
  263. Notification
  264. Query question
  265. Type mismatch error, SQL and Recordset
  266. Function used in SQL Select query
  267. Processor Number
  268. How to remove the CR character (â–¡)
  269. Designing Access2003 unbound form in an asp.net-way?
  270. forms: simple and complex question
  271. Suggestions needed.
  272. multi-page, multi-filter access report problem
  273. Database normalization question
  274. Database Replication A97 vs A2003
  275. Access DB Security
  276. Outlook Emails in Access
  277. Date formatting so "01/22/2005" becomes "January, 2005"
  278. Changing, "FindFirst" to using the, "Seek" Method?
  279. print only some reports?!"
  280. Application Search and Replace Tools
  281. Referencing data in a field within another field
  282. forms --> access
  283. Need help with merging spreadsheet together
  284. Import Specs: Still buried in Access 2003?
  285. Combine (Merge) Data from Two Access Tables
  286. Linking to a backend using code?
  287. Adding index marks for Word
  288. Having trouble setting up transactions
  289. How do I set a form to automaticly start at new record and not overwrite first record?
  290. Update sub-form on tab from field
  291. Qty Problem
  292. Searching Using Combo Boxes
  293. Query help : Urgent please
  294. send Outlook email from different name?
  295. Controls over image
  296. Q about creating new form
  297. blat command line does not work in Shell method
  298. From the previous question - Search the records by groups based on identical field value
  299. Help with Acces Runtime 2002
  300. Locked Record when connecting to SQL Database
  301. if then else - help please
  302. Changing and storing the value in a text box without adding row to table
  303. open & close time of database?
  304. Multiple Concurrent 'References' to MS Excel?
  305. Two Tables
  306. Combo Box question
  307. Appending records in another database
  308. recordsets?
  309. Asp.net caching vs Access Caching.
  310. ADO and DAO together in same application?
  311. Create Autonumber & query problem
  312. Indexing a phone book
  313. Custom page size in report
  314. Extended one to many relationship
  315. Book recommendation for access queries?
  316. SQL Server 2005 Express Edition Overview
  317. OLE problem with A2002
  318. List Box Options Not Appearing
  319. Blanl Lines
  320. Displaying both the master and its details as a grid
  321. A'2003; SourceObject = Query.MyQuery (BUG!) (?)
  322. WEB Integration of Access Database/System
  323. Invoking Filter by Form from Code
  324. IM/EXport specifications automatically creating
  325. Crashing Subform
  326. Crashing Form (& Access)
  327. problem with crosstabs + reports
  328. Combo box bound column value
  329. Re-use values of err.number and err.description after a msgbox in the error handler
  330. Combo box question
  331. Database security
  332. How to either programatically reset AutoNumber or simulate autonumber in a temporary table
  333. Calling a class' private method from a form
  334. Create a form to run a Union All Querry for specific citeria.
  335. Upgrade path to MSSQL2000
  336. QUERY 'ONCLOSE' EVENT?
  337. Database Design Questions
  338. Deleting Records Before Packaging Causing Slow Reports
  339. Run Regedit from Access form
  340. Dual "Parent-Child" Combo Boxes
  341. On cancel=true, extra Access-warning?
  342. RTF2 ActiveX plugin from Stephen Lebans
  343. DBase Index Files
  344. Trying to understand primary keys, relationships and such.
  345. What would cause"Compile error in hidden module"
  346. Required Fields in a Form
  347. Parameter Prompt for field, which was deleted from table
  348. Linking tables to SQL Server 2000 causing strange results
  349. CALCULATING TIME
  350. How to check if table exists
  351. data type mismatch in criteria expression
  352. Unable to set focus on a text box
  353. using flash in ms access 97
  354. Initial Value for Combo Box Text field
  355. List Box on Datasheet Form
  356. run beforeupdate from another sub
  357. Getting rid of Access 2000 LDB files
  358. Compact an Access database in VB code
  359. using a remote MySQL Database in MS Access
  360. DDE - Excel XP
  361. Access vs Visual Studio dot.net
  362. Combining data from several fields in a Union Query
  363. Why function does not work?
  364. Dev Ashish function not recognized. Need advice quick.
  365. Comparing input date to current date
  366. Records across LAN
  367. ddl for union queries
  368. Memory usage for reports
  369. Multiple Sort in a Continuous Form - Similiar to AutoFilter
  370. How to bypass 'No current record' error
  371. Detect idle time, shut database down
  372. Upgrade issues from 97 to 2003 - references? DATE LEFT and FORMAT give compile errors
  373. Stop Autosave for Forms with Table Recordsource
  374. Display a numerical query result as a letter
  375. Strange behavior in a continuous forms subform
  376. Passing an argument to a subroutine
  377. subform with unbound forms
  378. Linux backup - mdbtools detect corruption?
  379. can't append or edit data in form & query
  380. One million records a day
  381. Using access data to fill in pdf forms
  382. Can i open remote (http) files for input?
  383. Connection String suddenly Stops working
  384. Deduplication and Data Cleansing Software
  385. Surpress dialogbox?
  386. Check if printer is active
  387. Thanks!
  388. Documentation outsourcing a must to reduce your expenses
  389. outlook data
  390. create autonumber
  391. Form check box & report data
  392. converting data
  393. Need Help opening a form from a form, using Openargs
  394. Hidding dbWindow form user in access app
  395. Set Report Zoom to 90%
  396. Proxy problem with InetTransferLib
  397. Pivot Charts SUCK - need help
  398. Auto Number from a Make table query
  399. Performance of MSDE over VPN
  400. Problem Opening Report From Form
  401. Can DMIN return multiple values
  402. PopulateCombo Box Row Source with list of files
  403. Linked table password storing
  404. Computer bloat question
  405. conditionally enabling a form control
  406. replicate Frontend MDB to Backend Database
  407. Access
  408. ACC97: Linking tables using two fields in each table
  409. Question about Access 2002
  410. Database Issue
  411. Updateable Query
  412. Using On Mouse Over OR Mouse Move to display a description
  413. connection string with database password...
  414. Backup of an Access Database while Running.
  415. Use multiple queries to display information on a form
  416. Access Database on Web Servers
  417. Access and Excel Pivot Table
  418. Anyone have experience using CDOSYS?
  419. Any Idea is welcome
  420. Reports - position of a control
  421. Resize(): Reliable way to determine bottom padding?
  422. Combo Boxes
  423. Tabcontrol - add records
  424. auto generate claim no
  425. create autonumber
  426. While printer.printing
  427. More challenges with Returning orders
  428. I fall down at my knees
  429. Yes, indeed
  430. DLL In Different Locations
  431. before update - validating potential new data?
  432. import+3query+recursion
  433. need office xp 2002
  434. Sorting Where Sort Field Is Null
  435. Appending data...
  436. Show Total In Subreport On Main Report
  437. Properly cased patronymic last names
  438. Format to say "Required"
  439. report totals
  440. file dialog - select a file
  441. Open Form with a filter value from another form
  442. Module Compare Add-In?
  443. Can't manage to get text to be Vertical
  444. Row Total
  445. Populate List or Combo Box with file names in a folder
  446. can't update/change anything in db application
  447. Last Record
  448. VBA question
  449. On Open Event Procedure
  450. Numeric overflow in [tinyint] field
  451. Using hours in a date range parameter
  452. Expressing hours in a query parameter
  453. On Open Event Procedure
  454. Telling programatically whether an Office product is installed
  455. Tab command in access procedure
  456. This script causes NP Pool to exhaust itself - can't see why - very simple
  457. MS Access 2000 + Table + Report
  458. Query Results formatting.
  459. Testing if an entered value exists
  460. How to manage Access security
  461. Help with access code to close a window
  462. ADO query question - which is faster?
  463. SendObject Warning in Outlook 2003
  464. Get stored procedure output value back in VBA
  465. Trouble with Access 2000 and finding a table's source
  466. Problem retrieving printer information for this object
  467. Project time estimation
  468. Month by month analysys
  469. Append Query Random Failure
  470. Direction on a project early on
  471. Using Mag stripe reader to access records
  472. Sending selected items from listbox to report
  473. Format function in SQL
  474. Help Converting from Treeview 5 to Treeview 6
  475. Output report to rtf format
  476. How to open multiple data bases from one GUI
  477. autonumber->number of key
  478. Fw: Compare textbox value to record in table
  479. Date Difference for different records with same GroupId
  480. Validation rule for number
  481. Need help with Justification in Access
  482. Link Table Manager path problems
  483. Access Scalability - records vs. filesize
  484. Combine two tabels to one. (Regular time and Overtime)
  485. MS Access 2003 Runtime Environment
  486. asp.net datalist display single row
  487. Query results in needless/extra zeros
  488. Huge Database Advice
  489. Huge Database Advice
  490. Query timeout problems
  491. Can not open reports in MS Acess 2003
  492. VBA/ MS Access. Code formating/alignment
  493. Using a variable to store an jpg
  494. Automation - Excel & Access
  495. Creating and using Stored Procedures and Views in Jet
  496. Make table from code?
  497. Setting the size of column widths of a combo box through Code and Searching Combo Box
  498. Doing the unthinkable with my tables
  499. Subreport title
  500. Thanks!
  501. Help with error in trying to email from Access...
  502. Access97 crashes on Windows 2000 or Win XP
  503. Compare textbox value to record in table
  504. EDIT COMMAND
  505. Pls help
  506. Saving Access File
  507. Assistance with Digits To Text Function
  508. A Form Letter with Access
  509. Aligning controls in page header and detail line
  510. A2003 Slow in Shuting Down BE ldb
  511. Password that changes according to month
  512. Combo box entries
  513. Unbound Textbox not printing in Report
  514. Get file attributes with code
  515. using lebans rtf2
  516. Access Paper
  517. Access Docu?
  518. How to copy existing table structure to create empty temp table?
  519. ref:disabled toolbars etc
  520. New; going from flat to relational
  521. Visual Studio Tools for Office ?
  522. Determining whether a Database is corrupt
  523. Dim X as long ==> What is the value of X???
  524. Not able to add record
  525. running a query to find missing names between 2 tables
  526. Sending selected items from listbox to report
  527. ListBox question
  528. Pls help
  529. How to make composite unique index?
  530. CHanging the Extension from mdb to whatever
  531. Coding a switchboard so new forms don't pop open in new windows.
  532. Cascaded update/delete box unavaible.
  533. Access Report / Sub report with parameters
  534. Blank pages in a report
  535. Text box in access report not displaying currency format
  536. Securing A Folder On A Server
  537. Unique OrderId number Help
  538. MS Access on a LAN
  539. Can you stuff data into a word doc w/o word?
  540. Prevent Dups in the code
  541. Doubleclick in listbox
  542. Selecting a row in Subform
  543. UPdate Outlook Calender
  544. Call for help to Scouting members
  545. Linked Files
  546. How can error messages be displayed when using Command Buttons - Access 97 ?
  547. A-2003 - FK combo-box losing formatting when selected in main table
  548. Windows Colour Scheme
  549. How to pass variable value...
  550. Refresh a lookup box?