View Full Version : answers
- Field Type changing to hyperlink via VBA
- Updating Code From a Form
- MS Access 2000 DB / Active Directory awareness
- ODBC: Width of a Unicode text Column...
- OLE Object
- Allowing Nulls in Code
- ODBC Errors
- Seperating Full Name
- print screen ?
- Find a file
- bloating during FileCopy
- Insert an ADO recordset in an Acess 2002 table
- Deleting records using a multselect listbox
- Changing one's AccessMonster password
- Buying a new computer with Windows xp Professional
- Issues between A97 and Outlook 2003?
- Trouble with updating tables/ maybe a requery is needed- but how?
- Controls that show in datasheet?
- List box problem
- hourglass control during execution of code ?
- ODBC Windows 2003 Terminal Server
- Is there a way to total a "Count" column in the same SQL statement
- question about "At Your Survey" survey app
- What happened to the Access Addin for inserting Error code?
- child/master links
- multi item combo boxes or list box
- textbox size limit with sql
- Yet Another "OpenForm Action Cancelled" Topic
- "Find" function
- Need good idea
- How many time a string appears in a text
- Need help with Access SQL format
- Sub-form question
- Text box linked to Combo Box
- Running a MS-Access BE and an SQL-Server BE on same TS Server
- Sample data with FirstName and Surname
- building a trigger to change parent table
- Salad...Thanx
- Crosstab - barking up wrong tree?
- Text box linked to combo box
- Dynamic mailmerge subject
- Need help with Subforms
- I got a new gig today
- MS Word Mail Merge FindRecord won't find
- Access 2000 vba code large and slow
- Attching files
- Sum of Top 3 Values in Query Result
- How to close a DB ?
- Deploy Access
- IF box is filled then change colour
- Linking records
- Sub-form problem
- Help with query need
- How to rotate a text box?
- need help to advance db
- Linked Tables path.
- Select Query in VBA
- Help with transferring data from excel to access.
- System Date-Access2000
- Import from File Open Dialog
- CallByName to Module rather than to Form
- How can I modify fields types via VBA code?
- Access Report Problem
- Date Fields
- Novell login ad Access
- Login di Novell in Access
- Insert Random Number
- Access Banking Solution
- Query help needed
- Access performance on the Web vs TS
- Help comparing strings
- Newsgroup Etiquette: Responses
- Copy Data from Subform in A97
- Driver's License Mag stripe data
- Report Question
- Blank Pages in Printing Reports (Page Height Mismatch?)
- Capitalize first letter of each word
- Query Set Up
- TimeSheet in MS Access
- Expressions calculation Help Please!
- forms/subforms with DAO ?
- Problems with editing the VBA code - auto syntax check??
- Linking Allen Browne's code to Northwind
- Problem inserting object into Bound Object Frame
- Can't open query on updated recordset without exiting/re-entering macro
- Using GoTo or Resume
- Package my Access 97 application with your Sagekey software
- VB calling a form/subform by name rather then me.formname
- Importing existing data
- How do I know if a recordset has been filled?
- Another query problem - what function?
- accessing C drive
- Current record for a recordset not bound to a form
- Generate unique barcode to unique ID
- beginner with autonumber problem
- MS Access Banking Solution
- Embedding Picture problem
- Splash Screen
- Problems with displaying data from two tables on one form
- lists and combo box in a form
- query problem
- Trouble changing value in an appended field in ADO recordset
- Trouble changing value in an appended field in ADO recordset
- Solution: field-level permissions in Access
- String function
- Suppressing Access' table error messages
- Missing Toolbar menus
- Reference Library for just 1 user
- Subform Requery Issues - Error 2467
- How do I hide columns on tab control subform?
- Outlook automation formatting text
- Function Module looping problem
- Open form from another database
- Seeking advice on replication
- 2003 Database can be opened with default system.mdw
- Overflow Error
- MS-Chart in access
- import txt file
- probably a old chestnut-tips of Photo database design please
- control source based on wheter item iexists in other table
- Password For Table
- Help on report footer calculated field
- Huge problem with Access 2003
- Clarify "Enforce Relationship"
- Vertical lines in report (code check needed)
- Disapearing tables in query design mode.
- web forms w/ access
- lose autonumber property when i link mysql & msaccess
- Navigating a Tab Control
- Check for Query Results with no Records
- query parameter from open form field.....
- Special MDB or normal MDE ??
- text file as data source for query
- Emailing and creating PDF's in Access 2000+
- validation, before_update and after_update
- Change data from verticle to horizonal
- Same events for similar controls
- How to display a 0 for a empty record?
- Copy data from one form to another and create a new record to add data
- Reference Libraries for some not all
- Access Merge to Word Document
- Programatically fill a combobox
- Create simple Stored Procedures?
- Filesearch problem
- report?
- Looking for Tables in a Database
- ASP: Retrieve autonumber field on INSERT
- link record to form
- Error Message in Report b/c of Null or No Values
- Reply
- Mde file creation problem
- List box Requery is one record behind all the time
- Adding a "Compile and Save" Button To A Form
- AOIndex is not an index in this table
- Locking...
- OLE problems
- Control print from VBA (Access 97)
- Crosstab is missing data from underlying table
- Tree View File Browser
- Probably an easy one...
- Remove tool bars
- Appending a .rtf to Word
- INSERT INTO appears to be asynchronous?
- Encode/Decode Database
- Records disappear from table
- AutoForm Code?
- Need Advice on Table Structure for Part Kits
- Access Date Function Query
- HELP----DOES ANYONE HAVE A SIMPLE .mdb for MLM structure?
- Any similar function to instr into sql server 2000
- saving word documents
- List Box Set Focus Problem in MS Access 2003
- Data from Excel to Access, Arrgghhhh ...
- NEED HELP. MS ACCESS to do MLM Tracking
- reference library missing Microsoft Outlook 10.0 Object Library
- Connecting to sage line 50
- Tab Control Help wanted
- copy from the list box
- link 2 fields on a master subform
- case sensitive like searches
- Combining Lines In a Report
- hard time with criteria and report
- Line Graphs within Access
- Passing values in a hyperlink
- Error adding a new detail record
- Access 2000 last record from subreport disappears
- Access 2000: Version comparison
- Positioning popup
- increment form field after record save
- Saving a Record - Access 2000
- unlock DB - to view table, forms design
- Afterupdate for textbox?
- DB messed up after network failure - help
- Simple Combo Box Question
- Requery of form based on saved query...
- SQL syntax question
- Msgbox not issuing 'beep'
- Logging onto a Remote Computer
- Need file browse on Access form
- Time-keeping rules
- A2K Application.Quit won't - reference MDA libraries
- Signing an App with Access 2000
- Crosstab query
- Need Help on MLM database in MS Access
- Please help - Post Code Search
- Access Report using Grid
- Access 97 event logging
- Need help locking fields. MS Access 2000
- Date calculations
- Text versus Number field.
- Anyone yet using Microsoft's Visual Web Developer 2005 Beta 2
- Help! Queries and Calculations!
- one-to-many convert to form with multiple check boxes
- Access + VB6 recordset troubles
- Isolation problem
- Convert a sum in a report from a null value to zero
- litlle question
- Help! Compile Error: Method or data member not found
- Master Detail Question
- Access 97 MSDE Links
- HELP! After opening, a database immediately closes – using startup form
- little problem.
- Right-side blue panel 'Open' list: how to delete a filename?
- lier un fichier texte avec des dates
- transferspreadsheet to existing excel worksheet
- Table efficiency question
- filling in text box using a query and storing the information
- Memo text formating
- error "3343 Unrecoginized database"
- Problem with Stored Procedures and shared user name
- Data from Excel to Access
- Feeling dunb today can't get my head round a seemingl;y simple query...
- Setting up replication with access front end
- Query error: "Data types in the criterion expression are incompatible"
- 5365 monografia 5365
- How can I add items to combo box without using ";" in additem method
- Suggestions? Access formula for web query
- Online Technical Communication Survey
- I have declared an array Dim MyTables(14) AS Long and now I want to assign values for MyTables(0 - 15) = to the number of records in each table
- <<help>> Application in ver 2002 runtime vs. ver 2003
- Continuous Form Colour
- Cannot send ADO Date/Time parameter to a parameterized query
- access mysq - connection securityl
- Report Question
- help with a report..
- Boolean Field Properties.
- dlookup problem
- How do I evaluate the 'Count' for a report header, footer, detail??
- Pass string from form one to form 2
- Datasheet form - change column width, with a twist!
- Wrong Default Database Folder at Startup Automatically
- Linking and disconnecting from backend databases
- How to delete commented code lines ?
- Error accessing data from Access through Excel
- will REGEXP_SUBSTR work in MS Access?
- how can I sepreate infor. from one field to new fileds?
- Linked images
- Data Access Pages getting messages in browser
- Merging Access Contact Info Fields into Outlook VBA
- OLE Corruption
- Have Report Print to Specific Printer Paper Tray in MDE
- Design Question - Need suggestions for Creating Related Records
- Relationships in a database
- database records to excel sheet
- SQL Syntax
- variable question
- any idea for me?
- Query to flag a field based on calculated data
- Query to flag a field based on calculated data
- linked table manager
- query not retaining criteria
- Newline in String?
- DateDiff -1 problem
- opening mde file
- Why doesn't this code work???
- MS Access pages-problems with charts
- It's tough one!
- How to Pass collection between modules?
- Row-level locking Q. Front-end? Backend? Both?
- How to make API Browse sticky?
- store locator database
- Selecting Specific Dates
- Microsoft, the future and you
- Proyectos de Inversion en IT en la Universidad Tecnologica Nacional
- Why does ?2944*24 in the immediate window give me an overflow error?
- Allen Browns audit log - doesn't save the log
- event procedure update
- How to add records using Query
- Can someone tell me what is wrong with this simple query syntax?
- Help with Combo box menu item
- Text in Query/Numbers in Report
- Upsizing issues
- Conversion to adp
- Running multiple versions of Access/Runtime ... in Terminal Server
- SQL JOIN query - Inner, Left or Right?
- Dim'ing a var as Long, then assigning it to an expression that eval's to #NULL# - Is that a problem?
- Access query records to Word
- Can the Format$ function be used to format 42397136 to "42,397,136" ?
- Inner Join with a MS Access module
- Switchboard has disappeared
- Upsize from Access 97 to SQL 2000 Problem
- MAPI mail failure codes??? Where can I find out what failure error code 2 is? How about the rest of the codes?
- Unbound Combobox not displaying data as expected ... need HELP, please.
- Simplest way to read size of file on disk from Access 2.0 code?
- need help, not sure with what....
- Database Design Recommendation Sought - Objective: Reduce Sluggishness / Improve Efficiency
- From within MS Access, would like to 'roughly' estimate bytes of storage required by data in each table
- None of the wizards are working with Access 2000 on WIN XP HOME
- text box properties
- Color coding lists on sub forms
- Looking for pointer in right direction for a call center application
- forcing creation of parent before saving child
- Looking for cool/useful/clever examples of form usage!
- Multiple entries in one field
- Form_Timer alternative Access 2003
- combo pulldown ordering question
- Help with syntax for where clause
- how can I sepreate infor. from one field to new fileds?
- Linked Tables
- Access 2003 Web page for data entry....info and help please
- Selectively omit records from report based on date
- Calling a module from a form command button
- Incorrect data format after replication
- "Autonumber" for each line related to given record.
- Required field on a form
- When use a list, and when a lookup table
- El usuario admin ha situado la base de satos en un estado...
- table distribution
- how to show different values other than the first in a combo box
- DLookUp
- I want to implement ULS, one Q?
- How to update form
- Opening a form as read only
- Can't Trap combo box error when null entered
- how to group data in column headings in crosstab query?
- Scientific database design question
- Trouble with Simple Multi Select Listbox in Access 2003 (not so simple for me)
- Deleting records in table makes hinders data entry form
- Offline use
- Using SQL Triggers and Access Subforms
- Deleting records in table causes missing data in a form
- Deleted Records in a table, now my form is not working...
- List All Controls on an Open Form including other Containers
- Different tables on one report/form
- Need advice on how to confirm Access 2K Library References on atartup
- Export to Excel works - but manipulate the worksheet
- ADO: Why I use it
- first value of each itemid how ?
- subform programming question
- Linking modules to buttons in forms. How????
- Question about importing objects
- could not find the object 'MSysACEs'.
- This is an oldie but a goodie...
- Opening Access 2002 also Opens a New Explorer Window
- Square characters at end of string
- Textboxes, RTF2 and Unicode
- Acc2000-2003 wizards in design mode?
- Splitting an Access database
- Signing a Database Application
- Adding security to Access applications AFTER the event?
- Access 97 on XP send mail
- Time difference
- Multiple Instances Of A Report: Fighting Nature?
- Allen Brown's audit log code problem
- DBA HELP: Performane Tune SELECT, SUM, & CASE
- Access report print colour question
- File name in text export
- SQL Server
- Exiting subroutines
- If then Else in Query
- Dropped records when linking tables with Exchange mailbox
- Automate ODBC config to SQL Server
- Synchronisation nightmare
- Getting jpgs to Appear On Form
- Sorting Problem
- List Boxes
- Closing for vs Refresh
- RTF2
- Repopulate Listbox with prior selections
- Missing Semicolon error
- Microsoft Access corruption compact and repair
- VB Script to SQL
- I want to list saved querydefs having "tblCorrespondence" in their SQL...
- #Name? Error
- Access report will not print image header.
- Like inside Iif as Query Criteria
- Wanted: Book Recommendations
- Please Please!! One form with Info from Two tables
- Help with a report
- sub_report multiple (iteration) record display problem
- Lost back end connection
- Accessibility keys - form & report design
- Replace Function
- Tab Control
- Active Control trigger
- Print a report or form using filtered criteria from a filter dialog box
- Validation Rule
- Closing a form causes crash
- Access 97 Mystery New Record
- How to split one field to many
- 3 test collection is quite good
- Cumulative Sum in query is very slow...
- Access hangs after table grows to 12000 records
- Need help displaying text data for foriegn Key in form
- Tab Indexing in a Tab Control
- New user query.
- ODBC connection to Oracle tables in VBA
- How can I replace one word in a field
- access query info to excel range
- Help writing a macro or query.. not sure which!
- How to convert one string to another
- Saving / Modifying a ODBC connection.
- Applying filter to a subform
- Advice on Table Structure (Agencies & Sub-Agencies)
- How to Execute a statement from a Text..
- Uprotecting a DB
- Progressbar
- ODBC connection - faster or slower in MS Access/MS SQL Server 2000
- Inventory Help
- Compact Database on Close - Good Idea or Not?
- Access Mail Merge
- Access re-writes combobox row source query
- listbox bug?
- Too many active users
- Changing record before update
- Multi select list boxes
- Creating self referencing table from multiple tables
- triggering a value to be passed from a control on a subform to a parent form
- Populating fields on form from different tables
- Security required - replace Access?
- A 'datagrid' or 'table' in MS Access
- MS Access
- how to get the specified number of records from ms access database
- Splitting DB vs. linking
- query help pls - add totals of 3 fields with similar values
- Combine Records
- Opening a Document in Excel Format in Access
- Export a Table from Access 2000 to Excel - Error Msg
- How to clear out bad configurations from MyODBC driver?
- directshow not installed
- Identifying what was clicked
- Data Entry In Normalized Database
- Prevent data entry of Date Field
- Unattended Install using MS Office Access 2003 Developer Extensions
- parameters and Forms
- excluding records from a query
- Forms: Requery a subform from another form
- Access date/time range query
- 97 link to 2003
- TransferText method msaccess - Imported table corrupted
- how to set RowSource in MS Graph programatically?
- Jet4 SP8 installation process
- Assigning Openargs to a "Form" Variable!
- Conversion of 1.0 DB, to 97, to 2002, now to SQL
- Datediff
- A problem with RWOP Security?
- Combo box selection
- Filter Help
- A problem with RWOP Security?
- OpenDialog?
- MS Access blogs
- Reports
- Autofill
- New Guy with (likely) Simple Question
- calling MSDE functions via ODBC ?
- How do I write a query so if a field is blank it won't show
- Web services Error- Server was unable to process request ---> object refference not set to an instance of an object
- Password for backend
- Using SQL Server for Data Procressing
- ListViewRemember
- Excel Automation question
- updating null records in a table
- Updating JOIN and UNION ALL query
- Print Log problems
- Error message
- Error message
- Access 2003 - a system error happened or there is not enough memory
- Window size and positioning - how to define?
- Saving split database on network and local
- Grab HTML and display in form.
- Storing OLE
- Data member not found
- Unbound form
- Sorting records using visual basic
- Help With Sub Query
- How to sort table data?
- Audit trail question
- chart/graph issues
- Advertising
- Attaching a label to a BOX
- Bug in DateAdd Function?
- Access 2003 runtime package connection problem
- Disabling Design View of a Form
- Button Sequence?
- close form if query returns no records
- Access appears to hang when linking Oracle table via ODBC
- I imported a module from an Access 2.0 database into Access 97. Can I tell by looking at the code what must be changed to 32-bit DLL calls?
- Query through form with or without data specified
- What is the N in front of the string?
- How to limit concurrent users/logins
- Code works on design database, but not in work database (in the network)
- passing a string or building a string for testing
- Multi-user Access DB; DAO or ADO?
- Search Beta Test :secure login without Password
- Running Access 2000 on a PC with Access97
- Linking tables on data access pages
- Permissions
- Selecting a column without knowing its name
- Max of value
- Want more about vendor and simulation
- How to constrain a screen-dump to include only the current form...
- find duplicates between 2 tables
- Access Data pages
- Backing Up a Remote SQL DB as XML
- Report DLookup Field Filtering
- Access 97 - Multiuser problem
- Shell32.dll -- What's in there?
- Creating a simple standalone query
- I cut this example right out-a-the MS Access 2.0 help. I cannot get it to work.
- SQL in VBA
- Crystal Reports Export Format From MS ACCESS
- Using Array in Dlookup
- Saving VBA crashes system loses forms Couldn't Update Locked
- How to get user defined property value using VBA in .ADPs?
- Successfully opening a Recordset
- Which is faster in DAO under Access Basic (Access 2.0) FindFirst or Seek?
- Can all fields and contents be viewed in 1 window?
- Query Help
- How to remove "(text)" from a string
- When to use .MDE's
- Week no & period no
- ADO, adCmdText, parameters
- Sorting dates without yeats to get a birthday list?
- Appending text to number returns #Error
- Convert date to number and back
- Sort access database
- editing a record from an order form
- large mdb file
- ADO from within ms access
- Edit pdf document
- Stop Steve, the advertising machine
- Returning the path to a file in VBA
- International Motivation Survey
- Supercomputer and encryption and compression @ rate of 96%
- reading large text fields (ODBC direct connection to Oracle) in Access 97 vba
- XML Import Error: Too many fields defined.
- multiple join SQL query
- excel import problem
- Recursive code to create indented bill of material
- Connection problem from Access front end application to SQL Desktop Engine backend