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