View Full Version : answers
- Autofill query
- Access to excel
- Msgbox text font
- Import Excel using Access Wizard
- How to add data from one form to another
- I was planning to use this code to add users in A97...
- Trying to use Playsound in A97...
- Importing and Updating Access XP
- Word function out of Access 97 non-responsive after Access 2003 Upgrade
- Microsoft Desktop Client: Any chance of connecting to local drives?
- Modifying subform records for cartesian product
- Thank you David Fenton... but one more little thing.
- Switches?? - Access 2002, VBA
- A97 compact database question?
- LIKE criteria works in query but not in VB
- eeek help
- Cannot compact
- Problem with SQL statement on subform
- access query issue....is it possible?
- Appending Strings
- A97 allows separate procedures in a form module to share common labels.
- How do you record check box selections in the database?
- assign auto number using VBA
- What's the default choice if Public/Private is ommited from the Sub statement?
- Access 97 linked to Oracle showing wrong datatypes
- UPDATE SQL Statement in Excel VBA Editor to update Access Database - ADO - SQL
- Loop through all forms to set Allow Design Changes Property
- Storing check box selections in a textbox as appended strings
- A97 table field of Yes/No type without a default value property setting has a default value?
- how to make sure access queris the correct data sets?
- MS Acces help needed
- Subform Problem
- Query Criteria linked to form
- Date Field ---Help
- use dao to create odbc link table and saving the password
- Hidden modules in Access 97 - what are they?
- Events on Tab control
- I'm trying to grasp the concept of class modules, seeking a straight-forward example on a site somewhere
- A97 debug window
- MS Query not enabling join options when merging dbfs
- Access really slow over the network
- Melissa Data Address Object
- Help w/ On Open Vs On_Open Vs On_Current
- Who controls improvements in Access
- Scroll automatically tabbing through fields in a form
- Password Backend
- Running Totals by date misbehaving ?
- attachment
- Access and Oracle sequence issue
- Error Creating Table in MS Access
- A2K3: Use control on form for calculated field
- Report Formulas not totaling in footer sections
- MS Access as a web darabase?
- Opening database exclusively
- Database Permission Settings
- Footer OK on print preview, but doesn't print to printer
- Force 4 digits in field
- Problem with date formats in international project.
- MSCAL.Calendar.7
- Accessing a MS Access database across two servers
- Button Effects on Access forms
- In Form View - can't get to next record. Why?
- Reverse Engineering an mde
- dynamically control form objects
- Adding a Quit to a Macro using Visual Basic
- Include picture in Access form
- Emailing one page from a report..
- Query to show letters sent by date in a crosstab format
- Inference Engine
- CopyFromRecordset does not work on different machine
- Problem grouping records by certain time frame (report)
- Use friendly Databse Tool for non-DBAs
- date comparison
- Copy Same records
- To brows to a folder or file
- object variable or with block variable not set
- object variable or with block variable not set
- Closeing MSQuery Window from Access
- Question 2: automatically update an embedded XLS-flie
- Question 1: How to refer to a arrayed multple textbox?
- Numeric column in Excel
- Which Record to display 1st?
- Field to Field data duplication
- After Update event
- how can i 'select' items in a list box from a button click
- Is there a way to automate importation of Excel data?
- # of Months Calcuation only returns 0
- Disable Shift Key. Help!
- Error 3265: Item not found in this collection
- Find the length of text stored in a textbox?
- Problem with control source for text box on report
- Colour Cycle in forms?
- How to create table?
- Setting form properties in VBA: do I need numbers?
- What does var$ mean?
- Specifying parent child form by name
- Report objects
- Changing Unbound Field Name
- DateTime problem
- Switch function max number of varexpressions in Access xp
- File convertion
- Find file window
- Twips and Pixels: Please confirm
- Problem with forms
- update Access table by VBA in Excel
- To All
- MS ACCCESS has encauntered a problem and needs to close ...
- Who Monotors The Newsgroups?
- Return to same Record
- How to specify Range when exporting to Excel with JET?
- Query/Report to show how many letters sent per month
- Determining the size of a file via a URL
- How do you tell which page of a tab control is being displayed?
- What files do I need to deploy the runtime of Access?
- Need help with Tab Control (unable to update some fields)
- Text is too long to be edited
- Too many Forms Open
- Access application dies connected to Oracle databases
- Excel Automatation and Changing Format Of Cells
- Automating import into Access of e-mailed form to email data
- (Español) Utilización del SendKyes
- Using IIf More Than Once In A Report Textbox
- How do I change an MS Access Database PAssword from VB Code
- check constraint message
- 4k Table limit
- Altering a column to REAL and setting the format + the decimal in SQL.
- Calling excel: subscript out of range
- Determining the size of a file via a URL
- Connection String in VBA
- Syntaxerror in Designview -> How to correct wrong SQL-Syntax?
- Office 2003 Picture Manager: OLEClass property and Class Property
- Prevent textfield from being deleted from but allow updates
- Checking the value of a field in a table from Code
- SQL synthax problem on INSERT INTO instruction.
- Access report not reaching printer
- how do i insert new record in a joined table's
- DoCmd.OpenForm
- HELP ME TO USE GMAIL
- Help entering in a constraint, Please!
- Extracting data from Excel into Access Table
- what is the error here?
- can anyone here help me
- Count only counts all results and ignores criteria
- Play a ".Wav" sound with Access
- Extracting from Long Binary field
- pop up calenar not working in subform
- Please help! Strange behavior: Access > Word Mail Merge code
- TOP 10 query
- northwind sample database is a turn-off
- Loosing Printer Settings
- Running Balance Help wanted
- A mystery: can just a compact & repair change table relationships?
- Advice on Looking up
- VBA Problem
- After using clipboard functions in Excel from Access VBA Excel doesn't quit
- Present the 'gaps' in numbering
- How do I get a databse password in VBA?
- preventing opening database window in MDE
- ADO Importing from an unknown named Excel worksheet
- Update Access Table with filename, modified file date/time and values contained in these flat files
- Iterate through table fields in an ADP?
- Lock Cells
- Link OLE objects to Records
- Networking Database
- Question about relationships, inner joins and query results
- Forms, Memos, and Quotation Marks
- Intervals - Using lookup?
- Dont show report when invalid date is entered?
- Setting Checkboxes of Treeviews at Mask-Opening
- I already have a table called client and seems to be related with other tables ,I tried making TBL client as lookup too, I ended up having another table called Client_1?
- Can MsAccess help me in this application?
- Adding up field from a table
- Why does Access create a duplicate database every time I open my mdb?
- OCX clock control for Access 97?
- Cannot open any more databases.
- Publishing with Word
- size of database
- Unable to open database
- How to tell if others are connected to the database
- Problem printing report
- Selecting forms with multiple instances
- VBA Excel paste from access function fails every second time it runs!
- Print Report Based on Form
- Add new record, requery to add to table and then open for returning to new record
- Can I create a .Net custom control in a Microsoft Access form?
- Access opens to blank screen, won't open database
- name of A97 workgroup administrator executable?
- Q:Access Parameterized Query to Oracle?
- Microsoft Jet database engine stopped.... problem with fixing it
- Closeing MSQuery Window from Access
- Incremental Numbering
- Subform is ignoring filter
- Adding record to another table from form
- Recreating Design Master question
- Using a combo box on search form
- access date function question
- Implementing a calendar report
- Error with DLookUp
- How to you handel different access versions running the same database
- Report, Crosstab Query and Parameters
- access romania
- Replication via code
- Repairing when not broken
- Open Form At New Record (Empty)
- problem with SQL in Access
- PGUP, PGDN
- SQL Summary problem
- What owc10.dll does?
- How to control unexpected/unwanted GotFocus event property setting (expression)
- create a field based on another field
- Code to create table with increasing field numbers
- How to edit Production DB
- How to Ignore Missing Libraries ?
- Creating tab delimited file
- How to count a text field in a form
- Using Not In List and a Query?
- Changing one MDW file for multiple databases
- One record per tab
- Select newly added element in a list based on a sql
- Join Issue
- Table Setup
- Transfer Access database to Intranet
- Run-Time Error '6'
- Different Access version problem
- Create table shoutcut and add to existing group using code only
- Create table shoutcut and add to existing group using code only
- Strange Access Issue
- Print same Report of different heights on continuous paper
- Macro substitution request
- Imoveable Forms
- Insert only if item doesn't already exist... easy right?
- Pring in a smaller size
- Relink all tables in other database
- Make Subreport Function Like Main Report
- Custom Filter
- ANY Idea how to flush all data in an access DB or one of its tables?
- Passing arguments to function by reference - Good or Bad?
- Sending Parameters to Query
- Monitor Network Traffic
- Parsing data from a text field
- Connect property of linked ODBC table
- Setting Report Page Size To A3
- Having trouble with DLookUp in A97...
- .mdw only allows one user
- Conditional Formatting
- Using Text Box Name as string?
- Access runtime version
- User not in Admins - how to circumvent their not being able to create a new user?
- I get type mismatch errors sometimes. Why does Access think it knows what data type a text box control is?
- creating an inventory application
- Updating Table records
- A97: If I create a new user with CreateUser Method, is she automatically a member of Users group?
- Whats the easiest way to allow a user to change password in an A97 app?
- Chr$(13) & Chr$(10) give me a problem in main menu label caption property...
- problem running access
- Passing Record Set Reference from a form
- RunTime Error 5
- CurrentDb.Execute options
- Return File Modified/Create Date
- Create alias for network drive?
- A97: Can I 'peek' to see if there is another record?
- A97: Why is there no example for GoToRecord Action HELP section in Access 97?
- Help!
- Query question:
- VB.net Access97
- Query MySQL
- Moving data from Access to Excel
- File Import Question
- SQL Troubles
- Determine if listbox has values
- DLookUp Error message
- DLookUp Problem
- Automate the closing of Word from Access after MailMerge
- Importing data performance
- Access and Frontpage
- Export report as WEB page
- How can I attach two reports to the same Email?
- Controlling Excel from Access: Using Sendkeys to enter data into an Excel Input Box
- ComboBox
- Invalid Argument (OLE Objects)
- SQL Multi Column Primary Key Problems
- Problem in Join(T-SQL)
- Is This Development?
- highlighting the current record
- Compact on Close Code
- a2k - using bound subforms and transations
- Rounding a number up
- HTML chars have strange chars that show up as little square boxes, but are something else?
- Upgrading Access2000 to SQL Server
- Make it compulsory to fill in field in form
- Do I need to set form properties every time??
- Opening Report 100% view as default
- closing ODBC connection ?
- Opening a mail merge document from Access 2000
- Insert date
- Package Wizard
- yet another question - how do I set error trapping to 2?
- Psuedo Code
- report on close
- Deleting filtered records not working properly.
- reports question
- Server error
- Entering the Record Number in a field?
- Putting the Record number in a field?
- Putting the Record number in a field?
- Select Row in Datasheet Subform
- Assigning a Data Type to a Combo in VBA
- Dynamic Crosstab + Sub Report
- Comparing Text Fields in table
- Docmd.save Does Not Produce Error
- Sequencial ordering
- Forms modified when the really aren't?
- Where's my copy of Building Applications With Microsoft Access 97?
- Different code for saving records from A97 data entry forms?
- Selecting Records between two date fields
- Need help with multi-user environment
- list / form linking -- half way done
- type mismatch
- "Quit" in macro closes out the whole app
- Error Cannot Add or Change record because this record is required in table...
- subforms
- Referring to combo box controls on forms in A97
- Best Method For Providing Interactive Reports To Clients Who Dont Have Access To System
- Combo Box forces addition twice
- Mail Merge to Word -Problem with Access Form Code...
- Switchboard won't appear (Access '03)
- Split database convertion
- A97 and PDF's - Are they compatible?
- E-mail report as excel to people on report
- Registry Writing
- Text size in design view
- group by + count problem:
- Licencing the 'Reporting Donkey'
- Looking for a query
- Getting A Bigger Slice Of The LAN Pie For My App?
- Access security
- Form Operations
- Syntax error in query...(ADO.NET + MS Access)
- Action upon Key Press
- Pulling field value for remote webpage
- please help an access noob
- # symbol is showing up before and after hyperlinks
- Query
- A97: Importing AutoExec macro from Access 2.0
- Update Access from Excel via SQL
- Query Help
- A97: How to hide ALL the tool bars?
- Freeze field/column in continuous form
- Counting SubForms and SubReports
- Null and evaluation statements
- How to "Select All" in filtered recordset
- Need help on AVERAGING
- Problem with calling subform's button click event from the main form
- modules and sub routines
- StLinkCriteria syntax with multiple subforms
- Popup Form Eccentricity
- Dcount - novice user trying to write a novice expression
- ADP SQL Server Time Out
- custom shortcut menus
- Hide Section When Printing Report
- Matching Records with user definable criteria.
- Problem opening a recordset based on a stored procedure in Access Project
- Query Where WHERE clause points to Current Row?
- Not equal to a number
- Subform Linked Fields
- Office Automation using MFC
- Marketing Forecast, Quarterly Revenues
- DAO Parsing Table1 in Table2. What is wrong there ?
- search problem after converting data base Access '97 to Access 2002
- customized menu toolbars
- values are not going into table.
- to trigger or not to trigger
- logout for ODBC source ?
- pivotchart
- select the 1st row in a listbox
- select characters in a field
- A97: Keyword 'show' - what is that exactly?
- What's this... #If Win32 Then...
- A97: How go to new record on data entry form
- A97: Module window, clicking in vertical bar on left side of window...
- MS Access - how-to set control source for text box to query
- Parameter type append query dialog box - how to abort smoothly?
- Anyone here deployed an Access DB with an SQL / MSDE back end?
- How can I have Null entry in child table linked field?
- Cross reference utility?
- Need Help With Groups and Stored Drawings
- ADODB & Queries
- OpenArgs by reference?
- Looping thru Table1 to parse records to Table2
- Displaying calculations in a query field using Access 2000
- Password Encrytption Security (97 through XP)
- How to Import multiple excel spreadsheats?
- Access database opened via Intranet - integration
- text box help
- ActiveX calendar control in 97 - how is value updated?
- A97: Why negative memory values reported?
- What, exactly, is a control array?
- reading video properties from A97
- Continuous View Single View
- defining query in vb instead of design view
- Graphics disappear when printed
- Overflow error when Exporting Access200 report in RTF format
- Navigation button inactive
- Forms bound to SQL Server views
- SysCmd
- Reseting menu bar with VBA in Access?
- Access 2003 ExportXML - changing default tags?
- Update query # 2
- What replaces Database/Recordset collection in Access XP?
- Access DB continues to grow in size
- Can I join an Access 2.0 system.mda file from Access 97, to make it easier to import forms and other objects from my old Access 2.0 apps?
- syntax error in INSERT INTO statement
- Wildcards in OLE Linked Object File Name
- Access Automation causes warning messages and more to cease functioning
- Parameter Query - how to avoid needing wildcards
- Help With BuildSQL() Statement please
- ldb not releasing
- Internet Transfer Control, only option?
- Need help with tricky query... well tricky for me
- LDB file
- itc alternate
- What kind of database is access?
- standard view in database window
- filling fields with query results
- Determining a form's actual location (when it is not current)
- Code To Limit Precision?
- object invalid or no longer set message in vb
- A2KReportSpecs.mde as reference in XP runtime
- Access/VB6 problem Help needed
- Access 97 Import Text Problem
- Query and combo box to select parameter
- Displaying user-created menubar via automation
- Please help! What is wrong with this SQL code?
- Problems with autonumber field
- changing field data types programmatically
- No option for linking ODBC tables
- position in a field
- ADO / DAO Syntax to write to external database
- menu bars, tool bars, etc...
- Access Security Questions
- Datetime problems
- sql question
- Using Access database in an internet environment
- Ignoring spaces in combobox text: done,almost!
- Where To Put Error Handling Code
- Filtering a forms recordsource being used for a report
- label printing
- TransferSpreadsheet And Excel Formatting Problem
- columns and headings in listboxes
- Error Handling For A Recordset
- Nicht normal
- Valuation of database records: MoSCoW
- part of seconds in timestamp
- For a Field or Property object, this property is read/write until the object is appended to a collection or to another object, after which it's read-only
- Access Help
- Opening a mail doc from Access - code problem
- Filtering a numeric field with command "Like [.....]" as criteria in a query
- Error in Validation Rule
- How can I add NEW LINE to a report
- Code for Creating random letter combinations, but there are duplicates
- Database Design Question
- Data Type Mismatch
- changing a module into class module
- Requery Recordset
- ODBC Drivers error '80040e14' Syntax error (missing operator)
- Code completion / compact DB from code / slice data ???
- Automatic List Of Methods Does Not Come Up
- Future of access?
- insert with select
- Use an mdb as a background executable
- Min value of two date fields in same table
- Form freezes after deleting picture
- Problem with Ms Jet Exchange Isam (MSEXCH40.DLL)
- Import - database name as variable
- Searching .mdb files
- Help_with_forms
- Problem Opening Access 2000 Db with Access 2003
- MS Access Query
- subforms synchronisation
- name of current procedure
- Automatic Update After Printing
- Converting quotation marks to ASCII numerical value
- Weird access error: Access/OLE/Active-X communication
- Printing to receipt/serial printer from access
- solution for passing parameters to saved pass-through queries
- adding controls in forms from vba
- Please Test
- Opening a form in a specific location on the screen
- vb access run time error 3705
- Update an Oracle table, get 3167 error on faked Autonumber ID field
- Error message
- Trying to determine if MSDE Database is installed and install if not
- Strange behaviour in Access 2000/Win 2000
- Iterating a table with VB
- insert statement
- Data migration problem: Report sticks to old table name
- multiple columns in listbox
- Records Based on Recent Date
- Searching a txt file for instances of a string
- Count subrecords from record
- VB Copy a Tab Page
- Drag and Drop
- Problems with Code
- Inserting data into a Join table from a multiselect listbox?
- Link text box to a table
- Returning Records with Apostrophes in text strings using code
- inspecting whether a form is open
- My Dlookup is 'canceled'
- Hyphenated Name Field
- Refresh Tables on opening
- DCount function
- Problem on requery a form
- deleting an object in another database
- Entered data in query to form
- VistaDB vs Access or SQLServer
- Procedure list
- Strange query behaviour on different machines
- Not in List asks twice before I can leave the field
- SQL Query: Count with "having" date in the last five years
- comparing the datastructure of two tables
- Fields Containing Links to Drawings
- Make table query in a loop gets error: 'The database engine could not lock table...'
- List Boxes and Wildcards
- Set Lines Per Page for Space Delimited Text Output of Report
- Deleting Spaces between numbers or text in a field
- Status bar text does not update under XP
- Nested Sql - "Syntax Error in From Clause"
- Search a table column on any word or all words?
- A2003: "Update or CancelUpdate without AddNew or Edit"
- Using Access/Jet on Web site
- ACCESS 2003 query size high problem help
- MS ACCESS Security issue.
- Is a LEFT JOIN with a subquery possible?
- Wanted: Programmer to modify MS Access database for web use
- Wanted: Programmer to modify MS Access database for web use
- always prompt to refresh link problem
- SQL or RecordSet object?
- Perform an event when moving between records
- Fix to White Tab Controls in Access 2003?
- GetClipboardData(): Losing precision?
- Changing Screen Resolution
- Combo/List Box in Query Question/Problem
- Where to find Sample Databases ?
- SQL using IF THEN ELSE
- Keith - Advice on code
- Number of Copies....
- Query / Join help please!
- Secure Database for .net
- How to display an error message
- updating date