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