View Full Version : access answers
- Autonumber
- Report size
- Add rows to top of existing spreadsheet
- Relationships decision to be made...
- How do I find the MSAccess.exe file path??
- Read dBase IV
- Looking for matches, adding to match table
- Form/New Record
- XY (Scatter) Chart
- notepad file to ms-access compatible file
- Multiplication formula
- OLAP Problems in Windows Environment
- Code for controling FTP from Access VBA
- How can I interact with MS Access using a programming language like Perl?
- Help with parameterized queries
- Reading Global Address List in Outlook (CDO)
- submitted data not updated promptly with ms access
- I need help w/ Queries
- Date Query?
- Login in form text fields are filled out..
- Printer properties
- SubReport on Main Report Page Footer - Didnt think it would be so hard.
- Hide Duplicates flag?
- Access / ASP hacked insert
- Select query that won't run as Update query?
- Can A97 Be Installed On A WinXP Machine?
- How to work on home laptop, then update client's Front End?
- Comparing one date against a list of dates
- CutePDF. Pass file location?
- RegisterDatabase for AS400
- Open source "Tanning Salon" Application
- filtering the last date
- Using an SQL statement to convert date format where the field is NULL???
- Listbox: Use SQL + constant text string to assign values
- Total Access Analyzer?
- splitting text into characters ... HELP ME SPLIT
- Looping Query Defs
- Problema per creazione Rubrica...Help me!
- almost got the mail merge to work one problem
- Thanks for help today - new problem with recordset
- no read permission
- Run-time error '424': Object required - can't work out why
- Select multiple date fields from one table
- Picture on page
- IsNull() - I can't get it to work properly..
- The EXISTS operator in A97 SQL - I cannot find documentation on it in A97 HELP
- A97 SQL capable of showing data from 2 different table records in a SINGLE output record in dynaset?
- Dynamic Crosstab Report Problem
- Change Caption Of Label In External Database
- Changing table permissions in VB Code?
- Using a picture (Form Template) as background in a report?
- A97 query question
- Snapshot viewer and Access 97 reports And Emailing
- Database Permission Question
- Text Box and 255 character limit
- The .Value of a Check Box
- Removing Items from a Listbox with Multi-Select enabled
- Adding Excel Object Library Reference Programmatically
- UI: Combo Box Max Records Recommendations?
- Update Query
- Creating self-join table
- disabled startup
- Globals and system instability
- Random Number in Query?
- report page layout help
- autonummering in table gives problems
- Autonumbers: Retrieve unused no's
- how to skip runtime error
- Printer Orientation and PrtDevMode MSDN example not working
- ORDER BY a SubSelect?
- Database creates another file when first opened? What causes this?
- help with update table
- Access 12 screenshot (my style)
- Relationship Link
- Run-Time error 3146
- DoCmd.RunCommand Equivalent for acFormBar, 7, 6, 0, acMenuVer70
- Using Vendor ActiveX Grid in MSAccess
- Set myTableDef = myDB.TableDefs(myTable) is so slow ....
- is stupid
- richtextbox loadfile problem
- Public variables reset on error, what's up?
- Find Primery Key
- Linked images don't refresh
- Pivot-Table Form vs MS Graph?
- Access Database through ASP
- Run-time error..
- Type mismatch error
- Compact a password protected MDB from a front end MDE
- Find and Replace special characters in a field
- How to stop an Access form from automatically saving a record?
- Formal Complaint
- Need a little guidance (beginner)
- Rename Table/subform Field Names
- OLE OBject Source Doc
- Linking table/query SQL
- Access Report
- How to check the status of a sub form
- Check on empty record set in VBA
- How to Lock the Page Setup in reports
- Display One-To-Many records in a Mail Merge
- Enter control
- Conversion to SQL Server backend
- Open images after double clicking them on form
- Custom table property to prevent overwrite?
- Moving a text box in a report at runtime
- Rotating label text in A97? Is it possible?
- error message 3343
- How do I write code to allow user of a runtime distro to select a DEFAULT printer?
- Input Parameter Query Window - Duplicated?
- problems compiling with Listview control
- Unable to create new records on linked tables over network
- Mail Merge Access 97 and Word
- Sum Subform Records in Mainform contol
- How to break out of loop from error handler?
- Sorting report by Quater
- Update Table
- Expression error
- Need Church database for small church
- Select top on 2 tables based on date?
- update, append query Joins being deleted.
- Unable to make form visible again
- export temp table to text file user side
- Users being locked out, unable to open file
- Application.Version
- Access 12 screenshot
- Help with DLookup
- DLookup return date from database
- CreateReport(, templateName) not coping report properly
- How do I restrict my results?
- Body for e-mail
- Reconcile Query Wizard Add-In For Access 1.2
- SQL Help (Please)
- Playing Sound Clip
- comp.databases.ms-access
- Strange behaviour on startup when project is signed
- Open a 2nd form from a 1st form and keep the same rs and current record
- database worksheets?
- Access help!
- USING DLOOKUP TABLES
- RECORD LOCKS
- UPPER CASE
- csv export file and international settings
- Query With Many Checkboxes
- Need to send a directive to linked database
- Like Clause
- rolling average
- Access on the Net ?
- What Access Runtime files are needed to deploy? (2002/XP)
- Please help: How to concatenate fields in querie??
- Columns
- Hoogste waar de in een kolom
- Problems with HTML Imports
- MyControl.text in form without record
- How do I disable automatic save of my project as I build my database in access?
- lost mdb
- Sorry ....Using Access 2002 object lib. in Access 2000...
- Using the 2002 Access Lib. in Access 2003 .....
- Table Index Construction
- An NT Security Gotcha that looks like a Jet Security issue
- Requery a subform from a lbo - how?
- Help with validation feature`
- Function to return quoted value?
- Postcodes
- Using data from one Access database in another
- security: user level vs. group level
- A97 - I cannot prevent Access from changing (c) to a copyright symbol when typing into a memo field
- Does not import all data?
- PDC2005: Anything new for access?
- ldb file and Exclusive Access question
- Condition Format in Multiline Textbox
- Multiple Date Ranges in a Report
- Check to see if a button has been clicked on a form
- Union Query and Filter By Form, Access crash
- Remove dash from soc sce #
- Finding a specific record
- public variables
- No Current Record
- SQL multiple statements?
- Access not working (can't query or create report)
- Help with Report Design
- MSAccess query error
- A97 - 5 records in a recordsource query cause 5 pages to print out
- A97 question regarding closing a report
- docmd.openform where condition problems
- Changing a Label Caption in a report
- Conditional Format With VBA
- Keeping empty subreport visible
- Very basic problem
- math problem with dates.....
- Exploring use of Dir("\testdir\nul")
- Looking for users of a niche product
- modified snaking columns
- ODBC--call failed
- Access Runtime/Access Full Version
- How to transfer *.dbf (many files)
- listbox in endless form
- Manually changing a linked table location
- How can I set value in function that returns array?
- How to remove last digit for inputted value?
- Appending records to a table from a form filtered recordsource
- Using Code
- report errors
- report error
- report error problem
- report error problem
- Print Tree View
- Help Needed With Corruption Problem
- Using Unbound Textbox as parameter
- Font Size in Query SQL View?
- A2002: Activate Event
- Security settings for downloaded databases
- Hyperlink
- Issue with Make-table query - Will this HURT?
- Autonumber Oddity
- Synchronize SQL Server with Access MDB?
- Help with filter
- Converting positive number to negative number
- I wish to rebuild all A97 tables from scratch - whew! Prefer to automate task.
- concatenate two records in same table
- concatenate two records in same table
- Problems with Date conversion from text format into date/time...
- How to remove Lookup property from table field with VBA?
- shorten time to attempt to connect to back end
- OnNoData
- UCase not working in A97 runtime installation...
- 2 questions
- Linking Images using VBA code
- Conflict with Webroot's Spy Sweeper
- Intermittent missing reference problem
- Decimal places.
- Credit card number rounding?
- Output Stored Procedures as text problem
- Unable to set subdatasheet to None
- Error "You don't have the license required to use this ActiveX control"
- problems dealing with dates in my queries/SQL code
- Partial Replication of Data
- Access 97 and counting the occurrences in a string
- Reports opening differently on client/my machine
- Email reports?
- Searching a Field containing OLE Objects Returns Inconsistent Results?
- Adding to lookup list automatically
- Help with error message
- SQL - JOIN or nested query?
- Refer to class-properties (A97)
- Linked tables in a query giving no results
- Linked tables in a query giving no results
- Managing controls on subform
- How to unhide a specific form or database window in A97?
- A97 closes down each time I open a particular report. Anyone know the meaning of this?
- Access Developer's Handbook 2002: Tagged Values
- Problems migrating to XP
- Looking for a copy of ODE97
- Update foreign key before appending records to central database
- ONLY NUMBERS
- How to read .iif file of Quickbooks using vb or any code
- Themed Tab Control work-around
- combo boxes
- default value taken from other filed
- How to read .iif file of Quickbooks using vb or any code
- no data on a form
- SIMPLIFYING WORDS IN A TABLE
- Multiple Record Copy Transaction...
- time attandance system
- Embedded Images
- Concatenate 3 lines of text into a "Paragraph"
- Stored Procedures?
- VBA functions to create a PDF rectangle with a shadow
- Problem with form
- Help for C# Interview questions and career decision
- joining queries
- Code for finding name of relationships
- How to programmatically determinae the field name referenced by query param?
- Automatic backup's Access 2003 database
- Change a lot of words in a table
- DCount.
- A97 error #3067 occurs when it really should not
- How to fill a for automaticly(just some boxes)
- I need a personal code library
- Null Values or Wierd Behavior based on a user's profile
- Form for 2 tables
- Alternative to lookups in tables - questions
- Transactions for linked SQL Server Tables?
- Saving ODBC SQL database to "local" mdb?
- Include word doc(s) in report
- Data Access Page problem
- problem - open recordset - ADO
- question about % in reports
- DAO 3.51 and DAO 3.6
- Access Treeview - Is it Safe Yet?
- MDAC
- How to use parameterized query with DAO Recordset?
- Change Focus triggers Before Update
- PostCode-Zipcode
- compare tables
- Linked Tables, access security help.
- "Too many Fields" error running query with <255 fields
- Use not local admin Outlook Fails
- ie 6.0 and Access2k
- Understanding ODBC connections...!
- Using nested subform
- Linking Tables in Access
- A97 - How to automatically export a table to ms excel data-file from within code?
- Invisible Query Head-Scratcher
- numeri
- Upsizing
- How to supress message when dynamically setting Report recordsource
- Problem deleting ldb file
- Foreign Key with multiple columns and null value
- exporting access data to excel for calculations and reporting
- Unlock/edit a database...
- Like criteria
- requery a subform on a form
- Generating an Index
- How to get a query to pick up the value of the active form
- A2003 Backend opens in read-only intermittently
- &Relationships Bug - workaround
- How to set Startup Properties in MDE?
- In trouble! Db locked with exclusive access
- How to put controls on a form with VBA code
- If a field is keyed in, then delete other fields
- setting fields based on values of other fields
- Table Structure - Using Query with Form for Input
- compare two tables using this module?
- Ordering fields in query based on current date
- How to send emails from ms access..
- Modems and Access2003
- How to parse CITY ST ZIP+/-4
- Allowbypasskey property
- Append to master replication table
- Open a DB from the switchboard of another DB
- Only add Valid Payments on a Report.
- Calculate Number of Years, Months and Days between 2 dates
- Oracle 9.2 attached table real slow and data incorrect with Access 2003 SP1
- Lock an access db
- Printer / Report issue with Office XP over Network
- Can't Import a .dbf File
- Default combo box line
- Setting field properties in code
- REPOST: Unique connection ID not name.
- Creating new field in code
- Using combo boxes to fill in other bound controls not working..
- restoring default printer
- Trouble moving Access tables to SQL back End
- Enter Parameter Value showing up when already defined
- Assign textbox value from command button
- How do I refresh a control
- How to handle with "&" in text
- A97: MediaPlayer.MediaPlayer.1 control on a form - how do I use it to play a .wav file
- A97 - I've been looking for a position counter to display on a form the current character position of cursor
- Payroll DB
- Won't let me remove tables
- A97 overflow error returned when trying to calculate 192/(24*60*60) - why?
- A97 - how to format time lapse to appear as "4-minutes 12-seconds"?
- combo box choices
- How to speed up reading input from a text file?
- Split master table into smaller tables
- DoCmd.SendObject acSendNoObject Inserting Hyperlink in message containing a space.
- Need help to read database contents - very tricky
- How to Update ignoring validation rule
- A97 variable length string declaration - how to do?
- check box changes subform operation
- acCmdInsertHyperlink defaults "Browse for" File
- Catastrophic noob... can anyone help?
- ComboBox source query: run at Form_Open
- Access hanging periodically
- How to display multiple pictures per record in an Access database?
- Cancel Click Of Check Box
- 'Invalid bookmark' or 'database engine stopped the process' errorswithout corruption?
- Unique connection name?
- Mixing two Image samples by Lebans
- Access and vba in excel
- FE & BE Version Control Tips?
- Determinaition of Paramatric Queries
- using query results to populate a list or form
- Combo Box - NotInList Event - need help
- How do I link a control to the value in a form?
- Help needed w/Crosstab Query and Col Values
- Finding the current computer name in VB?
- AddItem not adding columns to listbox
- How to compute age in a query?
- Simple question about Cancel Event
- Accessing list of files from disk
- MDE Don't work
- Preparing for .NET Interviews
- How can I run an insert query on report
- Second Request - Can I return a value from an ACCESS report to VB?
- OpenRecordset & 3027 read only error
- Set a variable equal to the result of an sql query
- Question about moving Access app to web
- format for naming recordset field
- Display a report in a form...
- Determine if user has local admin rights in VBA
- Please Please Help!
- Find how many similar records..
- File already in use
- Problems Subclassing in Donors/Donations DB
- How to use static variable to exit function?
- How can an AutoNumber field start at some other value
- Put four queries into one
- Using combo-box as a user filter - trying to use format to display text "all" for null values
- Effects on RST in Calling Proc
- How to influence two tables with one form
- Access 2000 date range using today's date
- Build comma-delimited list from table
- Outlook mailitem
- Evaluating Complex Recordset Field Statements
- Compute Name , Is it a good idea to use it for copy protection?
- Predifined text and starting from the last record(in a form)
- Does ACCESS have the MINUS keyword
- Form_Dirty is not firing
- Parameter Query and Date calculations....
- Slow Update Queries
- Check box controls subform control source formula
- Subform not allowing creation of new record
- user permission
- MS Access Database with Remote Desktop - Multiple
- Error trapping code
- A97 - How to preserve eMail addresses pasting contact info from MS Word doc to A97?
- converting ACCESS to Stata using Stat/Transfer
- dirDataCopy error message when converting to Access 2000
- Comverting Dates
- Left Join Not Supported - translated from legal SQL statement
- Tables Queries Criteria oh my!
- Transferspreadsheet File Name Limit
- Tree view adding duplcate keys
- Is it possible to open an Access Macro as a recordset in VBA code
- VBA to Word problem
- Running code in one form from another
- Duplicate query recordset
- Lock Down Titlebar in Form
- Keywords
- Access 97, XP and 3170 Couldn't find installable ISAM
- Full menus
- Trouble working with not between
- mail merge
- mail merge
- mail merge
- Importing Excel Spreadsheets Into Access 97
- Date format cannot be controlled
- Date format cannot be controlled
- Problem with inner join
- Set and restore permissions using VB?
- Calculating the dwell time between two Records
- Control format property in OnFormat event
- Can A2k co-exist on a Machine Running A2k3
- edit word document
- How do I refer to a series on an MSgraph in access?
- Concatenating text fields with a WHERE condition
- Anyone use Visual Studio Office Dev Extensions?
- How to open default email program when I store some email addr. in a field?
- hiding record navigation button in forms
- raport and null problem
- IIf Function based on field value of continuous form
- TransferText
- Drawing objects in Access 2003 - can it be done on forms?
- delete all text starting with ..
- Help with counting occurances of similar text
- Before Update
- Help with an SQL query (opposite to a union query - if it exists)
- File Not Found error when importing forms from another database
- Adding Incremental Records
- Date Conversion
- running an update query from form...can I just use the sql cmd
- subform question
- backend corrupt
- Handling Apostrophes
- can someone tell me what I am missing with strings
- Need check box to change formula used in subform source
- Combining two queries
- Display one to many records in a mail merge
- I used to see a menu item/short cut menu to translate macros to code
- locking down tables
- Blank Form
- Adding a column in report
- Help with simple database concept
- Open the Outlook Addressbook in VBA
- Exporting To XML File
- AppHelpFile key and context-sensitive help
- Tab Form and 'cannot open more tables error'
- Report in Table Format?
- Help with VBA syntax please
- New Access / SourceSafe Bug Discovered
- Query Corrupted? - Access 2002
- Need help writing a double click event procedure
- Attaching Document
- Memo field not large enough
- Creating ODBC Data Source automatically?
- how to check list box
- Need help parsing a string - reverse Val?
- Check box changes formula used in subform
- how to open code builder for default when click on event builder in forms
- Export Query To XML
- Form colors in Access XP look goofy when converting
- Importing Excel
- Displaying and modifying 1:N data in forms?
- How to delete the missing References for VBA
- Some fields of a table are not visible in the design view
- Accessing a Report properties without opening it
- Option Button bug?
- Control Reference
- Aggregate function error
- Arvin Meyer's Good Article For Beginners
- Elookup vs Dlookup, Error 3048
- ComboBox using SQL code
- Migration to Postgres
- Front end grows when saving
- Cannot Delete access file
- [ODBC] How to compact a base ?
- continuous form buttons with different images (from table)
- Pr4int Preview Vs Print
- Help? Subdatasheet bug 'You can't hide a control that has the focus'
- How much to charge
- Missing references in VBA code
- Missing references in VBA code
- the form jump after a AfterUpdate Event
- How can I disable a reference library with VBA code
- We aim to please
- How do i hide a group footer if it's the only group?
- Database as Variable for Param query
- Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
- Protect MS ACCESS DATABASE
- Trim/Remove Unwanted Spacing In Text
- Linking to an external library with VBA code
- How can I concat the name of a control in a way that I can refer to it in code?
- Read Outlook emails using Access
- Anyone wrote VBA for calc'ing determinant of 3x3 matrix?
- Combo Box Display Problem
- posting 20050827
- repost calling a subform from another form(not main form)
- calling a subform from another form(not main form)
- How do you boot connected users from your database ?
- Repost : Reading a Text File
- Wont find infomation from table
- Verify Jet SP
- Sort Is Not Working
- PDF
- Requery
- Queries/joins with more than 2 tables
- generating sequencial numbers
- Concatenate text fields in query
- ER diagramming wish list: send a request to Microsoft
- Microsoft Scripting Runtime
- Problem with my chart in MS Access 2002 using a form and VB
- opening and closing IE
- Combo-box not displaying all entries
- Weird parameter prompt appearing after creating a subreport
- how to print (or not) the contents of a textbox in a report
- Embedded Pictures
- record lookup
- postcode finder, lookup,search