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. Combo Box problem
  2. How to reuse a subform?
  3. Confirm Successfull Update of Database
  4. Lookup problems
  5. Copying MS Access object (Forms etc) using VB from 1 db to another
  6. docmd.RunSQL Update records in table how can I get rid of the "You are about to update" message
  7. Code to get phone numbers in canonical format?
  8. sql query
  9. Display only 1 item out of duplicates query
  10. Display only 1 item out of duplicates query
  11. Why 50 character fieldsize default for text field type?
  12. Script to Filter and Email Reports
  13. Mouse Wheel
  14. Hiding a Group Footing while a report is running
  15. Linking Tables Problem
  16. List box Help
  17. trying to pass a field name as a string to a function
  18. access 97 to access 2003: query builder question
  19. Open MSAccess 2003 with MSAccess 2000
  20. Can this be done in Access???
  21. Custom date format
  22. Access 2002 and Sync
  23. Reports too wide
  24. Please help friends
  25. tricky access question using sql
  26. Expanding data - 1-5 to 1, 2, 3, 4, 5
  27. Multiples campos en uno
  28. Call me Mr Picky but ...
  29. Abnormal Programm Termination
  30. Copy a recordset will now copy - almost!
  31. Statistical Control Charts
  32. Calendar
  33. looping through records and updating specific records
  34. HELP! Working through the "Trusted Site" security "feature"
  35. Search Form and Access
  36. Keyboard set focus in tabbed subform?
  37. COPY A RECORDSET WILL NO LONGER COPY!
  38. Duplicate Records Warning
  39. New Records to Several Forms
  40. Autonumber Replica
  41. Advice for Avoiding Critical Posts
  42. Advice for reacting to critical posts
  43. Acc97: Splitting tables
  44. Different users, different access using encrypted data
  45. looping through specific records and updating
  46. Custom Menus being overwritten
  47. Dim me as stubborn!
  48. Query Drop box, etc Help will pay for your time!!
  49. Sending email from Access
  50. obtaining and then grouping by week no's
  51. Runtime Access 2002 (I need help)running on Win2K Win98
  52. Advice on database design requested
  53. Problema num relatorio ???
  54. Operation must be an updateable query
  55. access 97: queries
  56. Math SUM() - - Database amounts lack positive / negative
  57. New Records
  58. Images on forms
  59. Drag and Drop from Windows Explorer to copy files from 1 directory to another
  60. Screen Refresh
  61. How to highlight textbox with the max value
  62. Build a reference to a control on the fly
  63. Referencing the Caption of a Custom Popup in VB
  64. Recent problem wtih dates in report - Please help
  65. SQL-Export: Access --> Access - How to make a SQL-File for Backup?
  66. e-mailing mail merged word documents
  67. One last command before DB closes
  68. A2003 - "Code May be Harmful" message
  69. Comparing Tables
  70. Identifier row in query
  71. carriage return in an expression
  72. The best (correct?) way
  73. Looking for the right CRITERIA!
  74. Runtime Error Win 98 Microsoft 2000 Pro
  75. Dates and enrolment
  76. Odd behavior of A2K app in Access 2003
  77. Insert Email Address
  78. IVR software for A2K VBA?
  79. SMTP Engine for VBA?
  80. Month/Year Date Format
  81. Update All Records in Subform
  82. Naming of subreport text boxes
  83. Stored Procedure Temp Table Madness
  84. How do I open a Report to a specific page?
  85. User Interface Conceptual Questionn - on right track?
  86. Dynamically Creating a form
  87. Calculated Controls- Recognizing change in value
  88. Creating PDF
  89. Disabling the <shift> + <enter>
  90. Form Print with changed copies
  91. Windows API ShellExecute in Access 2003/Windows XP
  92. Code a button
  93. Process needs refining,
  94. finding duplicates with two fields....
  95. Pop Music Chart Database Template Needed
  96. Report generates incorrect results after first time
  97. Slidng windows in Ms Access
  98. How secure is my application???
  99. Query, drop box HEELLP!
  100. retrieve word OLE object from a table in access
  101. Performance drops after first lock
  102. Data Access Pages only work from local drive
  103. E-Mail Single Record in Access
  104. Set focus in a recordset?
  105. Finding if a value exists in a table
  106. DoCmd.OpenQuery Windows 98
  107. Null
  108. SQL To JetSQL Converter?
  109. SQL To JetSQL Converter?
  110. Table vs. Query
  111. Appending an s for plural
  112. Sum columns in Access table
  113. Architecture billable-hour tracking
  114. Newbe - Data Entry - Home/End/Arrow Keys
  115. Trying to get file attributes from within Access
  116. Data type mismatch....
  117. No License on Access 97 - Now Out of Memory
  118. ? How to display result set in random order?
  119. ? How to display result set in random order?
  120. Using IIf in Criteria for a query
  121. getting query result to show in sub form.
  122. Report Based On Crosstab Query Question - A2K
  123. Macro condition: how to determine if a column exists?
  124. Convert minutes to hour and minute in MS Access 2000.
  125. Single INSERT statement creates Duplicate Entries!
  126. Modal Form & Minimizing Access
  127. Looking for testers for mdb
  128. Explosion
  129. Derived Columns in one to many relationships
  130. displaying table names based on tabledef properties
  131. Creating a variable from an expression
  132. Creating a variable from an expression
  133. Help vs Online Help
  134. REQ HELP: Batch Print Multiple Reports to Pdf file(s)
  135. Help with pre-printed form
  136. CreateQueryDef and Execute
  137. Rounding time
  138. Key-assignment
  139. Validation Rule for Date (1/1/yyyy or 12/1/yyyy)
  140. most recent date
  141. activeX component can't create object
  142. ftp into access
  143. Access Instant Messenger
  144. Come on you MVPs...Access to Indexing Service...can it be done?
  145. Undefined function Format
  146. Date and parameter issues with dynamic SQL creation
  147. Get recordset from an open query window
  148. Runtime when usin Win98
  149. Need SQL for Joined Tables
  150. Popup Forms
  151. Store List Box values
  152. Barcode reader using Access
  153. Missing Help Files
  154. VBA or VB.NET?
  155. More Data Type Mismatches - It Makes No Sense
  156. Restricting output
  157. Format a specific time in Access
  158. overwrite ADE file when application is opend at client pc
  159. [SUBCLASS] Problem on A_XP
  160. Problem with automatically sending an Outlook appointment generated in VB in Access 97
  161. sub form scrolling
  162. Web Page
  163. How to change orientation in ms word with vba
  164. List Box Column to Memo truncates at 255 characters
  165. format query expression from dialog as percent
  166. What issues can I have with an large Access database
  167. Access and Newer Development Platforms
  168. MS Access 2000 corrupt's databases
  169. ODBC Linking
  170. Security in Access installation
  171. VBA in MS Word and MS Access different (use of external COM objects)
  172. POS printers (point of sale)
  173. VBA - Get Open Windows
  174. Doubt in ado control
  175. Picture Problem
  176. printing checks
  177. Creating HTML Pages from Access 2000
  178. Calculations on a report
  179. scrrun.dll version 1
  180. Problem with a Union of two criteria in a query
  181. VBA Run Query and Prompt forQuery Parameters
  182. Font problem in Report...help wanted.
  183. Spaces in query output names
  184. SQL - how to expand this via sql only please?
  185. Group By
  186. General SQL Question
  187. Asking for database password
  188. columns in reports
  189. Comparing Tables
  190. How can I erase a linked field of a record
  191. Wininet And WinXP SP2 Heads Up
  192. RE-NUMBER KEYS WHEN NEW KEY ADDED
  193. Access 2003 upgrade question.
  194. Question on Queries & Forms
  195. Access File Exports
  196. Outlook Appointment in VB
  197. Dev Avishs Internet Transfer Library & Logging in
  198. Input Data from Text File - Checking for Data Already in DB
  199. Best way to convert query to VB SQL?
  200. Report conditional formatting based on recordset comparison
  201. How to do Query by Form?
  202. Default Field Size question?
  203. Combo Box Drop Down without the focus
  204. Dcount function, return dates in last year in criteria
  205. a2k Turning a single-user app into a multi-user app
  206. Latest Date Query
  207. Missing properties in VB
  208. Report parameter not working
  209. Database Efficiency
  210. Trim/RTrim not stripping trailing space characters in Access 97
  211. Extracting embedded OLE documents from Access
  212. Update Query
  213. Run-time A2003. Edit path to wrkgrp file.
  214. Searching on a text field
  215. import a textfile with vba
  216. MS Access on PDA's
  217. help with DoCmd.Close
  218. Subform load order and "Invalid reference to the property Form"
  219. Subform load order and "Invalid reference to the property Form"
  220. Access Lotus Notes Email, Changing Sent By Name
  221. Graphs working in 2000 and 2002, but not 2003
  222. selecting multiple records to edit
  223. Structuring question - many attributes per person in table
  224. Run a procedure on multiple rows
  225. MS Works 6.0 to Access 2000
  226. Reorganising the contents of a list box
  227. Trouble sorting a column by month
  228. Date field manipulation
  229. Need better argument for using bound forms
  230. Recordset operation seems to hang
  231. How to print a report to a PDF file via code?
  232. Access with word mail merge
  233. updating a field on a particular day.
  234. dao reference confusion: access 97 to 2003
  235. opening a form with a large recordset at a specific record
  236. Query Specific Years
  237. Order of the tables searched
  238. Tab Control - Slow opening
  239. Work with XP but not 2000? Access 2000
  240. (dhl) Who using database
  241. NotInList - NewData split over 3 Fields
  242. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  243. Combo Notinlist - add new item
  244. SQL Help - Selecting first, second and so on
  245. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  246. list box as query criteria
  247. Subform Problem
  248. Combo Box Update Table
  249. Text File Import
  250. Graphical Report Examples?
  251. Row data transfer between tables using a form interface
  252. Snaking columns subreport not snaking when added to main report
  253. How can I pad a number to make sure it's 5 chars in length?
  254. Access 97 Compile Error---any other suggestions?
  255. Recordset update is skipping every other record
  256. DataGrip Director Fatal Error - Need Advice/Help
  257. DoCmd.TransferSpreadsheet
  258. Pass report name to module
  259. Module works, can't open it in Macro
  260. Access 2000 connect to Outlook Inbox
  261. Dealing with ties in ranking code
  262. Reading a text file
  263. Copy Displayed info from a Form to Table
  264. Copy Displayed info from a Form to Table
  265. Running queries via forms
  266. Output Graphics
  267. How do I uninstall 2003 Run-time app
  268. Row Height
  269. report+2 labels
  270. Counting the periods ( "." ) in a large block of text???
  271. Connecting
  272. Data type mismatch error - why?
  273. Why should I use VBA instead of queries?
  274. Notinlist Event
  275. Simple Question?
  276. Quicker/automated way to process single quotes in an INSERT statement?
  277. Printing Reports with Bitmaps
  278. t-sql UDF syntax error help!
  279. Inserting results of a recordset in Chunks
  280. MS Access Forms problem
  281. Report/Subreport Question
  282. help in importing excel spreadsheet !!
  283. Automating a Compact
  284. referencing a DLL from a ms access 2000 database?
  285. Creating report from listbox data?
  286. On Row Data Bind?
  287. Method 'Form' of object '_SubForm' failed
  288. Interesting Combo Box question
  289. Maximum bytes that can be stored in a string variable?
  290. Please help! A2K Memo field showing error "Too much text to edit"
  291. Missing Controls on Form
  292. Sorting form records on the unbound column in a combo box on the form
  293. How to design dynamic table (Unknown number of cells)
  294. HELP WITH REPORT TOTALS
  295. Data Source - Tab Control
  296. createdatabase creates wrong version of access db
  297. report subform print control
  298. VBA Programming Ported over to Excel
  299. Automation Error
  300. Problem with Deleted Records
  301. How do I programmatically set macro security to Low ?
  302. Compare Tables Between Databases
  303. Split database slow over the network
  304. Table design
  305. Help Needed to Create Special Records
  306. Documentation for various refernces appearing in VBA compiler - "FundWare"
  307. Documentation for various refernces appearing in VBA compiler - "FundWare"
  308. easy data entry?
  309. Compact database error
  310. Need a combo box with only certain numbers
  311. InputBox date prompt gives wrong month
  312. HELP! Old ODBC Drivers on Windows XP
  313. Problem using an interlocked WHERE-Clause
  314. Can't open database in A2k
  315. smtp emailing - aspemail, vsemail, other dlls...
  316. Time Stamp
  317. Return average of non zero values in query
  318. How to Compare Autonumbers and Return the Larger Value, and try to Assign it to a Bound Field
  319. VBA or qry
  320. combo dropdown
  321. Table Hyperlink
  322. spell check in Access is not working
  323. Help Coding Unique Numbers for Primary Keys
  324. Access 2003 Report log
  325. Microsoft Access build management
  326. Formatting calendar type report
  327. Using the OrderBy property on an unbound ComboBox column
  328. Locating a legal copy of Office 97 Developer Edition in Spanish
  329. Access and web pages
  330. Pivot Table
  331. Multi-Select Listbox
  332. FTP/CGI Code?
  333. .mdb file locks up at times. Permission settings question
  334. recover deleted records
  335. Fill field with chosen value from a drop down combo box
  336. Linked DB2 table in Access 2000 shows #Deleted on every record
  337. Is this Query inefficient?
  338. Converting 97 to 2000
  339. One process cant read data inserted by other process. Why?
  340. A strange delay in interaction between 2 subforms
  341. Distribute Access .mdb file
  342. Automated entries in form
  343. Why can't I delete from an updatable query
  344. Recalculate Calculated Control on Form
  345. Adjust Control Height/Width Precisely
  346. Type safety vs late binding and class polymorphism
  347. Report - Output to Snapshot ... then Email as Attachment using Outlook Express !
  348. Suppress Zero values in a Cross Tab report
  349. Strange problem with secured database--Urgent HELP Needed
  350. MOD Operation
  351. Get The Decimal Part Of A Number
  352. Validate Time in MS Access 2000
  353. tab out subform01 to subform02
  354. Sorting Table Data (Yes, I know I should have used a query!)
  355. calculating days
  356. Help with Totals in Report
  357. Date & Time Field
  358. Using a key based on 2 fields
  359. getrows problem with a dao recordset
  360. getrows problem with a dao recordset
  361. Mystery can't add new Records
  362. when or Where do you use a union query ?
  363. OnOepn event in report
  364. Mystery can't add new Records
  365. SQL query question
  366. Capitalizing first letter of each work
  367. Installing a 2002 version DB on a A97 system
  368. Access Database To Web Server
  369. Require some feedback regarding using tree - list- view in Access XP
  370. Database opening slowly
  371. Exporting Euros To Excel
  372. Optional arguaments and IsMissing function
  373. Where to find small fonts
  374. CA issues million dollar challenge to open source community
  375. Storing JPEG Thumbnails
  376. File does not exist (?!)
  377. Display an image if a field has data or not
  378. When should Activate happen?
  379. spell check in Access greyed out
  380. Some SQL is *Much* Faster Than Other
  381. Subform updating
  382. Multiple Entries per field
  383. importing data
  384. DAP -update frame from table value?
  385. 3 SubReports with date parameters
  386. table linked to text file producing extra rows
  387. RunningSum in Report not re-setting by group
  388. Invalid procedure call in query - why!??!
  389. Validation rule
  390. Print a file in a database
  391. Calendar control
  392. Report / Subreport sum
  393. Normailising Tables
  394. ADP - Walk the collection
  395. SELECT COUNT - How to get this value to a variable in VBA???
  396. ChangeRegister?
  397. Mail merge problem
  398. access 2002 and vba
  399. How to get Graphs from MS Access and use them in MS Powerpoint
  400. please help to create a table with relationships
  401. Sorting based on field not in table
  402. Limits of Access 2003 using ADP on SQL Server Express BE?
  403. What is crashing Access 97 (SR-2)?
  404. the expression builder
  405. Query to select latest date among several
  406. muddle with security
  407. Printing report programatically while the report is still processing
  408. Record number - on Form - always defaults to 1
  409. Comparing tables in MS Access
  410. Writing GetUserName value to table
  411. error from getting value from a text box
  412. Date function
  413. Using DMax "a hard one"
  414. Report header question
  415. Database gone amok
  416. Open Main form - MAXIMIZED.
  417. Outlook Click Yes - Reference problem???
  418. ADP text box issue: Backspace deletes ALL text.
  419. table deletions
  420. Requery Subform From Another Subform
  421. Problem with Index using Seek method
  422. Updating Tables in Stock Database
  423. regrouping data in large dataset
  424. Outlook content to access
  425. Need recommendation for beginner's Access book for client
  426. Looping SQL SELECT and INSERT INTO query
  427. Access 2000 failing to activate "mailto: " hyperlink
  428. saving records with "enter"
  429. Datensatz speichern nur durch RETURN
  430. How to retrieve User name and group of a secured db vis VBA?
  431. Query problems when using Nz
  432. executing stored procedure in vb Access97
  433. lock record on a form
  434. Oracle vs Access
  435. Excecute VBScript from Access
  436. Access database corrupted - Relationship between related tables LOST
  437. Inner Join Conundrum
  438. Program won't run from CD
  439. Export to csv having issue with import to SQL(Remedy)
  440. Total Access Analyzer Support
  441. I need a non-example-specific description of how to do dynamic crosstab reports
  442. Does using Filter vs. RecordSource for Report create more network traffic?
  443. how to handle locked objects?
  444. Problem with new records in subform
  445. Searching for DB Objects within an ADP
  446. Filtering records in a form based on data in a subform or another query.
  447. text box visibility in report
  448. Won't open Common Dialog Box using API call
  449. report+truncate
  450. calculated form
  451. Open new instance of Word from mdb.
  452. Import outlook custom form fields data into access
  453. Download
  454. Access - web forms
  455. Adding Multiple records using Relational Tables
  456. Trying To View JPEGS: Microsoft Access Doesn't Support The format of the file
  457. Questions, Questions...
  458. Set sort order in MS Access 2000 report
  459. margins setup
  460. Clear Database
  461. Delete duplicate data in Access
  462. a2k recovered from corruption, missing relationships
  463. Auto Assign Value Based On Another Field's Value
  464. Counting Problem
  465. New to VB -- how to open an Access table?
  466. Help with Reporting
  467. Report based on crosstab query
  468. FORMS - Give consistent visual appearance to all.
  469. interest calculation
  470. Date format range
  471. Continuous Forms
  472. Problem with Access2002 app made on localized version and run under US version - Please help
  473. Referential Integrity - How to update a table?
  474. Tab control within another tab control
  475. Database Repair Services
  476. ADPs, Integrated Security and Selective Permissions
  477. INSERT INTO confusion
  478. Advance Query..Urgent
  479. Anyone have experience with dbUpgrader or other ways to upgrade back end?
  480. Query on month
  481. Can't .Undo Date control
  482. Email Invoice
  483. Snap shot viewer
  484. query needed to subtract values
  485. RecordSource Property Unavailable
  486. Printing Reports to Multiple Printers
  487. SQL query referencing field values + wildcards
  488. Auto populate a second field
  489. ?Issues using DLOOKUP & both negative / positive lookup values?
  490. Database Management System
  491. Mysterious Behaviors of the Combo Box
  492. SQL query fails
  493. Rename Files in a Directory
  494. SQL Delete statement
  495. a2k detect identical records
  496. Transfer Text from Union Query
  497. How do I run a sumation matching database.......
  498. VBA reference question
  499. Subform won't show data selected from Combo Box
  500. working with forms
  501. Export Records to a text-file
  502. elegant solution to many-to-many table/form problem
  503. planning access
  504. Switchboard?
  505. Abfrage definieren: [Katze, Katze, Hund,Hund, Hund, Vogel,....] --> [Katze, Hund, Vogel]
  506. Error converting from Acc97 to Acc2000
  507. Importing a .txt file into an existing database
  508. mail merge to word
  509. missing lines in reports
  510. Synchronising forms
  511. FTP from MS Access?
  512. starting one database with another
  513. Centre a Report at Runtime
  514. sending emails
  515. mail merge to word
  516. group options and tab stop in a form help
  517. group options and tab stop in a form help
  518. How Can aBound Combo Box be Used as a Record Selector?
  519. Replacing Forms w/Unbound populating w/Query
  520. Bookmarking Record for return
  521. ask me a question ms access databases
  522. opening an image viewer
  523. Summing columns in two separate queries
  524. MDM.EXE on startup menu
  525. Reference to use 'fIsAppRunning' in Access 2002
  526. export a query/mail merge To MS Word from Access In code
  527. appending prefix to a report field
  528. Filtering a subform
  529. question: automatically generating field names from record values
  530. Access 2000 Stability
  531. Programatically Close any form that hasn't got focus
  532. Testing for an open recordset
  533. Problem with err.raise
  534. Win 2000 and access pecularities
  535. Looping Structure to change field data
  536. Relocating Columns in QBE Grid
  537. 2 checkboxes and a continuos form
  538. calculated fields in tables/ queries
  539. Followup: Module Problem with CODE
  540. Relinking tables to Multiple "Back-ends" (using multiple OS's!)
  541. SQL searches and ODBC to Oracle database
  542. Auto-populate a field
  543. WAV Files
  544. "Query is too complex" error
  545. Programatically Create Query for tables
  546. Change the field name
  547. VB "Call" syntax vs command-style syntax
  548. Rankings
  549. printing Yes, No, Maybe from the numbers 1, 2, and 3 using an Access report
  550. Help! How to Loop through Recordsetset, create web page, ASP, and save it ??