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. new record detection
  2. A97: Can't import a text file to an Access 97 table?
  3. A97: Is it a feature or a beature of Access compiling code on the clipboard?
  4. Mail Merge
  5. postgreSQL temporary tables and MS Access
  6. A97: Is there a way to exclude certain modules from being compiled?
  7. A97: Q re ShellWait?
  8. A97: Copying HELP text is flaky.
  9. A97... not important, just curious (2 if's or select case)
  10. Add "All" to Combo Box and Use "All" as Criteria in Query
  11. Further adventures in Jet database compaction
  12. Love the SQL, can't seem to get a combo box to use it...
  13. locking subforms
  14. recordset for reports ?
  15. stopping every acknowledgement
  16. Aggregate two fields
  17. Document Tracker
  18. Access Modules
  19. ADODB connection can't open. Database locked.
  20. Show all record using combo box
  21. avoiding reference problems when distributing apps
  22. Looking through date in SQL
  23. SQL Problem
  24. Control form movement
  25. Parsing out SQL statement
  26. search access table throught webpage helppppppp
  27. Why does A97 show a number like -2147483630 as the ForeColor property of a control?
  28. Seeking alternative for suspending code execution with acDialog parm in A97...
  29. Saving Modules in Access
  30. Access 2003 Reports
  31. SysCmd acSysCmdInitMeter
  32. 2 records per detail in Report
  33. Has anyone ever wished for a fixed version of Access rather than a new and improved version?
  34. A97... SysCmd, what are the 4 possible values and what do they stand for?
  35. Trying to make a form not sure how to do it
  36. A97... If I run Me.Visible = False in a form module, should Unhide be an option under "Window" menubar option?
  37. Automating user changes to database
  38. Application crashes upon trying to commit a transaction
  39. Refresh a Form
  40. how can I open table in mdb access database without running form
  41. How to have filled data in field started with CAPITAL?
  42. Terminal Services
  43. Multiple pastes
  44. formatting listbox
  45. how to move to a specific record after the form is refreshed?
  46. Accessing as lookup column
  47. Filtering data entry in forms
  48. Create tables Using VBA
  49. How to Ask a Question Here
  50. Update Query VERY slow! Please help :(
  51. Database Deployment
  52. How to avoid default "can't save form at this time" message?
  53. references
  54. Properties for a custom class (not a collection)
  55. Help with Access template
  56. Code to Unzip file from Outlook message
  57. An experience in linking Blackboard learning system backend to Access
  58. Releasing Object Variables
  59. calculation with msaccess
  60. external data from internet
  61. access summery reports
  62. Only my form
  63. MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000
  64. An FAQ?
  65. references question
  66. Access 2003 missing the intranet or the website
  67. Active Directory?
  68. flaky events in A97
  69. How do I force MS Access to stay minimized?
  70. ensuring certain code runs when returning to a form...
  71. A2K Record-Level Locking
  72. Select diff value from drop down in subform, it changes all occurences in DB
  73. A97's Activate event - reasons why it does not occur after opening a form?
  74. Adding Multiple Records
  75. TransferText
  76. Why is Me.Hide not a valid statement in A97?
  77. Is Name Autocorrect fixed in Access 2003?
  78. Recreate/Reset Data Behind Form Data
  79. Privileges, Security & Database Design Issues
  80. Stopping/preventing Access from continuing onto another process/action
  81. filter on form with VBA
  82. Grand Total
  83. Access 2003 Corruption
  84. Is this a job for access or SQL?
  85. Riportare un record precedente
  86. Calculating date differences from a table?
  87. Unique Fields
  88. Export Excel file on mapped drive
  89. Record Y of X question
  90. form jumps to the top
  91. Instance of Access hangs
  92. Reference for ADO.net
  93. Advanced Access Security problem
  94. To WITH or not to WITH?
  95. Workgroup MS Access 2003 Windows XP
  96. Running Split Access2000 db on Network
  97. Filter and Index
  98. Recommended data access model
  99. Code To Run WinZip?
  100. Users ADP files suddenly adding DBO extension and not working properly
  101. How to access data from a subform
  102. Text Box With Validation Rule
  103. Does Any One Knows how can i learn this language?
  104. Combo Boxes and Selecting Everything in a Query
  105. Microsoft Outlook 2000 Blocks Access File Attachment
  106. Access Report Control ??
  107. Access Report Control ??
  108. Interesting issue with compaction. Any ideas to eliminate?
  109. Access 2002 Security on multiple workstations
  110. Position a commandbar
  111. SELECT clause and LAST function causing problems
  112. How to set background color in pushed button of Option Group.
  113. How to make in Find Record the Match tool setting "Any Part Of Field" default
  114. Trapping Error 2501
  115. Linked Tables - Identity column needed ?
  116. Help: Is there a line break in Report
  117. Group By with Multiple Fields
  118. Group By with Multiple Fields
  119. Group By with Multiple Fields
  120. Group By with Multiple Fields
  121. How to Populate "To:" field in Outlook with Access query results.
  122. Can't Get Echo To Work
  123. 2003 Developers Edition?
  124. unable to update via form - relationship problem?
  125. Copy records from form as new records
  126. Help: How to prevent moving to the new record when sub form is null?
  127. Inserting Strings into a text box
  128. Access 2003, Question concerning Adobe Acrobat
  129. Getting the results of a report calculation or data field
  130. user defined error
  131. Hiding a Label with a Sub report
  132. Help with query syntax please
  133. format of column heading in crosstab query
  134. Replica-manager: deleting old replicas?
  135. Subform Question
  136. Function vs Sub /Public vs Private
  137. MDE front-end on network share?
  138. Recordset for MS Graph (Chart) through VBA ?
  139. access and postrgresql
  140. Using MSACESS for translations?
  141. date help appreciated
  142. relation 0:1
  143. scroll subform with mouse
  144. Summarize Text
  145. IT Studies
  146. Using any value in multiple columns as query parameters
  147. Combining multiple columns into 1.
  148. Combining multiple columns into 1.
  149. Read this if you dare
  150. Read this if you dare
  151. access 2k print problem
  152. access 2k print problem
  153. Displaying hyperlink contents in reports
  154. Displaying hyperlink contents in reports
  155. fun quotes for the day
  156. fun quotes for the day
  157. Error 3014 and 3518
  158. Error 3014 and 3518
  159. A2K - possible to have fading colour effect on labels or textboxes?
  160. A2K - possible to have fading colour effect on labels or textboxes?
  161. Another joy of ADO
  162. Another joy of ADO
  163. Plesae help with this query
  164. Plesae help with this query
  165. How to refresh data on a MainForm
  166. How to refresh data on a MainForm
  167. Radio button groups are null
  168. Radio button groups are null
  169. F11 doesn't bring back DB window
  170. F11 doesn't bring back DB window
  171. F11 doesn't bring back DB window
  172. F11 doesn't bring back DB window
  173. ADO Question
  174. ADO Question
  175. MultiTable runtime parameter
  176. MultiTable runtime parameter
  177. Help With Table Design
  178. Help With Table Design
  179. Eliminating Blank Rows In Reports
  180. Eliminating Blank Rows In Reports
  181. Subform Question. Please help!
  182. Subform Question. Please help!
  183. Excluding records where two tables have the same id
  184. Excluding records where two tables have the same id
  185. References in Access and VB
  186. References in Access and VB
  187. Accessing Access mdb via ODBC - how to return autonumber
  188. Accessing Access mdb via ODBC - how to return autonumber
  189. Help With Table Lock, Please.
  190. Help With Table Lock, Please.
  191. currency data type
  192. currency data type
  193. syntax error for Update Query
  194. syntax error for Update Query
  195. how to disable the 'next' navigation button to new records on conditions?
  196. how to disable the 'next' navigation button to new records on conditions?
  197. Help. Button: copy value from field, followed by start ext. application.
  198. Help. Button: copy value from field, followed by start ext. application.
  199. I finished the application - - - now what?
  200. I finished the application - - - now what?
  201. Generating Numbers automatically
  202. Generating Numbers automatically
  203. Importing Tables Question
  204. Importing Tables Question
  205. Trouble setting hyperlink string with code
  206. Trouble setting hyperlink string with code
  207. how to specify a common spellcheck dictionary
  208. how to specify a common spellcheck dictionary
  209. OnApply Event doesn't act as documented
  210. OnApply Event doesn't act as documented
  211. The app's been built, now what?
  212. The app's been built, now what?
  213. VERY simple application fails to start
  214. VERY simple application fails to start
  215. J-Integra for COM (Java COM interoperability)
  216. J-Integra for COM (Java COM interoperability)
  217. Help with a C++ library
  218. Microsoft throwing curve balls at Access Developers! ARGH!
  219. OutputTo
  220. OutputTo
  221. Populating One Dropdown based on the Results of Another
  222. multiple users
  223. Exiting A Multi-level Procedure From the Lowest Level
  224. Find duplicate records on two fields
  225. Nav Bar on Form doesn't work
  226. How to renummer ID (now contains holes), even when table is full of records.
  227. making a logfile
  228. Forcing ODBC-Autocommit
  229. Acquiring some sort of unique machine ID?
  230. RecordsetClone only retreives 100 records in ADP
  231. date/time fields to just dates
  232. Time to migrate from Excel to Access?
  233. Queries...any way to disable/lock a column?
  234. FindFirst and query not finding records - date values
  235. 3-year Comparison YTD
  236. SQL required for delete
  237. Tab pages
  238. Strange SP Problem
  239. Conditionnal formating
  240. Table sql in acces is not updatable
  241. Turn off File, Edit, View, etc...Menu
  242. Referencing Forms
  243. Online Form -> Email -> Access database
  244. Maximising a switchboard form when it loads.
  245. Compare query
  246. Compare query
  247. auto delete in windows xp
  248. How to put/edit VB script what hightlight buttons on mousemove?
  249. Corruption of Back End
  250. Button closing database AND exit Access, how?
  251. Why can I only do a record search from two fields and not more?
  252. Replace Subform
  253. Dynamic form possible?
  254. Calulate time between different records
  255. Option Group: Values only nummeric, how to perform for all characters?
  256. Stand Alone Database Application
  257. Can Access 97 emulate Windows Find Command?
  258. How to Date Filter on a Group By Month query
  259. Selecting into a variable
  260. Using EVAL() in a Query with a nested Field Reference
  261. Skip to Next (in a for each next loop) if condition is met
  262. text box dependent on other text box entry
  263. Secure Database Code
  264. 1st character of field Uppercased only with input mask?
  265. How to make button filling in the present date in a data field
  266. VB code that uses recordset logic and split function runs very slow
  267. Monthly Attendance Report
  268. Input mask field is _______: I do not want them visible / mouse cursor not to 1st
  269. Error in Visual Basic closes the database
  270. How should I use NotInList for this application?
  271. Delete table and associated relationships
  272. works at home but not on host servers
  273. crosstab queries formatting question
  274. multiple selection
  275. multiple selection
  276. Variable Field not wanted in Access Queries
  277. Sending email with atachments in Access 2003 (vb)
  278. selecting a subset of choices based on a first choice
  279. I know it can be done now!
  280. Transparent Background on Subform
  281. I was pleased to see a couple of ttf files in my runtime distribution fileset
  282. ADODB and Access Reports
  283. Relationships confusion
  284. Set Recordsource
  285. Pulling info from linked table based on text box entry
  286. A97's 2427 error - Why does it occur when refering to a textbox control?
  287. Making access 2002 fill in the city from a zip code tbl
  288. ADODB Connection String - Prompt for Password?
  289. Another Mail Merge Question
  290. How to put the ID back to 1?
  291. Refresh sub form after entry
  292. Opening Access 2003 dumps copy buffer
  293. Open Form Smaller
  294. Question about mde
  295. Open a form to the position of the mouse
  296. Open a form to the position of the mouse
  297. Forms, Reports align on decimal
  298. unexpected prompt in report
  299. Transform string : "c;b;a;e;d" -> "a;b;c;d;e" ?
  300. Query Problem
  301. How do i create a validation rule in a table
  302. Two or more Access Reports -> a Single Snapshot file
  303. Embarrassed to put this on the forum - but here goes anyway - can't see controls on form
  304. 50 forms later, I forgot to set the form captions...
  305. Dates: Using a query result in another query
  306. Method 'Range' of object '_Global' failed
  307. Multiple sql statements in insert query
  308. Can someone tell me what is wrong with the syntax of this WHERE clause?
  309. Statement works in Access 2000 but not Access 2003
  310. Invalid argument
  311. Need help with building database
  312. Gather information from Excel PivotCache
  313. Question on Dcount -
  314. A97 procedure causes keyboard CTRL key to get stuck. Why?
  315. Excessive Calculations Please Help
  316. Some SQL trouble
  317. SendObject process automation
  318. Opened Form is not getting Focus
  319. OnFormat Event
  320. A2K3: Custom grouping for report
  321. Limiting no of chars in unbound field
  322. Calculated fields
  323. getting the name of the current field on a form
  324. Determine whether a specified control exists on another form or report object?
  325. Programatically Get A List Of Subfolders
  326. How to extract OLE Object (Bitmap Image) to file system?
  327. Want to Open a form and have NO default
  328. How do I get this query to work?
  329. Question on Access 2000 Report Design
  330. Is =GetMyCriteria() a valid criteria expression in query?
  331. Limiting Command Line Executable
  332. Calling user-defined function from query
  333. Strange behavier in execution of this SQL query....
  334. Dynamic Choice - Print or Preview
  335. 6 digit Date Format
  336. How to dynamically assign a query field its criteria?
  337. Example of an access update query
  338. Report Error: Multi-Level GROUP BY clause is not allowed in a subquery
  339. What's wrong with this get last day of month function?
  340. charting - time axis
  341. form event question
  342. Can someone tell me what the significant difference between Date and Variant datatypes is?
  343. Can I use A97 DateGrouping property to find Sunday date for any week?
  344. Append / Update Query
  345. accessing MS Access database fila via ODBC problem
  346. How to run a query that exists in Access from VB
  347. Image viewer controllable by Access via OLE Automation?
  348. Numb in Kalamazoo
  349. VBA/Query to update certain fields
  350. Access is using something to play audio files. How can I find out what it is?
  351. Error 2115
  352. clear out a mdb database
  353. maketable query and non-local database
  354. Is there a way to read the status bar?
  355. Poll: How many of you feel inconvenienced by inability to use dbl-click to select a string in A97?
  356. Reset an Undo
  357. Row Source SQL query question.
  358. Updating listbox.
  359. New Adobe Professional 6 user seeks Quick answer!
  360. Synchronizing Two List Boxes problem - Access 2003
  361. Suppress Access Generated Warning
  362. Undocumented rounding algorithm
  363. Failure to open pdf file
  364. Restricting what my user can see, howto?
  365. removing wrap text format when exporting to excel
  366. windomino - migrazione dati in access
  367. problems keeping window maximized
  368. Access and ODBC
  369. Weird form problem
  370. E-mail Attachment
  371. Using Datediff
  372. Access 2002 Wizard Source Code
  373. scanning Multiple pages into Access 2k
  374. WHERE clause constraint with 2 columns
  375. Adox procedures problem
  376. inserting autonumbers in SQL.
  377. Creating relationships in code
  378. Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
  379. Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
  380. Passing variable value from code to query criteria?
  381. Access screen resolution, resizing
  382. Tutorial or Book on Report Creation
  383. auto dial with voip
  384. A97 does not prevent entry of new records from a form bound to a table
  385. Automate import of data from several text files
  386. ECO Database
  387. Is DSN-less connection to UPS WorldShip possible?
  388. Molehill into Mt. Everest
  389. Gathering data from one table and sending it to another
  390. Output to CSV
  391. Import all Files in a Folder
  392. Adding Bulk Records
  393. Two questions relative to security.
  394. hyperlink address on rich textbox control - Any possibilty ?
  395. Access vs. SQL for audit trail of record changes?
  396. barcode active-X
  397. Display records from MS Access Database
  398. record locking but not
  399. Need form button that creates URL link from unique ID record
  400. what is demo.hlp in A97?
  401. a2k - does supporting multiple users imply use of Access security?
  402. o2k - more thoughts on moving to multi-user - comments?
  403. Ok really Wierd
  404. Fill query column with my own values
  405. problem accessing access 97 database through odbc on windows 2003 sp1
  406. Sequentially numbering a field !
  407. Convert DB Access 2002 to Access 2003
  408. ApplyFilter method
  409. Getting more than one result from a function.?
  410. Is there a benefit of setting up relationships in A2003?
  411. Help creating connection function
  412. Derive Ranking Function
  413. Amateur would like code critique
  414. Filter on subform no longer works with linked ODBC table
  415. reference a column but avoid blank rows
  416. A97 runtime objective: put a set of files in alternate dir
  417. Find via code
  418. VBA DoCmd.GoToRecord , , acNewRec in first row
  419. Redundancy of multifield indexes?
  420. Help - Updateable query adds new row with missing criteria fields
  421. Database corrupt by one record
  422. Access 2003, Can run a report but can't print 1 section.
  423. restricting access to records based on user identity
  424. editing MSysRelationships
  425. Updating cells
  426. passing data to modal dialog box in VBA
  427. Rich textbox control .
  428. MS Access Help: Copying database Relationships
  429. Problem with activex control in report
  430. Focus & Navigation Problem !
  431. embedded users manual ?
  432. Import not working- need SQL statement to add table2 into table1
  433. Linking two fields
  434. Group column headings and sum their values
  435. multiple contition field in a query
  436. AutoFill Field
  437. Calculate one year back, Access and Oracle
  438. Remove Access Protection
  439. Stacked Column Charts
  440. Is this a many to many?
  441. Display a form's Context help when the form opens
  442. Exporting to Excel: Multiple tables in 1 spreadsheet - the last of 3 tables won't export.
  443. How to do this??
  444. email via winsock
  445. access subquery not enough storage is available to complete this operation
  446. How can I make the database multiuser?
  447. VBA: Generic reference to ME
  448. Reference problem by running an application on an alien pc
  449. Simple Query to Linked ODBC table gives wrong results
  450. Open Office 2.0 import to dBase from text & spreadsheets
  451. Formatting a SQL Server decimal data type
  452. Update table after leaving a record.
  453. sql for an A97 query that'll return 6 future consecutive dates 20-25 days from now
  454. printing "blank" pages
  455. How to change the table name in a report?
  456. Copy at specific record...
  457. MDIClient height
  458. Duplicating record
  459. SQL to query value from field of current record only
  460. Help with Do...Loop command using dates as parameter
  461. Parameters based on Multi-Select List Box in Access 2000
  462. Memo
  463. Access Databases and the Internet
  464. Separating the database
  465. sendobjects with text fike
  466. How to utilise "Me" in a public function
  467. modify a line in a line graph using code
  468. Counting Columns in a table using code
  469. Altering tables in code
  470. Display two fields by selecting value in one
  471. Begineers question
  472. Is it possible to create a runtime A97 app that runs from a CD only?
  473. Save or Drop Record?
  474. autofill
  475. Property Not Found error when trying to set AllowBypassKey in A97
  476. AutoExec macro, A97?
  477. Why are some of my comboboxes getting populated and other are not?
  478. I have a completely secured database and I want to completely unsecure it
  479. Upsizing A2K to SqlServer, is Access Project necessary?
  480. Combining multiple columns into one row in one field
  481. Capturing Forms
  482. Whats in my queries and marcos!
  483. Combo Box Synchronising
  484. Help needed with combined Dlookup/DatePart Syntax
  485. Querrying Jet and SQL tables
  486. Windows 2003 Server and Oplocks
  487. Need Help with DLookup Function in Access
  488. MBE File Creation problem.
  489. Export to Access - ERROR: User-Defined type not defined
  490. "Select single * " in ACCESS 2000
  491. Reconneecting to BE after network drops out
  492. Export Delimited txt File
  493. Failure to compact/repair: why?
  494. Is the Between ... And operator strictly reserved for use in SQL?
  495. How to "hold" execution
  496. A97 code causes keyboard loss
  497. How to link an image to a record using VBA?
  498. Problems playing sound from A97 on Win98 box?
  499. Colours in Report acFormatHTML
  500. Limit to New records only after synchro
  501. Is This Possible?
  502. The missing hard drive
  503. ANDing and ORing question...
  504. Running Total Query SQL Syntax Error
  505. Won't open with startup, decompiling sorts it out, why?
  506. James Isle Mercanti's barcode39.mdb
  507. Permissions, RWOP queries not the answer
  508. Invalid Bookmark Error
  509. A97 syntax for specifying currently open database in DAO...
  510. How can I be sure I'm reading a MAC address hard-coded on a NIC?
  511. Report with subreport - one-to-many relationship
  512. MS Access 2003 and Word 2003 Mail Merge Problem
  513. Anyone know how to get a list of files in a directory
  514. sql
  515. Alternative application security schema via web verification
  516. Scrambling suggestions sought.
  517. schedule report mailing without leaving access open?
  518. Communicating with Act
  519. Seeking old Access 2.0 code for reading MAC address
  520. I'm pulling MAC address off local machine with code furnished by Radu Lascae
  521. Access 2003 - Error 1706. No valid source for product DAO.
  522. Automate Import from Access to SQL Server through VBA in a ADP....
  523. What's the easiest way to read a MAC address 'n suck it into MS Access?
  524. Query Querstion
  525. tracing relationships
  526. I've created some forms with the wizard that have textured background in detail section
  527. Web-ifying an Access database / Security
  528. Close application and automatically shutdown XP Machine
  529. Web-ifying an Access database / Security
  530. Close application and automatically shutdown XP Machine
  531. Please post a sample A97 runtime launch string example
  532. Pass Running-sum Group Total from Sub Report to Main Report
  533. from mdb to exe???
  534. How to Open a database.db in access
  535. Problem referencing the form that a Dcount and If...Then...Else statement are place in
  536. Make form uneditable based upon Access login group
  537. Yet another Backend Bloat Discussion
  538. Help with Fiscal Date problem Date(), DateDiff(), DatePart()??
  539. database design query
  540. Updating project rankings automatically - Help needed
  541. Testing for time elapsed
  542. link tables
  543. INSERT Query on two dependent joined tables ??
  544. Get rid of "Add or remove buttons" dropdown menu on custom toolbar
  545. Patrick Snowball
  546. How to display (print) the day of the week for a date field
  547. How did I accidently turn "snap" on in access 97?
  548. How to write by VBA in an embedded xls-file?
  549. Data in different tables.
  550. creating a query out of thin air