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. Refresh on mainform/subform
  2. Maximum length of an If Then line in VBA
  3. Is it possible to specify a specific printer in the vba code?
  4. Is it possible to specify a specific printer in the vba code?
  5. Dialer in AccessFAQ.exe?
  6. Continue to lock record in main form while editing subform records
  7. two nested select statements
  8. Faxing Reports on the Fly
  9. String Manipulation
  10. Systemically OutPut Access Report To PDF
  11. Wierd error when editing an Access Memo field.
  12. LARGE report problem
  13. Scrolling problem with php web page - problem with IE or PHP?
  14. How come I sometimes get this?? "Run-time error 3211: can't lock table. "
  15. Synchronizing Table definitionns in one mdb file with those from a second mdb file
  16. How to compare fields from similar tables
  17. Works to Access
  18. I need HELP with error "Too few parameters..."
  19. where can i find a script
  20. How to convert php script to access
  21. Design Question
  22. is the byte on or off
  23. Programatically Enter Data Into main Form And Subform
  24. printing odd pages of reports / duplex printing in Access 2002
  25. Filtering text boxes from two comboxes
  26. Filtering text boxes from two comboxes
  27. Reset Field Autonumbering
  28. printing subforms
  29. update to second table?
  30. Division in Access does not match Excel.
  31. OPTIMIZING A FORM?
  32. DAO problem in Access 2003 - Can't find .Edit method for recordset
  33. MSACCESS.exe process does not stop when user exits Access
  34. Help: Using a Checkbox to Control a Date's Value
  35. Query based on form parameters
  36. How to go through a bunch of text boxes in a form.
  37. What's the best way to do this in Access2000?
  38. Continuous Form locking after sorting
  39. Why can't I use Database object in code?
  40. Make active page name on tabbed form BOLD - A97
  41. Any suggestions
  42. Disadvantage of Access as front-end
  43. how to force form to load in datasheet view
  44. what event is fired when you move to next record in form
  45. Duplicates
  46. A validation rule question
  47. database for internet - compacting
  48. Need help with validation rule
  49. 2 quesitons about forms
  50. report rowsource query
  51. Mailmerge problems - how to solve?
  52. Which Code run faster in MS Access SQL or DAO
  53. How do I time out (auto exit) an MS Access 2000 application if no activities after a certain time?
  54. Rectangles on a form
  55. query problem - recordset not opening
  56. Processing Fees based on Percentage
  57. XML-Import in Access2002
  58. Can't change data in query after adding table
  59. What is the best setup program generator for a commercial Access application?
  60. wifi hotspot directory available in MS Access format
  61. You'd think they'd have used ...
  62. Format a report with rows and columns
  63. Parameter query via value in form - driving me mad
  64. The visual basic for Applications project in the database is corrupt
  65. Adding Item to Combo Box
  66. Time isn't on my side
  67. Programatically Enter Data Into Another Form
  68. Copy data from subform1 to subform2
  69. Run Macros without MS ACCESS loaded
  70. Auto Data Entry
  71. split reattach code question
  72. Beginner Help Again - Queries
  73. Update combobox from table.
  74. Help needed with databases + asp problem
  75. Weird actions after upgrading from 2.0-2000
  76. Shareware documentation?
  77. FROM RELATIONAL TO FLAT
  78. Custom message box on NotInList - don't want to add new value
  79. Open Form WIth Calendar Control To Specific Date
  80. Report Layout Help Required
  81. Subform OnExit Not Enough
  82. Passing Value from the form to a report query
  83. Line 1: incorrect syntax near '!'. in a macro with asp
  84. calculating totals in a query
  85. ADPs /// idull thoughts
  86. Questions about Reports.
  87. Problem with Queries and Cartesian Product Joins
  88. Highlight the background color of data on conditions
  89. Limited Characters in a Text Box
  90. Reference Menu Captions in VB
  91. Dsum Use In Query
  92. Filling in null fields from previous records
  93. Forms in Access
  94. MS Access to vb.net/ASp.net migration
  95. Entering A Transaction
  96. Pasting records in Access front end using MySQL backend
  97. Access2000 database on the internet
  98. how to improve the speed of reading from access using dao
  99. 'Allow Additions' Causing Unexpected Results
  100. 2 tables 1 with duplicates
  101. Automatically populate foreign key in query?
  102. Simple Access 2000 Query won't work in XP
  103. editing entries in a table using textboxes and a listbox
  104. Need some help fixing my UNION statement
  105. Upgrading to SQL Server
  106. Text File Export
  107. archiving
  108. Download Access templates
  109. a2k - implementing simple popup form to main form
  110. PivotTable and recordset
  111. How to Link MS Access Report in VB
  112. query help
  113. Horizontal Report problem
  114. Databases for translating English-French and English to Spanish
  115. select aus einer Tabelle in ein Textfeld
  116. Seeking freelance programmer for simple project
  117. XP - 97 lockup
  118. How do i set up a query?
  119. Filling null records with previous value--loop?
  120. Acc 97 .Bookmark Property
  121. Access 2000 Calculations
  122. GTRR; If no Related Record, Create New In 2nd Form
  123. Row-level security and MSSQL
  124. GTRR; If no Related Record, Create New In 2nd Form
  125. ACCESS 2000 - bad input
  126. Make Table query on ODBC table changes NULLs to empty strings in Access 2002
  127. Remapping the keyboard up/down arrows for tab stops
  128. Need a Search String Routine
  129. Wierd Query Question
  130. Display automatic update field on a form without being able to edit
  131. ** MS Access support in Unix ? **
  132. Opening Backend DB faster
  133. HELP
  134. Can access tell me if I'm using a table or query?
  135. Call Database in ADO For Table Linking
  136. Powerpoint from Access problem...any ideas?
  137. I need help from VB/VBS experts: exporting Access OLE object (Word document) to a file
  138. Finding near matches
  139. Assign values based on Count(field_name) in query
  140. Server.CreateObject works on IIS 5.x / WinXP Fails on IIS 6.x / Win2K3
  141. The Year() Function and Update Queries
  142. date format problem
  143. A2K db is read-only for the others
  144. Automaticall linkin external Paradox tables - based on the pathnames.
  145. Using AllowSpecialKeys property
  146. Sub report
  147. Null values in a query
  148. Wie kann ich aus einem Formular aus Daten selektieren und in ein Textfeld schreiben?
  149. My FE updater - whadya'all fink?
  150. Subform Form.RecordSource inconsistent?
  151. Basic question on database size - does an empty row take up space?
  152. Beginners help for Mail Merge
  153. Correctly sum a column of currency in a report -- rounding issues???
  154. Cannot Set Bound TextBox Value
  155. Need Assistance with Error Handling
  156. HELP!: "Object doesn't support this property or method"
  157. Access database for rental properties
  158. Hyperlinks don't update with new record using VB code: Access 97
  159. Data loss in Access-97
  160. Hyperlinks don't update with new record using VB code: Access 97
  161. Problem Setting Value
  162. Problems with Setting Value
  163. Items included in one list but not in the other
  164. Online Performance - Snapshot Viewer
  165. need help on simple(?) query
  166. Singling out fields on Continuous Forms
  167. built-in filter functions failing when form recordsource is set to recordset
  168. Menu Bar Has Disappeared - Can't Get It Back
  169. Timestamp - Digital Signatures
  170. Filtering form by combo box
  171. Timestamp - Digital Signatures
  172. Simulate "Circular Queue" structure
  173. Problem on a report..,?
  174. Full Email Address Outlook Access
  175. Access 2K - Read-Only Forms
  176. Trying to combine Two queries into One Query.. Need Help!
  177. Function to determine if form is loaded returns strange value
  178. ADP Test (Multi-Posted)
  179. Menu callback function in Form's code module
  180. Count query - how to use the result in VBA?
  181. 1 x front end & 3 x back ends
  182. Global Variables and Terminal Services
  183. Addition von Zeiten
  184. Licensing and availability of VBIDE
  185. Accessing MS-Access from Solaris and AIX
  186. Filtered by form - differences between totals.
  187. PFS Professional File System 2.0
  188. How to add long items and scroll bars to combobox?
  189. Next / Previous Record Buttons
  190. Changing rowsource when dropdown the combobox
  191. filter adp report where record source uses aggregate functions?
  192. Access 2000 - Field Color Changes
  193. Need to return latest record when there are duplicates
  194. Combobox lookup function gives syntax error
  195. Page Break in Report (Access 97)
  196. Subcategory lookup tables
  197. Please Help With This Access Question
  198. distinct + sum
  199. one to one relation
  200. distict and sum
  201. Limit result set to top 10
  202. Are Access 2002 and 2003 compatable
  203. Access 20003 and 2003 compatability
  204. populating a combobox
  205. Excel automation causes runtime error 1004 on second attempt
  206. NORTHWIND questions
  207. Is access suitable?
  208. HELP...Exporting/Extracting an Access OLE object (Word document) to a Word document file
  209. How Do I Transfer Data From One Table To Another
  210. Combobox Question
  211. Mouse Wheel Subforms (again!)
  212. Ambitious report idea......... "Favorites"
  213. cdo scheduled task runs as user1 but not user2 ?
  214. select aus einer Tabelle in ein Textfeld
  215. Update query help
  216. Searching for connecting access to the web
  217. Resources for intermediate user?
  218. Assigning Default Value
  219. Close Button
  220. Load event of active form fires when Access closes
  221. REQ HELP: Upper Case "C" replaced Lower Case "c" in Table
  222. Query textbox value on a form
  223. Upgrading to newer version
  224. DCount question
  225. using control source on query result
  226. selheight question
  227. Editing object description properties with VBA
  228. Opening a word document or PDF file
  229. what sql string has to be?
  230. Synchronizing Microsoft Access
  231. Same date data for 12 months how?
  232. Two questions about Access 2000
  233. record update to a record in another table..?
  234. Secure Database Systems
  235. Importin a MySQL database into MS Access
  236. Update query doesn't work
  237. Best way of updating a table, based on the results of a query
  238. Error 3197: Deadlock?
  239. simple email from access
  240. Calendar Control question
  241. 1 ZIP code 2 Cities
  242. Report CAN GROW problem with Memo field
  243. Search Multiple Tables at once.........?
  244. (dhl) Exporting Table to Excel
  245. Update query in access - based on data in different table
  246. Access 2000: how to create a query based on a form parameter -- Please HELP!!
  247. Access 2000: How to query the fields in a table
  248. Access Query help!!
  249. Revisions
  250. Talking between forms.
  251. Default Value set the same as last valus for field
  252. Track the User logged in the Shared MS Access Database
  253. Email from Access to Outlook express
  254. Listbox problem
  255. User Level Security - Change of password...
  256. Help - Date Tracking
  257. Search for text in a text field
  258. Updating 2 tables in 1 to Many
  259. can't sort after filtering
  260. filtering form by combo box not really working
  261. 'Password to view project properties' in MSAccess 2000
  262. long strings in vba
  263. how to pass recordset object to procedures/functions?
  264. VBA - MailMerge error 2046
  265. Error 2427 upon opening a form/subform?
  266. The Expression "On Load" you entered....
  267. Please Help Acc97 Database has Got the Better of me
  268. Importing dates like 01JAN2003 from txt file
  269. parameter querie basics
  270. Access References Using UNC
  271. Winzip (wzzip.exe) via access
  272. Unknown function Date()
  273. Printing Properties
  274. how to track object modifications
  275. Access 97 Report crashes under Windows XP but OK on Win2K
  276. "one user account fits all" in a secured database?
  277. How do I group weekly dates, based on a Calender Table?
  278. Forms using linked tables fail
  279. Difficulty with combo box selection TO keep cursor focus
  280. vb.net and stored procedures on SQL Server 2000
  281. Can't edit the results of a query
  282. How could a three dots become a bolded vertical line in a textbox in MS Access 2000?
  283. A2K: Report formatting issue grouping on "Fld<>'Value'"
  284. check for identical input
  285. database servers rent
  286. whitespace string as primary key
  287. Multiple queries in a combo box
  288. query group calculation
  289. Simple Query Help
  290. Insert new data in subform
  291. Runtime Security
  292. Query table by the date
  293. Condittional formatting
  294. If blah blah blah #AND# If Not blah blah blah produce same results. Why?
  295. Help needed w/Runtime, XP, and "Can't be started…" error
  296. a2k - creating salary totals
  297. a2k - creating salary totals
  298. SendObject creating 2 attachments WHY?
  299. Farid writes:
  300. Output Excel File (dhl)
  301. Hyperlink captured in e-mail
  302. scrolling through report
  303. date query
  304. Can't acces the right excel sheet with vba
  305. PASSING KEYS
  306. Creating tables in another table of the same directory
  307. Normalisation Question perhaps?
  308. Date Query Grouping Help!
  309. Sort Table Through VB by multiple columns
  310. Need help with placing value into subform
  311. Code Just Stops
  312. Searching Database
  313. Custom Events / Application properties ?
  314. Validate fields.
  315. report not showing all data?
  316. Case sensative
  317. OT - Sharing Revenue
  318. File List Creator
  319. days between two dates
  320. Runtime security
  321. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  322. Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
  323. MS Access Trial version 2002
  324. Trying to find text within a text string
  325. Custom MsgBox Message
  326. "Opened Exclusively" message on same machine with 2 of 3 Windows users
  327. Dev Ashish acc 97 set page setup margins at runtime VB
  328. An expression question
  329. Is data secure within an MDB/MDE file?
  330. parameter query not working as expected
  331. Multiple Sub queries in a SELECT statement
  332. Difficulty with combo box selection
  333. Append Query/Memo Truncation
  334. Editing question: locating a charter within a string!
  335. Obtaining Table name from error message 3200
  336. how to Locate cell in the datagrid control
  337. Auto Fax when "printing" a Report
  338. Writing to CD from within A2003 VBA
  339. Help - Close Date and Effective Date
  340. a2k - quickest way of checking for a value in an array?
  341. Row handle invalid/referred to a deleted row or row marked for deletion
  342. Subform dissapears when adding a new record to main form
  343. I don't remember carriage and return
  344. Executing multiple sql DDL statements
  345. Highlight the date on the calendar control
  346. Change background/tab colour of tabControl?
  347. Recordset confusion
  348. Appending boiler plate records w/o having a relationship - Pleasehelp
  349. Acc 97 page setup
  350. Problems making new records through the form wizard
  351. Using Crystal Reports in MS-Access & Use of timer event
  352. How to strip out sender address and originating IP address from received eMails
  353. Please help with treeview
  354. Multiple Queries - 1 date range
  355. Problems making or deleting records through a form control button
  356. admin info
  357. Application for "Find a Dealer Near You"
  358. Form scrolls down a bit when opened
  359. Changing table structures in Access
  360. dialog print on report
  361. Larry--Access 97 Question
  362. Possible for Column Height in Row Source
  363. Probably an easy answer - Form and update question
  364. access problem on date conversion please hlp
  365. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  366. Move instead of delete
  367. ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
  368. Simple Expression Too Complex
  369. MS Access 2002 replication problem
  370. combo box (optional add to list )
  371. Data dictionary for Access?
  372. Append query not setting Yes/No flag
  373. Add_in Manager
  374. any springsteen fans - need database will trade
  375. Replication Manager 4.0 - Changing IP Addresses (HELP)
  376. #Deleted In All Fields When Linking SQL Server Table In MS Access
  377. Are select queries with inner joins updatable?
  378. [Field name] returned as data in query results
  379. Search multiple fields (80!) in a query
  380. Can I label queries so the can be copied with VBA? Confused!
  381. corrupt db and MSysObjects
  382. my query doesnt work
  383. Provide a Recordset to a report from VB via COM API?
  384. Coding No Related Records?
  385. Create New Record In Different Form
  386. Question: How to launch a Module of code on startup
  387. Help with modules I think
  388. Uploading to website
  389. Trouble Importing Data
  390. Importing Data to Access.
  391. getting "n" records using RND()
  392. Getting External Data into Access.
  393. Enumerate controls in a runtime environment.
  394. fields containing * ?
  395. I can make databases in Ms Access on order
  396. Wykonam projekt na zlecenie Bazy w Ms Access, programy w Delphi6 lub Builder5
  397. Open subform on Tab Form, with criteria
  398. Show images in a control within Access
  399. Make help in Access database
  400. RS232 data to Access database - general approach
  401. Combo box list question
  402. Access to Excel PasteSpecial Values
  403. Variable Row Source for graph on subreport
  404. Slow Searches in Access
  405. Searching for files and extracting contents
  406. Live Updating Excel - Access Links
  407. Determining which folder is a shared folder
  408. Cascade delete
  409. How to sum up total time logged in by a given member in tblMemberLogins having Login & Logout Date Type fields
  410. Report with null values
  411. Report - Extra blank page problem.
  412. "This recordset is not updatable" - why not?
  413. No access to .dbf files in access 97 after installing access 2003
  414. Query Design View - set default window state
  415. Need Help with counting weekly dates. One more time.
  416. find file, copy and save under new name?
  417. Replace function - odd problem
  418. Date problem with not american format
  419. Question of syntax
  420. Database design question...
  421. NEED FIND BUTTON TO RETURN MSG "NO RECORDS FOUND"
  422. Edit, Delete, Update ... Error :-(
  423. locking records on a form
  424. Concatenation Error in Access 2000 report
  425. Constraint
  426. Old Value - A97
  427. I need to "hack" into an MS Access program - help!
  428. Printing a record on a report depending on a record in another table
  429. Verhindern von ScrollBars in einem Unterformular
  430. Getting an IP address.
  431. burning JOIN question
  432. Help on DAO in ACC2000
  433. Code To Check a Folder For any Files
  434. Record is not locked, although Edited Record locking is set
  435. Connecting To FoxPro
  436. Oracle with Access?
  437. Access window - once minimized, won't maximize
  438. Access window - once minimized, won't maximize
  439. Corrupted form/control
  440. Multi Select Listbox control - SO SIMPLE BUT WHERE IS IT!
  441. Displaying Subform
  442. Delete query help
  443. Item's Indes in multiselect listbox
  444. Was the item selected or deselected?
  445. Crosstab query reports (unknown fields in reports) What about sorting?
  446. Find record causing failure on Insert statement
  447. Multiselect Listbox
  448. Blank Field Problem
  449. Blank Field Help?
  450. Blank Field Help?
  451. Access XP strange behaviour
  452. VBA quick question
  453. convert from 2000 to 97
  454. Access RunTime
  455. Autocreate records and print them
  456. Connecting to Microsoft Index server service from Access
  457. textboxes updating from a listbox
  458. Cascade delete of indirect children records
  459. Repost: Union query truncating field
  460. iif statement dealing with nulls
  461. Want to easily copy selected object between databases
  462. Array error when passing to Sub
  463. Syntax Error in SQL Statement
  464. Tool to identify unused objects?
  465. User Account Locking
  466. Hardware tracking solution
  467. Joining 2 queries for 1 report
  468. 180 day rollover of records
  469. Corruption when "Compact on Close" active
  470. Need SQL help - Select Distinct, Count, Group By
  471. Varchar2 fields limit
  472. Button Pictures
  473. How to capture data change...
  474. TransferSpreadsheet seems to corrupt spreadsheet
  475. Security at Runtime Problem
  476. Re - post..Date/Time
  477. SQL error
  478. Multiple Names In A Mail Merge Field
  479. Setting date condition
  480. Updating and Deleting a number of records at the same time.
  481. Query Records from a specific Date Range
  482. A Totals Query That Doesn't Total
  483. Date Selected query parameter
  484. VBA datatype mismatch error 13
  485. VBA
  486. Printing underlines on subreport data
  487. Best book for my skill level?
  488. ???? Macro security question
  489. Report Setup
  490. Highlighting individual records on a continuous form
  491. LDB files and file names
  492. Best way to let users input picture/drawing to each record?
  493. Form-subform links - am I breaking the rules?
  494. Acc 97 - Set place/numbering in continuous form by code
  495. Table - Import / Link Wizard...
  496. Right Justify in list box
  497. Number of lines in a sub-report
  498. Report Problem
  499. Re-dimensioning string variable that has already been globally dimensioned...
  500. Form and query
  501. ERROR: "Method 'Connection' of object '_Current Project' failed.
  502. ERROR: "Method 'Connection' of object '_Current Project' failed."
  503. Date/Time Conversion woes
  504. Date/Time Conversion woes
  505. Workdate calculation Access 2000
  506. Is there a way to delete every record in a table without selecting all the rows
  507. Form and queries
  508. Access 2003 - importing PDF files as part of a record
  509. Image doesn't work after extracting from MSAccess
  510. How do I avoid "File Sharing Lock Count Exceeded (Error 3052)"
  511. SQL with special characters...
  512. Found Text but Can't Extract from Word Doc
  513. Organizing lead files
  514. Queries on tables from different data sources
  515. fast
  516. VBA editor changes keyboard layout.
  517. Select an item in a combobox
  518. Access 97 - how does it import database objects from other databases?
  519. Copy new db
  520. Suppressing Not In List msg in combo box
  521. passing filter to sub report
  522. Combobox & null
  523. a2k - rounding of figures, comments?
  524. Dates
  525. Help on FE, BE, Linked tables and Bloating Concepts and some advice on how i should construct my database
  526. Access MySql ODBC strategy
  527. security problem
  528. How to rotate text
  529. Access OnNotInList sooo Frustrated
  530. Syntax error in Create Table statement? Why
  531. Access 2003 problem
  532. Delete message - Can is selectively be turned off?
  533. Hide friendly ODBC connection error message
  534. Missing .OCX files after 2003 upgrade
  535. Typing SQL Tables in by hand, in Access
  536. Seeking syntax for pass-through query to delete SOME table records
  537. Updating Hyperlinks
  538. frequent database corruption
  539. memo fields blur in acc '97
  540. How do I set a shortcut key to a save function
  541. Mouse Wheel ON/OFF Subforms - Lebans MouseWheel On/Off
  542. requery listbox as you type
  543. New CDMA Awards 2-DVD Set!
  544. Crosstab ColumnHeaders
  545. Restart Autonumber
  546. Problem with use of calculated form field in query
  547. attaching forms
  548. date, default value
  549. Problem opening a Form
  550. How to make access import special chars correctly?