View Full Version : answers
- Another look-up combobox speed question
- Password Problem
- Grouping labels
- ShellExecute and MS Photo Editor
- Looking up redundant occurences
- Copy and Delete Linked Table in Access 2000
- [Access/VBA] How to convert a RunMacro with a "repeat expression" in a simple function call ? (no more macro !)
- Copy column into clipboard
- Budget Modelling in Access
- user permissions
- Adding several fields in a form and storing in table?
- Adding several fields in a form and storing in table?
- Bad screen painting - how come?
- Labels - Printing varying numbers
- How can I import CSV with Carriage Return?
- REQ: help with checkboxes
- How can i copy a table to a new table with primary key remain
- Need help binding multiselect listbox to table
- Check box in access
- Other Users don't see table updates
- Redefine data structures?
- Checkbox values change when print previewing or printing
- Function to supply the criteria for my IN Clause
- Assign Yes/No field numeric value then sum values
- Booking
- How to tell if you're on the last record
- Attempting to change same data same time
- Linked Table Manager -> Subform Crashes ...
- How to Set Time to 24hr Military Time ?
- Convert to Half Hour of Day
- date/time stamp
- date/time functions
- sending emails containing pictures
- Auto-schedule Data loading process
- Can I pass parameters from a macro to query?
- Convert Access97 to Access2003
- form message
- form message
- select query using arrays
- Missing in Action
- Field doesn't repaint
- trying to append from several different databases
- Refer to the Previous Record
- A97 runtime installation failure due to DAO350.DLL not registering in registry?
- Loop a shell command (batch file)
- Parameter Query, Link Oracle Table
- Problem Solving Skills for Engineers
- SQL command help
- SQL command help
- Corrupt Encrypted Back-end. Any suggestions?
- New : test yourself my new VB6 syntax analyzer.
- Recordsets and archiving
- Help - has lost ODBC connector access to Webhotel
- Parameter Values in a Report
- lebans richtext control, subform question
- Access Subreport objects from vba code
- Networked Database Woes
- Connecting to ODBC DB at startup
- TROLL ALERT - take care when talking to Br@dley!
- Updating MS Access tables from a query
- Disk Farm
- Mouse scrolling in A2k
- Product Relations List Box box help....
- BOM, with Joe Celko Nested Sets
- MS Access in UNIX Server
- Automatic updates
- Query 3 seperate tables
- Custom Buttons
- Getting things to appear on a screen
- Cool combo box functionality desired--changing sort order and highlighting
- Cascading Combo Boxes on continuous forms in Access 2000 - SOMEONE PLEASE HELP
- VBA reference problem
- Problem with displaying Unicode in Chart object (MS Graph 8)
- Runtime options
- detecting network connectivity
- (FIND&REPLACE) inside a Popup/Modal Form?
- Determine object type if have name?
- Query textboxes on when Not Null
- Dynamic Field Color Change for whole form?
- select all entries in a list box
- Assign values to new Record with info form last record.
- Form Does Not Refresh
- KeyPressed and KeyCombination Control?
- Password on close (again)
- Parameter Promp After Form Closing
- Adding Rows
- Find record problem
- Error with AppendChunk() and MEMO field
- Search Button
- Access FINDandREPLACE Dailog Problem? acCmdFind
- Format in £ rather than $
- Database Splitter
- Simple problem with combo-Box Text
- Has anyone used the IADsOpenDSObject in Microsoft Access 97?
- search
- Jetcomp crash
- padding text fields with blank - MSAccess vs. OLEDB Jet4.0
- Alert Boxes in Access
- Export to Word Bookmark
- subquerys use A97 format in A2000
- Wireless Connection - Non-Jet Back End
- saving data
- programmatically obtain the hard disk's serial number from VBA?
- Charts Erroneously Showing Design Data
- For...Next in subform
- ACC-XP(2002) - Create RunTime code?
- Help with SELECT syntax
- Raise Event from referenced mdb to Main.mdb
- Read and Import folder names from a CD?
- Windows 2003 server
- subform visibility should change depending on drop down selection
- Handling Calculated Historical Values
- Checking before adding a new record
- Tab Function
- Having problems updating one table from another.
- ADO refresh problem...
- On Error Resume Next
- Not In List Error
- Joining two tables on two fields
- connect as Access 2K DB from Access97
- E-mail word document as an attachment from Access
- ODBC connect to remote SQLServer
- PrintPreview messing with DetectIdleTime code ?
- Query ignoring functions returned value
- Taps for DAPs
- Difficulty displaying graph in Form View that I see fine in graph control on form opened in design view
- E-mail
- Report to PDF and Email it - Sorted
- Set appointment in Outlook on other computer
- Setting hyperlink for email
- A Query / Report Question with a difference.
- Usining Replication
- calender ms access the same as outlook
- Wireless connections, trace them in a LAN?
- Autofilled field after chose value in another combobox
- No solution on Wan.
- Adding My Contact Details to Reports.
- Extracting OLE to pdf
- Export file from BE mdb to BE folder
- Really ODD image loading error in Access 2003
- Anding a field for record count. Same address multiple name.
- Slow data access on Network(LAN)
- A97: Autonumber values growing by leaps and bounds?
- Find Dialog Box - Detect When Complete and No Longer Displayed?
- Emulate desktop shortcut start in directory
- Replication
- How do I set MS Access NOT to use my profile's 'My Documents'
- REQ: Help with querying check-boxes
- Need help with a conditional formatting string
- where is the SQL for a pivot table?
- More to Command Button
- Command button to open Find dialog
- Change a text box to a combo box in VBA
- SQL DECODE FUNCTION
- disabling fields
- SendObject problem
- docmd.sendobject ...sending a non-Access object
- Limited number of updateable fields in update query??
- Automating folder export from Outlook to Access
- Access listbox auto sellect
- Tenths and hundreths of second
- Making a lot of stuff Visible and not Visible on a Form
- Linking Tables to network Database
- Runtime errors: ADO (80040e21), DAO (3001)
- Populate word Userform from Access
- grouping a field in a query
- saving data
- OT. Fax Server With Access
- Access97 How to have a visible cell reference from another DB or SS
- autonumber query to number in another table
- SQL Insert, Autonumber, and End of Table ???
- Quick Question about Missing References
- Outlook Express
- Colsing a for with dissolving of the form
- InnerJoin + Left Outer Join syntax problem
- Suppress the "Loading Image" dialog
- Distinct records in report
- Using Access MDB on a Linux Web-Server possible?
- access 97, too many nested subforms, is there a workaround
- Export
- How to Auto-Document Access 2003?
- Dynamic MS Access Form Help
- Help using form filters
- Attaching SQL Table w/o DSN
- delete report fields if no data
- Query by 24 hour Shift
- help with looping through array required!
- Open form using list box (compound key)
- A2K - Odd form closure problem - REPOST
- HELP ON WAN
- Lebans Rich Text Control LDB/Locking Problem
- Query criteria that isn't bound to a single form or report
- Country, State/Province, County, Region, City
- Main form with 2 subforms - Error: Method 'requery' of object '_Subform' failed
- Convert MS Access DB (FE&BE) to Oracle
- Link to Oracle tables with VBA
- Records Getting Deleted from Key Table
- Relationship getting deleted by itself!
- Audit Trail For Access DB?
- Calling query which uses alias results in different value
- Calling query which uses alias results in different value Version
- Chart Help Needed
- Form design for questionnaire
- urgent req with our Direct Client
- Delete Posts
- Normalization and AVG across columns
- Please help me with memo fields
- Report
- queries - null value
- Mobile Device and File Dialog Box
- Configure Report
- Any recommended Excel forums???
- A2k - odd form closure problem
- chart object drives me nut
- Reading Microsoft Access Macros via VBA code
- query questions
- Opening folder when the folder name has a comma in it.
- VBA to Yahoo, MSN or AOL Instant Messaging?
- Help using form filters
- Cmd to open AddTable Dialog (A2K/SQL Server)
- ftp using Internet Transfer Ctrl
- Open a new browser window in a Data Access Page
- Exporting images (ole object) from access to images folderfolder
- Setting a Key to update cascading table
- Importing multiple files..
- Access Report : Calculated field3 = field1 + field2
- Deleted column in a Table linked to 35,000 entries!
- event in access
- access problem please i need your help
- Invalid Command Line Switch: 'I' in Access 2k
- modifying relationships using DAO?
- Date and Time calendar
- Count Items in a report
- Select Count(*) question
- IIF in Query Design
- Run-time error '6' Overflow
- Run-time error '6' Overflow
- How to retrieve the date of record creation?
- Efficient way to store photos
- Userform as subform
- get MSDASC.DataLinks COM Object used CreateObject function in VB or PB
- From text box to field
- Who started me?
- Access or SQL Server 2005?
- Sharing a backend over the internet
- Numerically incrementing a string
- Converting Access system to Chinese version
- Combine multiple records into one
- SendObject & A2K SP-3
- Access 2003 Error Distributing .mdb
- ForceNewPage Property
- Any way to remove the AutoIncr / Autonum attribute using DAO?
- drop list to fill in the blanks on a form
- Displaying multiple field values in 1 query record
- What is wrong with my code??
- A2K - plausible to change recordsource for reports in MDE?
- Developer Don'ts: Nonsense Progess Bars
- Not in the list
- Decimal Symbol
- Auto-Populating a field in Access
- Option Group Counts
- inventory and pos
- urgent req with our Direct Client
- using an update query to change multible things...need help
- Complex Copy Function
- Query with user-defined function doesn't appear to work.
- Underlining in Hyperlink not Showing up
- Can someone help me?
- Access XP Bug - Linked Images - Any Solution??
- Continuous Forms Question
- Leban's A2000ReporttoPDF Functions: Can you stitch many SNPs into one PDF?
- Counting Days in Access
- MS Access - "Parameter Incorrect" Message : Stored Procs
- Exporting jet table metadata as text?
- Unable to link to backends on another computer with A2003
- Middle record in a form
- Peronnel Area Reporting Database
- query/subform question
- Adding a New Record to Access form using Visual Basic in Excel
- Synchronizing 2 subforms of same table
- Formulare miteinander verknüpfen
- Building Access Applications "Inventory"
- Table with only the last record
- access database
- textbox: counting & editing
- Type Conversion Failure
- record navigation icons
- Any way to change the OLE type in an OLE field?
- Selecting Last 2
- How to Maximise MS Access and Bring to Front
- Kill Process
- Subtracting select queries form each other (each select query has multiple conditions)
- Conversion of an MS Access application
- How to calculate the difference between values in preceeding records
- Simple Report / Query Question
- How to have other fields on form autofilled after I choose a value from list box
- Getchunk and AppendChunk
- Translate CrossTab Querys (Please Help!!)
- Combobox slow to drop down
- Combobox slow to drop down
- Pass Throughs and Reports - Record Order?
- Reorganize Databases
- Overtime Query
- REQ: any utilities for designing front-ends for databases
- Overtime Query
- Network Files Inaccessible
- Check Box clearing
- Julian Date Conversion - Can Anyone Help?
- Calling queries from MacroVBA - where query has a parametercriteria
- Query-by-form; using a criteria on a combo list
- searching using text box and query
- Cross-joins and non-updateable record sets
- Need to Connect to Oracle DB with no ODBC
- While using Shell to open a new instance of same database, using vbHide to Hide the new instance fails.
- Time over 24 hours
- Database corrupt error while posting large transactions
- access 97 upgrade question
- Recalc or refresh - focus current record in subform lost
- List Box gives Null Values
- znaczek "+" do ukrycia lub pokazania szczególów rekordu?
- Automation operations
- Access 2003 ADP
- Using Access and MySQL over Internet
- Using Access and MySQL over Internet
- Hide Controls
- After the default printer has been changed by code in Access 2003, the application still directs a report to the former default printer.
- Lebans ListView - More Columns
- Design question
- Calculating total number of fields in a table
- This is simple in excel....not in access....
- Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica
- Record locking
- How to run an updated query in macro
- How to run an updated query in macro
- How to run an updated query in macro
- Set control property using variable for report name?
- deleting records
- Parameter Query
- DateDiff in Query
- recordset cashing
- Limit to even numbers
- Similar Programs - MS ACCESS
- Add Filter to Report
- Missing Reference because of multiple Outlook Versions
- Splitting windows like Excel?
- Couldn't update multitable form (3 tables)
- DLookup criteria problem
- automate button click event within vb using web browser
- Hiding the mouse pointer
- Create MDE causes Access to crash
- How to check if a database is .mde in access 2000
- anyone interested in a hotel reservation system
- Lost Bookmark
- How to handle CD and DVD drived in VBA?
- Need help with SQL Select statement using LIKE
- Enabling / disabling functions
- List of objects at left of screen disappears
- Need process for selecting available reports
- Store files on SQL Database
- How to retrieve the date when a record is created in an Access
- access 2003 form to count fields with data
- Outlook/A2003 compatability problem
- How to do group header?
- help with message box
- DoCmd.TransferSpreadsheet
- Attaching .xls file from a saved location
- urgent req with our Direct Client
- Control query-datasheet launch position
- WebBrowser ActiveX Control
- help require for algebra function??
- Control query-datasheet launch position
- Subform Displays Data from Record #1 (not current customer) - HELP!!
- Revert mde to mdb - Possible
- INSERT INTO Acess 2K table from Visual FoxPro DBF
- DoCmd.GoToRecord , , acNewRec
- Form fields lock after update in combo box
- MS Access Now() minus preset amount of Minutes
- Books on SQL for Access
- Many-to-Many with SQL
- Filter by Form - not working
- Create Form-Subform to Perform Searches
- Access 97 takes 50% of my cpu :~)
- Convert all folder contents that are xls to csv
- total minutes in access 2003
- Vertical labels on forms are invisible
- Trying to sort transactions by time
- Set recordset field contents to string
- Automatic historical archiving of data for comparison
- limit two combo boxes with unrelated data??
- Value Lists
- Value Lists
- Help needed with SQL Select
- Rebuild Form From Scratch?
- MSACCESS 2003 CREATE PROC
- automatically retrieve value from a range table
- Querying for No Records?
- How to create a decimal number in Access?
- Relational database design
- Calling an MS-DOS command
- MS Access Reports
- How to read Access Data Access Pages with vb .net
- Creating a Mailing Sheet using Data - PLEASE HELP
- complex insert and vba
- I am a beginner
- urgent req with our Direct Client
- Access 2003 performance on datasheet view of bound form
- Run a script to alter a column in a table?
- application.printers port problem
- Multipy Entries tying to same reference table
- C# .NET to MS Access OLEDB - Security error
- update query help. error??
- Why does detail section scroll behind header?
- Access Database Programing Questions
- change default printer to network printer
- Updating a shadow DB
- Adding Tables and Forms to an Application
- Will Access 2003 open and run A97 mde files?
- sending email crashes with ms acecss
- ms-access database cannot be updated
- Building a Complex Crosstab
- Problems importing Excel into Access
- Formatting as Date in a query expression
- Form Filters or Rebuild SQL Statement as Recordsource?
- SQL Server Express: Anybody Using It?
- What's wrong with my code?
- ListBox, ListIndex and ListCount. A BUG???
- Repeating information on report fields
- Subreport not showing - but my frustration is
- A97 Runtime - Records can't be read. No permission on MSysModules2.
- Custom Collection Class woes
- Odd recordset behavior
- SourceTableName truncate
- Report record source
- update query- HELP??
- A2k - what the hell is TID?
- error messages?
- a2k - bizarre subform bug
- Directory tree scanning
- Row Headings in a Crosstab Query
- Subform Wizard and number of primary key fields
- Pivot Table Help
- How will we use .Net in future versions of Access
- Is ADO Dead (3)?
- Possible to open list box when clicking on text (beside arrow)?
- Auto filled in values from another form after choosing value from list box.
- How to be auto jumped to last reord after opening form?
- I do not want first caracter capitalized, how?
- Is ADO Dead (2)?
- Is ADO dead?
- Run-time error
- How to add restriction that field is empty.
- Not getting login prompt
- How to change the color of the buttons or the button from the switchboard?
- New to Access search field
- Multiselect list problem
- Lookup table question
- pause "on current"
- A97: Am having difficulty getting msaccess.exe written to target drive in runtime rollout
- how do u send an email using access?
- how can I save all database on a CD?
- DCount
- VBA: Reciprocal functionality ?
- Report, Form Argument in a Procedure
- Access 2: Can't Perform Join- Combined Fields Too Long
- How to set a background color with certain HEX, DEC or RGB value?
- Want to insert logo with transparant background but get white
- Setfocus jumps to next field, but default value is selected in that field.
- How to set the selection-bar- and selected-text-color in a list box?
- Select data from other DB
- Help with Conditional Formatting
- MS Access as front-end for Paradox database?
- Connecting MS Access to Unix Jbase system
- Connecting MS Access to Unix Jbase system
- Access 2000
- Changing querydef sql to match form!control parameters
- mdb keeps crashing
- MS Access Database right for us?
- Separate one field into two fields
- count a check box field?
- A2K3: Problem with displaying week number on report
- MS Access Script to import data from external mde database to mdb database
- Add and update records in VBA
- HHC5013: Error: URL reference in the TOC cannot be resolved:
- Birthday in a query?
- advanatges and disadvantges of using ms access over vb6?
- Database books yay!
- byepass hard disk when working in moveable drive
- Storing and extracting binary files in Access
- Charts
- Listbox doesn't update on Requery
- How to get Cells(i,j) value in Access?
- Help with converting DAO to ADO
- How do I NTH select in MSAccess 2003?
- A97 Query with BLANK Data
- Problems with a shared Access 97 DB
- Redundant Lookup
- Wrong textbox gets focus.
- Automated database entry
- splitting string
- DateAdd help
- How do I open a file in VBA from Access?
- DateAdd help
- unlocking table to be updated while being used by others
- Running Metrics off of tracking DB
- set data field to null
- Running Metrics off of tracking DB
- how to break the bounds of 59 in date/time data type
- how do u open a specific ms word file??
- Different results in VB6 ADODB & Access 2003 (11.5614.5606).
- Send Raw data to a Printer using Win32 API
- Error # 3125 - " is not a valid name
- Access: Colorizing Query Results in Report
- a "different" conditional report field
- Update records from one database table to another
- Week/quarter format in Charts A97
- Error in setting multiple field relationships with vba
- How to have two subforms on one main form reference same table??
- How to have two subforms on one main form reference same table??
- display problem with access
- Help! Exporting Access table to Paradox
- Subform errors - can you check this...
- Subform no-brainer
- STDEVP problem?
- Protect VB.Net code converted from Access
- swapping recordsets on a form
- Query Truncates Memo Fields
- Determine if file is on local PC
- Help in proving that Access is an industrial strength front-end
- Email Query Results
- 3 Identical Reports (almost)
- Refreshing and linking SQL Tables to Access front end
- How much to convert to SQL server
- Filename or path difficulty in a macro
- MS Access Switchboard With Dynamic Labels
- urgent req with our Direct Client
- Corrupt Table Problem
- Why cant i get the header images on every page
- Access 2000 Data Entry Form goes invisible
- JRO and Access - what program.suite is needed?
- Record Count
- query for two values
- Shell the same database ignores the 'vbHide' argument
- FYI - Issue with TransferText in Access - VBA
- Seeking code to ID & print all controls having a ValidationRule property set - but no ValidationText
- fOSUserName for Multiple UserNames
- report sort query
- Decompiling an A97 mdb file...
- code to open list box from param query
- Confirm record updates dialog
- Grouping in Access Report