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