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. Chart Help Needed
  2. Form design for questionnaire
  3. urgent req with our Direct Client
  4. Normalization and AVG across columns
  5. Delete Posts
  6. Please help me with memo fields
  7. Report
  8. queries - null value
  9. Mobile Device and File Dialog Box
  10. Configure Report
  11. Any recommended Excel forums???
  12. A2k - odd form closure problem
  13. chart object drives me nut
  14. Reading Microsoft Access Macros via VBA code
  15. query questions
  16. Opening folder when the folder name has a comma in it.
  17. VBA to Yahoo, MSN or AOL Instant Messaging?
  18. Help using form filters
  19. Cmd to open AddTable Dialog (A2K/SQL Server)
  20. ftp using Internet Transfer Ctrl
  21. Open a new browser window in a Data Access Page
  22. Exporting images (ole object) from access to images folderfolder
  23. Setting a Key to update cascading table
  24. Importing multiple files..
  25. Access Report : Calculated field3 = field1 + field2
  26. Deleted column in a Table linked to 35,000 entries!
  27. event in access
  28. access problem please i need your help
  29. Invalid Command Line Switch: 'I' in Access 2k
  30. modifying relationships using DAO?
  31. Date and Time calendar
  32. Count Items in a report
  33. Select Count(*) question
  34. IIF in Query Design
  35. Run-time error '6' Overflow
  36. Run-time error '6' Overflow
  37. How to retrieve the date of record creation?
  38. Efficient way to store photos
  39. Userform as subform
  40. get MSDASC.DataLinks COM Object used CreateObject function in VB or PB
  41. From text box to field
  42. Who started me?
  43. Access or SQL Server 2005?
  44. Sharing a backend over the internet
  45. Numerically incrementing a string
  46. Converting Access system to Chinese version
  47. Combine multiple records into one
  48. SendObject & A2K SP-3
  49. Access 2003 Error Distributing .mdb
  50. ForceNewPage Property
  51. Any way to remove the AutoIncr / Autonum attribute using DAO?
  52. drop list to fill in the blanks on a form
  53. Displaying multiple field values in 1 query record
  54. What is wrong with my code??
  55. A2K - plausible to change recordsource for reports in MDE?
  56. Developer Don'ts: Nonsense Progess Bars
  57. Not in the list
  58. Decimal Symbol
  59. Auto-Populating a field in Access
  60. Option Group Counts
  61. inventory and pos
  62. urgent req with our Direct Client
  63. using an update query to change multible things...need help
  64. Complex Copy Function
  65. Query with user-defined function doesn't appear to work.
  66. Underlining in Hyperlink not Showing up
  67. Can someone help me?
  68. Access XP Bug - Linked Images - Any Solution??
  69. Continuous Forms Question
  70. Leban's A2000ReporttoPDF Functions: Can you stitch many SNPs into one PDF?
  71. Counting Days in Access
  72. MS Access - "Parameter Incorrect" Message : Stored Procs
  73. Exporting jet table metadata as text?
  74. Unable to link to backends on another computer with A2003
  75. Middle record in a form
  76. Peronnel Area Reporting Database
  77. query/subform question
  78. Adding a New Record to Access form using Visual Basic in Excel
  79. Synchronizing 2 subforms of same table
  80. Formulare miteinander verknüpfen
  81. Building Access Applications "Inventory"
  82. Table with only the last record
  83. access database
  84. textbox: counting & editing
  85. Type Conversion Failure
  86. record navigation icons
  87. Any way to change the OLE type in an OLE field?
  88. Selecting Last 2
  89. How to Maximise MS Access and Bring to Front
  90. Kill Process
  91. Subtracting select queries form each other (each select query has multiple conditions)
  92. Conversion of an MS Access application
  93. How to calculate the difference between values in preceeding records
  94. Simple Report / Query Question
  95. How to have other fields on form autofilled after I choose a value from list box
  96. Getchunk and AppendChunk
  97. Translate CrossTab Querys (Please Help!!)
  98. Combobox slow to drop down
  99. Pass Throughs and Reports - Record Order?
  100. Combobox slow to drop down
  101. Reorganize Databases
  102. Overtime Query
  103. REQ: any utilities for designing front-ends for databases
  104. Overtime Query
  105. Network Files Inaccessible
  106. Check Box clearing
  107. Julian Date Conversion - Can Anyone Help?
  108. Calling queries from MacroVBA - where query has a parametercriteria
  109. Query-by-form; using a criteria on a combo list
  110. searching using text box and query
  111. Cross-joins and non-updateable record sets
  112. Need to Connect to Oracle DB with no ODBC
  113. While using Shell to open a new instance of same database, using vbHide to Hide the new instance fails.
  114. Time over 24 hours
  115. Database corrupt error while posting large transactions
  116. access 97 upgrade question
  117. Recalc or refresh - focus current record in subform lost
  118. List Box gives Null Values
  119. znaczek "+" do ukrycia lub pokazania szczególów rekordu?
  120. Automation operations
  121. Access 2003 ADP
  122. Using Access and MySQL over Internet
  123. Using Access and MySQL over Internet
  124. Hide Controls
  125. After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.
  126. Lebans ListView - More Columns
  127. Design question
  128. Calculating total number of fields in a table
  129. This is simple in excel....not in access....
  130. Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica
  131. Record locking
  132. How to run an updated query in macro
  133. How to run an updated query in macro
  134. How to run an updated query in macro
  135. Set control property using variable for report name?
  136. deleting records
  137. Parameter Query
  138. DateDiff in Query
  139. recordset cashing
  140. Limit to even numbers
  141. Similar Programs - MS ACCESS
  142. Add Filter to Report
  143. Missing Reference because of multiple Outlook Versions
  144. Couldn't update multitable form (3 tables)
  145. Splitting windows like Excel?
  146. DLookup criteria problem
  147. automate button click event within vb using web browser
  148. Hiding the mouse pointer
  149. Create MDE causes Access to crash
  150. How to check if a database is .mde in access 2000
  151. anyone interested in a hotel reservation system
  152. Lost Bookmark
  153. How to handle CD and DVD drived in VBA?
  154. Need help with SQL Select statement using LIKE
  155. Enabling / disabling functions
  156. List of objects at left of screen disappears
  157. Need process for selecting available reports
  158. Store files on SQL Database
  159. How to retrieve the date when a record is created in an Access
  160. access 2003 form to count fields with data
  161. Outlook/A2003 compatability problem
  162. How to do group header?
  163. help with message box
  164. DoCmd.TransferSpreadsheet
  165. Attaching .xls file from a saved location
  166. urgent req with our Direct Client
  167. Control query-datasheet launch position
  168. WebBrowser ActiveX Control
  169. help require for algebra function??
  170. Control query-datasheet launch position
  171. Subform Displays Data from Record #1 (not current customer) - HELP!!
  172. Revert mde to mdb - Possible
  173. INSERT INTO Acess 2K table from Visual FoxPro DBF
  174. DoCmd.GoToRecord , , acNewRec
  175. Form fields lock after update in combo box
  176. MS Access Now() minus preset amount of Minutes
  177. Books on SQL for Access
  178. Many-to-Many with SQL
  179. Filter by Form - not working
  180. Create Form-Subform to Perform Searches
  181. Access 97 takes 50% of my cpu :~)
  182. Convert all folder contents that are xls to csv
  183. total minutes in access 2003
  184. Vertical labels on forms are invisible
  185. Trying to sort transactions by time
  186. Set recordset field contents to string
  187. Automatic historical archiving of data for comparison
  188. limit two combo boxes with unrelated data??
  189. Value Lists
  190. Value Lists
  191. Help needed with SQL Select
  192. Rebuild Form From Scratch?
  193. MSACCESS 2003 CREATE PROC
  194. automatically retrieve value from a range table
  195. Querying for No Records?
  196. How to create a decimal number in Access?
  197. Relational database design
  198. Calling an MS-DOS command
  199. MS Access Reports
  200. How to read Access Data Access Pages with vb .net
  201. Creating a Mailing Sheet using Data - PLEASE HELP
  202. complex insert and vba
  203. I am a beginner
  204. urgent req with our Direct Client
  205. Access 2003 performance on datasheet view of bound form
  206. Run a script to alter a column in a table?
  207. application.printers port problem
  208. Multipy Entries tying to same reference table
  209. C# .NET to MS Access OLEDB - Security error
  210. update query help. error??
  211. Why does detail section scroll behind header?
  212. Access Database Programing Questions
  213. change default printer to network printer
  214. Updating a shadow DB
  215. Adding Tables and Forms to an Application
  216. Will Access 2003 open and run A97 mde files?
  217. sending email crashes with ms acecss
  218. ms-access database cannot be updated
  219. Building a Complex Crosstab
  220. Problems importing Excel into Access
  221. Formatting as Date in a query expression
  222. Form Filters or Rebuild SQL Statement as Recordsource?
  223. SQL Server Express: Anybody Using It?
  224. What's wrong with my code?
  225. ListBox, ListIndex and ListCount. A BUG???
  226. Repeating information on report fields
  227. Subreport not showing - but my frustration is
  228. A97 Runtime - Records can't be read. No permission on MSysModules2.
  229. Custom Collection Class woes
  230. Odd recordset behavior
  231. SourceTableName truncate
  232. Report record source
  233. update query- HELP??
  234. A2k - what the hell is TID?
  235. error messages?
  236. a2k - bizarre subform bug
  237. Directory tree scanning
  238. Row Headings in a Crosstab Query
  239. Subform Wizard and number of primary key fields
  240. Pivot Table Help
  241. How will we use .Net in future versions of Access
  242. Is ADO Dead (3)?
  243. Possible to open list box when clicking on text (beside arrow)?
  244. Auto filled in values from another form after choosing value from list box.
  245. How to be auto jumped to last reord after opening form?
  246. I do not want first caracter capitalized, how?
  247. Is ADO Dead (2)?
  248. Is ADO dead?
  249. Run-time error
  250. How to add restriction that field is empty.
  251. Not getting login prompt
  252. How to change the color of the buttons or the button from the switchboard?
  253. New to Access search field
  254. Multiselect list problem
  255. Lookup table question
  256. pause "on current"
  257. A97: Am having difficulty getting msaccess.exe written to target drive in runtime rollout
  258. how do u send an email using access?
  259. how can I save all database on a CD?
  260. DCount
  261. VBA: Reciprocal functionality ?
  262. Report, Form Argument in a Procedure
  263. Access 2: Can't Perform Join- Combined Fields Too Long
  264. How to set a background color with certain HEX, DEC or RGB value?
  265. Setfocus jumps to next field, but default value is selected in that field.
  266. Want to insert logo with transparant background but get white
  267. How to set the selection-bar- and selected-text-color in a list box?
  268. Select data from other DB
  269. Help with Conditional Formatting
  270. MS Access as front-end for Paradox database?
  271. Connecting MS Access to Unix Jbase system
  272. Connecting MS Access to Unix Jbase system
  273. Access 2000
  274. Changing querydef sql to match form!control parameters
  275. mdb keeps crashing
  276. MS Access Database right for us?
  277. Separate one field into two fields
  278. count a check box field?
  279. A2K3: Problem with displaying week number on report
  280. MS Access Script to import data from external mde database to mdb database
  281. Add and update records in VBA
  282. HHC5013: Error: URL reference in the TOC cannot be resolved:
  283. Birthday in a query?
  284. advanatges and disadvantges of using ms access over vb6?
  285. Database books yay!
  286. byepass hard disk when working in moveable drive
  287. Storing and extracting binary files in Access
  288. Charts
  289. Listbox doesn't update on Requery
  290. How to get Cells(i,j) value in Access?
  291. Help with converting DAO to ADO
  292. How do I NTH select in MSAccess 2003?
  293. A97 Query with BLANK Data
  294. Problems with a shared Access 97 DB
  295. Redundant Lookup
  296. Wrong textbox gets focus.
  297. Automated database entry
  298. splitting string
  299. How do I open a file in VBA from Access?
  300. DateAdd help
  301. DateAdd help
  302. unlocking table to be updated while being used by others
  303. set data field to null
  304. Running Metrics off of tracking DB
  305. Running Metrics off of tracking DB
  306. how to break the bounds of 59 in date/time data type
  307. how do u open a specific ms word file??
  308. Different results in VB6 ADODB & Access 2003 (11.5614.5606).
  309. Send Raw data to a Printer using Win32 API
  310. Error # 3125 - " is not a valid name
  311. Access: Colorizing Query Results in Report
  312. a "different" conditional report field
  313. Update records from one database table to another
  314. Week/quarter format in Charts A97
  315. Error in setting multiple field relationships with vba
  316. How to have two subforms on one main form reference same table??
  317. How to have two subforms on one main form reference same table??
  318. display problem with access
  319. Help! Exporting Access table to Paradox
  320. Subform errors - can you check this...
  321. Subform no-brainer
  322. STDEVP problem?
  323. Protect VB.Net code converted from Access
  324. swapping recordsets on a form
  325. Query Truncates Memo Fields
  326. Determine if file is on local PC
  327. Help in proving that Access is an industrial strength front-end
  328. Email Query Results
  329. 3 Identical Reports (almost)
  330. Refreshing and linking SQL Tables to Access front end
  331. How much to convert to SQL server
  332. Filename or path difficulty in a macro
  333. MS Access Switchboard With Dynamic Labels
  334. urgent req with our Direct Client
  335. Corrupt Table Problem
  336. Why cant i get the header images on every page
  337. Access 2000 Data Entry Form goes invisible
  338. JRO and Access - what program.suite is needed?
  339. Record Count
  340. query for two values
  341. Shell the same database ignores the 'vbHide' argument
  342. FYI - Issue with TransferText in Access - VBA
  343. Seeking code to ID & print all controls having a ValidationRule property set - but no ValidationText
  344. fOSUserName for Multiple UserNames
  345. report sort query
  346. Decompiling an A97 mdb file...
  347. code to open list box from param query
  348. Confirm record updates dialog
  349. Grouping in Access Report
  350. Help required passing variables from a top level macro to queries.
  351. Option Group Filtering - problem
  352. stop next record, if field not complete
  353. Syntax form moving from page-to-page (actually, Tab-toTab) in Tab Control on form?
  354. Set Security on using VBA in saved Access Query
  355. hours, minutes, and am/pm to a TIME variable
  356. bringing up the right record
  357. IS NULL/IS NOT NULL
  358. Exit many procedure with one command
  359. filter by form/selection MISMATCH in Criteria Expression
  360. FIX for: Compact + mda or mde reference = CRASH
  361. Open and eidt macro in code
  362. Access 97 form sizes
  363. bound ole ctrl only displaying path
  364. adp and exec stored procedure
  365. Uncheck Read-Only attribute
  366. Creating Directories
  367. Determining Macros Security Level Using Code
  368. Unicode Compression not working under DAO.
  369. Importing Access database into Sql Server Express
  370. Code to check if form is open
  371. Allowing R/O users access
  372. A2K - update to field problem
  373. How to pass a filtered recordset of a form to a chart?
  374. Spread time accross day
  375. Variables in Shell Command
  376. How to copy the button characteristics
  377. Question about Yes/No selection buttons - can they be reset to "no choice"?
  378. I Need A Help With Auto Generating String (Access 2003)
  379. Event Trigger on Save
  380. ordinal position of fields in ado recordsets
  381. Changing Integer to Double
  382. Open word files using combo
  383. Pivot Chart
  384. Existence of Field Name in Record Set
  385. basic DB structure help
  386. counting records in open form after filter, trapping for empty recordsets
  387. Assigning sequential numbers
  388. Can i suppress Acess message ?
  389. Converting from Access 2000 to Access 2003, execute for a sql insert, update not working
  390. A97: Setting form's Picture property to another file from within VBA doesn't repaint the form with new bitmap
  391. Water Trending Database
  392. digital signature
  393. Access XP / SQL Server 2005 Express?
  394. Add a column to table based on formula & criteria
  395. Copy and Linking Access Front End to SQL Back End
  396. A97: Simplest way to limit unbound textbox to 200-chars entered MAX
  397. Error Missing system.tlb
  398. urgent req with our Direct Client
  399. change font size for data labels
  400. Horizontal Report
  401. Random error Message box
  402. Does associative array exist in VBA?
  403. Oracle 10g ODBC
  404. help with a simple query
  405. Is it necessary to use PLUSes in an msXML call instead of spaces?
  406. Does custom form property get reset?
  407. Selection Problem
  408. open recordset gives type mismatch
  409. Opening a PopUp Near the Button that called it
  410. Making control visible in one record only
  411. Update query on definite record(row) of table.
  412. Calendar Control 10.0 Missing Events
  413. option button help
  414. Where are A97 command button pictures stored?
  415. MS Access and Sharepoint: saving the username and password in a linked table
  416. database in state that prevents it being opened or locked
  417. Different colored words in a single label control?
  418. Referencing subform during module code
  419. Assigning numbers in batches
  420. update a lbl depending on whether check box is ticked or not
  421. help with updating checkbox
  422. Export data
  423. Write conflict
  424. Triple state checkboxes CAN be used with themed controls
  425. MS Access 2003
  426. Accessing my db remotely
  427. Using GetOleDbSchemaTable and Visual Basic .NET for MS-Access and SQL Server Express
  428. How to modify qryOwnerList to not show John Doe record?
  429. Advice on Courses
  430. Nedd help finding right course
  431. Query
  432. Update multiple tables from one form
  433. Addinf firelds to tables remotely
  434. Add rows in access subform
  435. Access to SQL
  436. City/County table
  437. Separating text by carriage return
  438. Memory Hogging by SQL-Access Database
  439. database server interfaces examples
  440. Enumerate objects in ADP
  441. database server interface
  442. Failure of OpenDatabase Method
  443. database server interface
  444. printing report in vertical using courier new font
  445. syntax error (missing operator) in query expression
  446. Flashing Forms on load
  447. help! how can i notify the user a films is out on rent?
  448. RWOP queries for back-end secuirty: easy/hard? slow/fast?
  449. In an object, like combo box, what is difference between "control source" and "Row Source"
  450. "ORDER BY" negtive decimal values bug hasn't been fixed
  451. open recordset
  452. open recordset
  453. A report with prompts, but without a query...Possible? Clarification Please.
  454. Error occurring in error handler
  455. database server interface
  456. database server interface
  457. Transactions in Access 2000
  458. Escape codes for delim characters in listbox value list?
  459. VB.Net code to upsize Access DB to SQL Express?
  460. Gantt Chart in MS Access
  461. After edit form, return to same place on first form...
  462. Horizontal Report
  463. Difference between client server and shared access
  464. openargs and security
  465. Working with linked tables
  466. Allowing certain users to administer users via code, and other security questions
  467. Updating checkboxes with the jitters!
  468. 1 to many relationship between columns
  469. Global Search over Multiple Databases
  470. Find/Replace error
  471. urgent req with our Direct Client
  472. Call call
  473. Contents of Form Fields not Displaying
  474. Ole Objects
  475. Keyword Search
  476. How do I find the remote DB's that link to my tables?
  477. Change Record Source on switching View to Datasheet
  478. Need HELP - Form Moving Around
  479. export report fromm access 2000
  480. Creating dynamic field queries....
  481. Advice: Export to excel causes access to hang.
  482. User queries and security
  483. Data Access Pages
  484. Is it possible to examine a system from within a VBA procedure to read and document system settings?
  485. Me.AddMode
  486. Selecting only one active record from multiple records
  487. Spot the Error
  488. Query - Mid Function & Mail Merge
  489. Calculating Opening Balance in a Report !
  490. Figuring out the right query
  491. Pasting table data to web page
  492. Cannot Save Imported Access XP Report with Linked Image
  493. Query Question - Combine records with same policy number
  494. Query Question - Combine records with same policy number
  495. Query Question - Combine records with same policy number
  496. VBA collections question
  497. ByVal call
  498. Seeking way to shorten this little code snippet...
  499. urgent req with our Direct Client
  500. Date Time picker revisited...
  501. Code to delete all queries not working right
  502. Dynamic Fields Report (Access 2000)
  503. Cant assign a value to this object ... when trying to clear a checkbox
  504. Dismissal and Google Archives (OT)
  505. Microsoft Access 97 Runtime
  506. Database connectivity with MS Access in Microsoft Visual Studio .NET
  507. A2K - MDE hell
  508. Relationships Report: how to print additional info about the fields
  509. How to protect
  510. Run Time Error
  511. Difference between Access and Access Project
  512. Help With Sub-Forms
  513. Calling a function
  514. A2K - help with array search
  515. obtain read permission by VBA
  516. Append query from Oracle Back-End
  517. Append query from Oracle Back-End
  518. MS Access iterators?
  519. Compact and repair back end?
  520. Access 2002 vs. 2003
  521. Office Developer Edition questions.
  522. Combo Box look up problem
  523. can't filter report in Access2000
  524. Report Trouble
  525. Proposal to change the name of CDMA
  526. Closing a form automatically if no records
  527. Button / Macro's does not work on other PC
  528. Search Function
  529. Great Job Board
  530. how to programmatical read the current sql statement if cuurent query ins't saved?
  531. ' More controls' empty
  532. Access 12 Blog's Latest Post
  533. Returning information on form used as a dialog
  534. How to restrict the number of records added to a table by a subform??
  535. Run-time error 3231
  536. clearing form after insert
  537. Databound list box populated with parameterized query?
  538. Runtime
  539. Access 2003 mail merge using DDE
  540. Global Variables
  541. Search Form Access
  542. Transaction Table
  543. DateSerial ()
  544. How do I stop the enter key from going to next record?
  545. What's "required" to get work in Access these days?
  546. Adding a field to a Form
  547. Is it possible to get the AD user group to which an Access user belongs??
  548. Return whole word for filtering
  549. ODBC not connection to database
  550. Help !! Form Moves to Unexpected Position