View Full Version : access answers
- 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?
- Setting RecordSource
- Import Automation and...
- Fuel tracking in vehicle database
- Automate run all table names in Combo box
- Need to parse Name field so I have to fields, FirstName, LastName
- Custom Field in Query Slows it Down Dramatically
- Access Developer's Edition Questions
- Speeding Up Access and Jet on a Network
- code to automate full import - reliable?
- Lost References in one copy?
- Link two tables?
- Connect to Internet from Access?
- "You do not have access to the folder ... " message using Access97 on WinXP / WinXP SP2
- Access Performance Curiosity Question
- Datasheet Form Not Growing to Show Data
- Modify a remote macro or startup procedure
- calculating a percent of total in a query
- How to Energize a Dreadfully Slow Query
- Enter a Description using scripts in MS-ACCESS
- Design of ticket sales database
- Visual Source Safe and MS Access
- MS Access 2003 - Error Handlers (Add-ins)
- How do I make this report?
- Simple Query
- Union query
- Sorting in forms
- How to use form to print report
- Programmatically remove a form from Access 2000
- format : %
- How to get user id of windows into access via vba?
- Find record using Combo box
- before update - validating potential new data
- Create autonumber
- Problem with recordset name using string
- Encrypting some fields
- Pivotchart question
- Excel Automation Problem
- Charts
- Update Query (Access vs. SQL Server)
- Access Date Format Input
- how can I bypass my query parameter
- Disable custom menu in ms access 2000 / xp
- ACCESS COPY AND PASTE
- Toggling Checkboxes
- First sign in a field needs to be a CAPITAL letter
- adding numerical values for ID purposes
- update table from form
- Application.ImportXML Fatal Error; Causes? Way Around?
- HTML Template File Name Question
- Linked Look-up Menus
- filter with form--test for null date
- Combo box to query to report
- Button Images?
- Button Images?
- restaurant directory database
- Listbox...more
- Displaying DWG In A Form
- Calculated Control using 3 criteria including dates
- List Box DoubleClick
- tab control page jumping
- Formating currency in a report with mils
- Formating currency in a report with mils
- Breaking Locks
- hyperlink in a report
- Access -> Excel
- dlookup problem
- Hierarchical Data in Jet
- ASP Login Failure - Database Password
- Enable controls on a tabcontrol
- exporting database table create statements
- Combo box fills text box
- Maschera per interrogare query
- Limit decimal places with Excel automation
- calculation
- Username of XP login
- Subform and Macro question.
- Sample Switchboard/Design/Code
- Shell Woes
- Opening Excel spreadsheets: How to get past security warning?
- Help with Check Box code
- Passthrough queries and RecordsAffected
- tab control jumps when you try to cycle subforms?
- What's the easiest way to convert an access form to to a web based Front end ?
- query to split fields into multiple rows?
- If Statement
- Append Problems
- CurDir
- Dates in Visual Basic Access 2003
- Transferring data
- URGENT PLEASE HELP ASAP. Date/ Time multiplied by a cost for a certain field? PLEASE.
- Multi-select list box
- Google says piss off!
- excel automation, cross tab query, parameterized queries
- Child Values in One Field?
- Issue tracker MDB
- Simple html forms out of a database record?
- sql server and access
- make all values identical
- App Path
- help whit DBF linking
- HAVE YOU HEARD THE GOOD NEWS!
- Web page locks
- Priting all files in a Directory
- Rename an external file
- controltip text not working :-(
- Access 2003 -- DAP question -- is it possible to display a form with a subform?
- Occurences of a field in database
- Opening database with text editor
- Connection to MYSQL
- Count values across fields?
- using database password..
- 2003: Functional Analog of AutoExec at Quit time?
- Is it possible to
- Bilingual amount formatting
- When to requery Form after running Update query?
- EVERY Chord, Scale and Mode for GUITAR.. Literally!!
- Please take a look at this great program
- String Link Criteria for List Box
- Problems with Converting Text to Currency
- negative
- VB6 dll passing dates
- Novice Question
- How do i view the SQL statements behind an existing report
- How do i view the SQL statements behind an existing report
- Can This be Done? PDF Background
- Reports with lots of fields not otherwise in database
- MS Access dynamically change a table in a query for a report
- Where could I purchase a copy of Building Applications with Microsoft Access 97?
- Seeking site describing "Class Modules" in Access 97
- Database capability question
- Add a cloumn with a row source
- I wanna create a new database
- embedd report as a subform or such...
- Leban's RTF2 Span Report Over Multiple Pages
- *IMPORTANT* Message for Google Group, Usenet and AOL users!
- App won't close
- Idiot Question: Why do I get a propety Error with the following code?
- ACCESS ADO-Update Function does not work correctly
- calling Excel xla from Access
- Automating update of date restriction in query
- Find Record mataching 3 criteria Fields
- *IMPORTANT* Message for Google Group, Usenet and AOL users!
- Open pivot table view by default
- *IMPORTANT* Message for Google Group users!
- PrtDevMode I think
- Access 2003 macro security
- Problems sorting forms in Access 2003
- choice of DB
- Changing the source of a report and query
- issues with reporting foreign keys
- Can I reference Form properties from a control's property sheet?
- Count Distinct Response
- Like Statement
- Access recordset alternative?
- Select query on text field