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. Report record source
  2. update query- HELP??
  3. A2k - what the hell is TID?
  4. error messages?
  5. a2k - bizarre subform bug
  6. Directory tree scanning
  7. Row Headings in a Crosstab Query
  8. Subform Wizard and number of primary key fields
  9. Pivot Table Help
  10. How will we use .Net in future versions of Access
  11. Is ADO Dead (3)?
  12. Possible to open list box when clicking on text (beside arrow)?
  13. Auto filled in values from another form after choosing value from list box.
  14. How to be auto jumped to last reord after opening form?
  15. I do not want first caracter capitalized, how?
  16. Is ADO Dead (2)?
  17. Is ADO dead?
  18. Run-time error
  19. How to add restriction that field is empty.
  20. Not getting login prompt
  21. How to change the color of the buttons or the button from the switchboard?
  22. New to Access search field
  23. Multiselect list problem
  24. Lookup table question
  25. pause "on current"
  26. A97: Am having difficulty getting msaccess.exe written to target drive in runtime rollout
  27. how do u send an email using access?
  28. how can I save all database on a CD?
  29. DCount
  30. VBA: Reciprocal functionality ?
  31. Report, Form Argument in a Procedure
  32. Access 2: Can't Perform Join- Combined Fields Too Long
  33. How to set a background color with certain HEX, DEC or RGB value?
  34. Setfocus jumps to next field, but default value is selected in that field.
  35. Want to insert logo with transparant background but get white
  36. How to set the selection-bar- and selected-text-color in a list box?
  37. Select data from other DB
  38. Help with Conditional Formatting
  39. MS Access as front-end for Paradox database?
  40. Connecting MS Access to Unix Jbase system
  41. Connecting MS Access to Unix Jbase system
  42. Access 2000
  43. Changing querydef sql to match form!control parameters
  44. mdb keeps crashing
  45. MS Access Database right for us?
  46. Separate one field into two fields
  47. count a check box field?
  48. A2K3: Problem with displaying week number on report
  49. MS Access Script to import data from external mde database to mdb database
  50. Add and update records in VBA
  51. HHC5013: Error: URL reference in the TOC cannot be resolved:
  52. Birthday in a query?
  53. advanatges and disadvantges of using ms access over vb6?
  54. Database books yay!
  55. byepass hard disk when working in moveable drive
  56. Storing and extracting binary files in Access
  57. Charts
  58. Listbox doesn't update on Requery
  59. How to get Cells(i,j) value in Access?
  60. Help with converting DAO to ADO
  61. How do I NTH select in MSAccess 2003?
  62. A97 Query with BLANK Data
  63. Problems with a shared Access 97 DB
  64. Redundant Lookup
  65. Wrong textbox gets focus.
  66. Automated database entry
  67. splitting string
  68. How do I open a file in VBA from Access?
  69. DateAdd help
  70. DateAdd help
  71. unlocking table to be updated while being used by others
  72. set data field to null
  73. Running Metrics off of tracking DB
  74. Running Metrics off of tracking DB
  75. how to break the bounds of 59 in date/time data type
  76. how do u open a specific ms word file??
  77. Different results in VB6 ADODB & Access 2003 (11.5614.5606).
  78. Send Raw data to a Printer using Win32 API
  79. Error # 3125 - " is not a valid name
  80. Access: Colorizing Query Results in Report
  81. a "different" conditional report field
  82. Update records from one database table to another
  83. Week/quarter format in Charts A97
  84. Error in setting multiple field relationships with vba
  85. How to have two subforms on one main form reference same table??
  86. How to have two subforms on one main form reference same table??
  87. display problem with access
  88. Help! Exporting Access table to Paradox
  89. Subform errors - can you check this...
  90. Subform no-brainer
  91. STDEVP problem?
  92. Protect VB.Net code converted from Access
  93. swapping recordsets on a form
  94. Query Truncates Memo Fields
  95. Determine if file is on local PC
  96. Help in proving that Access is an industrial strength front-end
  97. Email Query Results
  98. 3 Identical Reports (almost)
  99. Refreshing and linking SQL Tables to Access front end
  100. How much to convert to SQL server
  101. Filename or path difficulty in a macro
  102. MS Access Switchboard With Dynamic Labels
  103. urgent req with our Direct Client
  104. Corrupt Table Problem
  105. Why cant i get the header images on every page
  106. Access 2000 Data Entry Form goes invisible
  107. JRO and Access - what program.suite is needed?
  108. Record Count
  109. query for two values
  110. Shell the same database ignores the 'vbHide' argument
  111. FYI - Issue with TransferText in Access - VBA
  112. Seeking code to ID & print all controls having a ValidationRule property set - but no ValidationText
  113. fOSUserName for Multiple UserNames
  114. report sort query
  115. Decompiling an A97 mdb file...
  116. code to open list box from param query
  117. Confirm record updates dialog
  118. Grouping in Access Report
  119. Help required passing variables from a top level macro to queries.
  120. Option Group Filtering - problem
  121. stop next record, if field not complete
  122. Syntax form moving from page-to-page (actually, Tab-toTab) in Tab Control on form?
  123. Set Security on using VBA in saved Access Query
  124. hours, minutes, and am/pm to a TIME variable
  125. bringing up the right record
  126. IS NULL/IS NOT NULL
  127. Exit many procedure with one command
  128. filter by form/selection MISMATCH in Criteria Expression
  129. FIX for: Compact + mda or mde reference = CRASH
  130. Open and eidt macro in code
  131. Access 97 form sizes
  132. bound ole ctrl only displaying path
  133. adp and exec stored procedure
  134. Uncheck Read-Only attribute
  135. Creating Directories
  136. Determining Macros Security Level Using Code
  137. Unicode Compression not working under DAO.
  138. Importing Access database into Sql Server Express
  139. Code to check if form is open
  140. Allowing R/O users access
  141. A2K - update to field problem
  142. How to pass a filtered recordset of a form to a chart?
  143. Spread time accross day
  144. Variables in Shell Command
  145. How to copy the button characteristics
  146. Question about Yes/No selection buttons - can they be reset to "no choice"?
  147. I Need A Help With Auto Generating String (Access 2003)
  148. Event Trigger on Save
  149. ordinal position of fields in ado recordsets
  150. Changing Integer to Double
  151. Open word files using combo
  152. Pivot Chart
  153. Existence of Field Name in Record Set
  154. basic DB structure help
  155. counting records in open form after filter, trapping for empty recordsets
  156. Assigning sequential numbers
  157. Can i suppress Acess message ?
  158. Converting from Access 2000 to Access 2003, execute for a sql insert, update not working
  159. A97: Setting form's Picture property to another file from within VBA doesn't repaint the form with new bitmap
  160. Water Trending Database
  161. digital signature
  162. Access XP / SQL Server 2005 Express?
  163. Add a column to table based on formula & criteria
  164. Copy and Linking Access Front End to SQL Back End
  165. A97: Simplest way to limit unbound textbox to 200-chars entered MAX
  166. Error Missing system.tlb
  167. urgent req with our Direct Client
  168. change font size for data labels
  169. Horizontal Report
  170. Random error Message box
  171. Does associative array exist in VBA?
  172. Oracle 10g ODBC
  173. help with a simple query
  174. Is it necessary to use PLUSes in an msXML call instead of spaces?
  175. Does custom form property get reset?
  176. Selection Problem
  177. open recordset gives type mismatch
  178. Opening a PopUp Near the Button that called it
  179. Making control visible in one record only
  180. Update query on definite record(row) of table.
  181. Calendar Control 10.0 Missing Events
  182. option button help
  183. Where are A97 command button pictures stored?
  184. MS Access and Sharepoint: saving the username and password in a linked table
  185. database in state that prevents it being opened or locked
  186. Different colored words in a single label control?
  187. Referencing subform during module code
  188. Assigning numbers in batches
  189. update a lbl depending on whether check box is ticked or not
  190. help with updating checkbox
  191. Export data
  192. Write conflict
  193. Triple state checkboxes CAN be used with themed controls
  194. MS Access 2003
  195. Accessing my db remotely
  196. Using GetOleDbSchemaTable and Visual Basic .NET for MS-Access and SQL Server Express
  197. How to modify qryOwnerList to not show John Doe record?
  198. Advice on Courses
  199. Nedd help finding right course
  200. Query
  201. Update multiple tables from one form
  202. Addinf firelds to tables remotely
  203. Add rows in access subform
  204. Access to SQL
  205. City/County table
  206. Separating text by carriage return
  207. Memory Hogging by SQL-Access Database
  208. database server interfaces examples
  209. Enumerate objects in ADP
  210. database server interface
  211. Failure of OpenDatabase Method
  212. database server interface
  213. printing report in vertical using courier new font
  214. syntax error (missing operator) in query expression
  215. Flashing Forms on load
  216. help! how can i notify the user a films is out on rent?
  217. RWOP queries for back-end secuirty: easy/hard? slow/fast?
  218. In an object, like combo box, what is difference between "control source" and "Row Source"
  219. "ORDER BY" negtive decimal values bug hasn't been fixed
  220. open recordset
  221. open recordset
  222. A report with prompts, but without a query...Possible? Clarification Please.
  223. Error occurring in error handler
  224. database server interface
  225. database server interface
  226. Transactions in Access 2000
  227. Escape codes for delim characters in listbox value list?
  228. VB.Net code to upsize Access DB to SQL Express?
  229. Gantt Chart in MS Access
  230. After edit form, return to same place on first form...
  231. Horizontal Report
  232. Difference between client server and shared access
  233. openargs and security
  234. Working with linked tables
  235. Allowing certain users to administer users via code, and other security questions
  236. Updating checkboxes with the jitters!
  237. 1 to many relationship between columns
  238. Global Search over Multiple Databases
  239. Find/Replace error
  240. urgent req with our Direct Client
  241. Call call
  242. Contents of Form Fields not Displaying
  243. Ole Objects
  244. Keyword Search
  245. How do I find the remote DB's that link to my tables?
  246. Change Record Source on switching View to Datasheet
  247. Need HELP - Form Moving Around
  248. export report fromm access 2000
  249. Creating dynamic field queries....
  250. Advice: Export to excel causes access to hang.
  251. User queries and security
  252. Data Access Pages
  253. Is it possible to examine a system from within a VBA procedure to read and document system settings?
  254. Me.AddMode
  255. Selecting only one active record from multiple records
  256. Spot the Error
  257. Query - Mid Function & Mail Merge
  258. Calculating Opening Balance in a Report !
  259. Figuring out the right query
  260. Pasting table data to web page
  261. Cannot Save Imported Access XP Report with Linked Image
  262. Query Question - Combine records with same policy number
  263. Query Question - Combine records with same policy number
  264. Query Question - Combine records with same policy number
  265. VBA collections question
  266. ByVal call
  267. Seeking way to shorten this little code snippet...
  268. urgent req with our Direct Client
  269. Date Time picker revisited...
  270. Code to delete all queries not working right
  271. Dynamic Fields Report (Access 2000)
  272. Cant assign a value to this object ... when trying to clear a checkbox
  273. Dismissal and Google Archives (OT)
  274. Microsoft Access 97 Runtime
  275. Database connectivity with MS Access in Microsoft Visual Studio .NET
  276. A2K - MDE hell
  277. Relationships Report: how to print additional info about the fields
  278. How to protect
  279. Run Time Error
  280. Difference between Access and Access Project
  281. Help With Sub-Forms
  282. Calling a function
  283. A2K - help with array search
  284. obtain read permission by VBA
  285. Append query from Oracle Back-End
  286. Append query from Oracle Back-End
  287. MS Access iterators?
  288. Compact and repair back end?
  289. Access 2002 vs. 2003
  290. Office Developer Edition questions.
  291. Combo Box look up problem
  292. can't filter report in Access2000
  293. Report Trouble
  294. Proposal to change the name of CDMA
  295. Closing a form automatically if no records
  296. Button / Macro's does not work on other PC
  297. Search Function
  298. Great Job Board
  299. how to programmatical read the current sql statement if cuurent query ins't saved?
  300. ' More controls' empty
  301. Access 12 Blog's Latest Post
  302. Returning information on form used as a dialog
  303. How to restrict the number of records added to a table by a subform??
  304. Run-time error 3231
  305. clearing form after insert
  306. Databound list box populated with parameterized query?
  307. Runtime
  308. Access 2003 mail merge using DDE
  309. Global Variables
  310. Search Form Access
  311. Transaction Table
  312. DateSerial ()
  313. How do I stop the enter key from going to next record?
  314. What's "required" to get work in Access these days?
  315. Adding a field to a Form
  316. Is it possible to get the AD user group to which an Access user belongs??
  317. Return whole word for filtering
  318. ODBC not connection to database
  319. Help !! Form Moves to Unexpected Position
  320. Converting excel to Access
  321. You do not have exclusive access
  322. connection string sql server 2000
  323. How best to modify value entered into textbox on form during BeforeUpdate event code?
  324. Excel Output written from Access Form
  325. Is there a way to randomize or loop through a set of wav sounds--for fun?
  326. Microsoft Access has encountered a problem...
  327. PDF Printing
  328. Page numbering as function of grouping in a report
  329. Top Values for Each Student
  330. Sheduled tasks
  331. Forcing Wait or Delay ?
  332. Has anyone seen this before?
  333. Dynamic Query via User-Specified Fields
  334. Better way to lock VBA Project?
  335. Invoice Payment Query
  336. Access 2003: Problem running update queries on linked-in Excel Spreadsheets
  337. How could bytes be converted into ASCII in a secret code form for students?
  338. Change Indexed Property in table makes change the query behaviour:why?
  339. Could you please do this?
  340. Calculated Summary Field
  341. Access Blog does a Lazarus
  342. Comparing Multiple Dates to another table
  343. Replacement for Access 97
  344. Select from multiple queries/tables?
  345. Run time error 3231
  346. Creating monthly records from effective date records
  347. easy question on forms/tables
  348. Run a batch file from Microsoft Access
  349. Run a batch file from Microsoft Access
  350. .tab import quiting early
  351. Access and Outlook Automation
  352. User "lost" min max close buttons
  353. lock fields in DB with the content of other fields
  354. Documentation of Database in Word
  355. Different results in VB6 ADODB & Access 2003 (11.5614.5606).
  356. Proposal of Revision of CDMA newsgroup FAQ by Mike Noel
  357. Query into VBA
  358. Get the first in the row
  359. Using ADO to import Excel into Access Read Only - while file is open
  360. Need help with next step of creating Import Form
  361. Syntax error in insert
  362. Urgent req with our Direct Client
  363. Combine 2 tables into 1 virtual recordset
  364. DAP - What datapage?
  365. VB6 code to Lock access table
  366. QBE function for filling 11 digits
  367. msoControlEdit bug !!
  368. data access page
  369. ADO: importing Excel data while it is already open by another user...
  370. Lost and Found Database
  371. Anybody ever create a library catalog in Access?
  372. Allowing users to view only their own data
  373. moving to run time Acc 03
  374. Packaging an excel workbook and assess database to gether
  375. how do i get access to automatically fill in fields?
  376. Totals Report
  377. Error 2501 No-brainer
  378. Foreign Key not updating
  379. Tiered database help
  380. Login Form
  381. DoCmd
  382. How do I create a button that prints 2 copies of a form?
  383. Urgent req with our Direct Client
  384. How do I fix a corrupt database
  385. Help in report
  386. How do I pull only one occurence w/query?
  387. Is there some way to shut down Access automatically?
  388. MS Access Form w tabs
  389. maths on a form
  390. odd window alignment
  391. Network Login ID for "Created By"
  392. Endlosformular
  393. Primary Key
  394. Debugging Access 2002 vs 97
  395. Help! Access 2003 Runtime install problems!
  396. Links neben Daten einen Text / Grafik anzeigen im bericht
  397. changing a control property according to record values
  398. Visible Command Button
  399. A2K3: Can not see dialog boxes. Form hides them
  400. Total problem in subform
  401. Access 2003 Runtime install hangs on Installing fonts
  402. Macro error "Cannot update. Database or object is read-only."
  403. Date Serial Issue
  404. TextStream Object Write to File Fails When Field Text Contains Returns
  405. Day number to day name
  406. Forum Announcement
  407. Using "In"
  408. query question
  409. MS Access 2003 - automatically create reports/subreports based on criteria
  410. programmatically reading .pdf file attributes?
  411. Urgent req with our Direct Client
  412. Can't open db tables
  413. Unable to Edit Records in Linked Table (ISAM, MSA 2000)
  414. Count day of the week
  415. updating or replacing multiple values in one field
  416. Replicating and Synchronizing
  417. Someone must be able to help me with my ASP problem
  418. naming conventions
  419. UNION query not working
  420. Access Combo (Droplist) Not autocompleting
  421. Persistence
  422. Duplicates
  423. Passing parameters to queries using VBA
  424. Counting years and months between dates
  425. Call procedure with parametrs
  426. Hiding Data
  427. multi column foreign key and null values
  428. Help with listbox and append VBA
  429. Need Help with nasty query
  430. creating a date value from month, day, and year fields
  431. Values carried over from one record to the next
  432. Urgent req with our Direct Client
  433. Need help with output
  434. Conditional test to combine multiple records
  435. Edit a Query
  436. Creating an MSI file for an Access program
  437. Complicate report: how to sort out single records?
  438. String pattern matching with the VBA Replace function?
  439. select from a table the highest revision number
  440. Indexs and seek need help
  441. Lookup field in datasheet view
  442. Lookup field on datasheet view
  443. Lookup field on datashhe view
  444. set the caption of a field using vba
  445. Extracting date from dat/time field : help required
  446. A problem occured while Microsoft Access was communicating with the Ole server or ActiveX Control
  447. Repost - InetTransferLib ftp problem
  448. Print report multiple times based on value in the report
  449. drop-down feeding two fields
  450. Running sum problem
  451. Cant get into db
  452. Is There A Way to Pop Up a MessageBox Warning When User Changes Data?
  453. Cant get into db
  454. Pass Parameter to query via Report
  455. Simple join problem (I think!)
  456. Lock form on a record
  457. problems with a query or quaries
  458. mdb -> xls
  459. Problems creating an Auditing facility
  460. Lost menu bar in MS Access 2000
  461. custom button for next "non recurring record"
  462. Lost table design defaults
  463. A2K - how do I automate clicking of a checkbox?
  464. MS Access 2000 - Record data shifting to the right
  465. Creating a report with 3 tables in it
  466. how to know the table Exist in the db using dao?
  467. How call procedure?
  468. how to know the table Exist in the db using dao?
  469. Check on fields without a value (value Is Null)
  470. Hyperlink walkthrough
  471. Multi user design gaffe
  472. How to ensure accurate mileage expense calculations??
  473. Continuous Form !
  474. Problem with On Error Go to in Event Procedure
  475. Aligning number values
  476. Access 2002 Runtime Fails to End
  477. Choosing the correct event
  478. Report errors from a form to select names and dates with...
  479. How to prevent Spell Checker from cycling records?
  480. Expanding control size in a report
  481. Why do people do this?
  482. In some runtime installs of A97 databases want to bury a text file for future reference
  483. Function returning array of strings
  484. acOutputTable - cannot save output data
  485. Splitting string
  486. Append records into another database
  487. Padding string
  488. exporting data with commas separating the data
  489. Cascading Combo Boxes on Subform within Tab Control - Help!
  490. Syntax error (missing operator) in query expression
  491. ER diagram for...
  492. auto populate sub datasheet
  493. evaluating calculated controls
  494. Help with SQL query
  495. How to get value of Toggle/Check/Combo controls?
  496. Access 2003 & SQL Server 2005
  497. report print out is different from preview mode - please help.
  498. Can one open a xls sheet as a subform?
  499. query on memo field
  500. Access Development Freelance
  501. Enter Key behaviour - Access 2003
  502. Import XSD file to Access 2003
  503. Suggestions for creating new SQL Server backend from code
  504. too many fields.
  505. What is syntax for displaying a specific tab of a tab control upon an "on open" event of a form?
  506. Insert into validation rule violation
  507. Need help again!! Crazy Boss is at it again.
  508. Nedd help again!! Crazy Boss is at it again.
  509. How do I set up a report print routine?
  510. ADODB.Connection - from ACCESS to Oracle
  511. ReCONNECT VB code to Access DB
  512. Format dd-mm-yy not working (A2k)
  513. Me.recordsource in MS Access 2003
  514. empty table
  515. refresh not working
  516. Sum query: Data type mismatch in criteria expression
  517. sum query: Data type mismatch in criteria expression
  518. InetTransferLib ftp problem on some computers, not others
  519. How to output a text file with a page break
  520. Setting the form dataentry property via vb?
  521. Method Not Found, Access 97/2000 Conversion
  522. access to Access
  523. Query based Report in Access using VBA
  524. confused with events
  525. Arithmetic problem refresher help
  526. Visual Basic Issue
  527. Report Prints Too Small
  528. donor database for NGO
  529. Have on option group but need one of the option buttons when clicked to allow editing to a certain field
  530. AccessXP and Outlook question
  531. my DAO-made tables are invisible, not just hidden
  532. invoicing routine problem
  533. Strange notation from database
  534. access 97 - not enough memory to update display...
  535. MS Access Data Changes Not Committing Before Next Read?
  536. Print Word doc. from Access
  537. Access -> SQL Server
  538. Saving Spreadsheet to Unicode extra quotation marks
  539. strings
  540. strings
  541. Where to find info/samle code to draw graph in Access Form using MS Graph
  542. Convert Access dates to Oracle format
  543. import data MySql with Access from Excel file
  544. Handy routine for building an IN clause from multi-select listbox
  545. Pushing data from Access to existing Excel workbook using ADO
  546. open and print files with vba?
  547. Reading a SQL Server text field using a connection.OpenRecordSet
  548. Code examples
  549. Temp database wouldn't open from jump drive
  550. select cast syntax