View Full Version : answers
- Lining up columns on subreport with main report
- Unexplained behavior in Windows 2000 Adv. Server environment
- Unexplained behavior in Windows 2000 Adv. Server environment
- Self-Referencing tables
- Self-Referencing tables
- Change the autonumber of a table
- Change the autonumber of a table
- AccessXP Startup switch /ro
- AccessXP Startup switch /ro
- MS Access Shell use to call external application with audio
- MS Access Shell use to call external application with audio
- "Overflow"
- "Overflow"
- /cmd problem
- /cmd problem
- Access 97 bogus duplicate records
- Access 97 bogus duplicate records
- Publish with MS Word problem
- Publish with MS Word problem
- Jet SP8 installed but still requested
- Upsizing MDB to SQL server
- Unwanted American date format problem
- NETWORK INVENTORY
- Refresh/Reconnect to SQL Server
- Using UNION of 2 or more saved queries
- Run as is it possible ??
- Use of "Max" in query grid
- IMPORTING QUERIES FROM ANOTHER APP
- How to use extracted table with base table?
- focus from main form to sub form
- turn off warning
- form is not allowing me add data
- Space at the end of the field
- xls MACRO help
- Listing all users in a combo box.
- Query problem
- missing operator in query expression
- Customised Dropdown ComboBox
- Summing text field containing blanks
- Etiquette about reposting a question
- newb seeking help with form
- Strange corruption problem
- looping through toolbars
- Simple Update Query
- Access 2003 security
- Consolidate data in head office
- Differences between Access 97 and Access 2000/2003
- Setting recordsource for subform
- Easter function explanation Part II (long)
- Help with Registry Patch
- HTML Help
- Please Help - Combo Box Question...
- "Connection Failure"
- MSDE Upgrade question
- Add xls Macros to existing Module.
- Access Books
- basing a form on a RWOP query
- Linked Table Manager Macro
- Access books
- Custom toolbar problem
- Do I understand form optimization correctly?
- Read only version of a form.
- Report Group Footer not displaying the total that I want
- Como Box
- Application crashes after a call to DaoObject->CommitTrans
- generating a seriel of serial no
- hide pagefooter
- Locally using Access and IIS
- Help needed with frustrating menu bar problem.
- controling which report to print in VB
- Left Join behaving like Inner Join - Access 97
- How to use variable to reference rst!Item?
- Rolling Average Calculation Problem
- SQL error "Arguments are of the wrong type ..."
- Copying records
- Report Group Section Footer displaying Totals
- Upsizing questions
- Macros and queries
- Getting Totals From Two Different Tables In A Query
- Auto Number
- Creating new Fields in code
- Sequencing Problem using an MS Access Query
- Looking for 3rd Party Developers
- A97 graphing (x,y) coord's - how to do it?
- A97 tables needed containing geodata for USA state boundaries 'n city loc'ns
- Rounding Frustration
- Focus on tab control instead of first field
- archive macro
- can Access 2002 or 03 import multiple worksheets?
- Tracking Changes in Access
- Dynamically Renaming Fields?
- Import XML with Attributes
- Reading Text Files - Dev
- Advice On Random Sample
- EVERY "on open" gives "expected end of statement" error-->SOLUTION!
- OnDirty only working once
- Access database suddenly increased in size
- Merging several lists into one, with different field names
- how to pad zeros to the left of a field in a table and KEEP them there?
- how i connect my comp.databases.ms-access with jsp in tomcat3.3
- When will a query run?
- Problem with ActiveX
- currency format in a textbox
- currency format in a textbox
- No Current Record
- Send Object on WinXP
- record-locking?
- Using NOW() to display long date in a report
- report "too long"
- How to make all access to linked table read-only
- Variable Pointers
- Quick help with extracting a value
- Security in Access 2003
- How to interrogate through OLEDB for space to be freed by compaction?
- Right Clicking a form gives users wrong power
- no suitable driver found exception when getting connection with access
- Locking controls locks another form up...why?
- Access backup software
- creating pivot tables in Excel from Access
- Problem with Embeded Queries
- Workgroup file (system.mdw) problem
- Word truncates Memo field when using Automation from Access
- Create report in MS-ACCESS
- How many subforms can I have in Access 97?
- Any resolution for Err 3734 "Database has been placed..."
- DCount, by customer
- Updating Multiple Access Tables with Single Excel File
- How to 'dump' all standard and class module code lines into an Access table
- Multiple product classes table design
- Time and Attendance Recording
- How to set up read-only accessibility to an existing .mdb
- AllowByPassKey error
- Access Wizards don't see table
- Call Function by string
- fGetControl (strMyControl) as Control
- Multi-column report needs word Continued
- Permission problems with Access and SQL
- Row handle referred to a deleted row -- error message
- Help with totals in access
- Tools for record locking
- Top 10?
- Access 2003 runtime confusions
- Form field visibility -
- Passing a parameter as a form control (or not!)
- Looping through every oject for Application.SaveAsText
- SQL asp select syntax help
- Application.Name
- Unselecting items in a Listbox (HOW?)
- I want to examine each procedure in my class modules and standard modules (A97)
- Creating Groups and Users
- Multi-user, Multi-computer MS-Access.
- Distinct problem
- Distinct problem
- Help. How to enable the confirmation of save on changing table/query?
- Using Listboxes to enable multi-select
- Combine 2 memo fields and insert a blank line
- Automate compact and repair/backup database
- Query type for asp page?
- Primary Key question
- Menu Bar Startup Options via VBA
- Bringing up the Expression Builder
- AIUTO: Collegamento tabelle MySql ad Access
- want to about ms access
- Record Locking in Access 2000 DB
- Report view
- Create dynamic hyperlink in Access 2000
- Fried brain by 10am - wierd "fake" hang problem
- Multiple criteria on filter
- memo field auto-expanding?
- Get runtime error "94" with 1st character capitalization script
- lock records on edit detection
- Awful performance and millions of packets transferred
- super quote
- ADO parameters queries and stored procedures - and Connections
- supporting text fields >255 in Access 2003
- RecordsAffected reporting the wrong value
- Need advice on table structure and on creating subforms
- Mail Merge Problem
- Problem with limit on maximum number of textboxes on a form or report in MS-Access
- Access, ASP, DATE problems!
- Persistent recordset error 91
- toolbar diappeared
- subform name on control tab weirdness
- Running a Database on a USB Flash Drive
- curious about command buttons
- Search button / form
- stumped - 'field too small to accept....' (err number 3163) error only with MDE on production server
- Query to XLS
- How to Compact a "Table"
- Snapshot Viewer on Macs?
- multiselect problem
- Need help on user input decision for Form
- Form Not Painted / Visible !
- Larry Linson
- Calendar
- How to calculate the sum of a colon
- Accounting in Access for small businesses
- DISTINCT problem in query?
- Implementing row-level security (SQL/AD)
- mouse scrolling problem
- I could use some help with a query using mulitplication
- one to many & many to many relationship
- Object variable question
- Checking a condition to be true over 9 consecutive months
- Help....Frustrated with Forms
- Navigating main form with subform
- Why code unhiding database window in A97 unhides hidden form too?
- new record detection
- A97: Can't import a text file to an Access 97 table?
- A97: Is it a feature or a beature of Access compiling code on the clipboard?
- Mail Merge
- postgreSQL temporary tables and MS Access
- A97: Is there a way to exclude certain modules from being compiled?
- A97: Q re ShellWait?
- A97: Copying HELP text is flaky.
- A97... not important, just curious (2 if's or select case)
- Add "All" to Combo Box and Use "All" as Criteria in Query
- Further adventures in Jet database compaction
- Love the SQL, can't seem to get a combo box to use it...
- locking subforms
- recordset for reports ?
- stopping every acknowledgement
- Aggregate two fields
- Document Tracker
- Access Modules
- ADODB connection can't open. Database locked.
- Show all record using combo box
- avoiding reference problems when distributing apps
- Looking through date in SQL
- SQL Problem
- Control form movement
- Parsing out SQL statement
- search access table throught webpage helppppppp
- Why does A97 show a number like -2147483630 as the ForeColor property of a control?
- Seeking alternative for suspending code execution with acDialog parm in A97...
- Access 2003 Reports
- Saving Modules in Access
- SysCmd acSysCmdInitMeter
- 2 records per detail in Report
- Has anyone ever wished for a fixed version of Access rather than a new and improved version?
- A97... SysCmd, what are the 4 possible values and what do they stand for?
- Trying to make a form not sure how to do it
- A97... If I run Me.Visible = False in a form module, should Unhide be an option under "Window" menubar option?
- Automating user changes to database
- Application crashes upon trying to commit a transaction
- Refresh a Form
- how can I open table in mdb access database without running form
- How to have filled data in field started with CAPITAL?
- Terminal Services
- Multiple pastes
- formatting listbox
- how to move to a specific record after the form is refreshed?
- Accessing as lookup column
- Filtering data entry in forms
- Create tables Using VBA
- How to Ask a Question Here
- Update Query VERY slow! Please help :(
- Database Deployment
- How to avoid default "can't save form at this time" message?
- references
- Properties for a custom class (not a collection)
- Help with Access template
- Code to Unzip file from Outlook message
- An experience in linking Blackboard learning system backend to Access
- Releasing Object Variables
- calculation with msaccess
- external data from internet
- access summery reports
- Only my form
- MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000
- An FAQ?
- references question
- Access 2003 missing the intranet or the website
- Active Directory?
- flaky events in A97
- How do I force MS Access to stay minimized?
- ensuring certain code runs when returning to a form...
- A2K Record-Level Locking
- Select diff value from drop down in subform, it changes all occurences in DB
- A97's Activate event - reasons why it does not occur after opening a form?
- Adding Multiple Records
- TransferText
- Why is Me.Hide not a valid statement in A97?
- Is Name Autocorrect fixed in Access 2003?
- Recreate/Reset Data Behind Form Data
- Privileges, Security & Database Design Issues
- Stopping/preventing Access from continuing onto another process/action
- filter on form with VBA
- Grand Total
- Access 2003 Corruption
- Is this a job for access or SQL?
- Riportare un record precedente
- Calculating date differences from a table?
- Unique Fields
- Export Excel file on mapped drive
- Record Y of X question
- form jumps to the top
- Instance of Access hangs
- Reference for ADO.net
- Advanced Access Security problem
- To WITH or not to WITH?
- Workgroup MS Access 2003 Windows XP
- Running Split Access2000 db on Network
- Filter and Index
- Recommended data access model
- Code To Run WinZip?
- Users ADP files suddenly adding DBO extension and not working properly
- How to access data from a subform
- Text Box With Validation Rule
- Does Any One Knows how can i learn this language?
- Combo Boxes and Selecting Everything in a Query
- Microsoft Outlook 2000 Blocks Access File Attachment
- Access Report Control ??
- Access Report Control ??
- Interesting issue with compaction. Any ideas to eliminate?
- Access 2002 Security on multiple workstations
- Position a commandbar
- SELECT clause and LAST function causing problems
- How to set background color in pushed button of Option Group.
- How to make in Find Record the Match tool setting "Any Part Of Field" default
- Trapping Error 2501
- Linked Tables - Identity column needed ?
- Help: Is there a line break in Report
- Group By with Multiple Fields
- Group By with Multiple Fields
- Group By with Multiple Fields
- Group By with Multiple Fields
- How to Populate "To:" field in Outlook with Access query results.
- Can't Get Echo To Work
- 2003 Developers Edition?
- unable to update via form - relationship problem?
- Copy records from form as new records
- Help: How to prevent moving to the new record when sub form is null?
- Inserting Strings into a text box
- Access 2003, Question concerning Adobe Acrobat
- Getting the results of a report calculation or data field
- user defined error
- Hiding a Label with a Sub report
- Help with query syntax please
- format of column heading in crosstab query
- Replica-manager: deleting old replicas?
- Subform Question
- Function vs Sub /Public vs Private
- MDE front-end on network share?
- Recordset for MS Graph (Chart) through VBA ?
- access and postrgresql
- Using MSACESS for translations?
- date help appreciated
- relation 0:1
- scroll subform with mouse
- Summarize Text
- IT Studies
- Using any value in multiple columns as query parameters
- Combining multiple columns into 1.
- Combining multiple columns into 1.
- Read this if you dare
- Read this if you dare
- access 2k print problem
- access 2k print problem
- Displaying hyperlink contents in reports
- Displaying hyperlink contents in reports
- fun quotes for the day
- fun quotes for the day
- Error 3014 and 3518
- Error 3014 and 3518
- A2K - possible to have fading colour effect on labels or textboxes?
- A2K - possible to have fading colour effect on labels or textboxes?
- Another joy of ADO
- Another joy of ADO
- Plesae help with this query
- Plesae help with this query
- How to refresh data on a MainForm
- How to refresh data on a MainForm
- Radio button groups are null
- Radio button groups are null
- F11 doesn't bring back DB window
- F11 doesn't bring back DB window
- F11 doesn't bring back DB window
- F11 doesn't bring back DB window
- ADO Question
- ADO Question
- MultiTable runtime parameter
- MultiTable runtime parameter
- Help With Table Design
- Help With Table Design
- Eliminating Blank Rows In Reports
- Eliminating Blank Rows In Reports
- Subform Question. Please help!
- Subform Question. Please help!
- Excluding records where two tables have the same id
- Excluding records where two tables have the same id
- References in Access and VB
- References in Access and VB
- Accessing Access mdb via ODBC - how to return autonumber
- Accessing Access mdb via ODBC - how to return autonumber
- Help With Table Lock, Please.
- Help With Table Lock, Please.
- currency data type
- currency data type
- syntax error for Update Query
- syntax error for Update Query
- how to disable the 'next' navigation button to new records on conditions?
- how to disable the 'next' navigation button to new records on conditions?
- Help. Button: copy value from field, followed by start ext. application.
- Help. Button: copy value from field, followed by start ext. application.
- I finished the application - - - now what?
- I finished the application - - - now what?
- Generating Numbers automatically
- Generating Numbers automatically
- Importing Tables Question
- Importing Tables Question
- Trouble setting hyperlink string with code
- Trouble setting hyperlink string with code
- how to specify a common spellcheck dictionary
- how to specify a common spellcheck dictionary
- OnApply Event doesn't act as documented
- OnApply Event doesn't act as documented
- The app's been built, now what?
- The app's been built, now what?
- VERY simple application fails to start
- VERY simple application fails to start
- J-Integra for COM (Java COM interoperability)
- J-Integra for COM (Java COM interoperability)
- Help with a C++ library
- Microsoft throwing curve balls at Access Developers! ARGH!
- OutputTo
- OutputTo
- Populating One Dropdown based on the Results of Another
- multiple users
- Exiting A Multi-level Procedure From the Lowest Level
- Find duplicate records on two fields
- Nav Bar on Form doesn't work
- How to renummer ID (now contains holes), even when table is full of records.
- making a logfile
- Forcing ODBC-Autocommit
- Acquiring some sort of unique machine ID?
- RecordsetClone only retreives 100 records in ADP
- date/time fields to just dates
- Time to migrate from Excel to Access?
- Queries...any way to disable/lock a column?
- FindFirst and query not finding records - date values
- 3-year Comparison YTD
- SQL required for delete
- Tab pages
- Strange SP Problem
- Conditionnal formating
- Table sql in acces is not updatable
- Turn off File, Edit, View, etc...Menu
- Referencing Forms
- Online Form -> Email -> Access database
- Maximising a switchboard form when it loads.
- Compare query
- auto delete in windows xp
- Compare query
- How to put/edit VB script what hightlight buttons on mousemove?
- Corruption of Back End
- Button closing database AND exit Access, how?
- Why can I only do a record search from two fields and not more?
- Replace Subform
- Dynamic form possible?
- Calulate time between different records
- Option Group: Values only nummeric, how to perform for all characters?
- Stand Alone Database Application
- Can Access 97 emulate Windows Find Command?
- How to Date Filter on a Group By Month query
- Selecting into a variable
- Using EVAL() in a Query with a nested Field Reference
- Skip to Next (in a for each next loop) if condition is met
- text box dependent on other text box entry
- Secure Database Code
- 1st character of field Uppercased only with input mask?
- How to make button filling in the present date in a data field
- VB code that uses recordset logic and split function runs very slow
- Monthly Attendance Report
- Input mask field is _______: I do not want them visible / mouse cursor not to 1st
- Error in Visual Basic closes the database
- How should I use NotInList for this application?
- Delete table and associated relationships
- works at home but not on host servers
- crosstab queries formatting question
- multiple selection
- multiple selection
- Variable Field not wanted in Access Queries
- Sending email with atachments in Access 2003 (vb)
- selecting a subset of choices based on a first choice
- I know it can be done now!
- Transparent Background on Subform
- I was pleased to see a couple of ttf files in my runtime distribution fileset
- ADODB and Access Reports
- Relationships confusion
- Set Recordsource
- Pulling info from linked table based on text box entry
- A97's 2427 error - Why does it occur when refering to a textbox control?
- Making access 2002 fill in the city from a zip code tbl
- ADODB Connection String - Prompt for Password?
- Another Mail Merge Question
- How to put the ID back to 1?
- Refresh sub form after entry
- Opening Access 2003 dumps copy buffer
- Open Form Smaller
- Question about mde
- Open a form to the position of the mouse
- Open a form to the position of the mouse
- Forms, Reports align on decimal
- unexpected prompt in report
- Transform string : "c;b;a;e;d" -> "a;b;c;d;e" ?
- Query Problem
- How do i create a validation rule in a table
- Two or more Access Reports -> a Single Snapshot file
- Embarrassed to put this on the forum - but here goes anyway - can't see controls on form
- 50 forms later, I forgot to set the form captions...
- Dates: Using a query result in another query
- Method 'Range' of object '_Global' failed
- Multiple sql statements in insert query
- Can someone tell me what is wrong with the syntax of this WHERE clause?
- Statement works in Access 2000 but not Access 2003
- Invalid argument
- Need help with building database
- Gather information from Excel PivotCache
- Question on Dcount -
- A97 procedure causes keyboard CTRL key to get stuck. Why?
- Excessive Calculations Please Help
- Some SQL trouble
- SendObject process automation
- Opened Form is not getting Focus
- OnFormat Event
- A2K3: Custom grouping for report
- Limiting no of chars in unbound field
- Calculated fields
- getting the name of the current field on a form
- Determine whether a specified control exists on another form or report object?
- Programatically Get A List Of Subfolders
- How to extract OLE Object (Bitmap Image) to file system?
- Want to Open a form and have NO default
- How do I get this query to work?
- Question on Access 2000 Report Design
- Is =GetMyCriteria() a valid criteria expression in query?
- Limiting Command Line Executable
- Calling user-defined function from query
- Strange behavier in execution of this SQL query....
- Dynamic Choice - Print or Preview
- 6 digit Date Format
- How to dynamically assign a query field its criteria?
- Example of an access update query
- Report Error: Multi-Level GROUP BY clause is not allowed in a subquery
- What's wrong with this get last day of month function?
- charting - time axis
- form event question
- Can someone tell me what the significant difference between Date and Variant datatypes is?
- Can I use A97 DateGrouping property to find Sunday date for any week?