View Full Version : access answers
- 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
- Put four queries into one
- Using combo-box as a user filter - trying to use format to display text "all" for null values
- Effects on RST in Calling Proc
- How to influence two tables with one form
- Access 2000 date range using today's date
- Build comma-delimited list from table
- Outlook mailitem
- Evaluating Complex Recordset Field Statements
- Compute Name , Is it a good idea to use it for copy protection?
- Predifined text and starting from the last record(in a form)
- Does ACCESS have the MINUS keyword
- Form_Dirty is not firing
- Parameter Query and Date calculations....
- Slow Update Queries
- Check box controls subform control source formula
- Subform not allowing creation of new record
- user permission
- MS Access Database with Remote Desktop - Multiple
- Error trapping code
- A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
- converting ACCESS to Stata using Stat/Transfer
- dirDataCopy error message when converting to Access 2000
- Comverting Dates
- Left Join Not Supported - translated from legal SQL statement
- Tables Queries Criteria oh my!
- Transferspreadsheet File Name Limit
- Tree view adding duplcate keys
- Is it possible to open an Access Macro as a recordset in VBA code
- VBA to Word problem
- Running code in one form from another
- Duplicate query recordset
- Lock Down Titlebar in Form
- Keywords
- Access 97, XP and 3170 Couldn't find installable ISAM
- Full menus
- Trouble working with not between
- mail merge
- mail merge
- mail merge
- Importing Excel Spreadsheets Into Access 97
- Date format cannot be controlled
- Date format cannot be controlled
- Problem with inner join
- Set and restore permissions using VB?
- Calculating the dwell time between two Records
- Control format property in OnFormat event
- Can A2k co-exist on a Machine Running A2k3
- edit word document
- How do I refer to a series on an MSgraph in access?
- Concatenating text fields with a WHERE condition
- Anyone use Visual Studio Office Dev Extensions?
- How to open default email program when I store some email addr. in a field?
- hiding record navigation button in forms
- raport and null problem
- IIf Function based on field value of continuous form
- TransferText
- Drawing objects in Access 2003 - can it be done on forms?
- delete all text starting with ..
- Help with counting occurances of similar text
- Before Update
- Help with an SQL query (opposite to a union query - if it exists)
- File Not Found error when importing forms from another database
- Adding Incremental Records
- Date Conversion
- running an update query from form...can I just use the sql cmd
- subform question
- backend corrupt
- Handling Apostrophes
- can someone tell me what I am missing with strings
- Need check box to change formula used in subform source
- Combining two queries
- Display one to many records in a mail merge
- I used to see a menu item/short cut menu to translate macros to code
- locking down tables
- Blank Form
- Adding a column in report
- Help with simple database concept
- Open the Outlook Addressbook in VBA
- Exporting To XML File
- AppHelpFile key and context-sensitive help
- Tab Form and 'cannot open more tables error'
- Report in Table Format?
- Help with VBA syntax please
- New Access / SourceSafe Bug Discovered
- Query Corrupted? - Access 2002
- Need help writing a double click event procedure
- Attaching Document
- Memo field not large enough
- Creating ODBC Data Source automatically?
- how to check list box
- Need help parsing a string - reverse Val?
- Check box changes formula used in subform
- how to open code builder for default when click on event builder in forms
- Export Query To XML
- Form colors in Access XP look goofy when converting
- Importing Excel
- Displaying and modifying 1:N data in forms?
- How to delete the missing References for VBA
- Some fields of a table are not visible in the design view
- Accessing a Report properties without opening it
- Option Button bug?
- Control Reference
- Aggregate function error
- Arvin Meyer's Good Article For Beginners
- Elookup vs Dlookup, Error 3048
- ComboBox using SQL code
- Migration to Postgres
- Front end grows when saving
- Cannot Delete access file
- [ODBC] How to compact a base ?
- continuous form buttons with different images (from table)
- Pr4int Preview Vs Print
- Help? Subdatasheet bug 'You can't hide a control that has the focus'
- How much to charge
- Missing references in VBA code
- Missing references in VBA code
- the form jump after a AfterUpdate Event
- How can I disable a reference library with VBA code
- We aim to please
- How do i hide a group footer if it's the only group?
- Database as Variable for Param query
- Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
- Protect MS ACCESS DATABASE
- Trim/Remove Unwanted Spacing In Text
- Linking to an external library with VBA code
- How can I concat the name of a control in a way that I can refer to it in code?
- Read Outlook emails using Access
- Anyone wrote VBA for calc'ing determinant of 3x3 matrix?
- Combo Box Display Problem
- posting 20050827
- repost calling a subform from another form(not main form)
- calling a subform from another form(not main form)
- How do you boot connected users from your database ?
- Repost : Reading a Text File
- Wont find infomation from table
- Verify Jet SP
- Sort Is Not Working
- PDF
- Requery
- Queries/joins with more than 2 tables
- generating sequencial numbers
- Concatenate text fields in query
- ER diagramming wish list: send a request to Microsoft
- Microsoft Scripting Runtime
- Problem with my chart in MS Access 2002 using a form and VB
- opening and closing IE
- Combo-box not displaying all entries
- Weird parameter prompt appearing after creating a subreport
- how to print (or not) the contents of a textbox in a report
- Embedded Pictures
- record lookup
- postcode finder, lookup,search
- Disk or network error
- Current concensus on using WSH libraries from Access
- Text too large to be in a field
- How to move to item in ListBox?
- permissions to import after a new workgroup file?
- making and refreshing local lookup table
- How to increase the response time by working with linked tables
- RE-linking to back end
- Annotated Calendar
- Microsoft Scripting Runtime Reference
- Ownership ?
- Conversion Map for Field Type and Field Format
- How to automate this import
- Need Help Checking Values in one table against two min max values in another
- Generate String and output to textbox in report
- Returning a number from a hex value.
- Reference Error: Difference between UK office and US office?
- Change f-e links to replica?
- Strange Problem doing DOS Dir Command in VBA Help Please
- checking input in inputbox
- DLookup Problem
- Access 2000-repeating data for labels based on # in a table
- Tossing someone off of the internet.
- Macros and fields in a table
- Does the physical path of a library matter as long as it's registered?
- problem with a LIKE query
- Group BY - Maximum Fields
- How to sort an array of string
- Finding an Installable ISAM
- Any known issues with UTF8 and UCS2 unicode???
- Setting Updatable Property of QueryDef to False
- Conditional display of records based on user's multiple selections
- Calculated total on subform will not display on main form
- Displaying (scrolling to) a specific record in a continuous form with VBA
- Access 2k/2003: Touble with delete query using WHERE EXISTS
- Updating records in a related table
- 'VB in Access' and SQL: Library Management
- 'VB in Access' and SQL: Library Management
- copy comment from access-table
- NULL data increases table size
- A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET
- ARGH! Type Mismatch on Set Recordset
- MDI background color (detail) - XP
- Accounting
- Dumping query result into Excel spreadsheet
- Why this 2467 error?
- How to test the contents of a field or control?
- field is wiped out without warning
- No underlying data to support subform
- Is there an easy way to enlarge an Access report ?
- No underlying subform data to go by
- Extracting format info from database
- Form design for staff schedules that vary..
- ListBox displays values, identical ComboBox does not
- Picture
- Problem programaticaly importing tab delimeted xls file
- Change default table colors
- Change default table colors
- Form/Subform
- Problem turning off action messages in runtime - append query not working
- Assigning Values to Imported Data
- A2K - how to extend default cursor position to ALL textboxes?
- Bypass entering password to ODBC data sources
- Not returning Memo field
- .mde on different Office versions
- ActiveX demos
- Enter Key Behaviour
- dbo qualified name error in Access 2003
- Consensus on using PDA software with Access
- How to limit records displayed in ListBox?
- Who is in my database?
- How to tell if a form is open?
- Registering MPE with Access 2003
- Open Form when DB starts
- Acess developer researching non-Access web based database
- IsNothing() IsEmpty() : Why i can not find it in Access 2003 Visual Basic For Application?
- Problem with AutoExpand - Still Need Help
- API to Access Active Directory Organizational Unit Membership
- Change icon in task bar - Please help!
- Criteria For Subform Combobox Rowsource
- matching with duplicate references
- 60 GB IPOD deal found
- Toolbox
- Prevent Custom Menu From Appearing
- Verify Existence of Field Names before Opening Form
- "VBA project is corrupted", Access2003--Access2002
- Disabling menu option
- Recordset problem due to corruption?
- Can corruption cause this?
- Exporting data to excel via macros
- Error sending email
- Opening a file
- Extract information from various web sites
- FORM function no longer work after upgrade from 97 to 2003
- Code Issues
- Trivial query?
- UPDATE query results not written to database
- determining dimensions of image in a layer
- Access to CSV translation/Conversion Programmer needed...
- Mailmerge via Automation in Access.
- ADODB Connection String with password
- Create Custom Expression Builder / Calculation Engine
- Populating fields from a separate table
- UPDATE query not happy with date fields
- Adding Appointment to Outlook Public Folder
- Simple Running Tally
- Letter Search for field
- Keeping total of items entered
- Assigning an access key to a command
- How can I remove hard returns (CR + LF) in a memo field string?
- 'Data type mismatch error' using Mid function in a query
- Concurso
- add record for each text box entry
- Problem w/AutoExpand in Combobox
- Assigning Values to Imported Data
- Display image on form via network path.....
- Pass through query to stored procedure
- adding records to table from text box values
- running Access Read Only
- Auto FE updater - Wkrgrp problem.
- Subform creates duplicate records in Main Form
- Filter a form on a field in a subform two levels deep
- Toolbar launch of the Print Dialog
- Strip File Name & Folder Name from path.....
- How to use DAO 3.6 DLL
- AccHelp future development - discussion please
- SendObject & Thunderbird
- Accessing a DB on a file server through ASP on the Web Server