Microsoft Access / VBA Answers - Page 37

select query question
Merging 2 rows (moved from VB forum)
Why?: Data type mismatch in ctiteria expression
Date on a report or form
Filtering Form for a Report
Complex SQL statement in MS Access
Making records inactive
query expression in an expression
Access/Jet SQL: Date/time issues
Importing Data
Display users in shared Access 2007 database
Help with DAO record schedule EOF File Error
Allow Multiple Users
SubForms Not working properly
a2k - best way to make a copy of records to the same table?
Please guys help me out with these queries?
set focus on 1st item in combo box & error handling
acccess rights
Auto Exec macro hangs after compact/repair
Delete
Troubles with query into array
Positioning a pop-up Calendar
Writing a new record to a table but cross referencing a Primary Key ID before hand..
large 2003 app
How to Point to Dynamic Column Headers in Crosstab Query
Wrapping Text - Export from Access to Text File
Querying dates of two fields.
To Zoom with SendKeys, Shift F2, use DoEvents
Access vs Oracle
Subform
Close Explorer windows
Tag Property
Calendar Control !
Print Report Based on Query of External Database
msaccess 2007
tree menu
Opening file in vb
Blank form on Form load
Problem with ACCESS 2007 Form
Access.Application
Requery subform issue
making multiple line notes in VB editor
TimeElapsed Greater Than 4 hours comparison
Delete Query Question
Query : dynamic criteria
getting proper dates covered for reports
Opening a Macro in Design View
DB2 Dbase Locks
Can I create 'conditional' sorting on report
Programmatically documenting macros
Make procedure wait for closure of a form to proceed
Display Date and Time on Status bar
Junk values in table
Using INNER JOIN to display the names instead of the IDs
glitch with vertical text in report print preview?
Cannot convert large 2003 program
Weird record level locking with a self join
Linking Powerpoint to Access
Known issues with Access 2007 and Access 2003
Send two objects by e-mail
Multiple Records Based On A Date Range
Finding Totals for creating percentages in reports
Form to be in readonly but some fields can be edited
Access 2003 Expression
Using Access to view and edit SQL Server table with Bigint primarykey
query with 2 linked databases
Select Report to Open by CheckBox
leading zeroes in alphanumeric id number
VBA Solution for Simulating Excel VLookup in Access
Set conditional formatting in excel workbook, looping through all the sheets
Booking System - Vacant room report
Timer Event
Filtering a data access page subpage in a frame in Access 2003
Print updated pivot chart report (Macro or VBA)
Text Box Conditional
convert large access 2003 app
Simple Report Question - Fields from multiple tables
DLookUP Problem
Quick Report Question
Rows disappear when converting from Access 2007 to Access 2000
Progress bar... possible in access?
pyramid commission
Adding subform entries
ODBC-Insert on a linked table failed
List Box Value
How do I prohibit new records in subform?
Use a form to update a table
Is it possible to save a record by just click on Enter keyboard button?
Export to excel sheets
List Box Value
Data Formating In Query
Query returning too many lines - IIF / IN statement?
Will Jet work for this?
Find value in field
Adding a Calendar to an Access Form
Tab Control (Form) - flashing list boxes
My query is too slow/freezes on first page.
Record Not Saved In Table & Does not show up in the Form
Progress display doesn't work
Strange text characters in query
TABLE needed to match nicknames with actual given names
Searching a field via code
Check if user clicked certain button on previous fom
How do I update Access 2003 with changes?
Merging two time fields in a report and sorting by time
Access Tick box
Close Form conditional on content in subform
Access 2003 report appears differently on different machine?
Recipe for those who are in diet
Rectangle Marker
Outlook - Access integration
Log in form problems
Access primary key reset problem
Appending to a subform table which is linked to a autonumber
Read Excel Spreadsheet Names from Access
For Each Next Problem
Instant Replication?
How do I stop Access from starting subreport on a new page?
is there a way to complete records in tables automatically?
How do I build a dynamic array from a SQL select statement
Averaging a column of numbers in a report
input form display problem.
Experience with Zoho Creater and/or Dabble DB
Double code
Count Number of Records of a RecordSet Meeting Certain Criteria
Crosstab and maketable query
DSum local variable as criteria
#Error on a Report
Urgent Help: Macro Access 2003
Dateadd criteria problem
using code for Quick Access Toolbar position
Getting Rid of #Error
Clearing rows in a form...having trouble...Please help!!
Change value of checkbox at runtime (using VBA)
Access 97 on a Vista machine
I found affordable health insurance.
Connecting to MySQL at Startup
how to display a midnight value
undefined function while retrieving data with excel (in dutch and in english)
Linking .dbf files
Crosstab query
Auto Edit record by clicking on listbox
Help with Two TextBox in one field and some PLEASE!!!
Doing an "Or" search using criteria from a text box
Sequential Numbers on Forms
Setting focus in a tab control in a nested subform when main form record changes
VBA: Duplicated code in another form is not working
HELP QUERY to return email add in REPORT when combo box is selected in a FORM
How to update records of a form from the combo box
Inserting a menu button in an Access form...
VBA Code for Is Not
hyperlink email
Changing or editing
Linked Table Data Type Problem
Display non-distinct records in sql
dynamic report columns
Searching with leading wildcard
run-time error 3027 Cannot update
Ready to use Database Structures
Invalid Character Value for Cast Specification
#Num!
Find Using Wildcard
Next Hireno
User Login Timeout
Hiding/Unhiding fields in a form using a pick list
Total newbie question
What is wrong with this?
Would this be easy to do??
Append Query, duplicates
Problem filtering a combobox with textbox input
Date and Time grouping for Production Reports
Can/should Status field be on Parent table in 1 to many Relationship?
Problem with function.
Open and email files
Compile Error in VBA
Custom icons on my custom toolbar?
How to view the jpg & tif files as OLE object
Compile error - Invalid qualifier
Using RDA method in SQL server 2005
Printing Problem
Setting Query criteria from a record/field
Access 2007 and Filter on content
Access 2007. PivotTable. Grand Total by row and by column
for loop on form(Datasheetview) , need help
break on unhandled errors??!
Error on Converting Access 95 to Access 2002
Program Deactivation
Choosing a field's record based on date
1.625 should round to 1.63... not 1.62... RIGHT?
Last Name, First Name
Need remote access
Understanding the Select Case Statement
Communication Error
Changing The way a field is viewed on Access Report
Filtered Combo Box on the detailed section of a subform
New to access
Form Based Query
Access 2003 VBA SQL Insert Limitation
Leave Opened Table on Top
Error 3111 Table or Query TMP%#MAU@
Making a Function for the Switch Board
Postcode query in access to link with googlemaps
Counting Records in a Qry
Layout
Transfer data from one list box to the other
Need help
disable a97 controls upon reaching "new record"
Report generates blank first page
How to add an email attachment?
Unable to read past teh first record in ADO recordset
Validation
Adding multiple totals
Record is deleted! Access 2003
Warning while Traversing a Query in MS Access
VBA-Create Macro (& Delete Form)
Conditional formatting on a combo box
trying to be a copycat--picture included
removing from combo box
Better ID Numbers
Search record
Sharing Access database In a Office network
Auto Run a Macro when the table is loaded
omit from select query
Unlocking Lookup without Unlocking Form
Coding Best Practise
Referencing a Subform
open folder from access
sharing a database on 2 pc's, one vista / one is xp
Select Only 10 Columns Going Back
Simple Form/Table Question
how to store my value
Refresh a subform within a subform within a Form
detect if database was opened to database window view
Write statment and Shell statement
Button Control And Referencing
How do I update fields in one table from another table
Using current record in append query
Display decimal Places
I need to edit customers with certain ZIPCODES
A Particular Database
How do I Convert excel data into access
Unique Number Creation
Problem Opening Queries in Access 2007
.mdb View & Tools Missing in Task bar
Importing Excel into Access 2007
Unsecured workgroup database
Network connection front end to back end
Subform Data Entry
Filter a report
Trouble with age in ranges
Form Locking
Making sure that correct version of client is used
Synchronising table field name change in back end database to front end client
turn a control on, then off, on a form
Mailing report in lotus notes - can ollyb help? or anyone
Displaying Full Name in drop down box from First Name & Last Name columns?
Duplicating records in subform
Really need help with VBA
Access Run Time Error 3011
Horizontal Continuous Forms
Removing "Enter Parameter Value" Dialog box
User and friends database structure
Microsoft Access can't find the name 'Empty' you entered in the expression
Union SQL Need your Honest Opinion
Transfering data from text box on one form to another form using vb
Duplicate record check prevents modifying of records
Expressions in Access 97
Moving data from a list box to a table
What would you recommend as a harmless test to determine state of SetWarnings in A97
A97 form blows up, #258
If Checkbox 1 - True How do I make Check 2 = True
Update Subform when mainform info changes
ODBC Connection Error
linking tables in runtime
Default Values on New Records
Charts
Date compare isn't working like it should
Order of Events
Access 2007 run time problem
checkbox in report
Searching across many fields with the same term in a query
transform Data - please please help... its important
two questions. 1) rowsource 2) refresh combo box list after add a record
BeforeUpdate cancel intermittently not working - my fault or not?
Using remote function
Help with this auto numbering field
MAX of Text Field Date, Inner Join
I want to Access a Subform based on a selection in another form
Acc 2000 Like Operator Problem
Need Help: Exporting more than 65k records to a fixed width text file
Problem with unbound form fields for search / building query in VBA
Where Can I Get Access 97 From
Null VS. 0 as default value in number field
Advance Import of Data
Can't see some data in VBA recordset
Access 2007--Disable Autofilter in Datasheet Subform
Form With Multiple Enteries
Add Series to Chart Datasheet
what is your processor speed.....its high or low....
Searching for most common name
Distinct selection
What can I include on my switchboard
Search Option - MS - Access
Access ADP and Stored Procedure Did not Return Any Records
Problem editing data in queries
Table locking up in Access 2003
Where command help
Has Anyone Else Noticed This In Access 2007?
A03: Can't Link ODBC Tables
Cascading to a third combo box.... on a form
Stores Balance
Selecting Specific Records In A Multiuser Database
Reference a Field's Value in a Table
Clear Subform based on checkbox
Speed up my query
Using one search button to look in four forms?
Answer to Saving Form With Required Field
Answer to Saving Form With Required Field
Number precision
Copying values from a List Box into a Text Box
How does Rnd() work? How to store a value.
Quick date format converting Access 2007 to 2000
VBA Arrays
SOLVED:Sub expects a (
SQL Help
VBA openreport filter
Expression Not or Not Like
Cancel won't close a form if no changes have been made
Using DoCmd.FindRecord
Prompt User Response
Problem passing form data from synchronized list box to master table
renaming "Exit Access" command to "Exit" in Access 2007
SQL if statement with 3 variables
Selectively duplicating records
2nd Subform disconnect from 1st Subform
Search form in access
Access SQL Query: Get complete row for 3 distinct values
problem disappears when I step through code
Display new report when chosen one contains no data...
ADODB.Connection & Recordset
Displaying 0/1/Null data as checkbox on Form
Hide textboxes with no records and move/shift left visible txtboxes on a form
Subform Does Not Display All Fields From Cross Table SQL Select
DoCmd.OpenForm problems
Selecting multiple external files via command button
Enable Sub-Datasheets In Forms
how to show names of the forms of one Access database in Datagrid?
Tab Control Code Question
How to find the most popular info. using a query
VB code in access to import and export of excel
Access 2007 jpeg display problem
Filtering a form from another form
Using AND and OR in querystring
Looping records in form
Printing a sub form report from the main form
Form not displaying when new record is added
Updating Form Using Form Events Rather Than Control Events
cron or schedule
Access application icon
Service Call Area
Variable Calculated values
SQL for running average calculations
Creating a report based on field values
combo box issue
Select/highlight text and search
help with week days
Interactive Parameters
Adding a new line to subform
all items
append queries in VBA
Populating a list box, filtered with values from the form
login to access - vba runs as admin user
Top companies recruiting this weekend - Apply with updated resume
Access Application For adding/editting SQL Records
Code in Subform
How to work with the command "Refresh"
How to force the curser to a next field in a datasheet form
Data entry outsourcing takes good care of your core business
To Compare all dates in a table
Link Subdatasheet tbl to 2 columns of another tbl
pass values to query as criteria from form
how to limit mspaint run from hyperlink to a a single instance?
I am building a search form
Building a single form for multiple entries
Unable to import or export a table
DoCmd.RunCommand acCmdDeleteRecord Problem in A2007
Syntax Error missing operator
How to make access form into html file?
Access closes when compacting and wont repair
Default Date
97 Access Database to Office 2003
Hyperlink not a hyperlink?
Clock in switchboard
Search all from one table
Estimating Program help
connecting comboboxes in a subform
Editing incorrectly entered records on a form
Sum Property in Access
#Error on form when no data present: Access 2003...
Replacing Null & Populated Fields
facing problem in query
how INDEX works in Ms Access
determine if recordset is empty BEFORE running movefirst
Compact Repair Database
Report printing problems
Access Switchboard cursor
Forms collections
Get data from next record
Printing a report query using a "print" button on a form
"When I say that I am off to do my puzzles ... all the family alsostay up the other end of the house. We have had a few "harsh" words someevenings."
Update specific record position in table using recordset
Accessing MS Access Database
Date/Time Criteria for a Query
Blob in Access
Report - How to compare year to year data
help in writing a query
Forms and subforms
Use SQL to Import Data Directly Into Access
Help with Batch File
Code for saving NEW datatable into a database
Delete record based on two tables
Normalization question
nz for blanks in queries - formatting
Subform switching Form_Load?
Loop to delete record(s) in multiple tables Access 2003
linking by table description name
Combo box pain
I need help with versions
Counting # of pages printed from a report
Trouble creating query that counts items
Access 2003 Report Format Issues
Slow Office Automation
Find data present, return yes/no, not DATA VALUE
Display date ranges
sum in access report with repeating invoice
Generating an Outlook 2003 Appointment from Access 2000
Multi Colmn Reporting within a group
Export table to dbf file and right codepage with DoCmd.TransferText
Cascading Lists for a form
On Print Event
Outgrowing Access
Exporting Date to txt file
Frightening problem using Access 2003 code in 2007
"Archive" process not working properly
simulate keypress
Syntax for using Nz function to handle blank fields in a querycalculation
linking subforms
SELECT * FROM table1 WHERE ;
VBA - Searching forms for most common name
Maximised Switchboard leads to all forms being maximised...
Northwind database
Multiple pieces of data in one field
Linking / De-Linking Tables
help with labels in access 2003
How to download files from webserver to client
Any keyboard shortcuts you routinely disable in your apps?
Make a database that each record shows a picture located in folders (paths)
OpenArgs overwriting each record
Modifying layout of pivot table form
Trouble Defining and Updating Recordset
Getting ComboBox recordsource filtered by current data in current record.
Stock
Access scans first 25 rows of a file to determine data type
2007 Query
resetting the recordsource
Subform Filter / Update Issues
SQL Server 2005 Licensing concern.
Enter parameter value error on subform
Creating a loop to save multiple excel documents...
Updating distinct rows
populating an unbound field in a continuous record form
Access 2007: Syntac error (missing operator) in query expression
Autoload data at startup (from excel to access)
Fill in missing data on a graph in Access 97
Functions - Is there a function for 'between'
Update Query define unique record for updated table
Help with populating fields for a new record
Opening a report from a form so that the last report is visable and sorted by a field
Queries - look up dates, sorting, etc.
Access Can't Import An Excel File Unless It Is Open
Is there VB code or a Macro for duplicating a record then changing one field's value
Help with populating fields for new record
Access ImportSpreadsheet and Wizard Give Different Default Field Names
SQL in place of Adodc. How is it done?
Shared database locked - cannot update - Access 2000 - Help!
pivot tables have stopped being editable
Unique Value creation
How to clear a combobox in VBA
UnBound Combo Box Behaviour
Is FormHeader Active ?
Delete content of a text control by code
searching in a continuous form: wanted a placeholder
access2007 combo stops filtering
Running Crystal Reports from within an Access DB
Data matching within 10 integers - query
Count problem in ACCESS
Frm/SubFrom Troubles
Autofill Address, City, etc.
Calculate a Moving Average and Update Table
Combo Box populating 2 text boxes automatically
Citrix - Runtime
i can't get my updatequeries to work.
for loop problem
Rick Fisher's Find and Replace question...
source Query works, Chart Doesnt
Using VBA to Update an checkbox
Delete
Requerying ComboBox in NotInList event
Combo Box that combines multiple row source codes
Pulling up a record by an index number.
Display values in a combobox frm a table
Combobox not showing full list of values
Catch right click of mouse
Database Restriction Help
Displaying Records associated with Distinct Column Values
Needing Help on Relations, Is there anyone that can help?
Overflow (Not a newbie question) VBA
Table Relations
WALK IN INTERVIEW AT RELIANCE COMMUNICATIONS
Excel workbook copy to existing workbook
Walkin Interview At Persistent in Bangalore on 8th and 9th March 2008
Having trouble with seeing form in design view
attaching report as rtf
CopyFromRecordset Problem
Waiting for Shell to Finish
Query Date Parameter Write in Report
Validations not working in Access 2000
Displaying OLE objects in Access 2007 (access 2003 problem)
Display Lookup Fields from Multi-Select List Box on a Report
How to prevent overlapping schedules?
relationships
TCS FRESHERS WALK-IN MAR 8/COGNIZANT (CTS) WALK-IN MARCH 12 (THROUGHNITEO IT SOLUTIONS)
Null result in Expression, how to populate?
BeforeUpdate vbYesNoCancel
Retrieving last Number in Field
concatenate multiselection from listbox bound to form
Autogenerated column value in access
export into text File
Update using a specific record
Calender control and listing last 5 payments made
Extracting Unicode characters from RTF
Between And Operator
Store a Calculated Value From a Report?
Form Design - PivotChart with Data Table?
Need Loop to fill in field used in Query
Access not sending email
Database Corruption issues
Access 2007: expand option of a row in a table fails
Network Access Form Read Only Problem
Add a detail (child) record