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