Microsoft Access / VBA Answers - Page 38

This should be easy, right??
Case or IIF?
Relationships in Access
Display Record on Form based on value in Text box
continuous labels and report setup
Getting error " '' is not a valid name... [Error 3125]
DateTime comparison problem when use format() or dateValue()
Searching for a blank field in an SQL statement
selecting one item for each hire
Protect MS Access Database
how to autocomplete a report field?
Limit records in a query by group
Table & Form
Table & Forms
Enter Key Behavior... is there more?
Alter a Query
Having trouble with query...
Year Function
Report Question
report by date
Disable Lebans' RTFControl, How ?
Freshers Recruitment & Walk-in For Freshers Feb 23-24
Excel copy/paste between workbooks - the grid disappears!
refresh combo box control
Stupid infinite loop problem
Group or Nested Classes Examples????
Protect my database
Problem with Access 2007 Ribbon
multi select list box
Help constructing a SQL String
quick query with regards to populate problem
Remove input boxes when report opens
Populate Listbox with Parameter Query in VBA
One FIlter for Multiple Sub forms
Prevent Linking to SQL Server Tables
File Not Found Error on String File reference
Disk or Network error on Terminal Server
import data from .xls file
String Function
Problem with sendObject
Query Update Separate String from Number
Access 2007 : Data Stability on Network
Day Difference in Table
Calculation of time
Format conversion from number to YYYYMM
a problem
Calling a custom DLL function
DIR(Filename) Question
can't see new customer in control
Display a saved file by clicking on button in Access
Unbound TextBox Control doesn't start the MainForm search
Autonumber
access and photo editor
Select query, trying to hard code
Changing Ribbons for different forms
Access Subforms - Passing in form values to a query
QBF in Access 2007
Calendar control
access 07 query
Complex Query Building Help
Seeking VBA equivalent of launching MSPAINT c:\image.bmp with XP's START button
Current user?
Complicated Query (or is it?)
Opening a Form with Query Specific Data
Tabs on top of Tabs
Variable Table Name For A Query
Cancel Row Insert
Copy subform contents
Auto - Start Code
not allow dublicate records
Too few parameters expected 1
Best way to maintain billing rate history?
Overflow
Upgrading Access to 2007
Can I use MySql With Access 2007
"'Save Record' not available" error
Can I bold a field in a report if it meets criteria?
Access 2003 Error: 3218 Could not update; currently locked
selecting data from 2 tables to a 3rd table using a form
when close a Pop-up form, keep main form on same record
Subform in Access
make sure a record added in a subform gets appended to the underlying table.
Automatic form update
Possible to change text box to list box with code?
Linking databases
Form After_Update Event Firing after Undo
Calculate first and last day of week
Issue accessing MS Access database on another server
flexibility of selecting fields in filtering
Form as argument of function called from Textbox on same form
Convert Excel Formula to Access Formula
Unmatched query multiple criteria
Possible to write a macro that creates a new table?
Using code in VBA pulled from database
Combo box with a red border
LINKING excel to access 2003
Including Nulls in a Query - Query not showing all records
calculate string+integer..
Need help with creating a customized search form
How do I use to combo box in a form to display desired values?
Sum problem!
Advice & Form Design Issues
Help- Problems with rst.Edit
Compact/Delete an access 97 db using VBA
CreateReport using template
COmbo boxes
Layout problems in Access
multiple instances of a form - selected records ms access 97
Shifing backend from one server to the other
Regarding DoCmd.TransferText
Is it Me!
Single User Access
A particular field cannot be empty
Using Calendar in a form
open a word document by clicking a buttton in access form
ODBC error "could not open file <path>\dba.mdb"
Programatically convert a textbox to combobox and back
SQL query in Access error
Method 'Command' of object 'view' failed
Undo changes to a record with subtables
sub for record change?
[SQL] Ambiguous outer join
Counts on Summary page
Passing Form Public Variable to query
Export from access to excel
Form does not display controls when opened through AutoExec macro
Problem with ADO AddNew
Can I change an Error Message to direct user to correct field
check new customer is exist in table
Grading Values
Editing Status Bar Text
Sub Query Problem
how to send two reports in one email via DoCmd.SendObject acSendReport,
Deleting List item using Form
Error 2105 from "Add New" Command Button
Populating many combo boxes as result of combobox choice
PHONE SYSTEM ACCESS CODING - PHONE #'s = TERRITORY
Query Results
Parameter Form
MS Access - Problem with Hyperlink - not showing 'edit' option
Create New Blank Record In a Form
Search button returns no results
Combo Box to Change Preset Textbox
EISWT-08 Draft paper submission is deadline is just few days from now
Multiple Query text boxes on a single form - MS ACCESS 2003
Tree Structure Query / Report - MS Access
Referencing Subreport Control in Main Report Footer
Related table question.
insert into sqlserver with autonumber
Macro Update Function To Table
easy edit forms
How to refer to a control created by CreateReportControl?
HELP String Parsing Msaccess
Calendar - Schedule Access 2007
FileDialog box and preventing browsing
Error 3167 Record is Deleted **
Create New Record in Form
Is this Possible?
Keeping track of which queries are open
Drop Down Combo Filtering
Self Joins in Access - Error Encountered.
Avoiding 'Delete Table' Warning in Make-Table Query
Need cross reference from table for query
Close button bug
Want to view query output in horizontal table
SQL Query
Check recordcount -table in Ms access(local)
find position in range of values and display on form
Idea plz
Trap Error 2501
compile error in hidden module - module1" error when creating MDE
Automatically assign (sort of) incremental numbers
Transfer data from one database to another from a 3rd database
Compare and Return Record
Help with this query
Updating an open recordset in Access + Separate Array Question
On Time Delivery Query
Validation by looking into an existing table
Access Levels: having different views for different logins
Need "Browse for File" button
How do I import data from a locked Excel file?
Consolidating records in a table
Date Entry - Displayed as Month in PivotTable
Return ALL records
Creating A Query Expression Help
Strange behavior: Form slowly moves down
Change "Find" Settings in Access 2007
Design view Greyed out
Access Performance question...
Create table based on records in filtered form
Using Access through a Web Server
Copy date part as text
Cant Load query as recordset
Format Excel document from Access
Very Simple question!
Access or MySQL
report repeats himself three times
Count records in subform
Form fills the whole screen
open excel file automaticallty via access btn
AddNew Method of ADO
Use a variable in place of a table Name in Select statement
Access 2007 navigation pane (with Access runtime)
Automate fields based on current date on form load
Update a combo box after changing another combo box
open form multiple times
Change a query's SQL code from excel
slowdown of query with <>0 parameter in summed number field
Heading
Too many headers in a report
Export to Excel issue
Average of a double not a double?
Multiple Users - database locking
Change Reports and VBA code from a run-time DB
Save records from a list box to a separate table?
#Name? Error Access 2007
Setting Timer
lock table
Missing data???
Combo Box in a Query Criteria Box
Calculating seven days from a Start Date
If is being ignored!
Filter a group
Checking to see if an .exe file is loaded
Write Conflict Error MS Access 2003
Creating report with dynamic queries
Live exchange rate data into Access?
Count Imported Rows From Excel Spreadsheet
preventing user to access/see/import/linking tables
Merging different reports (with parameters) into one
Trouble with Regular Locking
Filter Information via combo box
DoCmd.OutputTo - How can I add the date to my document name?
simple report idea - but I can't figure it out!
EXE For Altering A column size
CANNOT RETRIEVE RECORD by EMAIL FIELD
checkbox result highlights text fields in form
How To Find Next Autonumber Value
All or Filtered using a CheckBox
Store Value of Input For a Report
Refresh all forms if open by multiple users
Automatic filter reset
saving records
Access Report formatting
Opening a filtered form from a custom switchboard
Access Update Query from a Txt File
docmd.findrecord error 2162
Why won't this work in my report?!
SubForm OnExit Event
Force Users to log out.
Compare first 6 digits of phone number
multiuser .....
Access 2003 - How best to push front end updates?
How do I print a report based off of a continous form's search results?
Restrict use of special charecters
Primary key foreign key
Clear form button and the code to make it work
Sorting records using more than one field
Access Database Online? (basic)
How do i LIMIT the in Access
What is best way to create an autonumber that has a prefix?
Count IF on MS Access
Help With CheckBox
IIF() logic failure over ADO
Report in 1/2 hour intervals instead of 1 hour?
Displayin FromDate Todate
hide check box in form
Relationship
How to create menu from a macro
need help with database design
Running macros in Access 2007 Runtime on Vista
question on date functions
Help! Access closes automatically
Insert Into..Values(function())..
Limit Query In Reports Fields
total # of records in a report
Referencing Array elements on A form
Passing variables between Forms
refering to variable in a form.
Relationship issues
Help! Update Records with same values Query
Need Report Help Comparing Data
Open source method for converting from EUC-JP to Unicode
Access Programming
need to add text at bottom of a DETAIL list in a report
Data from memo field
issue with creating a weekly report
Validate date field in form?
Access Formatting Date Field Display based on condition
ORDER BY (SALES divided by ORDERS) ASC
block edit and delete record in form
Display EUC-Encoded field on Access 2007?
Saving matrix in access 2003
deleteting a record
Data Entry Form with a Many-to-Many Relationship
Primary Key in in Data enry Form
Update subdatasheet from main form
Creating a Pivot table in an Access 2003 report
Create String of Forms - Passing Identifier from Form to Form
From report to E-mail
Remove filter does not work...
Email Data Collection - Can I autopopulate a field based on the email address?
Printing Reports generated from Temporary Tables
Forms not behaving when opened in Access 2007!
using wild card search
Query Join Properties
Updating design changes to a Multi-User Database
Joining Tables
Having a Combo Box display part of a list based on a parameter
Weight loss calculations
Table ID Count
Query that returns unique records, except for adding one feild.
Excel report using old version of MS excel
advise about STRUCTURE for a beginner
Special Effects for MS Access button controls
Change bar color on bar graph
Using AVG in Control Source
Table help
Adding items to form in 'on-going' manner...
find duplicates query
Access Runtime 2007 - Installation failed
Runtime error on form
A2K: problem with limitfieldsize code that restricts number of input characters
Open a file with file name from listbox
2 fields, REQUIRED and NON-REQUIRED dates
Sooooooooo Slooooooow
How do I evaluate if all or some of items in list box are selected
"Data Type Mismatch" when opening Report
Trying to sort chart by month
How to get Access form names into an Excel file?
Imported DBF not pulling in all information
Disabling fields
Auto Fill Field
Display Alerts - How Do you disable them in VBA?
Getting data to refresh automatically
Exporting Tables/Queries into csv files
Passing listbox controls to a report.
access accepts the MINUS operator
Problem with listbox selecting an item
Help Creating a loop
Here,computer oriented programs only.
Re-Filtering on a current form
Save Record in VBA
Splitting a DB?
Reference/Library problems on 2003
Formatting a String Variable into columns
Auto closing
Query Problem
Send Attached excel sheet to varied email addresses
Grouping Output to Excel. Help Needed!
Memo Field
Automated Import of Non Access Friendly File
Trusted locations ACC2007
Buttons to Filter Report
Security Warning - this file may not safe...
How to distribute an MS Access 2003 App?
How to get the Total and getting the Ranking of the Totals using query in MSAccess?
Chart static values from list box, is this possible?
Not Sure How This Can Be Done
Select an item in a list box through vba
Parameter Query
auto form update
Excel Spreadsheet to Access Question
In VBA, how to make form properties "stick"?
Importing date/time values
IF THEN - Hide toolbars for users
Parse a path for a file name in Access
"On Open" Event; applying a query to open a form
Query w/ date range and grouping
Buttons 2007 vs. 2003
One user getting read-only error
Trouble referencing a subforms.afterupdate event
Trigger On Click Event of a button from another form.
Membership History
limit to number of characters in Textbox
Strange combo problem
Setting Event Order
Multiple Users
Copying CD directory contents to text or memo field
Creating a drop-down box in a Access query
MS Access: Pulling Data From One Table To Another Table
query an unbound field in form.. Possible?
Persistence, Binding, Annotations in java: an example with Netbeans6.0 and MsAccess
auto updating front-end on workstations
How to Calculate skewness and Kurtosis in Access2003 using VB
access complained: this is why...
Compact MDB back to Access 97 format with code?
and
count function query
Query Problem - Help!
Simple SQL Problem
ADODB .Open Problem
Sendkeys problem
Creating a composite key
List boxes and buttons, a great combo!
Module breaks with no breakpoint added
DSum Syntax Woes
FrontEnd BackEnd linking
Bypass autonumber
listbox and drop down list query!!
How Do I Limit Print Area on a Form
Quiz Maker
Data Type Mismatch in Expression Error - Access VBA
Compare different fields for maximum value
Lebans RTFControl, how to 'get back' to Word ??
Trougble with Combo Box
Putting in who last updated data and date into a report
Missing Records in a Subform
Access Grouping Question
VBA Help
Totals Group Query
Query Problem - Help!
from report to outlook
Date Problem
Auto FE Updater Problem
how to activate command button or hyperlink in access reports
Please guide me
Help with Run-time Error '-2147352567 (80020009)'
subquery syntax question - sub query after FROM?
Access 2007 ribbon dropdown
Access 2007 command buttons do not function - database in Access2000 format
SendObject, but for a spreadsheet?
How can I select only the rows I need?
Pulling report with two criteria and date; type mismatch on preview
How can I get "CONSTANT" behavior from a variable (Constant magic)?
SQL Optimization
Compact on Close Problem on Server
web data retrieval help
Presentation of a date field in a report
Combine text boxes
How to fix missing subform with error: "Syntax error access violation"?
Pulling data from a table into a form...automatically
Minimized form loses bind
AC2002: Command button batch printing of .xls file (with macros)
Setting the default value in a subform
Odd Behavior of entry fields (not allowing edits...)
Preview Report on Form to include subform
"Phantom" report
Access Split Database - Others cannot lauch database from UNC
insert fails on linked SQL table (timeout)
access97 & .copyFromRecordset different when using sql server 2005
Calling a form from a Query in Expression Builder
Relational table structure
Subform looking for other data tables to write the record...
send current report as attachment
Maybe IIF, I don't know!!!!!
sum or Dsum?
continuous form: records do not automatically fit nicely
Filter a Report Date field from a form
Load Image
Creating Reports from a Template
help me
Access assistance, if you can. Query related.
SQL SCRIPT SHARE
How to count unique users and also number of visits in a report
loop vs SQL
Access -> SQL Server. Any benefit on a single PC?
Dynamically referencing a variable in VBA code in Access
Using checkboxes to decide what records go on a report
Filter on current record in a form upon selecting a check box
Date&Time Picker
Help me in selecting first n records from a table by SELECT Query
runtime error 2001 only when open tabbed form
Is there a way to set the CanShrink property in VBA or code view?
SQL Getting values from 3 different tables
a really annoying update SQL problem
default value i et felt i en form
Update table through form
Clocking in time problem
how many records are being displayed
transactions and linked tables (advise requested)
calendar control help
Adding icon image to button at runtime
Linking Outlook
Switchboard problem
Crosstab click opening a report
Using LIKE in a Parameter Query - Access 2000
Selecting days
Error-Project or Library not found
Exporting specific fields from tables
How to update a price but retain old price for older records
exe setup file to run other computer where MS access is not Available
Combo Box Help.
On Record Source update event???
dll File
How to make access ask you which report you want to print
Enter Parameter Value
A Level Help
Form Won't Display in Form View
Invalid Argument
lookup tables / combo boxes
Access form won't reset unless closed and reopened
DoCmd.GoToRecord , , acNewRec
Find Percentage difference among fields in a record
String Matching in Database, how to negate leading zeros and partial match strings of
Access Function for Outlook_From Form
Please help me in printing serial no. in ACCESS report
Having a text box display by default the value of the previous record
Fill textbox onClick from another Form
Print a record number in access report
Save using Current Date and Current user profile
Memo Fields in Access 2003
exporting access records
Prompt to Save?
Im always denied! when accessed .mdb file
Trouble with form expressions
insertion and deletions are giving problems.
Preventing Additions or Edits ... need help
MS-Access through Outlook - Sender's Name?
Export parameter query to xml
Convert negative number to Zero
Form Blank Please Help
Opening up a form with it going to a new blank entry
SQL Statement Error
Access 2003 remove digital signature
Variance Query
Change column name?
How to Left Join (or outer join) a number of queries?
Retrieve Value of Grouped Radio Button
Debugger stops functioning
Concatenate all records in 1 Field and output in Text file
Can I create a gmail filter to forward certain email to a group
Searching this site question
SSL communication - UPS Electronic Manifest
Variable already exist error (MS Access)
Variable already exist
Access Graphs
put more than 255 field on report from two tables
Can access sum two fields in a form...
combo box problem -> won't display everything in a subform
Count selected rows in a table and show in this in a form
Calculate future date in access 2007
Anyway to remove #hyperlink# from .Value Property?
Access Database
Fields from two Tables on Report.
Setting a password prompt option on a form
Embed PDF Viewer Object
Access 2007 Preventing Form Updates
access user tracking
Disabling mouse wheel in a subform
XPDL integration into Access Application?
How to update linked child in subform when master field has changed?
Update column from query or other table
Help! Need to calculate and store value based on total in Subform
preventing users to import data from another mdb file
Licensing application on Terminal Server
really basic access question
once upon a time... : linked tables
Cumulative totals in reports
Sql Query