View Full Version : answers
- Problema con un report
- password enbaling form
- 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
- WEB DEVELOPER NEEDED in HOUSTON
- 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
- using flash in ms access 97
- Unable to set focus on a text box
- 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
- Combining data from several fields in a Union Query
- Access vs Visual Studio dot.net
- Why function does not work?
- Dev Ashish function not recognized. Need advice quick.
- Comparing input date to current date
- Records across LAN
- Memory usage for reports
- ddl for union queries
- 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
- Form check box & report data
- create autonumber
- 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?
- Tabcontrol - add records
- Combo Boxes
- 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
- Using hours in a date range parameter
- Numeric overflow in [tinyint] field
- 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
- Help Converting from Treeview 5 to Treeview 6
- Format function in SQL
- 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
- Setting the size of column widths of a combo box through Code and Searching Combo Box
- Make table from code?
- Doing the unthinkable with my tables
- Subreport title
- Help with error in trying to email from Access...
- Thanks!
- 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
- UPdate Outlook Calender
- Selecting a row in Subform
- 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
- code to automate full import - reliable?
- Speeding Up Access and Jet on a Network
- 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
- Encrypting some fields
- Problem with recordset name using string
- 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
- filter with form--test for null date
- Linked Look-up Menus
- 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?
- Append Problems
- If Statement
- 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
- Access recordset alternative?
- Like Statement
- Select query on text field
- Macro to Run multiple queries
- DSum([Field) in Subform where its current-records are stored with all subform records
- Problems Saving A Report
- vb6 dll
- Access.CurrentDb.Name and Win XP
- Zoom and fit report to wimdow
- Copying MDBs Via Code
- Excel like autofilter query
- DSum basic help
- Tracking/sequence numbers
- Code for Duplicate Records Warning
- DoCmd.RunSQL INSERT INTO
- the SUM function and rounding?
- Print content of sub form only
- Store the Value?
- Selective Table Delete question
- Large Query with more than 255 fields
- Count of non duplicated recs
- COMPACTING AND REPAIRING DATABASE
- Recordset retrieval Error
- Importing Text
- docmd.setwarnings false isn't working...
- FillDown in Access
- Problems with Access 2003 - Keyboard Type Ahead Buffer
- primary key problem...
- Yes/NO Query Question
- Specific excel file to open on a button.
- Error 2501 The OpenReport action was cancelled... HELP!
- Creating hyperlinks in exported report
- Determining first and last records displayed in a form
- how to have a date calculation
- How can I change font size in Datasheet view of a sub-form??
- How to create autonumber
- Acc 97 and Windows XP
- converting multiple field data into a scholarship amount
- Keeping old office CD's for licensing
- Report quirk
- Eliminate Blank Rows
- Access Run-Time and Name/Initials
- Report / Query : Multiple Dates
- Popping Access form from CallerID
- Codes and masking
- how to get SQL2k user ID passed to Access
- question about regression in Access
- I monografia Administração I
- transfer db from one computer to another
- Access 97 Subform v. Subreport
- Screen Scrape?
- error accessing file
- Update Table from form or query
- Parameter Query Prompts
- Displaying first record of subform in parent form.
- New record button greyed out
- Barcode Scanning
- Creating a pass through query
- Update query Inner Join question
- Update Recordset From Code Problem
- delete form
- How to Sum totals contained in queries?
- Access 2000 Tab Control OnChange Event does nothing
- How would you...(report vs numbered copy)
- Have you ever worked with a secure MS-SQL serbver/database?
- Total Query from Subtotal Query
- Access 2003 - Left Join wierdness
- ListBox: Changing appearance of selection rectangle depending on focus?
- Populate text box from selection keeping navigation working
- How to make ComboBox selection save?
- Any advantage to converting DB Format from 2000 to 2003?
- "Screen Scrape"
- Printer object bug with Access 2003 - confirmed by Microsoft Corporation
- Printer object bug with Access 2003 - confirmed by Microsoft Corporation
- not show records in a form
- auto update currency?
- Is it possible to prevent the addition of new records but still be able to edit existing records on a form?
- Writing into external table not possible
- RecordSet as Record Source
- Fill Down in Access ?
- Hide Ttle Bar
- Populate multi-list box based on selections in a different multi-list box
- How to unlock VBA Project?
- multiple field primary key in Access 2003?
- Save record if any field has been modified on form
- Could someone direct me to information on the proper use of WHERE statements
- Calculating amount of time spent on a project
- Hyperlinks in Access 2003
- q. Downloading Photos From the Internet
- How can you open a form to a specific record from another form?
- Refresh form, Access 2002
- Problems linking the value of a ComboBox to a SubForm
- I need a function to get the date of the monday in a given (year,weeknumber)
- Access 03 and HP Laser - Print Shrinking
- Can query with left join be made editable?
- Keep together
- Efficient temporary tables
- Query totals disagree with Filter totals
- Unable To set A2k .SubDataSheetName in A2003?
- Record Limit in Access 97
- Access 2003 macro security
- Access vs Excel Presentation