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

  1. copy multiple fields from one table to another
  2. limit query results to no duplicates on 1 field
  3. How do you create 2 key fields?
  4. Preventing users from Switching Forms AccXP
  5. Efficient way to compare data in Two identically structured tables.
  6. Merits of CustomProperty vs. form parameter
  7. Count number of orders and number of different itemnumbers
  8. Timing a proecess in Access2000
  9. security on forms
  10. Filtering
  11. invalid date in linked table from exchange
  12. Major A level Project.....help needed
  13. Synchronizing Two Subforms
  14. Reports and rtf exports
  15. Close Form if No records
  16. Two Linked Table Problem
  17. Help: how retrieve first line from memofield?
  18. Two different apps - two similar reports...
  19. Metacode (was "Custom error numbers/messages tip")
  20. Queries Prompting for Input Twice
  21. ADO Question
  22. access in a shared folder
  23. Changing "Index or Primary Key cannot contain a null value" message
  24. A2K REPOST - all controls on subform disappear after delete
  25. How to programmatically load/ref pics in DB?
  26. Modifying Age Function
  27. I use an Access table to house sounds. I play & record them from a form. I need just a wee bit more help...
  28. I'd like to call an external program from within an Access procedure to allow me to record voice
  29. !!FAQ! for Date: 20031102 - New Users Look Here! [Last Updated July 24, 2002]
  30. How to send email without displaying it ...
  31. VB Calculate and update field in a Form
  32. VB Calculate and update fields in Forms
  33. Extracting month name
  34. Can I extract a street address using a query?
  35. For the PRO's: Kaplan's TSISOON as base for autobackup in A97
  36. Visual Basic Programmers Needed....
  37. warning of an approaching date
  38. Only 1 problem left with sending email
  39. Code to send mail ..
  40. Smart Defaults
  41. A2K - executing code after using a datepicker
  42. Outlook Redemption not working ...
  43. Exporting
  44. get values from another table
  45. Sum in Report is off by a penny!
  46. AllowAdditions on subform
  47. converting DOS dbase program into Access
  48. how to create an Access data input form external to db?
  49. Splitting Database Question
  50. Relationship problem ~ How to tell Owner his db is crap.
  51. !!FAQ! for Date: 20031101 - New Users Look Here! [Last Updated July 24, 2002]
  52. Alter record based on query result?
  53. updating tables
  54. Access db can be updated by several people at the same time (via Web form)?
  55. A2k bug? Deleting db.props causes corrupt db
  56. Merge fields from Table in Report
  57. Merge fields from Table in Report
  58. Export of form with 2 graphs As a JPEG
  59. Install that security package from Microsoft
  60. form fails to... FIX
  61. Combo Box Problem ...
  62. Adding a new Record and updating mutiple Tables
  63. Multiple Queries into One Report?
  64. form fails to ... part two
  65. Form fails to release control of table
  66. Shell.exe Command
  67. Using Form to Write to a Table
  68. Open Access Database Form from within Access database
  69. cannot open any more databases
  70. INSERT INTO Error
  71. OutputTo "crashing" app?
  72. SQL Server Conversion
  73. ADO Parameter Query
  74. Subtotals on unpredictable key within a report
  75. Class Modules and Is Nothing
  76. Need help with option group labels and embedding fonts..
  77. Changing Names of Objects
  78. Deleting modules
  79. HELP! Getting Error: Argument not optional (Error 449)
  80. Compile Problem
  81. !!FAQ! for Date: 20031031 - New Users Look Here! [Last Updated July 24, 2002]
  82. List of databases
  83. Views not
  84. Nested Select of Min and Max
  85. date conversion
  86. formatting Msgbox
  87. Reports don't always run
  88. Export Data to Word
  89. weeknumber in sql??
  90. SQL select and listbox
  91. Rounding up by a specific increment...?
  92. Question about Report Efficiency
  93. creating primary key from stored info
  94. Better use of x or y or z....
  95. Access 2002 doCmd.Sendreport filter?
  96. Sony clie not syncing
  97. Action Query
  98. DAO Garbage at 256+ Characters
  99. Duplicate records to different tables
  100. Restricting Users to Certain Data in DB by filtering a field
  101. Getting individual information from the last record of a query
  102. Problems with MAX and Group By
  103. acsess encryption
  104. What's the verdict on Access 2003?
  105. Only Admin can change db.Props ?
  106. Need to Open Database from another Database and delete table within
  107. Default selection in a listbox
  108. Question in .vbs script to pull export from Access
  109. Creating Stored Procedure error
  110. Passing form parameters to subform in stored procedures
  111. Help: Counting Records for a report
  112. Variable Reference
  113. ACC-97 - Great Version Controller/Auto Incremental Backup
  114. numeric formatting
  115. Margin problem?
  116. DB Design Question
  117. Object variable or Width block variable not set error
  118. How to reference my constants declared in an xl module
  119. !!FAQ! for Date: 20031030 - New Users Look Here! [Last Updated July 24, 2002]
  120. Unwanted save of changes to GUI
  121. Change length of variable
  122. A2K - error for this query is very strange!
  123. find a date between 1 yr from specified date and 6 mos from specified
  124. Data Provider
  125. League table problems - correct table design?
  126. Export File Name
  127. arrows to move to the next record in the form
  128. StoredProcedure results from VBA code in MSAccess
  129. List Box problem after upgrading to Windows 2000
  130. TimeSheet Database
  131. Acc97 - Record Changes Not Writing to DB
  132. Timesheet Database
  133. Make slow query faster through joins
  134. Problems with Report Where Condition
  135. Write records to Excel
  136. Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot) - Equivalent in ADO???
  137. Duplicating data
  138. combo box in query
  139. Add New record
  140. General Design Question SQL Tables or Local Tables
  141. MSJETOLEDB40.DLL failed to register
  142. Multipage subform issue
  143. Displaying Record Number on Form
  144. Timestamping a record
  145. Print Preview
  146. Query 'upsize' to sql utility
  147. List Box Problem, - Very Strange.
  148. SQLServer 2K Update problem
  149. Creating objects at runtime using NEW
  150. Access - Identifiying Query Dependencies
  151. Weird Inter-Table Dependency!
  152. Create DB for survey results - how?
  153. Expressions and the IIf statement
  154. entry validation by the first letter
  155. office 9 reference
  156. Connecting to MDB file with ActiveX
  157. Database folder set to "Read Only" and cannot change?
  158. Many to Many
  159. Access 2000 union query fails silently or with "data type mismatch in criteria expression"
  160. Strange Automation Issue
  161. Calculate Years
  162. File Sharing Lock Count Error -- ??
  163. 2 non wanted messages in Outlook when emailing from Access
  164. Standard Time calculation wrong in PreciseDateDiff .... fix
  165. Report: How to sum groups that use count function
  166. security
  167. Listbox issues
  168. How to pass parameters to a cross tab query?
  169. Eliminate Duplicates by Returning Latest Record
  170. Using MultiSelect List Box on a Subform
  171. Access runtime - Installshield
  172. !!FAQ! for Date: 20031029 - New Users Look Here! [Last Updated July 24, 2002]
  173. Duplicating records
  174. A query problem
  175. linking a query like a table
  176. Winfax vs mail
  177. Problem with Reserved Character in TransferSpreadsheet method
  178. Print report for 1 record
  179. References
  180. Export access data table into excel
  181. "There is no object in this control" in Access 97 form with registered MSINET.OCX on XP machine
  182. ODBC connection to Sybase DB not closing
  183. Date field manipulation
  184. Access 2000 corrupt data with huge jumps in autonumber
  185. How to pass the record between forms?
  186. Access to SQL Server
  187. How display subform using Data Access Page??????????
  188. Importing data using TransferSpreadsheet
  189. Update all fields from a table with the values of a related table
  190. References issue
  191. Externally Run Access Queries/Function
  192. Stop Mouse Wheel from Scrolling Records
  193. listbox problem
  194. SaveAsText syntax
  195. SaveAsText error
  196. Results returns from stored procedures
  197. Twips, points and cm
  198. Calculate number of days
  199. Access 2003 - Security Warning
  200. The joy of decompiling...
  201. Quick fix to unnormalized DB
  202. "Error accessing file. Network connection may have been lost." (TJR)
  203. Internet developer for hire, capable with MS-Access
  204. defaulting to my documents folder
  205. Attn. Steve Jorgensen - blat SMTP mailer
  206. Re-using Navigation Buttons in Many Forms?
  207. Mail Merge for Access Reports .. recommendations?
  208. N-number of subgroups
  209. help w/ transferring data into report
  210. InetTransferLib demo doesn't work
  211. Managing code snippits in Access XP
  212. Access XP Expression Builder dosnt wrap text
  213. Need help filtering records with combo boxes
  214. filtering data based on an user input on a form
  215. Why would DoCmd.OutputTo occasionally crash?
  216. Mixing Formats within a textbox
  217. Sub Form
  218. Use Access DB without Access
  219. Report question: 2 columns of data
  220. Adding a Field using VB to an existing table.
  221. Open Outlook Calendar from Access?
  222. Trouble shooting PDF output
  223. Advice request.
  224. Advice request.
  225. New Query Wizard
  226. using a query to change a yes/no field
  227. Access 2003 Help Files - How To Disable Microsoft Online Help
  228. Verision differences 97/2000/XP/2003
  229. Creating a record in a child table using ADO
  230. Query "Where" question
  231. !!FAQ! for Date: 20031028 - New Users Look Here! [Last Updated July 24, 2002]
  232. How to make multiple queries an atomic transaction?
  233. Access 2000, error 2185 on Win2k PC's
  234. Database twice as large after using password
  235. Printing to 2 different paper trays or to 2 different printers
  236. Query problems.
  237. secured replication
  238. Get the value from a single cell
  239. first?
  240. By Pass Keys
  241. Swedish characters
  242. Vertical text in report
  243. Cerating new record using ADO
  244. Jet Database could not find Export file
  245. Linking linked SQL tables to back-end
  246. Access 2000 First record of report preceeded by blank record
  247. ErrorTable/Log
  248. Is there a way to display alternate text in a text box if field is empty
  249. Create Query / Make Table with YYYY
  250. Forcing Uppercase
  251. Selection - Combo Boxes
  252. Getting Trusted Connection log on when not wanted
  253. Still able to link to a secured DB
  254. Converting Access OleObject images back into native format
  255. Can Access support ASP transactions?
  256. Easy combo box question
  257. Jet40 SP8 and Access W2K3
  258. Follow Hyperlink leaves the MS Access Window large
  259. Simple self-updating calendar in form
  260. How can I determine filetype/extension of files stored in OLE fields?
  261. Blank Form
  262. Subforms into forms
  263. ODE tools installation
  264. MSINET control - installation/setup hitches
  265. Greyed out Tools, References option in VBA
  266. Clipboard Message On Database Close
  267. !!FAQ! for Date: 20031027 - New Users Look Here! [Last Updated July 24, 2002]
  268. Connect to web database
  269. AutoNumber filling in gaps
  270. SQL Update query
  271. Problem - absolute path to linked tables
  272. Whats missing from range of licenses?
  273. Out of Memory Access95 error in WinXP
  274. Read specific field of specific record
  275. ADODB.Recordset - referring to a field
  276. Counting specific Week days
  277. Konversonsproblem von 2002 auf 2000
  278. Access Booking System
  279. Windows RUN entry through Access VBA
  280. Improving my schema
  281. Unrecognised Database Format
  282. Problems with group and report footer
  283. Database Design
  284. Query to search for all records based on combo box
  285. Help required on Access SQL queries
  286. help finding bad record in query
  287. OpenForm Action was Cancelled - Disable this msg !
  288. Progamatically change directory to insert hyperlink from
  289. Database window
  290. Open specific spreadsheet from Access
  291. Using acCmdOLEDDELinks to update Excel object in an Access Report
  292. Null fields
  293. ODBC Connection Timeout
  294. check for duplicates
  295. Visual Basic Command Reference Information
  296. Custom error numbers/messages tip
  297. Copying to clipboard
  298. MS Access - Email Automation stops
  299. Copying to clipboard
  300. Make Table Query HELP & Append only 1 ID
  301. ODBC Sage Line 100
  302. Relating Tables in a database automatically
  303. How to build this field expression
  304. !!FAQ! for Date: 20031026 - New Users Look Here! [Last Updated July 24, 2002]
  305. Index does not work properly!
  306. Controlling Paper Size
  307. email automation
  308. Query Questioin
  309. Complex label question
  310. cmdButton to Print 3 copies of record in Form view ?
  311. Converting query from Access to ADP
  312. Percent Data Entry in Table?
  313. How to email a file using the DoCmd.sendobject
  314. !!FAQ! for Date: 20031025 - New Users Look Here! [Last Updated July 24, 2002]
  315. Opening a jpg file. Code from Lebans
  316. TransferText and Runtime Error 3011 (solved)
  317. Data Access Page Capability Question?
  318. Urgent,Plz help me .......need to calculate the total of a field in subreport.
  319. seeing data access page in web(intenet)
  320. Can I embed pictures?
  321. Microsoft Visual Studio Tools for the Microsoft Office System 2003
  322. microsoft access
  323. MSACCESS.EXE - Application Error
  324. How to Make a backup of the databse
  325. MS Access export to text file decimal round off problem
  326. update query from vba
  327. Saving last TransactionID to another table
  328. Locking a Database
  329. using the combo box with a button
  330. Access XP weirdness ...
  331. Show All Data in a Field
  332. Update 1999 db - it has NO relationships
  333. !!FAQ! for Date: 20031024 - New Users Look Here! [Last Updated July 24, 2002]
  334. Urgent ... Access 97/2000/XP on Win2k w/Terminal Services
  335. Reports....another question!
  336. Saving Last TransactionID in another table
  337. Error when Adding Record to Linked Subform
  338. HTML Page text box properties
  339. Connecting a form to a calendar
  340. SendObject Woes
  341. SendObject Woes
  342. Import Date field
  343. Labels Starting Position
  344. URGENT: Access another app and sendkeys
  345. Query help
  346. Access database help
  347. VB prob - calling functions
  348. Urgent,Plz help me .......need to calculate the total of a field in subreport.
  349. PLease HElp #2 from pulling up record
  350. FW: Check the patch from MS Corporation
  351. Populating table field
  352. Automatically changing dates
  353. I have about 300+ pieces of data representing wood shingle widths from random run-of-the-mill batches... how can I show a bell curve in Access???
  354. narrow search as you type
  355. Date Problem - How to identify working days only
  356. Automaticaal Enter A Value In A Field
  357. drawing in forms
  358. Problem editing memo data in a text field in a Form
  359. Access 2000 Import Specifications defy logic
  360. Mac Version
  361. MsgBox if Checkbox IsNull
  362. table structure
  363. sorting text in numeric order
  364. DoCmd.OpenQuery and error trapping
  365. Text Import Problem (Quoted Identifier and Comma-delimited)
  366. Access messes up my system Please Help
  367. report in access
  368. access database
  369. PLease Help: Pulling up a particular record using a form
  370. Access Database to Executable File
  371. Linking to image does not "stick"
  372. How to identify the control that has focus?
  373. !!FAQ! for Date: 20031023 - New Users Look Here! [Last Updated July 24, 2002]
  374. Reports
  375. Back end privileges
  376. Hmmm, installation
  377. Access 2000 Subform Dataview Scrollbar scrolls too far
  378. Display method for GroupWise message
  379. Lookup Date in Another Table
  380. Using the RunApp Macro Command
  381. ADO Connection.Open fails
  382. Making a FORM Read Only
  383. data access pages
  384. Report textbox height after CanGrow has been activated
  385. Image path in Access 2000 database; want to display photo in form and on web
  386. Space between fields
  387. query calculation
  388. Printing current record
  389. How to pass trough form-variable, querydef-variable...
  390. saving prtdevmode in table
  391. Email mit HTML Tags durch SendObject erzeugen
  392. Combo Box - Storing Results
  393. Query Documenting Code
  394. Need Your Guys Help With A Query
  395. Subform in Datasheet view question
  396. Unbound Control and AllowEdit = False
  397. database crash
  398. Placing points on a map based on ZIP Code
  399. Table fileds Vs Records
  400. Programatically Update Multiple Tables from one entry Form
  401. will References stick in an MDE?
  402. Dynamic Subreport Size
  403. Referring to properties
  404. How to link a form from one database to another
  405. Auto Capitalization in VBA Editor - WHY?
  406. Username
  407. Requerying a ListBox upon returning from a modal form
  408. Help with SQL Query
  409. Minimum
  410. hoe facturen maken in Access 2002 ?
  411. Moved from Win 2000 to Win XP and receive Class Not Registered error
  412. !!FAQ! for Date: 20031022 - New Users Look Here! [Last Updated July 24, 2002]
  413. Exporting Pictures to .rtf
  414. Function to retrieve domain name for an IP address?
  415. Monitoring ACCESS 2000 tables for changes
  416. How to import/map excel table data to access table data?????
  417. How to import/mpa excel table to access table????
  418. date function in access97
  419. Where to look for textbox background color change at runtime
  420. Problem with rounding in MS-Access 2003
  421. Required Parameters for a command object
  422. Can you transfer custom menus/toolbars
  423. Position a list to a record?
  424. Locking Tables Against Edits
  425. Requery failure causing GPF in MSAccess.exe- is this a known bug? Is there a fix/
  426. Nested/Subquery assistance
  427. Access not regognize field value change when its calculated by VB
  428. Access or FoxPro?
  429. New Keyword: Instance of Form as SubForm & Form
  430. Best source for tips
  431. Q: Use a temp table for a single field or ?
  432. testing post
  433. Running meterage totals
  434. Rst.FindNext Loop
  435. Command Line Switch Password
  436. Database Help
  437. phantom querydef
  438. fEnumDomainUsers and LDB Viewing on 97 split DB w/ distributed FE
  439. Subform
  440. Concatenate text files
  441. Data entry to multiple tables
  442. Query to Replace Columns
  443. access 97 : command button question
  444. Check for user name already in secure database
  445. Looking for alternative to Look-up tables fields.
  446. Text disappearing from combo box
  447. Using the Same Form for Multiple Queries
  448. Changing access record to horizontal output
  449. User-defined type not defined
  450. Query won't pull amounts less than zero
  451. Combo Box Problem when Apostrophe in Text String
  452. Filter by Form... but only for Subform
  453. Memo field truncated in query/report?
  454. Link to objects in an mdb with a non-"mdb" extension
  455. How do I create an In-Statement in MS Access using records from a table?
  456. !!FAQ! for Date: 20031021 - New Users Look Here! [Last Updated July 24, 2002]
  457. problem with updating database
  458. Access 2000 - Queries in code - ADO or DAO
  459. Output Report to Word
  460. access, the right choice for a new project?
  461. Appending Tables in Access
  462. calculating month end returns in expressions???
  463. Use VBA to insert a new record in a subform?
  464. Compacting a database on close
  465. Allen Browne's Access Tips - change of address
  466. Access 97 on Win 2000
  467. Can't Decipher Unusual Autonumber Scheme
  468. Repost: Attachments to Outlook Express possible?
  469. Report TimeOut
  470. Balance
  471. MS Query
  472. count
  473. Access 2000 Split Database Performance issues.
  474. Macro to save query as Excel file
  475. MS Query - STANDARD DATE to YEAR-MONTH and WEEK
  476. Could Not Update; Currently Locked
  477. Shortcut menu change problems in A2K
  478. seperating the salestax field in the ACCESS XP's wizard gen. orderentry db [will pay $ for a fix]
  479. Automagically add a field to a table
  480. Button to Send an Email to Group(s)
  481. help with check boxes
  482. Printing rowsources of all Reports. "Document" type not recognized
  483. Relationship question.
  484. Username and Password for Tracking Purposes
  485. Detect which drive is a Zip drive programatically
  486. Converting to 2002. Problems with RunCommand.Find
  487. DB question ... thanks
  488. validating Dates and Times
  489. Suppressin DIV/0 in Access reports
  490. !!FAQ! for Date: 20031020 - New Users Look Here! [Last Updated July 24, 2002]
  491. Repairing Access 2000 mdb hangs the utilites.
  492. Small syntactical error
  493. Doesn't compile
  494. Access Exclusively opened by another user
  495. Case sensetive query
  496. Admins Member receives error 3033
  497. Workgroup specification dilemma
  498. Forbid closing a Form
  499. Access Runtime Error with Switchboard on Some computers
  500. Updating recordset for a subform
  501. Printing Label Problem
  502. parameter query passed from a form with wildcards
  503. Expanding memo field to larger form
  504. Corrupted or Language Problem Access 2000 Database?
  505. Print Last Page of a Report
  506. Access 2000 Linked to SQL Server 2000, openRecordset error
  507. need some suggestion.. am a new user of access
  508. list box double click
  509. Access97 & Access2K
  510. Attn Bob Quintal
  511. Unused Objects
  512. anybody know why "Dim db As Database" won't compile????
  513. *** Access Programmer Available ***
  514. Passing comparison criteria and listbox questions
  515. DAO problem
  516. Two autonumber fields
  517. Link Table to expanding Text file in Access
  518. convert Access 2000 db back to Access 97
  519. Database password as parameter
  520. Combo Selection / Filter
  521. Ideas for tables
  522. Urgent Recordset problem
  523. !!FAQ! for Date: 20031019 - New Users Look Here! [Last Updated July 24, 2002]
  524. problem with sql
  525. Open Word File using Dir Function
  526. Copy and Paste in field names
  527. paragraph key in memo field
  528. Average Problems
  529. Barcode Reader and Caps lock
  530. Create Subform in VBA
  531. Programming Access mail merge to Word
  532. Dir Function
  533. Extra SUM in query
  534. access project
  535. Runtime Access problem...
  536. importing dbaseiii records
  537. Retrieving records deleted from table
  538. NotInList event adds records twice
  539. Global variables? Transfer selected fields to unrelated form
  540. SQL syntax for Null?
  541. Importing
  542. Can I query max data for three time frames daily for a month?
  543. How to use "Insert Into" to programatically insert multiple fields into a table
  544. Outlook attachment
  545. Storing large amounts of text
  546. !!FAQ! for Date: 20031018 - New Users Look Here! [Last Updated July 24, 2002]
  547. searching by ADO
  548. Sql recordsource from a subform
  549. ADO Recordset: Fields Shifted?
  550. Error 3251, Recordsets !@#$%^&*()