Microsoft Access Form Coding [Archive] - Page 69

Preventing empty reports from printing
Combining 2 txt files into 1 via VBA
'generic' subform that can display any query?
re: multiple page form question, Sandra Daigle pls
Error 28 - Out of Stack Space
Access 2002 PivotTable Wizard
Compact and repair
Query Question
CDONTS and SMTP server
Pictures in a Form
counting
error 3022 (double values in index)
Error message: Invalid use of Null
Put the result of a query in a variable
Use same code in form and report
DBEngine.Idle
Help Please with EditMode Property
Re: display rtf formatted text on a form
Opening reports from command buttons
Search for value
storing Multiselect Listbox selections - Access 2000
Open file
Chart's series format
Write conflict
Coverting String to Date in Form Code
Access 97 Rich text box problem
Subform as continuous form
Trying to Setup an Automatic Number Generation
Histogram
System Time
timetable
2 questions
using Application.quit causes fatal crash an error message in load event
manipulate datasheet (of a form)
Calling a Sub syntax question
sending an email from Access 2002 qury
Combo Box question
John W. Vinson[MVP] - Combo box problem continued
Continuous Forms
Suppressing Excel Confirmation Message
Problem updatin record
VBA HELP NEEDED
Re post again -- Is it possible to auto close a form after 10 minutes...
A repost from .forms - Is there a way to alter a subform's Data Entry property
HDI? Suppress Save dialog when closing a created form
Combo Box!!!
Combo Box!!!
Recordset using string variable unsuccessful
Use a variable to SetFocus to a control
A field is not updated.
MSysObjects question
Method not found error
QUERY: Ascending & Descending Percent formats
Fields not responding
Two subforms + update query
Read data form USB and Com port
BeforeUpdate event
Autofilling information in subform - Tab form issue?
Selecting records to print
Switch between PivotTable/Datasheet view in subform
Use cbo without a mouse
Date/Time Stamp
SQL - Update
Enablesand odd behavior
EVENT PROCEDURE TROUBLE
capturing input from a prompt
Creating a Context Menu in Access
Copy and Paste
A pair of update probems
ODBC Call Failed
Double Click
How can I show elapsed time?
Cancel Mouse Selection
CDONTS email error
Fields not recognized
Duplicate Values and Form_Error
Email from form
Combo Box problem
UnDim Control box if other control =YES
Menu Bar
Event Property: type not defined
telephone format
Starting Acess adp by different users
runApp adding directory path
Object Array
Help with data entry using a combo box
Re: Validation Rule Violation
Using the New Folder feature of the new BrowseForFolder API
Tab Control - Placement of nestled tabs?
Inserting character at Line 30 of multiline textbox
Repost : limiting lines per textbox and spill it over to 2nd textbox
comboxes
Searching Word Documents
ADO access to MDB file on network drive
Extracting Email Addresses From A Large Text File
Append ADO recordset to JET table
GotoControl
access value in bound column of list box
Can't Edit Records Using a Form
Assign a function key to open a form
limiting lines per textbox and spill it over to 2nd textbox
limiting lines per textbox and spill it over to 2nd textbox
Problem with DLookUp function
Updating a field in one table with data from another table
Procedure_Event Name Property?
OUT OF MS-DOS HANDLES
Number does not display correctly
Open a form to a blank record
dlookup Criteria
Can't assign a value?
back end mdb
Form with subform and tab form
Updating A Query
Date Problems
Copy and paste
A "Add Person" command doesn't.
Ordering an array
Changing Color after Update
Validation Complications Using Form On Error
Populate Listbox With FileNames
How to change the record source at runtime?
COmbo Box's third value
Combo Box
Determine if a form is open
Repost:: Locking Records
Selecting row from subform
Adding Title to Switchboard Form
Form/subform linked field update
#Error
REPOST: Saving Deleted Entries
Verify that fields are filled when adding a reord
CrossTab Query
Lookup question
Combo Box Problem
Drag and Drop
Update a memo subform
Access Form Problem with data changing to Chinese
Is there a faster/better way than .Filter?
FTP
Add a column to a table using ADO
Opening an Excel Document from Access Form
=> Check Box source int column shows tick for all >0
Recordset and Substitution
ADO reference path missing
Moving from mdb to adp
How to open Access Subform in Visual Basic?
Control Source error
Help!!! Newby at the keyboard
Limiting continous forms
Add a column to a table using code
A2K: Editing MDA code when working in the calling MDB
Form/Subform find record
DB Need query to be updatable
how to show available resources
Highlight Locked Fields in datasheet
Determining Field Value for Selected Record
Change time
Finding a Record with a Multiple Combo Boxes
Saving Deleted Entries
dialog form data
Loop problem
Compacting DBs
Custom ADO recordsets and listboxes...
RESetting Input Parameters on Access Report
"Object invalid or no longer set"
I need a code
query ac
Autonumber question
DB "object required"
Items not in collection error
Find Button on a Form
What Causes Disk or Network Error ????
Cancel New Record with a button
How to get information in a form using a combo-box?
sum
Re: display text box in continous forms
Phone Number Question
Arranging debugging window
"Object invalid or no longer set" error
creating entry in 2 tables
TransferText Woes
Posting from Access form to a website database
RunApp not running C+ .exe program
HELP!!!!!!!!!
Compact and repair
Display font size for DataSheet view
enumerate a collection of text boxes
Problem!!!!
Changing the width of a label - read only error
Dates regional settings
image movement based on reord
Hiding Table Values Cont
limiting lines per textbox and spill it over to 2nd textbox
ACG PDF and Mail Class Library
How do you do? (an old dog learning new tricks)
Drag and drop in access 2000 forms
Date field with no entry - copy forward
Silent Mode for DoCmd.RunSQL "INSERT INTO ... ;"
Writing to the same location
run a command for each record from a selectionquery
DLookup confusion
string fuction
Date & Time Picker Control 6.0 (SP4)
OnRecordExit wha' happened?
Delete Button
Using FileDialog Thumbnail problem
Event for MS Scroll Bar
Formating Time in min:sec.hundreds of second
Sorting records in a subform
How to assign function to CommandBarButton ?
Out of memory 64k
Hide/unhide image on forms
New record doesnt show
Combing the attributes of ControlTipText with StatusBarText in Access 2k
Form Record Navigation
Sub Forms
Using combobox to update a field (again)
I cant create new record via drop box
Set Command Bar Button = Toggle Button
Code for closing Form
Conditional Formats on Continuous Form
List box
access to Outlook
Do Loop or DoWhile question
Displaying Credit amounts as red
Are there books on controlling Excel ?
validating user input
table entry based on record
bounded multiple select listboxes
como box update
DoCmd.FindRecord
Object Required - error 424
Form/SubForm Lookup
Help On running code on db startup
Report group header formatting
Delete button
show in processing
Refer to Subform Controls
'recording' invoices
Sub Query problem
Find Records
closing a form with cancel button
Intermittent Access and Word printing issue
Input Parameters
Calendar Control Range
Delete Record by Field Info
Combo Box
Report group header formatting
Passing Data Between Forms
loop through textbox in form
prevent beforeupdate of form when moving to subform
AutoFill Controls
Error Message
Membership Expired
Handling ODBC errors on bound form
acgsoft help in access
Calculate lines in memo field
Advice on book to buy
ADO Recordset Navigation ??
converting an old database into access
Auto Increment
XP User ID
Alternate color for each Record in a Form
comdlg32.ocx
After update DLookup help required
run a search
Runtime version.
Is it possible to auto close a form after 10 minutes...
protect a file
Command button on Subform
Calling a sub or function
delete record message
DateDiff Problem
Expiry Date
Missing Online Documentaion for Event Handling Procedures
Prevent User From Selecting Another Tab Page
Prevent Access from updating a blank record
Allowing date-time field to handle more than 24 hours
Set Focus Method
Re: Fire an event at END ???
exporting to excel
Too few parameters error.
Random Testing...
DB Add Record doesn't work
Looking for Access Report Writer
closing forms
Editting Switchboard with Password
Placing a subform on a continuous form, Hopeless?
I cannot update a table from a form
Return to current Record
Combo List to open different subforms
create textbox programmatically
DB No value given for one or more required parameters.
I've lost my focus for forms
error message - invalid use of null
ApplyFilter II?
Can Shrink Yes/No Fields
Filter for Cmd Button
Copying Outlook Attachments to an Access table
Drop Down Lists
Enter data on update
Fill from Group by Qry
Dlookup Problem
Dates
Finding users who are logged on
Simulating an OnClick Event
CurrentDB.OpenRecordset and memory
=> Drop Down list box to determine data in subform
Data Provider Problem
Data from subform
How to write DLookup when criteria is based on joined fields
Insert into table pronlem
passing variable into word from access form
Need help on an SQL Statement
How to make a form unmoveable ???
quick money
strange problem
Need Help with values from tables as parameters
ApplyFilter?
update after adding a record
sendkeys
animals
Combo Box works in 2002 but not 2003
Global Variable?
error 3709 in access 2000
VB Code Issue
Using contents of a field as a field name
Moving from subform to subform
How extract date part of date/time ?
Email completed form
DB Adding a new record when form is based on a query
Re: Updating Tables
problem with subform synchronising
Re: On Got Focus
Re: Updating Tables
Re: On Got Focus
Refresh or Requery
controlling a subform
Type mismatch error
If Last Record
Flickering form
Errors w/calandar control on XP upgrade
Fix code to duplicate a related record (except PK)
MAPI read receipt
Need to export select statement.......
continuing columns
clipboard warning message
Populating Form with Multiple Records From Query
Hiding the Database Window
Scroll Bar Record Indicator
Search
Retrieving values of checkboxes
Code Causes Task Manager to Max Out
Add hyperlink
DLookup and If/Then
change record from command button
Cmd Buttons
No value in openargs
mail to: hyperlink query
Re: How do you program tab controls from visible to not visible?
How do you program tab controls from visible to not visible?
Using form to select information
OPen form, but do not open subforms
combo box
controls in report
open a form at today's date or next date if no match for today
Run-time error 458
How do I test for a null value in a text box?
Using combobox to update a field
List of queries
SELECT question
Passthru query as control source
Multi-column combo box
Run-time error 458
Open Forms In A Particular Location
Help messages on the Switchboard
Another Subform Question
spacing
Formatting a Txtbox to Display Time
Refer to a Subform on a TabControl
Please help with Update query
Selection In A Textbox
Event won't fire
Form Problems With XP- PLEASE HELP!
Passing a ComboBox as a parameter in Access 2003
Unable to solve error in Listbox
Last record(s)
Looking for a "String To Date" function...
CURRENTDB SIZE
Unable to join linked tables
How do I make use of calendar in Access
Detail Section
Select Case Statement (A97 in NT)
Disappearing/Blank Combo Box Contents
looking for example
Multiple column combo-box
using check box to select day off
Sending Outlook Message?
Embedding sound in a form
combo box
Disable combo box
Add a record to a related table via code
Re: Need VB Script Info
Data Entry using SubForms
Send past due
DB can't input data in form, eliminate blank record in subform
How to retrieve/display ODBC errors
Linking forms
Deleting records
combo-box unbound column
Dynamic QBF - concatenating - HELP!
Continuious Form Problem
Table size
Uneditable query problem in unbound subform
OnOpen Form - Security
Switchboard Form - Exit application
Updating Outlook?
Pass multiple variables from one form to another
Getting the lastest data from a table
Hiding Table Values
Changing Hour/Min/AM-PM
Wordwrap a textbox contents
comparing fields from 2 tables and then counting the results
ListBox multiselect problem.
Insert Navigation Buttons
Select a number of records
Copy From Field To Field
access 2003 problem w/ combo box query after return from modal form
Requery combo box in subform OnCurrent causes corruption
Call to other programs
reset checkboxes to default for all datasets
>> Delay loading form
Print Preview
Field Size and Input Mask
Tab Controls - Restricting Movement
Email Recordset
Default Print Settings
Capturing the value of a parent form in code
Filter Form first record displayed
default value
Disabling Subform Controls
Dir function
Duplicate a record in a related table
VB & Dlookup
Tab pages
handling date ranges in Dynamic QBF
REPOST - How to Lookup Current Record Field Value (that is not displayed)
Filtering: What Am I Doing Wrong?
calculate date
John C.
Combo Box Requery
Specifying an Outlook account from Access Code
How do I store multiple list box values in a table?
send data to MS Word
Fax Report
Problem pulling info from a table for use in vb code
Corvert date to Day value
Locking Rows
shade
Resising form
Image control bmp display problem
"auto-complete"
Programmatically Switching Subform Views
prevent multiple records deletion in a form
subforms
Problem with DateAdd()
Time
fore color-continuous form
Restoring Database Window
Getting Record Count in VB
Menu Bar
Force Access to flush data.
How to refer to bound form's ADO Recordset ?
Counting records in filtered form from junction table
Using Variables in SQL SELECT....INTO
DoCmd.Execute to insert a record
Record Validation
Record validation
Using MultiSelect with a Listbox as criteria for a report
Jump to Specific Record
Custom Collection
WHERE Clause on Date's in OpenRecordset
Position in Continuous Forms
SQL WHERE Date in RST = Date Entered
Hiding record - continious form
Forms programming
Using a variable in Where Clause in Query
Access Troubleshooting
Open an ".exe" program with code
Coding for F9 Refresh of list box?
Cannot setFocus
Displaying records in Subform
Can't get the label to flash
Changing Control Source, rowsource, et al
Rollover images
NotInList error for new entries
Dynamic Control Type Morphing
help with Code
How To Build A List Of Products From Multiple Categories
Access list of field in a table
Date Selection
Calling a Second Form and Returning to Original
Refering to a group of fields!
Count Weeks
Tables and List Boxes
Re: Need VB Script Info
Finding record on main form
checkbox to update text boxes
Re: Need VB Script Info
programmatically add record
Make easy moeny
Pasting Trend Graphs
Show Text box
Display all products but enter qtys for some
Loop Problem
Filter on Open
form to table
Refresh active window
Main Form and Sub Form
Combobox bug?
Subform Using a Stored Procedure RecordSource with Optional Parameters
Using the 'SetValue' Action
Stay on Same Cell after Requery
'user-defined type not defined'
Space problem
Update table from combo box
Changing underlying table/query in a form
VB comparison problem
Subform Mayhem
Problem with IIf statement
Check box to prevent updates
Problem setting RecordSource from SQL statement
Report Question
Calculated DSUM Field
Problem with 'Next' navigation button
Clear all default values by cycling through tagged controls
3061 Error
print data on a sheet subform
How do I remove all the obsolete code?
Problem Entering category data
Programming Access to give next date Automaticaly
Reference & Codes
Event timing and 2585 errors
How do I Move data from a Form to a Table?
Cancelling Unloan event
Cancelling Unloan event
Finding and updating a record
Bypass shift key
Dynamically creating a combo box
Linking back and front end - Is there a way to specify the backend path with code?
CommandBar function call w/o parens runs function 2-3 times
2004
Multiple rows' selection on datasheet
form-subform transfer
SQL statement
DoCmd.OpenForm
Another Auto Number question
Functions and Subs
Search Window in Form while importing
Autonumber Question
Changing Unbound Field on a Report
Real-TIme Updating of Tables and Active Window Forms
Any wizards for fonts in memo boxes?
SetValue from Form utilizing Subdatasheet Form
A how to question
ADO recordset errors when trying to set to form recordset
Automatic Number Rounding
List Box
Accessing the Calendar in MS Outlook 2002
Locking down database
forms question
DB Query has Type mismatch in expression
Setting field values from expressions
How to get option button value from a worksheet
If "Open Form"
RunCommand Action Cancelled
Honey, I shrunk the screen!!
Check for Open Form
Data type mismatch
Allocate Payment
Resetting a Counter/unique #
Loop Causes Dead Machine
Use table in VB subroutine that is not part of form
Me! vs Me.
Dsum sing single date criterior
Wrong column displayed in combo
MS access Jet error 2044
NotInList
test for value
Replace Function
Custom WeekNumber
Query Problem
Newbie Forms Programmer Question(s)
Form Query
Record #'s won't change on forms
Help on delaying a look
Combo Box Controls Sub Form
Opening subform to a new record
Dec. 22 Post Cont.
Highlighting Columns
Error 3211
Use Command button to rename on fly
Subform based on crosstab query
Deleting an Existing Query using VBA (Access 2000)
create new text box
Dirty property on subform
Performing field calculations on a form in Access 2000...
Linked Word Templates Open As File/New
Problem with a code posted in an article in the microsft knowledge base
help file
AllowEdits, etc., properties not functioning
Populating a list box with the contents of a directory
Form Auto Filling
=> dbo. prefix renders SQL stored proceedures unknown
Shortcut Menus
creating automatic email address...
Continuous form problem
Need help with forms and applyfilter command
Reading This Could Change Your LIFE!!!
Question On SQL Syntax
Ensuring Primary Key integrity
tables
Pass inverted comma as a string
Next and Previous Buttons
form not maximizing
How? Form/subform with a listbox to choose child data to display.
Recordset is not updatable
Modal
combobox values
expression that has no value error
If Chk False then Enabled=False
How to Refer to Current User in VBA (Access 2000)
Numbering on a form
Filter for form Access 2000
Submit Button Functions Auto Submit
Automatic alignment, ADO binding
Calculating totals with a form
My form doesn't requery.....help!
=> Query in SQL Server not recognised by Access Project
Timer Programme
Using a Calculator
Re: Date Problem
=> Permissions for Stored Proceedures
How to display status
Re: OnKeyPress Docmd.findrocord A2002
How to do this???
Connect to Outlook Contacts, save as VCards
attach form to window bottom
change properties entrycells on subform
Order items in a listbox
Jet doesn't recognize my subform
Writing data to a single field in a single record
Calling function from a form control doesnt work
Reading This Could Change Your LIFE!!!
finding a control in a sub form
Problems with Runtime
using me! or me. ?
Letterhead and Paper Drawers
Pull down menu sort
Control Label
That SetFocus thing
*Can't Bookmark a form from a vba subroutine!*
Can't Bookmark a form from a vba subroutine!
Line Return
Creating Query from Presently Active Record
Creating Query from Presently Active Record
After close 2. modal form, access is locked
Hi, I need help with my configuration about Outlook
Hello
Next & Previous
Next & Previous
Tab control
"NZ" function doesn't work with "Me" (HELP)
SetFocus
Pivot table and event
Problem with Runtime (XP)
Line Returns
Limiting Report Records
Adding recurring dates to printable calendar
Centering a shelled app onscreen
Finding blank lines in a multi-line text box
Return node's full parentage in tree data structure
tapping into shell output string
ListBox, wrapping the text
Limiting Report Records
Invalid Procedure or Call Argument
updating a field when the record is modified
Simple Form Command Question
listbox problem
I need help on multi select
Creating/deleting a table in another MDB
lagging problem in Db
Deleting a table in another MDB
I want to Duplicate
Adding Totals based on opt.
Open a modal form with new
help on DLookUp
frm.FilterByOn=True closes application
help with linking tables
Access form & table setup
Pause Code Timer
Counting records in subform
MSAccess.exe Program Error / Using CreateForm Function
Error Handling
Where do I put DLookup?
Detecting Null Values
Filtering within forms
Re: Deleting Files through Code
Run-time error when opening a form
Find a record from a drop down box
editing a code
Calling forth a form using 2 identifiers!!!
Automatically Populate a field
SQL2K Errors
Find Date Problem
Retrieving network in user names
OnKeyPress Docmd.findrocord A2002
automatic drop down lists
Continious Forms in subform
beginner's question
Freeze Column?
Can Time be converted to use in a calculation?
security problem accessing Outlook from MsAccess
Various Control Sources
Word File in MS Access
Report Query keeps asking for a field
Open File Window
Chart on a form
unprotect 1 datafield in protected form
Open Second Form By Date
Calling record from a subform
List Box
List box or subform??
calculating max/min date differences
Export file list?
linking combo boxes
Combo box quesion
subform data entry
Pop ups
Referring to subforms
=> Subforms
No object in control
Year Hard-coded into record - Acc2000
Stop Subform query
Set visibility of a field on a form based on value of checkbox
access can't add, rename or delete controls you requested
DTPicker
=> Form fields to Save to two Tables
default in code
Attach file to sendObject