Microsoft Access Form Coding [Archive] - Page 59

Opening Word document via code... having issues...
List Box Problems
Help with RunCommand / Pivot Tables
Newbie : Command Button to Find
Access 97 Output Mask
delete excel file from access macro
adding new records
Incrementing numbers
automatic date update
subform sync'ing
Dlookup fields
Determine wether code execution is finished
Changing Combo Box Text to be "like new"
Use Enter key for activating a command
Error occurs when pressing new record button
Compare records in Access and Excel
Re: Require a field if a condition is met
messages when I run a macro
Change Order By property and requery not working
ADODB connection creates error; using Microsoft.Jet.OLEDB.4.0 as data provider
form/subform deleting records
Re: If/Then and Control Type acLabel
Record Additions / Changes
dropdown based on previous entry not working
Form-Add New-"Can't Set Value to Null...."
How to share access database over intra-network?
Messages in Excel
detecting that a dirty form is no longer dirty
Calling form with criteria
Supressing page footer.....
.AllowEdits
View Records on Form
Need to use 2 fields in link criteria
How to combibe data from different databases?
query as source
Replacing Access error messages
Searching for a record
Subform to subform navigation
Can anyone tell me the problem with this code
Command button to go from one report to another
Form Validation
Send Object
Unable to see all the modules
Form Sizing
Change Order By property and requery not working
Locking a Field after Entry
Help! Need to display new records in a look-up field on a form.
Common Dialog
Copying a date from a text file
Calendar Form-Dlookup not working
TabControl Right-Click when Disabled
ComboBox showing specific datas
Notification
use network logon id to set default value for a field
maximizing form when loaded
a few questions
Re: Use tabs to divide data
ADO recordset and Filter problem
Warning message
Problem adding data to a non-AllowAdditions form
Entering userID without seeing list
Validation criteria of Form-Table
Re: Dollar Sign in Functions?
What kind of relationship is between these two tables.
Re: On Change of a control
List box - query
Grouping on a Form
Reference Row in Subform
Re: recordset problem
Clearing combo boxes
09 August 2004, Access 2000, Reports, How to know last line no. printed by Access Report
Error Message
How to view a report without print?
event programming when adding record with keyboard shortcut
pull records
On Change of a control
Microsoft Access build management
Re: Visual Basic Conflict causes Database to Fail
Pulling a single page report
Re: Access not closing
assigning items from a list of 1000 to a form field
import file box
GoToRecord Doesn't Work in SQL Linked Table
Command button to make form visible
Query With No Data Returns Blank Form
check to see of a form is open
Automated Paste Append Problem
Invalid Arg 3001 with SQL recordset
Re: 2nd Post - Listbox Problem
Requery Combobox
Reports
Code Update
Re: Dollar Sign in Functions?
Update a field on certain dates
Tab control question
AUTO FILL OF FIELDS
Newbie: How to search for a record using criteria from to two table fields
Deleting a record on a subform from the main form
real state - Brazil
Date Format on FORM
Access Quit Problem
Source Object of subform
Adding Lines and Numbers to a report
Pulling Data from a table that not related to the form
subform referencing
Re: Diff between refresh & requery
Jet database engine cannot find a record
GENERATING AUTOMATIC NUMBERS
How do i set up a medical database
Can I highlight some words in a lable or textbox.
a contiues form question
Passing values between forms
tab control question
Pass selection from combo box as argument for query
Coding of message to flag when two values are different.
Coding of message to flag when two values are different.
DateTime problem
getrows problem with a dao recordset
Resize window ...
Re: WEIRD ERROR AT REFRESHING DATA DISPLAYED IN AN ACCESS FORM
WEIRD ERROR AT REFRESHING DATA DISPLAYED IN AN ACCESS FORM
put controls on form through VBA
Can't disable keystroke shortcut
update statement runtime error
strings in text box control source
Findfirst Question
Updating controls when form has no data
Validating an attempted insert
Auto-Depress Buttons???
Delete a file on my hard drive
Combobox refuses to get "nothing" value, even though it's not required, allowed to get zero lengths and not limited to list.
Syntax to refer to subform in BuildCriteria statement - Access 2k
linking tables with ADO
landing cursor to BEGINNING of TextBox's input mask
Disabling all buttons on form
Reseting to "nothing" chained commands in which LimitedToList=True and AllowZeroLength=False
Running function which gets a form parameter type + Reseting existing field's parameter to null or ""
Forms
Links
Re: Need your advice
Need your advice
Combobox
Re: Detail Section of subform record events?
query
Changing font size
COMBO BOX RESTRICTION
find command button
CopyFromRecordset Excel Automation
Form Property - Form.Dirty Question - Access 2000 vs 2003
Re: Referring to main form control from subform
Re: Referring to main form control from subform
hanging process
Write Conflict
Checkbox.enabled
msWord Embedded in Access crash
cancel update on movement between form and subform
ComboBox
Flash the taskbar button
Dirty Access Question
Combo box selection writes to two places
Add a help button ("?") to the Menu Bar of a Form
requiring non null field values in a form or query
Re: Counting records in a recordset
Closing objects before exiting in Access 2000
Can I get an explanation for why a form is acting a certain way?
ALL CAPS
access 2003, keydown from filter by form mode
IIF Statements
Control Code Placement
Form for user/group management?
Login Forms?
Is there a better way to "Requery" this...?
Option groups value from a table field
Show a form in front while another form is loaded in the backgroun
Get name of current sub/function OR name of last label clicked
Time Stamp on a form
Multiple ComboBox
Automation to Excel
ComboBox
Checkboxes on Forms Connected to Queries
Update and record
Filtering
Combo box
Form frozen after loading/opening
2nd Post - Listbox Problem
Sequencial Numbering without using Autonumber
Datediff, if field is blank
All
Recieving the Year from the Date() function
New Mouse Over Error
check box on form - getting it to default to a business vs. home address?
Strange error message
Re: Add to LIST BOX
Re: RESTRICTING DROP DOWN LIST
Requery Subform
Combo box on Form will write to table
Getting 'Object Required' error when I used a collection
Calculation Location?
Where Clause
IIf Null, then hide
Showing cards on buttons
Reporting grouping dropping duplicate entry.
Hyperlink on Outlook form
Problem sending MAPI mail from Access to Outlook
Passing Data from one form to another
send report format
How to 'give' the status bar back to Access
Using the KeyDown event
Using the KeyDown event
Warning users about updating a text box
Changing default printer and printing to Acrobat (pdf)
Running a query using a command button
Options Group Coding Question
2nd Post - Recordset Help needed
Implementing a Save, Delete or Cancel MsgBox
THANK YOU
curdir Code Failing
stopping a procedure if the user cancels a delete operation
Import reports from another database
Re: Need help w/ CASE statement
RE: Updating fields on a form
Form with CheckBoxes
Error on a form
Variable not defined
RE: Fill Values by command button
Form BeforeUpdate Event Is Running Only Once (Access 97)
Re: [Visible] = No
Custom Menus under Access 2003
DateAdd question
Re: tbtray
DoCmd
Recordset help needed
Recordset help needed
How to control a report from a form?
Exporting to Text
change form record source SQL
Re: how to become the best flirter
Listbox Problem
Opening a link through access
Run Excel Macro from Access
How can I check if a form is open
using "LIKE" in a query
Returning Variables from Sub Functions
Download ..info. from another app
Message Box Size?
Trigger Not match
access 2003 and function key trapping
Subform disappears from main form if no records
Open picture in MS Photo Editor
Deleting a record programmatically
RE: SQL Update, with Blank fields
Compile error
Problems with Adding <all> as a parameter
Forms/Subform Samples
change defaults in FIND
Reading Registry Key Names into FormsTextBox in Access
For...Next statement woes
transfertext & schema.ini
counting fields
Opening word file via VB Code
generate access report using info from the web
Reducing size of forms recordset
Object reference from string
Envelope Button
Where Clause in on open form event
Pass parameter into a form that use stored procedure.
Where argument
Import Excel spreadsheet to Recordset
to show a fiscal year
The default for a list box set to a query string
VBA References
Controls on Forms
Listbox Horizontal Lines
Cond. Formatting
Forms design
file locked
get info from another application
get info from another application
Re: Tabledef.append - SLLLOOOW
Re: Tabledef.append - SLLLOOOW
Lock record
Lock record
Lock records
Lock records
Lock records
form in new instance
form create new instance as new
controls on forms
Open form as new instance
What's wrong with this code???
Enter notes for one person from another form
access 2002 Using form filter or not??
Forms: Adding a Search form to a database
Forms: Adding a Search form to a database
time sensitive update
message box with message based on tbl
Dim for Public Variables
Primary Key accross 2 fields
Oldvalue not working
Finding unreferenced vars
dcount question
Can't reference subform
Set focus to Combobox
Set focus to Combobox
Button Functionality
counting the list box
Msgbox Question
AutoNumber
Type Mismatch error
Update field value from subform calculation
Re: Rerun a query
non deletions of records
Updating ADO Recordset
default Date value
how to get rid of VB error messages??
how to cut from one and send to another
Changing a subform's recordsource
Can I open form "filtered" from Switchboard?
"Round" function not working properly...
Help with API calls to external program
Re: Public Variables
windows Explorer
RE: Synchronizing list boxes
Re: Message to pop up when required field is tabbed thru w/o data
Message to pop up when required field is tabbed thru w/o data
Expand Message Box
Access 2002 Merge with Word 2002 with Intranet use
Calendar Control
Re: Listbox not Showing Table Data
field update
VB code to ignore error
odbc with Oracle
compact & repair
Automating lookup and Fax
Use of public variables with a multi-user database
Run time error 3421
type mismatch error
Changing the Background color of a Command Button
Load an array, sort it, write it to a text file
Loop Problem
Synchronizing Combo Box Updates the entire row
Formatting dates
underline characters with INPUT MASKS for TextBoxes
Converting Text Entries to Upper Case
Parameter Question
Permissions within the appl
Audio Recording or Dictation software for Access?
Stop execution of code in VBA
Dlookup
Loan Originators Needed
number of the line that generated .
Expression
Coding for an event procedure - error?
Make it with DAO
Can you assign a control name to a variable of some type
own passwort function
Using Access to "call" an announcement form
How to change text box backcolour ...
Update Table - Newbie needs help
Filtering subform thru main form
Dim Name
using a DSum() function in a form footer
unbound text box, Criteria for Query
Combo boxes on datasheets
Sort Form by text box
SQL query length restirction
activating opened form
How to import a query data to a table
I have found a efficient way to flirt...
Listbox not Showing Table Data
Re: Disallow changes to existing data
Help Coding Delete Child/Parent Records
HELP Compile Error opening db
CheckBox
Creating and using add-ins
How to open a file using VBA
Error 3009
Using a variable in a select statement
Q. Error when trying to do Dir, as stated from Access Help File.
Graphic files in db
Access 2003 Date validation on a form
Passing name of a contol?
Form Field Validation - Access 2003.
adding recordsource on open of form
Hard to explain -- two types of ItemID's one table
show number of filtered files
IsNull Problem
Comparing Dates in Forms
Change linked Sourcedoc in unbound object frame
Using Keyboard combinations to insert data
Setting the default value using code, removes leading zero on text fields!!!!
Access 2003 Mistery
How can i access an access BE file though a modem ?
Populating tables from an Array
Re: validation rule violations
Re: Get data from each record in subform
RE: validation rule violations
NEXT TO Last (or Max or Min)
Allow users to set default date
Printing a different invoice layout based on check box
vb6 code calling access97 runtime switch invokes two versions acc
Q: Select text from message box?
Form Emailing
Copying a previous field's value and pasting it to a later field
Re: Multiple selections from a list box
Re: Apostrophe in Name generating error in code
Re: Deleting a Command Button
returning code line numbers
List Box
Continuous Form Questions
Re: msgbox and buttons
Altering startup settings on database
Format A Continuous Form
Form View & Datasheet View on the same form
Q for Steve Lebans: Query by picturebox?
Coding for Command Button to send info to table & create a new rec
VB code help
checking whether a form is opened
Office 2003 SP1 - Worth trying?
Adding new record via VB code?
Record scroll bar
Any Grandparents out there?
Date question
Re: Subform/Command
Preventing to change a field's value after updates
How to get Current Display Settings ?A question of MVPs
Inserting or deleting records with out system prompt
Re: Make copied record the current record
Applying update on click to all related records
Re: Coding for Command Button to send info to table & create a new rec
how to link query with subform in VB
Locking controls in the Detail section of a form
Restrictions for controls
Open in form view when database opened
Trapping Errors with Select Case
Reference BIG problem!!!
Adding time intervals - format problem
Auto Date Insertion
Calendar form
Updating a text box based on another text box
resetting controls on form
RE: Long confusing question - controlling forms with VB
Creating a login form (how to)
open a form maximized
New Record
Lebans Calendar
Re: Problem with OpenRecordSet
Create a running total
Relationships and Linked Tables
TransferText
Textbox to sum the values in the column of a listbox
control array in access?
input date of birth and display age
Applying 2NF
Losing character when exporting
multi-list box i access 2000
Code Window 'Auto List'
control array
Get value from textbox when it doesnt have the focus
Lookup a record as you type in a form field
Changing the Height of A list Box
Help, please
Re: Tracking Time Spent
Get User Name with NO windows security
refer to recordcount of subform
Open Form ...
Create a Cancel Button to Halt an operation
Email
syntax to refer to a control on a form's subform?
Cancel form close?
Button to Export List Box Contents to Excel
Help with correct Method/syntax
Read Only
Required Field
Re: Tracking Time Spent
Re: Command button on Main form that saves data in subform
Adjust Control Size Automatically
Auto re-number records based on a query
Re: =CurrentUser() has stopped working
Null
Error Handling?
Too few parameters. Expected 1
Julian date
Problem Synchronizing Table Data With Listbox
How to connect Access forms to SQL tables
How to convert Access to VB Dot Net
Re: Confirm Record Changes
Calendar Control 11.0
updating subform
updating subform
Re: Message Box - control line feed in text messages ?
docmd.sendobject problem
Prevent mouse scroll wheel from changing records
Date() & DateAdd return #Name? in ART2002
Write conflict
pass workgroup info
Changing record order through the environment
will this work
Filtering a combo box linked to a form
Preventing dup entries for any given date
requiring form controls to have non-empty values for new records
Docmd.SendObject raises error 2282
Office 2003 SP1 Released to public
Access - update form with different table
Re: #name? in textboxes but control source matches field names
Re: Get data from each record in subform
Re: Command button to browse computer for file
Why I keep getting the error message when I use 'transferDatabase'
Crash when requerying form
Separate Forms or All-In-One?
Indirect reference to Textbox control method
Re: Display form while code executing
Access 2K Crashes When typing Code
Subforms in AddMode
Combo Box missing data unless "Refresh" is done....
Progress Bar Control
to few parameters
Refreshing subforms code
Forms take forever to open
Stupid request
Display Data in MultiSelect Listbox
Outlook calendar and Access
Change Password
Questions
combo box to show and add record
Multi-Select Filter
Re: 103 FIs: this, "SPAM" business
Help with Coding
Disable Printing
URGENT: Cannot Open Any More Tables
Custom Autonumbers (of a sort)
which is better for inserting new records.
DLookup is hard
Trying to get AddNew method to work.
Modifying northwind to allow a variable price (or in a new databse)
msysobject.type
Controls disappear when form is empty
Opening current record in a report or new form
Close one form and open another
Email Report as Body
Move To Next Field
Change passowrd
Help w/ DLookup
Form on the Internet ?
Using combo-box to look up and add/edit ect...
Creating an order
Loop not running
Progressbar Position changes!
access 97 enumerate all non-hidden reports
How to open a mail program through code?
Coding/Array Help
ESC - unload form
how to restrict field updates
Help w/ Me Function? Or: concatenating a string for a ADO field reference?
tell if a form is open
Spellcheck causes duplicates
Calendar Form
setting widths on a form in datasheet view
Opening second Access DB's form with parameters
Package Wizard sets up Application Icon Wrong
Access Form to Report Filter Inconsistency Problem
Find data in table
HELP with coding
Sending Query Results to Outlook
Help w/ Me Function? Or: concatenating a string for a ADO field reference?
resizing
Scroll problems
How to Insert a clip art in a form
how to auto populate a field from another table using dlookup
MS Access VBA error message - help with coding
Add new record and move back and forth using Navigation bar in MS Access 2000
Help pls: Form.Subdatasheet Expanded - No expansion if no child records?
Which page of a tab control has focus?
Unbound fields won't print
same database in Access 2000 and '97
Re: Creating a disabled look to on a list box
Access 2000 and wav files
Export query from w/cmd button from form
Is there a PROPER round function to use in ACCESS?
Read only form
Re: Format Problem
Selecting records from a query
Raise error for the form's error event
Lost in Date Format ???
Help with defining variable
Populating a field with a number + 1
Having Trouble with Bound Form
.bottom of TextWidthHeight
Help with Access 2003.
Warning Message Following Hyperlink
cascade update/delete question
Which should I use?
Ugh! Can't figure this out...
VBA active windows -- why are there so many?
Not even a professional can help me.
Need Error Number to trap
Manipulating a comma delimited String
Whacky "Overflow" error drives DBase manager nuts
Display 1st 10 records, next 10 records using SQL?
Displaying the print file dialog from within code
Re: Creating a disabled look to on a list box
Re: Date field causing problems in FindFirst
Re: Lost in Date Format ???
ServerFilter on SubForm
Re: Subform Detail coding
EXPLICITt or IMPLIED establishment of referential integrity
Disabling PROJECT save (not Form) at exit
How to remove or hide the data control?
Multi Column Combobox - Select Case
Open a form in either continuous or single record view
Print the location of the batadase on the report
Multiple Email Address
Strip all non alpha characters from a string
combos in subform
Error Codes, list of
OpenForm action canceled for unknown reason
Form layout:
Combo Box error message
Lost Record after data entry
trouble running query with string as criteria
vmakam@mobyz.com
Mouse scrolling
Bring a subtotal from subform to main form
Compact and Repair Back End DB?
Override natural error message
Re: Filtering Data
Help with Coding Value on Form
Dim as database Compile error
Changing a value between a form and table
Multi-select list-please help
drop down control displaying records in form
Check box
Text box instead of combobox
Delete From???
Command Button
Re: Running SQL Command From Form
switchboard
switchboard
Command line arguments
DBase Update Confirmation Window.
Set Combo Box Column Width for global app
Code to increment/update a field
Report Group Format Event Firing twice?
Shortcut files
Combo Box in Dropdown State?
Send email from acceess with outllok templates
saving data on closing form
Message box
bolding text
Help! Bug in combo box query
Action from particular key press
Filtering on main form and subform
Requery when entering new record line
Option group & combo box relationship
Re: AFTER UPDATE (IF FUNCTION)
form's picture
Re: Filtering data
if -then by form page
pop up warning balloon
Changing Input Masks
Making a chart from Form Data
Re: AFTER UPDATE (IF FUNCTION)
Re: AFTER UPDATE (IF FUNCTION)
Validate data in a listbox
Humble apology about Novell5x
Timing problem between Word and Access
Using Recordset
Locking a Record which is currently in use
Alias Triplicates
if then else
Address problem
Unexpected outcome with SetFocus method
autonumber
Form error event vs. Sub error event
Re: How access length of text column?
Re: Passing Variable from Parent to Sub Form Or...
store values in a table
multi-select list
Positioning cursor at end of default value
query to pull prices for different dates from a table
Tab order
Dir Function
coding for timesheet
Print Screen
Set Focus to empty???
Not on list event as module
Alias
Re: how check if a query exists
Startup Form
validation rule violation error
BeforeUpdate Prompt to Save Data
Coding for Random Numbers on a form
Records not getting appended
Record Synchronization Opening second form
Re: Scroll Box??
The reference to the control in the form does not work!!
Capturing Novell5x login name
A form for a query relating 2 tables
AC2002: Error 429 on XP SP1 - never happened on other installs !
creating a form from code
Form Before update interferes with other procedures
Re: Creating MDE file all forms were deleted
Environ()
QueryFormFields
Query too many fields
This action was cancelled by an associated object
Code to change Access Defaults
Export access reports data into excel sheets
Attaching a file using CDOSYS
Add new record(fk) to a related record(pk) from cmd button event
Version Control
updated hlp with multi-select query
multi-select list in access
SQL Queries with ODBC
Unable to type in text box on form...
display images from left to right in continuous form?
Print form current record only with subform
slow refresh
subtracting time
Auto update combo
Tab Control in Access 2003
Requery Subform on a Tab Control
Printing Excel and word from Access
Help with a string
SQLUPdate using DATES
synchronizing main/sub forms
Print to PDF using VBA
Unbound form
Update a form
Query Form
Network UserName within Coding
Invisible Forms
lock a control on a form
Re: lstBox default value
lstBox default value
Drive Inventory
Displaying an instance of a form
Erratic Behavoir of List Box
Problems with quotes in string
Combo box data type problem
Search a word in a field of a form
Forms
query in subform
HyperlinkAddress limitations?
Ms Access didn't display the date format
Form slow on first load
ImageListCtrl in XP
Table exists?
Open form showing selected field's info
combo box size