View Full Version : access answers
- Running database on differing OS machines
- distributing access database files
- ? Affecter une priorité à un contrôle d'access
- fastest way to call a function
- ?? TRANSFERDATABASE COMMAND
- dsum issue
- Print report/subreports based on each date in range
- What to delete new record started on Continuous Form
- Reformatting data into logical records
- 20 million records: Too many for an MS Access app?
- DateDiff Error
- Rolling Rates of Return: Data Structure?
- setstartupproperties doesn't work for xp mdb
- AccessCode must wait until excel closes. HOW?
- Need help formatting page footer please
- Applyfilter or form bound to query??
- Subform H*LL
- listing data in columns dependent on letter of alphabet
- listing data in columns dependent on letter of alphabet
- MS Excel IF Statement w/pictures??
- calculating time II
- Calculated field in subform
- Show database window from VBA
- Array element appears to lose value (Access 2002, XP SP2)
- MS Access Report
- Which Courses students have not taken query
- VBA control of field value match with excel value in cell
- On Format headache
- genealogy database
- Microsoft VBScript runtime error '800a01a8'
- VBCode Help for Beginner
- Can I display all the records of a DAO.Recordset in continuous forms textboxes?
- Putting Columns on a report
- Bank reconciliation
- How do I do a print preview using Access Automation in VB? Print works fine.
- Deploying Access 2003 runtime
- Expression Builder
- Important Access Client/Server tip
- Database size - problem
- Will Access 2002 Save As Access 97 ??
- Option Group Button Help
- Help with Form position after report preview
- multilevel hierarchy query
- Access Data Projects Uniqueidentifier problem
- Best way to make Access 2.0 code wait 10 seconds before processing the next line???
- Moving from one form to another and then back
- Report Total Line: Summing just two rows?
- Emailing from a form
- vba sql query passing to report
- Open file (from url)
- VBA code help Export Excel data to Access table
- Error 3048 Cant Open any more databases
- Error 3048: Can't Open any more databases
- Another Dlookup problem
- Database distant access
- Combo box query report
- Making Access work faster
- database tables and relationships
- Version issues
- Add data from a form into a table!
- How to save a record
- Q on weird subform skip behaviour
- How to ensure that on a continous form of 12 row only 1 tick box is checked??
- How to ensure that on a continous form of 12 row only 1 tick box is checked??
- Compact the database problem
- Changing Window States of Reports/Forms
- Difficult Graph Needed
- Integrating Crystal Reports into Access97 form
- Exam type questions
- Help With Query
- Record limitation when using Data Access Pages
- Finding the last record -10
- Record limitation when using Data Access Pages
- RowSource Issue
- Access: How to disable importing tables from my database to other
- Missing Pair Fields WHAT?
- Open a corrupt Access 97 db
- How to convert Date to Week #
- Help with Relationships - Query and Table relationship
- How to use a popup form to filter data on a main form?
- Calling C#.net .dll from VBA
- displaying a command button in the detail part of a form.
- Special Labels
- Help with Database Object
- Database Report field
- Database Report field
- Ascending number in query
- a2k - how to code a simple version check over the net
- Parameter in query to dropdown list
- Inserting a new Record in sub-table and ensuring valid relationship values
- Help with calculated control on form
- capturing the printing properties of a report of form when sent to a printer
- Downloading of data from access
- Command Buttons
- Reports
- Microsoft Access and Cash Drawer
- TreeView documentation
- Sub Form - Linked Child Field - Linked Master Field
- Multiple users changing the same record
- Design question
- How to round a number by 50s or 100s.
- Why do I always get -1 when I do Recordset.RecordCount
- Key Stroke
- Access Developers edition?
- Asp and access database--Long
- I Have a Query
- Change Text
- How to avoide the "Alert Messages" when using Queries
- ms access
- Excel error at web server
- Excel process doesn't shut down
- Assign value to Excel.Range
- DSum Help
- Public (Global) variables
- Late Binding??
- query design help for book index
- Base DS form on QueryDef?
- Output access to Word merge
- Where can I find the syntex of "formatnumber"
- Tab Caption Goes Away
- Exporting a Report As a Word Document
- Simple function sometimes works ... sometimes doesn't ?
- Code "Auto-Letters" ?
- What event occurs just before a record is written to table?
- Exporting text files without .txt extension
- date issue in .adp file
- OFF TOPIC Frustrated Rant
- Adding new users requires exclusive access to mdw!!
- Complicated Question
- Previous Business Day
- the Find Command Button
- Apply Filter in subform
- Listbox Updating
- Code to fix corrupt table
- Tables Duplicating Themselves with an underline and then a number
- Create IIf Statement for Query
- SendObject in Access2K works sporadically
- Change Textbox Width
- count and group by with OR
- Returning Focus to Main Form
- Automated Screen Print - Possible?
- Union Query Truncates Memo Fields
- Amount of time spent on a record
- How to make the Linked Tables in Access to Share only ONE connection?
- most recent, min/max query
- Remove multiple Chr(13) & Chr(10)
- Access 2002 runtime error for Windows XP
- I cannot figure out this query - I thought it would be simple but...
- How to use different data sources for different sections of a report?
- Using Excel data in query
- Update Query
- OLE Applications for JPG Files
- Using code to copy forms/macros etc
- Saving a set of reports in Word automatically
- Recommended Stretagy for Bi-Direction SQL DB Synchronization
- Using jpeg files as OLE objects Q2
- [ODBC] form linked to odbc tables with "high" number of record
- Problems Converting 97 Query into 2003 format
- Using JPG Files as OLE Objects
- Textbox, web browser control, and Unicode (got cutoff)
- splitted database crashes when adding records to linked table
- updating access 2000 mdb from asp.net Microsoft.Jet.OLEDB.4.0 ???
- Excel protect sheet macro problem
- Access and a VPN
- Access & a VPN
- Access & a VPN
- read only access database
- Reports In Visual Basic and Access
- Access DB Security
- Securing a single table - what are the options?
- My text field Criteria : "N/A" - How to resolve "/"?
- Best way to let users run SQL?
- Access unexectedly shutting down
- Web browser control, Unicode
- Call Function
- Subform Contro; Border
- Exporting Report To MS Word
- Buttons and Listboxes
- Access Books
- How to convert Date to String
- How to convert Date to String
- How to convert Date to String
- Search and Update - Difficult update query
- Hourglass status
- caselle di testo e formato ora
- me.cb.Type?
- Copy file from within Access 2003 project
- Two Lookup Combo Boxes on Same Form
- Microsoft Office Library Reference
- Multiple Field Search
- can't send Email from Access
- Question didnt seem to bump
- Linking table to multiple tables
- reports
- API Gurus - Alpha transparent popup a la Outlook 2002
- Commandbars Controls Collection
- Print Form to Report
- query based on lookup value
- Report performance question
- Multi-level GROUP BY Error 3612
- Problems loading a listbox rowsource from code
- Text box question
- Differences - Syntax & Form operations
- Combos with Tens of Thousands of Records
- Back -end Front-end
- Changing Table Names
- Next "Available" record ?
- Slow Access 2003 in Win XP with network connection
- Pad lines on a report
- Access/Jet Statistics
- Questionnaire in MS Access
- Text Box Issues
- Updating Records on Form through Linked Tables
- Go Back And Forth Between Functions
- MS Access and SQL bigInt
- Change in appearence of google group page
- How to do the Declare for a Delphi DLL
- how to change the owner of a table
- Security Manager Add-in Error
- Settle a disagreement with my boss re SELECT DISTINCT
- Creating a Backup Database
- Setting focus to textbox after clicking on multipage tab
- Comb Boxes within a Sub-form
- How to copy groups and users from old secury file .mdw into a new one?
- Tuning of group reports
- Database back end - SQL Server or Access
- Autoexec question
- Optimization technique
- Using same table for Lookup
- Won't sendObject from access 2000
- Highest Value For Each Person In the Database
- calculation visibility
- Where clause in SQL statement problem
- Can't open linked DB files
- Type conversion problems with Access Import Wizard
- Corruption Manifests In Access 2000 But Not In Access 2003
- OLE Image Problem in A2002
- Return to code section and loop before giving up on an error.
- Return to code section and loop before giving up on an error.
- Query of two tables
- show day (date) quickie
- Reconnect to DB back end - password
- seperate page/document for each record?
- Code problem with rowsource and SQL statement
- SETTING DIFFERENT RECORDSOURCES FOR ONE REPORT
- Please help me get started (Access on the Web)
- Simple question (I hope!!) on .FindFirst
- dynamic popup screen for multiple comments fields
- Help for Xbase to Access -Allen Browne may be
- Report including only days with value > 0
- scurity + form
- Need Loop Help - VBA novice
- Combo Box Problem
- Is it possible to join two queries together
- Retrieve Information about Access Version
- password enbaling form
- Problema con un report
- Filtering out unwanted characters from a mag stripe swipe.
- jet 4.0 error message
- Can't open my database - linked tables
- Change me.sourceobject
- A very specific problem involving duplicates
- Notification
- Query question
- Type mismatch error, SQL and Recordset
- Function used in SQL Select query
- Processor Number
- How to remove the CR character (â–¡)
- Designing Access2003 unbound form in an asp.net-way?
- forms: simple and complex question
- Suggestions needed.
- multi-page, multi-filter access report problem
- Database normalization question
- Database Replication A97 vs A2003
- Access DB Security
- Outlook Emails in Access
- Date formatting so "01/22/2005" becomes "January, 2005"
- Changing, "FindFirst" to using the, "Seek" Method?
- print only some reports?!"
- Application Search and Replace Tools
- Referencing data in a field within another field
- forms --> access
- Need help with merging spreadsheet together
- Import Specs: Still buried in Access 2003?
- Combine (Merge) Data from Two Access Tables
- Linking to a backend using code?
- Adding index marks for Word
- Having trouble setting up transactions
- How do I set a form to automaticly start at new record and not overwrite first record?
- Update sub-form on tab from field
- Qty Problem
- Searching Using Combo Boxes
- Query help : Urgent please
- send Outlook email from different name?
- Controls over image
- Q about creating new form
- blat command line does not work in Shell method
- From the previous question - Search the records by groups based on identical field value
- Help with Acces Runtime 2002
- Locked Record when connecting to SQL Database
- if then else - help please
- Changing and storing the value in a text box without adding row to table
- open & close time of database?
- Multiple Concurrent 'References' to MS Excel?
- Two Tables
- Combo Box question
- Appending records in another database
- recordsets?
- Asp.net caching vs Access Caching.
- ADO and DAO together in same application?
- Create Autonumber & query problem
- Indexing a phone book
- Custom page size in report
- Extended one to many relationship
- Book recommendation for access queries?
- SQL Server 2005 Express Edition Overview
- OLE problem with A2002
- List Box Options Not Appearing
- Blanl Lines
- Displaying both the master and its details as a grid
- A'2003; SourceObject = Query.MyQuery (BUG!) (?)
- WEB Integration of Access Database/System
- Invoking Filter by Form from Code
- IM/EXport specifications automatically creating
- Crashing Subform
- Crashing Form (& Access)
- problem with crosstabs + reports
- Combo box bound column value
- Re-use values of err.number and err.description after a msgbox in the error handler
- Combo box question
- Database security
- How to either programatically reset AutoNumber or simulate autonumber in a temporary table
- Calling a class' private method from a form
- Create a form to run a Union All Querry for specific citeria.
- Upgrade path to MSSQL2000
- QUERY 'ONCLOSE' EVENT?
- Database Design Questions
- Deleting Records Before Packaging Causing Slow Reports
- Run Regedit from Access form
- Dual "Parent-Child" Combo Boxes
- On cancel=true, extra Access-warning?
- RTF2 ActiveX plugin from Stephen Lebans
- DBase Index Files
- Trying to understand primary keys, relationships and such.
- What would cause"Compile error in hidden module"
- Required Fields in a Form
- Parameter Prompt for field, which was deleted from table
- Linking tables to SQL Server 2000 causing strange results
- CALCULATING TIME
- How to check if table exists
- data type mismatch in criteria expression
- Unable to set focus on a text box
- using flash in ms access 97
- Initial Value for Combo Box Text field
- List Box on Datasheet Form
- run beforeupdate from another sub
- Getting rid of Access 2000 LDB files
- Compact an Access database in VB code
- using a remote MySQL Database in MS Access
- DDE - Excel XP
- Access vs Visual Studio dot.net
- Combining data from several fields in a Union Query
- Why function does not work?
- Dev Ashish function not recognized. Need advice quick.
- Comparing input date to current date
- Records across LAN
- ddl for union queries
- Memory usage for reports
- Multiple Sort in a Continuous Form - Similiar to AutoFilter
- How to bypass 'No current record' error
- Detect idle time, shut database down
- Upgrade issues from 97 to 2003 - references? DATE LEFT and FORMAT give compile errors
- Stop Autosave for Forms with Table Recordsource
- Display a numerical query result as a letter
- Strange behavior in a continuous forms subform
- Passing an argument to a subroutine
- subform with unbound forms
- Linux backup - mdbtools detect corruption?
- can't append or edit data in form & query
- One million records a day
- Using access data to fill in pdf forms
- Can i open remote (http) files for input?
- Connection String suddenly Stops working
- Deduplication and Data Cleansing Software
- Surpress dialogbox?
- Check if printer is active
- Thanks!
- Documentation outsourcing a must to reduce your expenses
- outlook data
- create autonumber
- Form check box & report data
- converting data
- Need Help opening a form from a form, using Openargs
- Hidding dbWindow form user in access app
- Set Report Zoom to 90%
- Proxy problem with InetTransferLib
- Pivot Charts SUCK - need help
- Auto Number from a Make table query
- Performance of MSDE over VPN
- Problem Opening Report From Form
- Can DMIN return multiple values
- PopulateCombo Box Row Source with list of files
- Linked table password storing
- Computer bloat question
- conditionally enabling a form control
- replicate Frontend MDB to Backend Database
- Access
- ACC97: Linking tables using two fields in each table
- Question about Access 2002
- Database Issue
- Updateable Query
- Using On Mouse Over OR Mouse Move to display a description
- connection string with database password...
- Backup of an Access Database while Running.
- Use multiple queries to display information on a form
- Access Database on Web Servers
- Access and Excel Pivot Table
- Anyone have experience using CDOSYS?
- Any Idea is welcome
- Reports - position of a control
- Resize(): Reliable way to determine bottom padding?
- Combo Boxes
- Tabcontrol - add records
- auto generate claim no
- create autonumber
- While printer.printing
- More challenges with Returning orders
- I fall down at my knees
- Yes, indeed
- DLL In Different Locations
- before update - validating potential new data?
- import+3query+recursion
- need office xp 2002
- Sorting Where Sort Field Is Null
- Appending data...
- Show Total In Subreport On Main Report
- Properly cased patronymic last names
- Format to say "Required"
- report totals
- file dialog - select a file
- Open Form with a filter value from another form
- Module Compare Add-In?
- Can't manage to get text to be Vertical
- Row Total
- Populate List or Combo Box with file names in a folder
- can't update/change anything in db application
- Last Record
- VBA question
- On Open Event Procedure
- Numeric overflow in [tinyint] field
- Using hours in a date range parameter
- Expressing hours in a query parameter
- On Open Event Procedure
- Telling programatically whether an Office product is installed
- Tab command in access procedure
- This script causes NP Pool to exhaust itself - can't see why - very simple
- MS Access 2000 + Table + Report
- Query Results formatting.
- Testing if an entered value exists
- How to manage Access security
- Help with access code to close a window
- ADO query question - which is faster?
- SendObject Warning in Outlook 2003
- Get stored procedure output value back in VBA
- Trouble with Access 2000 and finding a table's source
- Problem retrieving printer information for this object
- Project time estimation
- Month by month analysys
- Append Query Random Failure
- Direction on a project early on
- Using Mag stripe reader to access records
- Sending selected items from listbox to report
- Format function in SQL
- Help Converting from Treeview 5 to Treeview 6
- Output report to rtf format
- How to open multiple data bases from one GUI
- autonumber->number of key
- Fw: Compare textbox value to record in table
- Date Difference for different records with same GroupId
- Validation rule for number
- Need help with Justification in Access
- Link Table Manager path problems
- Access Scalability - records vs. filesize
- Combine two tabels to one. (Regular time and Overtime)
- MS Access 2003 Runtime Environment
- asp.net datalist display single row
- Query results in needless/extra zeros
- Huge Database Advice
- Huge Database Advice
- Query timeout problems
- Can not open reports in MS Acess 2003
- VBA/ MS Access. Code formating/alignment
- Using a variable to store an jpg
- Automation - Excel & Access
- Creating and using Stored Procedures and Views in Jet
- Make table from code?
- Setting the size of column widths of a combo box through Code and Searching Combo Box
- Doing the unthinkable with my tables
- Subreport title
- Thanks!
- Help with error in trying to email from Access...
- Access97 crashes on Windows 2000 or Win XP
- Compare textbox value to record in table
- EDIT COMMAND
- Pls help
- Saving Access File
- Assistance with Digits To Text Function
- A Form Letter with Access
- Aligning controls in page header and detail line
- A2003 Slow in Shuting Down BE ldb
- Password that changes according to month
- Combo box entries
- Unbound Textbox not printing in Report
- Get file attributes with code
- using lebans rtf2
- Access Paper
- Access Docu?
- How to copy existing table structure to create empty temp table?
- ref:disabled toolbars etc
- New; going from flat to relational
- Visual Studio Tools for Office ?
- Determining whether a Database is corrupt
- Dim X as long ==> What is the value of X???
- Not able to add record
- running a query to find missing names between 2 tables
- Sending selected items from listbox to report
- ListBox question
- Pls help
- How to make composite unique index?
- CHanging the Extension from mdb to whatever
- Coding a switchboard so new forms don't pop open in new windows.
- Cascaded update/delete box unavaible.
- Access Report / Sub report with parameters
- Blank pages in a report
- Text box in access report not displaying currency format
- Securing A Folder On A Server
- Unique OrderId number Help
- MS Access on a LAN
- Can you stuff data into a word doc w/o word?
- Prevent Dups in the code
- Doubleclick in listbox
- Selecting a row in Subform
- UPdate Outlook Calender
- Call for help to Scouting members
- Linked Files
- How can error messages be displayed when using Command Buttons - Access 97 ?
- A-2003 - FK combo-box losing formatting when selected in main table
- Windows Colour Scheme
- How to pass variable value...
- Refresh a lookup box?