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. ODBC -- Call Failed.
  2. ODBC -- Call Failed.
  3. Graphic front for AC97
  4. Autofill query
  5. Access to excel
  6. Msgbox text font
  7. Import Excel using Access Wizard
  8. How to add data from one form to another
  9. I was planning to use this code to add users in A97...
  10. Trying to use Playsound in A97...
  11. Importing and Updating Access XP
  12. Word function out of Access 97 non-responsive after Access 2003 Upgrade
  13. Microsoft Desktop Client: Any chance of connecting to local drives?
  14. Modifying subform records for cartesian product
  15. Thank you David Fenton... but one more little thing.
  16. Switches?? - Access 2002, VBA
  17. A97 compact database question?
  18. LIKE criteria works in query but not in VB
  19. eeek help
  20. Cannot compact
  21. Problem with SQL statement on subform
  22. access query issue....is it possible?
  23. Appending Strings
  24. A97 allows separate procedures in a form module to share common labels.
  25. How do you record check box selections in the database?
  26. assign auto number using VBA
  27. What's the default choice if Public/Private is ommited from the Sub statement?
  28. Access 97 linked to Oracle showing wrong datatypes
  29. UPDATE SQL Statement in Excel VBA Editor to update Access Database - ADO - SQL
  30. Loop through all forms to set Allow Design Changes Property
  31. Storing check box selections in a textbox as appended strings
  32. A97 table field of Yes/No type without a default value property setting has a default value?
  33. how to make sure access queris the correct data sets?
  34. MS Acces help needed
  35. Subform Problem
  36. Query Criteria linked to form
  37. Date Field ---Help
  38. use dao to create odbc link table and saving the password
  39. Hidden modules in Access 97 - what are they?
  40. Events on Tab control
  41. I'm trying to grasp the concept of class modules, seeking a straight-forward example on a site somewhere
  42. A97 debug window
  43. MS Query not enabling join options when merging dbfs
  44. Access really slow over the network
  45. Melissa Data Address Object
  46. Help w/ On Open Vs On_Open Vs On_Current
  47. Who controls improvements in Access
  48. Scroll automatically tabbing through fields in a form
  49. Password Backend
  50. Running Totals by date misbehaving ?
  51. attachment
  52. Access and Oracle sequence issue
  53. Error Creating Table in MS Access
  54. A2K3: Use control on form for calculated field
  55. Report Formulas not totaling in footer sections
  56. MS Access as a web darabase?
  57. Opening database exclusively
  58. Database Permission Settings
  59. Footer OK on print preview, but doesn't print to printer
  60. Force 4 digits in field
  61. Problem with date formats in international project.
  62. MSCAL.Calendar.7
  63. Accessing a MS Access database across two servers
  64. Button Effects on Access forms
  65. In Form View - can't get to next record. Why?
  66. Reverse Engineering an mde
  67. dynamically control form objects
  68. Adding a Quit to a Macro using Visual Basic
  69. Include picture in Access form
  70. Query to show letters sent by date in a crosstab format
  71. Emailing one page from a report..
  72. Inference Engine
  73. Problem grouping records by certain time frame (report)
  74. CopyFromRecordset does not work on different machine
  75. Use friendly Databse Tool for non-DBAs
  76. date comparison
  77. Copy Same records
  78. To brows to a folder or file
  79. object variable or with block variable not set
  80. object variable or with block variable not set
  81. Closeing MSQuery Window from Access
  82. Question 2: automatically update an embedded XLS-flie
  83. Question 1: How to refer to a arrayed multple textbox?
  84. Numeric column in Excel
  85. Which Record to display 1st?
  86. Field to Field data duplication
  87. After Update event
  88. how can i 'select' items in a list box from a button click
  89. Is there a way to automate importation of Excel data?
  90. # of Months Calcuation only returns 0
  91. Disable Shift Key. Help!
  92. Error 3265: Item not found in this collection
  93. Find the length of text stored in a textbox?
  94. Problem with control source for text box on report
  95. Colour Cycle in forms?
  96. How to create table?
  97. Setting form properties in VBA: do I need numbers?
  98. What does var$ mean?
  99. Specifying parent child form by name
  100. Report objects
  101. Changing Unbound Field Name
  102. DateTime problem
  103. Switch function max number of varexpressions in Access xp
  104. File convertion
  105. Find file window
  106. Twips and Pixels: Please confirm
  107. Problem with forms
  108. update Access table by VBA in Excel
  109. To All
  110. MS ACCCESS has encauntered a problem and needs to close ...
  111. Who Monotors The Newsgroups?
  112. Return to same Record
  113. How to specify Range when exporting to Excel with JET?
  114. Query/Report to show how many letters sent per month
  115. Determining the size of a file via a URL
  116. How do you tell which page of a tab control is being displayed?
  117. What files do I need to deploy the runtime of Access?
  118. Need help with Tab Control (unable to update some fields)
  119. Text is too long to be edited
  120. Too many Forms Open
  121. Access application dies connected to Oracle databases
  122. Excel Automatation and Changing Format Of Cells
  123. Automating import into Access of e-mailed form to email data
  124. (Español) Utilización del SendKyes
  125. Using IIf More Than Once In A Report Textbox
  126. How do I change an MS Access Database PAssword from VB Code
  127. check constraint message
  128. 4k Table limit
  129. Altering a column to REAL and setting the format + the decimal in SQL.
  130. Calling excel: subscript out of range
  131. Determining the size of a file via a URL
  132. Connection String in VBA
  133. Syntaxerror in Designview -> How to correct wrong SQL-Syntax?
  134. Office 2003 Picture Manager: OLEClass property and Class Property
  135. Prevent textfield from being deleted from but allow updates
  136. Checking the value of a field in a table from Code
  137. SQL synthax problem on INSERT INTO instruction.
  138. Access report not reaching printer
  139. how do i insert new record in a joined table's
  140. DoCmd.OpenForm
  141. HELP ME TO USE GMAIL
  142. Help entering in a constraint, Please!
  143. Extracting data from Excel into Access Table
  144. what is the error here?
  145. can anyone here help me
  146. Play a ".Wav" sound with Access
  147. Count only counts all results and ignores criteria
  148. Extracting from Long Binary field
  149. pop up calenar not working in subform
  150. Please help! Strange behavior: Access > Word Mail Merge code
  151. TOP 10 query
  152. northwind sample database is a turn-off
  153. Loosing Printer Settings
  154. Running Balance Help wanted
  155. A mystery: can just a compact & repair change table relationships?
  156. Advice on Looking up
  157. VBA Problem
  158. After using clipboard functions in Excel from Access VBA Excel doesn't quit
  159. Present the 'gaps' in numbering
  160. How do I get a databse password in VBA?
  161. preventing opening database window in MDE
  162. ADO Importing from an unknown named Excel worksheet
  163. Update Access Table with filename, modified file date/time and values contained in these flat files
  164. Iterate through table fields in an ADP?
  165. Lock Cells
  166. Link OLE objects to Records
  167. Networking Database
  168. Question about relationships, inner joins and query results
  169. Forms, Memos, and Quotation Marks
  170. Intervals - Using lookup?
  171. Dont show report when invalid date is entered?
  172. Setting Checkboxes of Treeviews at Mask-Opening
  173. I already have a table called client and seems to be related with other tables ,I tried making TBL client as lookup too, I ended up having another table called Client_1?
  174. Can MsAccess help me in this application?
  175. Adding up field from a table
  176. Why does Access create a duplicate database every time I open my mdb?
  177. OCX clock control for Access 97?
  178. Cannot open any more databases.
  179. Publishing with Word
  180. size of database
  181. Unable to open database
  182. How to tell if others are connected to the database
  183. Problem printing report
  184. Selecting forms with multiple instances
  185. VBA Excel paste from access function fails every second time it runs!
  186. Print Report Based on Form
  187. Add new record, requery to add to table and then open for returning to new record
  188. Can I create a .Net custom control in a Microsoft Access form?
  189. Access opens to blank screen, won't open database
  190. name of A97 workgroup administrator executable?
  191. Q:Access Parameterized Query to Oracle?
  192. Microsoft Jet database engine stopped.... problem with fixing it
  193. Closeing MSQuery Window from Access
  194. Incremental Numbering
  195. Subform is ignoring filter
  196. Adding record to another table from form
  197. Recreating Design Master question
  198. access date function question
  199. Using a combo box on search form
  200. Implementing a calendar report
  201. Error with DLookUp
  202. How to you handel different access versions running the same database
  203. Report, Crosstab Query and Parameters
  204. access romania
  205. Replication via code
  206. Repairing when not broken
  207. Open Form At New Record (Empty)
  208. problem with SQL in Access
  209. PGUP, PGDN
  210. SQL Summary problem
  211. What owc10.dll does?
  212. How to control unexpected/unwanted GotFocus event property setting (expression)
  213. create a field based on another field
  214. Code to create table with increasing field numbers
  215. How to edit Production DB
  216. How to Ignore Missing Libraries ?
  217. Creating tab delimited file
  218. How to count a text field in a form
  219. Using Not In List and a Query?
  220. Changing one MDW file for multiple databases
  221. One record per tab
  222. Select newly added element in a list based on a sql
  223. Join Issue
  224. Table Setup
  225. Transfer Access database to Intranet
  226. Run-Time Error '6'
  227. Different Access version problem
  228. Create table shoutcut and add to existing group using code only
  229. Create table shoutcut and add to existing group using code only
  230. Print same Report of different heights on continuous paper
  231. Strange Access Issue
  232. Macro substitution request
  233. Imoveable Forms
  234. Insert only if item doesn't already exist... easy right?
  235. Pring in a smaller size
  236. Relink all tables in other database
  237. Make Subreport Function Like Main Report
  238. Custom Filter
  239. ANY Idea how to flush all data in an access DB or one of its tables?
  240. Passing arguments to function by reference - Good or Bad?
  241. Sending Parameters to Query
  242. Monitor Network Traffic
  243. Parsing data from a text field
  244. Connect property of linked ODBC table
  245. Setting Report Page Size To A3
  246. Having trouble with DLookUp in A97...
  247. .mdw only allows one user
  248. Conditional Formatting
  249. Using Text Box Name as string?
  250. Access runtime version
  251. User not in Admins - how to circumvent their not being able to create a new user?
  252. I get type mismatch errors sometimes. Why does Access think it knows what data type a text box control is?
  253. creating an inventory application
  254. Updating Table records
  255. A97: If I create a new user with CreateUser Method, is she automatically a member of Users group?
  256. Whats the easiest way to allow a user to change password in an A97 app?
  257. Chr$(13) & Chr$(10) give me a problem in main menu label caption property...
  258. problem running access
  259. Passing Record Set Reference from a form
  260. RunTime Error 5
  261. CurrentDb.Execute options
  262. Return File Modified/Create Date
  263. Create alias for network drive?
  264. A97: Can I 'peek' to see if there is another record?
  265. A97: Why is there no example for GoToRecord Action HELP section in Access 97?
  266. Help!
  267. Query question:
  268. VB.net Access97
  269. Query MySQL
  270. Moving data from Access to Excel
  271. File Import Question
  272. SQL Troubles
  273. Determine if listbox has values
  274. DLookUp Error message
  275. DLookUp Problem
  276. Automate the closing of Word from Access after MailMerge
  277. Importing data performance
  278. Access and Frontpage
  279. Export report as WEB page
  280. How can I attach two reports to the same Email?
  281. Controlling Excel from Access: Using Sendkeys to enter data into an Excel Input Box
  282. ComboBox
  283. Invalid Argument (OLE Objects)
  284. SQL Multi Column Primary Key Problems
  285. Problem in Join(T-SQL)
  286. Is This Development?
  287. Compact on Close Code
  288. highlighting the current record
  289. a2k - using bound subforms and transations
  290. Rounding a number up
  291. HTML chars have strange chars that show up as little square boxes, but are something else?
  292. Upgrading Access2000 to SQL Server
  293. Make it compulsory to fill in field in form
  294. Do I need to set form properties every time??
  295. Opening Report 100% view as default
  296. closing ODBC connection ?
  297. Opening a mail merge document from Access 2000
  298. Insert date
  299. Package Wizard
  300. yet another question - how do I set error trapping to 2?
  301. Psuedo Code
  302. report on close
  303. Deleting filtered records not working properly.
  304. reports question
  305. Server error
  306. Entering the Record Number in a field?
  307. Putting the Record number in a field?
  308. Putting the Record number in a field?
  309. Select Row in Datasheet Subform
  310. Assigning a Data Type to a Combo in VBA
  311. Dynamic Crosstab + Sub Report
  312. Comparing Text Fields in table
  313. Docmd.save Does Not Produce Error
  314. Sequencial ordering
  315. Forms modified when the really aren't?
  316. Where's my copy of Building Applications With Microsoft Access 97?
  317. Different code for saving records from A97 data entry forms?
  318. Selecting Records between two date fields
  319. Need help with multi-user environment
  320. list / form linking -- half way done
  321. type mismatch
  322. "Quit" in macro closes out the whole app
  323. Error Cannot Add or Change record because this record is required in table...
  324. subforms
  325. Referring to combo box controls on forms in A97
  326. Best Method For Providing Interactive Reports To Clients Who Dont Have Access To System
  327. Combo Box forces addition twice
  328. Mail Merge to Word -Problem with Access Form Code...
  329. Switchboard won't appear (Access '03)
  330. Split database convertion
  331. A97 and PDF's - Are they compatible?
  332. E-mail report as excel to people on report
  333. Registry Writing
  334. Text size in design view
  335. group by + count problem:
  336. Licencing the 'Reporting Donkey'
  337. Looking for a query
  338. Getting A Bigger Slice Of The LAN Pie For My App?
  339. Access security
  340. Form Operations
  341. Syntax error in query...(ADO.NET + MS Access)
  342. Action upon Key Press
  343. Pulling field value for remote webpage
  344. please help an access noob
  345. # symbol is showing up before and after hyperlinks
  346. Query
  347. A97: Importing AutoExec macro from Access 2.0
  348. Update Access from Excel via SQL
  349. Query Help
  350. A97: How to hide ALL the tool bars?
  351. Freeze field/column in continuous form
  352. Counting SubForms and SubReports
  353. Null and evaluation statements
  354. How to "Select All" in filtered recordset
  355. Need help on AVERAGING
  356. Problem with calling subform's button click event from the main form
  357. modules and sub routines
  358. StLinkCriteria syntax with multiple subforms
  359. Popup Form Eccentricity
  360. Dcount - novice user trying to write a novice expression
  361. ADP SQL Server Time Out
  362. custom shortcut menus
  363. Hide Section When Printing Report
  364. Matching Records with user definable criteria.
  365. Problem opening a recordset based on a stored procedure in Access Project
  366. Query Where WHERE clause points to Current Row?
  367. Not equal to a number
  368. Subform Linked Fields
  369. Office Automation using MFC
  370. Marketing Forecast, Quarterly Revenues
  371. DAO Parsing Table1 in Table2. What is wrong there ?
  372. search problem after converting data base Access '97 to Access 2002
  373. customized menu toolbars
  374. values are not going into table.
  375. to trigger or not to trigger
  376. logout for ODBC source ?
  377. pivotchart
  378. select the 1st row in a listbox
  379. select characters in a field
  380. A97: Keyword 'show' - what is that exactly?
  381. What's this... #If Win32 Then...
  382. A97: How go to new record on data entry form
  383. A97: Module window, clicking in vertical bar on left side of window...
  384. MS Access - how-to set control source for text box to query
  385. Parameter type append query dialog box - how to abort smoothly?
  386. Anyone here deployed an Access DB with an SQL / MSDE back end?
  387. How can I have Null entry in child table linked field?
  388. Cross reference utility?
  389. Need Help With Groups and Stored Drawings
  390. ADODB & Queries
  391. OpenArgs by reference?
  392. Looping thru Table1 to parse records to Table2
  393. Displaying calculations in a query field using Access 2000
  394. Password Encrytption Security (97 through XP)
  395. How to Import multiple excel spreadsheats?
  396. Access database opened via Intranet - integration
  397. text box help
  398. ActiveX calendar control in 97 - how is value updated?
  399. A97: Why negative memory values reported?
  400. What, exactly, is a control array?
  401. reading video properties from A97
  402. Continuous View Single View
  403. defining query in vb instead of design view
  404. Graphics disappear when printed
  405. Overflow error when Exporting Access200 report in RTF format
  406. Navigation button inactive
  407. Forms bound to SQL Server views
  408. SysCmd
  409. Reseting menu bar with VBA in Access?
  410. Access 2003 ExportXML - changing default tags?
  411. Update query # 2
  412. What replaces Database/Recordset collection in Access XP?
  413. Access DB continues to grow in size
  414. Can I join an Access 2.0 system.mda file from Access 97, to make it easier to import forms and other objects from my old Access 2.0 apps?
  415. syntax error in INSERT INTO statement
  416. Wildcards in OLE Linked Object File Name
  417. Access Automation causes warning messages and more to cease functioning
  418. Parameter Query - how to avoid needing wildcards
  419. Help With BuildSQL() Statement please
  420. ldb not releasing
  421. Internet Transfer Control, only option?
  422. Need help with tricky query... well tricky for me
  423. LDB file
  424. itc alternate
  425. What kind of database is access?
  426. standard view in database window
  427. filling fields with query results
  428. Determining a form's actual location (when it is not current)
  429. Code To Limit Precision?
  430. object invalid or no longer set message in vb
  431. A2KReportSpecs.mde as reference in XP runtime
  432. Access/VB6 problem Help needed
  433. Access 97 Import Text Problem
  434. Query and combo box to select parameter
  435. Displaying user-created menubar via automation
  436. Please help! What is wrong with this SQL code?
  437. Problems with autonumber field
  438. changing field data types programmatically
  439. No option for linking ODBC tables
  440. position in a field
  441. ADO / DAO Syntax to write to external database
  442. menu bars, tool bars, etc...
  443. Access Security Questions
  444. Datetime problems
  445. sql question
  446. Using Access database in an internet environment
  447. Ignoring spaces in combobox text: done,almost!
  448. Where To Put Error Handling Code
  449. Filtering a forms recordsource being used for a report
  450. label printing
  451. TransferSpreadsheet And Excel Formatting Problem
  452. columns and headings in listboxes
  453. Error Handling For A Recordset
  454. Nicht normal
  455. Valuation of database records: MoSCoW
  456. part of seconds in timestamp
  457. For a Field or Property object, this property is read/write until the object is appended to a collection or to another object, after which it's read-only
  458. Access Help
  459. Opening a mail doc from Access - code problem
  460. Filtering a numeric field with command "Like [.....]" as criteria in a query
  461. Error in Validation Rule
  462. How can I add NEW LINE to a report
  463. Code for Creating random letter combinations, but there are duplicates
  464. Database Design Question
  465. Data Type Mismatch
  466. changing a module into class module
  467. Requery Recordset
  468. ODBC Drivers error '80040e14' Syntax error (missing operator)
  469. Code completion / compact DB from code / slice data ???
  470. Automatic List Of Methods Does Not Come Up
  471. Future of access?
  472. insert with select
  473. Use an mdb as a background executable
  474. Min value of two date fields in same table
  475. Form freezes after deleting picture
  476. Problem with Ms Jet Exchange Isam (MSEXCH40.DLL)
  477. Import - database name as variable
  478. Searching .mdb files
  479. Help_with_forms
  480. Problem Opening Access 2000 Db with Access 2003
  481. MS Access Query
  482. subforms synchronisation
  483. name of current procedure
  484. Automatic Update After Printing
  485. Converting quotation marks to ASCII numerical value
  486. Weird access error: Access/OLE/Active-X communication
  487. Printing to receipt/serial printer from access
  488. solution for passing parameters to saved pass-through queries
  489. adding controls in forms from vba
  490. Please Test
  491. Opening a form in a specific location on the screen
  492. vb access run time error 3705
  493. Update an Oracle table, get 3167 error on faked Autonumber ID field
  494. Error message
  495. Trying to determine if MSDE Database is installed and install if not
  496. Strange behaviour in Access 2000/Win 2000
  497. Iterating a table with VB
  498. insert statement
  499. Data migration problem: Report sticks to old table name
  500. multiple columns in listbox
  501. Records Based on Recent Date
  502. Searching a txt file for instances of a string
  503. Count subrecords from record
  504. VB Copy a Tab Page
  505. Drag and Drop
  506. Problems with Code
  507. Inserting data into a Join table from a multiselect listbox?
  508. Link text box to a table
  509. Returning Records with Apostrophes in text strings using code
  510. inspecting whether a form is open
  511. My Dlookup is 'canceled'
  512. Hyphenated Name Field
  513. Refresh Tables on opening
  514. DCount function
  515. Problem on requery a form
  516. deleting an object in another database
  517. Entered data in query to form
  518. VistaDB vs Access or SQLServer
  519. Procedure list
  520. Strange query behaviour on different machines
  521. Not in List asks twice before I can leave the field
  522. SQL Query: Count with "having" date in the last five years
  523. comparing the datastructure of two tables
  524. Fields Containing Links to Drawings
  525. Make table query in a loop gets error: 'The database engine could not lock table...'
  526. List Boxes and Wildcards
  527. Set Lines Per Page for Space Delimited Text Output of Report
  528. Deleting Spaces between numbers or text in a field
  529. Status bar text does not update under XP
  530. Nested Sql - "Syntax Error in From Clause"
  531. Search a table column on any word or all words?
  532. A2003: "Update or CancelUpdate without AddNew or Edit"
  533. Using Access/Jet on Web site
  534. ACCESS 2003 query size high problem help
  535. Is a LEFT JOIN with a subquery possible?
  536. MS ACCESS Security issue.
  537. Wanted: Programmer to modify MS Access database for web use
  538. Wanted: Programmer to modify MS Access database for web use
  539. always prompt to refresh link problem
  540. SQL or RecordSet object?
  541. Perform an event when moving between records
  542. Fix to White Tab Controls in Access 2003?
  543. GetClipboardData(): Losing precision?
  544. Changing Screen Resolution
  545. Combo/List Box in Query Question/Problem
  546. Where to find Sample Databases ?
  547. SQL using IF THEN ELSE
  548. Keith - Advice on code
  549. Number of Copies....
  550. Query / Join help please!