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. Access to ASP/VB.net converters
  2. Bypassing a dialog
  3. Linking Forms
  4. Can't repoint linked tables
  5. Subform and .dataentry property issue
  6. First MACRO executed in an Access application
  7. Now()
  8. numbers rounding up in table
  9. A2K3- quick SQL help needed
  10. Transferspreadsheet Trapping Error for Duplicate records
  11. Help Creating Small Table In Memory
  12. Dlookup problem
  13. new record
  14. A97 - how to transfer a file from https?
  15. Why is it a bad idea to create new databases or tables every year??
  16. page breaks, printing and vba
  17. Summary query causes Access to crash
  18. Displaying a Cross Tab query on a Form
  19. Updatable query - Many to Many
  20. Need configuration help
  21. Group Data/Copy Row Two Field to Row One Field
  22. network error connection
  23. Why does fso.MoveFolder fail with "Permission denied"?
  24. Find the last number of a record
  25. simple function record into array
  26. Access VBA project locked
  27. SQL Server - Filter
  28. Whut I dew?
  29. Array Help
  30. Array help
  31. SQL Format leading zeros
  32. form layout
  33. struggling with a query
  34. Array help
  35. Default Survey in AT YOUR SURVEY form
  36. Access links, hyperlinks and headaches!
  37. field that uses the now expression for date and time does not enter the data into my table. Why?
  38. ucase or an expression that makes lowercase letters turn to uppercase automatically
  39. ucase function
  40. General sort order
  41. MS Access 2002 problem: linked form fields in ODBC queries
  42. Outlook Contacts
  43. Compact db corrupts link to another
  44. Search for plain text variables in word document
  45. Locate plain text variables <*> in word doc
  46. Back Style Property on Tab Controls: Disabled?
  47. access field merging
  48. How to change the properties of Text box depending on the value of combo box.
  49. Locate plain text variables <*> in word doc
  50. Search for plain text variables in word document
  51. Help needed on picture files in access
  52. Search for plain text variables in word document
  53. Database Schema
  54. Corrupt VBA project in the database
  55. Cannot access form fields from VBA
  56. AppPath in A97?
  57. run-time error 3073
  58. A2K3: design for pupil incidents database, help needed
  59. Week number to date??
  60. Create A List Of Dates In A Month
  61. How to control scanner from Access?
  62. New to ODE 97 Help Workshop Utility - How to compile a short test topic file?
  63. Transparent background of image on A97 report becomes opaque when printed. Hmmm?
  64. Lookup Date Table for Mising Date
  65. Using ".OpenCurrentDatabase" in VB .net to open an MS Access DB
  66. How do I setup a Countdown Field in Access 2003 Form
  67. Is a txt file Read-Only?
  68. Date Countdown Field
  69. linear Interpolation of data in a tabel
  70. Seeking opinions on code that utilizes internal represention of dates
  71. Maximizing Access Report From VB
  72. append issues: clear table code?
  73. How do I handle this referential integrity situation?
  74. How to use OutputTo with named query?
  75. Autonumber Format/Reset/Etc.
  76. Continuous Form
  77. Indexing Service and Access Files
  78. SQL query - combine sum() with getting latest record by date field
  79. radio button/combobox focus
  80. Insert OLE object in Access 97
  81. Graph/Range help needed...
  82. copy value from previous record!
  83. Access database used as OS interface?
  84. Linking Databases - Methods?
  85. linear Interpolation of data in a tabel
  86. cannot lock database
  87. Automatic Date Entry
  88. windows dialer and access
  89. Query and display record number only in a webpage
  90. a97 - problem transfer file from server with https
  91. Could Not Lock File Error 3050
  92. Week form
  93. Screen resolutions needed for development enviroment
  94. Could Not Lock File Error 3050
  95. WeekDay help
  96. Access Report to multiple PDF files
  97. merge with word using query with user entered paramiters
  98. Why does Alt-Return bring up properties sheet?
  99. Putting MS Access on the Web
  100. Why did Access just close when I tried to save a form
  101. POST to website with authentication
  102. replace Rs.AddNew with INSERT
  103. Passing search parameters with hyperlink to an ASP page
  104. odbc timeout
  105. SQL syntax - leading zeros
  106. Merge to MS Word
  107. Export Filtered Form to Excel
  108. Digital Signature for Access 2003 Project
  109. Changing Data Type - Text to ReplicationID
  110. Data Entry Only Form
  111. help with funtion (expression builder)
  112. graph
  113. design question
  114. One table or three?
  115. Modules Access 2003
  116. Modules Access 2003
  117. Interpolate data from tabel
  118. Update Links
  119. Autogenerating chart
  120. A funny problem to have
  121. Set background color of a column in a subform in datasheet view
  122. sorting between two spreadsheets
  123. Change "lookUp Method" to code used in a linked table
  124. How to have the face of button changed when pressed?
  125. Images w/ transparent background in Access?
  126. Which hardware upgrades are more important
  127. Create folder inside Queries & Forms Tab?
  128. Where can I find reference documentation for Access?
  129. Problem with Query data in report
  130. A2K - how to detect any change to a database to avoid unnecessary code execution
  131. Can I read the value of a textbox control on a report?
  132. Converting student scores to grades not that easy?
  133. "docking" forms
  134. Strange problem loosing data based on physical machine
  135. A2003 - Tab to Tab Focus
  136. how to update new password to existing table in a custom login form using macros or query?
  137. which approach? (cofused with tables)
  138. Creating dynamic sql
  139. form controls not really null??
  140. Line intercept - mschart
  141. Using combo box element as search criteria
  142. reading data in to Access From Excel
  143. How to automate PaperPort?
  144. availability of Jet DB engine on Win 200, XP, Server 2003
  145. Weird NotInList behaviour
  146. availability of Jet DB engine on Win 200, XP, Server 2003
  147. availability of Jet DB engine on Win 200, XP, Server 2003
  148. Search multiple MS Access database files via asp.net web application
  149. Basic query question regarding parameters and grouping.
  150. Autoincrement versus GUID
  151. Programatically accessing "object groups"
  152. Multiple database problem in A2003
  153. Report/Form event "On No Date"
  154. Queries with identical SQL code behave differently (one is expandable)
  155. Add column color in datasheet view
  156. Add a defined number of records to a table
  157. creating email attachments
  158. Access to Quickbooks
  159. Add record in grouped data access page
  160. Is David Fenton right about error handling? (re-post?)
  161. Access autopopulating field based on condition
  162. Is David Fenton right about error handling?
  163. Tooltips not working
  164. reselect random items
  165. Linking databases using ADO
  166. setfocus and report creation problem
  167. Best solution? (too few parameters. Expected 1.)
  168. Problems while making MDE
  169. export to excel with criterias
  170. #Name? Error... trying to link two fields in same form
  171. MS Access to Oracle Database Conversion
  172. Subreport visible property
  173. Field on Form = next record
  174. Validating "Orders" form
  175. Subvalues -- like submenus? How can I do it?
  176. No fields selectable for report
  177. calling C# .Net dll from VBA
  178. Create table from query?
  179. How to add a record in ms access
  180. How to add a record in ms access
  181. Unbound Nested Subform Simulating Continuous Form
  182. different permission for different users for password using tables and forms
  183. Need help with accounting database
  184. Active X not in Toolbox
  185. Which is best - recordsets/VBA V SQL statements for updating data
  186. How do you record multiple values into a column??
  187. File Name in Add-In Manager?
  188. Moving data from one list box to another via a button
  189. ??? for Wayne Gillespie on FTPClient Class Module.
  190. MS Access: a true RDBMS
  191. How to get cursor focussed on field field after new record?
  192. After closing Design View, the table appears instead of form
  193. Autonumber ID not yet visible when starting new record
  194. attaching picture to table
  195. Happy New Year
  196. Erl
  197. Change event trigger
  198. detail section in a report
  199. Licensing versus Customization
  200. Importing Text File that is vertically oriented
  201. After insert of date how to auto jump to next field
  202. Only get 1st record viewed in Report.
  203. DAO peculiarity in A97?
  204. Calculate Date Difference and display message box
  205. rendered date
  206. VBA for ACCESS
  207. Find and Replace against set of rules in 2nd table
  208. Carry data over to new record...
  209. =Iff(([Me]![Gender])="M","Male","Female")
  210. Edit multiple tables with one form per record
  211. Help with blank fields
  212. Help needed with ONLY VBA Code or Query
  213. Year Numbers
  214. Report / Query Problem
  215. Reports
  216. Using MZtools Freeware for VBA
  217. Run Update Query silently in background
  218. Run Update Query silently in background
  219. Create Macro to import fixed width text from clipboard or text file and update table
  220. reset number on new year
  221. Runtime error has occurred
  222. Creating Runtime DBs with Access
  223. move relationships from dev to production db
  224. How can I Display Visio Drawing?
  225. one to many howto????
  226. ComboBox Progressive Requery
  227. Minimized Database window moving way off screen
  228. merging tables
  229. navigate form with arrow keys
  230. calculating age from DOB and adding to table
  231. close form macro
  232. slow query
  233. Combo Box Progressive Requery
  234. How to increase the performance by working with linked tables
  235. Help with SQL query
  236. Clearing a combo box
  237. Hyperlinks inside an Office Assistant bubble?
  238. Hyperkinks inside an Office Assistant bubble?
  239. SendKeys help required
  240. subform refresh
  241. How to import..
  242. Adding a range of numbers from a form to a table
  243. datepart problem in VB code
  244. Problem with DateDiff
  245. add one to string in sql query
  246. Access 97 / XP sharing problem
  247. 2 Beginner Access question
  248. Reversing a COlour Code
  249. Sorting a SubForm
  250. Trouble with order by clause in report
  251. Off Topic - Access to Postgres
  252. TransferDatabase problem
  253. Nulling field in subform
  254. Tips to document Access program
  255. Lebans ReportToPDF solution Help
  256. Date Validation: IF's vs Case
  257. Probably a very simple problem, but it's got me...
  258. Adobe Acrobat & pdf.ocx - The Paperless Office
  259. failure in saving new added field
  260. A very basic search form in access
  261. 2 queries OK by themselves, FAIL in Union
  262. How to store folder path as Hyperlink?
  263. VB code to perform custom query of MS access table and display alert
  264. Run-time error
  265. Access Report is giving extra blank pages
  266. data in a tex field on an unbound form
  267. trying to copy an Access 2003 pivot table to excel or word .... or something
  268. 'Converting Varchat to Int' problem
  269. Relationships
  270. Not sure I understand what Response.buffer is really about
  271. MS Access adding dates
  272. Create Dynamically Built Data-Entry form to enter data into two tables
  273. Timeout while DDE linking to a VB application.
  274. query not working when i add an alias
  275. Runtime version overwrites full access
  276. calling excel function LinEst from VB
  277. Access to VB
  278. How to do a hyperlink inside of ...
  279. Choose Month & Year when giving report criteria
  280. Synchronising/replicating access with sql server
  281. serialize/deserialize Access report object
  282. Choose Month & Year when giving report criteria
  283. Pivot Tables Access vs Excel
  284. Use Select Query variable against a table and return value to same select query
  285. DeleteDuplicateRecords
  286. Progress Meter does not refresh during series of OpenQueries
  287. How to join two fields
  288. Left(field,Numchar) or Right not found
  289. Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
  290. NZ always returns a zero-length string when used in a query expression?
  291. backup databases
  292. Access 2003 unable to link to ODBC but 2002 on same machine can
  293. Duplicate record check
  294. Hyperlinks
  295. Sending SMS from Access
  296. UserForms
  297. forms only show primary key
  298. Scroll bar strangeness on subform
  299. Calendar Control turns white on new record
  300. automatically append new records
  301. OldValue not set
  302. form property for subform
  303. Help required formatting a date field in a SELECT statement results
  304. A2K3 & object dependency refresh
  305. What's with ADO?
  306. Assigning common id based on evaluation of two columns
  307. Select ALL from an unbound form for query parameters
  308. Totally lost on Date Sort
  309. Crosstab Query: Sort Column heading based on other column sort
  310. Cross tab Query: Sort Column Heading based on other column Sort order
  311. Split Database Security Problem
  312. Query has a problem with December??
  313. error -2147217904 - how to fix :o( ?
  314. A2K - passing more than one value into a popup form
  315. MS Access, PostgreSQL 8.1.1, connection string
  316. ODBC, connection pooling
  317. Using seek to find if a record exists
  318. error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
  319. Can lines collection be used to assist me in automatically numbering lines?
  320. GetSetting function breaks when code-signing
  321. Invisible textboxes on subform
  322. Database design question
  323. Filtering on a form
  324. Checkboxes verses field list boxes
  325. How to pull the newest record for each student out of a table
  326. after update not triggered
  327. OT. Happy Holidays to you all
  328. Opening form in datasheet view
  329. CurrentDb problem in report
  330. Need to add trailing 0's
  331. Problem with Left function
  332. Query Shows No Records
  333. Developing in Access 2003 with conversion problem
  334. setfocus to access application
  335. Packaging for multiple office versions
  336. MS Access Send To recipient (not as attachment but as HTML)
  337. A97 Runtime - I wish to disable F-11 key from displaying database window
  338. Sorting many fields in a form
  339. How can I enter several lines of text as a criterion and return several lines from my table?
  340. access 2003 validation rules
  341. lInking subforms
  342. Unable to edit form - Many-to-Many relationship
  343. What is a Library mde/mdb?
  344. on open and before exit events
  345. Access2000 data Entry Unbound Form With Subform
  346. Contingent formatting
  347. Developing in Access 2003 for Access 97 users
  348. Saving information on reprot to new table?
  349. How to stop library mde being reused
  350. Can't link forms
  351. An aid to inserting a Date, Small calender pops up
  352. Scroll bars are not appearing in certain situation.
  353. Customer keeping track of invoices received and paid.
  354. Access 97 Problem: only one printer shown in the printer screen
  355. Picture Importing
  356. TransferText dropping fractions
  357. Is Access smart enough to optimize this ?
  358. pasting records in datasheet-form: pass-through called twice ?
  359. Horizontal Scrollbar
  360. coloured lines of alist box
  361. Set Warning? Maybe?
  362. Need help on updating text box!
  363. video rental database?
  364. Making MS Access Form as a standalone form like in VB
  365. Can anyone recommend a Dot Matrix printer for my DB?
  366. Run external application script from access?
  367. problems with DSN for MS Acess database
  368. Reading image files from a URL location
  369. MS Access 2003 sending emails
  370. better way
  371. HELP 97 -> 2K and lost all relationships
  372. Help with a query trying to total!
  373. Subtract MULTIPLE time segments from a single time segment to calculate cycle time
  374. ControlTip Text
  375. Trouble With Left Join
  376. Dlookup
  377. mappoint looses forms focus
  378. Combo Box Recordsource When using CodeDB
  379. dcount, dsum, dlookup question (not syntax)
  380. Forms - pagebreak Visibility
  381. NetSearch the Business Intelligence Search Engine
  382. Creating a checklist from a table to indicate attandance
  383. hide form on startup
  384. Can't figure out error in simple dsum
  385. Data Conversion Error
  386. subform within a subform
  387. Help in generating a report
  388. make table query
  389. Can a variable hold 2 values simultaneously - a string value and a numeric?
  390. VBA Query code issue........
  391. Connect 2 subforms
  392. Dynamicaly created where clause for OpenForm
  393. Access versus MSDE versus SQL Server Express
  394. Database design - incorporate year of a certain event
  395. Error 3075 Function Not Available - but no missing references
  396. Strange findfirst behavior
  397. How to vary the number of copies of each record in a report in A97?
  398. Forcing Cursor To Specific Record/Field On Continuous Screen?
  399. Goodies in 2003?
  400. SQL Insert Into Error
  401. Parsing
  402. Transferdatabase
  403. how to determine whether any report is opened?
  404. I've never seen A97 combo-box wizard fail on a valid query until today...
  405. Key based on Login entry
  406. Listbox value does not change
  407. Properly using checkboxes in a datasheet form
  408. HIPPA - HealthCare Cliam Transactions
  409. Can you import images into access
  410. Export MS Access table via OBDC using VB
  411. real record in a subform
  412. mixing linked tables
  413. Input Mask for dateformat dd/mm/yyyy hh\:nn
  414. A97 - Forms - Rail Road Track layout
  415. Copying root directory
  416. Windows Explorer Switches
  417. 2 Combo Box Menu from Multiple Query
  418. pivot chart
  419. Sending report to a PDF File. Good link for Access developers
  420. Function DatePart(), how to subtract the month from a date field
  421. entering data from form into two tables
  422. Combo box dependent on another combo box, text part is blank
  423. gtotal
  424. attaching MsSQLServer(msde2k) tables to Access2k
  425. Trying to total a text box in report
  426. Update an account balance on a daily basis
  427. several questions regarding graphs
  428. recordset.MoveLast - "not enough space on temporary device"
  429. Backend on the internet?
  430. Execute database to Excel exportation stored procedure from VB
  431. query how to
  432. open excel file
  433. open excel file
  434. Updating combo box
  435. dynamically create Tab Control possible?
  436. Setfocus question
  437. default value help
  438. Table exceeding one million rows crashes Access
  439. Filtered Colum To Single Comma Delimited Value??
  440. MS Access forum
  441. Default sort order
  442. Analyze Tool & Lost Data
  443. Add value to subform from main form
  444. Datasheet View: Second Combo Box Criteria Based on First Combo Box Value
  445. Access Reading and writing emails
  446. ftp from Access: problems
  447. Help with a report field
  448. Subject: Access Reading and writing emails
  449. Access fails if printer is out of paper
  450. Removing duplicates from query, but not from table
  451. I have carried out the Keith Wilby stepwise approach to securing an MDB but I am not sure what I have achieved
  452. Loosing Db connection?!?!?!
  453. Text becomes available when check mark is placed
  454. How to Test Function in Immediate Window
  455. Self join. Employees and supervisors query.
  456. Access 97, W2K, "can't open the mail session"
  457. Help with query to extract next best product
  458. Securing only certain forms?
  459. Printing to a dot matrix printer
  460. Enhancing the FAQ. Please suggest enhacements....(new topic, getting closer...)
  461. VBasic window opens with references grayed out
  462. Sum of Sum in Totals Query
  463. Trouble with concatenated string function
  464. Opening one database always restores a minimised database
  465. vba to activate a command button in a different though open form
  466. invalid operation
  467. The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record
  468. Arrays in Access.
  469. Can't get subform on tab control to requery
  470. Query help!
  471. Forms: attaching labels to a combobox
  472. move next
  473. Need help with ValidationRule
  474. Suppression of auto-fill-out of MS-ACCESS
  475. Getting the right software without getting ripped off
  476. auto email
  477. Creating a dynamic form, how?
  478. I wish knowledge as to creat a Bibilical data index i.e. Genesis to Revelations not alphabetical!
  479. Form navigation buttons do not show correct position
  480. How to Compress/zip files from MS ACCESS and then send it by email?
  481. Returning orders
  482. how to know the record position shown in a form?
  483. configuring access for all users
  484. MOST recent date
  485. Help! Public variable not staying set - 3420 Object invalid or no longer set.
  486. Combobox Not In List Event
  487. Proper use of global variables for reports
  488. Report question?
  489. Syntax for password protectd database...
  490. #error in report w/linked tables
  491. Sending data to Excel
  492. Updating via internet
  493. Novice Question - I wish to modify the data in multiple feilds
  494. Leaving debug.print statements in a database intended for runtime?
  495. general db design question
  496. Different type conversion A2k and A97 ?
  497. Outdated help (feat. Access '97 and VB4)
  498. Delete existing before running Open "c:\MyFile.txt" For Output As #1 ?
  499. YearFrac Year Fraction Calculation
  500. Code compiles, mde creation fails
  501. error setting a subforms recordsource from another form
  502. Odd error setting a form's recordset property
  503. Any reason to favor calling a batch file VS running a CMD directly in A97 VBA?
  504. Query runs fast once, then very slow
  505. Database Password
  506. Changing relations with VBA code?
  507. Method for updating production backends with new tables/fields
  508. Find first and last element of a column in a table
  509. Display text field for current record only......
  510. Access as Automation Server - Problem declaring Form 'withevents'
  511. How to Recover your lost password for Microsoft Access 95/97/2000/XP/2003 database ?
  512. Access and Images - Linking image table to a record table
  513. Can I waste your time please
  514. Healing
  515. How do I set an Aggregate SQL statement result to a control?
  516. Linking to tables in Firebird or other db
  517. Listbox Question
  518. Tab Control Question
  519. Compatability of A2000 and A2003.
  520. Could use so code help!
  521. Bookmarking
  522. Container Graphics not acting as expected
  523. Relationships design
  524. Having a tough time re-deploying proper System.mdw
  525. How do you adjust a form to open from the top?
  526. Automation Slower Than Windows Explorer
  527. TO ALL SUPPORTERS OF ARNO R AND HIS GOONS
  528. wrong result from recordset
  529. Launching an OLE Application From a Form
  530. OpenRecordset method
  531. Help with microsoft access for making schedules
  532. Can a MDW file which relates to a specific app be deleted?
  533. Subforms and Search Function
  534. Checkboxes
  535. How to Zip Files from ms Access
  536. Strange one: A2K2 wont recognize break points
  537. How to zip files from MS ACCESS
  538. Looking for Access Reporting Add-ins
  539. disabling close button for application
  540. Database doubles in size, when forms deleted even when compacted!
  541. How to tell if there is no selection in a DataCombo box?
  542. Capturing FTP responses in VBA?
  543. Changing order of columns in a table
  544. Wanting to give users 3 options
  545. Microsoft Off 11/Off 9 Reference
  546. Copy selected records and save as new rec with user input
  547. Multiple recordsets continued
  548. Attachments lost/reset once public db variable is set to ""
  549. To link or not to link
  550. New to access. stumped on query. Column to Row conversion Any ideas?