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. Problem with DateDiff
  2. add one to string in sql query
  3. Access 97 / XP sharing problem
  4. 2 Beginner Access question
  5. Reversing a COlour Code
  6. Sorting a SubForm
  7. Trouble with order by clause in report
  8. Off Topic - Access to Postgres
  9. TransferDatabase problem
  10. Nulling field in subform
  11. Tips to document Access program
  12. Lebans ReportToPDF solution Help
  13. Date Validation: IF's vs Case
  14. Probably a very simple problem, but it's got me...
  15. Adobe Acrobat & pdf.ocx - The Paperless Office
  16. failure in saving new added field
  17. A very basic search form in access
  18. 2 queries OK by themselves, FAIL in Union
  19. How to store folder path as Hyperlink?
  20. VB code to perform custom query of MS access table and display alert
  21. Run-time error
  22. Access Report is giving extra blank pages
  23. data in a tex field on an unbound form
  24. trying to copy an Access 2003 pivot table to excel or word .... or something
  25. 'Converting Varchat to Int' problem
  26. Relationships
  27. Not sure I understand what Response.buffer is really about
  28. MS Access adding dates
  29. Create Dynamically Built Data-Entry form to enter data into two tables
  30. Timeout while DDE linking to a VB application.
  31. query not working when i add an alias
  32. Runtime version overwrites full access
  33. calling excel function LinEst from VB
  34. Access to VB
  35. How to do a hyperlink inside of ...
  36. Choose Month & Year when giving report criteria
  37. Synchronising/replicating access with sql server
  38. serialize/deserialize Access report object
  39. Choose Month & Year when giving report criteria
  40. Pivot Tables Access vs Excel
  41. Use Select Query variable against a table and return value to same select query
  42. DeleteDuplicateRecords
  43. Progress Meter does not refresh during series of OpenQueries
  44. How to join two fields
  45. Left(field,Numchar) or Right not found
  46. Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
  47. NZ always returns a zero-length string when used in a query expression?
  48. backup databases
  49. Access 2003 unable to link to ODBC but 2002 on same machine can
  50. Duplicate record check
  51. Hyperlinks
  52. Sending SMS from Access
  53. UserForms
  54. forms only show primary key
  55. Scroll bar strangeness on subform
  56. Calendar Control turns white on new record
  57. automatically append new records
  58. OldValue not set
  59. form property for subform
  60. Help required formatting a date field in a SELECT statement results
  61. A2K3 & object dependency refresh
  62. What's with ADO?
  63. Assigning common id based on evaluation of two columns
  64. Select ALL from an unbound form for query parameters
  65. Totally lost on Date Sort
  66. Crosstab Query: Sort Column heading based on other column sort
  67. Cross tab Query: Sort Column Heading based on other column Sort order
  68. Split Database Security Problem
  69. Query has a problem with December??
  70. error -2147217904 - how to fix :o( ?
  71. A2K - passing more than one value into a popup form
  72. MS Access, PostgreSQL 8.1.1, connection string
  73. ODBC, connection pooling
  74. Using seek to find if a record exists
  75. error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
  76. Can lines collection be used to assist me in automatically numbering lines?
  77. GetSetting function breaks when code-signing
  78. Invisible textboxes on subform
  79. Database design question
  80. Filtering on a form
  81. Checkboxes verses field list boxes
  82. How to pull the newest record for each student out of a table
  83. after update not triggered
  84. OT. Happy Holidays to you all
  85. Opening form in datasheet view
  86. CurrentDb problem in report
  87. Need to add trailing 0's
  88. Problem with Left function
  89. Query Shows No Records
  90. Developing in Access 2003 with conversion problem
  91. setfocus to access application
  92. Packaging for multiple office versions
  93. MS Access Send To recipient (not as attachment but as HTML)
  94. A97 Runtime - I wish to disable F-11 key from displaying database window
  95. Sorting many fields in a form
  96. How can I enter several lines of text as a criterion and return several lines from my table?
  97. access 2003 validation rules
  98. lInking subforms
  99. Unable to edit form - Many-to-Many relationship
  100. What is a Library mde/mdb?
  101. on open and before exit events
  102. Access2000 data Entry Unbound Form With Subform
  103. Contingent formatting
  104. Developing in Access 2003 for Access 97 users
  105. Saving information on reprot to new table?
  106. How to stop library mde being reused
  107. Can't link forms
  108. An aid to inserting a Date, Small calender pops up
  109. Scroll bars are not appearing in certain situation.
  110. Customer keeping track of invoices received and paid.
  111. Access 97 Problem: only one printer shown in the printer screen
  112. Picture Importing
  113. TransferText dropping fractions
  114. Is Access smart enough to optimize this ?
  115. pasting records in datasheet-form: pass-through called twice ?
  116. Horizontal Scrollbar
  117. coloured lines of alist box
  118. Set Warning? Maybe?
  119. Need help on updating text box!
  120. video rental database?
  121. Making MS Access Form as a standalone form like in VB
  122. Can anyone recommend a Dot Matrix printer for my DB?
  123. Run external application script from access?
  124. problems with DSN for MS Acess database
  125. Reading image files from a URL location
  126. MS Access 2003 sending emails
  127. better way
  128. HELP 97 -> 2K and lost all relationships
  129. Help with a query trying to total!
  130. Subtract MULTIPLE time segments from a single time segment to calculate cycle time
  131. ControlTip Text
  132. Trouble With Left Join
  133. Dlookup
  134. mappoint looses forms focus
  135. Combo Box Recordsource When using CodeDB
  136. dcount, dsum, dlookup question (not syntax)
  137. Forms - pagebreak Visibility
  138. NetSearch the Business Intelligence Search Engine
  139. Creating a checklist from a table to indicate attandance
  140. hide form on startup
  141. Can't figure out error in simple dsum
  142. Data Conversion Error
  143. subform within a subform
  144. Help in generating a report
  145. make table query
  146. Can a variable hold 2 values simultaneously - a string value and a numeric?
  147. VBA Query code issue........
  148. Connect 2 subforms
  149. Dynamicaly created where clause for OpenForm
  150. Access versus MSDE versus SQL Server Express
  151. Database design - incorporate year of a certain event
  152. Error 3075 Function Not Available - but no missing references
  153. Strange findfirst behavior
  154. How to vary the number of copies of each record in a report in A97?
  155. Forcing Cursor To Specific Record/Field On Continuous Screen?
  156. Goodies in 2003?
  157. SQL Insert Into Error
  158. Parsing
  159. Transferdatabase
  160. how to determine whether any report is opened?
  161. I've never seen A97 combo-box wizard fail on a valid query until today...
  162. Key based on Login entry
  163. Listbox value does not change
  164. Properly using checkboxes in a datasheet form
  165. HIPPA - HealthCare Cliam Transactions
  166. Can you import images into access
  167. Export MS Access table via OBDC using VB
  168. real record in a subform
  169. mixing linked tables
  170. Input Mask for dateformat dd/mm/yyyy hh\:nn
  171. A97 - Forms - Rail Road Track layout
  172. Copying root directory
  173. Windows Explorer Switches
  174. 2 Combo Box Menu from Multiple Query
  175. pivot chart
  176. Sending report to a PDF File. Good link for Access developers
  177. Function DatePart(), how to subtract the month from a date field
  178. entering data from form into two tables
  179. Combo box dependent on another combo box, text part is blank
  180. gtotal
  181. attaching MsSQLServer(msde2k) tables to Access2k
  182. Trying to total a text box in report
  183. Update an account balance on a daily basis
  184. several questions regarding graphs
  185. recordset.MoveLast - "not enough space on temporary device"
  186. Backend on the internet?
  187. Execute database to Excel exportation stored procedure from VB
  188. query how to
  189. open excel file
  190. open excel file
  191. Updating combo box
  192. dynamically create Tab Control possible?
  193. Setfocus question
  194. default value help
  195. Table exceeding one million rows crashes Access
  196. Filtered Colum To Single Comma Delimited Value??
  197. MS Access forum
  198. Default sort order
  199. Analyze Tool & Lost Data
  200. Add value to subform from main form
  201. Datasheet View: Second Combo Box Criteria Based on First Combo Box Value
  202. Access Reading and writing emails
  203. ftp from Access: problems
  204. Help with a report field
  205. Subject: Access Reading and writing emails
  206. Access fails if printer is out of paper
  207. Removing duplicates from query, but not from table
  208. I have carried out the Keith Wilby stepwise approach to securing an MDB but I am not sure what I have achieved
  209. Loosing Db connection?!?!?!
  210. Text becomes available when check mark is placed
  211. How to Test Function in Immediate Window
  212. Self join. Employees and supervisors query.
  213. Access 97, W2K, "can't open the mail session"
  214. Help with query to extract next best product
  215. Securing only certain forms?
  216. Printing to a dot matrix printer
  217. Enhancing the FAQ. Please suggest enhacements....(new topic, getting closer...)
  218. VBasic window opens with references grayed out
  219. Sum of Sum in Totals Query
  220. Trouble with concatenated string function
  221. Opening one database always restores a minimised database
  222. vba to activate a command button in a different though open form
  223. invalid operation
  224. 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
  225. Arrays in Access.
  226. Can't get subform on tab control to requery
  227. Query help!
  228. Forms: attaching labels to a combobox
  229. move next
  230. Need help with ValidationRule
  231. Suppression of auto-fill-out of MS-ACCESS
  232. Getting the right software without getting ripped off
  233. auto email
  234. Creating a dynamic form, how?
  235. I wish knowledge as to creat a Bibilical data index i.e. Genesis to Revelations not alphabetical!
  236. Form navigation buttons do not show correct position
  237. How to Compress/zip files from MS ACCESS and then send it by email?
  238. Returning orders
  239. how to know the record position shown in a form?
  240. configuring access for all users
  241. MOST recent date
  242. Help! Public variable not staying set - 3420 Object invalid or no longer set.
  243. Combobox Not In List Event
  244. Proper use of global variables for reports
  245. Report question?
  246. Syntax for password protectd database...
  247. #error in report w/linked tables
  248. Sending data to Excel
  249. Updating via internet
  250. Novice Question - I wish to modify the data in multiple feilds
  251. Leaving debug.print statements in a database intended for runtime?
  252. general db design question
  253. Different type conversion A2k and A97 ?
  254. Outdated help (feat. Access '97 and VB4)
  255. Delete existing before running Open "c:\MyFile.txt" For Output As #1 ?
  256. YearFrac Year Fraction Calculation
  257. Code compiles, mde creation fails
  258. error setting a subforms recordsource from another form
  259. Odd error setting a form's recordset property
  260. Any reason to favor calling a batch file VS running a CMD directly in A97 VBA?
  261. Query runs fast once, then very slow
  262. Database Password
  263. Changing relations with VBA code?
  264. Method for updating production backends with new tables/fields
  265. Find first and last element of a column in a table
  266. Display text field for current record only......
  267. Access as Automation Server - Problem declaring Form 'withevents'
  268. How to Recover your lost password for Microsoft Access 95/97/2000/XP/2003 database ?
  269. Access and Images - Linking image table to a record table
  270. Can I waste your time please
  271. Healing
  272. How do I set an Aggregate SQL statement result to a control?
  273. Linking to tables in Firebird or other db
  274. Listbox Question
  275. Tab Control Question
  276. Compatability of A2000 and A2003.
  277. Could use so code help!
  278. Bookmarking
  279. Container Graphics not acting as expected
  280. Relationships design
  281. Having a tough time re-deploying proper System.mdw
  282. How do you adjust a form to open from the top?
  283. Automation Slower Than Windows Explorer
  284. TO ALL SUPPORTERS OF ARNO R AND HIS GOONS
  285. wrong result from recordset
  286. Launching an OLE Application From a Form
  287. OpenRecordset method
  288. Help with microsoft access for making schedules
  289. Can a MDW file which relates to a specific app be deleted?
  290. Subforms and Search Function
  291. Checkboxes
  292. How to Zip Files from ms Access
  293. Strange one: A2K2 wont recognize break points
  294. How to zip files from MS ACCESS
  295. Looking for Access Reporting Add-ins
  296. disabling close button for application
  297. Database doubles in size, when forms deleted even when compacted!
  298. How to tell if there is no selection in a DataCombo box?
  299. Capturing FTP responses in VBA?
  300. Changing order of columns in a table
  301. Wanting to give users 3 options
  302. Microsoft Off 11/Off 9 Reference
  303. Copy selected records and save as new rec with user input
  304. Multiple recordsets continued
  305. Attachments lost/reset once public db variable is set to ""
  306. To link or not to link
  307. New to access. stumped on query. Column to Row conversion Any ideas?
  308. Local Table vs. Class for Public Variables with simple types
  309. Multiple Vehicle Mileage Calculation
  310. In case you ever get an error 2455
  311. How do I change the keyboard input language from within Access 2000?
  312. File Transfer Animation
  313. Find Primary Key field
  314. Linking Checkboxes to values in a table for a Report
  315. Automatically printing to Adobe Acrobat
  316. OraOLEDB.Oracle provider missing
  317. Getting data from excel spreadsheet column into access table
  318. Report Help
  319. run sql query for each record in a contious form
  320. Ok this is a strange one
  321. SET NOCOUNT ON; Multiple Recordsets; ADO Command Text
  322. Look at this
  323. Curious about Access 12 Report Formatting
  324. Circular relationship nightmare
  325. print ourt labels
  326. Import Paradox database into mdb issue
  327. Automate printing reports to PDF
  328. Automating a command button to do a Get External Data command
  329. Super easy word merge
  330. DLookUp Problem
  331. database variables problem
  332. set up two criteria in one command button
  333. Finalizing the dialogue with newsgroup Megalomaniacs (change of Subject...)
  334. HELP - Using GoToControl in subforms
  335. Remove Filter/Sort
  336. Database security (crosspost)
  337. Encrypted database
  338. Conversion: Access 2000 to Access 2003
  339. Subtracting Dates
  340. Multipage Form
  341. Active X controls problem
  342. Dumb Question
  343. Edit format of field in a form that can be populated by a lookup
  344. How to extract just the time portion of DateTime
  345. Validation q's - subform BeforeUpdate event (and SQL)
  346. Code not producing desired result
  347. TransferText and Missing/Skipped first line - Solution
  348. Drop Down List
  349. Navigation buttons
  350. sql password with access query
  351. multiple selection
  352. multiple selection
  353. Can't update data in a query
  354. Word and Excel Objects in Access Reports
  355. Evals("myPublicVariable") do nor work: have you any alternative way?
  356. I am gathering the date of my customer..
  357. Dialogue with newsgroup Megalomaniacs (change of Subject...)
  358. is the access database able to be converted to SPSS date?
  359. subquery problem
  360. Display full name in combo box
  361. Get list of custom properties
  362. Switching between two columns in a form viewed as datasheet
  363. Horizontal grouping
  364. Multiple Recordset from a Stored Procedure
  365. From ListBox to Subform -- , how to add SQL statement?
  366. the switch statement has got me a little confused..can someone clear this up for me please
  367. Mailing Labels
  368. Select INTO ListBox
  369. Form border color
  370. Confirm/commit insert in ADP project
  371. Help with a list box
  372. ODBC: SQLTables does not return data for an Access database?
  373. OpenRecordset help needed
  374. Aiuto per formato data
  375. filtering and edit
  376. Error occurs when MS Access open Excel document and trigger the assigned macro in Excel
  377. SHELL handling a switch.....
  378. Explanation???
  379. Form opens SLOW when "Allow Addtions" set to No
  380. How to connect MS Access form to MS SQL Server
  381. I'm trying to completely unsecure an A97 app
  382. Please Help --Adding a Primary Key to a Table with over 180K records
  383. Pasting multiple lines of data into text box - how do I divide it into seperate strings??
  384. Query works in Access but not with exec call from .net
  385. A message to Self-Appointed-NewsGroup-Netiquette-Enforcers... PLEASE LEAVE US ALONE!
  386. Load Form?
  387. Need help on seeing data in form
  388. MS Access Query Export Error "Too Few Parameters. Expected 1"
  389. QBF problem with multiple combo boxes
  390. If Statemet
  391. What kind of replica?
  392. closing a db with an error
  393. MS access: Book recommendations
  394. Import data and changes from access to access
  395. editing data in pivot table
  396. Help please! Add or remove from field value through a form
  397. Text Field default value based on function...
  398. Programaticaly populate a sub-form
  399. Pass Through Query Nightmare (Access 2K --> SQL Server 2000)
  400. How can I stop people have access to my MS Access Tables and Queries via Import?
  401. Learn SQL?
  402. Mappoint app or activex control?
  403. beginer with problem
  404. Simple MS Access Update ... Wont Update
  405. Plot a data series along a secondary value axis
  406. Intel Software to boost Access' performance
  407. Re-appearing dlls and type libs.
  408. Field for Number of records in a query
  409. change form property using SetValue
  410. Query to display number count
  411. Browse and Store Filename
  412. Browse and Store fileaname
  413. clsReadTextFile
  414. Access 2k3 / WinXP Issue = kooky join
  415. Keeping track of jointly owned assets
  416. 50,000 Ft Question
  417. query
  418. Test
  419. How are you connecting to this group?
  420. Email data from input-screen
  421. Partial replica: which tables are synchronized
  422. Alternatives to expensive Wise/Installshield/Sagekey?
  423. Deleting from the query's datasheet view, from both tables?
  424. Query by User
  425. How to sort Commands in Menu Builder (Customize)
  426. How to convert/transform txt to DB
  427. Access date validation driving me nuts
  428. How to determine what system DLLS are running in one screen?
  429. Selling Access app to general public?
  430. COMCAT.dll difference in Packaging Wizard.
  431. Error 3075 when in stalling Package Wizard set up file (XP)
  432. Access 2000 Delete ADDs a New record? Help
  433. Delete Record Woes Access 2000
  434. export problems
  435. Problems Sending Attachments
  436. Hyperlink Properties
  437. Changing caption content in a Table or Form
  438. upload excel file into sql server
  439. zTest.htm Ever hear of it?
  440. form timer stops firing until mouse or keystroke event
  441. Get SQL Data (DNS Less)
  442. date value issue
  443. ARG! Help! Path/File error using Access XP ODE P&D Wizard
  444. Retrieve global constant string from another database
  445. Linking Two Subforms
  446. combobox dropdown
  447. Access 2000 query problem - Help!
  448. Relative Recordset Position
  449. Prevent Design View
  450. form sizing
  451. Blank page after report header
  452. TransferText and First Record in Text file
  453. Printing sheet of labels not working
  454. Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
  455. O.T. - I'm not sure - Anyway, its a sort algorithm question
  456. Access does not like Mysql
  457. WARNING: Relationships not imported with data
  458. copyfromrecordset does not work on different machine no errors reported
  459. Address Label Problem
  460. Is this a bug?
  461. Access database on Windows 2003 server is excrutiatingly slow
  462. Memo Text Truncation during Excel Export
  463. Adding last record to another table with Append Query
  464. I confess
  465. How do you determine if anyone is logged onto a BE database?
  466. Change table date/time field to text field in code
  467. Urgent Help on Australian dates on spreadsheet saving as American dates on a text file.
  468. Access 2000 database and Office XP compatability?
  469. macro, control on form
  470. Has anyone posted code to convert longer HEX numbers to DEC strings?
  471. Prevent minimising application. Possible?
  472. ADO new record #Error why??
  473. Date criteria
  474. Help handling string length overflow?
  475. All caps font for A97 report
  476. Re-logging into An Oracle Database
  477. Form Backgroud colors
  478. fDesign
  479. Help With Expression Please
  480. Difficult SQL Query with multiple records detail
  481. SQL code not returning correct data
  482. Report sometimes prints in grayscale -- problem and solution
  483. Window on toolbar
  484. Report
  485. How to make a condition for making a SUM - Correction
  486. How to make a condition for making a SUM
  487. Help with Golf DB
  488. DLookup syntax when there are two primary keys
  489. Automate WinZip self-extract
  490. Evaluating References in Code [Long]
  491. How to Consume a Web Service from Microsoft Access
  492. Access Hangs during spell check (Caught in loop)
  493. dcount syntax
  494. ADP and T-SQL Problem
  495. Need a Flowchart type Calendar for a lodging reservation application
  496. subform combobox filter problem
  497. 2006 Calendar Available
  498. subform combobox filter problem
  499. zipcode
  500. Msgbox Icons?
  501. wininet and urlmon in use during A97 runtime rollout
  502. Help with Charts
  503. Problem printed multiple instance reports
  504. Help with MS Access Report: Repost
  505. Enforcing no duplicates in multiple textbox controls
  506. Help needed with query syntax
  507. Two Query Questions
  508. How Do I mail merge one instance of every person???
  509. XML and special characters ...
  510. Click on Map area to chose filter for Query
  511. Publishing Web reports - can you
  512. are ado questions allowed here?
  513. Form data entry history
  514. Single item inventory?
  515. Macro
  516. Query Creates Read-Only Recordset
  517. Outlook Toolbar in Access
  518. MS Access Reports
  519. Access 97 - Reports
  520. MS Graph in Access 97
  521. Changing Stubborn Data Type
  522. Spontaneous loss of subform bookmarks
  523. Spontaneous loss of subform bookmarks
  524. filling up blank fields
  525. Update a 2nd Table
  526. Report Creation With Query
  527. Exporting Report to PDF without save prompt on Windows 98
  528. Query to ignore other conditions
  529. Stubborn front-end bloat in Access 2002
  530. Unique with empty records?
  531. Navigational / lookup combo boxes
  532. Run Time Error 3075 Missing Operator
  533. delete a record with required fields
  534. printing
  535. Add a query and print after filling out a form
  536. Setting focus to an external application
  537. MultiSum SQL Syntax
  538. Calling Access 2003 from cmd file via Windows Scheduler
  539. To populate Excel sheet
  540. Mailing List Auto Content
  541. Custom Menus Question (Remove 'Type a question for help').
  542. Date Parameter when using Intl Date Formats
  543. you cancelled prev. operation error
  544. Passing date as a parameter and regional settings
  545. HELP: how to recover deleted record from a Table
  546. Print Publisher document
  547. Reorganize MS Access Table
  548. AutoNumber Issue
  549. using database from different versions
  550. How to use UNION ALL and SORT BY