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 122

  1. How should I use NotInList for this application?
  2. Delete table and associated relationships
  3. works at home but not on host servers
  4. crosstab queries formatting question
  5. multiple selection
  6. multiple selection
  7. Variable Field not wanted in Access Queries
  8. Sending email with atachments in Access 2003 (vb)
  9. selecting a subset of choices based on a first choice
  10. I know it can be done now!
  11. Transparent Background on Subform
  12. I was pleased to see a couple of ttf files in my runtime distribution fileset
  13. ADODB and Access Reports
  14. Relationships confusion
  15. Set Recordsource
  16. Pulling info from linked table based on text box entry
  17. A97's 2427 error - Why does it occur when refering to a textbox control?
  18. Making access 2002 fill in the city from a zip code tbl
  19. ADODB Connection String - Prompt for Password?
  20. Another Mail Merge Question
  21. How to put the ID back to 1?
  22. Refresh sub form after entry
  23. Opening Access 2003 dumps copy buffer
  24. Open Form Smaller
  25. Question about mde
  26. Open a form to the position of the mouse
  27. Open a form to the position of the mouse
  28. Forms, Reports align on decimal
  29. unexpected prompt in report
  30. Transform string : "c;b;a;e;d" -> "a;b;c;d;e" ?
  31. Query Problem
  32. How do i create a validation rule in a table
  33. Two or more Access Reports -> a Single Snapshot file
  34. Embarrassed to put this on the forum - but here goes anyway - can't see controls on form
  35. 50 forms later, I forgot to set the form captions...
  36. Dates: Using a query result in another query
  37. Method 'Range' of object '_Global' failed
  38. Multiple sql statements in insert query
  39. Can someone tell me what is wrong with the syntax of this WHERE clause?
  40. Statement works in Access 2000 but not Access 2003
  41. Invalid argument
  42. Need help with building database
  43. Gather information from Excel PivotCache
  44. Question on Dcount -
  45. A97 procedure causes keyboard CTRL key to get stuck. Why?
  46. Excessive Calculations Please Help
  47. Some SQL trouble
  48. SendObject process automation
  49. Opened Form is not getting Focus
  50. OnFormat Event
  51. A2K3: Custom grouping for report
  52. Limiting no of chars in unbound field
  53. Calculated fields
  54. getting the name of the current field on a form
  55. Determine whether a specified control exists on another form or report object?
  56. Programatically Get A List Of Subfolders
  57. How to extract OLE Object (Bitmap Image) to file system?
  58. Want to Open a form and have NO default
  59. How do I get this query to work?
  60. Question on Access 2000 Report Design
  61. Is =GetMyCriteria() a valid criteria expression in query?
  62. Limiting Command Line Executable
  63. Calling user-defined function from query
  64. Strange behavier in execution of this SQL query....
  65. Dynamic Choice - Print or Preview
  66. 6 digit Date Format
  67. How to dynamically assign a query field its criteria?
  68. Example of an access update query
  69. Report Error: Multi-Level GROUP BY clause is not allowed in a subquery
  70. What's wrong with this get last day of month function?
  71. charting - time axis
  72. form event question
  73. Can someone tell me what the significant difference between Date and Variant datatypes is?
  74. Can I use A97 DateGrouping property to find Sunday date for any week?
  75. Append / Update Query
  76. accessing MS Access database fila via ODBC problem
  77. How to run a query that exists in Access from VB
  78. Image viewer controllable by Access via OLE Automation?
  79. Numb in Kalamazoo
  80. VBA/Query to update certain fields
  81. Access is using something to play audio files. How can I find out what it is?
  82. Error 2115
  83. clear out a mdb database
  84. maketable query and non-local database
  85. Is there a way to read the status bar?
  86. Poll: How many of you feel inconvenienced by inability to use dbl-click to select a string in A97?
  87. Reset an Undo
  88. Row Source SQL query question.
  89. Updating listbox.
  90. New Adobe Professional 6 user seeks Quick answer!
  91. Synchronizing Two List Boxes problem - Access 2003
  92. Suppress Access Generated Warning
  93. Undocumented rounding algorithm
  94. Failure to open pdf file
  95. Restricting what my user can see, howto?
  96. removing wrap text format when exporting to excel
  97. windomino - migrazione dati in access
  98. problems keeping window maximized
  99. Access and ODBC
  100. Weird form problem
  101. E-mail Attachment
  102. Using Datediff
  103. Access 2002 Wizard Source Code
  104. scanning Multiple pages into Access 2k
  105. WHERE clause constraint with 2 columns
  106. Adox procedures problem
  107. inserting autonumbers in SQL.
  108. Creating relationships in code
  109. Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
  110. Getting a query to use a number of values as criteria (A OR B OR C etc) which are stored in another table.
  111. Passing variable value from code to query criteria?
  112. Access screen resolution, resizing
  113. Tutorial or Book on Report Creation
  114. auto dial with voip
  115. A97 does not prevent entry of new records from a form bound to a table
  116. Automate import of data from several text files
  117. ECO Database
  118. Is DSN-less connection to UPS WorldShip possible?
  119. Molehill into Mt. Everest
  120. Gathering data from one table and sending it to another
  121. Output to CSV
  122. Import all Files in a Folder
  123. Adding Bulk Records
  124. Two questions relative to security.
  125. hyperlink address on rich textbox control - Any possibilty ?
  126. Access vs. SQL for audit trail of record changes?
  127. barcode active-X
  128. Display records from MS Access Database
  129. record locking but not
  130. Need form button that creates URL link from unique ID record
  131. what is demo.hlp in A97?
  132. a2k - does supporting multiple users imply use of Access security?
  133. o2k - more thoughts on moving to multi-user - comments?
  134. Ok really Wierd
  135. Fill query column with my own values
  136. problem accessing access 97 database through odbc on windows 2003 sp1
  137. Sequentially numbering a field !
  138. Convert DB Access 2002 to Access 2003
  139. ApplyFilter method
  140. Getting more than one result from a function.?
  141. Is there a benefit of setting up relationships in A2003?
  142. Help creating connection function
  143. Derive Ranking Function
  144. Amateur would like code critique
  145. Filter on subform no longer works with linked ODBC table
  146. reference a column but avoid blank rows
  147. A97 runtime objective: put a set of files in alternate dir
  148. Find via code
  149. VBA DoCmd.GoToRecord , , acNewRec in first row
  150. Redundancy of multifield indexes?
  151. Help - Updateable query adds new row with missing criteria fields
  152. Database corrupt by one record
  153. Access 2003, Can run a report but can't print 1 section.
  154. restricting access to records based on user identity
  155. editing MSysRelationships
  156. Updating cells
  157. passing data to modal dialog box in VBA
  158. Rich textbox control .
  159. MS Access Help: Copying database Relationships
  160. Problem with activex control in report
  161. Focus & Navigation Problem !
  162. embedded users manual ?
  163. Import not working- need SQL statement to add table2 into table1
  164. Linking two fields
  165. Group column headings and sum their values
  166. multiple contition field in a query
  167. AutoFill Field
  168. Calculate one year back, Access and Oracle
  169. Remove Access Protection
  170. Stacked Column Charts
  171. Is this a many to many?
  172. Display a form's Context help when the form opens
  173. Exporting to Excel: Multiple tables in 1 spreadsheet - the last of 3 tables won't export.
  174. How to do this??
  175. email via winsock
  176. access subquery not enough storage is available to complete this operation
  177. How can I make the database multiuser?
  178. VBA: Generic reference to ME
  179. Reference problem by running an application on an alien pc
  180. Simple Query to Linked ODBC table gives wrong results
  181. Open Office 2.0 import to dBase from text & spreadsheets
  182. Formatting a SQL Server decimal data type
  183. Update table after leaving a record.
  184. sql for an A97 query that'll return 6 future consecutive dates 20-25 days from now
  185. printing "blank" pages
  186. How to change the table name in a report?
  187. Copy at specific record...
  188. MDIClient height
  189. Duplicating record
  190. SQL to query value from field of current record only
  191. Help with Do...Loop command using dates as parameter
  192. Parameters based on Multi-Select List Box in Access 2000
  193. Memo
  194. Access Databases and the Internet
  195. Separating the database
  196. sendobjects with text fike
  197. How to utilise "Me" in a public function
  198. modify a line in a line graph using code
  199. Counting Columns in a table using code
  200. Altering tables in code
  201. Display two fields by selecting value in one
  202. Begineers question
  203. Is it possible to create a runtime A97 app that runs from a CD only?
  204. Save or Drop Record?
  205. autofill
  206. Property Not Found error when trying to set AllowBypassKey in A97
  207. AutoExec macro, A97?
  208. Why are some of my comboboxes getting populated and other are not?
  209. I have a completely secured database and I want to completely unsecure it
  210. Upsizing A2K to SqlServer, is Access Project necessary?
  211. Combining multiple columns into one row in one field
  212. Capturing Forms
  213. Whats in my queries and marcos!
  214. Combo Box Synchronising
  215. Help needed with combined Dlookup/DatePart Syntax
  216. Querrying Jet and SQL tables
  217. Windows 2003 Server and Oplocks
  218. Need Help with DLookup Function in Access
  219. MBE File Creation problem.
  220. Export to Access - ERROR: User-Defined type not defined
  221. "Select single * " in ACCESS 2000
  222. Reconneecting to BE after network drops out
  223. Export Delimited txt File
  224. Failure to compact/repair: why?
  225. Is the Between ... And operator strictly reserved for use in SQL?
  226. How to "hold" execution
  227. A97 code causes keyboard loss
  228. How to link an image to a record using VBA?
  229. Problems playing sound from A97 on Win98 box?
  230. Colours in Report acFormatHTML
  231. Limit to New records only after synchro
  232. Is This Possible?
  233. The missing hard drive
  234. ANDing and ORing question...
  235. Running Total Query SQL Syntax Error
  236. Won't open with startup, decompiling sorts it out, why?
  237. James Isle Mercanti's barcode39.mdb
  238. Permissions, RWOP queries not the answer
  239. Invalid Bookmark Error
  240. A97 syntax for specifying currently open database in DAO...
  241. How can I be sure I'm reading a MAC address hard-coded on a NIC?
  242. Report with subreport - one-to-many relationship
  243. MS Access 2003 and Word 2003 Mail Merge Problem
  244. Anyone know how to get a list of files in a directory
  245. sql
  246. Alternative application security schema via web verification
  247. Scrambling suggestions sought.
  248. schedule report mailing without leaving access open?
  249. Communicating with Act
  250. Seeking old Access 2.0 code for reading MAC address
  251. I'm pulling MAC address off local machine with code furnished by Radu Lascae
  252. Access 2003 - Error 1706. No valid source for product DAO.
  253. Automate Import from Access to SQL Server through VBA in a ADP....
  254. What's the easiest way to read a MAC address 'n suck it into MS Access?
  255. Query Querstion
  256. tracing relationships
  257. I've created some forms with the wizard that have textured background in detail section
  258. Web-ifying an Access database / Security
  259. Close application and automatically shutdown XP Machine
  260. Web-ifying an Access database / Security
  261. Close application and automatically shutdown XP Machine
  262. Please post a sample A97 runtime launch string example
  263. Pass Running-sum Group Total from Sub Report to Main Report
  264. from mdb to exe???
  265. How to Open a database.db in access
  266. Problem referencing the form that a Dcount and If...Then...Else statement are place in
  267. Make form uneditable based upon Access login group
  268. Yet another Backend Bloat Discussion
  269. Help with Fiscal Date problem Date(), DateDiff(), DatePart()??
  270. database design query
  271. Updating project rankings automatically - Help needed
  272. Testing for time elapsed
  273. link tables
  274. INSERT Query on two dependent joined tables ??
  275. Get rid of "Add or remove buttons" dropdown menu on custom toolbar
  276. Patrick Snowball
  277. How to display (print) the day of the week for a date field
  278. How did I accidently turn "snap" on in access 97?
  279. How to write by VBA in an embedded xls-file?
  280. Data in different tables.
  281. creating a query out of thin air
  282. Linking Outlook 2003 Tasks to Access 2003
  283. Changing the background picture on a form with code
  284. ODBC works in Excel not Access
  285. Requery Combo Box Clears All Combo Boxes
  286. Write conflict error - single user database
  287. Help with a form and checkbox
  288. Suggestions: Best Way to Integrate Excel with Access - Pivot Tables
  289. Adding records to a filtered form
  290. Subquery Fields Null
  291. Access Report Prints Shaded
  292. Returning True, False, and True Or False records
  293. Extracting records from recordsets
  294. Application and Form Design Suggestion
  295. Viewing PDF files from within a form
  296. Extract Data with VBA from table
  297. ASP.NET Application - Migrating from Access 2000 to SQL Server 7
  298. Creating Template in MS Access
  299. Stampa unione Word 2003
  300. Is there any known procedure to move the data from an excell sheet to a well designed DB in Access ?
  301. Help with code
  302. Weighted YTD Avg?
  303. Export Access table to Excel and format wksht using macro
  304. Lookup/ Combo Box issue
  305. Top 10 Issues with mdb front and SQLServer back end
  306. Errors Sharing 2000 DB
  307. Listing of tables
  308. Can I automatically generate a field in a table?
  309. Aggregate function Access
  310. Bulk Converting Access 97 to Access 2000
  311. Dcount in query not working
  312. TIME
  313. Restore Value
  314. EVAL
  315. How to secure an A97 database from being opened w/o the correct system datbase being in place
  316. Error Number 3000: Reserved Error (-3002); there is no message for this error
  317. Was the A97 runtime setup wizard in the ODE tools something MicroSoft begrudgingly offered?
  318. Export Access tables back out to XML
  319. Option Group on a Form
  320. Upsizing Wizard Nightmare
  321. Does anything like a "master error trap" exist in A97?
  322. Move a Record Up/Down in a Continuous Form !
  323. Can you tell the datatype of a control
  324. Query question - SQL syntax and joining multiple tables/queries
  325. ADP frontend - How to update a row added by a trigger
  326. Database window (list of forms) is frozen
  327. Listbox with Multi-Select Output Question
  328. Oracle Linked Tables - Big problem
  329. Add toolbar to MS Access
  330. Extract File Name From Path
  331. Autonumber failure
  332. Hey Horace
  333. WTF?? No save of modules?
  334. Can't delete fields
  335. Select statement Help
  336. A97 runtime installation onto Win98 box creates target mde file with +R file attrib?
  337. Showing currency decimal values in formns
  338. I have a problem w/ calculated field in A97 query...
  339. A97 Workgroup Security puzzle
  340. Repost (corrected explanation): Lengthy Error from Combobox
  341. Show certain records in 1 table - yet able to add new.
  342. Windows Terminal Server Printing Access Reports
  343. Update Using Form and Another Table
  344. switch attached hyperlink from an order to a loan.
  345. How to print report on one side of the page?
  346. how to backup an mdb file thru vba?
  347. Lengthy error message when attempting to select from a combobox list
  348. looking for ms access 2.0
  349. Conditional Tab Order?
  350. tracking changes among records in ms access
  351. Problem querying datetime in SQL Server
  352. Can SHELL handle a windows switch?
  353. Agregate function dates
  354. Something clobbering custom menu
  355. Easy Question: Comparison Operator
  356. Licensing Question
  357. Access on the Web
  358. function to stop certain dates being entered twice in access form
  359. A97 error "Operation Must Use An Updateable Query" ???
  360. Count, Sum or Ave records in a table with VBA
  361. Make a form query that allows the user select the text boxes ?
  362. Locking a temp table
  363. date/time in access to date in excel
  364. Format a reports layout
  365. end if function
  366. MDW
  367. Breakpoint being hit even when THERE ARE NO BREAKPOINTS set
  368. What the hell happened to my database?
  369. File bloating/compression problem in Jet
  370. Counting of records in a union query
  371. Admin Tables to avoid hardcoding data?
  372. privileges and tables for different types of users
  373. Help with Dlookup and Mid
  374. Create modular access frontend
  375. VBA/Lucent
  376. Can't open query in SQL View to correct query ("Join expression not supported")
  377. Spammed by PC Datasheet
  378. skip patterns thru a module....current forms problem
  379. How do I print the definitions of several queries
  380. Automated Data import from an excel form!!
  381. 3rd try: COMBOBOX not displaying all rows
  382. Combobox not displaying all the rows that it should be
  383. In the U.S., are EIN's nine digits long like SSN's?
  384. Can't load DLL '48'
  385. How to Lomit a Report
  386. Repost: To Dev Ashish (Concat query)
  387. Junction tables
  388. upsizing A2K to SqlServer
  389. Merge Query
  390. Populating one field in a table with one to many relation
  391. Using the replace function with ADO and an Access db from Visual Basic 6
  392. Multi select list boxes in Access
  393. Sagekey Access 2002 Runtime Object
  394. data weekly- monthly
  395. Access 2003 - How to show ValueList listbox data containing commas?
  396. Searching Child Forms
  397. Field Length for text box in form
  398. Exporting to HTML
  399. Error resolving replication conflicts
  400. Access and HTMLEncode
  401. Exception Report
  402. Failure to exit
  403. Confused about docmd.openform
  404. Cannot open any more tables
  405. how can I disable the mouse Scrolling Wheel?
  406. Most Recent Dated Record, perhaps I am not seeing it correctly.
  407. Incapsulate EXCEL into a ACCESS Form
  408. How to use Access with Web Services?
  409. SQL Server Connection User Security
  410. Record Number with a twist
  411. Strange Print Preview Behaviour
  412. Looking for an easy way to browse the file system
  413. Crosstab report with dynamic column headings
  414. SQL question... batch query...
  415. DateDiff function question
  416. keep track of Consecutive numbered cards
  417. Duplicate check on 2 fields
  418. Data type mismatch
  419. Cannot run any functions from a form
  420. Distinct vs DistinctRow?
  421. Appending to existing table painfully slow on network and 'out ofmemory' error
  422. Full, simple, instructions for connecting my C# app to an Access database?
  423. Dimming the Image in an IMage Control?
  424. SQL Linked Records (Quotes)
  425. Input range
  426. I copy Table from a DB to other one and am recieving an error, why?
  427. To Dev - Concat query
  428. To Dev - Concat query
  429. List Box. Please help
  430. Boot users - i'm sure i;ve seen this somewhere
  431. expression invalud, aggregate functions allowed only on output fields....
  432. add dummy character
  433. How to test the competence of Access Developer job applicants?
  434. HOW CAN I PRINT ACCESS REPORT FROM VB.NET.
  435. Stamping in a Hyperlink populates the Display Text but not the Address
  436. Can't save decimal numbers
  437. Displaying hyperlinks (as hyperlinks) data stored in linked table
  438. Search multiple job sites for you!
  439. Displaying Asterisks for Password typed into InputBox( )
  440. Determining the highest array value without cycling through
  441. VBA function for rounded pdf rectangles
  442. HELP - Everything is Locked
  443. How to prevent Form from closing?
  444. Dates confusions
  445. HELP! Strange behavior in A2K3 Dir function
  446. Insert statement into Access 2000 DB from VB6/ADO
  447. program to rename image paths
  448. Reusing a Form
  449. Creating Word Documents From An Access Query
  450. MS Access security-Read-Only with Create Report option
  451. Problem create view access ADP
  452. Trouble Exporting data
  453. Strange problem: Crash in print preview when opened by switchboard
  454. me.formheader.height compile error
  455. Please suggest right-sized shared database solution
  456. Grouping Problem
  457. Building a query with dates
  458. How to cancel unnecessary pages in report?
  459. PLEASE HELPPP URGENT..
  460. Record milliseconds
  461. MS Access linked to SQL Create View Problem
  462. Controls Flash Out Of Place On Form Resize
  463. Using a report multiple times
  464. Scroll bar on a disabled TextBox
  465. Pivot Table OXP W2K
  466. Numeric Field Overflow
  467. Last checkbox doesnt want to party
  468. APPOINTMENT TRACKING PER CLIENT AND CALCULATIONS - HELP
  469. clipper code to VBA
  470. Picking Random Values From A Table
  471. MSQuery Question
  472. Need help - trying to create a searchable list
  473. Date Criteria in a query
  474. run stored excel VBA procedure from ACCESS
  475. How do you export attachments on Access records?
  476. please help
  477. recordset bookmark problem
  478. Clearing a label used to display info from a combo box based on a linked table
  479. Custom Menus Overwirtten
  480. Transfer table records from one to another
  481. Problem UNIQUE KEY generation !
  482. Copy data from forms via relationships....
  483. data entry in add and verify mode
  484. Compact and repair
  485. Microsoft Graph and Access 2002
  486. Please, any help appreciated
  487. Open Acesss DB Backups
  488. Data entry of a swimmers/athlete's time
  489. Migrating data froexcel to access
  490. msjet40
  491. text limit on a textbox
  492. cannot import delimited text programmatically (macros) with automatic primary key generation
  493. Err 3188: Couldn't Update; currently locked by another session
  494. Login Security Question
  495. Importing text to Access, How to?
  496. Check off Items in Form
  497. determining next record in BeforeUpdate event
  498. Opening a form based on user selection in combo boxes
  499. Need some help in designing a simple customer database
  500. Checking if record exists
  501. Need to use a yes/no box on a form to drive a table update
  502. Table form cross query
  503. how to link a master detail table
  504. Using Code to log activities in a text file
  505. Carriage Return problems when importing from a Word document
  506. Operation must use an updatable query. (Error 3073)
  507. Show another item in table based upon what user selects.
  508. Access DB back-end File bloating
  509. Problem Using "Multi Select" Feature with a List Box on a Form
  510. Designing a small CRM system
  511. Memo Fields
  512. DoCmd.OutputTo vs. Macro Sheet
  513. Database Size
  514. HOW TO
  515. More of a Word problem really.. mailmerge
  516. how to lookup value in a form
  517. Entering records into a table from list box values
  518. Using different versions of access
  519. Reports: Formatting can grow / can shrink fields to the largest box.
  520. Excel VBA query to Access DB not returning all rows
  521. Query
  522. Access Date calculation
  523. Un
  524. Locked out
  525. Import CSV file that is currently zipped
  526. MS Access 2000 Report
  527. "Leftover" tab
  528. SelStart - SelLength
  529. SQL
  530. Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
  531. Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
  532. Is there any good solution to make a middle table or relation that allows usto have for each record in the Client Two or more records in the category connected with it?
  533. how to validate quarter-hour increments??
  534. How to create an e-mail as a sum of columns?
  535. How to creat thumbnails of jpg images in MS-Access database
  536. Mail merge date problem with Word 2002 using Access as data source
  537. How to determine if directory exists
  538. Random insertion upon deletion
  539. Delete a space in a string depending on the fields lenght
  540. Parsing Problem
  541. mde
  542. Driver License Scan
  543. locked out
  544. Query Multiple Criteria "All" or 1?
  545. How to implement a 'queue'
  546. <<help>> Code worked before and now it doesn't!
  547. Record counts
  548. What text property setting controls the "look" of the text in label attached to disabled textbox?
  549. I have a problem running Format in A97
  550. Any real need to go from DAO to ADO?