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 122

  1. How hard is it to convert an Access mdb to SQL Server?
  2. How to add multiple records with a form/subform?
  3. Problem - boolean value changes in record on form close.
  4. Help with conecction please
  5. MS Access 97 error
  6. Importing Toolbars
  7. self executable
  8. Deploying a .mdb without installing access
  9. Run-Time Error 2501
  10. Maybe a stupid question
  11. When to use 1:1 relationships?
  12. Selection In A Textbox
  13. Table field increments - don't want it to.
  14. Need to make a report from a value on Form
  15. Can't stop the query? Strange DLL error
  16. display a message box
  17. access 97: insert into and multiple records of the same loan problems
  18. automatically assign a value based on another value
  19. How to define a loop 2
  20. How to define a loop
  21. Help with UPDATE query
  22. when to quote variable values?
  23. Long String
  24. Changing Hour/Min/AM-PM
  25. Spin Buttons
  26. Dialog Box Problem
  27. Listbox Positioning
  28. A big thanks to you Guys from DD/Dialog Box Prob Solved
  29. Access and Adobe Distiller
  30. can I access a form in an mdb from another mdb
  31. SQL-Server <-> A97 Write conflict error!
  32. Report Print Event and Docmd.Sendobject
  33. Counting Files in a folder
  34. access 2003 problem w/ combo box query after return from modal form
  35. Subform that reverses master/child relationship?
  36. Browse for Folder, I am still missing something
  37. Main Form Text Box Referencing a Subform Field
  38. Conflict viewer says there are conflicts, but shows no tables
  39. Adding Employee comments
  40. Printing with mobile db
  41. Two Digit Year
  42. A good reason to use ADP's
  43. Label Position for a 3-D Chart.
  44. Dates and week numbers
  45. Format form/report records
  46. Update not seen in subsequent query
  47. Old ms-access file, showing wrong text in access xp
  48. Common Dialog assistance in the Online Help Files
  49. Removing Duplicate Data Problem..!
  50. Field can't be updated
  51. Locked table, err 3197
  52. Referencing a subform control for email
  53. comp.databases.ms-access stats thru 11/30/2003
  54. how to check date ?
  55. Problems with browse to files using an API call
  56. Continuos form format
  57. How terminate objects cleanly when access close ?
  58. How to obtain field describtion with code
  59. Automatically updated inventory
  60. Import text file
  61. How to use expression in conditional formatting?
  62. Advance Browse for Folders Dialog
  63. Strange Access 97 Behavior in Displaying Images
  64. Can't Open VB Editor and VB scrip won't run AFTER reopening database
  65. Windows XP Will Not Allow Output To Action
  66. Copy Access database
  67. Before MS makes programs try to think for us, ...
  68. Why doesn't OutputTo Method prompt for format?
  69. Customizing Navigation Bar
  70. Browse for Folders Dialog
  71. Replication of access db
  72. Replication of acess db
  73. Can't find syntax error in Access query - lost!
  74. Delete Query-Identifying the table with records for deletion
  75. currency to text
  76. Setting font size of text box in VBA
  77. Memo Fields via a webpage/upload images?
  78. Don't display the: "The OpenReport action was canceled" message box.
  79. Sql Query Question
  80. Time
  81. Available Access References
  82. I need help with my school project
  83. Can you install the Jet Engine in c:\windows\system in WinXP
  84. Auto number after a look up
  85. Can OutputTo append?
  86. testing
  87. query problem
  88. Placing jpgs (photos) in my A2K database
  89. Hierachical structures - an overview
  90. Run time error 3061
  91. ADP issue with navigating to record using rs.Bookmark
  92. Wierd error on starting proven A2K App.
  93. Changing one field in an updateable query to a new value on a form--without querying
  94. Custom Collection
  95. Deleting via a query with a join in it?
  96. Please help
  97. How to "unlock" table in error handler routine?
  98. the dirty form!
  99. Please help: Query uses _old_ value, but I am using _AfterUpdate_
  100. test
  101. User Input Validation - Data Checking
  102. undo icon on menu bar not accessible from a dialog form - why ?
  103. Requery won't update unbound field calculations - advice please
  104. RecordExit Event
  105. Check out this critical package for Microsoft Internet Explorer
  106. Error in Pace Calculation
  107. select statement not working
  108. Best way to model hybrid single/multiple logical database
  109. test
  110. Open Microsoft Search
  111. Yearless birthdates
  112. How To Build A List Of Products From Multiple Categories
  113. Formatting a calculated field with DateAdd
  114. Form suddenly won't open, why?
  115. Blank record in subform
  116. Query Calculations
  117. How I know what number was generated?
  118. NOT IN(SELECT
  119. insert into select
  120. Ordering dates in sub form
  121. Ordering dates in sub form
  122. Allow Bypass Key Other Options
  123. Custom Menu Bar Quirks
  124. Error 3021 description problem
  125. Report Copy Fails when Run on Windows XP
  126. Mouse wheel on Switchboard problem
  127. Subdatasheets for linked SQL Server Tables
  128. *.dbf > Access97 ?
  129. Displaying two records on one row of a form
  130. Shelling out to Adobe
  131. Rounding a number
  132. Hidden control
  133. New record gives error in "linked" form
  134. Help needed in access to Crystal reports..
  135. small access db
  136. SQL Server to MS Acces
  137. Recursive join - blind alley?
  138. Date Search Problem
  139. Search by Date
  140. Install Office Updates with 97/2000/XP Installations
  141. Refresh datalist contents
  142. Database Conversion error
  143. How do I copy data from one record into many
  144. "Cannot open any more databases": strategy needed
  145. URGENT: Volunteer's Needed (Missing Children)
  146. Tranfer Data from Combobox lookup to new record in another table
  147. Thank you all and best wishes for coming year
  148. Show undelying controls
  149. ComboBox question
  150. Help needed on ole db jet
  151. Happy new year and Thank you
  152. Month function
  153. Creating an automatic Record Display mechanism
  154. Group By
  155. Cannot link tables in Access 2002
  156. Auto Select Records
  157. Open Datasheet Form to Selected Record?
  158. How to program Escape key function in VBA?
  159. Can't transfer mdb file
  160. Security -- Protecting records within a table
  161. Combo Box - Default Values ?
  162. what apps do I need to program using MS access
  163. DSum Question
  164. Calculating a persons age using Access
  165. Simple Module/Variable Question
  166. File locking / sempahore necessary in multi user environment?
  167. Tip for dealing with circular reference issue
  168. Copying txtbox contents to the clipboard
  169. Subform mods not saving
  170. I'm confused...Access Security
  171. inventory
  172. Recommendation for custom dbase app
  173. I can't even find a subject for my question
  174. Invisible corruption
  175. GENERATE FIELD LIST FROM A QUERY?
  176. Crosstab header with a period
  177. access 97: INSERT and Append queries
  178. Help! Getting Error Code 40230 in Access XP when making an mde.
  179. Me.filter failing
  180. manipulate controls on current record of a form
  181. ADP Query Designer Won't Display UPDATE/FROM properly?
  182. Date problem
  183. Dimensions of gif & jpeg files
  184. More question on Data Auto Import (??)
  185. MS Access 97 - Forcing an Update
  186. Selected From Combo Box or Typed In?
  187. Macro in a Form, generating a Report
  188. Subreports
  189. Question about field design when planning a VB front-end to Access database
  190. The Access Runtime, Windows 2000 compability?
  191. handling errors + last_inserted_id + list_box search
  192. Flaws in Access (resource)
  193. Afterupdate is not requerying my list box when I navigate records!??
  194. How to clear form fields on loading?
  195. Access 2000 can't import DB3 or 4 or 5 files
  196. Need help with forms and applyfilter command
  197. Need help sending invoice data to a text box
  198. More question on Data Auto Import
  199. Parsing text
  200. Does MA Access have a Calendar Function?
  201. Color Name vs. Color Number
  202. Transaction Number addition to Imported Data
  203. Data bound controls bug?
  204. Can This Dlookup Work?
  205. VBA code editor ignores spacebar, sometimes - A2000
  206. Tracking communication threads in Access
  207. recordsets in DAO v. ADO
  208. What's changed in Access since version 97?
  209. Compare Access 2000 and Later versions
  210. Recordsets & Append query
  211. Copy a fields Value
  212. Access on web page
  213. What the hell is this: run-time error '-2146500594 (800f000e)'
  214. Creating a database connection and recordset
  215. Inserting values
  216. append query
  217. HowTo have 2 tabular detail lines on Single report ?
  218. Error Message Help "Error Accessing File"
  219. Odd behavior in A2K Form! Help!
  220. Question on Importing text data to Access
  221. delimeter counting: seperating the street from the adresnumber
  222. Background Image Now Small
  223. Context Menu
  224. report refers to each query row twice when using 'on print' event
  225. Update a field when a checkbox is clicked
  226. Constant Crosstab Headings & functions to create queries
  227. How can I find open recordsets or other variables that should have been closed?
  228. Can't run any wizard: "Permission Denied" (AccessXP)
  229. Access to Oracle 8i Commit
  230. Control Label
  231. Resizing Images then saving
  232. Treatise on Tree Control 6.0?
  233. Line Return
  234. 1:1 Relationships: RI Enforcement/Cascading Deletes?
  235. Update a Field from another table
  236. How to make all negative values positive?
  237. Help with this Error Message
  238. cancel if no records
  239. SQL Insert question
  240. Finding Latest Record for an Associate
  241. Calculating Dates
  242. #Delete
  243. Line Returns
  244. Public Variable- Why doesnt this work?
  245. Subform popup (shortcut) menus
  246. Subform header in Datasheet view
  247. Properties problem: .Text and .Value do not capitalize
  248. Open Report filtering from a listbox
  249. Delete
  250. Changing MS Login ID on-the-fly?
  251. Create a new Form from based on a 'Filter By Selection'
  252. Selecting Users from a list when running a report
  253. DMin Function
  254. Write to LPT
  255. Performance problem in one form only
  256. =Sum #Error
  257. I'm trying to list controls in immediate window... what's wrong with this code?
  258. Duplicating record
  259. Access 2002: problem in VB function
  260. Finding dates from a query
  261. Combobox
  262. Invoice numbering
  263. Replication/Synchronisation failure
  264. MsgBox won't close.
  265. Query Description Entry
  266. A single child changed the world!
  267. Combo box LimitToList property setting of No - I still get MS Access error...
  268. Changing Query Reference Table Names without rebuilding query
  269. IsNull
  270. Search an encrypted database and display results
  271. Access 2002: Call VB module from reports
  272. Metaphone source code
  273. Find and Replace Strings in Access: New Version
  274. Upsizing wizard
  275. $0.00 inserted into Currency field
  276. Worlds Dumbest Question!
  277. Is this feasible?
  278. Code: Private Sub help
  279. web database...
  280. Difference between rows
  281. Simple text file creation
  282. importing accented DOS chars
  283. Update a record
  284. Double Click on a Record in a Subform to Open that record in a new form.
  285. Query-Generated report
  286. tab control inside another tab control
  287. Life with Different Versions of Access
  288. PLC programmeurs gevraagd
  289. Input Box Fails to Cancel
  290. print out problem
  291. combo box doesnt save
  292. Date Filter
  293. How to use VBA to delete files?
  294. OT. Is anyone running Access with the Linux OS?
  295. Referring to controls in Modules
  296. OT. Remote access of your Access app over the web
  297. access97 runtime error 3075 missing operator
  298. Determining screen resolution in a procedure?
  299. MS Access & SQL Database for JPEGS
  300. The "database" object type missing in Access 2002
  301. Relation
  302. Simple code to delete all rcd in a table and import records to same table
  303. Combining multiple tables into one table
  304. MSDE - security issues while on cable modem?
  305. Is Access consistent with the order of events when opening a form from within a procedure?
  306. Access97 to WinXP from Win98
  307. Code for Filtering from Mult-select List Box Criteria
  308. OLE Server and ActiveX control
  309. Query in VB to Validate data
  310. A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
  311. advanced search functions (for photo database)?
  312. Error 3021 no current record access 2000
  313. Coldfusion and Access and Field Names (It ain't Paradox)
  314. Windows 2000 Server and Acess 2000 constant corruption
  315. Windows 2000 Server and Access 2000 constant corruption
  316. Subforms & Counting
  317. Table efficiency
  318. how to record invoice printed
  319. looping through all records with VBA
  320. Report Preview
  321. Need Help with Package and Deployment in Office XP Developer (replace - always, older files, never)
  322. Attn MGFoster
  323. #Name Error in Linked Combo Box Field in Printed Report
  324. <<HELP>> First level support for ms database
  325. Skinning Access forms
  326. Datensatz finden in Unterformularen
  327. Sharing across Win platforms
  328. how to set focus on a report control?
  329. Dsum , using numeric & Text help with the Text bit!
  330. Dsum , using Numeric and Text fields ????
  331. What is future of MS Access?
  332. How to access an MS Graph Object on a report
  333. Enter New Data In Comboboxes Only
  334. How to count records selected in subform datasheet?
  335. Move to next control in Form after pressing Enter?
  336. importing trouble with my access '97 D-base in access 2002 D-base format
  337. This is my problem......
  338. How do I pass a field name to a function?
  339. Advantages of moving to most current version of Access?
  340. How to use InStr Function to get hyperlink display text?
  341. Forms and the Switchboard
  342. ChkBox and TxtBox Problem
  343. dialog box with no border? (access xp)
  344. Error 2448 does not make sense in the context of the problem
  345. sql help - should be simple, but can't get it.
  346. Report by hour / day
  347. Passing Values to Parameter Query
  348. Re Disappearing forms!
  349. Save data entered when using [enter a value:] in SQL
  350. Access problem
  351. Parameter Query
  352. How to hide tables from the Import Wizard
  353. Disappearing forms!
  354. Please Help Passing Variable from Form to Query
  355. wanted: database publishing tool for MS Access
  356. Setting Controls from a Table in Access 97
  357. Shrink the size of a field
  358. Check Box Size
  359. Duplicate values
  360. Screen Preview differs from Print Out
  361. How to pass multiple arguments when calling Function?
  362. Trouble with Access Like Query in ASP
  363. Update a Form Field
  364. urgent : access sub-reports as popup
  365. Spaces in Field Names?
  366. Find Front End
  367. Automating queries by using a reference date.
  368. Moving data to SQL Server
  369. Access 97 on PC with more than 1 GB of RAM (Terminal Server)
  370. Problems with Access XP and SQL Server
  371. Memo datatype got trucated
  372. I want to make a web interface for my database...
  373. DllRegisterServer in MSFLXGRD.OCX failed
  374. SQL: INSERT INTO without specifying any column
  375. 100 Day Statistics for comp.databases.ms-access
  376. Statistics for comp.databases.ms-access
  377. Access Word 2003 Automation
  378. need help with vertical (columnar) datasheets
  379. Time-keeping with Access 2000
  380. Access 97 Database converted to Access 2000 - Controls do not work
  381. emailing from a form
  382. PivotTable date groupings
  383. Application Icon Location
  384. Call query design view from code
  385. Viewing table as subform and seeing linked items
  386. When does Does "On Open" execute?
  387. Passing Discontinuous Range (Array) of Values to User-Defined Function
  388. Iif Statement Returns Error in Form
  389. Send a draft message to mailing list
  390. multiple append queries using VBA
  391. Importing Tables from SQL Server to Access with Keys and Indices preserved
  392. Searching for the right word to encompass 'Supplier' and 'Consumer'
  393. Automating queries by using a reference date.
  394. Is 2.3 MB too big for a simple database?
  395. Selecting from Text File Truncates String
  396. Is this possible?
  397. 255 Column Limit using Microsoft Access
  398. Selecting from Text File Truncates Long Strings
  399. Get the name of the function or sub from within code?
  400. Non-Duplicate List Of Products
  401. Display date with 4 digit year
  402. update combo box
  403. Access 2002: Replication question
  404. Stephen LeBans JustiDirect text justification
  405. Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?
  406. Larry, for you . . .
  407. Save a record programmatically from a form's module
  408. Updating Linked Table - why is action query failing?
  409. Can't update a recordset after filtering
  410. Update Inventory
  411. One customer gets #error
  412. Determining where a control is on a form; header, detail, or footer
  413. Conditional state of a record
  414. VB - Question for OpenForm Criteria
  415. Assistance needed with a small piece of code
  416. The Paperless Office is Now!
  417. No $ for Currency fields
  418. How do I?
  419. Populate control in another form
  420. Redemption Not Blocking Latest Security Prompt
  421. Acc 97, expressions
  422. SQL - joining 5 tables - not all records retrieved
  423. help with unbound fields
  424. Paste Into A Combo Box
  425. Tabellen von verschiedenen DBs in eine DB kopieren
  426. Combo Box inital value to display
  427. DateValue
  428. What this query return ERROR?? :(
  429. Access 2002: Bar code problem
  430. Get the name or HelpContextID of a Toolbar Object?
  431. Problem retrieving printer information for this object
  432. Help: batch method to get .MDB table names ???
  433. A2K2 AllowAdditions
  434. Cannot import .xls file (Access 2k)
  435. Problem with Check Box use to Change Field Values
  436. Struggling with linked database problem
  437. Labels Dialog Box Enhancement
  438. Justdirect text justification
  439. Control Of What Is Printed In Page Footer
  440. Register a dll
  441. addresses
  442. I'm rusty on my Access...can anyone help with a Query question?
  443. Viewing linked entries in a subform
  444. How to loop through a record set.....?
  445. Problem Duplicating Forms in Access 2000
  446. Modifying an import specification doesn't work.
  447. Best way to handle distributing runtime installables from the web??? (slightly O.T.)
  448. Is there a trick to not have a cross-tab query sort the column headings?
  449. how I protect my DB with serial number disk?
  450. Report in Access project
  451. The above post is a forgery. Ignore
  452. MetaData Repository Standards?
  453. Parameter Value in IIF
  454. Using access to complete company forms
  455. problem with my code
  456. Sync Access with Palm PDA
  457. Adding a New Field to an existing Form
  458. Double Merge in a Access Report Possible??
  459. Getting User Name form Login (System enviroment variable?)
  460. A97: Get the month, day, and year from a date field in a table
  461. concatenated form fields
  462. The IsNull function requires 2 arguments
  463. Help with DCount function and filter
  464. Lookup field created with VBA ?
  465. Protecting your work
  466. Access 2003 pivot-table view gone?!?
  467. form field validation
  468. MSFT Access Unable to create MDE
  469. Iterate through all queries in database and set description
  470. Using Access with LDAP
  471. labelling
  472. Filter Sort Wild Card?
  473. A97 - Detect Idle Time
  474. How do you create a Report or query for the # last days?
  475. Date field
  476. Access 2002: Updating 2 same database
  477. Group total in distinct field
  478. Copy field with DoCmd
  479. Changing field types with Excel as linked table
  480. Can I use VBA to import/link tables?
  481. SQL INSERT INTO a table using information from two other tables
  482. Possible fix for Pivot Table grayed out or no row or column sight problem in Access 2002 XP
  483. Uninstall
  484. Access 2000 - Use ADO.Recordset as Report Recordsource
  485. Replace text in a field?
  486. Go To Current Record
  487. How to Lock and Hide Access Tables?
  488. Creating report using ASP with MS-Access
  489. Beginner: Open Main Switchboard Item in Datasheet view?
  490. Do NOT click on ANY URL's posted in CDMA
  491. changing a form to a subform (VB problems)
  492. BEWARE LINKS POSTED FROM SODOMIZERS!
  493. Access 97 Complication
  494. How to merge two distinct records into a single record?
  495. Alternative row color with a sub report
  496. Text Box Assistance
  497. Access freezing while printing
  498. Changing Colors of fields on a report
  499. Beginner: Mde error- couldn't make changes
  500. Any way to record the progress of a query while it is running in Access 2000?
  501. Finding Login Name for a Group Login
  502. Database window appears when it should not!
  503. Access Run Time: Alternative Version
  504. foxpro compared to access......can they do the same thing
  505. records in report disappear after design viewing
  506. FTP with Login and Password - what is wrong with this?
  507. Problem with DoCmd.OpenForm
  508. Dialog Box Not Dialogging
  509. parameter query
  510. Connect to back end for non logged on user
  511. Relationships and Cascading Updates problem
  512. Relationships
  513. Display of Menu bar while access is starting
  514. Table column is automatically populating itself
  515. SQL utility form for Access
  516. <<HELP>> Getting rid of part of a text field
  517. One Step Merge Document and E-Mail to a Group
  518. Update MS Access table from another table
  519. BEWARE LINKS POSTED FROM ANONYMIZERS!
  520. Subreport question
  521. How to: Filter Against Fields
  522. Access 2000 Missing Wizards
  523. Invalid Procedure Call or Argument (Left, Mid, etc.)
  524. Problem retrieving printer information
  525. How to SELECT hyperlink.htm FROM table?
  526. Error on opening a database: MS JEt database says someone tries to modify the file
  527. Use Access 97 or Access 2003
  528. Do I use Nz
  529. Access & system settings
  530. Error on opening a database: MS JEt database says someone tries to modify the file
  531. Sample files
  532. updating/adding to another table
  533. Send email - capture ProfileName from MAPI
  534. Microsoft Access license to distribute runtime components
  535. Get actual text of error trapped by Form_Error?
  536. Quieres ganar dinero extra para pagar tus deudas lee esto......
  537. Different Versions of Access on Same Computer
  538. a2k - weird code behaviour I can't explain...
  539. Updating Yes/No Fields !
  540. Time formats
  541. MS Access '97 and MS-Office XP-SBE, would it work?
  542. Parsing some text data into records...
  543. update blank table record field
  544. Forms and Form
  545. Report Writer question: can I do a "top ten"
  546. Re-entering combo boxes
  547. Beginner: Can a form edit identical data from more than one table?
  548. Installer problems
  549. Save files attached to an email
  550. Access data through MS query in Excel.