Home : Bytes IT Community / View Full Version : MS Access


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

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