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