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