Microsoft Access Form Coding [Archive] - Page 6

Report using subform Order By and Filter values
Re: Access to Excel
Adding records - automatic numbering with two primary keys
Prevent Duplicates
Re: can't see backspace as chr string ?
Custom MessageBox
Re: Save Record To Update Subform
Need help on this error --export to excel error message--
Printer friendly report based on a filtered form
Continuous form length
Excel to Access
open PDF file from query.
Database window
Problem counting items in List Box
Populate fields in an Access form
Combo box to limit selection based on current record in form
Build SQL statement
List Box Question
Seeing if there's changes in the db your form needs to know about -my solution
Access Problem: Combobox.setfocus fires combobox.OnClick event
Problems looping through many date fields.
Viewing TIFF files in an image control in Access 2003
Error 2185 for Text property in Header when form's recordset is em
Digital Signature Crap
Linked Table Locator
RE: Need help with syntax of If Then statement
Using MsgBox or InputBox
treeview double click event
Use a checkbox to control visibility of records?
Error 3201 Help!!
Command 'Copy' not available now
close form on empty record source
how to set a code for cmdbuttons
Conditional Display
RE: DLookup Date
collection
After update, two recordsets
create property and event
subform record source tabbed page
Filtered Combo box and displaying items not in list.
Is Access 2003 overiding Regional date Settings?
AutoFormat via VBA?
Re: If boxes don't equal number then msgbox
Re: Inserting Date syntax
Compile causes file size bloat
IIf Staement in control source of form
Re: Inserting Date syntax
Access 2007 Issue
Set Hyperlink Default
If boxes don't equal number then msgbox
Create a "modular" subform
Tooltips
After duplicating record problem
search criteria filter
Create a search path
How do I learn vba?
default is chosen or highlighted in the list box
Trouble with Multi List Box
RE: Checked and Uncheck checkboxes with code
Re: Checked and Uncheck checkboxes with code
Re: How to change the value from a control property ?
How stop subform adding blank values?
Stuck in loop when checking for Me.NewRecord = True/False
Detect Novell netware
Docmd.PrintOut - can I force landscape format?
Opening the MDB
Compile Error: Variable not defined
Print current record on form
set default value for unbound cbo from different table than source
Recordset/recordsource clarification
Open a report based on form fields
Help with code.
Me.Value
SQL Quotes
Upload Source File from User desktop to Server
Programmatically control Report Grouping & Sorting via Form
Hiding controls based on number of questions
Rollback changes in subform when subform lost focus
Need a code automatically generated based on data from a form
How do you render a record in a continuous Data Entry Form?
How to link pictures into the database
ComboBox Value List
Error in SQL
Conditional formatting date color for weekends
Formula/programming in excel for cinema movie scheduling
Using a variable for a listbox name
Quick code question
Re: Hide tab issues with focus......
Re: Need a combobox to filter sub form
new ReportToPDF
Access 2007 - Word 2007 - Mail Merge
ReportToPDF
ReportToPDF
Multiple Warnings
Elapsed time using date and time fields
Message box on open
Quick and probably quite simple Invalid Use of Null Aftermath Ques
Multi-Select List Box
Hyperlink Image
Variable button caption format?
Subform
Detect record in sub form
Place curser at end of line?
Maximize Window Space
RE: combo box display current record value
Citrix Log-on
Create new record in diff table
Removing the Help Combo Box
Error with automation - Access 2007 creating Outlook calendar appo
DLookup Missing RecordSource Question
Command Button
Format a multiple column combo box
Commit to table when get Error
data type mismatch
Data lost in one field - #deleted
Problem refreshing child form
Default Value Time() question
combo box selection runs query to sum values in table not gettingparameter from combo box
can't change data in form even thought the query is updateable
Event Procedure in Module
label or text box go to web link
Selecting current record in subform after removing filter
Create Temporarry form without saving
TextBox Object Control Source Expresion, trouble with
Master/Child Field
how to get record status in the Form (MS Access)
Re: Record navigation buttons on mainform and subform
Command Button to open form
Clear Text Box Tied to Combo Box?
Print multiple reports from Command Button with Filter
control properties
Filter code not working
Unwanted Form_Undo 'side effect' and form and control undo events
Re: Setting up a query for a subform
How to activate code within a new record
requeary form after vba code
Combo and subform
Call function in a different .mdb file on same folder
Minimizing the Navigation Pane
Update UserID and Default Date - Continuous Form
Concatenate function
hyperlink using part of file name
After Update and After Insert Events
Refering to Form controls in a general module
Subform check box not allowing to be checked
object variable or with block variable not set
RE: count and display YES results from subform to parent form
Scroll records in main form - ignore linked subform records
Reference help
Decimal placement
Update Open Form
before Update event
Label.caption = "" help
Setting the sub form to display blank when driven by a lookup combobox
Looping - Text Box in Header - Update Text Box in Detail
VBA code for setting the color of records in subform
Looping through a recordset
Combo Box to Subform
Text box visible on a continuous form
Bit of help needed on Validation Function ElseIf
change record source
type mismatch error in word automation
module code
Re: Setting default value in combo box
OLE object is empty.
Tab Visibility
main form - with subform
ODBC : Invalid argument
find cursor position on screen
Scroll lock on form
sum amount in my subform to text box in main form
WTF Happened?
Total or summing in the form with the subform
Combo Box-Text Box
Enable/Disable
Toggle Dirty or...
Get a Max value from a continous form's (subset) records
Auto Fill info
RecordCount clarification
Programmatically scroll a List Box
DateDiff Question
Cancel button on bound form
Reference Previous control on subform from a Main form control
Writing "transaction" records via continous forms and checkboxes
RE: Displaying results from combo boxes to subform
Re: wrong info showing up after choosing from combo box
MouseMove problem with continuous form on tab control
Help! with myfilter confusion.
numbering multiple key fields
pass through query with param
Outputting Data to a Text File
Re: combo box on subform showing same result for each record
input from form to a different table
Re: Total box at bottom of form
Event Procedure Owned vs Not Owned and by Month
Event Procedure to include 2 commands
How do I create a sub/function so I can activate using F5 from VBE
Send Mail From Access
Binding to an image
hwo to create a list of files name
Code to save table in my form?
changing mainform record from subform
Before Update Event
Using Colors in an Option Group - RGB Function
form/table question
Need VBA Help to Append!
Re: Sub form problem displaying value of combo box
Create and open a network folder via ms access 2003
New buttons or combos do not generate wizard
Getting CmbBxColumn from within query
Re: 2007 Open Form Command Button does not work at all!
Adding ALL to drp down list
Passing param with pass through query
SourceObject criteria
Runtime error 429 with EDI documents
SQL and leading zeros
Email message text
Runtime Error '424'-Object Required
Information about Spreadsheet-control needed
Access 2007 subform total.
ReportToPDF
Re: While Loop error can't find the field referred to in your expression.
subform total
control default value
RE: Recordset question/problem
RE: compile error: For control variable already in use
Bound Text Box Based on Multiple Combo Boxes
Lost all Visual Basic Code for database
too few parameters in SQL statement (expected 1)
Can't run with Access 2007
Update textbox from option group
Add 14 days to Dispatch Date
Re: Code Failure
Re: setting and clearing record dirty (A 2007)
Expected vs Actual
Refine listbox contents
Loss of ability to edit hyperlink in form field
Loop thru form controls that match records in listbox
Re: How to return a certain record from a table
prompt need to locate missing linked table necessary to open main menu form
Setting Form Rowsource
Spellcheck cmd button for current record only
Listbox Always Selects First Value
If record exists, edit it?
Docmd Send Object - multiple CC fields from a form
Re: using VBA, how do I get a ! into a string
Menu and submenu with commands
Text Box with ability to enter the user friendly 'looked up' value
Error using Like* operator
Verifying a Date from previous record before allowing new record a
Can't rename a forms
If, Then Button Code
Error handling in a Case Statement
Stopping a code to delete a table
Search field for not exact entry
Code halts on one PC but not others
Make the cursor invisible.
Me.AllowEdits with ComboBox
Deleting a Database
Opening an Access db within vba
LINK COMBO BOX WITH TABLE
Create command button to spell check form
Cbo Not In List code error
subclassing a form to control flashing
Datasheet question
miss\看来
add multiple records from a form into a table
need help for change full name code
Row highlighting by checking box in subform datasheet view
Row highlighting by checking box in subform datasheet view
Row highlighting by checking box in subform datasheet view
New objects don't work w/Access 07
REQ: looking for help/pointers on customising tool/control tips for Flexgrid please?
REQ: looking for help/pointers on customising tool/control tips for Flexgrid please? (e..g. balloon type and fore/back colour control)
Command Button, find multiple matching fields
Access 2007 Clicking In Record on Form To Same Record Different Fo
Form with (internal) image library
Unbound Form Events
can't delete record if checkbox is false
Don't want it to round
Complex Conditional DLookup/Query problem
Multicolum filter combobox
Re: keeping focus on a control
Comman Button
Hidden Subform, need NewRecord on Visible
RE: CreateTextFile permission denied
NotInList... NewData only working for some controls but not others
Using Text Box to Enter Criteria
Re: Index or primary key cannot contain a Null value
Re: Index or primary key cannot contain a Null value
RE: Select data from table NOT IN another table
Sub-form code not working as I intended
RE: Select data from table NOT IN another table
Class Module Choices
Hiding and Unhiding fields on a form
Persistent Breakpoint
Decimal number to hours
Update Multiple Forms
Need help creating code for sequential numbering
disabling a toolbar
Re: pass a value to an unbound combo box in a different database.
Windows 7 & Access 2007
Subform datasheet needs to show names depending on the number in t
Confirming Delete
How do I detach or disassociate a label from a control in Access 2
Filtering Between Dates
Color Picking
Sorting by a Status Field (combo box) on a Form
DLookup Help
How can I link form/subform in code?
Date type Variable - Type Mismatch
Calculate running sums
Auto Increment Number
How do I detach label from a control?
Exporting to Excel from Switchboard (Switchboard Manager)
Detail Back Color Question
Making boxes availble depending on combo box entry
Opening form to specific record
undo issue
Sum() issue
Re: I need a better filter
Creating email via Access Form
write conflict
Expression builder not working after 2007 upgrade
How can I code a checkbox to use "Y" and "N"?
Re: Need Help on SubForm
Need Help on SubForm
Code Needed in "If" Statement
If statment from msgbox responce
How to auto-populate some fields from the last record to the newon
Record entry on an unbound form
ADH paired listbox formatting
PictureBox class aligment issue
Problem with ColumnWidth property setting
Record Selectors on continuous form seem to select wrong record
Include 'empties' in query
Private Sub not working on main form
Tab index skips control
Possible to reference controls by Tags?
image file timings - help configuring a self timed sequence of ima
Subform reference
Re: Form_Dirty problem
Access 2007 and Default form to open upon load in Forms Coding
AutoResize on a continuous form
Invalid Use of Null on Function parameters
Dlookup and format
Re: Limit number of duplicate records per field
Decrypt
Return Conventional date from Year/Week combo
Data in Textbox not storing on Table
Buitl in "FIND" can not work on the subform
update the content of the field
elookup error
How to capture LostFocus
Hyperlink text - is their a fieldsize limit?
replacing a link to a SQL Server table with VBA
Re: conditional disable of textbox
'After Update' behaviour of controls.
Re: changing textbox color when selected
Access 07 Startup Sub Main
Steve Lebans Tool Tips
sql question
Crazy Labels
weird glitch with combo box
Centering form controls
treeview control issue
How to build a form to enter all "officers" at once
Re: Remove the selected node in a treeview (A2007)
Listbox
VB.Net control in A2007
I think this would be fun and Useful
values of column property for a list box
Converting access report to PDF in 2007
Form/query calculation using field value of a previous record
RE: Lock text box on current record
Re: Lock text box on current record
SP2 VBA Find Command
I didn't think of this
Text field like Date field
Error when closing form
WHERE's against words with accents
How to make one button to update 3 queries
compact and repair
Open Form On Close
Syntax for saving an exported Excel file as csv
Cannot requery
Access Application closes
wheel mouse event
" There was an error executing the command"
Question on Going to a Record
Questions about conditional formatting
Open form at first Alpha not first record number key
Form and subform weirdness when linking to SQL Server 2005 via OD
Re: Make Next button Visible after all Required Fields are entered
Default Value expression worked, now it doesn't
duplicate records
Simple manage of imported data
backing up the code mods
access table connected to excel form
Access & DLL
Re: Select file and save as hyperlink
Add a new column to a dao.recordset
Re: sql to vb
Re: sql to vb
2003 Database won't compile
Query criteria in textbox on form
Why isn't my text box/label populating on the report
ComboBox to update TextBoxes on Form
Sizing bound subforms based on number of rows
After changing the recordsource of a form, Disabling a button
Setting query criteria on form - text boxes
Link criteria on Open Form Command Button
KeyDown Escape Key not working
Drop Down / Combo Box
Attaching subform(Datasheet) to a subform(Single Form)
forms Coding
Re: Checkbox VB code after update
treeview and listview
Refresh, Requery, Repaint?? Which One?
Question Again
dlookup compare date values
Error trapping dirty event
Look up Name based on ID
Enter Parameter Values Problem
Automate (by VBA) scanning controlnames and saving in a table.
Maximize / Restore
Run-time error '2105':
Filtering forms data with a drop down box
Re: Getting a List of Tables in a Remote Database.
Refresh combobox data upon recordset change
Determine if external application is running
Re: Remove the selected node in a treeview (A2007)
REQ: looking for help on customising controltips for Flexgrid please? (e..g. ballon type and for/back colour control)
Re: subform variables not showing up in main form-only one blank row with field head
assigning all employee with first name start with D rev N document
Forms question - saving a form - VBA
Trying to ApplyFilter to form
Runtime Error
Wildcard in variable
Automation object?
Update form
RE: msgbox problem
Re: msgbox problem
Accessing Report Events with VBA
Combo Box Data Space Larger Than Combo Box Size
Combo Box - "<Select User>"
calculations in a form
Can Access Load A Text File
Form with multiple check boxes per record
Printing a PDF file directly from Access 2007
Don't Update Table from query filled form
Don't update table from form using query?
After New Record is added, update search combo box
Save Current Record; Go To Next Record - two tables in form
Incremental search with numbers
Parameter Form Error
SeStart question
Imbedded quotes in text field
Programmatically run Sync Now command
Problem navigating beyong the last record
Recordset in different colour
Send Email
Drag control with auto scroll
Form not working
Label visability changes
Message when record changed
check all yes/no boxes
Default value on continuous form from query
Looking for the right code
Using Can Grow in datasheet
Bring To Front
Data printing
Help in Coding please.
looping thru controls
Change event not happening
Autopopulate Form
get the previous data and make the chages
Autopopulated field in form
syntax for opening table, adding record ??
View Explorer Window in Access Form
Calculated control not displaying zero when recordset is empty on
Combo Box
Size of MDB code
Access 2000: Unbound Text Box saved in Same Table
Access 2007 crashes on open report that has no data source
Access 2007 crashes with docmd.cancelevent
Outlook blocks Access
Can't select from list box
WHERE clause in text Box
Determine which control was clicked by user
Switch to open application
Run Command On Certain Date
Re: Combo Box not retaining its value from table
disabling the undo button on A2007
Unwanted Message Box
How do I create an Access form that blocks 1st 5 #s of SSN?
Disable Database, Open With PW
edit fields to change multiple rows of data
DAvg in control - format problem
Query question
Feedback from Outlook
Re: Conditional Format whole line
form based on three table query
Re: Conditional Format whole line
Convert Data Types via Combobox
Pivot Table Or Pivot Chart
Event code apply to all objects
Date Code for 180 reminder
RE: Drop Down Box
Drop Down Box
RE: Option Boxes showing data
Combobox Sected Item
Tell what drives available?
clear button
Form State
Filter form based on value not in subform
Error Message when opening a button
Re: Access prints form instead of report!!
Re: Access prints form instead of report!!
Error Message when opening a button
Access prints form instead of report!!
Re: Pseudo 'Dirty' Event Procedure
Re: Button to export query to excel
Numbers appearing instead of text in Table
Remove navigation buttons on subform
Populate 2nd table from form
MS Graph Library
Recordset Clone using Autonumber
Freeze columns
Search and update with a combo box
Properties for linked text file
Re: Run-time error '5'
Form Open - Implement new record.
Next record after based on a sorted field not index
Report Graphics Not Appearing
Refresh form/subform information after update
Re: Login to an Access Application
Login to an Access Application
Set focus to control in another subform on the same form
Data for Combo Boxes - Most efficient method?
Display Text based on Selection from Combo Box
Re: Syntax Help
Re: proper steps to inserting pop-up calendar in Access form
proper steps to inserting pop-up calendar in Access form
A String ?
Code help with IsNot( ) operator
RE: Combo Box not retaining its value from table
Re: Combo Box not retaining its value from table
Select Two Values from One Combo
Enable a field only when adding a record
Switchboard Wizard Number of Items on Page
Allen Browne
Iif statements based on two combo boxes
Sort Order Button
parse a text file
Run-time error 2046 - need help with workaround
Special Effect annoying reset delay
Re: Option to cancel action on msgbox
Re: Option to cancel action on msgbox
Autopopulate 1 field based on another
Option to cancel action on msgbox
Activating OLE Obj In Form
Program not responding
Referencing sub-forms from their parents
Conditional Formating: Text Boxes, New Record
Combo Box to add items to a table
Open OLE File with Command Button
RE: Coding message in email
RE: Coding message in email
Major search task
Coding message in email
Message Box if either one of two codes in field
RE: can't find macro error
RE: No selection made for combo box
No selection made for combo box
can't find macro error
Re: Exit a loop when I have what I want
Report as email message rather than attachment
Example Reports?
Re: Loop through each field in a record
Freeze Panes
Mailmerge and Opendatasource
Error in multiple select in a list box code
Direct jump to a record
Conditinal Formating - continuous form - menu - Tickbox
ApplyType is always 1 for Toggle Filter
Importing Numbers in Scientific Notation
Dlookup Update
Importing Multiple files
Access 2007 Search Form
Alert to notify if duplicate Active measures
Aiuto!!
How to tell if a field on a form has changed? A control?
running SQL in the VBA code
Autoincement field reverts to Number after Tabledef is edited.
acActiveDataObject, works OK in Access97 but fails in Access2003
Re: Calculating Standard Deviation
Re: Calculating Standard Deviation
Re: Disable Controls + subform on a Form but keep one field enabled
Using VBA to Advance Form to Next Record in Acc2007 ?
Disable Controls + subform on a Form but keep one field enabled
Help With Code Please
Simple Loop Recordset Question
Dlookup in table won't work
IFF Null or NZ
Dlookup - To access and send multiple email addresses
do while?
Noob VB code, Need help with Passing multiSelect Listbox
Subform Refresh Fails on Opening Form. Works Otherwise.
A2007 How to output a PDF report
CALCULATED VALUES IN A FORM BASED ON USER DATA INPUT
Forced Page Break
need to update recordset for a function to calculate correctly - clarified and continued
Setting focus on subform row
Re: After Update Code
OLE Fields
Command Button not Enabled
After Update Code
Re: Transfering age calculation to a table
Re: Open form if box is checked
Open form if box is checked
Transfering age calculation to a table
Listbox format
Opening A Word Document In Access
error 3464 data type mismatch in criteria expression
Allen Browne's Search2000
Datasheet in split form is empty (running using Access 2007 Runtim
need to update recordset for a function to calculate correctly
Re: enable a field in a form
Exlude form in new DB copy
enable a field in a form
Re: Dlookup frustration
Dlookup frustration
Re: Start sequential number over every September
Start sequential number over every September
textbox autopopulated with formula...
Linking ComboBoxes
Take textbox value to other form
Access 2003-Date() = 12/30/1899 not 06/15/2009 why?
entering a form name as a function's value in a textbox's devault value.
4byte-char is not accepting
Porting to SQL Server Express
Coding
Open Report with the parameter
Re: Forms is loaded function
Append Records from a subform to a new record
Image file table update, code takes over 24 hours to finish....suggestions
Re: On Not In List
On Not In List
Why won't this work
How to set different combo box values for new record?
subform total behaving strangely
Help With Report Coding
Opening additional (non-default) form instances
Modal property
Re: function returning #Name?
function returning #Name?
Autonum Field is Null
Value on another table
Export datasets to different Excel spreadsheets in the same workbo
Re: Operation must use an updatable query
bof-eof
How do I force/run an object property
Unable to validate if text in control is bolded
Remove Filter keeping found record
Wrong records count in subfom
Open new record with selected fields from previous record
Object required running SQL Update
Validation Rule Problem
Update ALL records
Re: database size
Re: database size
Auto-populate a table from a form
output filter string to text box on form
Re: Show/Hide Comments Text Box
Show/Hide Comments Text Box
Re: Looping or Do While statement?
Looping or Do While statement?
Calling a User-Specific Form with Empty Data
Getting codes from a string type column
place cursor in datasheet subform based on query
form list requery
record macro
alter chart properties based on info in form
Print To Specific Printer
Re: Need to add other to list in combo box
Upgrade to 2007 breaks form link
Format a value using code
Re: How to code IIf test
How to code IIf test
dragging and dropping
Re: Timer Count
Timer Count
RE: Open form thru Parameter
Clear all fields in a form
Re: Trap Duplicate Index error
Disabling Specific Records
add a record
Loan
calculated controls coding
Someone stop my subforms from requerying
how to make math equations in a 2003 Access DB
Display Yes/No instead of -1, 0 on Search Forms
Name in table changes
Use Criteria to open a different type of form when item is selecte
insert record action truncating memo field data
RE: Subform Allow Edits Issues ?
Dlookup - new record
List box
refer to field on subform not working
Re: Slow Performance From Remote Networks and Telecommute (Through VPN)
Zip code code
open record on one form from another form
LogUsersOff
LogUsersOff
Add to table
trouble printing variavel
combining text file issues
Set A Field To Edit When Form Opens
Changing RowSource property for sub forms
Improving code
Dilemma of Multiple Apps for SHELL Call
Query problem
Progression bar
Navigation between forms
OrderBy property disappearance
Re: child records on the report
Re: Opening report
Re: Opening report
Re: Enter Parameter Value
Re: Enter Parameter Value
Combo box question on a form
Assign value from field in main form to field in subform
datatype mismatch - compare text to integer
Field to field validation
Change to form
Re: acDialog set but code keeps going?
Re: If Dcount Help
Scanning records of form+subform
bug in form event code
Expression that has no Value
Highlight all other fields on selected row in continuous form,
how to code a form for legal documents.
Re: IF Statement Help
Stumped on a continuous form
Re: MsgBox Help with Yes/No
Problems Managing Required Field and Form Events
Problems Managing Required Field and Form Events
Extract MS Project file from OLE object
open form event