Home : Bytes IT Community / View Full Version : MS Access
- User table structure
- Problem printing some access reports
- Functions not working
- Database design service
- Summary Page - Best Method
- INSERT into + null
- ReportToPDF
- Import different excel-files in one access-table
- Table property question
- Auto populate combo box range based upon previous selection
- Need help
- Forcing code to run from the Back End.
- cloning
- ANGELINA JOLI
- Plugging an alternate data source into MS-Access
- Querys are read only
- Quickest way to modify a recordset and insert into a table
- How can I create a list of another database's objects?
- Reports Running Very Slowly Under Vista
- URGENT PLEASE HELP!
- label is not visible on form
- Excel-Access link
- cross table report problem
- help please
- vb6 Access database - too many user
- Macro/VBA in MS Words
- Count Function
- Printing from code
- Problem installing Office 97 Professional SR2b patch in Vista
- Opening another program and maximising, and check whether already open
- Creating values in a table in code
- Computer Programmer Job Available!
- ms access data access pages
- Hide Captions title on form windows
- Proper Query Summing
- Records
- Open form using where clause
- Access to Outlook
- Unmatch query
- Outlook appointments
- Create Table & Provide Default Value
- Export to XML based on predefined schema
- Monica Bellucci
- TRIM
- TRIM
- comp.databases vs microsoft.public.access NewsGroup
- struggling with recordset code
- Functions not working
- Data gets out of order when exported
- receive and send emails in Access 2002
- Keypress --> avoid vbkeyreturn in textbox
- Slow odbc oracle query using oracle odbc
- Online Connection between Access and SQL Server
- Change field names to first row of table
- A3 Page Size Won't Stick
- Printer Drivers and Crashing Objects
- Referring to iteration number on a continuous form
- Corruption - how to MAKE it happen?
- Default View
- creating multi-relational db with overlapping memberships - very green novice
- Put field name in a column
- How to make first selected item in a list box visible
- Formatting NULL values in Drop-Down control
- Formatting File Names for OutputTo
- Change properties of existing tables without dataloss?
- Format VB Coding in Reports
- Splitting records in a table if a field has multiple values
- Calendar Templates
- Create Access Tables with a Pass Through Query from SQL2000 with SQL
- Why does my DB crash?
- New Database Help
- dbOpenSnapshot
- Themed Controls Bug?
- Need Enter key to populate field with value from previous record
- [Cross post] Recipient list of final task report in Outlook 2002 into Access 2002
- Opening an application from MS Access
- HELP - I goofed when creating a database
- Excel object still in memory after Access app runs
- Grrrr!! Access 2003 Database Corrupting On Exit
- KeyDown Event Question
- Two foreign keys pointing to the same primary key in other table
- Login/VBA script to login to Access 2000
- Access "Pages": Anybody Found A Real-World Use?
- Forms/Tables that can't/won't hold scroll
- Center Overlapping Controls
- Continuous Form GoTo specific record
- can't get unmatched query to work.
- module source control
- Question of How to Make a Certain Report
- skinning?
- Mentored Learning
- Steve Leban's RTF2 control & printing
- Database only works for a week
- cross-regional database management
- Auto FE Updater and Access Versions
- Recordset or Array to memory problem
- Access XP - Getting the current directory
- Category splitting Access 2002
- Report to pdf
- VBA breakout
- Report to pdf
- access form search record before delete
- How do I sort by a Count?
- Outlook 2002 to Access 2002 transfer
- Check Linked Table Connection
- Customer List Selection
- Slow application if more than one user
- Format combined fields?
- Saving a XML text file with Unicode encoding from Access
- Reference To Form Not Working
- Decompile?
- Right Join query with Between HELP
- touch screen
- Count fields that are not null
- Urgent! Subform populating another form
- How to detect all required fields of a form?
- Converting Access 2000 to 2003
- How do I create a shortcut to a report within an access database
- Changing the visible setting for a field in a sub report
- number of active customers per period
- Last vs Max
- Help - subform creating unwanted record in other subform
- Startup Application Icon (Front End)
- Grouping Data Range
- Printing Multiple Forms
- Querying Linked Tables on a Network Drive
- Joining different types Fields
- Max Value of Field (with a twist)
- Exclusive access problem in split db
- Not just returning value of selected record
- form access to form excel
- Can Access 97 run on Vista?
- Problem linking to website with Access
- Parameter queries
- Round numbers to integer
- 30 day trial then disable the database?
- developing a system for work and need some help please.
- Help needed adding times problem
- Introducing myself
- Database Dilemma
- Are any of the new version of Access any better than 97?
- query question
- Ms Access Tables Internet
- Access Databases Much Slower To Load Under Vista
- Wierd Stuff that happens. Access Reference Refresh.
- Unbound Formula required urgently please
- Special Characters Not The Same In Access as Excel, Word
- Open an ole-object from a table
- CDO for email?
- Link the FE to the BE using Code and Path/File
- good
- Editor setting to allow spaces in my code?
- Select Printer
- get and set form position
- Oracle 10g RC2 ODBC Access - odbc failed - where xyz <> "S"
- relational design normalisation
- pass value to variable in html file
- Access Permissions
- Make a PopUp Dialog Form Invisible
- Terminal Server or runtime version?
- Public and Private
- seeking query advice
- Using recordsetclone when only allowing new records to be added (Form Property Data Entry = yes)
- Syntax for correctly setting filter property in property sheet for form
- new item is automatically saved
- Display dynamic image in MS Access 2007
- Access Tables to Excel Worksheet Export
- backing up database...
- Problem locating file using Dir() function and path using UNC (Universal Naming Conventions) in Access 2003
- Can I Pass this Filter: ([Lookup_Field1].[Field1]="TYPE1"))) From Form to Report?
- DoCmd to delete records
- Design Question - many to many relationship
- Return only first record in set of records???
- drop list
- Displaying multiple records in a form
- Can Not Open Database
- showing every quarter between 2 dates
- Look and Feel Legality
- Import Wizard
- VBA syntax
- Repeat Section Problem
- query problem
- Just Learning and Need Guidance! Please!
- How to back up the data mdb using code (A2K3)
- Who are Darwin's Outcasts?
- Mouse wheel and Access 2007
- Updated AppUser Utility?
- Updated AppUser Utility?
- create table and specify a default value
- create table and specify a default value
- Access 97 Different Row Counts for Snapshot or Dynaset query
- access query help
- comp.databases.ms-access: 2002 file format problem
- Outputting "Create Table" SQL statements from access.
- to_char
- Avoid users being able to see db structure in .ACCDB of 2007
- DAO360.DLL - Access 2007
- need to find a cost effective inventory system
- Totally Off Topic: Dell and Vista
- How to roll your own combo box?
- Double Metaphone
- Which query is running
- Is it possible for an A97 report to be printed directly to MS PAINT?
- Copying all columns from another table
- MS Access 2000 DB w/ Multi Read Only Users + Folder permissions & the Lock File
- Help with Access Reports
- Excluding Fields On Export
- Get list of Available References?
- new error message
- I can't open my access database
- concatenating problem when hyphenated first name
- Domains
- Convert 2000 to 2007
- Update Column with Content of other table
- List people whose 40th birthday is approximately one month from now?
- Tabellenwert in einer anderen Tabellenspallte eintragen
- modeling tools useful for Access
- Duplicate numbers in "Autonumber" field -- help!
- Recordset FindFirst Not Working, Why?
- Seeking way to control default font size in ONLY MsgBox's in A97?
- Can you export a Report to another DB?
- mouse scroll whell problem
- File > Open works, double-click doesn't work?
- Query between dates
- Comepare todays date with date + 60 days
- dynamic forms
- adding a subform to a form....getting errors on the link
- Restrict FE application to one user at a time
- Menu Question
- Scroll In Code Window With Intellipoint 6
- Empty 29 comboboxes?
- Empty 29 comboboxes?
- VB script for comparing 2 MS Access Files
- Programmatically saving a record
- Info: code reference examples for developers
- PAINTING, DRAWING, MUSIC, POETRY
- ODBC Dialog won't appear
- Query with no doubles
- Sheets() and Worksheets() the same?
- Date Range Prompt for a Query
- Rounding numbers
- default text on a form unless.....
- Records corrupt in Access 2000+ but not Access 97
- Assigning one lesson to many or all students at once
- SQL Format "?"
- Office 2007 Academic
- Ignore Duplicate Entries
- Help with numeric field, msgbox
- FindWindowByPartialTitle Rename Title
- Help with sorting
- Maximum Number Of Controls On A Tab Control
- Can attributes of tables/relationships, etc. be changed programatically?
- Reference material recommendations
- Running average for weekly Dollars
- Linefeed to CrLf
- Array Values as Query Criteria
- OnKeyDown Event (When does it initially fire ?)
- Proper Use of Requery
- Unbound TextBox assignment to a Record OnClose
- Adding records to a table based on the value of one field of other
- Export db object using VBA
- Fiscal Calendar
- Read File
- Problem with counting selected records on form
- unable to open MDB file on server
- Access 2003 Blue Theme Under Vista
- Dabase Design
- Calling an IIf statement
- SendKey Problems with Vista
- Request for help
- Saving export to local drive is very slow
- Saving export to local drive is very slow
- Saving export to local drive is very slow
- Export to excel does not include data from all the fields
- All screen fonts defaulting
- Access keeps crashing
- Address a Control on a PopUp Dialog Form.
- Trying to set form filter from module
- new to calculations
- Trying to set form filter from module
- ReLink only tables?
- action queries not working when migrating to mainframe?
- action queries not working when migrating to mainframe?
- anyone used a form resizer
- Access Forum
- How to bind table record to form view?
- Field-level Permissions
- Filter in form not working?
- API code to obtain Acrobat Reader Shell Path from the registry
- ActiveX Control
- SubForm Record Delete Warning (2-times)
- Navigate between open windows? (opinion)
- Datasheet background color, Access97
- Query Help
- Date format hassle, UK vs US formats
- subform update?
- Closing Application After User Reviews
- What Does +IIF Do as Opposed to IIF?
- test for type of data in a string?
- Disappearing Combo Box Values
- Easy for you, new to me
- Arguments against using SHELL for opening Access from VB6
- Record corruption problems
- Get Microsoft Exchange Server Name
- Validation Rule on Table Field vs Form Control
- Get Value from Previous Record for this record
- Date manipulations
- AutoComplete - Advice before I start
- Strike-Out Text
- Ranking numbers
- RegExp Help Needed "Type Mismatch"
- INSERT INTO using memo fields
- Can't seem to use FileSystemObject
- Hebrew Access
- Followup to design question
- running out of resources
- Is there a way to print control attributes?
- ODBC Password?
- Access 2007 and Print Relationships
- Find size of database?
- Find size of database?
- Text box highlight
- Multi-User QueryDef?
- Easy for you, Difficult for me: Help a school
- Autogenerating Keys with Prefix Characters
- What combination of key strokes/presses will unconditionally shut down A97 w/o warning?
- Checking Values between two tables
- Completely blank a screen for 2 seconds from VBA? VB?
- Parameter query in VBA
- .PDF printing to specific printer
- ETL (Extract/Transformation/Loading) Tools for Excel to Access
- Access 97 crash
- subform problem
- Basic Subform Question - Pulling Up A Price
- Retrieve (Get) SQL Username from SQL Server using VBA code and Access 2003
- can you change to source object on subforms in code
- docmd.OpenReport - problem with Where Clause
- Trouble Trimming Multiple Customer Details
- Database corrupt after FTP (on some computers)
- Two users opening the same Access database (mdb) over the network at the same time, without locking the file
- Error Recovery
- Error Recovery
- Error Recovery
- filling picture on report
- Access an VB.Net
- My Linux Page
- Forms and SQL
- VB In Access
- Setfocus ready for typing?
- get sub proceedure name
- Split the Memo field
- Counting specific char's in a string
- Grouping numbers
- retrieve multivalued field using JDBC?
- How to prevent textbox on report from displaying in scientific notation?
- Conditional Formatting Colors and Code
- Docmd.OpenReport with the use of an external query
- Disable spell-checker in MS Access Run-time
- Next record in one-to-many relationship?
- How to tell if a form is opened as a tab (Access 2007)
- vertical text in label problems
- JOIN query: What happens when you delete a row?
- Populate record with lowest match
- Problem formdesign
- Intercepting error Access error messages
- Sorting in subform not persistent
- Write a log file of a DOS shell?
- Debugger
- Detecting record change on a form
- Conditional Formatting Macro
- Syntax for copying a file from one folder to another?
- Multi user - connection - error
- Subreports within a Report
- Hi Performance across slow LAN using FE/BE - more info & questions
- Convert from SQL Server to MS Access (yes that is not a typo)
- How to split the Memo field
- Auto Populate Based on fields from another table
- Partial matching
- VBA Syntex
- Help on If statment function using a range to input a value in to a text box
- VB issue
- Formatting an elapsed time that more than 24 hour
- Stumped... "Enter parameter value" when closing form with suborm referring to data in parent
- Subreport Question
- displaying record count in a message box
- gpupdate
- Trouble printing report
- SQL HELP
- Hide and unhide columns in a sub-form
- Pasting Dissimilar Records into One Text File
- Converting Text to Date
- Connecting to MS SQL Server
- VB6 applications with Access DB slow
- VB6 applications with Access DB slow
- Exporting data to a .txt file
- FTP server Logon hard code via VBA
- Updating a field in a table
- OLE Object (bound object); extracting
- problem with subform linking
- Passing an Object (VBA Question)
- diagram
- Asp query (SQL Related)
- Select and limit results in one table?
- Building SQL in Visual Basic
- Pasting into multiple fields in table entry
- How do I requery a subform from another subform?
- Requery another subform
- International Database
- Conditional SELECT (IF or CASE)
- Disable the Continuous Form or RecordSelector
- How do you store/manage/present the documentation for your database?
- Help required!
- How to use a DLL in MS-Access VBA
- Keeping track of changes in VBA Classes
- Search for an existing record
- Customer Lookup
- Archiving files
- Access 97 and Vista
- list 4 tasks
- Problem with CONVERT function
- Design Question
- Slow code execution in Access 2007
- small lay-out problem
- ClickEvent Function Problem
- Determine if New or Repeat Client
- YTD Report for clients
- Output the results of a query to Excel
- ask for parameter ?
- Form Lookup
- Is it possible to make the MDB non-readable after a certain period?
- Restaurant Database
- Restaurant Database
- Reports are based on????
- "Open File - Security Warning"
- Europe Tests Established Chemicals on Millions of Animals
- LookupTable with Referential Integrity and Cascaded Updates
- I'M LOCKED OUT OF MY DATABASE
- type ahead or typeahead buffer on 2003 upgrade
- Design-rehaul advice needed from experienced developers
- Button info not showing
- Access 2000 Security Warning
- Listbox ListCount with RecordSet
- Are there known issues with Vista and Acc2003
- The Microsoft Jet database engine stopped the process
- Client Monthly % and YTD
- Insufficient permissions to use back-end mdb object
- Client's Monthly Revenue and %
- Client's Monthly Revenue and %
- Access 2003 Edit Record Form (record selection)
- Continuous Form Update (Access 2000)
- Monthly Calendar view as report
- Open Access from VB6 program
- Queries and Parameters
- ms access / two-sides printing business cards
- Access / Microsoft SQL Server (MSDE) / Oracle 10g XE
- Syntax error
- Forms
- Access 2003 Open Exclusive Error
- Counting multiple columns
- VBA doesn't like this...
- What's the syntax for this SQL statement
- IIf to change the row source table
- Help? can't create active componet! Error????
- Draw Ellipse in Access Image Control
- Procedure in Access
- Query
- Create Excel Pivot Table from Access module
- Strange behavior: Colum disappears in label report
- Referencing to form's field value in query
- Add Jajah to Access database program
- A97 + Vista - need "permanent" admin privilege
- Center memo field vertically
- Tab Control and Dynamic subForm Linking
- Access very slow
- Start Job, Finish Job times...
- Access 2007 templates not working
- Conventional Tab Control Use.
- export a pivot graph from web data acess page
- Validation If Null and Empty String
- DB for Web
- Sudden issues with a Access 97 database
- Basic Invoicing Form Question
- vb to create right join
- Access Database
- Access Database
- Count number of lines in a text box for a report
- formatting text nothing seems to fix errors LOL
- Selective deletion - delete records based on dates
- Group Numbers
- Family Database ?
- How to replace empty cells in Access by NaN or -99
- Making a SubForm Modal when it has Focus
- How certain is a repair?
- Alter Column command
- Credit card processing possible with Access 2003?
- if statements??
- test
- What am I doing wrong?
- selecting data only once to avoid duplicating
- Sub Passing Variables to Query
- Export ADO or DAO recordset to CSV file
- Hyperlinking within a Database
- crosstab query and main table
- General question about Access
- How To Change Mhz In CDMA phone
- How To Change Mhz In CDMA phone
- Suppress the "Loading Image" dialog when opening a report
- Task Manager 2007 crashes Word/Excel 2003 reports?
- Task Manager 2007 crashes Word/Excel 2003 reports
- NoData for forms
- Getting started with filters.
- filtering out "#Error"
- Trees? Subprojects? Threads? Or How do I sort multiple levels of nested relations?
- Creating a System DNS on the fly
- Updating a field's value based on another field
- Unification Tables un a Data Base Table
- Losing Focus
- ???Field name concatenation???
- Capture Mouse Button States and Coordinates in custom function More options
- MS-Access 2003 Back End Maximum Users
- MS-Access 2003 Back End Maximum Users
- FileDateTime
- MS-Access 2003 Back End Maximum Users
- Dynamic Query or Dynamic Right Join
- DAO to ADODB Listbox conversion. Upsizing to SQL
- Can't open mailsession... No *real* solution ??
- activating another access application
- Problem with Shell32 and filehandle
- Array of bytes
- form help please
- Access Drawing Rectangles in Excel
- DAO version
- strange issue...
- database access error
- Custom Context Sensitive Menus within MS Access
- access 97 in vista
- Acces report to excel
- 2000 and 2003 on the same machine
- 2000 and 2003 on the same machine
- Search Number Two
- Built In Search Dialog...
- INNER JOIN argument doubled?
- Update Date
- Adding up hours and minutes problem
- Can't trap error in called routine
- Access 2007 Ribbon - Delete Home and Help
- dificult
- Using Winapi
- Subform Record Problem
- programming colorcode in forms