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