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

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