View Full Version : access answers
- 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
- Subform shows no records when Main form is filtered
- Updating field before append query
- Converting from Access2K to Access2K3
- Database structure documentation
- no object in control
- Access 2000 runtime and record-level locking
- Uniqueness of pair
- Form's Large Datasheet Optimization
- Counting Up With A New Twist?
- A2003: Functional equivalent of Excel's "Freeze Pane"?
- Create database in Access 2003 gets Access 2000 formatted DB
- Using "DB2 Friendly" Commands in Access Query - InStr v. POSSTR
- Macro at Starup
- export sql results to CSV file via VBA in access(PLEASE HELP)
- Update checkbox on a Continuous Form
- sql query - case sensitive search
- RNG code request
- Understanding custom events (and the TSI Compactor)
- Format an Access 2000 Autonumber
- Continuous subform -LOOP
- access97 runtime chart
- help starting with access please
- Should Debug.Print be Remmed Out?
- SQL Question
- ADO listbox form navigation issue.
- Updating field when click'ing the record selector in a form
- Linking a CSV file with a DB extension
- autonumber question
- Fantasy League Database
- Update option button value
- One question about report
- Show more relevant fields on report
- Prizes Query
- Access 2003 co-habitable with Office XP?
- Access 2003 - Inserting A Quick Time Movie - Data Access Page
- Print 2 of Each Page in Order
- Report Blank When Cursor is on Blank Line?
- Test for common values
- Global connection string to Access Databse
- Inserting more than one object into an OLE field
- run macro from outlook rules wizard
- Access 97 on Windows 2000 Server
- Calculation-Continous form
- Running an Access app on Citrix via a published application
- Query returning "error#" instead of zero
- repeating a record x times in a query
- How to test a bit in an integer?
- Related Subform causing duplicates?
- Join several tables in one query
- How to edit a non editable field ??
- FormFilter > ReportFilter
- Erratic behavior in combo box typing completion search
- Bit fields with Access97 and SQL2000
- Export to excel & format workbook
- Move file after import
- Context-Sensitive Access Controls
- Setting page heigth
- Alternate Record Printing Between 2 Reports
- Stop Importing of Tables without RWOP
- RTF word count?
- Packaging Wizard Root Directory Orca
- Access 2002 security
- "The OpenForm action was canceled"
- VBA and Reports
- Not recognizing multiple conditional actions within Macro - Help, please
- Access Datasheet - Subdatasheet question
- Autonumber of new record
- Show Menus/Toolbars on Startup
- Database documentation
- ControlSource and saving to table
- Using an OLE DB Provider's Functions in Code
- authorization at the beginning of transaction
- How to get a Gmail account
- HELP with date sorting in reports
- Binding controls to recordset with join
- combo boxes
- Open Excel from Access
- Domino VBA
- Domino VBA
- "Disk or network error"
- Allen Browne AutoFilter
- Form Help
- Access 2K MaxLocksPerFile
- Call the "Mail Recipient (as attachment)..." toolbar function in code
- print query name
- Error trapping ignored on second pass (DAO recordset duplicates error 3022)
- WindowsXP and Access97
- Future date displayed in a table
- Update append queries?
- Need to decompile to resolve references problem to mda
- Passing Data from One Form to Another-Simply
- It is Possible to Open A DBF File in Access
- Sorting Multiple Entries
- Resize OLE object
- Make A2K3 use standard Windows menu appearance?
- report parameter
- Stored procedures
- Access .ADP and Terminal Server / Citrix. Suggestions Needed.
- Startup, Tool Bars, Menu Bars, Shortcuts, DB Window, etc
- Problem activating macro within a form
- Adjust the heights and widths of multiple subforms without additional controls
- Form Unload/Close Randomness
- 2k Master/Child Not working in 2003
- conversion to 2003 and replication
- RunCode macro
- Importing from Excel, merging fields and Formatting
- passing subform argument to function
- importing form source code into access
- Query - possible to choose between 2 fields?
- Subform
- Access version recommendations?
- Storing updates?
- Access 2000 project connections
- Adobe Acrobat Install Kills Access Tooltips
- Nested query of sorts?
- Outer Join, cannot update issue
- calling a calculated field from subform to form
- Access' dStDev vs Excel's StDev?