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. A97 variable length string declaration - how to do?
  2. check box changes subform operation
  3. acCmdInsertHyperlink defaults "Browse for" File
  4. Catastrophic noob... can anyone help?
  5. ComboBox source query: run at Form_Open
  6. Access hanging periodically
  7. How to display multiple pictures per record in an Access database?
  8. Cancel Click Of Check Box
  9. 'Invalid bookmark' or 'database engine stopped the process' errorswithout corruption?
  10. Unique connection name?
  11. Mixing two Image samples by Lebans
  12. Access and vba in excel
  13. FE & BE Version Control Tips?
  14. Determinaition of Paramatric Queries
  15. using query results to populate a list or form
  16. Combo Box - NotInList Event - need help
  17. How do I link a control to the value in a form?
  18. Help needed w/Crosstab Query and Col Values
  19. Finding the current computer name in VB?
  20. AddItem not adding columns to listbox
  21. How to compute age in a query?
  22. Simple question about Cancel Event
  23. Accessing list of files from disk
  24. MDE Don't work
  25. Preparing for .NET Interviews
  26. How can I run an insert query on report
  27. Second Request - Can I return a value from an ACCESS report to VB?
  28. OpenRecordset & 3027 read only error
  29. Set a variable equal to the result of an sql query
  30. Question about moving Access app to web
  31. format for naming recordset field
  32. Display a report in a form...
  33. Determine if user has local admin rights in VBA
  34. Please Please Help!
  35. Find how many similar records..
  36. File already in use
  37. Problems Subclassing in Donors/Donations DB
  38. How to use static variable to exit function?
  39. How can an AutoNumber field start at some other value
  40. Put four queries into one
  41. Using combo-box as a user filter - trying to use format to display text "all" for null values
  42. Effects on RST in Calling Proc
  43. How to influence two tables with one form
  44. Access 2000 date range using today's date
  45. Build comma-delimited list from table
  46. Outlook mailitem
  47. Evaluating Complex Recordset Field Statements
  48. Compute Name , Is it a good idea to use it for copy protection?
  49. Predifined text and starting from the last record(in a form)
  50. Does ACCESS have the MINUS keyword
  51. Form_Dirty is not firing
  52. Parameter Query and Date calculations....
  53. Slow Update Queries
  54. Check box controls subform control source formula
  55. Subform not allowing creation of new record
  56. user permission
  57. MS Access Database with Remote Desktop - Multiple
  58. Error trapping code
  59. A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
  60. converting ACCESS to Stata using Stat/Transfer
  61. dirDataCopy error message when converting to Access 2000
  62. Comverting Dates
  63. Left Join Not Supported - translated from legal SQL statement
  64. Tables Queries Criteria oh my!
  65. Transferspreadsheet File Name Limit
  66. Tree view adding duplcate keys
  67. Is it possible to open an Access Macro as a recordset in VBA code
  68. VBA to Word problem
  69. Running code in one form from another
  70. Duplicate query recordset
  71. Lock Down Titlebar in Form
  72. Keywords
  73. Access 97, XP and 3170 Couldn't find installable ISAM
  74. Full menus
  75. Trouble working with not between
  76. mail merge
  77. mail merge
  78. mail merge
  79. Importing Excel Spreadsheets Into Access 97
  80. Date format cannot be controlled
  81. Date format cannot be controlled
  82. Problem with inner join
  83. Set and restore permissions using VB?
  84. Calculating the dwell time between two Records
  85. Control format property in OnFormat event
  86. Can A2k co-exist on a Machine Running A2k3
  87. edit word document
  88. How do I refer to a series on an MSgraph in access?
  89. Concatenating text fields with a WHERE condition
  90. Anyone use Visual Studio Office Dev Extensions?
  91. How to open default email program when I store some email addr. in a field?
  92. hiding record navigation button in forms
  93. raport and null problem
  94. IIf Function based on field value of continuous form
  95. TransferText
  96. Drawing objects in Access 2003 - can it be done on forms?
  97. delete all text starting with ..
  98. Help with counting occurances of similar text
  99. Before Update
  100. Help with an SQL query (opposite to a union query - if it exists)
  101. File Not Found error when importing forms from another database
  102. Adding Incremental Records
  103. Date Conversion
  104. running an update query from form...can I just use the sql cmd
  105. subform question
  106. backend corrupt
  107. Handling Apostrophes
  108. can someone tell me what I am missing with strings
  109. Need check box to change formula used in subform source
  110. Combining two queries
  111. Display one to many records in a mail merge
  112. I used to see a menu item/short cut menu to translate macros to code
  113. locking down tables
  114. Blank Form
  115. Adding a column in report
  116. Help with simple database concept
  117. Open the Outlook Addressbook in VBA
  118. Exporting To XML File
  119. AppHelpFile key and context-sensitive help
  120. Tab Form and 'cannot open more tables error'
  121. Report in Table Format?
  122. Help with VBA syntax please
  123. New Access / SourceSafe Bug Discovered
  124. Query Corrupted? - Access 2002
  125. Need help writing a double click event procedure
  126. Attaching Document
  127. Memo field not large enough
  128. Creating ODBC Data Source automatically?
  129. how to check list box
  130. Need help parsing a string - reverse Val?
  131. Check box changes formula used in subform
  132. how to open code builder for default when click on event builder in forms
  133. Export Query To XML
  134. Form colors in Access XP look goofy when converting
  135. Importing Excel
  136. Displaying and modifying 1:N data in forms?
  137. How to delete the missing References for VBA
  138. Some fields of a table are not visible in the design view
  139. Accessing a Report properties without opening it
  140. Option Button bug?
  141. Control Reference
  142. Aggregate function error
  143. Arvin Meyer's Good Article For Beginners
  144. Elookup vs Dlookup, Error 3048
  145. ComboBox using SQL code
  146. Migration to Postgres
  147. Front end grows when saving
  148. Cannot Delete access file
  149. [ODBC] How to compact a base ?
  150. continuous form buttons with different images (from table)
  151. Pr4int Preview Vs Print
  152. Help? Subdatasheet bug 'You can't hide a control that has the focus'
  153. How much to charge
  154. Missing references in VBA code
  155. Missing references in VBA code
  156. the form jump after a AfterUpdate Event
  157. How can I disable a reference library with VBA code
  158. We aim to please
  159. How do i hide a group footer if it's the only group?
  160. Database as Variable for Param query
  161. Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
  162. Protect MS ACCESS DATABASE
  163. Trim/Remove Unwanted Spacing In Text
  164. Linking to an external library with VBA code
  165. How can I concat the name of a control in a way that I can refer to it in code?
  166. Read Outlook emails using Access
  167. Anyone wrote VBA for calc'ing determinant of 3x3 matrix?
  168. Combo Box Display Problem
  169. posting 20050827
  170. repost calling a subform from another form(not main form)
  171. calling a subform from another form(not main form)
  172. How do you boot connected users from your database ?
  173. Repost : Reading a Text File
  174. Wont find infomation from table
  175. Verify Jet SP
  176. Sort Is Not Working
  177. PDF
  178. Requery
  179. Queries/joins with more than 2 tables
  180. generating sequencial numbers
  181. Concatenate text fields in query
  182. ER diagramming wish list: send a request to Microsoft
  183. Microsoft Scripting Runtime
  184. Problem with my chart in MS Access 2002 using a form and VB
  185. opening and closing IE
  186. Combo-box not displaying all entries
  187. Weird parameter prompt appearing after creating a subreport
  188. how to print (or not) the contents of a textbox in a report
  189. Embedded Pictures
  190. record lookup
  191. postcode finder, lookup,search
  192. Disk or network error
  193. Current concensus on using WSH libraries from Access
  194. Text too large to be in a field
  195. How to move to item in ListBox?
  196. permissions to import after a new workgroup file?
  197. making and refreshing local lookup table
  198. How to increase the response time by working with linked tables
  199. RE-linking to back end
  200. Annotated Calendar
  201. Microsoft Scripting Runtime Reference
  202. Ownership ?
  203. Conversion Map for Field Type and Field Format
  204. How to automate this import
  205. Need Help Checking Values in one table against two min max values in another
  206. Generate String and output to textbox in report
  207. Returning a number from a hex value.
  208. Reference Error: Difference between UK office and US office?
  209. Change f-e links to replica?
  210. Strange Problem doing DOS Dir Command in VBA Help Please
  211. checking input in inputbox
  212. DLookup Problem
  213. Access 2000-repeating data for labels based on # in a table
  214. Tossing someone off of the internet.
  215. Macros and fields in a table
  216. Does the physical path of a library matter as long as it's registered?
  217. problem with a LIKE query
  218. Group BY - Maximum Fields
  219. How to sort an array of string
  220. Finding an Installable ISAM
  221. Any known issues with UTF8 and UCS2 unicode???
  222. Setting Updatable Property of QueryDef to False
  223. Conditional display of records based on user's multiple selections
  224. Calculated total on subform will not display on main form
  225. Displaying (scrolling to) a specific record in a continuous form with VBA
  226. Access 2k/2003: Touble with delete query using WHERE EXISTS
  227. Updating records in a related table
  228. 'VB in Access' and SQL: Library Management
  229. 'VB in Access' and SQL: Library Management
  230. copy comment from access-table
  231. NULL data increases table size
  232. A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
  233. ARGH! Type Mismatch on Set Recordset
  234. MDI background color (detail) - XP
  235. Accounting
  236. Dumping query result into Excel spreadsheet
  237. Why this 2467 error?
  238. How to test the contents of a field or control?
  239. field is wiped out without warning
  240. No underlying data to support subform
  241. Is there an easy way to enlarge an Access report ?
  242. No underlying subform data to go by
  243. Extracting format info from database
  244. Form design for staff schedules that vary..
  245. ListBox displays values, identical ComboBox does not
  246. Picture
  247. Problem programaticaly importing tab delimeted xls file
  248. Change default table colors
  249. Change default table colors
  250. Form/Subform
  251. Problem turning off action messages in runtime - append query not working
  252. Assigning Values to Imported Data
  253. A2K - how to extend default cursor position to ALL textboxes?
  254. Bypass entering password to ODBC data sources
  255. Not returning Memo field
  256. .mde on different Office versions
  257. ActiveX demos
  258. Enter Key Behaviour
  259. dbo qualified name error in Access 2003
  260. Consensus on using PDA software with Access
  261. How to limit records displayed in ListBox?
  262. Who is in my database?
  263. How to tell if a form is open?
  264. Registering MPE with Access 2003
  265. Open Form when DB starts
  266. Acess developer researching non-Access web based database
  267. IsNothing() IsEmpty() : Why i can not find it in Access 2003 Visual Basic For Application?
  268. Problem with AutoExpand - Still Need Help
  269. API to Access Active Directory Organizational Unit Membership
  270. Change icon in task bar - Please help!
  271. Criteria For Subform Combobox Rowsource
  272. matching with duplicate references
  273. 60 GB IPOD deal found
  274. Toolbox
  275. Prevent Custom Menu From Appearing
  276. Verify Existence of Field Names before Opening Form
  277. "VBA project is corrupted", Access2003--Access2002
  278. Disabling menu option
  279. Recordset problem due to corruption?
  280. Can corruption cause this?
  281. Exporting data to excel via macros
  282. Error sending email
  283. Opening a file
  284. Extract information from various web sites
  285. FORM function no longer work after upgrade from 97 to 2003
  286. Code Issues
  287. Trivial query?
  288. UPDATE query results not written to database
  289. determining dimensions of image in a layer
  290. Access to CSV translation/Conversion Programmer needed...
  291. Mailmerge via Automation in Access.
  292. ADODB Connection String with password
  293. Create Custom Expression Builder / Calculation Engine
  294. Populating fields from a separate table
  295. UPDATE query not happy with date fields
  296. Adding Appointment to Outlook Public Folder
  297. Simple Running Tally
  298. Letter Search for field
  299. Keeping total of items entered
  300. Assigning an access key to a command
  301. How can I remove hard returns (CR + LF) in a memo field string?
  302. 'Data type mismatch error' using Mid function in a query
  303. Concurso
  304. add record for each text box entry
  305. Problem w/AutoExpand in Combobox
  306. Assigning Values to Imported Data
  307. Display image on form via network path.....
  308. Pass through query to stored procedure
  309. adding records to table from text box values
  310. running Access Read Only
  311. Auto FE updater - Wkrgrp problem.
  312. Subform creates duplicate records in Main Form
  313. Filter a form on a field in a subform two levels deep
  314. Toolbar launch of the Print Dialog
  315. Strip File Name & Folder Name from path.....
  316. How to use DAO 3.6 DLL
  317. AccHelp future development - discussion please
  318. SendObject & Thunderbird
  319. Accessing a DB on a file server through ASP on the Web Server
  320. Using DHTML exit control for ie5
  321. Can you fill a query parameter from a list ?
  322. Find a word or phrase in a report in Access
  323. adding strings to a table based on their entry into another table
  324. Hidden fields become visible when filter by form--how to prevent
  325. Referencing enumerated fields in sub-forms
  326. Input multiple line text file into one access record
  327. VBA SQL Select stmt multiple rows found but not getting RecordCount > 1
  328. SQL Query to Calc Gas Mileage
  329. Snapshot Viewer Control in Continuous Form
  330. Trying to copy a record within a table
  331. Internet explorer
  332. query criteria for >today?
  333. Custom Pivot forms
  334. How to lock tables with vba code?
  335. At random selection
  336. manipulating the values from expression builder and inserting in fields
  337. Automation Problem Office 97 In Windows 2000 SP4
  338. Oko IDDE and DB-manager now shareware
  339. Alternative To Treeview Control
  340. Trying to open Access 97 application with non-admin NT user
  341. MDI FORM in MSACCESS
  342. Transfertext Specification Name *.ini
  343. Keeping running total of part numbers entered into seperate fields
  344. Access Caching data?
  345. FORMS!reference too complex to run SQL query error
  346. Best way to import and update tables?
  347. Code to Search Tables Collection for a Specific String
  348. Query to Determine which record is not part of a Master Record Table
  349. from access to oracle
  350. Clear 2nd Combo on form (MS Access 2003)
  351. Reports preview ok, but print in top-left 1/16 of paper
  352. Access application with linked table to MSSQL server, data not updateable
  353. search VBA code from button-click on Form
  354. Opening MS Access from a webpage.
  355. deleting a column adox
  356. Deleting a field
  357. Excel Automation: I am confused
  358. Format field data
  359. Locate folders & files on network server through form....
  360. SQL syntax: How to insert srting with double quotes?
  361. late binding ?
  362. Sub-Subform Problem
  363. Duplicate tab delimited text file
  364. How to confine user SQL to imported tables?
  365. Easiest way to display properly formatted US 10 and 7 digit phone numbers?
  366. How can I display the group header every time there is a new page of detail records?
  367. Access security
  368. Export Query To XML
  369. XML
  370. Linked form question
  371. exporting memo field from access97 to excel97 truncates after 255 chars
  372. Report the numeric position of the 1st character in a string
  373. When is MS going to improve the Relationships module?
  374. Unable to move to different record in continuous form
  375. I don't want to use "Bankers Rounding"
  376. How to automatically fill in a web page form field?
  377. calendar activex control
  378. form formating question
  379. One table link breaks every time
  380. Auditorium setup & equipment 8/22/05
  381. missing references
  382. Audit Trail
  383. capturing web data thru access...
  384. DDL syntax for dropping relation
  385. Create Self-Join Query In Design View
  386. calendar
  387. list with file names
  388. extract table field value
  389. report grouping by week, month, year ..
  390. Print new record to label printer
  391. Execute dbFailonError & Cascade Delete
  392. #Error issue
  393. Import records from one database table to another
  394. Can A Single SQL Be Written
  395. Can't Compact DataBase
  396. distributing Access
  397. Linking 2 forms
  398. Access very slow
  399. Validation Macro
  400. How to convert an integer to a string
  401. Having a report going across the page - with a heading at the start of the row, then values going across...
  402. Displaying a temporary recordset
  403. Normalization Question
  404. CONVERT MONTHS NUMBERS TO ALPHA CHARACTERS
  405. Access 2003 code corruption problems
  406. Get MS Outlook Version Info
  407. Tab control Question
  408. combo box AtoZ ordering
  409. Access Project - Lookup in table
  410. Digital Signatures
  411. How to create relationships with DAO?
  412. Printing list of fields
  413. Making white sections of a picture (used in a report) transparent.
  414. Repeat A String In A Textbox
  415. I get an error back when I pass a SQL statement using Nz function to Access
  416. apiPlaySound
  417. requery question
  418. Why doesn't A97 cancel the click event?
  419. main form disappears after paste-append action using VBA
  420. Result of INSERT statement not showing up in following SELECT statement
  421. Text convert Code please
  422. Referring to SubForm/SubSubform controls
  423. Timing a form
  424. Criteria for Access 97
  425. BiskyMisky
  426. Is there a 'break' or 'continue' in 'Do Unitl'... 'Loop'?
  427. I posted this question 5 minutes ago. But it doesn't show up.
  428. Is there a way for Access to read CRC from other files?
  429. Synchronizing two forms
  430. Need help displaying photographs
  431. Access Has Broken - Help please
  432. Hide Permanetly the Windows Menu
  433. Working with report wzard
  434. Problems with Form fields using Linked Outlook Contacts Table
  435. Query where used diagram
  436. Should I use a crosstab for this?
  437. Referring to a form control in an update query
  438. How to convert form with vb code to html file?
  439. display one thing in field while allowing something else to be typed
  440. Does Number Contain Decimal Point?
  441. How to query by date?
  442. Search up and search down behave differently when using Find?
  443. A97 Font / Report question
  444. use of Me. gives RunTime error
  445. the first sunday of a month
  446. SENDING FAX
  447. Making same report appear twice on one page
  448. Problem with skv files
  449. Daily normal and overtime rates
  450. A97 How to force uppercase alpha chars in a textbox on a form?
  451. Link to Outlook Address Book
  452. ADO Recordset: Undefined Function 'NZ' in expression
  453. Get status bar text
  454. Can anyone help me turn this into code?
  455. Error Importing Text files. Error #3011
  456. run VBA code in something other than debug mode?
  457. updating bound & unbound controls on a form?
  458. Combo box display problem
  459. Can I set index properties on compound fields?
  460. Opening Access2003 and printing reports problem
  461. Can a query "look" at whats already in 2 table fields before appending a rec w/ redundant values in those two fields?
  462. File name on a form
  463. Out of memory in Access97?
  464. SQL Connections
  465. Trying to calculate a Sum
  466. A97 update all Command Button and Textbox Caption properties?
  467. String Concatenation
  468. Updates from external datasource
  469. Validation Rules
  470. Disabling form when a new form is opened
  471. import field names from fixed width text
  472. UNIQUE FOREIGN KEY Constraint?!?!
  473. autoincrement problem
  474. Split Database Poor Performance
  475. Function to count workdays
  476. Summarizing values for "duplicate" records
  477. Code To Prevent Printing A Subreport
  478. Report with totals only, no details
  479. user function in a query
  480. Authentication Failed Message????????
  481. Problem with linked tables
  482. Identifying Access Databases with tables linked from other Databases/Files
  483. Attach Files to Emails generated in Access VBA
  484. TransferSpreadsheet using a Query
  485. Combo Box to Filter Records in a Continuous Form
  486. Open Form in Ms-Access from a hyperlink by using dhtml control
  487. Table rounds all numbers to whole integers
  488. limit data to textbox
  489. copy data from a selected table to another fixed table
  490. Deleting a field
  491. Setting an autonumber programatically
  492. I can't get the "path" description to work for synchronizing 2 forms
  493. Exporting a Report to Excel
  494. Limiting Database - is this a good idea?
  495. Report Help: Reading Records From Same Field
  496. copy a record
  497. Crystal Reports active x control documentation
  498. adding a memo field programatically
  499. Subform loses recordset - shows #Name?
  500. Parameter Query
  501. API Viewer
  502. Excellent Resource!
  503. that's all we need
  504. printing problems with A97 on XP Pro and A03
  505. DoCmd.Applyfilter
  506. refering to a subform control
  507. Need VBA for file requester please
  508. Subform AfterUpdate goes to first parent record
  509. A97 table design?
  510. wininet vs. ftp script
  511. How to avoid ftping data all the time
  512. Mail Merge
  513. distributed database library
  514. Set Toolbar Combobox items when Toolbar is called?
  515. Access 2k3 Forgetting my code? :(
  516. Global variables are slowing down the query
  517. Connecting to SQL Server
  518. "numeric field overflow" only on linked tables...
  519. MS access coding standards.
  520. Thanks a lot experts!!
  521. Is there OpenArgs for Report?
  522. Formating numbers: I want '9' to be '009' and '19' to be '019'
  523. test
  524. CommandBars in Access 2002/2003
  525. What do the field type numbers returned in the debug window mean?
  526. Data Exporting
  527. Viewing Reports
  528. Limiting the number of records.
  529. Exporting Data
  530. printer settings
  531. Hard return in unbound textbox printing in report
  532. Need archtectural advice. DB server or File server.
  533. How to compact the database in VBA?
  534. Database w/ client access (online) and estimator
  535. How to compact the database in VBA?
  536. tricky problem :-) - self references & direction
  537. FTP with the WinInet dll.
  538. Database linking
  539. Losing Import Specifications - Access 2002
  540. database linking
  541. Database linking
  542. Simultaneous Insert
  543. query on different tables
  544. Plotting Data
  545. Access 2003 cannot print help please
  546. Retrieving Autonumber
  547. form speed up
  548. Combo Box Rowsource set at GotFocus
  549. Access/VBA Conditional Statement
  550. Access/VBA Conditional Statement