View Full Version : access answers
- 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
- Need Help on MLM database in MS Access
- Crosstab query
- Access Report using Grid
- Please help - Post Code Search
- Access 97 event logging
- Need help locking fields. MS Access 2000
- Text versus Number field.
- Date calculations
- 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
- Convert a sum in a report from a null value to zero
- Isolation problem
- 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.
- lier un fichier texte avec des dates
- Right-side blue panel 'Open' list: how to delete a filename?
- 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
- Online Technical Communication Survey
- Suggestions? Access formula for web query
- 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
- Using SQL Triggers and Access Subforms
- Offline use
- 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
- Automate ODBC config to SQL Server
- Dropped records when linking tables with Exchange mailbox
- 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
- Applying filter to a subform
- Saving / Modifying a ODBC connection.
- 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
- Shell32.dll -- What's in there?
- Access 97 - Multiuser problem
- 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
- MS Access database shuts down
- In Access 97 and Access 2.0 applications, if a command button has the focus, the spacebar will 'PRESS" the key. How to disable this?
- Updating a field in a current record
- Condition with an Else
- External Source Control of Basic Modules in MS-Access?
- Was there a way to run a FileExists check from MS Access 2.0?
- converting MS Word document to MS Access?
- Recipe Database
- UnitsToElement
- Problem installing Access 97 with Windows XP - "error occurred changing the workgroup database"
- Combo box jumps to values when duplicates
- Send to rpt before moving to a new record
- Subform datasheet selection
- Having Zeros Appear
- Problems with TransferText
- Network load
- Access 2000 - Open external table
- Distributing Jet database engine
- Openings in an online game company for database people
- MOD function
- Formatting Dates
- Mouse Wheel in MS Visual Basic window (in Access) stopped working!!
- Formatting Dates
- Formatting Dates
- Use Windows ImageList for program icons in treeview control?
- Build string variable
- MDE file shareware?
- Att: PC Datasheet - Please readf inside
- Turn off default menu bar
- fastest way to determine if any records exist in table?
- Problem with report trying to Duplex
- Convert .ADP to .NET?
- conditional on a form already being opened
- Table Allocation
- missing records from coded recordset when compared to qbe
- Running script before import
- Network resilience registry key for MS Access?
- Automatic update from Oracle db to access db
- subreport control reference problem
- DAP problem
- Using the Docmd to set another forms detail.visible
- Two multiselect listboxes
- Two multiselect listboxes
- access question / forms
- Text Box Values
- Create Access 2000 MDB from Access 2003
- Looking for help with Runtime Error
- How can I tell if file on linux box is moving across my LAN?
- Using GroupBy, Min, Max, and Count in the same Query
- Missing Query
- Download Code from an Internet Page....
- Conditional formatting problem
- Open WinExplorer from Access VBA ?
- Pictures in Reports
- SQL Backend/Access Frontend
- Access 2003 Edition
- Group Level Count
- SQL in VBA
- Problem with disconnecting
- Modifying subform makes query vanish
- combining duplicate data onto a single record
- 1:M with queries
- OpenReport with acDialog parameter
- Event Caller Question
- Break Default VBA Reference
- Syncronize two copies of a database
- Date() function problem
- Aged Debt grand totals in SQL
- Beginner Question: DAO vs. ADODB
- Variables in standard modules, single record entry wiht foreign keys
- You have a piont...`
- Excluding Previously selected Combo Box record to current Combo Box
- publishing a MS Access Database under one of the open licenses
- Access report totals
- Totally confused about Access 2003 Runtime availability!
- Where IIf and Datediff Statement
- Sharing Access *.mde file
- Subform calculated control
- Automatic Links in PDfs created from Access
- gotorecord help please
- Duplicate Records in a form
- mousewheel events?
- Counting Records
- Update one tab from another
- Newsgroup etiquette...
- AS400 connection AGAIN....
- Calculate totals from nested forms
- Updating a subform using a query
- Multi-User Access Database
- AllowEdits=false and OnKeyDown event
- Creating an Attendance Report
- Show more relevant field
- Scroll wheel on mouse
- How to call a function located in a form module (form open in form view) from an Access Basic global module?
- Timer events that must occur
- Excel automation weirdness
- Track Design Changes
- Help with Syntax on Webpage
- How can I find all instances of "tblCFClientChanges" in an Access 97 database?
- A2003 Help Font Size
- record template
- Accessing a non-primary key field from one table to another
- REPOST: Access 2000 runtime and record-level locking
- Accessing a non-primary key field from one table to another
- Accessing a non-primary key field from one table to another
- Accessing a non-primary key field from one table to another
- Fill from Combo Box Selection - Speed Issue?
- Follow up: Using Access+DBMS with >30 users
- Using Access+DBMS with >30 users
- merging tables/ deleting holes
- Creating relationships using VBA
- Table relationships and join type
- Autonumbers
- Rich Textbox Control That Allows Formatting
- Using Access+DBMS with >30 users
- Combining data from separate databases
- How to combine separate identical databases
- Direct location change
- Help with DConcat - Please
- Average by .25
- SQL Problem - Auction
- Counting group records
- 1 to many concatenation help!
- Date source location
- retrieve only part of text string
- AS400 connection again...
- Internet access behind win xp sp2
- tabbing out of a subform without knowing about the parent
- connect to AS400 using ADO...
- One backend or two?
- access database query HELP!
- Printing a photo from my form - Access 2003
- Select query truncates memo field
- Default
- Printing only the last....
- Problem retrieving printer information for this
- Starting Access program
- Incorrect Date posting Access 2000 SQL statement
- Help with opening form
- Access does not break on errors?!
- Best way to repair corrupted VBA code module?
- Print Log
- Creating a custom right-click "add then paste" item
- Form - won't allow input or new record
- Problems connecting to external data source
- dummy databases?
- Anyone still not upgrading from 97?
- ColumnHeaders
- setting CurrentProject.Connection in VBA
- Combo box behavior on continuous form
- ColumnHeaders
- Shared access to Database
- pass-through queries and parameters
- Cancel external process using event?
- Code is Wrong?
- Not getting value for second combo box "with" statement & Dcount help
- Help with Max Date please ...
- Converting Access 2003 to Access 97
- Can't open database
- Cannot find Macro '.'
- Help with... er... not sure how to describe this
- Sychronized Combo Boxes - Mystery of Missing Values
- Changing Access Charts Using Combo Boxes
- When is "db.close" needed?
- Help with automated sending of report
- Find Records with Max Date
- Problem with ODBC open dialogs under Windows 2003
- Import Specification Help
- sub totals in query
- How to combine Queries
- Parameters Not writing to table
- Textbox Value to Excel from Access
- Automate get external data to import a XML file.
- Opening forms with arguments through a Menu item
- form image background and tab control
- Help! - How can I make a calculation using a previous record?
- ComboBox Wildcards???
- Printing hyperlinked Word doc automatically with an Access report.
- Help constructing a query
- mde/ade security
- closed database
- edit a read only access form
- change lines to columns
- Remove Microsoft Access from task bar?
- Simple relationship question?
- Linking multiple tables alternatives
- autoexec macro for application access not a database
- Active X Textfile Layout Control Misbehaving in Access 2003