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. Control Label
  2. Resizing Images then saving
  3. Treatise on Tree Control 6.0?
  4. Line Return
  5. 1:1 Relationships: RI Enforcement/Cascading Deletes?
  6. Update a Field from another table
  7. !!FAQ! for Date: 20031227 - New Users Look Here! [Last Updated November 30, 2003]
  8. How to make all negative values positive?
  9. Help with this Error Message
  10. cancel if no records
  11. SQL Insert question
  12. Finding Latest Record for an Associate
  13. Calculating Dates
  14. #Delete
  15. Line Returns
  16. Public Variable- Why doesnt this work?
  17. Subform popup (shortcut) menus
  18. Subform header in Datasheet view
  19. Properties problem: .Text and .Value do not capitalize
  20. Open Report filtering from a listbox
  21. Delete
  22. Changing MS Login ID on-the-fly?
  23. Create a new Form from based on a 'Filter By Selection'
  24. Selecting Users from a list when running a report
  25. !!FAQ! for Date: 20031226 - New Users Look Here! [Last Updated November 30, 2003]
  26. DMin Function
  27. Write to LPT
  28. Performance problem in one form only
  29. =Sum #Error
  30. I'm trying to list controls in immediate window... what's wrong with this code?
  31. Duplicating record
  32. !!FAQ! for Date: 20031225 - New Users Look Here! [Last Updated November 30, 2003]
  33. Access 2002: problem in VB function
  34. Finding dates from a query
  35. Combobox
  36. Invoice numbering
  37. !!FAQ! for Date: 20031224 - New Users Look Here! [Last Updated November 30, 2003]
  38. Replication/Synchronisation failure
  39. MsgBox won't close.
  40. Query Description Entry
  41. A single child changed the world!
  42. Combo box LimitToList property setting of No - I still get MS Access error...
  43. Changing Query Reference Table Names without rebuilding query
  44. IsNull
  45. Search an encrypted database and display results
  46. Access 2002: Call VB module from reports
  47. Metaphone source code
  48. Find and Replace Strings in Access: New Version
  49. Upsizing wizard
  50. $0.00 inserted into Currency field
  51. Worlds Dumbest Question!
  52. Is this feasible?
  53. Code: Private Sub help
  54. web database...
  55. Difference between rows
  56. Simple text file creation
  57. !!FAQ! for Date: 20031223 - New Users Look Here! [Last Updated November 30, 2003]
  58. importing accented DOS chars
  59. Update a record
  60. Double Click on a Record in a Subform to Open that record in a new form.
  61. Query-Generated report
  62. tab control inside another tab control
  63. Life with Different Versions of Access
  64. PLC programmeurs gevraagd
  65. print out problem
  66. Input Box Fails to Cancel
  67. combo box doesnt save
  68. Date Filter
  69. How to use VBA to delete files?
  70. OT. Is anyone running Access with the Linux OS?
  71. Referring to controls in Modules
  72. OT. Remote access of your Access app over the web
  73. access97 runtime error 3075 missing operator
  74. Determining screen resolution in a procedure?
  75. MS Access & SQL Database for JPEGS
  76. The "database" object type missing in Access 2002
  77. !!FAQ! for Date: 20031222 - New Users Look Here! [Last Updated November 30, 2003]
  78. Relation
  79. Simple code to delete all rcd in a table and import records to same table
  80. Combining multiple tables into one table
  81. MSDE - security issues while on cable modem?
  82. Is Access consistent with the order of events when opening a form from within a procedure?
  83. Access97 to WinXP from Win98
  84. Code for Filtering from Mult-select List Box Criteria
  85. OLE Server and ActiveX control
  86. Query in VB to Validate data
  87. advanced search functions (for photo database)?
  88. A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
  89. Error 3021 no current record access 2000
  90. Coldfusion and Access and Field Names (It ain't Paradox)
  91. Windows 2000 Server and Access 2000 constant corruption
  92. Windows 2000 Server and Acess 2000 constant corruption
  93. Subforms & Counting
  94. Table efficiency
  95. how to record invoice printed
  96. looping through all records with VBA
  97. Need Help with Package and Deployment in Office XP Developer (replace - always, older files, never)
  98. Report Preview
  99. Attn MGFoster
  100. #Name Error in Linked Combo Box Field in Printed Report
  101. !!FAQ! for Date: 20031221 - New Users Look Here! [Last Updated November 30, 2003]
  102. <<HELP>> First level support for ms database
  103. Skinning Access forms
  104. Datensatz finden in Unterformularen
  105. Sharing across Win platforms
  106. how to set focus on a report control?
  107. Dsum , using numeric & Text help with the Text bit!
  108. Dsum , using Numeric and Text fields ????
  109. How to access an MS Graph Object on a report
  110. What is future of MS Access?
  111. Enter New Data In Comboboxes Only
  112. How to count records selected in subform datasheet?
  113. Move to next control in Form after pressing Enter?
  114. importing trouble with my access '97 D-base in access 2002 D-base format
  115. This is my problem......
  116. How do I pass a field name to a function?
  117. !!FAQ! for Date: 20031220 - New Users Look Here! [Last Updated November 30, 2003]
  118. Advantages of moving to most current version of Access?
  119. How to use InStr Function to get hyperlink display text?
  120. Forms and the Switchboard
  121. ChkBox and TxtBox Problem
  122. dialog box with no border? (access xp)
  123. Error 2448 does not make sense in the context of the problem
  124. sql help - should be simple, but can't get it.
  125. Report by hour / day
  126. Passing Values to Parameter Query
  127. Re Disappearing forms!
  128. Save data entered when using [enter a value:] in SQL
  129. Access problem
  130. Parameter Query
  131. How to hide tables from the Import Wizard
  132. Disappearing forms!
  133. Please Help Passing Variable from Form to Query
  134. !!FAQ! for Date: 20031219 - New Users Look Here! [Last Updated November 30, 2003]
  135. wanted: database publishing tool for MS Access
  136. Setting Controls from a Table in Access 97
  137. Shrink the size of a field
  138. Check Box Size
  139. Duplicate values
  140. Screen Preview differs from Print Out
  141. How to pass multiple arguments when calling Function?
  142. Trouble with Access Like Query in ASP
  143. Update a Form Field
  144. urgent : access sub-reports as popup
  145. Spaces in Field Names?
  146. Find Front End
  147. Automating queries by using a reference date.
  148. Moving data to SQL Server
  149. Access 97 on PC with more than 1 GB of RAM (Terminal Server)
  150. Problems with Access XP and SQL Server
  151. Memo datatype got trucated
  152. I want to make a web interface for my database...
  153. DllRegisterServer in MSFLXGRD.OCX failed
  154. SQL: INSERT INTO without specifying any column
  155. 100 Day Statistics for comp.databases.ms-access
  156. Statistics for comp.databases.ms-access
  157. Access Word 2003 Automation
  158. need help with vertical (columnar) datasheets
  159. Time-keeping with Access 2000
  160. Access 97 Database converted to Access 2000 - Controls do not work
  161. PivotTable date groupings
  162. emailing from a form
  163. Application Icon Location
  164. Viewing table as subform and seeing linked items
  165. Call query design view from code
  166. When does Does "On Open" execute?
  167. Passing Discontinuous Range (Array) of Values to User-Defined Function
  168. Iif Statement Returns Error in Form
  169. Send a draft message to mailing list
  170. multiple append queries using VBA
  171. !!FAQ! for Date: 20031218 - New Users Look Here! [Last Updated November 30, 2003]
  172. Importing Tables from SQL Server to Access with Keys and Indices preserved
  173. Searching for the right word to encompass 'Supplier' and 'Consumer'
  174. Automating queries by using a reference date.
  175. Is 2.3 MB too big for a simple database?
  176. Selecting from Text File Truncates String
  177. Is this possible?
  178. 255 Column Limit using Microsoft Access
  179. Selecting from Text File Truncates Long Strings
  180. Get the name of the function or sub from within code?
  181. Non-Duplicate List Of Products
  182. Display date with 4 digit year
  183. update combo box
  184. Access 2002: Replication question
  185. Stephen LeBans JustiDirect text justification
  186. Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
  187. Larry, for you . . .
  188. Save a record programmatically from a form's module
  189. Updating Linked Table - why is action query failing?
  190. Can't update a recordset after filtering
  191. Update Inventory
  192. One customer gets #error
  193. Determining where a control is on a form; header, detail, or footer
  194. Conditional state of a record
  195. VB - Question for OpenForm Criteria
  196. Assistance needed with a small piece of code
  197. The Paperless Office is Now!
  198. No $ for Currency fields
  199. How do I?
  200. Populate control in another form
  201. Redemption Not Blocking Latest Security Prompt
  202. Acc 97, expressions
  203. SQL - joining 5 tables - not all records retrieved
  204. help with unbound fields
  205. !!FAQ! for Date: 20031217 - New Users Look Here! [Last Updated November 30, 2003]
  206. Paste Into A Combo Box
  207. Tabellen von verschiedenen DBs in eine DB kopieren
  208. Combo Box inital value to display
  209. DateValue
  210. What this query return ERROR?? :(
  211. Access 2002: Bar code problem
  212. Get the name or HelpContextID of a Toolbar Object?
  213. Problem retrieving printer information for this object
  214. Help: batch method to get .MDB table names ???
  215. A2K2 AllowAdditions
  216. Cannot import .xls file (Access 2k)
  217. Problem with Check Box use to Change Field Values
  218. Struggling with linked database problem
  219. Labels Dialog Box Enhancement
  220. Justdirect text justification
  221. Control Of What Is Printed In Page Footer
  222. Register a dll
  223. addresses
  224. I'm rusty on my Access...can anyone help with a Query question?
  225. Viewing linked entries in a subform
  226. How to loop through a record set.....?
  227. Problem Duplicating Forms in Access 2000
  228. Modifying an import specification doesn't work.
  229. Best way to handle distributing runtime installables from the web??? (slightly O.T.)
  230. Is there a trick to not have a cross-tab query sort the column headings?
  231. how I protect my DB with serial number disk?
  232. Report in Access project
  233. The above post is a forgery. Ignore
  234. MetaData Repository Standards?
  235. Parameter Value in IIF
  236. Using access to complete company forms
  237. problem with my code
  238. Sync Access with Palm PDA
  239. Adding a New Field to an existing Form
  240. Double Merge in a Access Report Possible??
  241. Getting User Name form Login (System enviroment variable?)
  242. A97: Get the month, day, and year from a date field in a table
  243. concatenated form fields
  244. !!FAQ! for Date: 20031216 - New Users Look Here! [Last Updated November 30, 2003]
  245. The IsNull function requires 2 arguments
  246. Help with DCount function and filter
  247. Lookup field created with VBA ?
  248. Protecting your work
  249. Access 2003 pivot-table view gone?!?
  250. form field validation
  251. MSFT Access Unable to create MDE
  252. Iterate through all queries in database and set description
  253. Using Access with LDAP
  254. labelling
  255. Filter Sort Wild Card?
  256. A97 - Detect Idle Time
  257. How do you create a Report or query for the # last days?
  258. Date field
  259. Access 2002: Updating 2 same database
  260. Group total in distinct field
  261. Copy field with DoCmd
  262. Changing field types with Excel as linked table
  263. Can I use VBA to import/link tables?
  264. SQL INSERT INTO a table using information from two other tables
  265. Possible fix for Pivot Table grayed out or no row or column sight problem in Access 2002 XP
  266. Uninstall
  267. Access 2000 - Use ADO.Recordset as Report Recordsource
  268. Replace text in a field?
  269. Go To Current Record
  270. How to Lock and Hide Access Tables?
  271. Creating report using ASP with MS-Access
  272. Beginner: Open Main Switchboard Item in Datasheet view?
  273. Do NOT click on ANY URL's posted in CDMA
  274. changing a form to a subform (VB problems)
  275. BEWARE LINKS POSTED FROM SODOMIZERS!
  276. Access 97 Complication
  277. How to merge two distinct records into a single record?
  278. Alternative row color with a sub report
  279. Text Box Assistance
  280. Access freezing while printing
  281. Changing Colors of fields on a report
  282. Beginner: Mde error- couldn't make changes
  283. Any way to record the progress of a query while it is running in Access 2000?
  284. Finding Login Name for a Group Login
  285. !!FAQ! for Date: 20031215 - New Users Look Here! [Last Updated November 30, 2003]
  286. Database window appears when it should not!
  287. Access Run Time: Alternative Version
  288. foxpro compared to access......can they do the same thing
  289. records in report disappear after design viewing
  290. FTP with Login and Password - what is wrong with this?
  291. Problem with DoCmd.OpenForm
  292. Dialog Box Not Dialogging
  293. parameter query
  294. Connect to back end for non logged on user
  295. Relationships and Cascading Updates problem
  296. Relationships
  297. Display of Menu bar while access is starting
  298. Table column is automatically populating itself
  299. SQL utility form for Access
  300. <<HELP>> Getting rid of part of a text field
  301. One Step Merge Document and E-Mail to a Group
  302. Update MS Access table from another table
  303. BEWARE LINKS POSTED FROM ANONYMIZERS!
  304. Subreport question
  305. How to: Filter Against Fields
  306. Access 2000 Missing Wizards
  307. Invalid Procedure Call or Argument (Left, Mid, etc.)
  308. !!FAQ! for Date: 20031214 - New Users Look Here! [Last Updated November 30, 2003]
  309. Problem retrieving printer information
  310. How to SELECT hyperlink.htm FROM table?
  311. Error on opening a database: MS JEt database says someone tries to modify the file
  312. Use Access 97 or Access 2003
  313. Do I use Nz
  314. Access & system settings
  315. Error on opening a database: MS JEt database says someone tries to modify the file
  316. Sample files
  317. updating/adding to another table
  318. Send email - capture ProfileName from MAPI
  319. Microsoft Access license to distribute runtime components
  320. Get actual text of error trapped by Form_Error?
  321. Quieres ganar dinero extra para pagar tus deudas lee esto......
  322. Different Versions of Access on Same Computer
  323. a2k - weird code behaviour I can't explain...
  324. Updating Yes/No Fields !
  325. Time formats
  326. MS Access '97 and MS-Office XP-SBE, would it work?
  327. Parsing some text data into records...
  328. update blank table record field
  329. Forms and Form
  330. !!FAQ! for Date: 20031213 - New Users Look Here! [Last Updated November 30, 2003]
  331. Report Writer question: can I do a "top ten"
  332. Re-entering combo boxes
  333. Beginner: Can a form edit identical data from more than one table?
  334. Installer problems
  335. Save files attached to an email
  336. Access data through MS query in Excel.
  337. The meaning of "Me!"
  338. Sudden shut down when saving a Query
  339. make modules and tables invisible bt code
  340. Office 2000/XP Menu items
  341. Another SQL Question - Update Value with Column Name
  342. Referring to a variable field using SQL
  343. Calling Procedure on other form
  344. Log user on opening
  345. Specifications - limit on # of rows?
  346. Help with Access XP Error 2001 "You canceled the previous operation"
  347. Outlook automation from Access?
  348. Printing a Word Document from ACCESS
  349. Opening the main toolbar in VBA
  350. PHONY FAQ
  351. Problem w/MSINET.OCX in Acc97 runtime
  352. Saving Email Attachments To A Folder
  353. Run time error, "The data has been changed."
  354. Listboxes
  355. Access and Calendars
  356. Close report without save prompt after setting input parameters
  357. !!FAQ! for Date: 20031212 - New Users Look Here! [Last Updated November 30, 2003]
  358. [vba] looping through an array
  359. Access Service Patch version thru VBA
  360. How Do I create a new record from an existing record
  361. DHL or FedEx Track Links in SendObject Body For outlook?
  362. File Open Dialog Box
  363. Dim MyDbs As Database
  364. How to calculate time duration?
  365. Replacing data in a table WITHOUT changing the numbers created from a running sum..
  366. Call One Access Application from Another
  367. Text Files
  368. ODBC call-failed error
  369. VBA Code learner Please Help
  370. Help on Access... 2.0! Really! And on 2003...
  371. Help on Access... 2.0! Really! And on 2003...
  372. help with combo box requery
  373. Using an Access app without Access?
  374. Column Names
  375. Conflicting Versions
  376. Another database bloat question.
  377. Imorting Excel sheets e-mail attachments
  378. Time stamping on a network with no dedicated servers
  379. CompactDatabase fails with Invalid Argument error
  380. Printer/Page setting disappear when front end MDB copied to another PC
  381. Data Input Database Design Help
  382. OutputTo Macro problems...
  383. Freeze Columns
  384. multiple user access on shared network drive possible?
  385. Field type with greater than, less than signs
  386. Intellisense Window Closes too Quickly
  387. Corrupted file A2002 ???
  388. Subform and button on parentform
  389. Something to be said for a moderated newsgroup
  390. Select top 100 from table1 does not work? Is there another syntax?
  391. Show if a parent record has a child record.
  392. Sequential numbering
  393. Creating a Query in VB
  394. CPU Type in Access VBA?
  395. Tool for finding references to and from tables/queries/reports/forms/objects
  396. URGENT--PLEASE HELP
  397. Secure Database Object
  398. Do Loop provides incomplete data
  399. !!FAQ! for Date: 20031211 - New Users Look Here! [Last Updated November 30, 2003]
  400. Web based reporting software?
  401. Turn off the Office Assistant through Access VBA
  402. Removing Security?
  403. How do I do this?
  404. Out of memory error Access 97/XP Home with > 512 megs of RAM
  405. Assigning a value to a "Form" variable: Dim vFrm as Form
  406. Using import/export specs with ADP projects
  407. Word Automation
  408. I need help!
  409. Use the File Open Browse box
  410. Automating the import of an OLE object
  411. How to save variable values for future use?
  412. Access Virgin!! please help
  413. Access 2002: Selecting necessary data from several tables
  414. view result differs from the result in SQL Server
  415. Update Your Front End on the Network Easily
  416. Query speed anomaly
  417. Ms Access Database to web page
  418. Why does UPDATE query change data type?
  419. use of autonumber
  420. Auto fleet manager
  421. SQL statement problems
  422. Cleanup with Erase after Split?
  423. Jet or MSDE
  424. Query syntax, can it be better than Paradox?
  425. print preview problem
  426. App name ideas
  427. Count in Access
  428. Setting control properties
  429. Error Handler best practices
  430. Microsoft Oracle ODBC
  431. Finding Links that are not in Links Window
  432. problem with creating a duration field
  433. Q: Regarding back-ends, is it better to have one or several linked dbs?
  434. Sort Order in SubForm, Access 97
  435. Access 2000: Forms -- Getting a form/subform linked properly
  436. Shared network database
  437. Display weekday name of the date entered
  438. Multiple Record Sources
  439. Birthday Report
  440. Shared database
  441. help with display day(date)
  442. application developer required
  443. Automating report in a different MDB ( Question #2 )
  444. Ffield Size Problem
  445. Printing forms
  446. Subreports / Reports with Multiple Detail Sections
  447. error on inserting records to subform
  448. Send a pop up box behind a report
  449. DAO efficiency question
  450. Snapshots -vs- .pdfs
  451. Access 2000 Developer Tools
  452. Create report from Crosstab query w/dates as column headings
  453. Change cursor position of active control
  454. bank sort code issue
  455. Passing trough table
  456. error 3464 Data type mismatch error!! ??
  457. Changing the data type of a field in a table thru code
  458. Access Help
  459. How to add index with CreateIndex ?
  460. table name with spaces in RunSQL instruction
  461. Calculating Rows
  462. Query based on a Complete Field in a Table
  463. Unix Time
  464. error message!
  465. The images of boys' bare butts stayed with me as fantasy material for
  466. Data can't be saved to the field
  467. Simulating Combo Box AutoScroll on a subform list?
  468. GIVE IT UP DON MELLON
  469. Does Access know WebDAV?
  470. Error when executing SQL statment
  471. Problem with the mouse scroller
  472. Apply ValidationRule Before Update Method
  473. Text Box Formatting Based on Data
  474. sequential numbers
  475. !!FAQ! for Date: 20031209 - New Users Look Here! [Last Updated November 30, 2003]
  476. Compatibility Access 2000 and 97
  477. Compatibility Access 2000 and 97
  478. Access 2000 Distributing
  479. Access 2000 Redistributing
  480. Problem in programming waiting list for day care database
  481. REQ: Question about access. Please read inside. Thanks.
  482. A97 Graph question
  483. function calling
  484. Deleting in vba code
  485. a2k - real quick help needed on report printing out too many times
  486. system.mdw/default/secured mdw etc.
  487. Mystery bat file - A97
  488. How to get number of servers attached
  489. Navigating between forms, flickering
  490. update table
  491. Problem with Validate rule and Combo-box
  492. sql statement wildcard in fieldname
  493. Many 2 many forms. Shirfting data from 1 listbox to another ...
  494. How to move to specific record in Datasheet?
  495. Help - Unable to use ADO recordset as Form's Recordset
  496. OLE to Store Outlook EMail Objects in Access
  497. Access query fails if run through ODBC
  498. Change backgroud color for record listed in subform in continuous mode
  499. VBA - ACCESS 2000
  500. Copying permissions to a newly created mdb file
  501. How to not trigger dirty event when initializing control on form through VB?
  502. Programmatically identifying event properties
  503. Formatting data within a text box
  504. Substituting a variable in a form control
  505. Open Form from external database
  506. Adding current time in field with toggle button
  507. replication
  508. Calculationg & Avg time in a report
  509. Database to a:\
  510. Table entry from combo box
  511. try it in english maybe i am more lucky
  512. Empty lines in report
  513. why does that thing doesn't work??????,
  514. Emailing pages of report
  515. !!FAQ! for Date: 20031208 - New Users Look Here! [Last Updated November 30, 2003]
  516. Access : VBA
  517. a2k - graphics with transparency
  518. The beloved David Fenton in his own words
  519. Replication Manager
  520. Enforce rules with code or database design?
  521. Is it possible to switch content in a field upon choosing a certain field?
  522. record is not moving to next record on the dropdownlist
  523. How to convert Text dates to Date format?
  524. changing font color within column on form
  525. SQL statment for muliplie tables including the count function .
  526. Access wizards
  527. error when selecting data from the dropdown list
  528. Subreport Totals
  529. AddNew - Pocket PC
  530. Install that update from the Microsoft Corporation
  531. Default query parameter values
  532. AddNew from table A into table B - Pocket Access
  533. Finding records by date range?
  534. OpenRecordSet ...
  535. Importing only NEW RECORDs in MS-Access!
  536. byPass Shift Key in Access 2002
  537. Listbox does not allow me to detect a null value
  538. Report with a Control Filter?
  539. version?
  540. a2k - irritating RI message
  541. Conversion from Access 97 - 2000
  542. Conversion from Access 97 to 2000
  543. 2nd repost: Auto FE-Utility Access 2.0
  544. David Fenton is a valued member of this newsgroup
  545. Update txtbox with value from listbox
  546. Compact on Open
  547. !!FAQ! for Date: 20031207 - New Users Look Here! [Last Updated November 30, 2003]
  548. Hiding Group Footers & Headers
  549. Validation rule trouble - ensuring values held in one field are less than those held in another field
  550. Automatically Updating data end of month