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. problem with autonumber-field in Access
  2. saving a record before a Close action -- "Me.Dirty = False" OR "RunCommand acCmdSaveRecord"
  3. User-defined type not defined
  4. Punkt 1231049 - Powalice
  5. a2k - validating excel file before importing
  6. Combo Box Row Source
  7. Access Linked Tables and IIS/ASP
  8. Hoiw to store text to the Windows Clipboard using vba
  9. Blank Query Parameter Problems
  10. mousewheelhook Stephen Lebans
  11. Using SQL to source email address list
  12. runsql vs Execute
  13. Ad
  14. Database Design
  15. Going mobile with PDA: Palm OS or PocketPc platform ?
  16. Queries with field names defined by a control in a form
  17. are Transactions necessary with Forms?
  18. Connect to filebased accessdatabase on other computer?
  19. Looking for an Access Programmer
  20. getting rid of a dodgy query
  21. Calendar of Events
  22. better VBA editor? Does anyone know of a better VBA editor for Access?
  23. Credit card authentication from Access
  24. Telephone
  25. How do I remove references to non-existent menubars in an Access 2.0 report?
  26. queries and sql
  27. how to know which is the current user logged on access project
  28. SQL Problem
  29. Query on a calculated date field
  30. loc files
  31. ByRef question
  32. How Can I fax directly from Access 2003 to MS Fax
  33. ByRef question
  34. Access 2003 with a 2000 database
  35. How to trigger a tab key press programmatically?
  36. Lookup List with Code Hiding?
  37. bind a standalone recordset to a form
  38. Error 3251 Operation is not supported for this type of object
  39. Changing form properties with a button
  40. Refer to a control by its index
  41. Control array on form
  42. Access with SQL Server
  43. going beyond blanket upper case conversion
  44. Declaring variables
  45. Comparing quarterly sales data to previous quarter and previous year.
  46. ZOrder or SetChildIndex in Access
  47. multiple records open with forms
  48. Check for Backup file before deleting
  49. MAX with JOINS
  50. VIEW Relationships Using VBA
  51. Reporting Problem !
  52. Batch updates based on form data entries
  53. Listbox max lenght valuelist
  54. How to suppress pop up box.
  55. How to mimic a doubleclick in VBA
  56. Prepare a number
  57. combo box select when opening report
  58. Object owner can't change security
  59. Controlling "Next record" button
  60. randomising for a quiz
  61. MS Access on PocketPC?
  62. Using Rich TextBox on Forms
  63. How to get Bold letters in MsgBox
  64. Acces 2003 Package Wizard with Developer Extensions
  65. Opening an external Access form to add record (not-in-list event)
  66. Calculated Field Problem Access 2000 DB and Access 2003
  67. Linked SQL Tables
  68. Acc2003 - acDialog form freezing
  69. Filter By Form
  70. To Access MVPs regarding Access 2003 Help
  71. DCount and DLookup with Date
  72. Code question in form?
  73. MS Access 97 Find Duplicates Query w/o the Wizard
  74. Filter Combo Box Using A Checkbox
  75. AutoLookUp wont save field
  76. Postcode Database
  77. PRoblems importing excel spreadsheet
  78. linked table after microsoft access 2003
  79. Datensatzleiste enablen
  80. Setting a value in a subform
  81. Access 2000 - Error 3426 "This action was cancelled by an associated object" - info
  82. startup for to be invisible
  83. MDE doesn't work on target machine -- Access 2000
  84. Manipulating TableDefs
  85. Sorting out the logic
  86. Intranet/Network
  87. How to terminate process with VBA?
  88. AC2003 Runtime
  89. Copy & Pasting AC2003
  90. "Molasses" for Windows LAN?
  91. Changing field names or setting field names while importing a range of cells from Excel to Access
  92. Stand alone database
  93. Access Application on a web page
  94. Prevent
  95. Access Parameter Query to Word Merge
  96. Final solution on copy a recordset?
  97. Modify DAO.Tabledef
  98. Images quality in Reports
  99. Security Problem
  100. Run AutoReport with Parms from VBA
  101. Hyperlink Stop New MS IE instances
  102. Yes/No Field Using Make-Table Query
  103. Need advice on Word Automation from Access
  104. milti column page layout report
  105. Problem cycling records
  106. resize only a record in a continuous form
  107. Advice on VBA Comment Style
  108. running sum
  109. ODBC error - linking to oracle
  110. Why is this so slow
  111. Securing a Backend
  112. Test for Nothing
  113. PDF Automation
  114. Export fixed-width file
  115. Open an ODBC connection in a jet workspace and which workspace is better
  116. Can I call a SQL Server 2000 User-Defined Function from Access 2003?
  117. Write conflict (Record locking)
  118. Queries for MSSQL Server
  119. access 2003: ftp question
  120. appending local table to remote table using pass-through query
  121. Calculation on a form and a report
  122. running total in query
  123. Problem using Access linked table in Visual Studio.Net
  124. Replication and memo field
  125. Need Proof... Need Help Access issues
  126. access auto email message body
  127. What's the next step...connect to db in web folder
  128. VPN - FYI
  129. Help with Queries
  130. query help with conditional summing
  131. Problem to print the value of a parameter on a report?
  132. What is the largest "auto number" that can exist in an Access database? How to reset autonumber to start at 1?
  133. Combo Box problem
  134. How to reuse a subform?
  135. Confirm Successfull Update of Database
  136. Lookup problems
  137. Copying MS Access object (Forms etc) using VB from 1 db to another
  138. docmd.RunSQL Update records in table how can I get rid of the "You are about to update" message
  139. Code to get phone numbers in canonical format?
  140. sql query
  141. Display only 1 item out of duplicates query
  142. Display only 1 item out of duplicates query
  143. Why 50 character fieldsize default for text field type?
  144. Script to Filter and Email Reports
  145. Mouse Wheel
  146. Hiding a Group Footing while a report is running
  147. Linking Tables Problem
  148. List box Help
  149. trying to pass a field name as a string to a function
  150. access 97 to access 2003: query builder question
  151. Open MSAccess 2003 with MSAccess 2000
  152. Can this be done in Access???
  153. Custom date format
  154. Access 2002 and Sync
  155. Reports too wide
  156. Please help friends
  157. tricky access question using sql
  158. Expanding data - 1-5 to 1, 2, 3, 4, 5
  159. Multiples campos en uno
  160. Call me Mr Picky but ...
  161. Abnormal Programm Termination
  162. Copy a recordset will now copy - almost!
  163. Statistical Control Charts
  164. Calendar
  165. looping through records and updating specific records
  166. HELP! Working through the "Trusted Site" security "feature"
  167. Search Form and Access
  168. Keyboard set focus in tabbed subform?
  169. COPY A RECORDSET WILL NO LONGER COPY!
  170. Duplicate Records Warning
  171. New Records to Several Forms
  172. Autonumber Replica
  173. Advice for Avoiding Critical Posts
  174. Advice for reacting to critical posts
  175. Acc97: Splitting tables
  176. Different users, different access using encrypted data
  177. looping through specific records and updating
  178. Custom Menus being overwritten
  179. Dim me as stubborn!
  180. Query Drop box, etc Help will pay for your time!!
  181. Sending email from Access
  182. obtaining and then grouping by week no's
  183. Runtime Access 2002 (I need help)running on Win2K Win98
  184. Advice on database design requested
  185. Problema num relatorio ???
  186. Operation must be an updateable query
  187. access 97: queries
  188. Math SUM() - - Database amounts lack positive / negative
  189. New Records
  190. Images on forms
  191. Drag and Drop from Windows Explorer to copy files from 1 directory to another
  192. Screen Refresh
  193. How to highlight textbox with the max value
  194. Build a reference to a control on the fly
  195. Referencing the Caption of a Custom Popup in VB
  196. Recent problem wtih dates in report - Please help
  197. SQL-Export: Access --> Access - How to make a SQL-File for Backup?
  198. e-mailing mail merged word documents
  199. One last command before DB closes
  200. A2003 - "Code May be Harmful" message
  201. Comparing Tables
  202. Identifier row in query
  203. carriage return in an expression
  204. The best (correct?) way
  205. Looking for the right CRITERIA!
  206. Runtime Error Win 98 Microsoft 2000 Pro
  207. Dates and enrolment
  208. Odd behavior of A2K app in Access 2003
  209. Insert Email Address
  210. IVR software for A2K VBA?
  211. SMTP Engine for VBA?
  212. Month/Year Date Format
  213. Update All Records in Subform
  214. Naming of subreport text boxes
  215. Stored Procedure Temp Table Madness
  216. How do I open a Report to a specific page?
  217. User Interface Conceptual Questionn - on right track?
  218. Dynamically Creating a form
  219. Calculated Controls- Recognizing change in value
  220. Creating PDF
  221. Disabling the <shift> + <enter>
  222. Form Print with changed copies
  223. Windows API ShellExecute in Access 2003/Windows XP
  224. Code a button
  225. Process needs refining,
  226. finding duplicates with two fields....
  227. Pop Music Chart Database Template Needed
  228. Report generates incorrect results after first time
  229. Slidng windows in Ms Access
  230. How secure is my application???
  231. Query, drop box HEELLP!
  232. retrieve word OLE object from a table in access
  233. Performance drops after first lock
  234. Data Access Pages only work from local drive
  235. E-Mail Single Record in Access
  236. Set focus in a recordset?
  237. Finding if a value exists in a table
  238. DoCmd.OpenQuery Windows 98
  239. Null
  240. SQL To JetSQL Converter?
  241. SQL To JetSQL Converter?
  242. Table vs. Query
  243. Appending an s for plural
  244. Sum columns in Access table
  245. Architecture billable-hour tracking
  246. Newbe - Data Entry - Home/End/Arrow Keys
  247. Trying to get file attributes from within Access
  248. Data type mismatch....
  249. No License on Access 97 - Now Out of Memory
  250. ? How to display result set in random order?
  251. ? How to display result set in random order?
  252. Using IIf in Criteria for a query
  253. getting query result to show in sub form.
  254. Report Based On Crosstab Query Question - A2K
  255. Macro condition: how to determine if a column exists?
  256. Convert minutes to hour and minute in MS Access 2000.
  257. Single INSERT statement creates Duplicate Entries!
  258. Modal Form & Minimizing Access
  259. Looking for testers for mdb
  260. Explosion
  261. Derived Columns in one to many relationships
  262. displaying table names based on tabledef properties
  263. Creating a variable from an expression
  264. Creating a variable from an expression
  265. Help vs Online Help
  266. REQ HELP: Batch Print Multiple Reports to Pdf file(s)
  267. Help with pre-printed form
  268. CreateQueryDef and Execute
  269. Rounding time
  270. Key-assignment
  271. Validation Rule for Date (1/1/yyyy or 12/1/yyyy)
  272. most recent date
  273. activeX component can't create object
  274. ftp into access
  275. Access Instant Messenger
  276. Come on you MVPs...Access to Indexing Service...can it be done?
  277. Undefined function Format
  278. Date and parameter issues with dynamic SQL creation
  279. Get recordset from an open query window
  280. Runtime when usin Win98
  281. Need SQL for Joined Tables
  282. Popup Forms
  283. Store List Box values
  284. Barcode reader using Access
  285. Missing Help Files
  286. VBA or VB.NET?
  287. More Data Type Mismatches - It Makes No Sense
  288. Restricting output
  289. Format a specific time in Access
  290. overwrite ADE file when application is opend at client pc
  291. [SUBCLASS] Problem on A_XP
  292. Problem with automatically sending an Outlook appointment generated in VB in Access 97
  293. sub form scrolling
  294. Web Page
  295. How to change orientation in ms word with vba
  296. List Box Column to Memo truncates at 255 characters
  297. format query expression from dialog as percent
  298. What issues can I have with an large Access database
  299. Access and Newer Development Platforms
  300. MS Access 2000 corrupt's databases
  301. ODBC Linking
  302. Security in Access installation
  303. VBA in MS Word and MS Access different (use of external COM objects)
  304. POS printers (point of sale)
  305. VBA - Get Open Windows
  306. Doubt in ado control
  307. Picture Problem
  308. printing checks
  309. Creating HTML Pages from Access 2000
  310. Calculations on a report
  311. scrrun.dll version 1
  312. Problem with a Union of two criteria in a query
  313. VBA Run Query and Prompt forQuery Parameters
  314. Font problem in Report...help wanted.
  315. Spaces in query output names
  316. SQL - how to expand this via sql only please?
  317. Group By
  318. General SQL Question
  319. Asking for database password
  320. columns in reports
  321. Comparing Tables
  322. How can I erase a linked field of a record
  323. Wininet And WinXP SP2 Heads Up
  324. RE-NUMBER KEYS WHEN NEW KEY ADDED
  325. Access 2003 upgrade question.
  326. Question on Queries & Forms
  327. Access File Exports
  328. Outlook Appointment in VB
  329. Dev Avishs Internet Transfer Library & Logging in
  330. Input Data from Text File - Checking for Data Already in DB
  331. Best way to convert query to VB SQL?
  332. Report conditional formatting based on recordset comparison
  333. How to do Query by Form?
  334. Default Field Size question?
  335. Combo Box Drop Down without the focus
  336. Dcount function, return dates in last year in criteria
  337. a2k Turning a single-user app into a multi-user app
  338. Latest Date Query
  339. Missing properties in VB
  340. Report parameter not working
  341. Database Efficiency
  342. Trim/RTrim not stripping trailing space characters in Access 97
  343. Extracting embedded OLE documents from Access
  344. Update Query
  345. Run-time A2003. Edit path to wrkgrp file.
  346. Searching on a text field
  347. import a textfile with vba
  348. MS Access on PDA's
  349. help with DoCmd.Close
  350. Subform load order and "Invalid reference to the property Form"
  351. Subform load order and "Invalid reference to the property Form"
  352. Access Lotus Notes Email, Changing Sent By Name
  353. Graphs working in 2000 and 2002, but not 2003
  354. selecting multiple records to edit
  355. Structuring question - many attributes per person in table
  356. Run a procedure on multiple rows
  357. MS Works 6.0 to Access 2000
  358. Reorganising the contents of a list box
  359. Trouble sorting a column by month
  360. Date field manipulation
  361. Need better argument for using bound forms
  362. Recordset operation seems to hang
  363. How to print a report to a PDF file via code?
  364. Access with word mail merge
  365. updating a field on a particular day.
  366. dao reference confusion: access 97 to 2003
  367. opening a form with a large recordset at a specific record
  368. Query Specific Years
  369. Order of the tables searched
  370. Tab Control - Slow opening
  371. Work with XP but not 2000? Access 2000
  372. (dhl) Who using database
  373. NotInList - NewData split over 3 Fields
  374. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  375. Combo Notinlist - add new item
  376. SQL Help - Selecting first, second and so on
  377. '''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
  378. list box as query criteria
  379. Subform Problem
  380. Combo Box Update Table
  381. Text File Import
  382. Graphical Report Examples?
  383. Row data transfer between tables using a form interface
  384. Snaking columns subreport not snaking when added to main report
  385. How can I pad a number to make sure it's 5 chars in length?
  386. Access 97 Compile Error---any other suggestions?
  387. Recordset update is skipping every other record
  388. DataGrip Director Fatal Error - Need Advice/Help
  389. DoCmd.TransferSpreadsheet
  390. Pass report name to module
  391. Module works, can't open it in Macro
  392. Access 2000 connect to Outlook Inbox
  393. Dealing with ties in ranking code
  394. Reading a text file
  395. Copy Displayed info from a Form to Table
  396. Copy Displayed info from a Form to Table
  397. Running queries via forms
  398. Output Graphics
  399. How do I uninstall 2003 Run-time app
  400. Row Height
  401. report+2 labels
  402. Counting the periods ( "." ) in a large block of text???
  403. Connecting
  404. Data type mismatch error - why?
  405. Why should I use VBA instead of queries?
  406. Notinlist Event
  407. Simple Question?
  408. Quicker/automated way to process single quotes in an INSERT statement?
  409. Printing Reports with Bitmaps
  410. t-sql UDF syntax error help!
  411. Inserting results of a recordset in Chunks
  412. MS Access Forms problem
  413. Report/Subreport Question
  414. help in importing excel spreadsheet !!
  415. Automating a Compact
  416. referencing a DLL from a ms access 2000 database?
  417. Creating report from listbox data?
  418. On Row Data Bind?
  419. Method 'Form' of object '_SubForm' failed
  420. Interesting Combo Box question
  421. Maximum bytes that can be stored in a string variable?
  422. Please help! A2K Memo field showing error "Too much text to edit"
  423. Missing Controls on Form
  424. Sorting form records on the unbound column in a combo box on the form
  425. How to design dynamic table (Unknown number of cells)
  426. HELP WITH REPORT TOTALS
  427. Data Source - Tab Control
  428. createdatabase creates wrong version of access db
  429. report subform print control
  430. VBA Programming Ported over to Excel
  431. Automation Error
  432. Problem with Deleted Records
  433. How do I programmatically set macro security to Low ?
  434. Compare Tables Between Databases
  435. Split database slow over the network
  436. Table design
  437. Help Needed to Create Special Records
  438. Documentation for various refernces appearing in VBA compiler - "FundWare"
  439. Documentation for various refernces appearing in VBA compiler - "FundWare"
  440. easy data entry?
  441. Compact database error
  442. Need a combo box with only certain numbers
  443. InputBox date prompt gives wrong month
  444. HELP! Old ODBC Drivers on Windows XP
  445. Problem using an interlocked WHERE-Clause
  446. Can't open database in A2k
  447. smtp emailing - aspemail, vsemail, other dlls...
  448. Time Stamp
  449. Return average of non zero values in query
  450. How to Compare Autonumbers and Return the Larger Value, and try to Assign it to a Bound Field
  451. VBA or qry
  452. combo dropdown
  453. Table Hyperlink
  454. spell check in Access is not working
  455. Help Coding Unique Numbers for Primary Keys
  456. Access 2003 Report log
  457. Microsoft Access build management
  458. Formatting calendar type report
  459. Using the OrderBy property on an unbound ComboBox column
  460. Locating a legal copy of Office 97 Developer Edition in Spanish
  461. Access and web pages
  462. Pivot Table
  463. Multi-Select Listbox
  464. FTP/CGI Code?
  465. .mdb file locks up at times. Permission settings question
  466. recover deleted records
  467. Fill field with chosen value from a drop down combo box
  468. Linked DB2 table in Access 2000 shows #Deleted on every record
  469. Is this Query inefficient?
  470. Converting 97 to 2000
  471. One process cant read data inserted by other process. Why?
  472. A strange delay in interaction between 2 subforms
  473. Distribute Access .mdb file
  474. Automated entries in form
  475. Why can't I delete from an updatable query
  476. Recalculate Calculated Control on Form
  477. Adjust Control Height/Width Precisely
  478. Type safety vs late binding and class polymorphism
  479. Report - Output to Snapshot ... then Email as Attachment using Outlook Express !
  480. Suppress Zero values in a Cross Tab report
  481. Strange problem with secured database--Urgent HELP Needed
  482. MOD Operation
  483. Get The Decimal Part Of A Number
  484. Validate Time in MS Access 2000
  485. tab out subform01 to subform02
  486. Sorting Table Data (Yes, I know I should have used a query!)
  487. calculating days
  488. Help with Totals in Report
  489. Date & Time Field
  490. Using a key based on 2 fields
  491. getrows problem with a dao recordset
  492. getrows problem with a dao recordset
  493. Mystery can't add new Records
  494. when or Where do you use a union query ?
  495. OnOepn event in report
  496. Mystery can't add new Records
  497. SQL query question
  498. Capitalizing first letter of each work
  499. Installing a 2002 version DB on a A97 system
  500. Access Database To Web Server
  501. Require some feedback regarding using tree - list- view in Access XP
  502. Database opening slowly
  503. Exporting Euros To Excel
  504. Optional arguaments and IsMissing function
  505. Where to find small fonts
  506. CA issues million dollar challenge to open source community
  507. Storing JPEG Thumbnails
  508. File does not exist (?!)
  509. Display an image if a field has data or not
  510. When should Activate happen?
  511. spell check in Access greyed out
  512. Some SQL is *Much* Faster Than Other
  513. Subform updating
  514. Multiple Entries per field
  515. importing data
  516. DAP -update frame from table value?
  517. 3 SubReports with date parameters
  518. table linked to text file producing extra rows
  519. RunningSum in Report not re-setting by group
  520. Invalid procedure call in query - why!??!
  521. Validation rule
  522. Print a file in a database
  523. Calendar control
  524. Report / Subreport sum
  525. Normailising Tables
  526. ADP - Walk the collection
  527. SELECT COUNT - How to get this value to a variable in VBA???
  528. ChangeRegister?
  529. Mail merge problem
  530. access 2002 and vba
  531. How to get Graphs from MS Access and use them in MS Powerpoint
  532. please help to create a table with relationships
  533. Sorting based on field not in table
  534. Limits of Access 2003 using ADP on SQL Server Express BE?
  535. What is crashing Access 97 (SR-2)?
  536. the expression builder
  537. Query to select latest date among several
  538. muddle with security
  539. Printing report programatically while the report is still processing
  540. Record number - on Form - always defaults to 1
  541. Comparing tables in MS Access
  542. Writing GetUserName value to table
  543. error from getting value from a text box
  544. Date function
  545. Using DMax "a hard one"
  546. Report header question
  547. Database gone amok
  548. Open Main form - MAXIMIZED.
  549. Outlook Click Yes - Reference problem???
  550. ADP text box issue: Backspace deletes ALL text.