View Full Version : access answers
- Unduplicated count of a table
- Cash register Access database
- forum
- PT Tables
- csv file line length limit
- Ask before saving record
- Appending from 2 multiselect listboxes
- Using a button to populate another form's auto# field.
- Record Selector Macros
- Regarding input masks
- Form Should open Maximize
- Access Validation Rule Question. Help Greatly Appreciated.
- Access and word mail merge
- UI Metaphors for complex criteria selection
- txt to mdb
- Open form as Data Entry with Customer Info
- Linking Relationship tables problem
- Damaged File/Print... menu option
- How can I input a name into a reprort
- How to have field values transported to fields in another form?
- Access using .Net Datagrid
- Encrypted password field in Access database
- Encrypted password field in Access database
- Help!
- Access Run Time Error 6 Overflow
- IIF acting funny
- ODEUNST.EXE???
- Is it difficult for a hidden form to check for user activity every 15-seconds or so?
- A-97 Alzheimer moment... what were the basic components of securing an app?
- Can not open database file
- Update Query with User-defined function?
- Query base on a changing table
- Sendin emails through Microsoft Access
- Copying a value from subform to main form
- Bang vs. Dot - final answer
- Output To vs. Transfer Text Options
- Reading and Writing Folder Properties
- Question on Error Message
- Access to ASP
- Will Stephan Lebans answer questions about his Calendar 'control'?
- How to copy a value from one form to another by button?
- Open a different Word doc for each record?
- How to join 2 different database files?
- Quick, simple question with Access Database Form
- Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
- running vba code in a loop
- Time Picker Control
- A2K networked DB "already opened exclusively by another user"
- Access12
- Strange Time-Formating Problem
- access and sql server via odbc
- A2K Subreport disappears in Access XP
- OT NNTP in VB
- How to Remove <BR> in Fields
- Strange Email Problem
- RAM USAGE
- What does this query do?
- Looping A Specified Number Of Times
- distinct records
- Subform with Query
- visible flag: datasheet versus form view
- sorting a crosstab query
- Changing to owners permissions using VB
- Subquery Sum by Date Range
- Making a button appear pressed in?
- AUTOMATE EMAIL ADDRESS IN ACCESS?
- adding empty rows to the end of a report
- reference subroutine from another form
- Modify Access MDB Application
- double prompt for value in report
- Over the years, I've used query wizard to list duplicate entries...
- Macro security level
- Macro Data Entry in a multi-row Subform
- linking subform master/child fields problem
- Problem linking Child/Master fields correctly
- Run-time error 2465
- Read Only
- Use other value from table
- Filtering report and subreport from form
- Field type corruption?
- Can a multi user Access db be used via Terminal Services?
- Default Fonts
- Creating sample data & MDB file size?
- Error 430, CopyFromRecordset with DAO 3.6
- Slightly O.T. - seeking documentation of the microsoft user interface specification
- Linking form - Report
- Query criteria - limiting the records - question
- Sequential numbering of a record collection
- code doesn't work on some PC's; does on others
- GROUP BY problem in access
- circular dependency between subforms, problem cased by subform loading order
- Continuous Form: Changing .BackColor depending on value?
- validation rules
- mde
- Using wildcards in Crosstab Queries
- Overdue warnings in Access
- Can a control on a Datasheet have a scrollbar?
- Error msg when adding a new record to a subform
- Removinc and installing A97
- Pages In Subform
- adding Record autonumber problem
- OLAP Server Problem
- OLAP Server Problem
- Exporting From Access to a Dbase iV. via Object. Fails with error The Microsoft Jet Database engine could not find the object
- Number of users opened MS-Access.
- Consecutive Invoice Review
- Help on report..
- Mail Merge to an existing document
- Tough SQL objective - pulling data from 4 different tables
- field in subform
- Why do IT guys hate MS Access?
- Help wanted - how to merge two tables with different information.
- Programatically Populate New Database With Tables
- Missing Parameters in report
- MouseWheel event does not trigger
- Appending? Creating? Help!
- error 3021 no current record, only sometimes
- assigning a listview control to a listview object
- Insert Object- Scanner recognition
- Slightly O.T. - need a printer I can use on a specialty database app
- Field Totals
- Weird combobox error in subform
- Conditionally select fields in SQL statement. Possible?
- Error at last record in form while displaying count
- Saving datasheet layout in .mde
- Find the faq
- How to enumerate every record in the subform?
- Simple listbox question
- Convert string expression to value?
- fatal error trying to close form from subform via code
- fatal error trying to close form from subform via code
- Custom Error Message Fails to Work
- How to do a Transfer Text Batch Group
- Greenwich Mean Time (GMT) in Microsoft Access 2003
- Looping through forms then the controls.
- Referencing an object description in VB
- lost page tab
- Programmatically Import Toolbar
- Access 2003 Possible Corruption?
- Recordset problem
- Runtime Report Editing
- crostab query
- Summing Queries?
- Yes No field on form and query
- tab control record/ data exchange
- Scrolling back records on a data entry form...
- Report footer
- Data Transformation among Microsoft Products
- Rant
- Automatically add new records
- Automatically add new records
- Add a cell formula in Excel via vba from access
- Autonumber
- Report size
- Add rows to top of existing spreadsheet
- Relationships decision to be made...
- How do I find the MSAccess.exe file path??
- Read dBase IV
- Looking for matches, adding to match table
- Form/New Record
- XY (Scatter) Chart
- notepad file to ms-access compatible file
- Multiplication formula
- OLAP Problems in Windows Environment
- Code for controling FTP from Access VBA
- How can I interact with MS Access using a programming language like Perl?
- Help with parameterized queries
- Reading Global Address List in Outlook (CDO)
- submitted data not updated promptly with ms access
- I need help w/ Queries
- Date Query?
- Login in form text fields are filled out..
- Printer properties
- SubReport on Main Report Page Footer - Didnt think it would be so hard.
- Hide Duplicates flag?
- Access / ASP hacked insert
- Select query that won't run as Update query?
- Can A97 Be Installed On A WinXP Machine?
- How to work on home laptop, then update client's Front End?
- Comparing one date against a list of dates
- CutePDF. Pass file location?
- RegisterDatabase for AS400
- Open source "Tanning Salon" Application
- filtering the last date
- Using an SQL statement to convert date format where the field is NULL???
- Listbox: Use SQL + constant text string to assign values
- Total Access Analyzer?
- splitting text into characters ... HELP ME SPLIT
- Looping Query Defs
- Problema per creazione Rubrica...Help me!
- almost got the mail merge to work one problem
- Thanks for help today - new problem with recordset
- no read permission
- Run-time error '424': Object required - can't work out why
- Select multiple date fields from one table
- Picture on page
- IsNull() - I can't get it to work properly..
- The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
- A97 SQL capable of showing data from 2 different table records in a SINGLE output record in dynaset?
- Dynamic Crosstab Report Problem
- Change Caption Of Label In External Database
- Changing table permissions in VB Code?
- Using a picture (Form Template) as background in a report?
- A97 query question
- Snapshot viewer and Access 97 reports And Emailing
- Database Permission Question
- Text Box and 255 character limit
- The .Value of a Check Box
- Removing Items from a Listbox with Multi-Select enabled
- Adding Excel Object Library Reference Programmatically
- UI: Combo Box Max Records Recommendations?
- Update Query
- Creating self-join table
- disabled startup
- Globals and system instability
- Random Number in Query?
- report page layout help
- autonummering in table gives problems
- Autonumbers: Retrieve unused no's
- how to skip runtime error
- Printer Orientation and PrtDevMode MSDN example not working
- ORDER BY a SubSelect?
- Database creates another file when first opened? What causes this?
- help with update table
- Access 12 screenshot (my style)
- Relationship Link
- Run-Time error 3146
- DoCmd.RunCommand Equivalent for acFormBar, 7, 6, 0, acMenuVer70
- Using Vendor ActiveX Grid in MSAccess
- Set myTableDef = myDB.TableDefs(myTable) is so slow ....
- is stupid
- richtextbox loadfile problem
- Public variables reset on error, what's up?
- Find Primery Key
- Linked images don't refresh
- Pivot-Table Form vs MS Graph?
- Access Database through ASP
- Run-time error..
- Type mismatch error
- Compact a password protected MDB from a front end MDE
- Find and Replace special characters in a field
- How to stop an Access form from automatically saving a record?
- Formal Complaint
- Need a little guidance (beginner)
- Rename Table/subform Field Names
- OLE OBject Source Doc
- Linking table/query SQL
- Access Report
- How to check the status of a sub form
- Check on empty record set in VBA
- How to Lock the Page Setup in reports
- Display One-To-Many records in a Mail Merge
- Enter control
- Conversion to SQL Server backend
- Open images after double clicking them on form
- Custom table property to prevent overwrite?
- Moving a text box in a report at runtime
- Rotating label text in A97? Is it possible?
- error message 3343
- How do I write code to allow user of a runtime distro to select a DEFAULT printer?
- Input Parameter Query Window - Duplicated?
- problems compiling with Listview control
- Unable to create new records on linked tables over network
- Mail Merge Access 97 and Word
- Sum Subform Records in Mainform contol
- How to break out of loop from error handler?
- Sorting report by Quater
- Update Table
- Expression error
- Need Church database for small church
- Select top on 2 tables based on date?
- update, append query Joins being deleted.
- Unable to make form visible again
- export temp table to text file user side
- Users being locked out, unable to open file
- Application.Version
- Access 12 screenshot
- Help with DLookup
- DLookup return date from database
- CreateReport(, templateName) not coping report properly
- How do I restrict my results?
- Body for e-mail
- Reconcile Query Wizard Add-In For Access 1.2
- SQL Help (Please)
- Playing Sound Clip
- comp.databases.ms-access
- Strange behaviour on startup when project is signed
- Open a 2nd form from a 1st form and keep the same rs and current record
- database worksheets?
- Access help!
- USING DLOOKUP TABLES
- RECORD LOCKS
- UPPER CASE
- csv export file and international settings
- Query With Many Checkboxes
- Need to send a directive to linked database
- Like Clause
- rolling average
- Access on the Net ?
- What Access Runtime files are needed to deploy? (2002/XP)
- Please help: How to concatenate fields in querie??
- Columns
- Hoogste waar de in een kolom
- Problems with HTML Imports
- MyControl.text in form without record
- How do I disable automatic save of my project as I build my database in access?
- lost mdb
- Sorry ....Using Access 2002 object lib. in Access 2000...
- Using the 2002 Access Lib. in Access 2003 .....
- Table Index Construction
- An NT Security Gotcha that looks like a Jet Security issue
- Requery a subform from a lbo - how?
- Help with validation feature`
- Function to return quoted value?
- Postcodes
- Using data from one Access database in another
- security: user level vs. group level
- A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field
- Does not import all data?
- PDC2005: Anything new for access?
- ldb file and Exclusive Access question
- Condition Format in Multiline Textbox
- Multiple Date Ranges in a Report
- Check to see if a button has been clicked on a form
- Union Query and Filter By Form, Access crash
- Remove dash from soc sce #
- Finding a specific record
- public variables
- No Current Record
- SQL multiple statements?
- Access not working (can't query or create report)
- Help with Report Design
- MSAccess query error
- A97 - 5 records in a recordsource query cause 5 pages to print out
- A97 question regarding closing a report
- docmd.openform where condition problems
- Changing a Label Caption in a report
- Conditional Format With VBA
- Keeping empty subreport visible
- Very basic problem
- math problem with dates.....
- Exploring use of Dir("\testdir\nul")
- Looking for users of a niche product
- modified snaking columns
- ODBC--call failed
- Access Runtime/Access Full Version
- How to transfer *.dbf (many files)
- listbox in endless form
- Manually changing a linked table location
- How can I set value in function that returns array?
- How to remove last digit for inputted value?
- Appending records to a table from a form filtered recordsource
- Using Code
- report errors
- report error
- report error problem
- report error problem
- Print Tree View
- Help Needed With Corruption Problem
- Using Unbound Textbox as parameter
- Font Size in Query SQL View?
- A2002: Activate Event
- Security settings for downloaded databases
- Hyperlink
- Issue with Make-table query - Will this HURT?
- Autonumber Oddity
- Synchronize SQL Server with Access MDB?
- Help with filter
- Converting positive number to negative number
- I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
- concatenate two records in same table
- concatenate two records in same table
- Problems with Date conversion from text format into date/time...
- How to remove Lookup property from table field with VBA?
- shorten time to attempt to connect to back end
- OnNoData
- UCase not working in A97 runtime installation...
- 2 questions
- Linking Images using VBA code
- Conflict with Webroot's Spy Sweeper
- Intermittent missing reference problem
- Decimal places.
- Credit card number rounding?
- Output Stored Procedures as text problem
- Unable to set subdatasheet to None
- Error "You don't have the license required to use this ActiveX control"
- problems dealing with dates in my queries/SQL code
- Partial Replication of Data
- Access 97 and counting the occurrences in a string
- Reports opening differently on client/my machine
- Email reports?
- Searching a Field containing OLE Objects Returns Inconsistent Results?
- Adding to lookup list automatically
- Help with error message
- SQL - JOIN or nested query?
- Refer to class-properties (A97)
- Linked tables in a query giving no results
- Linked tables in a query giving no results
- Managing controls on subform
- How to unhide a specific form or database window in A97?
- A97 closes down each time I open a particular report. Anyone know the meaning of this?
- Access Developer's Handbook 2002: Tagged Values
- Problems migrating to XP
- Looking for a copy of ODE97
- Update foreign key before appending records to central database
- ONLY NUMBERS
- How to read .iif file of Quickbooks using vb or any code
- Themed Tab Control work-around
- combo boxes
- default value taken from other filed
- How to read .iif file of Quickbooks using vb or any code
- no data on a form
- SIMPLIFYING WORDS IN A TABLE
- Multiple Record Copy Transaction...
- time attandance system
- Embedded Images
- Concatenate 3 lines of text into a "Paragraph"
- Stored Procedures?
- VBA functions to create a PDF rectangle with a shadow
- Problem with form
- Help for C# Interview questions and career decision
- joining queries
- Code for finding name of relationships
- How to programmatically determinae the field name referenced by query param?
- Automatic backup's Access 2003 database
- Change a lot of words in a table
- DCount.
- A97 error #3067 occurs when it really should not
- How to fill a for automaticly(just some boxes)
- I need a personal code library
- Null Values or Wierd Behavior based on a user's profile
- Form for 2 tables
- Alternative to lookups in tables - questions
- Transactions for linked SQL Server Tables?
- Saving ODBC SQL database to "local" mdb?
- Include word doc(s) in report
- Data Access Page problem
- problem - open recordset - ADO
- question about % in reports
- DAO 3.51 and DAO 3.6
- Access Treeview - Is it Safe Yet?
- MDAC
- How to use parameterized query with DAO Recordset?
- Change Focus triggers Before Update
- PostCode-Zipcode
- compare tables
- Linked Tables, access security help.
- "Too many Fields" error running query with <255 fields
- Use not local admin Outlook Fails
- ie 6.0 and Access2k
- Understanding ODBC connections...!
- Using nested subform
- Linking Tables in Access
- A97 - How to automatically export a table to ms excel data-file from within code?
- Invisible Query Head-Scratcher
- numeri
- Upsizing
- How to supress message when dynamically setting Report recordsource
- Problem deleting ldb file
- Foreign Key with multiple columns and null value
- exporting access data to excel for calculations and reporting
- Unlock/edit a database...
- Like criteria
- requery a subform on a form
- Generating an Index
- How to get a query to pick up the value of the active form
- A2003 Backend opens in read-only intermittently
- &Relationships Bug - workaround
- How to set Startup Properties in MDE?
- In trouble! Db locked with exclusive access
- How to put controls on a form with VBA code
- If a field is keyed in, then delete other fields
- setting fields based on values of other fields
- Table Structure - Using Query with Form for Input
- compare two tables using this module?
- Ordering fields in query based on current date
- How to send emails from ms access..
- Modems and Access2003
- How to parse CITY ST ZIP+/-4
- Allowbypasskey property
- Append to master replication table
- Open a DB from the switchboard of another DB
- Only add Valid Payments on a Report.
- Calculate Number of Years, Months and Days between 2 dates
- Oracle 9.2 attached table real slow and data incorrect with Access 2003 SP1
- Lock an access db
- Printer / Report issue with Office XP over Network
- Can't Import a .dbf File
- Default combo box line
- Setting field properties in code
- REPOST: Unique connection ID not name.
- Creating new field in code
- Using combo boxes to fill in other bound controls not working..
- restoring default printer
- Trouble moving Access tables to SQL back End
- Enter Parameter Value showing up when already defined
- Assign textbox value from command button
- How do I refresh a control
- How to handle with "&" in text
- A97: MediaPlayer.MediaPlayer.1 control on a form - how do I use it to play a .wav file
- A97 - I've been looking for a position counter to display on a form the current character position of cursor
- Payroll DB
- Won't let me remove tables
- A97 overflow error returned when trying to calculate 192/(24*60*60) - why?
- A97 - how to format time lapse to appear as "4-minutes 12-seconds"?
- combo box choices
- How to speed up reading input from a text file?
- Split master table into smaller tables
- DoCmd.SendObject acSendNoObject Inserting Hyperlink in message containing a space.
- Need help to read database contents - very tricky
- How to Update ignoring validation rule
- A97 variable length string declaration - how to do?
- check box changes subform operation
- acCmdInsertHyperlink defaults "Browse for" File
- Catastrophic noob... can anyone help?
- ComboBox source query: run at Form_Open
- Access hanging periodically
- How to display multiple pictures per record in an Access database?
- Cancel Click Of Check Box
- 'Invalid bookmark' or 'database engine stopped the process' errorswithout corruption?
- Unique connection name?
- Mixing two Image samples by Lebans
- Access and vba in excel
- FE & BE Version Control Tips?
- Determinaition of Paramatric Queries
- using query results to populate a list or form
- Combo Box - NotInList Event - need help
- How do I link a control to the value in a form?
- Help needed w/Crosstab Query and Col Values
- Finding the current computer name in VB?
- AddItem not adding columns to listbox
- How to compute age in a query?
- Simple question about Cancel Event
- Accessing list of files from disk
- MDE Don't work
- Preparing for .NET Interviews
- How can I run an insert query on report
- Second Request - Can I return a value from an ACCESS report to VB?
- OpenRecordset & 3027 read only error
- Set a variable equal to the result of an sql query
- Question about moving Access app to web
- format for naming recordset field
- Display a report in a form...
- Determine if user has local admin rights in VBA
- Please Please Help!
- Find how many similar records..
- File already in use
- Problems Subclassing in Donors/Donations DB
- How to use static variable to exit function?
- How can an AutoNumber field start at some other value