Microsoft Access / VBA Answers - Page 74

Case statements using SQL in VB Editor in Access
I don't understand this at all...
Code VS query gives different average
could not update;currently locked > MDB is split and replicated.
Retaining Default Records After Editing
Help!! - report to show gpas between dates
Öffne Datenbank
Öffne Datenbank
limit records in left table but all records in right table
Excel to Access
Deleting a table in another MDB
2 Weeks Ago (for date field)
Runtime XP e Access 2000
Field level permisions
programmatically lock controls?
Date field problem
Report sub form filter
How to prevent copying
I don't understand this at all...
Access 2003 user level security
Populating field based on previous field criteria
Stephen Lebans Calendar
Creating a new database for items and quotes
Creating a Item / Quote / Sale Database
Vertical lines not printing or exporting...
Subtracting Time
Union Query
Notinlist Onthefly
Another Way to export OLE to JPEG....
Entering data from one table into a field on a form
sort report by year (weird format)
Audit Changes to List Box Items
javascript in a query's text string
<<help>> with sql statements run from a macro
Creating a query in code
Access 2002 Auto numbering key
Access 2003 MDW issue
Importing a collection of Excel workbooks in Access
Listbox with time
Need Help For Comining Two Tables With Same Fields
dimensioni Corpo di un report
due valori da una casella combinata
Legacy data in combo boxes
Show/Hide ComboBoxe/s base on a tick box answer
Sorting out the duplicates
Problem with SQL filter
Import Date Mask for Excel
VarPtr() Fun
How to remove or change title bar
How to control the Access Title Bar
splitting memo field at character limit
Help with command "Find Next"
Unable to design/preview a report
Add and/or delete records
display date numbers on report based on form
How to close Acess
Problem with Drop Down Menu and Subform
Validation Rule Error
If statement in 'After Update' event makes it miss other code
Convert rows to columns
Sub-Report Recordsource
Need help with criteria for a query - want all records or selection from combo box
Linked Table Manager
Printing Problem
Access 2003 - opening a form to show specific record
Send an email directly through Exchange
Excel to .MDB using macro
The print current record on specific report problem
Report Control
Show time in scheduler?
invalid field names when importing from excell
Turn a query into a table
Using a command button to toggle a checkbox
importing xls with invalid field names
"Invalid Argument" - 2gb isn't the problem
"Invalid Argument" - 2gb isn't the problem
Can I change a Label in a form on the fly?
Bad Code Needs Help
Switchboard Buttons quit working
union query - strange unwanted grouping
conditional autonumber ID's
Calling up cost prices
AutoExec - Action Failed
Updating between two tables?
Parameter Query Problem
Help With Removing Filter Properties From Form
Requery subform
sql quest
Problem in a form based on a query
Tool to export MS Access forms, queries, tables, and (eventually) code
Mail Merges in Access/Word 2003
Problem finding sum of DateDiff Field on report
Fill colour in field on a report
Changing Text to Uppercase
Appointments System
help me please
calculating date differences on dynamic variables
Dates Printing 1906 instead of 2006
Pass Through DDL SQL to Oracle Express via ODBC - Run-time Error '3003'
Cannot see tables even though they are there
Cascading lists problem
Access "synopsis" function?
How to Update 2 fields
M$ CREATE TABLE DATE Issue
CurrentDb in a DAO.Database
2GB size limit on Access2003/XP ?
creating formula in access
Copying Data from Access to SQL Server
creating formula in access
Experimental PDF Sketchpad A97 software available
Help on subform.
Report Formatting
Two Questions: Seeing if my query is done, and creating a RTF/Word doc
Complex query calculating sales - question explained
New Technoligy with Jet engine (terminal service and MDB)
Error for Linked ODBC tables
MS Access 2003 Crashes when I Open Form in Design Mode
Smoothly rename of buttons, combo boxes etc.
How to approach combo box with by default upper most value focussed
Conditional record navigation
Problem with my time clock database
Deleting the Values in A Field for All Records
complex Query help
Software looters cause loss of VAST amounts of wealth!
Computer Industry Workers May Face Cancer Risks
Build Shortcut Menu missing in Acc2000
better syntax in A97 statement
What Does a Valid Date Time Format Look Like?
Convert Text String to Actual Date/time variable
findthis.info
validating form fields problems
More on "cannot open another database" error
Microsoft Forms 2.0 TextBox
VB and an Access 2003
Create a multiple parameter search form for a query
fraction number format?
Sending a Pivot Table by Mail
Where Clause in OpenForm statement
Monitoring Record Alterations
access linked tables causing crashing
US/UK dates problem
List of all table names beginning with "ABCDE"
SYNC Form to listbox
SQL to find minimum value for each Distinct record
New job Access 97 help please
For...Each statement?
Can anyone help me on a data table problem?
Parameter Data Type Problem
Looping through continuous form
Optional criteria in query
data in url
Flag particular dates
checkbox text to yes/no
Why?
Sample Access Databases
report sorting
Access closes when activating vba code
How do you count the similar data in MS Access
How to shut off ALL Menus ?
.bak and .mdb file - corruption
SQL Query.
Display Current Month in Query
Mailing List needs CASS certifying or Barcoding
Import and append spreadsheet with multiple tabs with button
RecordSet and SQL Insert Query Trouble
Using a module to refference/control navigation buttons on a subform
CopyFromRecordset Error
Query by form
How to open a QUERY made in MSAccess2002 in VB6?
Painting the MDI Form with Desktop in VB6
Exit Button for Switchboard in Access 2003
Subform not displaying due to missing record
cutcopymode
How can I enlarge the size of colume in Access?
Run-time error 91 Object Variable or With block variable not set
Returning the range of a particular time
Runtime Error 3061: Too Few Parameters expected 1
How can i convert foxpro tables into text files
Lebans monthCal on subform
programmatically disable "Show Window Content while Dragging" How ?
Modifying the Window menu
Custom Format - QUOTES - blank when 0
Creating a quote comma delimited .txt file from Access
Getting a Total from a Single Table in Access
Bug in subform's Record Source when field added
Custom Website/Database Design
How to make a value list's rowsource to reflect records in a coluimn
Doing a lookup with a small local table and a large ODBC table
report record source
Help with report templates
Need help with an SQL statement
highest percenatage
Linked Table Manager
Slecting Max Date from 1 table
Can I disable the "X" for the application?
Normalizing a recipe database?
Modification of Title Bar in MS Access VBA Application
Using orderby with multiple fields
Accessing rows on a subform?
Open mdb in non-exclusive mode
Large Text field
middle tier discussion
Probably a dumb question
What is CRUD?
What is CRUD?
Mail Merge problems using Word 2003 and Access 2000
Automatically "fit" query design view table/field grid columns.
Update currency field
"Sharing" two tables
Can only see partial tables without old link
Unbound form and subform used for new record creation
Order of subreports on main report
MS Access reports to XML to .NET
Combo box question
Transferspreadsheet - simple question
Report Help
suppress Zero in Charts - MS Access
Question on Mail Merge with Shell Command
Find record - Simple problem
Help......replace Access with a .NET front end and SQL Backend solution
automatic graphics in forms
two sets of data in one query
Display of Total work in Seperate display field
MS access form problem
Totalling subreports in main report?
remove first characters of variable
Better way to update two tables ?
Field calcuation with an included yy
Question on Variable in Access
default printer on toolbar in access 2002
Problem on using SQL in VB6.0 with MS access Database
Access Automating
button on a data access page with more than one function
Access 2003 and SQL Server 2005 Express
Can't figure out the right Table Design
ALTER TABLE syntax?
Two questions
Access Front End to MySQL Database for Reporting
Largest Values & Count in MS Access
Default to Last Record opn a Form
Problems with SendObject after Upgrading to Access 2007
country settings
Using VBA to Link a Directory of CSV Files
Need Command Button to Bring up Pivot Table
Need Command Button to Bring up Pivot Table
Need Command Button to Pull Up A Pivot Table
Unable to set .SubDateSheetName=[None]
Split Time
iif expression in multiple table query
Using SQL Server as the backend
Sum problem in Two Fileds
Export truncates field of "memo" datatype.
Check if record is saved
Time Problems
access -> excel
several look for only one look for field!!
Microsoft Access User level security wizard
a sql query that doesn't return any record (performing date comparison)
group by similar columns and append others and add new column
Comparing Combined Columns
Help: Search form and fill in record for that field
Does anyone have any utilities to help with dashboard/switchboard designs?
Database corrupted error
Repeat Header Section
Orderdatabase - Difference in sale from one year to another - SQL?
OT Windows Vista and requirements
Left Join with criteria (long msg)
sql script
/repair from a .bat file - access 97
SQL headache
how to link to a back-end .mdb file on the net
combining text fields results in number
Automatically increment a value in a report's textbos or label
Correct syntax for Function
Help!
Migrate from MS Access to SQL - the easy way
Need help combining some fields
Add Option to OptionGroup
Write Conflict: Form / Subform
Transpose a Report
Change tab control background color
Help with Error
Access Queries
Read only records when a form is open!
DBA or NOT
Informal Poll: Access v. Other Programs
MS Access using MySQL
check for null in module??
Append ADO recordset to table
Calculating between dates on separate records
Smooth Refresh of calculated control
START UP FORM, PAYROLL AND CURRENCY DENOMINATION
Access Causes Permanent Problem in MSWord
Security problem
Date format in update query
Batch Import text files to Access
Pennies problem
Passing data to URL
Pivot Table to Report
What is the data type for an auto number value?
report address formatting
Slow With Multiple Users
VBA Code
Auto add of date to Subject field when sending email
VBA Code
Default Value Autoincrement within a Subform
link microsoft word title to a value in access
I need a shove in the right direction...
LEFT JOIN question
Grouping several reports together?
copy and paste multiple records
Reports - Showing Rows when there is no data
access97, is there an event triggered when you undo the contents of a field
Associating a color with a field.
A form to enter report criteria...(couldn't think of a better subject!!)
Suche innerhalb eie Datenbank
Looping, extracting and emailing?
Report IF
Combining multiple tables into one table
Delete Query and Macro
Trying to understand Group By
run simple SQL code from within a query
Query Help: Mutiple Relationships
Toggle buttons to display an "X" if the item is selected
Citrix and replication
Automating queries
Office2007 and emailing
automatically replace 'sf' with 'sales faculty'
Inlavid Operation ereror when refresh table link
Need to extract email addresses from Global Address List Distribution LIst
ADO Filter With Dates
Subform Name
Form to select the data from a table using multiple queries, save to another table
Email
How to lock entry
OT. Full version vs runtimes
Network traffic
XP SP2 and memory error
Creating a report of Metrics
Drop down box
DAO Recordset problem
Image Control SizeToFit
odbc problem or?
Images
SendKeys - is it error-prone?
Multi-user, offline use for Access database
Text in an expression
Trying to insert data containing #
Bookmark problem
Get Form Data into Parameter Query ?
Grouping
Data Access Page - Intermittent Read Only
Access 2000 SubForm Problem...
Customize Add/Delete/Modify in Data Access Pages
Requery on bound combo box causes data to disappear on continuous form
DateAdd Shift
using variables in query
Booking System Help
Create Table
Running two queries concurrently on linked tables
Every customer's last invoice
Creating WHERE string criteria on the fly.
Writing files to My Documents
Help with corrupted database
Filling Combo box with values from a query & value list
couldn't update/currently locked
Problem with query result
Printer object in A02/A03
serious error
serious error
How to programatically FTP an adp from web server
adding an auto field to an access table
Relationships
FormOpen error after installing IE 7 beta?
Repost: find record in form1 from form2
SQL Query Translate to Pass Through Query Problem
Tabbing into field causes form to go to next record
Horizontal Scroll bar in a combo box
Access 2000 & Linked SQL tables problem
Using Access 2000 across the Internet
Datasheet form - cant add new record
Count Days
Access Relationships Window: Proper Layout?
Wildcards & * including null values
Search record form
Reporting my database to the GM!
getting the inventory of macros in approach
In going to Mars, SOFTWARE property rights will play a key role!
Image control sizing
Query to Initial Email?
Combining two lookup fields
User Settings: table lookup vs keep table open vs load into variables
Form Macro Button Help Needed to Explore a File Directory
I need help with DLookup criteria
EXPORT ACCESS TO SQL DATABASE RECORD BY RECORD...
Forms Events & Invalid use of Null
Update Text Box
FE keeps decompiling
Creating a directory
Linking ADP to an MDB
decryption
Blocking form changes
query to increment record numbers
Is it possible to substitute an expression for the middle parm in a DLookUp function statement?
Cannot find forms/reports/code
Print Document direct from the form
Access mde files
Controlling edit
Superscript in a form or report label?
Which form is the "Current Form"?
Encryption via VBA Code
Notes To Do
Show newly added record
Zip mdb using Batch File
Trouble With saving fields brought in using combo box.
Record Locking Problem
High Volume Data over LAN/WAN/VPN etc...
mouse over and help assistance
Moving tables from one database to another
Application.Assistant.On = False
Determining whether an open form is being displayed in form view?
I received a 3072 error from ms access 97
is null and Asterisk wildcard
Compiler error: A module is not a valid type.
Wish to filter the records in subreport control (or subreport itself) upon opening main report
SQL query similar to DISTINCT help please
Declarations in Modules
AutoNumber and Filling a text box display with autonumber
Running code when access shut down with cross
INSERT INTO without Duplicates
Spoiled
Adobe 7.0 PDFMaker with MS Access
Referring to a specific column in a subreport control from a textbox on the main report...
Matching Report with Form with data from Synchronized Combo Boxes
Selection in a combobox
Keep a value in the combobox
Help - "this recordset is not updatable"
Add Audit Trail to Table Modification
MANY problems with subform in tab; want to add new record (adp/SQL)!?!?!
Sometimes when I attempt to refresh records in a subform control on the main form - it doesn't work
Create a number of records base on a field value
Macro problem
send command to other users within access
Printing Mailmerge word document from MS Access
Create Group, then add table Programmatically
DoCmd.TransferText rounds single numbers
Access Question : Week Number
Treeview control
delete duplicty
Create list of dependencies and dependants
Print out a report based on a few tables
Temporarily remove referential integrity checks through VBA?
Access 2003 macros in Access 2000
"registry error" when exporting Print Preview of a report to .rtf -- /profile
Split and Count text in a field
Split and Count text in a field
Help with Query
Trying to format zip code
how to show images linked to records on a report
What does this mean ==> ?", ",""
datebox
Cancelling current record
Question on Access 2002/2003
Citrix and prtDevMode properties
Results in Parallel columns
Find a record with a maximum value in a group
Using Return key as Tab key in an Unbound field in Data Access Pages
MS Access NotInlist add to combo box
Access Database Security
MS Access VB error 424
Marginally Slightly OT - Read/Write permissions for querying
MouseHook.dll Missing
Merging query data
Contents of Combo-box window auto-cleared
Empty field ignored when ORDER BY
I can't save this query
Displaying data from two tables in the same report
Lock the particular record in MS Access project and the Db is linked with Sql Server
Visible data with If/Then
IIF statement in MS Access Queries don't return false argument
Scheduler to Automate Email Code?
HELP WITH AUTO EXE PROGRAMMING/CODE
Permissions for one form changed
Prohibit record navigation
Maximize a control when a form is maximized?
Access not showing image on the form just the filename
Normalize Linked Table with Queries
Query Def and multi user environment
links relative path
<cr> after the 1023 character problem
insert a textbox value into access
Complex Cascading Combo Boxes
Double Records in Report
populate Tab Control dynamically
VB code to fill date and time in table row
Label Printing
Dynamic Query in Ms-Access
De-crypt a MDB Database
Access Query too complex?
Import using a matrix?
Macro-Action Failed - Halt
Help With Access Error Message Please
Remote Database Access
Map old to new values
Set up text boxes in VBA
Web Browser Control/Continuous Forms
cant get next number
GROUP BY and CASE STMT
help me understand this code.
Simple question about graphing in Access 97
mdb file copy while access running
Data disappears from Header textboxes
Macro pastes rather than evaluates
update default from table
DAO.recordset
Select from "linked" tables?
embed/link OLEObject(pdf,doc,xls) in report
Import Excel into Access Table
insert data from stored procedure into local access 2003 table
Import files into table
Access Query question - HELP!
Preserving 'Arrow' Appearance Of Pointer Over Text Control?
MultiSelect on a form to generate different records ?
Queries with the same number of records!
Access Report Only Works on Specific Comuters
Going loopy
View Access 2003 database in Access 2000
SQL query help
A basic question: Removing duplicate results from Max function
Display several dates on a calendar
MS Access
Question about where clause
Change printers with VBA
MS ACCESS
Update table using data from another table - MS Access
get number of fields in a table?
Searching form for specific record
changing system date style with code
formtotal
Too much in front end?
easy way to (almost)copy a recordset.
Open Ms Outlook using Relative Path
Creating normalized tables with queries
Open form to a specific Record, but show all records??
Good use of CurrentProject.isConnected ?
HTML Emails from Access
Access Exporting help
Sending E-mails with Outlook from A2002
How to find out how an Access table was made?
Macro or Query for compare 2 table