Home : Bytes IT Community / View Full Version : MS Access

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

  1. Delete spaces of fields in access table
  2. Winzip self-extract for Access Runtime install problem
  3. Passwords & Forms - Access 2000
  4. how to calculate man hours for different project ?
  5. Generic menu handling code
  6. Warehouse stock location tracking
  7. Report from Crosstab Query
  8. pdb file
  9. Numbering in Report
  10. Opening MDE Application using File Associations.
  11. general db design
  12. Virtual Memory
  13. Concatenated column in a report
  14. List box using tables
  15. Access Forms
  16. Error 3061
  17. Problems Caused By Several Users Using A Single Frontend
  18. query does not extract records if blank fields are included
  19. Generate PDF with VB code in Acrobat 6.0
  20. fenton-linson sf wedding
  21. updating a field with code
  22. Access 2.0 Multiuser Application
  23. !!FAQ! for Date: 20040219 - New Users Look Here! [Last Updated February 05, 2004]
  24. Unique index works but...
  25. what is wrong with this?
  26. Can A2002 Reports have multiple Groups on total database records???
  27. Double combined Search
  28. Combo box choices using query
  29. HEEELLP - No Value given for one or more required parameters - Win2000 & XP French version
  30. Create Shortycups in MS-Access ADP
  31. How to filter on a report?
  32. Certain Functions Have Stopped Working
  33. Reserved Error (-7711); there is no message for this error
  34. Reading a record set, code reads date as American not English
  35. Create .mde from .mdb with code or command line
  36. Sending an email from Access
  37. Access and DB2
  38. Comparing data in ms access
  39. Querying table using duel date fields
  40. Query Puzzle Access 2000
  41. Access 2002 conversion back to Access 1997 error
  42. looking for a tutorial or detailed infos on how to work with arrays??
  43. Implementing A Junction Table
  44. Lost the plot in design
  45. DAO and database corruption
  46. Updating an Addin
  47. Passing Query Results to Form
  48. Random AutoNumber - Is 0 possible?
  49. displaying data in multiple columns
  50. Does any body know where I can get a list of english words?
  51. Can't display embedded OLE object as icon
  52. Subform Record Pointer Resetting on Requery
  53. looking for online zipcode database and program
  54. Fails to navigate to the proper record WITHOUT a MsgBox
  55. HELP! HELP! HELP
  56. Getting data into Access Table from SQL
  57. Outlook events
  58. Help with automaticallly adding weekly charge
  59. Network Computers Suddenly Can't Access Database?
  60. Just converted to A2002, querries not working - please help
  61. AUTOMATICALLY UPDATE TABLE FROM FORM
  62. RTF2Control/divide text into several paragraphs
  63. Text Box Control Source problems.
  64. Increment Total on Second Table from Form
  65. forms - control tip text
  66. Generalization in Microsoft Access
  67. Length of Formatted String
  68. Query Causes Hard Crash
  69. Set required field to Null
  70. saving [enter a value] in update query
  71. Need help with delete query
  72. DLookup questions
  73. !!FAQ! for Date: 20040218 - New Users Look Here! [Last Updated February 05, 2004]
  74. excel
  75. removing last letter in data for a report
  76. What the hell is wrong with the Update statement!
  77. Limit the number of 'Selects' in Multiselect
  78. help with query revised from post (help with query (month as Text) up to given Month) 14/02/2004
  79. Problem with calculations!
  80. unique table property
  81. Word Table to Access
  82. Export to Excel
  83. Text string search query
  84. list box validation
  85. I'd like to get rid of new record so that user doesn't notice it.
  86. field-reference in msAccess Report (SQL server backend)
  87. Numbers in Listbox
  88. Update Combos using vba
  89. Replication with Split database
  90. Error accessing the OLE registry
  91. Problem with Query Date Parameter Selection
  92. Reports - Line Spacing in Detail Section
  93. XP Developer Packaging Wizard Error
  94. Access 97 Runtime - application icon doesn't appear
  95. Parameter Like Statement Criteria Problem
  96. Opening Access 2002 mde Files In Access 2003
  97. Upgrading from Access 2K to ...?
  98. "Query by Search Form" Question...
  99. report building
  100. Upgrade from O97 to O2K --OR-- O2K3?
  101. Error: Enter Parameter Value
  102. Label Wizard - Loses margins
  103. Convert null to 0 in crosstab query...
  104. Dialogic Board / Saving Audio files / Dictation
  105. Access vs. SQL
  106. Good relational database design
  107. combo box after update question
  108. !!FAQ! for Date: 20040217 - New Users Look Here! [Last Updated February 05, 2004]
  109. Help!! Calculations
  110. Problem trying to replace a Form using the Macro CopyObject command.
  111. Form problem
  112. OLAP cubes
  113. Scroll in subform only down, UP NOT possible (with mousewheel)
  114. Call Logging
  115. Import Wizard Puzzle....
  116. Corrupted(?) Menus in Access 2000
  117. wrong order of images in printing reports
  118. Object invaliad or no longer set error after onverting from Access 97 to 2000
  119. Exporting to excel csv and how to set the cell to wrap text
  120. images in reports doesn't refresh
  121. Help needed: Wrong strTbl in fRefreshLinks
  122. Complicated problem
  123. Reading forms and reports information in .adp
  124. prohibit double booking in room hire database
  125. text to column
  126. How can I get all table names from MS Access
  127. Printing documents from an Access form?
  128. Brick Codes
  129. Calling vb from other application
  130. #include
  131. very tricky sql statement
  132. Delete query problem
  133. Bound form, SQL server, opening in wrong mode
  134. thin drivers for ms-access ?
  135. Why to be careful declaring variable As New ...
  136. changing field names
  137. How to query for multiple criteria?
  138. Attach a recordset to a subForm?
  139. Slowwww printing on inkjet using DoCmd.Printout
  140. looking for online zipcode program and database
  141. Access 2000 VBA help file
  142. report and print a5 landscape
  143. Running Button Method from Another Form
  144. Need To Create A Master Record
  145. If...Then...Else
  146. Disc catalog to Access table
  147. Error from Office 2000 to Office XP
  148. Access 2k ActiveX treeview control
  149. How to replace a .mde file when many users are connected to the file
  150. Security--permissions not working properly
  151. Dlookup function gives "You canceled the previous operation" errmsg
  152. Scaning Documents Thru Access
  153. Script for Access FTP
  154. Cannot link table from SQL Server 2000
  155. Updating multiple tables with one form
  156. Using a Recordset to Send Emails in Outlook
  157. !!FAQ! for Date: 20040216 - New Users Look Here! [Last Updated February 05, 2004]
  158. Calculating fields in query
  159. Cannot link tables from SQL Server 2000
  160. Code to convert a Number to a spelled out number
  161. Office Delovoper
  162. Searching in VB
  163. List plus "Unknown" in Combo Box
  164. Access fails when clicking on a subform
  165. Highest Record?
  166. Open Access Maximized
  167. Filters and sorts in datasheet view
  168. Fremdschlüsselbeziehungen anzeigen lassen?
  169. Parameterized Query
  170. Building a report
  171. Easy one
  172. Acc2K FE, SQL Svr 2K BE, Slow form display?
  173. nz function with where clause
  174. OT - NewsGroup Personality - Gilbert And Sullivan
  175. Save Contents of Unbound Field
  176. Getting into secured old databases
  177. sorting difference query-report
  178. progressive number
  179. Nested IIF function
  180. default keypress
  181. Question on multiple forms and referencing data
  182. Error: User-Defined Type Not Defined
  183. Err.msg: You canceld the previous operation ????
  184. Reading excel file and writing to access table
  185. Sample database
  186. Access 97 to XP Access Conversion Error
  187. Can we use Office Document scaning utility into Access as ocx ?
  188. Access <- > SQL Server
  189. Locking records
  190. How to make/package a mde/mdb file so it can be run on a PC without MS-ACCESS installed...TIA
  191. Setting the recordsource of a report
  192. !!FAQ! for Date: 20040215 - New Users Look Here! [Last Updated February 05, 2004]
  193. Help needed to store quiz solutions from db to VB
  194. Adding Data to a N:N relationship
  195. Reservation system in Access?
  196. Can we display a report without print preview? General queston
  197. after update handling
  198. adp connection
  199. Rdb to MDB
  200. Error Accessing File - Network Connection May Have Been Lost
  201. sorting mixed data types in field
  202. Another update problem?
  203. Continuous forms, highlighting specific record
  204. ODBC and Access Database Online
  205. !!FAQ! for Date: 20040214 - New Users Look Here! [Last Updated February 05, 2004]
  206. Requery every subform?
  207. Screen resolution problem
  208. ODBC
  209. how to declare only once
  210. help with query (Month as text ) up to given month
  211. Print multiple copies
  212. 32x32 form icon while taskswitching
  213. Access 97 to XP error Japanese Characters
  214. Zip Function
  215. Sharing Access 2000 Files Between Computers
  216. Saving a record in a suborm with code
  217. Forms and Subforms - Many Calculations
  218. Access 2000 - the right choice?
  219. Access 2003 linked table manager not displaying tables
  220. /runtime + compact on close + references = crash?
  221. Senior Microsoft .NET Programmer/Analyst needed
  222. at wit's end about corrupted records in Access 2k table!
  223. Selecting Data to get a value
  224. Sending date to query problem
  225. Inserting a record & adjusting form?
  226. !!FAQ! for Date: 20040213 - New Users Look Here! [Last Updated February 05, 2004]
  227. 3 page "Detail Section" - is it possible?
  228. Execute/Insert into method works sometimes??
  229. Referring to subform
  230. Displaying information in Access - general question
  231. OLE IMages in Access DB
  232. problema di sviluppo
  233. How do I declare a variable that allows data to be added to it without losing its existing value?
  234. vexing decimal problems
  235. How to attach an SQL statement to an unbound control????
  236. Need Asssitance with On Delete Code
  237. Can't Open Anymore Databases
  238. "Catch all"
  239. Dates
  240. ADO not registered anymore
  241. Access-Datensatz an vorhandene Excel-Tabelle anfügen VBA Function (Office 97)
  242. relating queries to tables
  243. Linking to Act
  244. Replication ID /CustomerID problem
  245. How do I create an Icon in a form to Print a report
  246. Readable lables in a Pie Chart...how can I?
  247. MouseHook and Tab Controls
  248. Network Update Data,Information needed
  249. form fields and problems with recording data into the table from the forms
  250. Forecast Report
  251. how to retrieve 'quick launch toolbar' folderpath help!
  252. Calculating subsequent field values in table
  253. append property
  254. Need autonumbering help (novice level)
  255. Access to MySQL
  256. Access 2002 Database Design Help
  257. Display updated Totals
  258. Error 3020 Update or CancelUpdate without AddNew or Edit (Form Error)
  259. Beyond my scope =-(
  260. Can't change admin. password because tools menu missing
  261. queries doesn't return new records
  262. !!FAQ! for Date: 20040212 - New Users Look Here! [Last Updated February 05, 2004]
  263. Anyway to change the "style" of an existing form??
  264. Count distinct occurences
  265. Re-use report by using a query to filter
  266. Jumping to row in Subform
  267. Are drop-down menu itmes stored in table?
  268. Sympathy for Starwars :)
  269. Method to Display Future Popup Messages
  270. Prevent Deletion of Keywords in a Combo Box Table
  271. query with criteria on two fileds in one table
  272. Updating records in related tables...
  273. MS ACCESS Reports
  274. How to create own tab delimited file
  275. Word files import to access database ...?
  276. Create Read-only file in MSACCESS
  277. how to refresh the "other" data base window
  278. Microsoft Progressbare V.6 how to use it ?
  279. Link To Selected Fields
  280. Running Access 97 on Windows ME
  281. invalid arguement when updating memo field -- size limit?
  282. Access VB6 Integration
  283. Date Conversion From Text
  284. Determining Field Type and Loops
  285. BackColor On TextBox
  286. acting on null recordset
  287. Publish to web, Local option only enabled?
  288. Help with Function to redisplay a cost price...
  289. ? about closing this popup form
  290. value substutition
  291. One last question about using GetObject...
  292. Force Textboxes to new page in Reports --- Help
  293. Forcast Report
  294. Average Payment in Days
  295. Adding a column to an existing table with data
  296. Access 2000 and Calendars
  297. VBA Event Procedures in Form Module Lost Association to the Control on Form
  298. !!FAQ! for Date: 20040211 - New Users Look Here! [Last Updated February 05, 2004]
  299. Wanted - report writer to access ms-access databases
  300. Creating a Timesheet
  301. Average Payment in Days
  302. requery problem
  303. Windows 2000 Server Listed as a User in an Access XP Dabase
  304. Access 2002 deployment
  305. LIstBox vs Combo Box for looking things up
  306. Forcing zeroes as beginning of Key Number (ie SSN or Zip) and SSN appearing as 2323E+08
  307. Table Relation Question
  308. Adding Records using DAO and variables derived from queries.
  309. time based message box question
  310. Is there a way to speed up execution of this code?
  311. Concept Question
  312. Code to duplicate records
  313. Help with pictures
  314. Calculate in Text Box speed
  315. user input to query
  316. Writing to a file with VBScript/ASP sometimes gets truncated - why??
  317. Advise please
  318. Outlook Express <-> Access97
  319. Help with dlookup required
  320. Access Forms flow--> Visio
  321. How to distribute app with Jet binaries?
  322. should this ng become moderated?
  323. Median in a Query
  324. Upsizing question
  325. Print quality varies with Access version
  326. Building an expressions where parts are unknown at design time
  327. How to access a control through code?
  328. datepart to get mmddyy from date/time formatted mm/dd/yyyy problems
  329. Problems With Access 97 Falling Over
  330. MSDE 2000
  331. download data from access ????
  332. How can access desktop access database from my unitech pt930(s)
  333. Text criteria weirdness
  334. Web Enabled Access 2000 Database
  335. OnNextRecord
  336. HOW DO I ADD a vertical row of values in Access 2000??
  337. More getobject help, please
  338. Security Issues In a Multiuser Environment
  339. query to combine two tables
  340. Mapi Fails on MapiSession.Outbox.Messages.Add
  341. I Am Really Crazy
  342. Acess 97 toolbar help wanted
  343. Bibliographic formatted references
  344. Forms Format
  345. Strange "Mystery Record" Behavior
  346. sql server pass through query
  347. !!FAQ! for Date: 20040210 - New Users Look Here! [Last Updated February 05, 2004]
  348. Supress Automatically opening modules
  349. Building ODBC Connect strings that work
  350. How to use SQL queries in a report????
  351. ADO recordfind help
  352. Can't compile anything????
  353. =Format$ field doesn't work after copying database to new computer
  354. Subtract one year accurately?
  355. Groupwise Email from MS Access 2000
  356. Calling a function, basic question
  357. How to know if instance is already running
  358. Access 97 less available records
  359. How to put a menu bar DIRECTLY on a form.
  360. How to print tab in the middle of string in a report?
  361. Backwards Conversion
  362. Storing Only One Value?
  363. Future of MS Access......
  364. 401K Account Fees
  365. Link Code Modules instead of Import Access 2000
  366. Payroll Hx Table and Reports
  367. Check for a Date then do something....
  368. "The field is too small to accept ..." error for a bound control on a form
  369. Update Query - Finding and Updating Maximum Order Number
  370. Sympathy for Starwars :(
  371. please help me -microsoft access help reqired
  372. function(s) to split an e-mail address into user and host
  373. getobject
  374. access 97: duplicates in query
  375. Editable mde ...
  376. Form letter question
  377. Form Controls Colors
  378. Import table
  379. Interland MS-SQL Hosting - somewhat OT
  380. Is there an Access 2002 developer kit?
  381. !!FAQ! for Date: 20040209 - New Users Look Here! [Last Updated February 05, 2004]
  382. design question
  383. Access to SQL Server
  384. Append Query - Increment Order Number
  385. Bandwidth Required For ODBC Access
  386. Start and End dates of gaps in date range
  387. Need help! Trying to auto fill in a form
  388. RECORDSET NOT UPDATABLE
  389. Make Table Query in secured DB
  390. multiple ifs converted to case statement in vb function
  391. dates - vacancies and bookings
  392. ASP connecting to linked table in ACCESS (cannot find the input table or query)
  393. 0 or blank Data Entry field on a form when tabing or clicking to enter
  394. How to resize form from code?
  395. Access 97 upgrade question
  396. OT (a Little) Book Publishing Deals
  397. Query Date parameters promting order question
  398. Names of the variables as SUB arguments
  399. Clearing a binary marked field
  400. Different text styles in the same text box
  401. using Find property in a form to locate records in a table
  402. Tablecreate Query
  403. Outlook Redemption
  404. Last 5 items loaded
  405. conversion -MS Access 2000
  406. Use project without revealing tables, queries, ...
  407. Add controls to option group
  408. Parsing Subdirectories
  409. Import to table
  410. Urgent: No database objects visible in .mde
  411. Create PDF from Runtime/Distributed Application
  412. Help Displaying Tables in DataSheet Format
  413. Access 2003 Default File Format
  414. Can this form be made in ACCESS?
  415. how can i make unbound box limit to one line
  416. Re-using Old Autonumber Values
  417. make source invisible
  418. link helpfile in a button in the menu
  419. importing and saving an image
  420. !!FAQ! for Date: 20040208 - New Users Look Here! [Last Updated February 05, 2004]
  421. On Not In List
  422. Connect to Security DataBase (MS Access 2000)
  423. Getting NZ equivalent in an .adp View
  424. documenting access apps
  425. Can't read data from a table after saving record from a form
  426. mssql server to access script
  427. Send file as attachment to Outlook Express
  428. Select distict and order by in a combo box
  429. requery after date picker
  430. Combo Box Query On One-To-Many Form.
  431. Problems with IIF
  432. Using alias in expression
  433. Encrypt source
  434. Date Update!
  435. Null Values to zero
  436. If-then statement in query
  437. Growing database
  438. Hyperlinks to Powerpoint and Word - how much control does VBA give you?
  439. Using VBA function for Forms
  440. Losing it with Report/Sub Report from Union Query
  441. Outlook calendar in Access
  442. Access and Cash Register Operations
  443. Displaying only a startup form
  444. F11 does not cause the form to break
  445. Problem with images
  446. Trace which Key button was pressed?
  447. Task to convert A97 to A2000
  448. Table w/ Autonumber AND Cascade update
  449. Having A Query open a Form
  450. Engineer Avail
  451. Finding field names through database
  452. Duplicate value in field or relationship
  453. How to fill a two-column list?
  454. VB, PC to UNIX, mySQL, PHP Freelance Programmer Wanted
  455. Prerequisit to learn Access
  456. US and UK dates confused
  457. !!FAQ! for Date: 20040207 - New Users Look Here! [Last Updated February 05, 2004]
  458. SOLUTION: run time error 3146 ODBC call failed
  459. Form with Tab Control
  460. A date problem?
  461. Set variable from value in a table
  462. blinking control in report ?
  463. Subform refresh??
  464. Filtering Dilema!
  465. combo box to find records
  466. About to install Access 2003 - already have 97 and 2000 installed.
  467. Combo Box Query: Listing a subset - Revisited
  468. How to post to a remote form?
  469. Create cXML-File from Access97
  470. simple way to link an image to a table entry
  471. Reasons for upgrading to Access 2003??? Backwards compatibility with 2002?
  472. relate two access databases
  473. Timer Component
  474. HELP! - Missing Access 2000 components
  475. DateAdd Glitch?
  476. !!FAQ! for Date: 20040206 - New Users Look Here! [Last Updated February 05, 2004]
  477. SQL select
  478. Multiple clients (seperate db) one master (sees all db's)
  479. ? about displaying total from subform on main form
  480. openrecordset without using "set variable = "
  481. Grouping in a report
  482. How do I refer to a subform (VBA)?
  483. Microsoft Access can't send this e-mail message
  484. Save from combox bound info to table
  485. Delete current record
  486. Null in subquery returns no records
  487. Multi - Select List box Question
  488. How to Prevent ControlTipText Pervasiveness
  489. Relink just not right....can someone help me please
  490. Charts in Access
  491. Access internet linkups
  492. Oracle Person Needs help with MS Access Queries
  493. On form open, expression has invalid reference
  494. Pictures in image control don't refresh
  495. Missing data when exporting to excel
  496. formatting a Text box for hyperlink
  497. Alternate backcolor in report
  498. MS Access - Crystal Reports
  499. Security on back-end Access 2002 database.
  500. Stand Alone Access Applications
  501. PostgreSQL back-end. Ref. integrity violation in transaction.
  502. Out of Memory
  503. Calendar Control on form
  504. start-up projects
  505. Image Handling Problems...
  506. Switchboard - Hide the Database Objects
  507. Entering a Date/Time parameter?
  508. The memory could not be "written".
  509. Adjusting the X-Axis of a Bar Graph
  510. Form created as datasheet; displays as single form
  511. ADO: Can I insert a stored procedure in a transaction
  512. opening recordsets
  513. ADO: new ID after insert
  514. Query Help - Returning the Difference between Two Values
  515. Help out with a difficult query?
  516. Change default reference from access11 to access 10?
  517. !!FAQ! for Date: 20040205 - New Users Look Here! [Last Updated February 05, 2004]
  518. Why does Access get confused with the result set?
  519. Acrobat 6.0: Print PDF by VB Application.
  520. Auto populate field based on recordset and coding
  521. Getting last entry of field for default value in form
  522. Weird Access 97 MDE behavior
  523. Msado15.dll
  524. Query for Report to allow choice between 2 date fields for date range
  525. How to connect access remotely
  526. Parsing an XML file
  527. sql optimisation
  528. Output To Formats Missing
  529. Writing from unbound comboboxes to tables
  530. Subform will only show 6 records
  531. Before Update Event for Text Box Contents
  532. Creating duplicate data
  533. Need help on importing an Excel Sheet into Access 2000
  534. Subforms - 4
  535. Hours and numbers
  536. datetime field overflow (year 1899)
  537. Showing same ref number in 2 Tables
  538. Modifying Objects in Access XP
  539. Combobox help needed...
  540. Stumped, Desperate: Word 97 with Acc 97 on WinXP...
  541. Recordsets .. why the error message?
  542. TransferSpreadsheet fails in simple reproducible example
  543. Create List of Report Recordsource Items
  544. Auto fill in without one to many relationship.
  545. Merge Records From Multiple Sources
  546. Frontend on Windows PC/backend on a Mac?
  547. how do I use word doc in access
  548. Linking from Access 2000 to Access 97
  549. Time portion displayed when field has the focus
  550. Charts in access - serious troubles