Microsoft Access / VBA Answers - Page 37

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
If Yes/No field = True, then next field is required
Query by Form - Select All Feature on the dropdown lst
Odd Key Violation Errors
Referring to Query Results
exclude records that include given value
MS Access Sorting
Autofill form based upon data from another table
How to query time range and day of the week?
Anyone using Sharepoint Services as a backend to an Access frontend
Show all records through combo box and command button
Getting data from other forms/subforms
I am stupid- Access Relationships and such
Customized Table
"Microsoft Access can't fine the field "|" referred to in your expression"
File / Record Lock Error !!
Need to create an event for a duplicate record command button
MS ACCESS: How to delete value from an option group control
Remove Duplicate events.
Carriage Return in MS Access
Controlling the 'On change' event for a numeric control.
Field is rounding off
Confusing Data Issue
Calendar tool creating random records
Problem with SP during F&R
Dynamically Unhiding Fields base on selected data
Can I put a password into my VBA code when Importing a table
Bar chart report
Ms Access database security
MS ACCESS, Syntax error (missing operator)
HELP!-Compact on Close removed my db
Unlock database in access 1997
Control Scrolling Of Continuous Form
Convert an Access2002 database to Access2007
Disable progressbar for Bound Image Object
Medical Records Database
Smoothen screen update
Search Form using Option Buttons
create report from joined tables
printing multiple copies of a report
help needed by a newbie - saving multi select values to a table
preventing user to access/see/import/linking tables
Church Database alphabetical assignment
constraint in access 2003
http post tbl records to server
Form/Subform In Continuous Form
Strange Image behavior
Adding hour/minute time in MS Access
How to round a text box value in the access form
Playing Music From Access
Unique, one-time data, programflow in Acces
Open form showing only Dates in the future
stock level update
Help My Cursor
Access 2007 export specified rows
Form Permissions
Filtering form records using a combo box
Need Pre-Populated Grocery Database.....
text box with now() as default value
MS Access 2003: Importing files and validating them
Using a recordset with Oracle
login / username
Access Error Query must have atleast one destination field
Query max records
hidden database window shows on exit
Populate Previous Month
Record Locking if time is after 7am and 7pm
MS ACCESS: How to enable control in a form based on another control
Importing fields/information from WORD to ACCESS
Adding attributes in a query
Do You Know If She Is Cheating?
Startup Form
Is Report Successfully Printed ?
does access resets margins when distributing reports?
Find and show duplicate records
rs! question
Saving Form Criteria
Access VBA Parsing CSV Field and Creating new rows
Saving form with required fields
Access 2k code doesn't run under Vista/A2k7
Automate a data type change
Can't use reports in Access 2003 for db originally created in 2007 software
asterix password
Retain fields
Security Startup Dialog
Multi-table Value Query Help!!
Locking in Queries for Reports
String Reading
Interactive job sheet
Complex booking form using VBA code
Formating the SubForm
Open a form on a record closest to the current date
Multiple viewing of form
BUidlling a query/report with several keys
Using multiple OR statements in IIF, or nesting
Unique total for each row
Access 2007 crashing with right click on subform
Printing multiple forms in Access 2007
Creating a letter in Access with data from unrelated tables
"Undefined Function ... In Expression"
Autofill password using VBA from Access form
check box into a text field on a report
Trouble getting memo field printout exactly the same layout as theform
'Undefined function Dlookup' error with Sagekey 'Access 2002 MsiWizard'
New in MS Access, need help
Removing Customize Dropdown on a Custom Toolbar
If me.dirty...
Custom Record Indicator not updating after requery
Slider bar control for modification of data in a graph
unusual Ques. !!
Drop down list in Access
How to Resolve Duplicate Data Entry Issue?
Access versions later than A97 allow more than 255 crosstab fields?
Calculating Time Query
Record Lock of Code problem?
Use keyfield in linked SqlSever query
Could not update; currently locked --> On INSERT !?
How To Disable Or Hide the A2007 Quick Access Toolbar
Microsoft Access SQL Documentation
update subform filter by onchange event on main form
Access Inner Join Delete query
if statement with null criteria
use of two record sets in ms access 2000 one for retriving and the another for updating after correction
access & website form submissions
DAO Compile Error
too many indexes in Access 2003 database
Access Locked us out of DB!
Help Union SQL for simpletons
Numerical Report based on number of CaseTypes / Dated
Copying data from one form to another automatically
dblclick event
Ms access linked sql server table update problem
How to correct locked subform to enter data
Access expression builder syntax and null value issue
Open form in a New Window using a command button
Access 2007: Status Bar Text randomly cut short
Open Custom Help
Should we Convert to Access 2007?
opinion question - deletes
Delete issue
Table Layout
Sum of 2 Text Boxes
Supress Results of a Select Query
office 2007 / Access 2000
Looping in a Subform
Help with subform values
Get subreport Can Grow to repeat upwards instead of downwards?
Importing a large .csv into Access with more than 255 Fields
Updating table from a form
Invalid use of Null
Using ODBC in Access
Format and date functions not working for users
Storing A Number