View Full Version : answers
- One-to-One table / "related record required" - HELP
- Access/Outlook integration in Office xp/2003 ?
- Lines in a Report
- AccessReport-To-PDF
- Go To Rcord Number x - how do I write macro
- Insert a Dash in a reprot
- datetime
- msgbox
- Time differnce in whole hours
- OBJECT BLOCK OR WITH BLOCK VARIABLE NOT SET
- How to test if records in Table?
- Change Column definitions?
- Ldb Persistent Locking
- KeyPress to prevent entry of certain characters
- MSCAL.OCX and multiple versions of Access
- Access 97 Combo Box Problem
- Conditional display of a Drop-Down selection in a form
- Parameter Query Problems
- bang or dot? How to reference controls in queries?
- Can't build a link between unbound forms
- Detecting Quit
- Avery# For Labels
- ODBC on new installs
- Required field in subform
- error when trying to add record to Access 2000 db
- text field only for text - no numbers
- Q: Sorting/Grouping query results
- Criteria testing fields that may contain null values
- Relationships Between Lookup Tables and Regular Tables
- FoxPro index problems with Access
- Error on Exit - Occurs on Compacting Database
- Deleting Records with Similar Fields
- Tapping into 2nd unbound Combo colum
- Update problem get error message 3709
- IPersistStream object in Access
- Determining OLE dimensions
- Increasing Access Knowledge
- Splitter Manager Killing ME
- !!FAQ! for Date: 20031015 - New Users Look Here! [Last Updated July 24, 2002]
- Printing from MS Access to HP LaserJet via JetDirect
- Form??
- multilingual Access 2002 application (best practices)
- HELP! Why does my database keep corrupting?
- Import a toolbar
- Error on Openning Project
- Error On Exit Application
- Form/Subform & XP
- ODBC database does not appear in 'Files of Type' list
- A97 > 2000 problem
- Translating Text Document
- Query with forms
- font problem with import text wizard in ACC97
- Time calculations in Access 2000
- Find worksheetname
- Mail merge and labels button from multiselect listbox
- What control libraries to use
- Migrating Access 97 mdb to Access 2000
- help need urgently
- Restricting the taskbar to one icon per open database instead of a group in XP.
- Help with creating report
- How can I make Access 97 "see" tables in a remote database after creating those tables with a query???
- DTPicker.Value is read only
- Subform doesn't show records?
- List box problem
- Best way to link 2 tables
- alternative to autonumber
- Help Desk Call-Centre Log
- Problem with 'Filter By Form'
- Saving and Updating Records
- !!FAQ! for Date: 20031014 - New Users Look Here! [Last Updated July 24, 2002]
- Possible to see who has file open?
- forbid closing the form ?
- Ignored characters
- Proper Syntax for DSN-Less Connection
- coding a form with dynamic record counts
- On the subject of Data Warehouses, Data Cubes & OLAP….
- Stephen Lebans Code
- Enter date as 12/01 and display it back as 12/2001 problem
- Unable to quit Access.
- "Records - Refresh" menu - drag - drop - gone
- Images
- MS Query - STANDARD DATE to YEAR-MONTH
- Retrieving Date in tabular Report
- Virsus
- Web access to a secure database
- printing to multiple trays
- orphaned .mdb file
- Errobject
- Very sticky Object Invalid error
- Can I identify a Telephone number to use it in a query for information
- Jet error 49 Windows NT4
- rant about focus - has this happened to you
- rant about focus - has this happened to you
- How do I automatically update a date field upon data entered into another field?
- Microsoft Office Launch Events
- Re. Control can't be edited; it's bound to unknown field ' EmployeeID'
- Recovering a database from *.dmp formats
- Need Info on Developer Edition
- wildcard in QBE criteria causing data type mismatch error
- ReturnRecords property setting???
- Image database
- New users & personal ID's...
- ListView on Tab Control - a workaround
- What is the default admin username & pass for a new installation of Access 97?
- How to enter Access 97 after creating username & pass?
- How do I set up Access 97 security to require a login ID & pass when launching Access 97?
- A2k - records on many side appearing spontaneously - help!
- ms access web how-to
- Form/Subform in XP
- Relink MS Access tables using VB
- Combo box versus Listbox
- !!FAQ! for Date: 20031013 - New Users Look Here! [Last Updated July 24, 2002]
- Need Help with Code to Email from Form
- Moving to next record on SQL Backend
- circular form control
- Starting behaviour
- Copy form data via PK ?
- DSum #Errors When Date Parameter Used
- Datatype mismatch problem...
- Link external Databases
- Report showing products in descening order
- accessing MS-Access Objects from VB 6.0
- vba problem: datensätze vertauschen
- Date Returns #Name
- Custom Help in Print Preview
- ODBC + Access + C = problem
- Converting MS Access Queries to TSQL in SQL Server
- alias field names sometimes not working in select query
- Sequence of Form events
- Help Workshop - Warning Message
- Listbox Order
- Need help with insert query ?
- HOW DO I RESENT AUTO-NUMBERING TO 1 (ONE)?
- ADO Error 3251: Current provider does not support returning multiple recordsets from a single execution?
- Null Value in form problem <beginner> Please Help!
- Disable mouse
- Query
- Is indirect sub/function possible in Access?
- database to be used by 2 remote users
- conflicts in mail permissions
- Whats wrong with this piece of code II
- Whats wrong with this code
- Relationship Question
- form for db updates to do?
- !!FAQ! for Date: 20031012 - New Users Look Here! [Last Updated July 24, 2002]
- Necessity: mother of programming
- Mathimatical function on a derived date
- text box trunctated
- Access 97 + Windows XP = Blue Screen
- structure comparison
- The mistery of the hidden menu code
- Navigation buttons off bottom of screen?
- Can VBA FTP?
- Parse VB/VBA Code
- Tick Box
- Filtering using combo
- Kill file, how to find out it it's available yet?
- Linked tables: Long file path
- Msgbox icons - rules for using?
- Global variable to change report title
- replication
- Trouble Linking to .DBF File
- Class Problem
- mdb file permissions ?
- Help with Help files
- Bound combo to control another combo
- !!FAQ! for Date: 20031011 - New Users Look Here! [Last Updated July 24, 2002]
- AccessXP Reports Open Fit to Page
- ODBC Connection to Multiple Access Databases
- forms
- Which DBMS?
- Totals query divided per months
- Parsing mdb filename from linked table connect property
- Create table and set format proprty
- Use Code To Insert Code In Multiple Reports
- Passing parameter to ADO recordset from Field
- function with variables from different forms
- Menu At Top Of Screen Disappears
- Problem creating Excel files from an Access Module
- Freeze Panes
- A2K - still have a slight date problem...
- Missing Link Properties For Report and Subreport
- Meaning of "Object Invalid or no longer set"?
- A97: Hint About Constants, Compiling, Decompile
- Page event "skips" Detail formatting
- VB IDE AddIn with VS VB 6.0
- Inserting data into Access form from SQL Stored Procedure
- Problem with Index
- Q: Simple SQL query question
- Access Sub-Report question.
- SQL syntax assistance on a Pass-Through query desparately needed...
- Help me with this query.
- Access 2K Conversion
- Foreign key field on form
- !!FAQ! for Date: 20031010 - New Users Look Here! [Last Updated July 24, 2002]
- INSERT INTO Query
- Query Problem using wildcards
- Query help
- Normalised reports
- Another Nz() Problem in A2K
- Remembering what record and field and returning after running someVB
- How do I make one of my installed ODBC drivers the DEFAULT driver?
- MSAccess and FileNet Panagon Report Manager
- BIG DATABASE OFTEN DIRTY
- Which_solution_choise?
- Return File Date
- How do I change the font on a single bound text box?
- Automated Functions
- File bloating after decompile
- Omnis7 ODBC
- Scanning
- Only Print One Page?
- Union Queries & Filters
- HELP! How to delete recods in one table that match those in another table?
- Can a subform's window size be set programatically?
- icons on buttons
- MS Graph 8 Line Graphs
- Hiding control names
- test
- copy files
- Lock Textboxes
- Unwanted duplicates in query
- import message from outlook form
- NZ Assistance with DSum
- How to customize shortcut menu?
- Application defined or Object defined error
- Evaluating dates that contain nulls
- Word Mail Merge
- NewB: Connecting to Database?
- Appending Text file with a header record
- How do I know that a program is already open
- reservations
- reading next record in a query
- Access -> Excel Automation Slow
- Q: Accessing table fields from Report Detail On Format event
- Multiple File Types Link Refreshing
- myodbc with windows xp
- exporting query to text file [help!]
- Update query problem
- Transfertext failure in referenced .mde
- !!FAQ! for Date: 20031009 - New Users Look Here! [Last Updated July 24, 2002]
- Text Export Problem Run-Time Error '13'
- Count Function - Help
- CodeModule Find Method regexp
- Storing Unsaved Word Documents as BLOBs
- AC97: Filling out a PDF form through automation?
- How much art to put into database?
- Question using SENDOBJECT command in ACCESS 97 Macro
- Active Application LostFocus and GotFocus Issue
- The expression you have entered is too complex
- Default field value = record number - How do?
- Calculating weekdays only
- Globally Check Contents Of Table
- newb join query
- SubForm Refresh
- Access Ghost - Please help!
- SQLDisconnect from ms-access database
- Microsoft.Office.Access.2003.Developer.Extensions - new !
- UNUSUAL MOUSE SCROLL BEHAVIOUR
- Access-ADP: tablesize and speed
- Database Design
- Form on Form - Modal to Use or Not
- Help Too many Fields
- Bookmark Code for HTML Page
- creating invoices for all customers
- Populating underlying table with the correct values problem..
- Linked database - mysql & msaccess - autonumber problems.
- Can't add record
- Difference between Time fields? - Access 2000 Query
- Q: Designing table with net revenue..12 fields for months or 1?
- Add months to date
- error on form
- gif images
- Dynamically Adding a Table to Each Page
- How to get "<All>" selection in combo box?
- key selection in combobox
- Adding Broken References
- Automatic Population of a Field
- How to Requery a control in a form
- A2k: Module stops executing after OpenReport, SendObject
- !!FAQ! for Date: 20031008 - New Users Look Here! [Last Updated July 24, 2002]
- MPT Tree for Access
- Calling a remote PHP script from within Access?
- how to use alter table and identity
- Restricting no. of digits in field
- Date Calculations
- Importing from Excel
- Executable Forms
- This wretched SQL has me stumped!
- Executable Forms
- Link Table in Access 2000
- Disable Escape
- How to make this 'simple' query?
- Copying data from multiple fields on one form, to another form.
- conversion of ms access 97 application to ms access 2000
- Stored Procedure from Access 97 to SQL 7
- Disable Escape
- Access over a network HELP NEEDED
- Creation of a table with 300 fields. How?
- Calculating In Access
- Changing a Library Reference
- Is this SQL query possible?
- a2k me.recordsource not taking
- Put metods & properties Help into MDE
- What is quicker or better?
- Duplicate autonumber
- Upsizing Overflow Error
- decompile in Access 2002?
- how to preview a report using VB
- Store personal settings
- is vpn the only way to use access across the internet
- Delete Backup files Older than 5 days?
- send a report as the body of an email
- Can a report be programmatically moved to last page?
- HELP ME ACCESS 2000 and ORACLE ODBC 8I
- Updating a Listbox
- VBA filter code does not work!
- Command bar OnAction
- Capture AutoNumber ID with AddNew method
- Error Codes
- Recreate a deleted linked table
- MS Graph - Late Binding Question
- access 97 - runtime error '2465'
- Printers not showing up in Access on XP Pro machine with Adobe installed
- Sort a form by default
- Where can I find the pathname?
- A2k - updating Many side dependant on change to record on the One side
- Date/Time in Advanced Filter/Sort
- #Error Message from SubReport
- !!FAQ! for Date: 20031007 - New Users Look Here! [Last Updated July 24, 2002]
- Btrieve to Access
- Event on record navigation?
- Comparaison dans une seule table
- Putting my Access 97 database on the web
- Include Custom Property on Title Bar?
- TreeView problem with subforms in Access97
- Two Versions of Access on same machine?
- A2K Report Design Problem
- List Box
- Find last entry which isn't null
- Deploy modified Front End
- Probleme sql UPDATE par odbc/php
- listbox
- Listbox selection shows detail
- access97 slow on windows2000 Server
- Need examples of database models
- Access Drop Down List
- Popup modal form
- Swen -- can I make a new eccount with a non existing emailadress ?
- Q: What is the most efficient/fastest way to open a form?
- Global Function Guidance
- DSum Formatting Issues
- ActiveX Grids
- Search Problems
- UPDATE SET xxx=SELECT Help
- NotInList event?
- Attachments to Outlook Express possible?
- Access to Access ODBC connection via Internet?
- SQL & VBA
- Open a form with subform in MDE
- Linked Pictures
- Automatically Fill Fields
- Sorting a REPORT by a Calculated Field in group header
- Total Records on a Form
- A2k - Query error, concerning dates (quick fix i'm sure)
- Access 2000 - export Report design, not data
- setting a subreport
- !!FAQ! for Date: 20031006 - New Users Look Here! [Last Updated July 24, 2002]
- Append query help
- Requery Subreport list-box control
- Recreating Problematic Database
- report of data entered on the current day
- Using a combo box to prefil other fields
- NorthWind Example Question
- select distinct criteria?
- Access Database Templates
- For Each - Next
- max records
- leading 0
- How to get value from a query or table?
- set recordsource to query ==>> error 2467
- SQL Logon for ODBC Linked table
- A97 - Creating a Seach form
- Transitive dependencies
- access installed slows app?
- FontName = "Franklin Gothic Medium, Tahoma" ?
- Help With a DATETIME Query
- Creating databses for variable records
- No of chars in a text field
- setup access/win2k for internet use
- Autonumber code
- A2K - allowing multiple dates in continuous form
- !!FAQ! for Date: 20031005 - New Users Look Here! [Last Updated July 24, 2002]
- group by query help
- Will I run into problems if I download MDAC 2.6 SDK and install it on a Windows XP machine?
- I would like to attach briefly to an Access 2.0 database located on a web server somewhere
- MDE file
- Access(97) won'r run - no license on this machine
- email hyperlink fields?
- Account Receivables
- Huge file size
- Suppress "Object Already Exists" Message
- Creating a label in Access 2002 - Avery number not in pre-loaded list in Access label wizard
- QUERY QUESTION: how to use form variable as criteria ??
- Query about ADO Query
- Close a form before it opens
- Test ignore
- Synchronize attempt failed: Error #3003: "Could not start transaction; too many transactions already nested."
- MultiSelect Listbox trouble
- Better way to store data
- How to save unbound field text to table?
- !!FAQ! for Date: 20031004 - New Users Look Here! [Last Updated July 24, 2002]
- Speed tip: Set RowSource of Subform's Combo box in GotFocus event rather than Enter
- TEST
- OT. Anyone going to the Office rollout Oct 21 in San Francisco?
- Table Design
- Getting a sum from a recordset question. Access97
- Migrating a single user access database app to multi-user multi-site.
- Form and Query Questions
- Help With Another UPDATE uery Please!
- complex union query
- Problem with refresh form the subreport to the main form
- Check if th MS Outlook is open
- DSum, Function Methods - Need Assistance
- Access 97 - Turn of Access Warnings
- OLE Automation library - what's it for?
- Office Developer and Office XP
- SMTP code for VBA?
- Allowed to distribute fonts?
- SMTP code for VBA?
- Professional Resumes, Business Plans, Accounting, and Virtual Administrative Assistant Services
- Design Changes To Objects In Shared MultiUser Database
- How Do I Get Rid Of Coded Characters In An Access Database Memo Fields
- Create long string from query result?
- Combobox in sub-sub-form
- Opinions Wanted: New ActiveX Piracy Control
- Odd Behavior Of Combobox and Textbox
- Help with UPDATE query
- IF in a query
- Need opinions on converting Excel db to Access/MySQL or ?
- Compacting a database on close
- delete when duplicate
- Second Query Question
- Query Question
- Calendar
- Link OLE Object and file from a form
- Security Update Disables TableDef AttachSavePWD Attribute?
- !!FAQ! for Date: 20031003 - New Users Look Here! [Last Updated July 24, 2002]
- HELP! - NEED VB CODE FOR BEGINNER
- Correlation Analysis - 'Not Enough Memory to Run Excel' & other strange behavior
- Bitmap bacground in sub-report
- .NET and TableDefs.Append
- Subreport Doesn't Display When Query Returns Zero
- Maiximum forms and tables
- Conditional Formatting in Forms in A97
- Access Security
- Printing MS Access Database Structure in ASP
- Where condition
- How to do this using MS ACCESS
- Form Subform Error
- Function and SQL
- Hours available in a day
- Date Format Problem
- Compress Access DB
- Another SQL/query question
- difference between Primary and Unique index?
- How do you parameters (from code) to an Access Query
- Simple file attachment
- Text search in linked OLE object
- Open database window from hidden button
- Late binding now failing
- VB6, VS6 versus VB.NET, VS.NET compatibility with Access 2000/XP apps
- Linked sql view changing datatype
- Select qry dialog box
- best control/method for item selection on Access form
- Locked Records
- Copy information from one form to another
- COMPARE MAIN FORM TEXT BOX ES TO SUBFORM TEXTBOX AND CHANGE BACKCOLOR
- How to check the Application SetOption in Microsoft Access
- Validation of a field using Access Forms
- Prevent certain columns being edited or new records added.
- E-Mail one record at a time to different address
- Faxing from Access
- access record overwritten
- Number of rows in a table
- popup spying background report.
- Date Functions in Access 2000
- 2 old table into 2 new
- Detecting Windows Shutdown in Access 97
- Outer Join possible in Access 2002?
- help: MS Access Query problem with average, Max..
- Output to Word - place the cursor!
- search table and remove ,
- Module problem
- Print drawings
- Querying remote tables
- hidden form becomes visible if all other forms closed
- What is wrong with this code?
- How do I Mail Merge RTF data to word?
- Attempting to close form - ... will reset the current code in break mode...
- Word automation bug
- Word automation bug
- Modify source script dynamically ?
- OutputTo Excel
- OT - calling batch files with parameters from GUI
- Set Caption Of Label On Report
- let's try this again - help!
- Record Numbering problem...
- help with relationships?
- Make Reports Open 100%
- Help needed with a complex query
- Need Some Help
- Updating back-end
- Multiple Search Criteria
- Make Products/Orders Query Updateable.
- Adding users to secured database
- Hiding zero values in text boxes?
- How to check user input for illegal characters?
- IsNull Or IsNotNull problems
- storing a variable
- ..SendObject...[help]
- Display Record number is a Control
- Why can't I Kill temporary database?
- Selection Does Not Appear In Combobox
- Conversion from Access 97 to Access 2000 (or XP)
- !!FAQ! for Date: 20031001 - New Users Look Here! [Last Updated July 24, 2002]
- ? about adp and connections
- Query Expression to Return a Part of a Field
- Printing multiple reports!
- Form won't open correctly if there is no data
- Select multiple items from drop-down list
- SQL Query
- Recently edited records
- Crosstab with month/year ... count and average
- Access Special Keys
- Need help: How do check the -FULL- Access version number in vb??
- Counting with and comparative list
- SQL Query looses order after UNION in A97
- Access 97 - Update Multiple Tables from one form
- variable (long) as criteria for Dlookup
- DoCmd.OutputTo acOuputQuery -- Eats Query! Where did all my SQL go?
- Contradiction between TOP and ORDER BY in a ranking query
- changing code by code
- where_condition in Sub-Reports !!
- "exclusively in use" problem
- Changing a Library Reference
- Code to select a record
- Compiling Access XP to run under Access 2000
- Word not opening properly during a mailmerge
- Selecting in a Listbox an Unbound column