Microsoft Access Form Coding [Archive] - Page 9

Re: last thing
Using Automation to get Outlook email addresses
Open and close access file
Form
Copy Button help needed
Form not displaying value set by code...
Form closes anyway
Re: How to Disable And Enable a Form
Concencate Emails, Error type declaration does not match
Open a report in an external database
MetConv error in Access 2007
Report not sorting
The Microsoft Access 2003 Video Training
Locating and running a file
Database Open Event
Re: that didn't work
Re: Select a Customer from ListBox????
Master Detail
query return multiple rows to autofill multiple rows on continuousform
DCount not recognizing criteria
Microsoft Office Access doesn't support this ActiveX control
run time version
copy paste tbale without primary key
Unwanted Forms Code break
Run code if record does or does not exist for value entered in for
Compare OldValue and value
repeating date of previous record
Split the Database and VBA code issue
datetimepicker issue on subform
search a word through projects
ComboBox
3 generations tables on the form
Access and small characters
Line Width Change
Access 2003 form labels fuzzy fonts
Event Fires Twice
setting the focus to a nested subform
Count and display entries
Re: check for redundent entires onexit
Subforms and filtering
Zoombox-font-format
Re: TxtBox new Updates
Required fields
Refreshing sub form from main form
Combo boxes Once Again
Need help coding nested/dynamic combo boxes
conditional formatting stops responding after 6th record on form
run time error 2001 - You canceled the previous operation
TxtBox new Updates
TxtBox with Timestamp on each change
compile error invalid use of NEW keyword
Datetimepicker on the subform
Forcing a user to complete a field before saving the record
Bool format in listboxes ...
split form: duplicate entries after insert in datasheet part
user name and location
Go to the next meeting date
Using a continuous form to set up link rows
Rename File
IF RECORD EXISTS - records showing on subform (don't want to)
Switchboard/Form - Error - No Object for this Control
Error 2455 - Invalid Reference to Form/Report
RowSource & AutoExpand
Re: Open Selected Record in form
Re: Move from parent to Child Form.... Problem
disable controls until data is verified
Strange Runtime Error
DoCmd.GoToControl question
Finding the middle of a table
Re: One line of code for multiple labels
Re: One line of code for multiple labels
Detecting record locking in mult user environment
Linking a ListBox with a subform
Toggle Button for Visible Command
Counting the records
Re: Number/Name in Code
specific character keypress help needed
Date field will not populate correctly
Change text in a text box
Re: HyperLink field Unable to Open Up documents
Error message
Re: cannot update
SPAM
Erisson FREE Laptop
combo multi select list
Data Type mismatch error
VBA Syntax issue (I hope)
Re: Sale Id , Number Increment Problem
How to suppress the "no current record" error.
Update 25% to one field 75% to other
What's going on?
Re: Sale Id , Number Increment Problem
Re: Sale Id , Number Increment Problem
webbot bot="SaveDatabase" - problem posting asp page
Check for file in folder
* Take it like a man live screen shots
Running a MakeTable Query
If then statement in form using two separate fields
OpenForm vs. Form menu double click.
Error Message Run Time 2465
Update Combo Box when Not In List and update related info in form
Re: Rename Access labels in a form
If one thing and another thing
Using If & And
Using If & And
Drag a text box in a form
Highest value for a field
Main Control References SubForm Control
Converting select queries to SQL
Data passing thru the fields of the header
ODBC connection problem
ODBC connection problem
ODBC connection problem
ODBC connection problem
Filter by month and year only
Switchboard Settings giving error message on open
Using Code to change a field in all records in a subform
Not in List
Not In List
subdatabasename at frontend
forms, foreign keys and relational model
subdatasheetname property set at run time
set subdatasheetname at run time
subdatasheetname property at run time
subdatasheet
Inputbox ok only
Re: Changing Color of One Record in Datasheet Mode
Validation Error
List Boxes Do Not Requery (Access 2003)
NESTED IIF STATEMENT. PLEASE HELP.
ComboBox - Is it in list?
Problems withRT07 and msflxgrd
Zoom form from Double-Click
iff, then, else textbox help!!! revisited...
DateDiff issue
Function vs. Sub
Can't launch mde using button on form
Backup Database Macro?
Re: Changing Color of One Record in Datasheet Mode
Imperiale Watch, Best Wristwatch
No. 8 Watch, Best Wristwatch
Evidenza Watch, Best Wristwatch
Angular Momentum Watch, Best Wristwatch
Tourbograph Pour le Merite Watch, Best Wristwatch
Re: Need Help with SQL in Code
FileDialog Object ceased to function (User-Defined Type not Define
Order form
Order form template
Multiple copies of Report
Multiple copies of Report
printpreview window sizing
Multiple copies of Report
Multiple copies of Report
Multiple copies of Report
Multiple copies of Report
Form to add and update data
Referring to a control's associated label
Importing files from multiple drives
Saving form created on the fly
record lock property on the form
Calculate values of 2 controls based on the values of 3 other cont
Change text that select in a text box
Putting date into form as default value isn't working
Putting date into form as default value isn't working
Putting date into form as default value isn't working
Putting date into form as default value isn't working
Putting date into form as default value isn't working
Putting date into form as default value isn't working
Input Form
Eval function
Cascading Combo Box Problem
Combo box with same table source
Data type returned by function
not in list - add record to table not working
Will I have to redo the file path
Will I have to redo the file path
Where Clause Keeps Getting Added to SQL
Referencing all objects on a form
date time picker on the tab control
Select/Reference all objects
Select/Reference all objects
combo box with parent table
Too Few Parameters Error
Too Few Parameters - Urgent
Too Few Parameters - Help!
Too Few Parameters -- Help!
Too Few Parameters Error -- Need Help!
Before update condition
Before Update Condition
Change text in a text box
How to copy the slected text in a text box
Can't use SetFocus
label associate
Image Control in Sub-Routine Error
Allow additions and edits not working right
cut and paste to a tab control
Develope on Office 2003 and run on Office 2002
Unable to use functions within a Select Query
right to left menu
Developing on Off 2003 and running on Off 2002
What is SetFormControls ?
SQL PassThrough query - CSV error
Developing on 2003, running on 2002
SQL PassThrough query - CSV error
SQL PassThrough - Export CSV error
Filtering one listbox from another listbox
clone questions
Multiple Filter Critieria with Single Button Click
Cycle using Me.RecordsetClone
Global Form Events
Best Way to Debug Startup Code?
Transfer Data between two forms
Problem with Opening Subform
Problem opening subform
Having trouble opening forms
BeginTrans/CommitTrans in form with subforms
Cycle to first record?
Sorry for multiple post
Nested form filtering
Nested form filtering
Cycle back to first record?
Cycle back to first record?
Cycle back to first record
you can not go to the specified record
on dirty
Setting Up OpenArgs and OpenForm
Send Records from Form, Method or Data Error not Found"
modify data structure while users on the system
ahtCheckOpenArgs([Form])
User Level Security
Export to text
Export to text
Export to text
Re: right to left menus
Slightly off topic: Activity log and firewall
Copy data from one form to another
Copy data from one form to another
Hey guys, have you heard about this guy?
Resizing the form
Object requred Error
Re: Syntax Error
OnClose Problem
OnClose Problem
form multiple combo code problem
Understanding an Error number
allow edit = false
how do I add a do until loop to this code?
form size
Listbox .Selected=False won't work
ListBox .Selected=False won't work
nice shopping plaza
Populate Textbox from a combobox
Populate textbox from combobox selection
Check for existance of table by name
Wait fr Form to Close
Push a button, print an envelope?
attachement with email
attaching report to email
attaching report to email.
Not In List question
Prevent access to Form Design
referencing a page on tab control
Resetting default values on forms
How to tell Outlook that .Body is in HTML format.
change data color based on field in table
Cycle Through records
Re: Access search button
Re: Pop message last businessday of month
cbo AfterUpdate question
network error ?? newbie question on Access
Pop message last businessday of month
Access search button
Update Textbox when other textboxes are updated.
Click on Save Button - saving PDF report
Save record and refresh(all controls)
Re: Opening a report based on a value of a column of combo list.
Opening a report based on a value of a column of combo list.
Storing Dates and Time
Re: docmd.TransferSpreadsheet exporting numbers as text?
ActiveX control text box
Bound Form to Table - Cancel Operation
check file exists
sendobject - attachment
Same filter, same datatype but only some records filtered
ListBox
Help with prefilling a form
Alternate Address
Navigating from form to subform to subform
change toggle on entry in combobox
Re: Adding data from one form to another
Reference subform with SearchForRecord macro action
Re: Adding data from one form to another
Adding data from one form to another
How to locate a multi-criteria record?
needing query assistance
Enable user to change currency format
Capturing number from query
RE: Capturing number from query
Open a Calculator
Error writing values to table
Open object in another database
Getting total for Rows in a Report
Form_Load
Module Not Found
Why the minus 1?
Form pulling data from table1 to autofill fields in table2
RE: Form pulling data from table1 to autofill fields in table2
Graph not showing
Printing with formatted lines
Drop Down Search Box
changing recordsource continuous subform in vba
Can't get the correct quotes or syntax on strSQL multiple WHEREclause
Re: & 1 Samuel 25v42
Parameter Form DropDown Issue
Closing folder
iff, then, else textbox help!!!
Checking for duplicate entries
Re: & 1 Samuel 25v42
Format form for particular records
replace text in a string
Picture now shown immediately
Last update on..
Is it update query that will do this?
What formula should be used
Re: access and vsto
Resizing a text box
What is the VBA for Get open
access and vsto
Re: Keydown hierarchy
Re: Combo Box Error
Combo Box Error
Simple Query Question
Form updates table when it should not
Event triggering on subform while in main form
Multiple colors in one text box
Re: Uusi ominaisuus Gnomessa??
ADH MultiPik SetCollections method not working in A2002
using array to sum fields
menu control
Requiring alpha data entry
Run-time error '2004'
place image control on the form
Print all docs in a folder
relation problem between 2 table
To load or not to load
Launch PowerPoint File Using MS-Access Form Button
have macros replaced event procedures in MS access 2007
Combo box choice checks a box in another database table via dlooku
Sort Single/Double Digit Values
Deleting records based on another table
Assemble and insert hyperlink
Creating a function that returns a collection...
Corrupt Form - very complicated form - how to recreate.
How many records in a filtered report? (A2007)
Combo Box criteria
need directionon "cancelled previous operation" error
Code for an Adverse Selection
allow user only to go back, not to proceed
DateSerial function generates Run-time error 13: Type mismatch
to make it can not enter data
Access survey console
What is the VBA
Is it possible to create a 'Continuation Form' (not a continuous f
Re: Unbound combo in form header
Changing back color
Deleting spaces at the right
Can I capture SORT event in continuous form?
ADH MultiPik weirdness...
INSERT INTO PROBLEM-TOO FEW PARAMETERS error.EXPECTED 1
Deleting a table
Pass a value from a Form to a Report
Time bomb a DB
ToolBar concern
question about Shell Function
Select row in a datasheet subform
Sort datasheet subform by column with command button on main form
what causes an error that says: "Too few Parameters. Expected 1."
obtain sequence number automaticly when depend on value of other f
"Data type mismatch" error
combo box won't allow me to select anything
Date Add
Drop down box problem
Relationships - Multiple Back End Files
Reset combo box on unbound form
controlling invisible controls on form
select child records from list box to filter report
Counting Records in a combo box
Show picture on button on other computers
Re: Null = 0 Problem
Combo Box Question
Re: Help with multiple Select List box
Re: Help with multiple Select List box
Calling SQL stored procedure from form control cmdButton
Usage of a field from an unrelated table in a form
Zip a file from within VBA
Re: button wizard
Make a temporary table with a unique name
Re: Creating a Time Sheet Entry Form in Access
"Id" is not an index in this table
navigating to different records in a read only form
Set Focus to add new record on subform
Question regarding MkDir
Re: Multiselect Listbox
One form or the other depnding on certain criteria
Runtime Error
Combo Boxes with blank lists
check for control
Option group to filter a form
Requiring alpha data entry
CALCULATION
OPtion Group
Call a report in another .mdb-file from a .mde-file
To use Get Open
Re: MultiList select box and combo Box for report
Form/Subform Refresh
force new record to be at bottom of continuous subform?
reverse checkbox code
table relationship
Is this a Quotes problem?
Record Level Filtering
Reminders
coding a concatenation
limit to list - save to table not working
open form without seting focus(?)
Moving backwards from subform to subform to mainform
Line Numbers On Subform
Check Records exists
Returning the sum of a column in a table
Change mousepointer to hand
Copying a table to an array
Re: undo button
How to write function from this IIF statement
Adding a new record in Subform--Please Help!!!!!!
Re: Filter a subform
Inserting concatenated strings from a form into the appropriate ta
Re: Filter a subform
Linking forms-problem long and confusing
Alberts MultiSelect Form Question #2
Alberts MultiSelect Form Question #1
Check for Null on Continuous Subform
Project with multiple Part Numbers
Field to = Calender Control
Trouble with Recurring Records
Open other Access Applications
How to launch IE from a command button
Seeking T-Shooting Suggestions
Re: Canceling record navigation
Checkboxes in DAO sql statement...HELP
Limts
Date range Look up
Automatic input mask..
sql to pass value to variable to pass to text box
re-useable validation rule
DLookup, unbound controls questions
Need a ClickBank Account?
send user to a website
Form greyed out unless ...
Arithmatic on Dates
Brain cramp! setting value of multiselect list
Exporting an access query to a excel template
Selecting record from table using a list box
Opening a report from a form
How navigate from subform to main form using tab or enter
Linked tables & UNC
Update unbound TextBoxes on Form; Need to Read AND Write
main form has back-end table data source
operator as a variable (syntax ?)
operator as a variable (syntax ?)
recordset.count behaves strange
Update Data in Table with Form
MILEAGE PAY CALCULATION
Select Case Trouble
Multiple field result coding
Re: Use pop up to go to record on subform
Can't assign a value to object
Memo-field
DSum w/Between = Invalid use of Null
Re: Open form at its designed size?
Need fields to show info from different sources
Need form to display related record not just add new
Refresh Combo Box on Main Form / Subform
OnOpen Code Problem Still Exists After Workarounds
Requery subform with new SQL
SubForm does not accept focus when adding a new record ?
code goes too fast
need advise on merging
Listbox position code
Re: First and only occurrence
Maximize Form
SetFocus in Form Undo event
Canceling sendobject
Form Current Event
Multi-Query enter date based on checkbox
Not In List Problems
code execute while inactive
Multiple criteria taken from 2 seperate forms
Error checking
Non-English characters add '?'s to string variable
Left$ (?)
How to implement Multivalue field-style checkboxes
List Box
if 3*15
Print Options Using Dropdown Menu
operator as a variable
msgbox to show user
OpenQuery parameters
OnOpen Code Error
Form and display resolution
Limit Keys
Is "IN" an Operator?
DCount error
email-adres remains blue
GoToRecord on a subform...
PASSING VALUES IN CALCULATED FIELDS ON FORMS.. PLEASE HELP
cmd button to open small form when value is null
IF Statement
Open and filter report
compact sizes of Access 2003 and 2000
pushbuttons don't work any more
Lengthy SQL string producing error - Why?
Repost: Problem with Allen Browne Duplicating Code
RowNum using Numbers 2 Roman code
Split Forms Buggy
*REPOST* Re-Query Code was working, no longer is
Subform Null Values
Google maps from form
RecordSource Using a PassThrough Query
Copying a form
Error "no value given for one or more required parameters" HELP
Previous month returns blank text box
Close form without saving changes
Re: Email from list box
Importing data from Excel to Query
Open 2 forms on startup
if statment in case statement
RUN-TIME ERROR 2455
Code to cause a form update...
Uncheck box & clear combo box in new records
Access Subforms - Master/Child fields - one-to-many relationship
error in IIf
Sum or DSum to get a total?
Modify Search Button by using ComboBox
find record in main form then find record in the subform
Saving a form as an image (bmp / jpg)
Required Entry
Export Query to Excel command code HELP
inputmask
clicking on a field to send mail
Coded button not working properly
add / update record
Strip Characters
AutoFillNewRecord for multiselect field
Text box query
Reducing Code
Button to navigate/Filter records from month to month and year to
Easiest way to copy/add identical record.
Problem with Allen Browne Duplicating code
Subform not refreshing
>> Find value in 2nd Column of listbox
strange way to compare dates
Change textbox/combobox colors with a procedure
Check to see if a key is being held down
Create dir based on record ID
Carriage return
Button that shows the & symbol
Field data jumps
Forms buttons don't work in mde
Access 2K: Refresh Combo Box after adding new data from another fo
How to return values - best solution ?
Re: Exixsting project: no error handling!
add items from one combobox to another
Access 2003 Database corrupted
my table can not be seen anymore in Msysobject query
"Too Few Parameters. Expected 1."
Help w/form coding
CALCULATIONS
Refreshing a form
Do Cycle
set focus with command button
sum on group not working
Error calling a Field
how to refresh a subform
refresh only the subform
access to a variable in a subforms code module
CALCULATION
open form NOT maximized
Repeating selected fields into the next record
events not firing??
open form maximize
use of '&' symbol
more sendobject-problem info
RE: Correct syntax for a temporary table in Access 2007
Bound/Unbound? Refresh or not? Faster?....
mvps.org solution not working...
Excel not closing when opened from Access (again...)
Can't open module
combo box value
validation rule error
Select All Subform Records
Form/Sub-Form selector shading
Spurious "form" in db
trying to work with table data
RE: Correct syntax for a temporary table in Access 2007
DateSerial function
sendobject doesn't send
label visible depending upon value in another control
Checking if subform is dirty
Programmatically Doing "Save As Query"
Set Focus On Subform Control
Re: Efficiency Question
sendobject problem
RE: PDF opens then closes
macro where statement problem
sending report in pdf format
adding a new record at subform should update an existing record (not create new record)
Efficiency Question
textfield in a loop
Requery was working now is not
After Update Requery Code
Test if an array is filled
Changing fore and back colour of a combo box
Forcing an Event
Re: Using option groups
Using option groups
Problem With Fields Collection
LOOKUP IN MULTIPLE TABLES
Access VBA - ODBC Timeount on Sql command to update records Options
Sending Data from a Form to a Table
How to send an email via an Address in an Access2003 field?
Dlookup problem
listbox doesn't store value
RecordsetClone.Recordcount not counting correctly
Help with code
Help with code
Re: How to Round Up to 0.5/1 ?
Is it possible to...
Errors with Sub Form Totals
"Invalid use of Null" message from DSUM
Synchronized Comboboxes
Form, subform & Right click
Bound form & blank combo box
Focus after DblClick
How to create a macro to incorporate the following code
Form validation and deleting record if dirty
Re: duplicate entries
can not execute code in break mode
Problems saving record to a SQL Server via VBA
set default value for a textbox to the current user
Report not opening correctly
Running Sum Question
Open form by doubleclicking in subform-datasheet
Problems with a Sum controlsource, please help.
number from a string
Re: count code
Import to link table
Sending Access mail using smtp
Getting a nice layout
Do not want subform to update
Import Text file via browse box - import specs?
weeknumber should return a date
select listview checkboxes using VBA
DSum #Error
How to send email from Access without opening Outlook
Change Event
Refreshing form with all records
Re: Me![Arg] Vs. Me!Arg
Runtime error 2001
advise on how to....???
Do...Until Loop Code
Corrupt Front End
notice of filtering
adding vertical scrollbars to access form with tabs
Difficulty with search string
Add code to existing code
How do I get the hourglass to show?
Functionality error when converting Access 2007 to 2003
Multiple Subforms and Arrays
Opening Form To Add New Records + View Existing Records
RE: cancelling the docmd.close function clears text boxes
Re: cancelling the docmd.close function clears text boxes
Hidden Excel Workbook after automation
RE: Combo Box List Not Visible
Deleting a Form & SubForm Record
Incremental ID # increase default value
vba code question
Combo Box List Not Visible
Stopping automatic SAVE on close
Report set-up
Incorporating optional function argument
Cannot Expand Named Range
Problem with DoCmd.TransferSpreadsheet acImport
Add item to subform with dbl-clk event
stLinkCriteria syntax help
code conversion
RunSQL - MakeTable Query
Re: How to Set focus on Form! Header's Control ?
refresh an open form using records from another open form?
set default value in field of form in Access 2003
Edited Record on Form
Sub Form Text Color
Re: Auto Increment
How to "remember" password
Re: Pick List for Combo Box & Displaying Old data
Off topic Windows question
choosing between queries when opening form
How make subform independent of main form?
Re: Adding quantity x cost for entire report.
Re: Adding quantity x cost for entire report.
Re: Passing form varible to query
Re: Report Groupby variable
Re: Adding quantity x cost for entire report.
Find dialog and What's this question mark exposes Replace?
Counting records
Show control on continuous subform row based on a condition
Current control
Form Sorting and Adding Records
Re: Passing Problem
Syntax question about stLinkCriteria
Run Append Query from ControlButton on Form
Send an email to a contact with no attachment
I can't get this code to work
Set value in one field based on selection from lookup field
Ensure field holds a value before continuing
What sql server permissions etc for linked tables, sprocs
Opening form to a specific record
table relationship
RE: Displaying attached Printers in a List Box
How do variables work?
Maintaining cross-reference table
SUM failing on group footer
Validation Rule on form
Re: User Name and Passwords
Conditional Formatting based on Current Record [field] minus PreviousRecord [field]
Code won't update
set focus on single control
Get filename during Import Wizard.
Re: XP Vista & Office Cheap!
Math Does Not Add Up
In over my head!
Combo Controls
Import from Word
OKay, BUt........................
Locking an autodate
Popup a Memo field to add more data
Cont. Forms/Individual Record/working with properties
capturing a signature
Setting up an outbound campaign
Moving controls dynamically
Checking if form is a sub-form
Message appear while Access is thinking/working