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