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