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. Compessing an Access database
  2. Access users group announcements - acceptable to post here?
  3. After Update, After Insert
  4. Query shows new data in a table regardless of date limit
  5. Is this possible in a report?--insert graphics in page header and overlay detail
  6. Apps that transform csv into catalog-style database-driven sortable lists
  7. How to make Calculations using two entities in currencies
  8. Pivot Chart - inability to prevent rounding of data (Access 2003)
  9. A Simple Many to Many relationship db
  10. Number of data points in Access chart
  11. Import Errors - "Could not find..."
  12. Visual Basic class any help for learning VBA
  13. Probably A Simple Solution? EventProcedure Link to a Specific Procedure.
  14. Text value available for other forms
  15. ADP Project gives error when using the filter by selection option on a stored procedure
  16. status line updates upon export
  17. Selecting Distinct Rows From 1 Table??
  18. Creating AutoNumber Field Problem
  19. String sql problem
  20. Internet Value Retrieval
  21. convert a text field to a legitimate date value
  22. No error message displayed
  23. No error message displayed
  24. access query
  25. A2K3: query to return lowest of two sets of dates
  26. Entering data into subform
  27. Easy(?) SQL question
  28. Slowness when creating/editing reports
  29. How to create an AutoNumber field with a SQL statement?
  30. NotNull Query
  31. A question mostly about Word and Office and thus: OT
  32. Make Form Button close current form and bring switchboard to foreground
  33. Retrieving weekly totals from MSAcces
  34. Text Cut
  35. Help with Digital Signatures
  36. Input of "Inputbox"
  37. Input of "Inputbox"
  38. To hide columns in a form with datasheet view
  39. Scope of transaction processing wrapper
  40. String Length And Error 3035
  41. update a yes/no field using if then statement
  42. "Casting" an object in Microsoft Access
  43. Have form only open for one user at a time.
  44. Refresh of form
  45. Suggestions on how to create a scheduler in Microsoft Access
  46. VBA code to change the label text
  47. Acc2003: Magnify report in preview mode?
  48. seeking beta power user testing (off topic)
  49. connecting Access front-end to SQLServer back-end via code
  50. Syntax in DCount function
  51. Microsoft Flex Grid
  52. Groupung and Counting items in queries
  53. Clock in Form
  54. Checkboxes - How do I display values from a reference table
  55. limiting values in a list box that is based on another list box
  56. Having mega-problems with importation of 20,000-line text file
  57. MS-ACCESS with 180k / month record
  58. Can I scan an open table for CRLF's with Edit/Find or CTRL-F?
  59. Acc2003: Problem with UNION query in subreport?
  60. set a limit to the number of rows allowed in a table
  61. Access default menu missing
  62. Access 2000 & 2003 on same machine
  63. Issues with repainting a MSGraph object
  64. Looping Through Make-Table Query
  65. How to remove chart legend
  66. Query to get Table schema
  67. Upgrading advise
  68. Auto-number text field
  69. Removing the Auto Round feature for numbers?
  70. Which is faster?
  71. Create Relationship in access - Pls help immediately
  72. Recognizing keystrokes?
  73. Chkbox to check for duplicate records
  74. Carrying Fields
  75. Carrying Fields
  76. Carrying Fields
  77. Problem saving binary data in OLE Object field
  78. New Kexi for MS Windows released
  79. hyperlinks
  80. Another look-up combobox speed question
  81. Password Problem
  82. Grouping labels
  83. Looking up redundant occurences
  84. ShellExecute and MS Photo Editor
  85. Copy and Delete Linked Table in Access 2000
  86. [Access/VBA] How to convert a RunMacro with a "repeat expression" in a simple function call ? (no more macro !)
  87. Copy column into clipboard
  88. Budget Modelling in Access
  89. user permissions
  90. Adding several fields in a form and storing in table?
  91. Adding several fields in a form and storing in table?
  92. Bad screen painting - how come?
  93. Labels - Printing varying numbers
  94. How can I import CSV with Carriage Return?
  95. REQ: help with checkboxes
  96. How can i copy a table to a new table with primary key remain
  97. Need help binding multiselect listbox to table
  98. Check box in access
  99. Other Users don't see table updates
  100. Redefine data structures?
  101. Checkbox values change when print previewing or printing
  102. Function to supply the criteria for my IN Clause
  103. Assign Yes/No field numeric value then sum values
  104. Booking
  105. How to tell if you're on the last record
  106. Attempting to change same data same time
  107. Linked Table Manager -> Subform Crashes ...
  108. How to Set Time to 24hr Military Time ?
  109. Convert to Half Hour of Day
  110. date/time stamp
  111. date/time functions
  112. sending emails containing pictures
  113. Auto-schedule Data loading process
  114. Can I pass parameters from a macro to query?
  115. Convert Access97 to Access2003
  116. form message
  117. form message
  118. select query using arrays
  119. Missing in Action
  120. Field doesn't repaint
  121. trying to append from several different databases
  122. Refer to the Previous Record
  123. A97 runtime installation failure due to DAO350.DLL not registering in registry?
  124. Loop a shell command (batch file)
  125. Parameter Query, Link Oracle Table
  126. Problem Solving Skills for Engineers
  127. SQL command help
  128. SQL command help
  129. Corrupt Encrypted Back-end. Any suggestions?
  130. New : test yourself my new VB6 syntax analyzer.
  131. Recordsets and archiving
  132. Help - has lost ODBC connector access to Webhotel
  133. Parameter Values in a Report
  134. lebans richtext control, subform question
  135. Access Subreport objects from vba code
  136. Networked Database Woes
  137. Connecting to ODBC DB at startup
  138. TROLL ALERT - take care when talking to Br@dley!
  139. Updating MS Access tables from a query
  140. Disk Farm
  141. Mouse scrolling in A2k
  142. Product Relations List Box box help....
  143. BOM, with Joe Celko Nested Sets
  144. MS Access in UNIX Server
  145. Automatic updates
  146. Query 3 seperate tables
  147. Custom Buttons
  148. Getting things to appear on a screen
  149. Cool combo box functionality desired--changing sort order and highlighting
  150. Cascading Combo Boxes on continuous forms in Access 2000 - SOMEONE PLEASE HELP
  151. VBA reference problem
  152. Problem with displaying Unicode in Chart object (MS Graph 8)
  153. Runtime options
  154. detecting network connectivity
  155. (FIND&REPLACE) inside a Popup/Modal Form?
  156. Determine object type if have name?
  157. Query textboxes on when Not Null
  158. Dynamic Field Color Change for whole form?
  159. Assign values to new Record with info form last record.
  160. select all entries in a list box
  161. Form Does Not Refresh
  162. KeyPressed and KeyCombination Control?
  163. Password on close (again)
  164. Parameter Promp After Form Closing
  165. Adding Rows
  166. Find record problem
  167. Error with AppendChunk() and MEMO field
  168. Search Button
  169. Access FINDandREPLACE Dailog Problem? acCmdFind
  170. Format in £ rather than $
  171. Simple problem with combo-Box Text
  172. Database Splitter
  173. search
  174. Has anyone used the IADsOpenDSObject in Microsoft Access 97?
  175. Jetcomp crash
  176. padding text fields with blank - MSAccess vs. OLEDB Jet4.0
  177. Export to Word Bookmark
  178. Alert Boxes in Access
  179. subquerys use A97 format in A2000
  180. Wireless Connection - Non-Jet Back End
  181. saving data
  182. programmatically obtain the hard disk's serial number from VBA?
  183. Charts Erroneously Showing Design Data
  184. For...Next in subform
  185. ACC-XP(2002) - Create RunTime code?
  186. Help with SELECT syntax
  187. Raise Event from referenced mdb to Main.mdb
  188. Read and Import folder names from a CD?
  189. Windows 2003 server
  190. subform visibility should change depending on drop down selection
  191. Handling Calculated Historical Values
  192. Checking before adding a new record
  193. Having problems updating one table from another.
  194. Tab Function
  195. ADO refresh problem...
  196. On Error Resume Next
  197. Not In List Error
  198. Joining two tables on two fields
  199. connect as Access 2K DB from Access97
  200. E-mail word document as an attachment from Access
  201. ODBC connect to remote SQLServer
  202. PrintPreview messing with DetectIdleTime code ?
  203. Query ignoring functions returned value
  204. Taps for DAPs
  205. Difficulty displaying graph in Form View that I see fine in graph control on form opened in design view
  206. E-mail
  207. Report to PDF and Email it - Sorted
  208. Set appointment in Outlook on other computer
  209. Setting hyperlink for email
  210. A Query / Report Question with a difference.
  211. Usining Replication
  212. calender ms access the same as outlook
  213. Wireless connections, trace them in a LAN?
  214. Autofilled field after chose value in another combobox
  215. No solution on Wan.
  216. Adding My Contact Details to Reports.
  217. Extracting OLE to pdf
  218. Export file from BE mdb to BE folder
  219. Really ODD image loading error in Access 2003
  220. Anding a field for record count. Same address multiple name.
  221. Slow data access on Network(LAN)
  222. A97: Autonumber values growing by leaps and bounds?
  223. Find Dialog Box - Detect When Complete and No Longer Displayed?
  224. Emulate desktop shortcut start in directory
  225. Replication
  226. How do I set MS Access NOT to use my profile's 'My Documents'
  227. REQ: Help with querying check-boxes
  228. Need help with a conditional formatting string
  229. where is the SQL for a pivot table?
  230. More to Command Button
  231. Command button to open Find dialog
  232. Change a text box to a combo box in VBA
  233. SQL DECODE FUNCTION
  234. disabling fields
  235. SendObject problem
  236. docmd.sendobject ...sending a non-Access object
  237. Limited number of updateable fields in update query??
  238. Automating folder export from Outlook to Access
  239. Access listbox auto sellect
  240. Tenths and hundreths of second
  241. Making a lot of stuff Visible and not Visible on a Form
  242. Linking Tables to network Database
  243. Runtime errors: ADO (80040e21), DAO (3001)
  244. Populate word Userform from Access
  245. grouping a field in a query
  246. saving data
  247. OT. Fax Server With Access
  248. Access97 How to have a visible cell reference from another DB or SS
  249. autonumber query to number in another table
  250. SQL Insert, Autonumber, and End of Table ???
  251. Quick Question about Missing References
  252. Outlook Express
  253. Colsing a for with dissolving of the form
  254. InnerJoin + Left Outer Join syntax problem
  255. Suppress the "Loading Image" dialog
  256. Distinct records in report
  257. Using Access MDB on a Linux Web-Server possible?
  258. access 97, too many nested subforms, is there a workaround
  259. Export
  260. How to Auto-Document Access 2003?
  261. Dynamic MS Access Form Help
  262. Help using form filters
  263. Attaching SQL Table w/o DSN
  264. delete report fields if no data
  265. Query by 24 hour Shift
  266. help with looping through array required!
  267. Open form using list box (compound key)
  268. A2K - Odd form closure problem - REPOST
  269. HELP ON WAN
  270. Lebans Rich Text Control LDB/Locking Problem
  271. Query criteria that isn't bound to a single form or report
  272. Country, State/Province, County, Region, City
  273. Main form with 2 subforms - Error: Method 'requery' of object '_Subform' failed
  274. Convert MS Access DB (FE&BE) to Oracle
  275. Link to Oracle tables with VBA
  276. Records Getting Deleted from Key Table
  277. Relationship getting deleted by itself!
  278. Audit Trail For Access DB?
  279. Calling query which uses alias results in different value
  280. Calling query which uses alias results in different value Version
  281. Chart Help Needed
  282. Form design for questionnaire
  283. urgent req with our Direct Client
  284. Normalization and AVG across columns
  285. Delete Posts
  286. Please help me with memo fields
  287. Report
  288. queries - null value
  289. Mobile Device and File Dialog Box
  290. Configure Report
  291. Any recommended Excel forums???
  292. A2k - odd form closure problem
  293. chart object drives me nut
  294. Reading Microsoft Access Macros via VBA code
  295. query questions
  296. Opening folder when the folder name has a comma in it.
  297. VBA to Yahoo, MSN or AOL Instant Messaging?
  298. Help using form filters
  299. Cmd to open AddTable Dialog (A2K/SQL Server)
  300. ftp using Internet Transfer Ctrl
  301. Open a new browser window in a Data Access Page
  302. Exporting images (ole object) from access to images folderfolder
  303. Setting a Key to update cascading table
  304. Importing multiple files..
  305. Access Report : Calculated field3 = field1 + field2
  306. Deleted column in a Table linked to 35,000 entries!
  307. event in access
  308. access problem please i need your help
  309. Invalid Command Line Switch: 'I' in Access 2k
  310. modifying relationships using DAO?
  311. Date and Time calendar
  312. Count Items in a report
  313. Select Count(*) question
  314. IIF in Query Design
  315. Run-time error '6' Overflow
  316. Run-time error '6' Overflow
  317. How to retrieve the date of record creation?
  318. Efficient way to store photos
  319. Userform as subform
  320. get MSDASC.DataLinks COM Object used CreateObject function in VB or PB
  321. From text box to field
  322. Who started me?
  323. Access or SQL Server 2005?
  324. Sharing a backend over the internet
  325. Numerically incrementing a string
  326. Converting Access system to Chinese version
  327. Combine multiple records into one
  328. SendObject & A2K SP-3
  329. Access 2003 Error Distributing .mdb
  330. ForceNewPage Property
  331. Any way to remove the AutoIncr / Autonum attribute using DAO?
  332. drop list to fill in the blanks on a form
  333. Displaying multiple field values in 1 query record
  334. What is wrong with my code??
  335. A2K - plausible to change recordsource for reports in MDE?
  336. Developer Don'ts: Nonsense Progess Bars
  337. Not in the list
  338. Decimal Symbol
  339. Auto-Populating a field in Access
  340. Option Group Counts
  341. inventory and pos
  342. urgent req with our Direct Client
  343. using an update query to change multible things...need help
  344. Complex Copy Function
  345. Query with user-defined function doesn't appear to work.
  346. Underlining in Hyperlink not Showing up
  347. Can someone help me?
  348. Access XP Bug - Linked Images - Any Solution??
  349. Continuous Forms Question
  350. Leban's A2000ReporttoPDF Functions: Can you stitch many SNPs into one PDF?
  351. Counting Days in Access
  352. MS Access - "Parameter Incorrect" Message : Stored Procs
  353. Exporting jet table metadata as text?
  354. Unable to link to backends on another computer with A2003
  355. Middle record in a form
  356. Peronnel Area Reporting Database
  357. query/subform question
  358. Adding a New Record to Access form using Visual Basic in Excel
  359. Synchronizing 2 subforms of same table
  360. Formulare miteinander verknüpfen
  361. Building Access Applications "Inventory"
  362. Table with only the last record
  363. access database
  364. textbox: counting & editing
  365. Type Conversion Failure
  366. record navigation icons
  367. Any way to change the OLE type in an OLE field?
  368. Selecting Last 2
  369. How to Maximise MS Access and Bring to Front
  370. Kill Process
  371. Subtracting select queries form each other (each select query has multiple conditions)
  372. Conversion of an MS Access application
  373. How to calculate the difference between values in preceeding records
  374. Simple Report / Query Question
  375. How to have other fields on form autofilled after I choose a value from list box
  376. Getchunk and AppendChunk
  377. Translate CrossTab Querys (Please Help!!)
  378. Combobox slow to drop down
  379. Pass Throughs and Reports - Record Order?
  380. Combobox slow to drop down
  381. Reorganize Databases
  382. Overtime Query
  383. REQ: any utilities for designing front-ends for databases
  384. Overtime Query
  385. Network Files Inaccessible
  386. Check Box clearing
  387. Julian Date Conversion - Can Anyone Help?
  388. Calling queries from MacroVBA - where query has a parametercriteria
  389. Query-by-form; using a criteria on a combo list
  390. searching using text box and query
  391. Cross-joins and non-updateable record sets
  392. Need to Connect to Oracle DB with no ODBC
  393. While using Shell to open a new instance of same database, using vbHide to Hide the new instance fails.
  394. Time over 24 hours
  395. Database corrupt error while posting large transactions
  396. access 97 upgrade question
  397. Recalc or refresh - focus current record in subform lost
  398. List Box gives Null Values
  399. znaczek "+" do ukrycia lub pokazania szczególów rekordu?
  400. Automation operations
  401. Access 2003 ADP
  402. Using Access and MySQL over Internet
  403. Using Access and MySQL over Internet
  404. Hide Controls
  405. After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.
  406. Lebans ListView - More Columns
  407. Design question
  408. Calculating total number of fields in a table
  409. This is simple in excel....not in access....
  410. Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica
  411. Record locking
  412. How to run an updated query in macro
  413. How to run an updated query in macro
  414. How to run an updated query in macro
  415. Set control property using variable for report name?
  416. deleting records
  417. Parameter Query
  418. DateDiff in Query
  419. recordset cashing
  420. Limit to even numbers
  421. Similar Programs - MS ACCESS
  422. Add Filter to Report
  423. Missing Reference because of multiple Outlook Versions
  424. Couldn't update multitable form (3 tables)
  425. Splitting windows like Excel?
  426. DLookup criteria problem
  427. automate button click event within vb using web browser
  428. Hiding the mouse pointer
  429. Create MDE causes Access to crash
  430. How to check if a database is .mde in access 2000
  431. anyone interested in a hotel reservation system
  432. Lost Bookmark
  433. How to handle CD and DVD drived in VBA?
  434. Need help with SQL Select statement using LIKE
  435. Enabling / disabling functions
  436. List of objects at left of screen disappears
  437. Need process for selecting available reports
  438. Store files on SQL Database
  439. How to retrieve the date when a record is created in an Access
  440. access 2003 form to count fields with data
  441. Outlook/A2003 compatability problem
  442. How to do group header?
  443. help with message box
  444. DoCmd.TransferSpreadsheet
  445. Attaching .xls file from a saved location
  446. urgent req with our Direct Client
  447. Control query-datasheet launch position
  448. WebBrowser ActiveX Control
  449. help require for algebra function??
  450. Control query-datasheet launch position
  451. Subform Displays Data from Record #1 (not current customer) - HELP!!
  452. Revert mde to mdb - Possible
  453. INSERT INTO Acess 2K table from Visual FoxPro DBF
  454. DoCmd.GoToRecord , , acNewRec
  455. Form fields lock after update in combo box
  456. MS Access Now() minus preset amount of Minutes
  457. Books on SQL for Access
  458. Many-to-Many with SQL
  459. Filter by Form - not working
  460. Create Form-Subform to Perform Searches
  461. Access 97 takes 50% of my cpu :~)
  462. Convert all folder contents that are xls to csv
  463. total minutes in access 2003
  464. Vertical labels on forms are invisible
  465. Trying to sort transactions by time
  466. Set recordset field contents to string
  467. Automatic historical archiving of data for comparison
  468. limit two combo boxes with unrelated data??
  469. Value Lists
  470. Value Lists
  471. Help needed with SQL Select
  472. Rebuild Form From Scratch?
  473. MSACCESS 2003 CREATE PROC
  474. automatically retrieve value from a range table
  475. Querying for No Records?
  476. How to create a decimal number in Access?
  477. Relational database design
  478. Calling an MS-DOS command
  479. MS Access Reports
  480. How to read Access Data Access Pages with vb .net
  481. Creating a Mailing Sheet using Data - PLEASE HELP
  482. complex insert and vba
  483. I am a beginner
  484. urgent req with our Direct Client
  485. Access 2003 performance on datasheet view of bound form
  486. Run a script to alter a column in a table?
  487. application.printers port problem
  488. Multipy Entries tying to same reference table
  489. C# .NET to MS Access OLEDB - Security error
  490. update query help. error??
  491. Why does detail section scroll behind header?
  492. Access Database Programing Questions
  493. change default printer to network printer
  494. Updating a shadow DB
  495. Adding Tables and Forms to an Application
  496. Will Access 2003 open and run A97 mde files?
  497. sending email crashes with ms acecss
  498. ms-access database cannot be updated
  499. Building a Complex Crosstab
  500. Problems importing Excel into Access
  501. Formatting as Date in a query expression
  502. Form Filters or Rebuild SQL Statement as Recordsource?
  503. SQL Server Express: Anybody Using It?
  504. What's wrong with my code?
  505. ListBox, ListIndex and ListCount. A BUG???
  506. Repeating information on report fields
  507. Subreport not showing - but my frustration is
  508. A97 Runtime - Records can't be read. No permission on MSysModules2.
  509. Custom Collection Class woes
  510. Odd recordset behavior
  511. SourceTableName truncate
  512. Report record source
  513. update query- HELP??
  514. A2k - what the hell is TID?
  515. error messages?
  516. a2k - bizarre subform bug
  517. Directory tree scanning
  518. Row Headings in a Crosstab Query
  519. Subform Wizard and number of primary key fields
  520. Pivot Table Help
  521. How will we use .Net in future versions of Access
  522. Is ADO Dead (3)?
  523. Possible to open list box when clicking on text (beside arrow)?
  524. Auto filled in values from another form after choosing value from list box.
  525. How to be auto jumped to last reord after opening form?
  526. I do not want first caracter capitalized, how?
  527. Is ADO Dead (2)?
  528. Is ADO dead?
  529. Run-time error
  530. How to add restriction that field is empty.
  531. Not getting login prompt
  532. How to change the color of the buttons or the button from the switchboard?
  533. New to Access search field
  534. Multiselect list problem
  535. Lookup table question
  536. pause "on current"
  537. A97: Am having difficulty getting msaccess.exe written to target drive in runtime rollout
  538. how do u send an email using access?
  539. how can I save all database on a CD?
  540. DCount
  541. VBA: Reciprocal functionality ?
  542. Report, Form Argument in a Procedure
  543. Access 2: Can't Perform Join- Combined Fields Too Long
  544. How to set a background color with certain HEX, DEC or RGB value?
  545. Setfocus jumps to next field, but default value is selected in that field.
  546. Want to insert logo with transparant background but get white
  547. How to set the selection-bar- and selected-text-color in a list box?
  548. Select data from other DB
  549. Help with Conditional Formatting
  550. MS Access as front-end for Paradox database?