Home : Bytes IT Community / View Full Version : MS Access

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

  1. How do you record multiple values into a column??
  2. File Name in Add-In Manager?
  3. Moving data from one list box to another via a button
  4. ??? for Wayne Gillespie on FTPClient Class Module.
  5. MS Access: a true RDBMS
  6. How to get cursor focussed on field field after new record?
  7. After closing Design View, the table appears instead of form
  8. Autonumber ID not yet visible when starting new record
  9. attaching picture to table
  10. Happy New Year
  11. Erl
  12. Change event trigger
  13. detail section in a report
  14. Licensing versus Customization
  15. Importing Text File that is vertically oriented
  16. After insert of date how to auto jump to next field
  17. Only get 1st record viewed in Report.
  18. DAO peculiarity in A97?
  19. Calculate Date Difference and display message box
  20. rendered date
  21. VBA for ACCESS
  22. Find and Replace against set of rules in 2nd table
  23. Carry data over to new record...
  24. =Iff(([Me]![Gender])="M","Male","Female")
  25. Edit multiple tables with one form per record
  26. Help with blank fields
  27. Help needed with ONLY VBA Code or Query
  28. Year Numbers
  29. Reports
  30. Report / Query Problem
  31. Using MZtools Freeware for VBA
  32. Run Update Query silently in background
  33. Run Update Query silently in background
  34. Create Macro to import fixed width text from clipboard or text file and update table
  35. reset number on new year
  36. Runtime error has occurred
  37. Creating Runtime DBs with Access
  38. move relationships from dev to production db
  39. How can I Display Visio Drawing?
  40. one to many howto????
  41. ComboBox Progressive Requery
  42. Minimized Database window moving way off screen
  43. merging tables
  44. navigate form with arrow keys
  45. calculating age from DOB and adding to table
  46. close form macro
  47. slow query
  48. Combo Box Progressive Requery
  49. How to increase the performance by working with linked tables
  50. Help with SQL query
  51. Clearing a combo box
  52. Hyperlinks inside an Office Assistant bubble?
  53. Hyperkinks inside an Office Assistant bubble?
  54. SendKeys help required
  55. subform refresh
  56. How to import..
  57. Adding a range of numbers from a form to a table
  58. datepart problem in VB code
  59. Problem with DateDiff
  60. add one to string in sql query
  61. Access 97 / XP sharing problem
  62. 2 Beginner Access question
  63. Reversing a COlour Code
  64. Sorting a SubForm
  65. Trouble with order by clause in report
  66. Off Topic - Access to Postgres
  67. TransferDatabase problem
  68. Nulling field in subform
  69. Tips to document Access program
  70. Lebans ReportToPDF solution Help
  71. Date Validation: IF's vs Case
  72. Probably a very simple problem, but it's got me...
  73. Adobe Acrobat & pdf.ocx - The Paperless Office
  74. failure in saving new added field
  75. A very basic search form in access
  76. 2 queries OK by themselves, FAIL in Union
  77. How to store folder path as Hyperlink?
  78. VB code to perform custom query of MS access table and display alert
  79. Run-time error
  80. Access Report is giving extra blank pages
  81. data in a tex field on an unbound form
  82. trying to copy an Access 2003 pivot table to excel or word .... or something
  83. 'Converting Varchat to Int' problem
  84. Relationships
  85. Not sure I understand what Response.buffer is really about
  86. MS Access adding dates
  87. Create Dynamically Built Data-Entry form to enter data into two tables
  88. Timeout while DDE linking to a VB application.
  89. query not working when i add an alias
  90. Runtime version overwrites full access
  91. calling excel function LinEst from VB
  92. Access to VB
  93. How to do a hyperlink inside of ...
  94. Choose Month & Year when giving report criteria
  95. Synchronising/replicating access with sql server
  96. serialize/deserialize Access report object
  97. Choose Month & Year when giving report criteria
  98. Pivot Tables Access vs Excel
  99. Use Select Query variable against a table and return value to same select query
  100. DeleteDuplicateRecords
  101. Progress Meter does not refresh during series of OpenQueries
  102. How to join two fields
  103. Left(field,Numchar) or Right not found
  104. Is there a way to disable the F-11 key to prevent runtime installations from opening the database window?
  105. NZ always returns a zero-length string when used in a query expression?
  106. backup databases
  107. Access 2003 unable to link to ODBC but 2002 on same machine can
  108. Duplicate record check
  109. Hyperlinks
  110. Sending SMS from Access
  111. UserForms
  112. forms only show primary key
  113. Scroll bar strangeness on subform
  114. Calendar Control turns white on new record
  115. automatically append new records
  116. OldValue not set
  117. form property for subform
  118. Help required formatting a date field in a SELECT statement results
  119. A2K3 & object dependency refresh
  120. What's with ADO?
  121. Assigning common id based on evaluation of two columns
  122. Select ALL from an unbound form for query parameters
  123. Totally lost on Date Sort
  124. Crosstab Query: Sort Column heading based on other column sort
  125. Cross tab Query: Sort Column Heading based on other column Sort order
  126. Split Database Security Problem
  127. Query has a problem with December??
  128. error -2147217904 - how to fix :o( ?
  129. A2K - passing more than one value into a popup form
  130. MS Access, PostgreSQL 8.1.1, connection string
  131. ODBC, connection pooling
  132. Using seek to find if a record exists
  133. error 286: the other application in the DDE conversation isn't responding in the time specified by the OLE/DDE timeout setting
  134. Can lines collection be used to assist me in automatically numbering lines?
  135. GetSetting function breaks when code-signing
  136. Invisible textboxes on subform
  137. Database design question
  138. Filtering on a form
  139. Checkboxes verses field list boxes
  140. How to pull the newest record for each student out of a table
  141. after update not triggered
  142. Opening form in datasheet view
  143. OT. Happy Holidays to you all
  144. CurrentDb problem in report
  145. Need to add trailing 0's
  146. Problem with Left function
  147. Query Shows No Records
  148. Developing in Access 2003 with conversion problem
  149. setfocus to access application
  150. Packaging for multiple office versions
  151. MS Access Send To recipient (not as attachment but as HTML)
  152. A97 Runtime - I wish to disable F-11 key from displaying database window
  153. Sorting many fields in a form
  154. How can I enter several lines of text as a criterion and return several lines from my table?
  155. access 2003 validation rules
  156. lInking subforms
  157. Unable to edit form - Many-to-Many relationship
  158. What is a Library mde/mdb?
  159. on open and before exit events
  160. Access2000 data Entry Unbound Form With Subform
  161. Contingent formatting
  162. Developing in Access 2003 for Access 97 users
  163. Saving information on reprot to new table?
  164. How to stop library mde being reused
  165. Can't link forms
  166. An aid to inserting a Date, Small calender pops up
  167. Scroll bars are not appearing in certain situation.
  168. Customer keeping track of invoices received and paid.
  169. Access 97 Problem: only one printer shown in the printer screen
  170. Picture Importing
  171. TransferText dropping fractions
  172. Is Access smart enough to optimize this ?
  173. pasting records in datasheet-form: pass-through called twice ?
  174. Horizontal Scrollbar
  175. coloured lines of alist box
  176. Set Warning? Maybe?
  177. Need help on updating text box!
  178. video rental database?
  179. Making MS Access Form as a standalone form like in VB
  180. Can anyone recommend a Dot Matrix printer for my DB?
  181. Run external application script from access?
  182. problems with DSN for MS Acess database
  183. Reading image files from a URL location
  184. MS Access 2003 sending emails
  185. better way
  186. HELP 97 -> 2K and lost all relationships
  187. Help with a query trying to total!
  188. Subtract MULTIPLE time segments from a single time segment to calculate cycle time
  189. ControlTip Text
  190. Trouble With Left Join
  191. Dlookup
  192. mappoint looses forms focus
  193. dcount, dsum, dlookup question (not syntax)
  194. Combo Box Recordsource When using CodeDB
  195. Forms - pagebreak Visibility
  196. NetSearch the Business Intelligence Search Engine
  197. Creating a checklist from a table to indicate attandance
  198. hide form on startup
  199. Can't figure out error in simple dsum
  200. Data Conversion Error
  201. subform within a subform
  202. Help in generating a report
  203. make table query
  204. Can a variable hold 2 values simultaneously - a string value and a numeric?
  205. VBA Query code issue........
  206. Connect 2 subforms
  207. Dynamicaly created where clause for OpenForm
  208. Access versus MSDE versus SQL Server Express
  209. Database design - incorporate year of a certain event
  210. Error 3075 Function Not Available - but no missing references
  211. Strange findfirst behavior
  212. How to vary the number of copies of each record in a report in A97?
  213. Forcing Cursor To Specific Record/Field On Continuous Screen?
  214. Goodies in 2003?
  215. SQL Insert Into Error
  216. Parsing
  217. Transferdatabase
  218. how to determine whether any report is opened?
  219. I've never seen A97 combo-box wizard fail on a valid query until today...
  220. Key based on Login entry
  221. Listbox value does not change
  222. Properly using checkboxes in a datasheet form
  223. HIPPA - HealthCare Cliam Transactions
  224. Can you import images into access
  225. Export MS Access table via OBDC using VB
  226. real record in a subform
  227. mixing linked tables
  228. Input Mask for dateformat dd/mm/yyyy hh\:nn
  229. A97 - Forms - Rail Road Track layout
  230. Copying root directory
  231. Windows Explorer Switches
  232. 2 Combo Box Menu from Multiple Query
  233. pivot chart
  234. Sending report to a PDF File. Good link for Access developers
  235. Function DatePart(), how to subtract the month from a date field
  236. entering data from form into two tables
  237. Combo box dependent on another combo box, text part is blank
  238. gtotal
  239. attaching MsSQLServer(msde2k) tables to Access2k
  240. Trying to total a text box in report
  241. Update an account balance on a daily basis
  242. several questions regarding graphs
  243. recordset.MoveLast - "not enough space on temporary device"
  244. Backend on the internet?
  245. Execute database to Excel exportation stored procedure from VB
  246. query how to
  247. open excel file
  248. open excel file
  249. Updating combo box
  250. dynamically create Tab Control possible?
  251. Setfocus question
  252. default value help
  253. Table exceeding one million rows crashes Access
  254. Filtered Colum To Single Comma Delimited Value??
  255. MS Access forum
  256. Analyze Tool & Lost Data
  257. Default sort order
  258. Add value to subform from main form
  259. Datasheet View: Second Combo Box Criteria Based on First Combo Box Value
  260. Access Reading and writing emails
  261. ftp from Access: problems
  262. Help with a report field
  263. Subject: Access Reading and writing emails
  264. Access fails if printer is out of paper
  265. Removing duplicates from query, but not from table
  266. I have carried out the Keith Wilby stepwise approach to securing an MDB but I am not sure what I have achieved
  267. Loosing Db connection?!?!?!
  268. Text becomes available when check mark is placed
  269. How to Test Function in Immediate Window
  270. Self join. Employees and supervisors query.
  271. Access 97, W2K, "can't open the mail session"
  272. Help with query to extract next best product
  273. Securing only certain forms?
  274. Printing to a dot matrix printer
  275. Enhancing the FAQ. Please suggest enhacements....(new topic, getting closer...)
  276. VBasic window opens with references grayed out
  277. Sum of Sum in Totals Query
  278. Trouble with concatenated string function
  279. Opening one database always restores a minimised database
  280. vba to activate a command button in a different though open form
  281. invalid operation
  282. The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record
  283. Arrays in Access.
  284. Can't get subform on tab control to requery
  285. Query help!
  286. Forms: attaching labels to a combobox
  287. move next
  288. Need help with ValidationRule
  289. Suppression of auto-fill-out of MS-ACCESS
  290. auto email
  291. Getting the right software without getting ripped off
  292. Creating a dynamic form, how?
  293. I wish knowledge as to creat a Bibilical data index i.e. Genesis to Revelations not alphabetical!
  294. Form navigation buttons do not show correct position
  295. How to Compress/zip files from MS ACCESS and then send it by email?
  296. Returning orders
  297. how to know the record position shown in a form?
  298. configuring access for all users
  299. MOST recent date
  300. Combobox Not In List Event
  301. Help! Public variable not staying set - 3420 Object invalid or no longer set.
  302. Proper use of global variables for reports
  303. Report question?
  304. Syntax for password protectd database...
  305. #error in report w/linked tables
  306. Sending data to Excel
  307. Updating via internet
  308. Novice Question - I wish to modify the data in multiple feilds
  309. Leaving debug.print statements in a database intended for runtime?
  310. general db design question
  311. Different type conversion A2k and A97 ?
  312. Outdated help (feat. Access '97 and VB4)
  313. Delete existing before running Open "c:\MyFile.txt" For Output As #1 ?
  314. YearFrac Year Fraction Calculation
  315. Code compiles, mde creation fails
  316. error setting a subforms recordsource from another form
  317. Odd error setting a form's recordset property
  318. Any reason to favor calling a batch file VS running a CMD directly in A97 VBA?
  319. Query runs fast once, then very slow
  320. Database Password
  321. Changing relations with VBA code?
  322. Method for updating production backends with new tables/fields
  323. Find first and last element of a column in a table
  324. Display text field for current record only......
  325. Access as Automation Server - Problem declaring Form 'withevents'
  326. How to Recover your lost password for Microsoft Access 95/97/2000/XP/2003 database ?
  327. Access and Images - Linking image table to a record table
  328. Can I waste your time please
  329. Healing
  330. How do I set an Aggregate SQL statement result to a control?
  331. Linking to tables in Firebird or other db
  332. Listbox Question
  333. Tab Control Question
  334. Compatability of A2000 and A2003.
  335. Could use so code help!
  336. Bookmarking
  337. Container Graphics not acting as expected
  338. Relationships design
  339. Having a tough time re-deploying proper System.mdw
  340. How do you adjust a form to open from the top?
  341. Automation Slower Than Windows Explorer
  342. TO ALL SUPPORTERS OF ARNO R AND HIS GOONS
  343. wrong result from recordset
  344. Launching an OLE Application From a Form
  345. OpenRecordset method
  346. Help with microsoft access for making schedules
  347. Can a MDW file which relates to a specific app be deleted?
  348. Subforms and Search Function
  349. Checkboxes
  350. How to Zip Files from ms Access
  351. Strange one: A2K2 wont recognize break points
  352. How to zip files from MS ACCESS
  353. Looking for Access Reporting Add-ins
  354. disabling close button for application
  355. Database doubles in size, when forms deleted even when compacted!
  356. How to tell if there is no selection in a DataCombo box?
  357. Capturing FTP responses in VBA?
  358. Changing order of columns in a table
  359. Wanting to give users 3 options
  360. Microsoft Off 11/Off 9 Reference
  361. Copy selected records and save as new rec with user input
  362. Multiple recordsets continued
  363. Attachments lost/reset once public db variable is set to ""
  364. To link or not to link
  365. New to access. stumped on query. Column to Row conversion Any ideas?
  366. Local Table vs. Class for Public Variables with simple types
  367. Multiple Vehicle Mileage Calculation
  368. In case you ever get an error 2455
  369. How do I change the keyboard input language from within Access 2000?
  370. File Transfer Animation
  371. Find Primary Key field
  372. Linking Checkboxes to values in a table for a Report
  373. Automatically printing to Adobe Acrobat
  374. OraOLEDB.Oracle provider missing
  375. Getting data from excel spreadsheet column into access table
  376. Report Help
  377. run sql query for each record in a contious form
  378. Ok this is a strange one
  379. SET NOCOUNT ON; Multiple Recordsets; ADO Command Text
  380. Look at this
  381. Curious about Access 12 Report Formatting
  382. Circular relationship nightmare
  383. print ourt labels
  384. Import Paradox database into mdb issue
  385. Automate printing reports to PDF
  386. Automating a command button to do a Get External Data command
  387. Super easy word merge
  388. DLookUp Problem
  389. database variables problem
  390. set up two criteria in one command button
  391. Finalizing the dialogue with newsgroup Megalomaniacs (change of Subject...)
  392. HELP - Using GoToControl in subforms
  393. Remove Filter/Sort
  394. Database security (crosspost)
  395. Encrypted database
  396. Conversion: Access 2000 to Access 2003
  397. Subtracting Dates
  398. Multipage Form
  399. Active X controls problem
  400. Dumb Question
  401. Edit format of field in a form that can be populated by a lookup
  402. How to extract just the time portion of DateTime
  403. Validation q's - subform BeforeUpdate event (and SQL)
  404. Code not producing desired result
  405. TransferText and Missing/Skipped first line - Solution
  406. Drop Down List
  407. Navigation buttons
  408. sql password with access query
  409. multiple selection
  410. multiple selection
  411. Can't update data in a query
  412. Word and Excel Objects in Access Reports
  413. Evals("myPublicVariable") do nor work: have you any alternative way?
  414. I am gathering the date of my customer..
  415. Dialogue with newsgroup Megalomaniacs (change of Subject...)
  416. is the access database able to be converted to SPSS date?
  417. subquery problem
  418. Display full name in combo box
  419. Get list of custom properties
  420. Switching between two columns in a form viewed as datasheet
  421. Horizontal grouping
  422. Multiple Recordset from a Stored Procedure
  423. From ListBox to Subform -- , how to add SQL statement?
  424. the switch statement has got me a little confused..can someone clear this up for me please
  425. Mailing Labels
  426. Select INTO ListBox
  427. Form border color
  428. Confirm/commit insert in ADP project
  429. Help with a list box
  430. ODBC: SQLTables does not return data for an Access database?
  431. OpenRecordset help needed
  432. Aiuto per formato data
  433. filtering and edit
  434. Error occurs when MS Access open Excel document and trigger the assigned macro in Excel
  435. SHELL handling a switch.....
  436. Explanation???
  437. Form opens SLOW when "Allow Addtions" set to No
  438. How to connect MS Access form to MS SQL Server
  439. I'm trying to completely unsecure an A97 app
  440. Pasting multiple lines of data into text box - how do I divide it into seperate strings??
  441. Query works in Access but not with exec call from .net
  442. A message to Self-Appointed-NewsGroup-Netiquette-Enforcers... PLEASE LEAVE US ALONE!
  443. Load Form?
  444. Need help on seeing data in form
  445. QBF problem with multiple combo boxes
  446. If Statemet
  447. What kind of replica?
  448. closing a db with an error
  449. MS access: Book recommendations
  450. Import data and changes from access to access
  451. editing data in pivot table
  452. Help please! Add or remove from field value through a form
  453. Text Field default value based on function...
  454. Programaticaly populate a sub-form
  455. Pass Through Query Nightmare (Access 2K --> SQL Server 2000)
  456. How can I stop people have access to my MS Access Tables and Queries via Import?
  457. Learn SQL?
  458. Mappoint app or activex control?
  459. beginer with problem
  460. Simple MS Access Update ... Wont Update
  461. Plot a data series along a secondary value axis
  462. Intel Software to boost Access' performance
  463. Re-appearing dlls and type libs.
  464. Field for Number of records in a query
  465. change form property using SetValue
  466. Query to display number count
  467. Browse and Store Filename
  468. Browse and Store fileaname
  469. clsReadTextFile
  470. Access 2k3 / WinXP Issue = kooky join
  471. Keeping track of jointly owned assets
  472. 50,000 Ft Question
  473. query
  474. Test
  475. How are you connecting to this group?
  476. Partial replica: which tables are synchronized
  477. Alternatives to expensive Wise/Installshield/Sagekey?
  478. Deleting from the query's datasheet view, from both tables?
  479. Query by User
  480. How to sort Commands in Menu Builder (Customize)
  481. How to convert/transform txt to DB
  482. Access date validation driving me nuts
  483. How to determine what system DLLS are running in one screen?
  484. Selling Access app to general public?
  485. COMCAT.dll difference in Packaging Wizard.
  486. Error 3075 when in stalling Package Wizard set up file (XP)
  487. Access 2000 Delete ADDs a New record? Help
  488. Delete Record Woes Access 2000
  489. export problems
  490. Problems Sending Attachments
  491. Hyperlink Properties
  492. Changing caption content in a Table or Form
  493. upload excel file into sql server
  494. zTest.htm Ever hear of it?
  495. form timer stops firing until mouse or keystroke event
  496. Get SQL Data (DNS Less)
  497. date value issue
  498. ARG! Help! Path/File error using Access XP ODE P&D Wizard
  499. Retrieve global constant string from another database
  500. Linking Two Subforms
  501. combobox dropdown
  502. Access 2000 query problem - Help!
  503. Relative Recordset Position
  504. Prevent Design View
  505. form sizing
  506. Blank page after report header
  507. TransferText and First Record in Text file
  508. Printing sheet of labels not working
  509. Using both IS NULL and IS NOT NULL in Access 2000 Pass Through Query (for SQL Server 2000)
  510. O.T. - I'm not sure - Anyway, its a sort algorithm question
  511. Access does not like Mysql
  512. WARNING: Relationships not imported with data
  513. copyfromrecordset does not work on different machine no errors reported
  514. Address Label Problem
  515. Is this a bug?
  516. Access database on Windows 2003 server is excrutiatingly slow
  517. Memo Text Truncation during Excel Export
  518. Adding last record to another table with Append Query
  519. I confess
  520. How do you determine if anyone is logged onto a BE database?
  521. Change table date/time field to text field in code
  522. Urgent Help on Australian dates on spreadsheet saving as American dates on a text file.
  523. Access 2000 database and Office XP compatability?
  524. macro, control on form
  525. Has anyone posted code to convert longer HEX numbers to DEC strings?
  526. Prevent minimising application. Possible?
  527. ADO new record #Error why??
  528. Date criteria
  529. Help handling string length overflow?
  530. All caps font for A97 report
  531. Re-logging into An Oracle Database
  532. Form Backgroud colors
  533. fDesign
  534. Help With Expression Please
  535. Difficult SQL Query with multiple records detail
  536. SQL code not returning correct data
  537. Report sometimes prints in grayscale -- problem and solution
  538. Window on toolbar
  539. Report
  540. How to make a condition for making a SUM - Correction
  541. How to make a condition for making a SUM
  542. Help with Golf DB
  543. DLookup syntax when there are two primary keys
  544. Automate WinZip self-extract
  545. Evaluating References in Code [Long]
  546. How to Consume a Web Service from Microsoft Access
  547. Access Hangs during spell check (Caught in loop)
  548. dcount syntax
  549. ADP and T-SQL Problem
  550. Need a Flowchart type Calendar for a lodging reservation application