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