Bytes - Microsoft Access / VBA answers - Page 21

Diff between pessimistic lock and optimistic lock
Appending data to multiple Tables in Access 2003
Unreadable record in Microsoft Access tables
Access 2003 & Vista
Expression with "No Value"
Using UniqueID numbers in a link criteria statement
Upgrading from 2002
how to enter a new record on a form
How to set read only custom menu bar
Is there a master table?
Creating a table-level validation rule to compare date fields
ASP/ADODB - Memo fields and richtext format
What effect does a network card have with Access?
Conditional Formula for Computing Commissions
Touch Screen Buttons?
invoice report - original + copies
Automatically input next highest value
File not found Vb -Access
controlsource
How to find all existing table names in Access DB
Open External Database Form
Time conversion from military to clock time
Migrating away from MS-Access
insert a record
2003 hyperlink default folder
Access 2007 Report Formatting...
Exam Results
Creating the correct type of table
Locking a form
Parameter query with IIF
How to create and retrieve an autonumber field
Access VBA Forms
How to combine 2 Access databases?
Use of Visible property if matching record found
runtime -expression can't find function
Form formatting
Input Masks?
Table to Report - Missing Data
Problems from making a access database
Help Creating a Commission Database
Startup Properties Help
Custom delete messages
Help needed for a Query
read/write word document properties from Access
Sum of field in unrelated table
With Export File Wizard, "Two Few Parameters. Expected 2."
Open mdb exclusive, permissions problem.
Compact and Repair Database Messed up a query of mine (i think)
Finding Oct-2007 record within 2 Date fields
Using OR and IIF
access form - expression
Combining Data from 4 Tables
Save a new form in MsAcess in a multiuser database will open
Two ldbs for one mdb?
Is it possible to conduct LIKE inner joins?
Access 2003/Outlook 2003 send email from Access
Access Lost and Found Template
Manipulating Rows In Access query
Access (no pun intended) to menu items
changing controls specialeffect at runtime
not populating all of my textboxes from selection in cbobox?????
Form display error #Name?
Unbound field in Report
Nested queries vs. junction table
Display Records Not Found
Use of ":" in Query Fieldname
Getting back a deleted record
query: setting a condition on a calculated field
Code for combo boxes returns error message!!!
Using Combo Box To Select query criteria
SetFocus doesn't bring opened form to top after first time
Order Command for Fields in Listbox
strikethrough text
Date parameters in queries
Programming Challenge Using Access (Contract Management and Monitoring)
Programming Challenge Using Access (Contract Management and Monitoring)
increase db size
How to stop this popup msg ?
problem with query SQL
Need Help on Access 97 --- how to use the Calendar
Problems Upsizing to SQL Server 2005 Express Using Wizard
A Simple Vba Application Required
Auto populate a field based on selection from Combo box
Font sizes in 'rich text' control
multiselect listbox -> populates subform in a form in a form! ;-)
MS Access 97 - Decrementing total in a query
help - scan in access
Default use Specific Printer and Label Size
Cancelling Outlook meeting requests
problem with access deployment in using runtime app
MS Access Combo Boxes & SubForms
MS Access Combo Boxes & SubForms
Identifying non-duplicate records
Can u set reminders in a microsoft access database
Print Preview to last page of report
Item not found in this collection. (Error 3265)
Command Button Responding to Input and Click? (Total newbie question)
Add text to a chart
Opening Sub Forms
Switchboard and Forms
Setting textbox to accept data after a check box has been checked
Syntax Error For Null Date Field
Validation - comparing values from another table
Making null a higher number
want to find a patrner for yourself?
problems with edit and movelast
Limitations of Access
Transfer spreadsheet functions - unexpainable results...
Validating Date of Non-Date Data Type
On Error Goto programming issue
Finding a value NOT selected in a listbox?
subfrm1 textbox "On Click" opens subfrm2 with same record
Access Query Critera, select from a table
Access 2007 Old Date format
Versions of Records
default code for Save button
Data Acces Page - textbox displays from dropdown selection
PasteAppend - Clipboard not responding
PasteAppend - Clipboard not responding
Concatenating hyphenated numbers with text
Preventing a report from being blank when one field is null
best way to gain exclusive access in multi-user environment
What is the maximum number of records Access can hold?
DateValue - Data Type Mismatch (URGENT)
odd characters when i send an e-mail from the database
Access Form with some VB 6.0 code
Report page setup properties
Script to Automate 'Get External Data' in Access
Acces Icon and taskbar grouping error?
Pivot Tables
Code to determine query
SQL query to work on two access databases
SQL Query for two Access Databases
& sign on a control
Strange delete record issue (involving msgbox)
Autonumbers above 100
A strange virus that disables reports?
Table Security in MS Access
SQL statement to report a tables's attribute types
Save Current Record on a Form
How do I create a hyperlink button on a form?
Help Req In Insert Query
How to maintain a dates on subforms descending sorted
How do i calculate a difference between 2 dates ???
importing ATT files into a database
Chart Bug In A2007?
How to filter report using button in Access 2000?
Transpose Report
"update" a record in a Form
how to open a subform within a main form using a button...
How to disable or redefine the Ctrl - hotkey which deletes a record
wrkgadm.exe failed
Copy text file from web server to local drive
Find first unused record number, above control number
Trying to round to a double
Querying One Combo Box in Another
Inserting recordset value into table
script to import dbf to ms access
OpenForm Method, wherecondition
average with null values
Coding to Open myBrowser and insert a Hyperlink
Using variables as function names and calling them?
Union Query with Union Criteria
Query by form seems to require certain inputs...
Viewing a calculated query field on a form
Ms Search Button Creation
emailing function
Query Results As VB Variables
A2003 SendObject error with earlier or later versions of MS Office
I have 2 db's w/similar info - need to make query combining them
Error: "Either BOF or EOF is True, or the current record has been deleted."
Populate a field based on a 'clicked' checkbox
Post Code Validation Rule
ListBox Multiple selections
Combo Box and filters
Loop System
Populating text box based on combo box selections
Me! vs Me.
Labels shown once per page on a column Report
Using Access to open, populate and save Excel template
query based on 4 queries - plz help
To have a field name altered
Reset filter, keep selection
SQL append query help
need help with query
EMPTY FORMS after cleaning TABLES
Access OutputTo Excel Not Linking properly
Mass Emailing
Sorting numbers in a Text field
Uploading Information
Required field upon meeting a condition in a form
In Access 2007, query designer sees only tables in open add-ins instead of the local DB.
Form drop down box options
Tables invisible per VBA - howto?
4 possible options (based on value combination from 2 combo boxes)
code for opening an outlook template
Need help with zip code issue on lables
Plz convert NZ() function of access queries to equivalent stored procedure
Working with subreports in a Report
Hiding Objects in Database Window
"You cancelled the previous Operation error"-HELP??
getting primary key from a table
Having a problem limiting results of query
Regrouping data on a table (from a table of all transactions to a summary by customer)
null problem
Subforms to filtered reports
Use of OutputTo for a report with a Where condition
how can I call a check box which is on a frame
String Manipulation woes
prompt
Export Access Report to Excel Keeping Formatting
Force "Insert Into" to use default values
Please help me in Date format conversion
Ascending dates in MS Access reports
Please Help Me
Form Data Extraction Question
cascaded combo boxes not refreshing
Help Required In Uploading Excel Files Into Access
DateAdd(DateSerial()) problem with months and days
cascading text boxes
[SQL] Matching One to many relationship, difficult.
Problem with MS-Access 2003 Listbox display
Looping a recordset definition based on number from array
Select Unique ID with only a set of values
Upload file to Access database via form
MS Access User locking
Form/Field Behavior
Progress bar
needing average..
Code to export Access records to Excel
Using Count or Sum in SQL and return 0 when null
System Builtin Function cannot be read
Running Modules from the Database Window
ODBC Linking
Missing "Microsoft Internet Browser" activex control
Trouble flipping name field in query!!!!
Combo box auto-prompt # text boxes
Printing multiple copies of a record in the same report
Closing previous form after opening new one
Rounding Number
linking a dlookup
Manifest retrieval database.
Looping a table as a Where clause and send emails.
Formatting more than one field at the same time (and dates as dates)
Network Problem
Access 2007 Runtime - Trusted Locations
Install problem... (Wise Installation)
Archiving and autonumbers
Testing for non existing table entries
Repeating Information on a Form
Tab (page) with Dynamic Questions
Creating a button that closes a switchboard and exits Access
Problem with recordset.fields(i).Type, it doesn't give the type name?
Refresh Tables Question
Check Values Before Insertion
Master/Child Link Problem
Displaying Code modules
Losing data in MS Access
OpenReport showing single charater for a field
Programatically checking Allows Null property of a column
Using the Combo Box's Not In List event with multiple fields
RE: How to print MS Access 2000 report to PDF995 printer by VBA Code
Access 2007 Client
Combo box to select report language
My forms commit anything to the database
Check Values Before Insertion
Extension of LogIn Table to display form based on user status
New database template
change the form based on options button
Change records in ms Access based on Excel spreasheet?
Reassign the Function Keys (F12, etc.)
Trying to combine 2 queries and one form's data into database inserts
Making the form blank
Can't use textbox in form to populate a table
Duplicate Entry removal
Excel Report
Calculating karat prices.
Macro - link
How distinguish Test/Prod copies of DB for user?
using LEFT to select a whole word (the left-most one)
Report Logic (Commission Report)
An inefficient query
Using pre-assigned case numbers
Concatenate Field, Count Characters and Shorten Value
Putting Recordset Results In E-Mail Body
Concatenate Numbers And a String with A defined Number of Decimal places
Help with access queries and logic
Access data into many Excel sheets
Schedule Recurent Dates
show records 1 day in advance
Automatic Iterating through filtered subsets of a recordset
Mid and Left with variable position
Assigning SQL result to a variable
Access 2003: Even distribution
Simple Householding question
Matching Values of Two Fields in a Table using two fields on a form
Iif query
Union Query Question
MS Access: Clear a field
table design - varying contract rates
List of Forms
Multiselect Listbox\Combobox Issue
Merge 2 tables
Unbound combo box selecting records w/same name but different Lot Number
Go to specific record in form
Run Popup Form under only under certain circumstances
Compare two columns and place results in new table
Hide Value 0 in Report
Stop tables automatically generating a row
FindRecord Question
How to use ADO to insert/update/select data into a form with subform(Datasheet)
Ms Access Round Up
Input Masks
query to group names from multiple fields
Output HTML report for each selected record
Default size, label etc on new controls
Variable Type
access database locked, can't compact, no current users
One class, multiple students?
Compact and Repair in off hours
Need help updating record (or combobox)
Linking databases
Access 2K3 Append/Update ignore non null cells!
Create Query to evaluate Max Date recognizing Null as High Value
How to change the RowSource in a SubReport
Reindexing Id No. Of Data Record Of A Table According To Date Feild Of Same Data Tabl
Problem with query
Email with MS Access and CDO: showdialog before sending
Access 2003 error shows after change DAO reference?
How do I Print a report with code
Visual Basic - NonDisplay Characters
Input mask problem
Unwanted scroll from mouse wheel in open form.
Multiple Records from Multiple Fields
problems with date and queries
Filename of current mdb
The use of timestamps
Synthax error in Conditional formatting
Using default value to clue the user into what info to type
Reading table from another mdb
Statistical analysis functions in Access?
MS access 97 select query
Trapping for Ctrl or Alt Key?
Data Type mismatch error
How to update inventory?
Join two columns to the same lookup table
Quick question about Count expression
Using find and replace in different fields.
SQL loop for pivot table
Day View Form
ADODB.Recordset.Fields.Update - Method not available
#deleted problem when deleting records from sql server through vba
Run-Time error 2001
Question about creating columns from data in rows
Help w/ Calculated Fields
Access Expression Builder
Word Document Linked to Access Report
Automated Indirect Replication Issue
Check for BeforeUpdate success..?
Updating data in 4D database
I need help understanding DateSerial()
Interesting bug with Access 2007 ribbon menus
Oracle Back End Access Front End
Strange problem with access combo
weird tables in the database
ID numbering
Comparing Records from the same table using Access 2003
Error From Jetdatabase.....
While open the report
How do you enter multiple terms off a list into one field?
Report Error
Simple listbox query question
Compact and Close creates new database
microsoft access has encountered a problem and needs to shut down
I can't seem to get the dates right
Find and copy record from one table to another in Access 2000
Form_Current() getting called automatically
String up to 2048 characters long??
Report calculations
Primary key dropping unexpectedly?
How to attach 2 reports to e-mail
Access 2003 crosstab query where criteria as increment
OpenForm WhereCondition not working
Get Line Number ()
Operation must use an updateable query
Sql statement
TRANSFORM (Crosstab) Query
find value of control defined by string
cddb or freedb queries
How To Hide A Form In Ms Access2003
Domain Aggregate per record?
"Undefined function '--' in expression" Error message
Option Explicit statement
Auto populate fields
Mircrosoft Access: Opening a sub form with a command button
need help with IIF statement
Combo Box not displaying all calumns
Book Suggestions
Dependent combo boxes and also unsure if need a sub-form???
The Dreaded DCOUNT Function in a Report
Open other access database from button inside access database
Type Mismatch - Not sure why
Importing Dates in MMDDYYYY format from Excel into Access Tables
Need Help With Date
Combine Rows and create fields
sql search problem
DLookup Syntax
Query Problem With Calculated Field
Filter records with Right string
Need to Dedupe a table
Dlookup Field Not Saving
Microsoft Access Vista - Emailing Problems, help please!
Setting focus to control after navigating to next record...
Prevent users from viewing tables
Truncating imported text
Sum function not summing correctly
DSum function in a report
Using Bar Code Reader
Export data from an ACCESS report into Excel with correct formatting
Adding fields to an existing Access 2002 table
HOWTO: Import data from XLS into Access Table containg AutoNumbers
Access '97 - Preview Report at "Fit" size rather than default "100%"
Wanting to sort a Cross Tab query in Month order
If...Elseif...Else...Endif question
Working in backend?
Data Access Pages
How to Code This Logic
Table Update Brings Wrong Number Of Records
File name for linked tables
Limiting a drop-down selection in a table
Insert Into - Code
Action Queries
Copying Text
Incrementing Letters
Forms
Memo field in Query behaves like a Text field
Filter subform based on a query .
Table layout for multiple product types
Schedule more access applications
Exporting Data to excel
Mailto hyperlink in a text box
Filter for null and zero length string entries
Multiple if statements
Access 07 ComboBox Filter results category subcategory type SubType
Access 2002-2003 file format
Update query, dcount, two tables
Default Value
prevent copy of Access database
To convert a number of any lenght into a 10 digit number starting with 1
Getting zeros to fill out a string
How to open queries in subforms?
Problem: Macro that opens Make-Table Query attached to command button on a form
blank of numeric data type
Other people's reports printing on my printer
How to prevent users from using 'Windows', 'unhide' on toolbar
Report page break
Creating a Keyword Search that filters records in a form
Microsoft format function in query and dealing with nulls
date literal with variable
Unskilled VB coding = createQueryDef doesn't work.
import table from excell to access
Printing only 1 label out of several
Sort and group on more than 10 fields
Export Access query/table to multiple Excel documents
Creating an update query to make chages to a single tuple
Would like to use 1 field to identify up to 7 weekdays
Combining Multiple Rows of one Field into One Result
Reference to outlctl.dll needs removing
Percent format display
How can I run a macro for Excel in Access?
Run update query if a check box is ticked
Using a Macro to Populate a Field with the Last Value
Separating database from user interface.
Is there a way to run a macro using VBA?
Set database to other than CurrentDB
8.3 filename conventions for table names?
How can I store the PC %Username%
Make Table Query & Losing Format
Writing Calculated Query Values To A Table
Date Field to Day of Week
Have a date on a subform change colour depending on another form's date
Conversion of date/ time fields
Runtime error 6
doubt in access subform
How to Create Dynamic Tables in MS-Access?
Search functionality
Access and Outlook Contacts linking
How do I force the inclusion of leading zero's?
How to open queries in subforms?
accessing a 2nd db using code
Update Multiple tables with one form
select command using oledb data base
Assign randon number to all records in one field
Quarterly Queries - Automating the Date
Debugger Blues
Fix PC Problems
Conditional Hide Of Form Control
Save the rankings of a Top 10 list for future comparison
return a value in combo box based on another combo box's selection
How do I "Copy" and "Paste" child subform records in details section?
how to Assign Getrows values to a number of variables
Access 2007 RunTime Ribbon
Blank Access window when using Runtime Mode
How to Pull All as well as specific data
User-Level Security: Prevent Default Access
VB question
Tabbed versus tiled views in Access 2007
EXPORT a .txt file but inserting data prior to export
Can a MsgBox-like popup be built using an Access form?
Variable Subforms
Find "11*" in a table, but not 11* using a wildcard
Setting Parameter criteria ?
Multiple frontends vs one complex frontend
Subform Scroll Bars Do Not Display
Distinct records
MS Access Requery problem
Autonumber strange behavior?
A Level Project needing assistance
Can't find project or library - Access 2003
Cannot update ODBC linked table even though I have R/W access to the table
How to test for membership of and AD group
Cascade deletions for Junction table
Dlookup Function Help ???
Access 2007 - CreateDatabase version problems
Export Access (via SQL) to Excel - Truncating Data
Linking table, from SQL2005 to MS Acess2003
Save an Attachment from mail
Access macros - automatically hit enter/select OK
Problems hiding command button
Access Form - Highlight Active Controls
Problem summing a recordset
Get unlimited visitors to your website
Link query?
import into access using some king of mapping of fields
Find out if a word in a text field is in a table
Convert a Number to Years and Weeks only
Append Query
I seem to be writing this statement wrong
+ is behaving like & during addition in a query.
Storing selected fields to two tables
Print reports after specified number of command button clicks
Add record in subdatasheet query dissapears when table added to relationship window
DateDiff - User defined Interval
Dynamic Forms
If then statements
Combo box multiple selection solution
How do you find out what Version wrote the database
Access with vb
Fill online forms from Access
First initial only in field on form