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