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 122

  1. Using jpeg files as OLE objects Q2
  2. [ODBC] form linked to odbc tables with "high" number of record
  3. Problems Converting 97 Query into 2003 format
  4. Using JPG Files as OLE Objects
  5. Textbox, web browser control, and Unicode (got cutoff)
  6. splitted database crashes when adding records to linked table
  7. updating access 2000 mdb from asp.net Microsoft.Jet.OLEDB.4.0 ???
  8. Excel protect sheet macro problem
  9. Access and a VPN
  10. Access & a VPN
  11. Access & a VPN
  12. read only access database
  13. Reports In Visual Basic and Access
  14. Access DB Security
  15. Securing a single table - what are the options?
  16. My text field Criteria : "N/A" - How to resolve "/"?
  17. Best way to let users run SQL?
  18. Access unexectedly shutting down
  19. Web browser control, Unicode
  20. Call Function
  21. Subform Contro; Border
  22. Exporting Report To MS Word
  23. Buttons and Listboxes
  24. Access Books
  25. How to convert Date to String
  26. How to convert Date to String
  27. How to convert Date to String
  28. Search and Update - Difficult update query
  29. Hourglass status
  30. caselle di testo e formato ora
  31. me.cb.Type?
  32. Copy file from within Access 2003 project
  33. Two Lookup Combo Boxes on Same Form
  34. Microsoft Office Library Reference
  35. Multiple Field Search
  36. can't send Email from Access
  37. Question didnt seem to bump
  38. Linking table to multiple tables
  39. reports
  40. API Gurus - Alpha transparent popup a la Outlook 2002
  41. Commandbars Controls Collection
  42. Print Form to Report
  43. query based on lookup value
  44. Report performance question
  45. Multi-level GROUP BY Error 3612
  46. Problems loading a listbox rowsource from code
  47. Text box question
  48. Differences - Syntax & Form operations
  49. Combos with Tens of Thousands of Records
  50. Back -end Front-end
  51. Changing Table Names
  52. Next "Available" record ?
  53. Slow Access 2003 in Win XP with network connection
  54. Pad lines on a report
  55. Access/Jet Statistics
  56. Questionnaire in MS Access
  57. Text Box Issues
  58. Updating Records on Form through Linked Tables
  59. Go Back And Forth Between Functions
  60. MS Access and SQL bigInt
  61. Change in appearence of google group page
  62. How to do the Declare for a Delphi DLL
  63. how to change the owner of a table
  64. Security Manager Add-in Error
  65. Settle a disagreement with my boss re SELECT DISTINCT
  66. Creating a Backup Database
  67. Setting focus to textbox after clicking on multipage tab
  68. Comb Boxes within a Sub-form
  69. How to copy groups and users from old secury file .mdw into a new one?
  70. Tuning of group reports
  71. Database back end - SQL Server or Access
  72. Autoexec question
  73. Optimization technique
  74. Using same table for Lookup
  75. Won't sendObject from access 2000
  76. Highest Value For Each Person In the Database
  77. calculation visibility
  78. Where clause in SQL statement problem
  79. Can't open linked DB files
  80. Type conversion problems with Access Import Wizard
  81. Corruption Manifests In Access 2000 But Not In Access 2003
  82. OLE Image Problem in A2002
  83. Return to code section and loop before giving up on an error.
  84. Return to code section and loop before giving up on an error.
  85. Query of two tables
  86. show day (date) quickie
  87. Reconnect to DB back end - password
  88. seperate page/document for each record?
  89. Code problem with rowsource and SQL statement
  90. SETTING DIFFERENT RECORDSOURCES FOR ONE REPORT
  91. Please help me get started (Access on the Web)
  92. Simple question (I hope!!) on .FindFirst
  93. dynamic popup screen for multiple comments fields
  94. Help for Xbase to Access -Allen Browne may be
  95. Report including only days with value > 0
  96. scurity + form
  97. Need Loop Help - VBA novice
  98. Combo Box Problem
  99. Is it possible to join two queries together
  100. Retrieve Information about Access Version
  101. password enbaling form
  102. Problema con un report
  103. Filtering out unwanted characters from a mag stripe swipe.
  104. jet 4.0 error message
  105. Can't open my database - linked tables
  106. Change me.sourceobject
  107. A very specific problem involving duplicates
  108. Notification
  109. Query question
  110. Type mismatch error, SQL and Recordset
  111. Function used in SQL Select query
  112. Processor Number
  113. How to remove the CR character (□)
  114. Designing Access2003 unbound form in an asp.net-way?
  115. forms: simple and complex question
  116. Suggestions needed.
  117. multi-page, multi-filter access report problem
  118. Database normalization question
  119. Database Replication A97 vs A2003
  120. Access DB Security
  121. Outlook Emails in Access
  122. Date formatting so "01/22/2005" becomes "January, 2005"
  123. Changing, "FindFirst" to using the, "Seek" Method?
  124. print only some reports?!"
  125. Application Search and Replace Tools
  126. Referencing data in a field within another field
  127. forms --> access
  128. Need help with merging spreadsheet together
  129. Import Specs: Still buried in Access 2003?
  130. Combine (Merge) Data from Two Access Tables
  131. Linking to a backend using code?
  132. Adding index marks for Word
  133. Having trouble setting up transactions
  134. How do I set a form to automaticly start at new record and not overwrite first record?
  135. Update sub-form on tab from field
  136. Qty Problem
  137. Searching Using Combo Boxes
  138. Query help : Urgent please
  139. send Outlook email from different name?
  140. Controls over image
  141. Q about creating new form
  142. blat command line does not work in Shell method
  143. From the previous question - Search the records by groups based on identical field value
  144. Help with Acces Runtime 2002
  145. Locked Record when connecting to SQL Database
  146. if then else - help please
  147. Changing and storing the value in a text box without adding row to table
  148. open & close time of database?
  149. Multiple Concurrent 'References' to MS Excel?
  150. Two Tables
  151. Combo Box question
  152. Appending records in another database
  153. recordsets?
  154. Asp.net caching vs Access Caching.
  155. ADO and DAO together in same application?
  156. Create Autonumber & query problem
  157. Indexing a phone book
  158. Custom page size in report
  159. Extended one to many relationship
  160. Book recommendation for access queries?
  161. SQL Server 2005 Express Edition Overview
  162. OLE problem with A2002
  163. List Box Options Not Appearing
  164. Blanl Lines
  165. Displaying both the master and its details as a grid
  166. A'2003; SourceObject = Query.MyQuery (BUG!) (?)
  167. WEB Integration of Access Database/System
  168. Invoking Filter by Form from Code
  169. IM/EXport specifications automatically creating
  170. Crashing Subform
  171. Crashing Form (& Access)
  172. problem with crosstabs + reports
  173. Combo box bound column value
  174. Re-use values of err.number and err.description after a msgbox in the error handler
  175. Combo box question
  176. Database security
  177. How to either programatically reset AutoNumber or simulate autonumber in a temporary table
  178. Calling a class' private method from a form
  179. Create a form to run a Union All Querry for specific citeria.
  180. Upgrade path to MSSQL2000
  181. QUERY 'ONCLOSE' EVENT?
  182. Database Design Questions
  183. Deleting Records Before Packaging Causing Slow Reports
  184. Run Regedit from Access form
  185. Dual "Parent-Child" Combo Boxes
  186. On cancel=true, extra Access-warning?
  187. RTF2 ActiveX plugin from Stephen Lebans
  188. DBase Index Files
  189. Trying to understand primary keys, relationships and such.
  190. What would cause"Compile error in hidden module"
  191. Required Fields in a Form
  192. Parameter Prompt for field, which was deleted from table
  193. Linking tables to SQL Server 2000 causing strange results
  194. CALCULATING TIME
  195. How to check if table exists
  196. data type mismatch in criteria expression
  197. Unable to set focus on a text box
  198. using flash in ms access 97
  199. Initial Value for Combo Box Text field
  200. List Box on Datasheet Form
  201. run beforeupdate from another sub
  202. Getting rid of Access 2000 LDB files
  203. Compact an Access database in VB code
  204. using a remote MySQL Database in MS Access
  205. DDE - Excel XP
  206. Access vs Visual Studio dot.net
  207. Combining data from several fields in a Union Query
  208. Why function does not work?
  209. Dev Ashish function not recognized. Need advice quick.
  210. Comparing input date to current date
  211. Records across LAN
  212. ddl for union queries
  213. Memory usage for reports
  214. Multiple Sort in a Continuous Form - Similiar to AutoFilter
  215. How to bypass 'No current record' error
  216. Detect idle time, shut database down
  217. Upgrade issues from 97 to 2003 - references? DATE LEFT and FORMAT give compile errors
  218. Stop Autosave for Forms with Table Recordsource
  219. Display a numerical query result as a letter
  220. Strange behavior in a continuous forms subform
  221. Passing an argument to a subroutine
  222. subform with unbound forms
  223. Linux backup - mdbtools detect corruption?
  224. can't append or edit data in form & query
  225. One million records a day
  226. Using access data to fill in pdf forms
  227. Can i open remote (http) files for input?
  228. Connection String suddenly Stops working
  229. Deduplication and Data Cleansing Software
  230. Surpress dialogbox?
  231. Check if printer is active
  232. Thanks!
  233. Documentation outsourcing a must to reduce your expenses
  234. outlook data
  235. create autonumber
  236. Form check box & report data
  237. converting data
  238. Need Help opening a form from a form, using Openargs
  239. Hidding dbWindow form user in access app
  240. Set Report Zoom to 90%
  241. Proxy problem with InetTransferLib
  242. Pivot Charts SUCK - need help
  243. Auto Number from a Make table query
  244. Performance of MSDE over VPN
  245. Problem Opening Report From Form
  246. Can DMIN return multiple values
  247. PopulateCombo Box Row Source with list of files
  248. Linked table password storing
  249. Computer bloat question
  250. conditionally enabling a form control
  251. replicate Frontend MDB to Backend Database
  252. Access
  253. ACC97: Linking tables using two fields in each table
  254. Question about Access 2002
  255. Database Issue
  256. Updateable Query
  257. Using On Mouse Over OR Mouse Move to display a description
  258. connection string with database password...
  259. Backup of an Access Database while Running.
  260. Use multiple queries to display information on a form
  261. Access Database on Web Servers
  262. Access and Excel Pivot Table
  263. Anyone have experience using CDOSYS?
  264. Any Idea is welcome
  265. Reports - position of a control
  266. Resize(): Reliable way to determine bottom padding?
  267. Combo Boxes
  268. Tabcontrol - add records
  269. auto generate claim no
  270. create autonumber
  271. While printer.printing
  272. More challenges with Returning orders
  273. I fall down at my knees
  274. Yes, indeed
  275. DLL In Different Locations
  276. before update - validating potential new data?
  277. import+3query+recursion
  278. need office xp 2002
  279. Sorting Where Sort Field Is Null
  280. Appending data...
  281. Show Total In Subreport On Main Report
  282. Properly cased patronymic last names
  283. Format to say "Required"
  284. report totals
  285. file dialog - select a file
  286. Open Form with a filter value from another form
  287. Module Compare Add-In?
  288. Can't manage to get text to be Vertical
  289. Row Total
  290. Populate List or Combo Box with file names in a folder
  291. can't update/change anything in db application
  292. Last Record
  293. VBA question
  294. On Open Event Procedure
  295. Numeric overflow in [tinyint] field
  296. Using hours in a date range parameter
  297. Expressing hours in a query parameter
  298. On Open Event Procedure
  299. Telling programatically whether an Office product is installed
  300. Tab command in access procedure
  301. This script causes NP Pool to exhaust itself - can't see why - very simple
  302. MS Access 2000 + Table + Report
  303. Query Results formatting.
  304. Testing if an entered value exists
  305. How to manage Access security
  306. Help with access code to close a window
  307. ADO query question - which is faster?
  308. SendObject Warning in Outlook 2003
  309. Get stored procedure output value back in VBA
  310. Trouble with Access 2000 and finding a table's source
  311. Problem retrieving printer information for this object
  312. Project time estimation
  313. Month by month analysys
  314. Append Query Random Failure
  315. Direction on a project early on
  316. Using Mag stripe reader to access records
  317. Sending selected items from listbox to report
  318. Format function in SQL
  319. Help Converting from Treeview 5 to Treeview 6
  320. Output report to rtf format
  321. How to open multiple data bases from one GUI
  322. autonumber->number of key
  323. Fw: Compare textbox value to record in table
  324. Date Difference for different records with same GroupId
  325. Validation rule for number
  326. Need help with Justification in Access
  327. Link Table Manager path problems
  328. Access Scalability - records vs. filesize
  329. Combine two tabels to one. (Regular time and Overtime)
  330. MS Access 2003 Runtime Environment
  331. asp.net datalist display single row
  332. Query results in needless/extra zeros
  333. Huge Database Advice
  334. Huge Database Advice
  335. Query timeout problems
  336. Can not open reports in MS Acess 2003
  337. VBA/ MS Access. Code formating/alignment
  338. Using a variable to store an jpg
  339. Automation - Excel & Access
  340. Creating and using Stored Procedures and Views in Jet
  341. Make table from code?
  342. Setting the size of column widths of a combo box through Code and Searching Combo Box
  343. Doing the unthinkable with my tables
  344. Subreport title
  345. Thanks!
  346. Help with error in trying to email from Access...
  347. Access97 crashes on Windows 2000 or Win XP
  348. Compare textbox value to record in table
  349. EDIT COMMAND
  350. Pls help
  351. Saving Access File
  352. Assistance with Digits To Text Function
  353. A Form Letter with Access
  354. Aligning controls in page header and detail line
  355. A2003 Slow in Shuting Down BE ldb
  356. Password that changes according to month
  357. Combo box entries
  358. Unbound Textbox not printing in Report
  359. Get file attributes with code
  360. using lebans rtf2
  361. Access Paper
  362. Access Docu?
  363. How to copy existing table structure to create empty temp table?
  364. ref:disabled toolbars etc
  365. New; going from flat to relational
  366. Visual Studio Tools for Office ?
  367. Determining whether a Database is corrupt
  368. Dim X as long ==> What is the value of X???
  369. Not able to add record
  370. running a query to find missing names between 2 tables
  371. Sending selected items from listbox to report
  372. ListBox question
  373. Pls help
  374. How to make composite unique index?
  375. CHanging the Extension from mdb to whatever
  376. Coding a switchboard so new forms don't pop open in new windows.
  377. Cascaded update/delete box unavaible.
  378. Access Report / Sub report with parameters
  379. Blank pages in a report
  380. Text box in access report not displaying currency format
  381. Securing A Folder On A Server
  382. Unique OrderId number Help
  383. MS Access on a LAN
  384. Can you stuff data into a word doc w/o word?
  385. Prevent Dups in the code
  386. Doubleclick in listbox
  387. Selecting a row in Subform
  388. UPdate Outlook Calender
  389. Call for help to Scouting members
  390. Linked Files
  391. How can error messages be displayed when using Command Buttons - Access 97 ?
  392. A-2003 - FK combo-box losing formatting when selected in main table
  393. Windows Colour Scheme
  394. How to pass variable value...
  395. Refresh a lookup box?
  396. Setting RecordSource
  397. Import Automation and...
  398. Fuel tracking in vehicle database
  399. Automate run all table names in Combo box
  400. Need to parse Name field so I have to fields, FirstName, LastName
  401. Custom Field in Query Slows it Down Dramatically
  402. Access Developer's Edition Questions
  403. Speeding Up Access and Jet on a Network
  404. code to automate full import - reliable?
  405. Lost References in one copy?
  406. Link two tables?
  407. Connect to Internet from Access?
  408. "You do not have access to the folder ... " message using Access97 on WinXP / WinXP SP2
  409. Access Performance Curiosity Question
  410. Datasheet Form Not Growing to Show Data
  411. Modify a remote macro or startup procedure
  412. calculating a percent of total in a query
  413. How to Energize a Dreadfully Slow Query
  414. Enter a Description using scripts in MS-ACCESS
  415. Design of ticket sales database
  416. Visual Source Safe and MS Access
  417. MS Access 2003 - Error Handlers (Add-ins)
  418. How do I make this report?
  419. Simple Query
  420. Union query
  421. Sorting in forms
  422. How to use form to print report
  423. Programmatically remove a form from Access 2000
  424. format : %
  425. How to get user id of windows into access via vba?
  426. Find record using Combo box
  427. before update - validating potential new data
  428. Create autonumber
  429. Problem with recordset name using string
  430. Encrypting some fields
  431. Pivotchart question
  432. Excel Automation Problem
  433. Charts
  434. Update Query (Access vs. SQL Server)
  435. Access Date Format Input
  436. how can I bypass my query parameter
  437. Disable custom menu in ms access 2000 / xp
  438. ACCESS COPY AND PASTE
  439. Toggling Checkboxes
  440. First sign in a field needs to be a CAPITAL letter
  441. adding numerical values for ID purposes
  442. update table from form
  443. Application.ImportXML Fatal Error; Causes? Way Around?
  444. HTML Template File Name Question
  445. Linked Look-up Menus
  446. filter with form--test for null date
  447. Combo box to query to report
  448. Button Images?
  449. Button Images?
  450. restaurant directory database
  451. Listbox...more
  452. Displaying DWG In A Form
  453. Calculated Control using 3 criteria including dates
  454. List Box DoubleClick
  455. tab control page jumping
  456. Formating currency in a report with mils
  457. Formating currency in a report with mils
  458. Breaking Locks
  459. hyperlink in a report
  460. Access -> Excel
  461. dlookup problem
  462. Hierarchical Data in Jet
  463. ASP Login Failure - Database Password
  464. Enable controls on a tabcontrol
  465. exporting database table create statements
  466. Combo box fills text box
  467. Maschera per interrogare query
  468. Limit decimal places with Excel automation
  469. calculation
  470. Username of XP login
  471. Subform and Macro question.
  472. Sample Switchboard/Design/Code
  473. Shell Woes
  474. Opening Excel spreadsheets: How to get past security warning?
  475. Help with Check Box code
  476. Passthrough queries and RecordsAffected
  477. tab control jumps when you try to cycle subforms?
  478. What's the easiest way to convert an access form to to a web based Front end ?
  479. query to split fields into multiple rows?
  480. If Statement
  481. Append Problems
  482. CurDir
  483. Dates in Visual Basic Access 2003
  484. Transferring data
  485. URGENT PLEASE HELP ASAP. Date/ Time multiplied by a cost for a certain field? PLEASE.
  486. Multi-select list box
  487. Google says piss off!
  488. excel automation, cross tab query, parameterized queries
  489. Child Values in One Field?
  490. Issue tracker MDB
  491. Simple html forms out of a database record?
  492. sql server and access
  493. make all values identical
  494. App Path
  495. help whit DBF linking
  496. HAVE YOU HEARD THE GOOD NEWS!
  497. Web page locks
  498. Priting all files in a Directory
  499. Rename an external file
  500. controltip text not working :-(
  501. Access 2003 -- DAP question -- is it possible to display a form with a subform?
  502. Occurences of a field in database
  503. Opening database with text editor
  504. Connection to MYSQL
  505. Count values across fields?
  506. using database password..
  507. 2003: Functional Analog of AutoExec at Quit time?
  508. Is it possible to
  509. Bilingual amount formatting
  510. When to requery Form after running Update query?
  511. EVERY Chord, Scale and Mode for GUITAR.. Literally!!
  512. Please take a look at this great program
  513. String Link Criteria for List Box
  514. Problems with Converting Text to Currency
  515. negative
  516. VB6 dll passing dates
  517. Novice Question
  518. How do i view the SQL statements behind an existing report
  519. How do i view the SQL statements behind an existing report
  520. Can This be Done? PDF Background
  521. Reports with lots of fields not otherwise in database
  522. MS Access dynamically change a table in a query for a report
  523. Where could I purchase a copy of Building Applications with Microsoft Access 97?
  524. Seeking site describing "Class Modules" in Access 97
  525. Database capability question
  526. Add a cloumn with a row source
  527. I wanna create a new database
  528. embedd report as a subform or such...
  529. Leban's RTF2 Span Report Over Multiple Pages
  530. *IMPORTANT* Message for Google Group, Usenet and AOL users!
  531. App won't close
  532. Idiot Question: Why do I get a propety Error with the following code?
  533. ACCESS ADO-Update Function does not work correctly
  534. calling Excel xla from Access
  535. Automating update of date restriction in query
  536. Find Record mataching 3 criteria Fields
  537. *IMPORTANT* Message for Google Group, Usenet and AOL users!
  538. Open pivot table view by default
  539. *IMPORTANT* Message for Google Group users!
  540. PrtDevMode I think
  541. Access 2003 macro security
  542. Problems sorting forms in Access 2003
  543. choice of DB
  544. Changing the source of a report and query
  545. issues with reporting foreign keys
  546. Can I reference Form properties from a control's property sheet?
  547. Count Distinct Response
  548. Like Statement
  549. Access recordset alternative?
  550. Select query on text field