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