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. CallByName to Module rather than to Form
  2. How can I modify fields types via VBA code?
  3. Access Report Problem
  4. Date Fields
  5. Novell login ad Access
  6. Login di Novell in Access
  7. Insert Random Number
  8. Access Banking Solution
  9. Query help needed
  10. Access performance on the Web vs TS
  11. Help comparing strings
  12. Newsgroup Etiquette: Responses
  13. Copy Data from Subform in A97
  14. Driver's License Mag stripe data
  15. Report Question
  16. Blank Pages in Printing Reports (Page Height Mismatch?)
  17. Capitalize first letter of each word
  18. Query Set Up
  19. TimeSheet in MS Access
  20. Expressions calculation Help Please!
  21. forms/subforms with DAO ?
  22. Problems with editing the VBA code - auto syntax check??
  23. Linking Allen Browne's code to Northwind
  24. Problem inserting object into Bound Object Frame
  25. Can't open query on updated recordset without exiting/re-entering macro
  26. Using GoTo or Resume
  27. Package my Access 97 application with your Sagekey software
  28. VB calling a form/subform by name rather then me.formname
  29. Importing existing data
  30. How do I know if a recordset has been filled?
  31. Another query problem - what function?
  32. accessing C drive
  33. Current record for a recordset not bound to a form
  34. Generate unique barcode to unique ID
  35. beginner with autonumber problem
  36. MS Access Banking Solution
  37. Embedding Picture problem
  38. Splash Screen
  39. Problems with displaying data from two tables on one form
  40. lists and combo box in a form
  41. Trouble changing value in an appended field in ADO recordset
  42. query problem
  43. Trouble changing value in an appended field in ADO recordset
  44. Solution: field-level permissions in Access
  45. String function
  46. Suppressing Access' table error messages
  47. Missing Toolbar menus
  48. Reference Library for just 1 user
  49. Subform Requery Issues - Error 2467
  50. How do I hide columns on tab control subform?
  51. Outlook automation formatting text
  52. Function Module looping problem
  53. Seeking advice on replication
  54. Open form from another database
  55. 2003 Database can be opened with default system.mdw
  56. Overflow Error
  57. MS-Chart in access
  58. import txt file
  59. probably a old chestnut-tips of Photo database design please
  60. control source based on wheter item iexists in other table
  61. Password For Table
  62. Help on report footer calculated field
  63. Huge problem with Access 2003
  64. Clarify "Enforce Relationship"
  65. Vertical lines in report (code check needed)
  66. Disapearing tables in query design mode.
  67. web forms w/ access
  68. lose autonumber property when i link mysql & msaccess
  69. Navigating a Tab Control
  70. Check for Query Results with no Records
  71. query parameter from open form field.....
  72. Special MDB or normal MDE ??
  73. text file as data source for query
  74. Emailing and creating PDF's in Access 2000+
  75. validation, before_update and after_update
  76. Change data from verticle to horizonal
  77. Same events for similar controls
  78. How to display a 0 for a empty record?
  79. Copy data from one form to another and create a new record to add data
  80. Reference Libraries for some not all
  81. Access Merge to Word Document
  82. Programatically fill a combobox
  83. Create simple Stored Procedures?
  84. Filesearch problem
  85. report?
  86. Looking for Tables in a Database
  87. ASP: Retrieve autonumber field on INSERT
  88. link record to form
  89. Error Message in Report b/c of Null or No Values
  90. Reply
  91. Mde file creation problem
  92. List box Requery is one record behind all the time
  93. Adding a "Compile and Save" Button To A Form
  94. AOIndex is not an index in this table
  95. Locking...
  96. OLE problems
  97. Control print from VBA (Access 97)
  98. Crosstab is missing data from underlying table
  99. Tree View File Browser
  100. Probably an easy one...
  101. Remove tool bars
  102. Appending a .rtf to Word
  103. INSERT INTO appears to be asynchronous?
  104. Encode/Decode Database
  105. AutoForm Code?
  106. Records disappear from table
  107. Need Advice on Table Structure for Part Kits
  108. Access Date Function Query
  109. HELP----DOES ANYONE HAVE A SIMPLE .mdb for MLM structure?
  110. Any similar function to instr into sql server 2000
  111. saving word documents
  112. List Box Set Focus Problem in MS Access 2003
  113. Data from Excel to Access, Arrgghhhh ...
  114. NEED HELP. MS ACCESS to do MLM Tracking
  115. reference library missing Microsoft Outlook 10.0 Object Library
  116. Connecting to sage line 50
  117. Tab Control Help wanted
  118. copy from the list box
  119. link 2 fields on a master subform
  120. case sensitive like searches
  121. Combining Lines In a Report
  122. hard time with criteria and report
  123. Line Graphs within Access
  124. Passing values in a hyperlink
  125. Error adding a new detail record
  126. Access 2000 last record from subreport disappears
  127. Access 2000: Version comparison
  128. Positioning popup
  129. increment form field after record save
  130. Saving a Record - Access 2000
  131. unlock DB - to view table, forms design
  132. Afterupdate for textbox?
  133. DB messed up after network failure - help
  134. Simple Combo Box Question
  135. Requery of form based on saved query...
  136. SQL syntax question
  137. Msgbox not issuing 'beep'
  138. Logging onto a Remote Computer
  139. Need file browse on Access form
  140. Time-keeping rules
  141. A2K Application.Quit won't - reference MDA libraries
  142. Signing an App with Access 2000
  143. Need Help on MLM database in MS Access
  144. Crosstab query
  145. Access Report using Grid
  146. Please help - Post Code Search
  147. Access 97 event logging
  148. Need help locking fields. MS Access 2000
  149. Text versus Number field.
  150. Date calculations
  151. Anyone yet using Microsoft's Visual Web Developer 2005 Beta 2
  152. Help! Queries and Calculations!
  153. one-to-many convert to form with multiple check boxes
  154. Access + VB6 recordset troubles
  155. Convert a sum in a report from a null value to zero
  156. Isolation problem
  157. litlle question
  158. Help! Compile Error: Method or data member not found
  159. Master Detail Question
  160. Access 97 MSDE Links
  161. HELP! After opening, a database immediately closes using startup form
  162. little problem.
  163. lier un fichier texte avec des dates
  164. Right-side blue panel 'Open' list: how to delete a filename?
  165. transferspreadsheet to existing excel worksheet
  166. Table efficiency question
  167. filling in text box using a query and storing the information
  168. Memo text formating
  169. error "3343 Unrecoginized database"
  170. Problem with Stored Procedures and shared user name
  171. Data from Excel to Access
  172. Feeling dunb today can't get my head round a seemingl;y simple query...
  173. Setting up replication with access front end
  174. Query error: "Data types in the criterion expression are incompatible"
  175. 5365 monografia 5365
  176. How can I add items to combo box without using ";" in additem method
  177. Online Technical Communication Survey
  178. Suggestions? Access formula for web query
  179. I have declared an array Dim MyTables(14) AS Long and now I want to assign values for MyTables(0 - 15) = to the number of records in each table
  180. <<help>> Application in ver 2002 runtime vs. ver 2003
  181. Continuous Form Colour
  182. Cannot send ADO Date/Time parameter to a parameterized query
  183. access mysq - connection securityl
  184. Report Question
  185. help with a report..
  186. Boolean Field Properties.
  187. dlookup problem
  188. How do I evaluate the 'Count' for a report header, footer, detail??
  189. Pass string from form one to form 2
  190. Datasheet form - change column width, with a twist!
  191. Wrong Default Database Folder at Startup Automatically
  192. Linking and disconnecting from backend databases
  193. How to delete commented code lines ?
  194. Error accessing data from Access through Excel
  195. will REGEXP_SUBSTR work in MS Access?
  196. how can I sepreate infor. from one field to new fileds?
  197. Linked images
  198. Data Access Pages getting messages in browser
  199. Merging Access Contact Info Fields into Outlook VBA
  200. OLE Corruption
  201. Have Report Print to Specific Printer Paper Tray in MDE
  202. Design Question - Need suggestions for Creating Related Records
  203. Relationships in a database
  204. database records to excel sheet
  205. SQL Syntax
  206. variable question
  207. any idea for me?
  208. Query to flag a field based on calculated data
  209. Query to flag a field based on calculated data
  210. linked table manager
  211. query not retaining criteria
  212. Newline in String?
  213. DateDiff -1 problem
  214. opening mde file
  215. Why doesn't this code work???
  216. MS Access pages-problems with charts
  217. It's tough one!
  218. How to Pass collection between modules?
  219. Row-level locking Q. Front-end? Backend? Both?
  220. How to make API Browse sticky?
  221. store locator database
  222. Selecting Specific Dates
  223. Microsoft, the future and you
  224. Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
  225. Why does ?2944*24 in the immediate window give me an overflow error?
  226. Allen Browns audit log - doesn't save the log
  227. event procedure update
  228. How to add records using Query
  229. Can someone tell me what is wrong with this simple query syntax?
  230. Help with Combo box menu item
  231. Text in Query/Numbers in Report
  232. Upsizing issues
  233. Conversion to adp
  234. Running multiple versions of Access/Runtime ... in Terminal Server
  235. SQL JOIN query - Inner, Left or Right?
  236. Dim'ing a var as Long, then assigning it to an expression that eval's to #NULL# - Is that a problem?
  237. Access query records to Word
  238. Can the Format$ function be used to format 42397136 to "42,397,136" ?
  239. Inner Join with a MS Access module
  240. Switchboard has disappeared
  241. Upsize from Access 97 to SQL 2000 Problem
  242. MAPI mail failure codes??? Where can I find out what failure error code 2 is? How about the rest of the codes?
  243. Unbound Combobox not displaying data as expected ... need HELP, please.
  244. Simplest way to read size of file on disk from Access 2.0 code?
  245. need help, not sure with what....
  246. Database Design Recommendation Sought - Objective: Reduce Sluggishness / Improve Efficiency
  247. From within MS Access, would like to 'roughly' estimate bytes of storage required by data in each table
  248. None of the wizards are working with Access 2000 on WIN XP HOME
  249. text box properties
  250. Color coding lists on sub forms
  251. Looking for pointer in right direction for a call center application
  252. forcing creation of parent before saving child
  253. Looking for cool/useful/clever examples of form usage!
  254. Multiple entries in one field
  255. Form_Timer alternative Access 2003
  256. combo pulldown ordering question
  257. Help with syntax for where clause
  258. how can I sepreate infor. from one field to new fileds?
  259. Linked Tables
  260. Access 2003 Web page for data entry....info and help please
  261. Selectively omit records from report based on date
  262. Calling a module from a form command button
  263. Incorrect data format after replication
  264. "Autonumber" for each line related to given record.
  265. Required field on a form
  266. When use a list, and when a lookup table
  267. El usuario admin ha situado la base de satos en un estado...
  268. table distribution
  269. how to show different values other than the first in a combo box
  270. DLookUp
  271. I want to implement ULS, one Q?
  272. How to update form
  273. Opening a form as read only
  274. Can't Trap combo box error when null entered
  275. how to group data in column headings in crosstab query?
  276. Scientific database design question
  277. Trouble with Simple Multi Select Listbox in Access 2003 (not so simple for me)
  278. Deleting records in table makes hinders data entry form
  279. Using SQL Triggers and Access Subforms
  280. Offline use
  281. Deleting records in table causes missing data in a form
  282. Deleted Records in a table, now my form is not working...
  283. List All Controls on an Open Form including other Containers
  284. Different tables on one report/form
  285. Need advice on how to confirm Access 2K Library References on atartup
  286. Export to Excel works - but manipulate the worksheet
  287. ADO: Why I use it
  288. first value of each itemid how ?
  289. subform programming question
  290. Linking modules to buttons in forms. How????
  291. Question about importing objects
  292. could not find the object 'MSysACEs'.
  293. This is an oldie but a goodie...
  294. Opening Access 2002 also Opens a New Explorer Window
  295. Square characters at end of string
  296. Textboxes, RTF2 and Unicode
  297. Acc2000-2003 wizards in design mode?
  298. Splitting an Access database
  299. Signing a Database Application
  300. Adding security to Access applications AFTER the event?
  301. Access 97 on XP send mail
  302. Time difference
  303. Multiple Instances Of A Report: Fighting Nature?
  304. Allen Brown's audit log code problem
  305. DBA HELP: Performane Tune SELECT, SUM, & CASE
  306. Access report print colour question
  307. File name in text export
  308. SQL Server
  309. Exiting subroutines
  310. If then Else in Query
  311. Automate ODBC config to SQL Server
  312. Dropped records when linking tables with Exchange mailbox
  313. Synchronisation nightmare
  314. Getting jpgs to Appear On Form
  315. Sorting Problem
  316. List Boxes
  317. Closing for vs Refresh
  318. RTF2
  319. Repopulate Listbox with prior selections
  320. Missing Semicolon error
  321. Microsoft Access corruption compact and repair
  322. VB Script to SQL
  323. I want to list saved querydefs having "tblCorrespondence" in their SQL...
  324. #Name? Error
  325. Access report will not print image header.
  326. Like inside Iif as Query Criteria
  327. Wanted: Book Recommendations
  328. Please Please!! One form with Info from Two tables
  329. Help with a report
  330. sub_report multiple (iteration) record display problem
  331. Lost back end connection
  332. Accessibility keys - form & report design
  333. Replace Function
  334. Tab Control
  335. Active Control trigger
  336. Print a report or form using filtered criteria from a filter dialog box
  337. Validation Rule
  338. Closing a form causes crash
  339. Access 97 Mystery New Record
  340. How to split one field to many
  341. 3 test collection is quite good
  342. Cumulative Sum in query is very slow...
  343. Access hangs after table grows to 12000 records
  344. Need help displaying text data for foriegn Key in form
  345. Tab Indexing in a Tab Control
  346. New user query.
  347. ODBC connection to Oracle tables in VBA
  348. How can I replace one word in a field
  349. access query info to excel range
  350. Help writing a macro or query.. not sure which!
  351. How to convert one string to another
  352. Applying filter to a subform
  353. Saving / Modifying a ODBC connection.
  354. Advice on Table Structure (Agencies & Sub-Agencies)
  355. How to Execute a statement from a Text..
  356. Uprotecting a DB
  357. Progressbar
  358. ODBC connection - faster or slower in MS Access/MS SQL Server 2000
  359. Inventory Help
  360. Compact Database on Close - Good Idea or Not?
  361. Access Mail Merge
  362. Access re-writes combobox row source query
  363. listbox bug?
  364. Too many active users
  365. Changing record before update
  366. Multi select list boxes
  367. Creating self referencing table from multiple tables
  368. triggering a value to be passed from a control on a subform to a parent form
  369. Populating fields on form from different tables
  370. Security required - replace Access?
  371. A 'datagrid' or 'table' in MS Access
  372. MS Access
  373. how to get the specified number of records from ms access database
  374. Splitting DB vs. linking
  375. query help pls - add totals of 3 fields with similar values
  376. Combine Records
  377. Opening a Document in Excel Format in Access
  378. Export a Table from Access 2000 to Excel - Error Msg
  379. How to clear out bad configurations from MyODBC driver?
  380. directshow not installed
  381. Identifying what was clicked
  382. Data Entry In Normalized Database
  383. Prevent data entry of Date Field
  384. Unattended Install using MS Office Access 2003 Developer Extensions
  385. parameters and Forms
  386. excluding records from a query
  387. Forms: Requery a subform from another form
  388. Access date/time range query
  389. 97 link to 2003
  390. TransferText method msaccess - Imported table corrupted
  391. how to set RowSource in MS Graph programatically?
  392. Jet4 SP8 installation process
  393. Assigning Openargs to a "Form" Variable!
  394. Conversion of 1.0 DB, to 97, to 2002, now to SQL
  395. Datediff
  396. A problem with RWOP Security?
  397. Combo box selection
  398. Filter Help
  399. A problem with RWOP Security?
  400. OpenDialog?
  401. MS Access blogs
  402. Reports
  403. Autofill
  404. New Guy with (likely) Simple Question
  405. calling MSDE functions via ODBC ?
  406. How do I write a query so if a field is blank it won't show
  407. Web services Error- Server was unable to process request ---> object refference not set to an instance of an object
  408. Password for backend
  409. Using SQL Server for Data Procressing
  410. ListViewRemember
  411. Excel Automation question
  412. updating null records in a table
  413. Updating JOIN and UNION ALL query
  414. Print Log problems
  415. Error message
  416. Error message
  417. Access 2003 - a system error happened or there is not enough memory
  418. Window size and positioning - how to define?
  419. Saving split database on network and local
  420. Grab HTML and display in form.
  421. Storing OLE
  422. Data member not found
  423. Unbound form
  424. Sorting records using visual basic
  425. Help With Sub Query
  426. How to sort table data?
  427. Audit trail question
  428. chart/graph issues
  429. Advertising
  430. Attaching a label to a BOX
  431. Bug in DateAdd Function?
  432. Access 2003 runtime package connection problem
  433. Disabling Design View of a Form
  434. Button Sequence?
  435. close form if query returns no records
  436. Access appears to hang when linking Oracle table via ODBC
  437. I imported a module from an Access 2.0 database into Access 97. Can I tell by looking at the code what must be changed to 32-bit DLL calls?
  438. Query through form with or without data specified
  439. What is the N in front of the string?
  440. How to limit concurrent users/logins
  441. Code works on design database, but not in work database (in the network)
  442. passing a string or building a string for testing
  443. Multi-user Access DB; DAO or ADO?
  444. Search Beta Test :secure login without Password
  445. Running Access 2000 on a PC with Access97
  446. Linking tables on data access pages
  447. Permissions
  448. Selecting a column without knowing its name
  449. Max of value
  450. Want more about vendor and simulation
  451. How to constrain a screen-dump to include only the current form...
  452. find duplicates between 2 tables
  453. Access Data pages
  454. Backing Up a Remote SQL DB as XML
  455. Report DLookup Field Filtering
  456. Shell32.dll -- What's in there?
  457. Access 97 - Multiuser problem
  458. Creating a simple standalone query
  459. I cut this example right out-a-the MS Access 2.0 help. I cannot get it to work.
  460. SQL in VBA
  461. Crystal Reports Export Format From MS ACCESS
  462. Using Array in Dlookup
  463. Saving VBA crashes system loses forms Couldn't Update Locked
  464. How to get user defined property value using VBA in .ADPs?
  465. Successfully opening a Recordset
  466. Which is faster in DAO under Access Basic (Access 2.0) FindFirst or Seek?
  467. Can all fields and contents be viewed in 1 window?
  468. Query Help
  469. How to remove "(text)" from a string
  470. When to use .MDE's
  471. Week no & period no
  472. ADO, adCmdText, parameters
  473. Sorting dates without yeats to get a birthday list?
  474. Appending text to number returns #Error
  475. Convert date to number and back
  476. Sort access database
  477. editing a record from an order form
  478. large mdb file
  479. ADO from within ms access
  480. Edit pdf document
  481. Stop Steve, the advertising machine
  482. Returning the path to a file in VBA
  483. International Motivation Survey
  484. Supercomputer and encryption and compression @ rate of 96%
  485. reading large text fields (ODBC direct connection to Oracle) in Access 97 vba
  486. XML Import Error: Too many fields defined.
  487. multiple join SQL query
  488. excel import problem
  489. Recursive code to create indented bill of material
  490. Connection problem from Access front end application to SQL Desktop Engine backend
  491. MS Access database shuts down
  492. In Access 97 and Access 2.0 applications, if a command button has the focus, the spacebar will 'PRESS" the key. How to disable this?
  493. Updating a field in a current record
  494. Condition with an Else
  495. External Source Control of Basic Modules in MS-Access?
  496. Was there a way to run a FileExists check from MS Access 2.0?
  497. converting MS Word document to MS Access?
  498. Recipe Database
  499. UnitsToElement
  500. Problem installing Access 97 with Windows XP - "error occurred changing the workgroup database"
  501. Combo box jumps to values when duplicates
  502. Send to rpt before moving to a new record
  503. Subform datasheet selection
  504. Having Zeros Appear
  505. Problems with TransferText
  506. Network load
  507. Access 2000 - Open external table
  508. Distributing Jet database engine
  509. Openings in an online game company for database people
  510. MOD function
  511. Formatting Dates
  512. Mouse Wheel in MS Visual Basic window (in Access) stopped working!!
  513. Formatting Dates
  514. Formatting Dates
  515. Use Windows ImageList for program icons in treeview control?
  516. Build string variable
  517. MDE file shareware?
  518. Att: PC Datasheet - Please readf inside
  519. Turn off default menu bar
  520. fastest way to determine if any records exist in table?
  521. Problem with report trying to Duplex
  522. Convert .ADP to .NET?
  523. conditional on a form already being opened
  524. Table Allocation
  525. missing records from coded recordset when compared to qbe
  526. Running script before import
  527. Network resilience registry key for MS Access?
  528. Automatic update from Oracle db to access db
  529. subreport control reference problem
  530. DAP problem
  531. Using the Docmd to set another forms detail.visible
  532. Two multiselect listboxes
  533. Two multiselect listboxes
  534. access question / forms
  535. Text Box Values
  536. Create Access 2000 MDB from Access 2003
  537. Looking for help with Runtime Error
  538. How can I tell if file on linux box is moving across my LAN?
  539. Using GroupBy, Min, Max, and Count in the same Query
  540. Missing Query
  541. Download Code from an Internet Page....
  542. Conditional formatting problem
  543. Open WinExplorer from Access VBA ?
  544. Pictures in Reports
  545. SQL Backend/Access Frontend
  546. Access 2003 Edition
  547. Group Level Count
  548. SQL in VBA
  549. Problem with disconnecting
  550. Modifying subform makes query vanish