View Full Version : access answers
- Refresh on mainform/subform
- Maximum length of an If Then line in VBA
- Is it possible to specify a specific printer in the vba code?
- Is it possible to specify a specific printer in the vba code?
- Dialer in AccessFAQ.exe?
- Continue to lock record in main form while editing subform records
- two nested select statements
- Faxing Reports on the Fly
- String Manipulation
- Systemically OutPut Access Report To PDF
- Wierd error when editing an Access Memo field.
- LARGE report problem
- Scrolling problem with php web page - problem with IE or PHP?
- How come I sometimes get this?? "Run-time error 3211: can't lock table. "
- Synchronizing Table definitionns in one mdb file with those from a second mdb file
- How to compare fields from similar tables
- Works to Access
- I need HELP with error "Too few parameters..."
- where can i find a script
- How to convert php script to access
- Design Question
- is the byte on or off
- Programatically Enter Data Into main Form And Subform
- printing odd pages of reports / duplex printing in Access 2002
- Filtering text boxes from two comboxes
- Filtering text boxes from two comboxes
- Reset Field Autonumbering
- printing subforms
- update to second table?
- Division in Access does not match Excel.
- OPTIMIZING A FORM?
- DAO problem in Access 2003 - Can't find .Edit method for recordset
- MSACCESS.exe process does not stop when user exits Access
- Help: Using a Checkbox to Control a Date's Value
- Query based on form parameters
- How to go through a bunch of text boxes in a form.
- What's the best way to do this in Access2000?
- Continuous Form locking after sorting
- Why can't I use Database object in code?
- Make active page name on tabbed form BOLD - A97
- Any suggestions
- Disadvantage of Access as front-end
- how to force form to load in datasheet view
- what event is fired when you move to next record in form
- Duplicates
- A validation rule question
- database for internet - compacting
- Need help with validation rule
- 2 quesitons about forms
- report rowsource query
- Mailmerge problems - how to solve?
- Which Code run faster in MS Access SQL or DAO
- How do I time out (auto exit) an MS Access 2000 application if no activities after a certain time?
- Rectangles on a form
- query problem - recordset not opening
- Processing Fees based on Percentage
- XML-Import in Access2002
- Can't change data in query after adding table
- What is the best setup program generator for a commercial Access application?
- wifi hotspot directory available in MS Access format
- You'd think they'd have used ...
- Format a report with rows and columns
- Parameter query via value in form - driving me mad
- The visual basic for Applications project in the database is corrupt
- Adding Item to Combo Box
- Time isn't on my side
- Programatically Enter Data Into Another Form
- Copy data from subform1 to subform2
- Run Macros without MS ACCESS loaded
- Auto Data Entry
- split reattach code question
- Beginner Help Again - Queries
- Update combobox from table.
- Help needed with databases + asp problem
- Weird actions after upgrading from 2.0-2000
- Shareware documentation?
- FROM RELATIONAL TO FLAT
- Custom message box on NotInList - don't want to add new value
- Open Form WIth Calendar Control To Specific Date
- Report Layout Help Required
- Subform OnExit Not Enough
- Passing Value from the form to a report query
- Line 1: incorrect syntax near '!'. in a macro with asp
- calculating totals in a query
- ADPs /// idull thoughts
- Questions about Reports.
- Problem with Queries and Cartesian Product Joins
- Highlight the background color of data on conditions
- Limited Characters in a Text Box
- Reference Menu Captions in VB
- Dsum Use In Query
- Filling in null fields from previous records
- Forms in Access
- MS Access to vb.net/ASp.net migration
- Entering A Transaction
- Pasting records in Access front end using MySQL backend
- Access2000 database on the internet
- how to improve the speed of reading from access using dao
- 'Allow Additions' Causing Unexpected Results
- 2 tables 1 with duplicates
- Automatically populate foreign key in query?
- Simple Access 2000 Query won't work in XP
- editing entries in a table using textboxes and a listbox
- Need some help fixing my UNION statement
- Upgrading to SQL Server
- Text File Export
- archiving
- Download Access templates
- a2k - implementing simple popup form to main form
- PivotTable and recordset
- How to Link MS Access Report in VB
- query help
- Horizontal Report problem
- Databases for translating English-French and English to Spanish
- select aus einer Tabelle in ein Textfeld
- Seeking freelance programmer for simple project
- XP - 97 lockup
- How do i set up a query?
- Filling null records with previous value--loop?
- Acc 97 .Bookmark Property
- Access 2000 Calculations
- GTRR; If no Related Record, Create New In 2nd Form
- Row-level security and MSSQL
- GTRR; If no Related Record, Create New In 2nd Form
- ACCESS 2000 - bad input
- Make Table query on ODBC table changes NULLs to empty strings in Access 2002
- Remapping the keyboard up/down arrows for tab stops
- Need a Search String Routine
- Wierd Query Question
- Display automatic update field on a form without being able to edit
- ** MS Access support in Unix ? **
- Opening Backend DB faster
- HELP
- Can access tell me if I'm using a table or query?
- Call Database in ADO For Table Linking
- Powerpoint from Access problem...any ideas?
- I need help from VB/VBS experts: exporting Access OLE object (Word document) to a file
- Finding near matches
- Assign values based on Count(field_name) in query
- Server.CreateObject works on IIS 5.x / WinXP Fails on IIS 6.x / Win2K3
- The Year() Function and Update Queries
- date format problem
- A2K db is read-only for the others
- Automaticall linkin external Paradox tables - based on the pathnames.
- Using AllowSpecialKeys property
- Sub report
- Null values in a query
- Wie kann ich aus einem Formular aus Daten selektieren und in ein Textfeld schreiben?
- My FE updater - whadya'all fink?
- Subform Form.RecordSource inconsistent?
- Basic question on database size - does an empty row take up space?
- Beginners help for Mail Merge
- Correctly sum a column of currency in a report -- rounding issues???
- Cannot Set Bound TextBox Value
- Need Assistance with Error Handling
- HELP!: "Object doesn't support this property or method"
- Access database for rental properties
- Hyperlinks don't update with new record using VB code: Access 97
- Data loss in Access-97
- Hyperlinks don't update with new record using VB code: Access 97
- Problem Setting Value
- Problems with Setting Value
- Items included in one list but not in the other
- Online Performance - Snapshot Viewer
- need help on simple(?) query
- Singling out fields on Continuous Forms
- built-in filter functions failing when form recordsource is set to recordset
- Menu Bar Has Disappeared - Can't Get It Back
- Timestamp - Digital Signatures
- Filtering form by combo box
- Timestamp - Digital Signatures
- Simulate "Circular Queue" structure
- Problem on a report..,?
- Full Email Address Outlook Access
- Access 2K - Read-Only Forms
- Trying to combine Two queries into One Query.. Need Help!
- Function to determine if form is loaded returns strange value
- ADP Test (Multi-Posted)
- Menu callback function in Form's code module
- Count query - how to use the result in VBA?
- 1 x front end & 3 x back ends
- Global Variables and Terminal Services
- Addition von Zeiten
- Licensing and availability of VBIDE
- Accessing MS-Access from Solaris and AIX
- Filtered by form - differences between totals.
- PFS Professional File System 2.0
- How to add long items and scroll bars to combobox?
- Next / Previous Record Buttons
- Changing rowsource when dropdown the combobox
- filter adp report where record source uses aggregate functions?
- Access 2000 - Field Color Changes
- Need to return latest record when there are duplicates
- Combobox lookup function gives syntax error
- Page Break in Report (Access 97)
- Subcategory lookup tables
- Please Help With This Access Question
- distinct + sum
- one to one relation
- distict and sum
- Limit result set to top 10
- Are Access 2002 and 2003 compatable
- Access 20003 and 2003 compatability
- populating a combobox
- Excel automation causes runtime error 1004 on second attempt
- NORTHWIND questions
- Is access suitable?
- HELP...Exporting/Extracting an Access OLE object (Word document) to a Word document file
- How Do I Transfer Data From One Table To Another
- Combobox Question
- Mouse Wheel Subforms (again!)
- Ambitious report idea......... "Favorites"
- cdo scheduled task runs as user1 but not user2 ?
- select aus einer Tabelle in ein Textfeld
- Update query help
- Searching for connecting access to the web
- Resources for intermediate user?
- Assigning Default Value
- Close Button
- Load event of active form fires when Access closes
- REQ HELP: Upper Case "C" replaced Lower Case "c" in Table
- Query textbox value on a form
- Upgrading to newer version
- DCount question
- using control source on query result
- selheight question
- Editing object description properties with VBA
- Opening a word document or PDF file
- what sql string has to be?
- Synchronizing Microsoft Access
- Same date data for 12 months how?
- Two questions about Access 2000
- record update to a record in another table..?
- Secure Database Systems
- Importin a MySQL database into MS Access
- Update query doesn't work
- Best way of updating a table, based on the results of a query
- Error 3197: Deadlock?
- simple email from access
- Calendar Control question
- 1 ZIP code 2 Cities
- Report CAN GROW problem with Memo field
- Search Multiple Tables at once.........?
- (dhl) Exporting Table to Excel
- Update query in access - based on data in different table
- Access 2000: how to create a query based on a form parameter -- Please HELP!!
- Access 2000: How to query the fields in a table
- Access Query help!!
- Revisions
- Talking between forms.
- Default Value set the same as last valus for field
- Track the User logged in the Shared MS Access Database
- Email from Access to Outlook express
- Listbox problem
- User Level Security - Change of password...
- Help - Date Tracking
- Search for text in a text field
- Updating 2 tables in 1 to Many
- can't sort after filtering
- filtering form by combo box not really working
- 'Password to view project properties' in MSAccess 2000
- long strings in vba
- how to pass recordset object to procedures/functions?
- VBA - MailMerge error 2046
- Error 2427 upon opening a form/subform?
- The Expression "On Load" you entered....
- Please Help Acc97 Database has Got the Better of me
- Importing dates like 01JAN2003 from txt file
- parameter querie basics
- Access References Using UNC
- Winzip (wzzip.exe) via access
- Unknown function Date()
- Printing Properties
- how to track object modifications
- Access 97 Report crashes under Windows XP but OK on Win2K
- "one user account fits all" in a secured database?
- How do I group weekly dates, based on a Calender Table?
- Forms using linked tables fail
- Difficulty with combo box selection TO keep cursor focus
- vb.net and stored procedures on SQL Server 2000
- Can't edit the results of a query
- How could a three dots become a bolded vertical line in a textbox in MS Access 2000?
- A2K: Report formatting issue grouping on "Fld<>'Value'"
- check for identical input
- database servers rent
- whitespace string as primary key
- Multiple queries in a combo box
- query group calculation
- Simple Query Help
- Insert new data in subform
- Runtime Security
- Query table by the date
- Condittional formatting
- If blah blah blah #AND# If Not blah blah blah produce same results. Why?
- Help needed w/Runtime, XP, and "Can't be started…" error
- a2k - creating salary totals
- a2k - creating salary totals
- SendObject creating 2 attachments WHY?
- Farid writes:
- Output Excel File (dhl)
- Hyperlink captured in e-mail
- scrolling through report
- date query
- Can't acces the right excel sheet with vba
- PASSING KEYS
- Creating tables in another table of the same directory
- Normalisation Question perhaps?
- Date Query Grouping Help!
- Sort Table Through VB by multiple columns
- Need help with placing value into subform
- Code Just Stops
- Searching Database
- Custom Events / Application properties ?
- Validate fields.
- report not showing all data?
- Case sensative
- OT - Sharing Revenue
- File List Creator
- days between two dates
- Runtime security
- Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
- Alternative to ADODB.Stream for saving documents into MS Access Database from within ASP page
- MS Access Trial version 2002
- Trying to find text within a text string
- Custom MsgBox Message
- "Opened Exclusively" message on same machine with 2 of 3 Windows users
- Dev Ashish acc 97 set page setup margins at runtime VB
- An expression question
- Is data secure within an MDB/MDE file?
- parameter query not working as expected
- Multiple Sub queries in a SELECT statement
- Difficulty with combo box selection
- Append Query/Memo Truncation
- Editing question: locating a charter within a string!
- Obtaining Table name from error message 3200
- how to Locate cell in the datagrid control
- Auto Fax when "printing" a Report
- Writing to CD from within A2003 VBA
- Help - Close Date and Effective Date
- a2k - quickest way of checking for a value in an array?
- Row handle invalid/referred to a deleted row or row marked for deletion
- Subform dissapears when adding a new record to main form
- I don't remember carriage and return
- Executing multiple sql DDL statements
- Highlight the date on the calendar control
- Change background/tab colour of tabControl?
- Recordset confusion
- Appending boiler plate records w/o having a relationship - Pleasehelp
- Acc 97 page setup
- Problems making new records through the form wizard
- Using Crystal Reports in MS-Access & Use of timer event
- How to strip out sender address and originating IP address from received eMails
- Please help with treeview
- Multiple Queries - 1 date range
- Problems making or deleting records through a form control button
- admin info
- Application for "Find a Dealer Near You"
- Form scrolls down a bit when opened
- Changing table structures in Access
- dialog print on report
- Larry--Access 97 Question
- Possible for Column Height in Row Source
- Probably an easy answer - Form and update question
- access problem on date conversion please hlp
- ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
- Move instead of delete
- ERROR: "Method 'Connection' of object '_Current Project' failed. -2147024769"
- Simple Expression Too Complex
- MS Access 2002 replication problem
- combo box (optional add to list )
- Data dictionary for Access?
- Append query not setting Yes/No flag
- Add_in Manager
- any springsteen fans - need database will trade
- Replication Manager 4.0 - Changing IP Addresses (HELP)
- #Deleted In All Fields When Linking SQL Server Table In MS Access
- Are select queries with inner joins updatable?
- [Field name] returned as data in query results
- Search multiple fields (80!) in a query
- Can I label queries so the can be copied with VBA? Confused!
- corrupt db and MSysObjects
- my query doesnt work
- Provide a Recordset to a report from VB via COM API?
- Coding No Related Records?
- Create New Record In Different Form
- Question: How to launch a Module of code on startup
- Help with modules I think
- Uploading to website
- Trouble Importing Data
- Importing Data to Access.
- getting "n" records using RND()
- Getting External Data into Access.
- Enumerate controls in a runtime environment.
- fields containing * ?
- I can make databases in Ms Access on order
- Wykonam projekt na zlecenie Bazy w Ms Access, programy w Delphi6 lub Builder5
- Open subform on Tab Form, with criteria
- Show images in a control within Access
- Make help in Access database
- RS232 data to Access database - general approach
- Combo box list question
- Access to Excel PasteSpecial Values
- Variable Row Source for graph on subreport
- Slow Searches in Access
- Searching for files and extracting contents
- Live Updating Excel - Access Links
- Determining which folder is a shared folder
- Cascade delete
- How to sum up total time logged in by a given member in tblMemberLogins having Login & Logout Date Type fields
- Report with null values
- Report - Extra blank page problem.
- "This recordset is not updatable" - why not?
- No access to .dbf files in access 97 after installing access 2003
- Query Design View - set default window state
- Need Help with counting weekly dates. One more time.
- find file, copy and save under new name?
- Replace function - odd problem
- Date problem with not american format
- Question of syntax
- Database design question...
- NEED FIND BUTTON TO RETURN MSG "NO RECORDS FOUND"
- Edit, Delete, Update ... Error :-(
- locking records on a form
- Concatenation Error in Access 2000 report
- Constraint
- Old Value - A97
- I need to "hack" into an MS Access program - help!
- Printing a record on a report depending on a record in another table
- Verhindern von ScrollBars in einem Unterformular
- Getting an IP address.
- burning JOIN question
- Help on DAO in ACC2000
- Code To Check a Folder For any Files
- Record is not locked, although Edited Record locking is set
- Connecting To FoxPro
- Oracle with Access?
- Access window - once minimized, won't maximize
- Access window - once minimized, won't maximize
- Corrupted form/control
- Multi Select Listbox control - SO SIMPLE BUT WHERE IS IT!
- Displaying Subform
- Delete query help
- Item's Indes in multiselect listbox
- Was the item selected or deselected?
- Crosstab query reports (unknown fields in reports) What about sorting?
- Find record causing failure on Insert statement
- Multiselect Listbox
- Blank Field Problem
- Blank Field Help?
- Blank Field Help?
- Access XP strange behaviour
- VBA quick question
- convert from 2000 to 97
- Access RunTime
- Autocreate records and print them
- Connecting to Microsoft Index server service from Access
- textboxes updating from a listbox
- Cascade delete of indirect children records
- Repost: Union query truncating field
- iif statement dealing with nulls
- Want to easily copy selected object between databases
- Array error when passing to Sub
- Syntax Error in SQL Statement
- Tool to identify unused objects?
- User Account Locking
- Hardware tracking solution
- Joining 2 queries for 1 report
- 180 day rollover of records
- Corruption when "Compact on Close" active
- Need SQL help - Select Distinct, Count, Group By
- Varchar2 fields limit
- Button Pictures
- How to capture data change...
- TransferSpreadsheet seems to corrupt spreadsheet
- Security at Runtime Problem
- Re - post..Date/Time
- SQL error
- Multiple Names In A Mail Merge Field
- Setting date condition
- Updating and Deleting a number of records at the same time.
- Query Records from a specific Date Range
- A Totals Query That Doesn't Total
- Date Selected query parameter
- VBA datatype mismatch error 13
- VBA
- Printing underlines on subreport data
- Best book for my skill level?
- ???? Macro security question
- Report Setup
- Highlighting individual records on a continuous form
- LDB files and file names
- Best way to let users input picture/drawing to each record?
- Form-subform links - am I breaking the rules?
- Acc 97 - Set place/numbering in continuous form by code
- Table - Import / Link Wizard...
- Right Justify in list box
- Number of lines in a sub-report
- Report Problem
- Re-dimensioning string variable that has already been globally dimensioned...
- Form and query
- ERROR: "Method 'Connection' of object '_Current Project' failed.
- ERROR: "Method 'Connection' of object '_Current Project' failed."
- Date/Time Conversion woes
- Date/Time Conversion woes
- Workdate calculation Access 2000
- Is there a way to delete every record in a table without selecting all the rows
- Form and queries
- Access 2003 - importing PDF files as part of a record
- Image doesn't work after extracting from MSAccess
- How do I avoid "File Sharing Lock Count Exceeded (Error 3052)"
- SQL with special characters...
- Found Text but Can't Extract from Word Doc
- Organizing lead files
- Queries on tables from different data sources
- fast
- VBA editor changes keyboard layout.
- Select an item in a combobox
- Access 97 - how does it import database objects from other databases?
- Copy new db
- Suppressing Not In List msg in combo box
- passing filter to sub report
- Combobox & null
- a2k - rounding of figures, comments?
- Dates
- Help on FE, BE, Linked tables and Bloating Concepts and some advice on how i should construct my database
- Access MySql ODBC strategy
- security problem
- How to rotate text
- Access OnNotInList sooo Frustrated
- Syntax error in Create Table statement? Why
- Access 2003 problem
- Delete message - Can is selectively be turned off?
- Hide friendly ODBC connection error message
- Missing .OCX files after 2003 upgrade
- Typing SQL Tables in by hand, in Access
- Seeking syntax for pass-through query to delete SOME table records
- Updating Hyperlinks
- frequent database corruption
- memo fields blur in acc '97
- How do I set a shortcut key to a save function
- Mouse Wheel ON/OFF Subforms - Lebans MouseWheel On/Off
- requery listbox as you type
- New CDMA Awards 2-DVD Set!
- Crosstab ColumnHeaders
- Restart Autonumber
- Problem with use of calculated form field in query
- attaching forms
- date, default value
- Problem opening a Form
- How to make access import special chars correctly?