Microsoft Access / VBA Answers - Page 69

How do you make a list made visible push down rest of form information
Error message by Mid([FieldName];3;2)
Best Place To Do Validation
simple question
How to send Email when process is getting delayed
Using And in a query using two tables linked by ID
Runtime Error 3010...table Already Exists
Multiple similar fields into one query
Line Break in a text box?
Visible field question
Update a table from multiple forms
Smart Tags
Adding dates to comments
Using MS-SQL SP with parameter from MS-Access
Connecting to data sources
unbounded MS Word document in an Access Report
Data Entry Form - Index/Primary key null value
List box and command button.
refresh listbox in another form
Progress indicator for Queries/Reports
Enable/disable controls on a Tabulated Form
Date
MS Access fields in Form mode
Access Reports HELP!
stop duplicate request
trouble with decription field !!
Getting text of Modules in non CurrentDB
Filtering to only show last balance
Where does everyone BUY/SELL PC's/MAC's online???
Autonumber generator (help required)
Can't get ActiveControl from Form_Current event
Nobody knows how to return a especific row?¿¿?
"Show All" in combo box not working
SQL statement with <> and Null values in the table
Find duplicates in another table
How to format fields in UNION query?
DLOOKUP vs FIND For Values as Field names
dlookup or find methods for fileds using balue for field name
dlookup or find methods for fileds using balue for field name
converted database
Novice needs assistance with calculating one field
Date Serial problem
API Browse Folder Dialog - hamgs if open when closing Access
Using CStr on a Memo field
like operator
counting records
Check for null entry in combo box
Lookup form and adding new records
Write Conflict Message - Turn Off!
Convert A2K to A97
Query for getting domain suffix from E-mail address field?
Subform recordset (set in code) is not updateable
print current record in form and sub form
most recent records
How to receive the current folder location as string
Help creating an insert query in access
Access Defaults in Standard SQL
Printing a report on 5"x3" Labels
Dcount Help Me
How to check a library link in VBA
Calculating hours
Copy a File
Trap for enter...
Setting a reminder in Outlook
Syntax help
Double quoting question
Calendar
Calculate end date (working day) in Access
SQL Query - Returning One Specific Column
Using The Select Top ... Offset In Access ?????
Lookup existing values
Loading images and hanging access
Manual Page numbering??
CMD.EXE /C COPY - Always Goes to My Documents. How to Change?
WhereClause problem using SQL Server
Trying to re-link hidden tables and keep them hidden - but not TOO hidden!
Problem with DMax & DLookup
New to SQL Server 2005
Exporting Empty fields into .txt
Invalid Argument for large import or link
Export Query result To A Table
Query help
Cross database triggers in Access 2003?
If/Then help!
multiple markups
Changing a duplicate select query into a delete query, help!!
Automated Import TXT file into Access
Cycle through records
Open Report by looking for the Report name on a table
Using login info to open a Connection object
Master database backend (20 offices) Please help!
Can I merge two ACCESS reports into one
Problem with edit form
Replace Access Menu
Combining sheets in Access
More help with form RecordSource
Email with Outlook from Access
Replication gone crazy
Combo box
Reports on specified data
Handling filters in Ms Access 2000 forms
Problem with Pages property on Access report after hiding a section.
Declaring Variables
Mousewheel Will Not Scroll in Listbox
In Access SQL, is there a way to rollback a transaction?
Disable Customize Toolbar.:Bug?
Open Word Files From Within Access
Unbound Objects on Report
How can I find the Parent of a Parent Form?
Displaying records without Dates in the end of the section
IE 7 - caution
Pull current months data
VBA code false "rst.FindFist strSearch"
Slow Query Speeds
Designing a Summary Report entering multiple dates for multiple criteria
Macros with autonumbering
Using VBA to compare 2 tables field by field
Steve Leban's RTF Control;Justify Text Vertically?
FIND LAST instance of 'quality' data
I need to get a row of a table by it's position
slow form display
My own lookups - enter one thing, table another
Date Format Question
AddPicture to the table ??? (from Access to the Word)
undo for a form in datasheet view
Delete Duplicate records
Quick Form Recordsource question
ALTER TABLE to rename a field with a variable
Russian text problems in Access 2000
Query - incorrect output when usingthe INT function
Comparing two tables in query and highlite the changes
INPUTBOX not evaluating properly
tab control.
Retrieve User ID
Opening a MsgBox in a form
syntax error? parameter querydefs
Locking a form
Conditional formatting referencing a table...
FileSearch Object. Strange result with Wildcards
Please help me in equal distribution of a list among people
Autonumber generator
Query Problem in Access
searching date from multiple columns
Populate 3 fields in a subform based on a combo box on main form
Hide Table, Query for use viewing in MS Access
MS Access Tokenise Cells and Append to table to flatten out
Linking tables and memory growth
Data Entry on tabbed forms
Moving fields around in a Form
running totals example
Corrupt database
running totals in report
Scripting a date stamp that will create multiple entries
Security Problem
Subquery help needed
Using a continuious form to search - coding problems
need help with update query
convert QBE SQL statement to SQL for VBA
Count Sports
Use Filter string AND OutputTo together to create multiple reports
Fill Date
How to set one form and jump to multiple tables
multipul records to a client
report footer at the bottom of the last page
Types, Classes: myObject("IWantThisProperty")
Field Autofill Problem
Tab Control on Access
Excel to DB format
MS Access - Record creation date /time stamp and record modify date/time stamp
Adobe Colour Settings
Advanced Report Formatting Resource?
Search in specific field on form does not work.
convert database
How can I know SQL better
FE Update 2003 Package Wizard - uninstall required?
filtering again
ListDatabase to Access
Hovering effect on form showing data from different query Access3
Connect to ODBC driver on a different machine?
Problem with MSysTable object permission
Oracle Table Link - automatic population of username and password credentials
parameter queries
Excel Spreadsheet Grid as interface for Access
Unrecognised database format
Connecting to SQL Server using domain account
On Current fires 5 times successively
When I tab on the lower portion of a form, the form scrolls up
List Box with all tables, queries and forms of my database
Dynamic Crosstab Report
Record Locking Access on File Share - HELP
Access Data Pages, Pivot Table, Current Record
OLE Object in Access 97 Reports
String Query Help
Need query Formula for consecutive days.
Damn sql problem again(sorry!)
How to close modal popup form from VBA
Need help to get a consecutive total from date field.
low performance
Pre-formatted Hyperlinks
Table / Form Direction Needed
SQL Query - redo needed
VBA Code Help in Access 2003
ADP Issues
Query Comma Delemited Textbox
Updating a combo box
I need to set up a rather liberal Parameter Query
sql Select Count result to variable ?
Restricting access to objects
Variable (Function) as Criteria still not working...
Date stamp - Newbie to Access 2003
not a valid bookmark - not using a recordset
Opening MS Paint and Pasting Via Code
Return a count of 0
How to Return a day?
Importing from Access to MapPoint
Opened database is not visible
Date format Database to Word changes
Newbie problem! Cannot find advice for this anywhere.
sql help, please =)
OnApplyFilter event works oddly
Automatically flagging a date T+30 days
How to get values from a field shown in a single cell on a report?
Loop through a data table and then update another table
How to use blanks as valid cells values in join
Filter and Sort properties of Access Form with SQL Server backend
from sub to mainForm
how to create a group and assign securities to the access database
Equal distribution of list
Excuting query from two combo boxes.(null value)
Launching Eudora 7.1 email with attachments from Access
Help: Linking Child & Parent Forms with a 'Partial' value.
MS Access ODBC configuration
Can inner join replace multiple loop selects?
Where do I start
Help with search function
assign account executive to a file
VB6/MS Access point of sale application problem "could not update; currently locked"
Update oracle sequence's nextvalue from access form
taking information from 2 tables and inserting it into a third
New Record Auto Fill as Previous Record Runoff?
Place Execution Date in a text Box upon completion of an event
Best method of accessing this newsroup / NGs in general?
exporting pivotchart to graphic
Returnt he results of 2 boolean variables as one result
Linked SQL Table into Access -1 doesn't register
Finding Dups & deleting the first case
Problem Deleting record when Linked fields are empty
Strange Report behavior
Creating graphs from data
export each record into separate excel file
Post only 1 instance of a field in an Unmatched Query
Only print last detail line for primary key, suppress all others
Using Steven Lebans "A97Save-Restore-Modify-RelationshipWindowLayout" A97
passing a global variable to query
What is this doing?
Sort query by calculated field
Query criteria from Main Form
Plugin ocx error
Searching records using a list box.
FindNext, FindFirst method problem on form, help?
Read Email and send it to other
Handle Selected Records
How to put date created from command button into table
Reading data from Access
Error Opeing report on clients machine
move a text field to an array - search one element at a time
Passing the value of Query Input to Form
table design and history
Help with tracking of contracts
can anyone solve this sql query?
Calculating Total for Subform dispalyed on Form
NULL Values in Total Queries (Access 2003) Bug or Deficiency
sending e-mail using VBA from a button on an Access Form
Help Me
addition of new data wrongly creates new record instead of updating??-
Count in Access
MS Access and Web Interface
A97 permissions help example does not compile
link sustain
split expression
Help Creating a Excel graph in Access with VBA
How to handle multiple markups
Creating data relationships
Access 2003 Reports slow
Table defaults not used when adding record in code
Prevent Update/Append/Delete Queries
Getting the data types and sizes from Access
passing filter to a sub form
Package Access Solution
Help Needed: Aggregating Multiple Columns in MS Access Query
sum as type ....
restricting sub forms for a dummy
Update selected items in a List Box
Problem with TransferText
converting to VB
option group
reports: columns in detail only?
OnTimer to Often?
Error Message in form
Office Vista 2GB MDB limit?
filter problem
ignore null value when filtering with multi criteria
text file reading in Access using VBA
Run-time error 2424 is driving me mad
Hide and Seek with Message Boxes
documenting table changes in A97
Excel import process stops running
multitasking movefile and running queries?
how to Prevent customers downloading the access database.. MDB from web folder.
Cannot paint on image on report
How to retrieve the recordcount from a named query? Help please
using enumerated data types with ms access
Can I make both these reports from the same table?
Migrating Access to .NET
Only the first result gets a value
DLookups
List box recordset, Form recordset
Looping in Module in Access Help
tracking users
Switchboard to tables
Like for Multiple Word Searches
Problem with MS ACCESS and Excel
recordselect query to pivot chart
advice on setting parameters
Using DataGrids and Data box with Access 2003
help with ImportXML method
Include TOTALS in a subform
Stupid Access Questions
Transfer Table to Existing Excel Worksheet
Convert string to command?
subdatasheets with linked tables broken? Access 2003
opening a form using a listbox and a button
Sub Form in a Report
Error 9: Subscript out of range
MS datagrid control in MS access application
bound a form
0 + 0 = -1 ?
Calling a module function from a form - Compile error!
Subtracting rows to determine actual sales
how to make oledb connection
How to open the Posiflex Cash Draw from an Access Report
a question about "group by"
Retrieve File Path
List Control RemoveItem
adding fields together and multiplying in access 03
Auto numbering oddity
My Calendar control button stopped working.
Opening a new instance of Access along with the mdb
Import Error Tables
Addition
Interactive Calendar Help
Rename a field name using code with variables
Installer softwear
How do I get code to act on the Value of a field not the literal name
Display Results of Last Record Saved in Certain Fields
Setting Time to track Minutes and Seconds
Many queries in the same screen grid
Printing reports from a list
Editing a record pulled from subform
Update query with aggregate function question
Color Changes
how can i search subcategory wise for a particular category,i want to display items
Dependency autoincrement
How may I count rows by day?
MS Access: Binding a Textbox to a Pivot Table Cell
Wait for user to close form
Total All Groups But One
Datediff
slowly converting all old 97 databases to 2003...
disable button if field is empty
Making 3 fields a primary key????
File opens as read only from disc
Disable Right Click
append query
Tell Me about Run-Time Error : 20534 error?
Dynamic Crosstab Report IN VISUAL BASIC
Setting Query Parameters Through VB
Date Range - avoid duplicates
Justify "right to left" access report textbox
Zoom RTF2
Open .eml as read-only
Error in Importing Excel file
Browse Button in DAP
How to solve Complex Query Error !
Waiting for a file
Query is too complex
Change Numeric in to Words
MSACCESS to Arcmap and then back again
Entering info into a continous subform
Filter main form based on subform filter
Averaging figures
CDO SDNI connection not authorized
barcodes...
Correct order for closing & setting to Nothing
A97: What's a workable substitute for Dim Thing(0 to intMyCount)?
barcode in combobox
Help with table and form design
After using an array, is it something to nothing?
Solution for storing “additional” membership info in the Access ASPNETDB.mdb
Criteria in Query Problem!
save old and new value from combo box to 2 different tables
Rounding Issues - HELP!
Problems with reports, functions, and queries with parameters
Access problem; "Not in List"
To Auto fill fields on a form
changing subform view
Change Size of Check Box
greyed out command button-how to accomplish
Report Bound Object Frame Showing a Form Object?
"Chinese" letters all of a sudden
A stupid Question from a 1st day Access Programmer chkbox
Calendar out of sync
How do I set combobox data source to a dynamic SQL statement?
Forms and viewing NEW records
Report Group Header vs. Detail difficulty
Waiting for a file
easyest question ever
Printing a wide form in 2 pages
Assigning Values to TextBox on Form
Moving focus from bound control to unbound control causes bound control changes to be cancelled
OldValue
Action=acOLEDelete on BoundObjectFrame cause error !
Print list of all joins and join types for a database
MS access field dependencies
Moving a tabbled control around on the form?
ADO Connection Open fails under source safe
Error 2450 Microsoft Access can't find the form referred to in a macro expression
Notification of Duplication
Add a new field into existing database
Read Act! data into Access??
Product of Row Entries
Multi-level Access SQL query:
Report generated but prompts for parameter when printing
Go To Specific Record Via Shortcut
Error drving me insane
Can't get ImportXML to work
number of records
Cascading combo - fields keeping value from previous entry
Count of records matching ranges in 2+ fields
Copying Values between subforms in tabpages
MS Access
How to Print the data entered on the RichTextBox control
Sending a report to pdf?
Want to calculate STDEV of last 20 value in the database Column
how can i get value from a web for my record ??
Subdatasheet property
set value question
Sql Statement Syntax
Record Sort
Database Structure/Relations help
Unbound Control (if not populated, enter "0")
Access 2002 vs Access 2003
Code to Start Replication
Client Wants Design Access To Database
How can I add a summary query to an existing report
Requery Error
Database structure printout
Dynamic hyperlink in form
Password protection
Adding Date Criteria
Access 2000 Inserting multiple rows based on a date range
multiple data in one field
Can you have access automatically run
concert dollars to letters "text"
Table Relationship problem
subreport wont show up
<SOAD> WAS "someothersubject"
ACCESS Query Calcs: Number
Can't see field in field list
Allow User to Add a Picture to a Table through a Form
display data and query side by side
Cannot change selection of radio button with Yes/No options - sometimes
Data Type Mismatch
Count of jobs per day
Applying filter from form in query
Manipulate current datasheet record in function invoked from macro
Bloomberg
how to prevent software from been pirated
Help formating a query field
Sending Mails from Access
Select a unique value based on several variants
How to Select a Page in a ControlTab
ReplaceLine
How to know if a Form exists in the database
MS-SQL Internet Hosting
User- and Workgroup Permission Problem
PEB ! STDEV of last 20 values
Picking up focused data from continuous form
.visible property not firing
use lookup field with non bound control
Export from Access truncates decimals to 2.
Auto Populating a form field after entering a number into a different field.
compare a date field on form
Conditional input mask on form
ControlTip Text Doesn't Work
Calculation Problems in Access 2003
Calculation Problems in Access 2003
Import to the backend of a split db
Logging Record Changes
Query format for Existing Time
historic financial data tables
password on linked tables
drop label if field is empty
Validation
Start Form Default Size then Expand With Command Button
Import Error Table
How to cycle thru ALL forms?
Stop a macro when an Append query will append zero records
Date format - this has to be simple...
Filtering Parts Orders
Switchboard button put button-text behind
Export to Excel and dictate the formula?
Access can't run when I'm logged off?
:DAT import to access
Access 2003 Developer Extensions
Problem with Quersy
number to text
change Subdatasheet to None in ADO
command button
Filtering Subforms
Text too long to be edited
criteria problem
query problem
ExtendedPrice calculation returns rounded off result
Is Name a reserved word?
Crosstab with cumulatives in the columns
disable access application maximizebox
Update Query
Help with data entry forms.
Validation Rule / Text
Standered deviation of last 20 values in the database column
Split 1Column into Multpile Columns
300K rows of data ...conversion
send and receive SMS
Using a view like the table datasheet on a form.
Subform A forcing record in Subform B
Select distinct e-mail adress from 2 columns
Problem With Right Join
Return rows
Appointment Form
Reports to web pages
Report..Urgent!!
How to rename a filename in a system folder with VBA code
Two Detail Sections in a Report?
Round up numbers to the thousand
Looking for recommendation on C# Book
Cannot assign a value to this object.
Need some help with subform
Using subform to go to record in subform
Rank records automatically