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