Microsoft Access Forms [Archive]

Data entry VBA
Update subform with combobox change on main form
Data entry to table from a form
Data entry for a table from a form
Speeding up "1 of X"
Re: Train ticket booking system
Calling Error Handling in VBA
'Go to Record' button - simple task but can't get it to work
DDE Send functions from Access 2003 not working in Access 2007
Using "tiles"
*HELP* with sorting in Basicform & Subform.. Access 2010
Ribbons on a form/report?
Mouse scroll wheel on Flexgird in Access
Expression is typed......
Docmd.SendObject issue
get filepath and file name of the mdb file from the form within the mdb
iif exists - too complex?
Reset Label Caption to Original
Prompt for a subform text field
How to List attachments in MS Access 2010
Please Help! The Expression you entered is too complex
Hiding a button based on a value in a table
problem with command button (inserts specific text)
Continuous Form Control Setting (Select Case)
Excel type spread sheet for recurring monthly items
Option Group ListBox Row Source "Expected end of statement"
filter query on combo box in a continuous subform
Subform
if listbox field is 1 then else
Filter tabular form by combo box
How to open same Access 2010 in separate process?
Auto-update a field based on input from previous field
Form shows ID, not values
Access 2010 won't run vba code on form load
Multiple criteria on StLinkCriteria
Multi-Select
Access 2003 Data Not Saving?
show only forms
Continuous Form: Change the color of one row
Using DSUM to get running total on a filtered form
Set Change Event on Control from Nested Subform
Using form and subform not connecting to two separate tables
how to call photo and faxviewer
Listbox SQL problem
OnClick on Combo Box opens a New Form
Filter parameters asked on first open, subsequent unfilter/re-filterdoesn't re-fill the parameters
Access 2007 - How to send a form via email using an email from the database
How to tell when form is being saved
Help with form
Record Count On Form in Access 2007
Trouble Filtering a Sub Form With Combo Box Options
Unneeded Scroll Bar Space in Form
Need help with form objects
Populate Value from Unbounded Computed Textfield Field into Master Table
Horizontal Form
Automatically highlight duplicate value
Help with form load
Select a field in query using combo box
Access 2003 error message
No idea how to do this..
Uncheck all checkboxes on update
Pull part of data from a string
Passing a Parameter into a MS Access 2007 Form
The check box list control in MS Access 2010
Form real refresh
New Version of Invisible Controls In Form View/DE "No" Prop Issue
Currenct issue with a text box
Problem with report passing filter
Offshore Data Entry Process with affordable price
Filling in fields to a partially complete record in a table using a form
A2000 form ceases working under A2002
Problem with Report and Forms
Need Carriage Return after Data Entry
Complete beginner please help xx
filtering a form based on a filter on an open form
Pls Help - Checkbox not updateable
Can't set the null or "" text box to be a calculable text box
Re: stlinkcriteria syntax. multiple fields and wildcards
ComboBox not updating
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed"
Stephen Lebans clsToolTip for Access version 1.4
Populate a field on a form
WHERE [Characteristics].[abbrev] in ()
column width in continuous form
Running sum on Commond button
Access 2010 Form Background Color Not Changing with Themes
Go to a Specific Record on a Subform
Form with a Continuous subform
Open Form and GoToNew with an ID from the first form
Trick filter form combo with DoCmd.OpenForm and Data Entry property
First Subform record gets modified when closing form
Creating a table in switchBoard
Fax Individual Report via command line
In access if form value is yes display next field.
Rank by State ?
Mimic Split Form with Two Subforms
My new pivot table doesn't save
Re: Online IT Training / e - Learning Courses of SAP, BA, Java, Oracle, QA, Data Warehousing, .net, QTP, SAS etc @ Crescent IT Solutions
Re: Online IT Training / e - Learning Courses of SAP, BA, Java, Oracle, QA, Data Warehousing, .net, QTP, SAS etc @ Crescent IT Solutions
Bridge Club Player selection Form
Force Autonumber to generate
Conditional Calculated Field
inserimento dati contemporaneamente in tabella
Apply Multiple Payments
Trouble with Expression
Disappearing Lines on Form-New Record
basic xy scatterplots that should be easy
Hide textbox on a record - Continuous form
issue with non active fields
Subform with subform properties
Send Query Result as Message Text
Update multiple record values from form/query
Using Forms to Export Data from an Access Table to an Excel Spreadsheet
Pop-up form when a certain value is chosen
Combo box help
Automating Access: running your own functions/passing arguments
Unhide Textbox
Main form sum from sub form
Field Dependency
Delete Table...
backcolor property condional format
MS Access Text Box Control
database does not work
Run a form in background using checkboxes on main form
MS Access - Print help!
filtering charts in a form
Re: Query and populate form based on quarter selected.
Populating data to subform from main form
totaling in a filtered form
Masking Characters
Can A Form Be Used Instead Of Cut/Paste To Excel ?
what Active X controls exist for 2010
filter on combo box possible?
Error 2115 and Listbox
Highlight rows in a subform datasheet view
installing on workstations
run error 13 type mismatch
Re: Open a database from a database
Open a database from a database
How to join 2 sumarised data sets
"You do not have exclusive access to the database" error message
Why is "export" greyed out in Access 2003
Are there problems working with Access 2003 and Access2007?
How to add a button to a form that opens another form
queries and forms
Delete/Copy Path Too Long Files
type ahead combo
Trouble changing the Row Source for a Combo Box Access 2007 - SQL 2000
Requery on a Tab Control - OnClick
Synchronize combo boxes
Excel
Re: Is there a way?
Which is faster?
conditional printing/display in a continuous form
Subform has greyed text box field like it is selected
Spinning progress indicator
auto-populate field based on info entered into other field
Re: Form - Conditional Formatting
ACCESS 2002 enters some kind of endless loop and crashes
embedded macro vs event procedure
Add Field from Query to Form - Access 2007
Automatically generating text entries from combo box
Re: Form - Conditional Formatting
Re: Form - Conditional Formatting
NotInList
Duplicating records
About queries and forms
Microsoft Access Power Mastery
SAP,ORACLE,OBIEE Online Training @ BigClasses.com
Re: Form/subform navigation
Re: Form Design advice
Adding data from a table to a subform with DLookup
Cant open database. Error: "could not find the object 'databases'
Problem with forms
In a Form wizard do not work
Control bar align
Strange message instead of wizard
Embedded dynamic image in MS Access
Macro doesn't work first time form is opened.
Combine data from Query
Update multiple records based on multiple fields?
Access Menus
Access crashing on a form
default value from another table
Access 2007 bug?
Instant Totals on Continuous Forms
Forms use linked tables and have multiple users
allow multiple selections from multivalue list
Access 2007 Tabbed form with shared recordset
VBA Syntax for subform record source change
Date parameters for report
Requery not working
Persistent variable?
data is in table but not forms
Copy Files with long file names
Capture ID of newly inserted row
group numbers in groups of five in a textbox?
New record button
two questions on exporting from a form
How to fing ping via VBA?
Form code stops working
Report distribution list
Tablet PC / Access 2003 and Capturing Signatures
Re: switch board
Re: switch board
Convert form's macros to visual basic
query in another database
Combo box question
Re: Keeping Form invisble until all data loaded
Open a form, via hyperlink, from a list
Auto Fill
Nace nuevo sitio de anuncios
Good job!
Snap To Grid: Label vs. TextBox [Access 2002*]
Form Problem
ManningFan - some tips about unbound forms?
How To Send And Email w/ Attachment with Access
NotInList
Re: Keeping Form invisble until all data loaded
Re: Keeping Form invisble until all data loaded
Why does form open narrower at runtime...
Form's title bar question
Trouble associating parent form record to subform's record
Formula to give squense number
If I DON'T put this lass MSGBOX in the code, it moves off my found record!!
How to change rights?
Can Grow/Can Shrink don't seem to work
Where does word "test" come from?
Re: xml import won't work
This seems like an easy lookup...what am I missing?
Need Help with Parameters
Deletes not available
Split Form event "On Data Change"
Error in SubForm After Switching from Access 2000 to 2007
Expression....is too complex
How can I change my default printer to another printer via VBA?
Access 2007 - Hiding the Menu Bar
Oh My Gosh, I just don't get it... Detail_Format() not triggering... arggg
Help with Lebans Code - A2KAutosizeOLE
Error on simple expression in footer
Jpg pics won't display on one PC
Hide a form button
Display records based on specific values
drop down based on query but also need a blank as an option
Need Mailing and Billing Address Displayed from Same Table
Delete Multiple Records from Subform
Synchronising multiple combo boxes
Form properties
Validation Rule Error Messages
How to use setvalue to set form comboboxes to null
Difference between Access 2007 and Access 2010?
"button" / form not working
Populate field from previous record
How to keep users out when no current record?
Best way to facilitate user's cancel?
chart in a form
A single row has too much info for the screen.
cannot assign query to a Subform
Hyperlink record / Startup?
newbie needs help simple form
How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart.
How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart.
xy-chart axes lower and upper limits dynamically set by data seriesvalues
How to find text between 2 words in a field via VBA?
OFFLB.exe
1 combo box changes per 2 other combo boxes
Addnew followed by Edit
If/Then useage in a form - what's faster?
subform suddenly not add-able
Opening a maximised report from a PopUp Modal form
Open a database without running the main form?????
editing a table thru a form
Calculating a text box
Open Splitform and Activate first record
Re: Can this be done
Re: Can this be done
GoToRecord on Split Form with Hidden Fields
Dev Ashish - fConcatFld function assistance
Conditional Processing
How Do I AutoFill a Form
Re: Setting visible property to text box won't save
sum calculation is not accurate
Re: Hiding a text box on a form
Application window size
Re: Audit Trail function won't record new records
Error 87 When Creating Large Email Distribution List
Form opens scrolled to bottom.
Controls don't appear in detail
Changing null to "" in a form field.
Mail Merge from Access - Word throws "Cannot Open Data Source" Error
No vertical scrollbar on form
Function as a control source?
Combo box problem
Autofill Combo Form Always Selects First Record If Same Name
Form fields don't need to always be filled in
Re: Another audit Trail module, now a runtime error
Need help on auto pop time through a form
Re: Audit trail on form
Re: compile error: expected array.
tab control; tabbed pages; form's vertical scroll bar not in topposition
The newly created record is now shown in the form
Re: Ribbon Customization in 2010
If calculation in text box > 1 hour set check box = True
Re: copied form to new database doesn't work
Mouse Wheel
Transfer Data between forms
Adding a Prefix
Combo Box not showing old records
Start Table ID count over to 1?
Access 2007 Verses 2003 - passing of variables.
Query Mouse Highlighted Records
Re: Running a query from a selection
Re: Running a query from a selection
Access Graphs - It converts my string into a number!
Performance issues with Access
Re: restricted access to a split database on a server
Trying to rename files in a folder from VBA
Displaying images in Access Forms
Is there limit to number of files in a datebase in searching forms
RE: Is there limit to number of files in a datebase in searching forms
How do I control a text box via another combo box
Limit Combo Box
Form Subform DLookup
Is a vertical datasheet view possible
Default font for forms in Access 2007
Re: Even an error with this code I copied
SubForm, or something Else?
applying concatenate filter
Criteria for check numbers only
RE: this code doesn't work fully
Re: this code doesn't work fully
Re: this code doesn't work fully
How to get Email address list from Outlook to Msaccess
Forms or Tables
Hide ribbon event not working
Imported Form Changes
Tab Order
importing graphic file msgbox flashes when changing records, turn
status validation help
RE: Sum error on continous subform
combobox problem in a simple form!SOS!
How to save a form as a template
Lebans MouseWheelOff code
Error Message "Compile Error: Variable not defined"
Graphical problems with forms in AC 2007
Re: Combo Box Adding Button to edit list items
Re: Date query
Value list updates not appearing in form
Skip pattern based on text box value
RE: Combo Box Adding Button to edit list items
Conditional Formatting
Populate Textbox
Re: Remove CAPS
Unbound text box calculation
specifying which subdatasheet in Access 2003
How do I repeat my header on each page of an access form
Employee time punch form
Re: Albert D Kallal's Ribbon Code
Multi Value Combo Boxes
Sorting Combo box items
BoundColumn property
Replace "assign the null value" message
Using the second column of a lookup field in row source
Problem Delay and Slowly Running the Microsoft Access
Re: How to use dynamic query in Access 2007 Form?
Form Scroll Bar
Re: read/write for some users, read only form others
checking for existing record
Re: input scanned documents in access 2003
Missing files
Re: mde file in Access 2007
Re: Password protection
Re: Password protection
Help with an expression to calculate a profit from one of three fi
Re: Employee Barcode scan IN and OUT using Access 2007
How to display progress on slow opening form.
work with million records sql>accesss
Re: Form just opened doesn't see data entered in previous form
Associate a form button to a query
Need free lease to purchase real estate agreement
Re: Matching data in two tables
Toggle button vs Command button
Check boxes to run queries
Embed Excel with form
Click a subform field to open relevant form
Re: Using 'like' on a user prompt
Re: Using 'like' on a user prompt
Windows 7 presses button
Add code to CloseButton
Search Filter
If field then checkbox and enable
DateDiff Error
RE: employee ID into text box, need to show all ID's that have ck in o
auto populate text box based on combo box value
Hyperlink on forms
expression has invalid reference to property form/report
Opening a sub-form from a command button
Sendobject Question
Requery Combo box in popup form
RE: DateDiff Error
A Great Big Thank You!
RE: DateDiff Error
Version Updates
RE: get data from a table not in a query
Form Refresh
RE: Datasheet Subform Query
Setting Size of Switchboard
RE: Setting Size of Switchboard
RE: auto populate text box based on combo box value
Free migration kit for MS Access developers: MS Office 2010 Web Apps
Very Simple Question
Re: Picking only the latest entry?
Wild card not working in Access 2010 query
Opening a dialog in a more helpful position
Set Query Criteria thru Function
Routine to run/export queries
"Enter key" default
Common “Button Block”
Not wanting to displaying certain forms
A calculation in a form
Web Browser Control
Overflow
User Name in a text box
Freeze fields with a command button click
Clearing a field
Displaying Yes/No as Yes or No instead of -1 and 0
How to add record in Subform which is in another Subform
Form will not allow checkbox option group or toggle
Re: Load Image Timing
Update box with combo box
Control limitations
How do I format a field based on the value
Provide Help/Tutorial Form
autoformat
On No Data Event
End of service calculation
Re: command button for find records
Re: command button for find records
Check for duplicate with multiple criteria
casting call for models in buffalo
Control Layout
trigger an event by changing pages in a tab control form
Re: show 2nd field when combo box choice is made
Selected subform record becomes unselected after code runs
Windows 7 Sendkeys
Autoformats
"Reset" combo boxes
Convert a form to a split form?
Text Box
Re: Search all table records from filtered form
Events Management
a question on form.item
Don't add record
crash on form with two subforms
Form Open Error Message
ComboBox formatting
Input Mask - quick question
What is the extra field added with a combo or list box
Problem Printing A record
subform for inputting grades not working
looping through controls - for each ... next
should i hide a form or make it modal
What is the extra column added to a form datasheet by a control
Delete button
attachment in form
Re: help needed with a combo box
Combo Box
Sum & Count on Form.
Conditinal Format Not Working
Combo Box - cursor automatically inserted instead of scrolling thr
Filter by form search field showing non-distinct values in pull do
Create datasheet in MDE
Microsoft Word Table design in Access 2007
How to prevent form from closing
Combo box values for existing and new records
Another cascading combo challenge
Adding lookup to a exsisting form
Access runs slow under Windows 7
How do I populate a subform field with a value from the main form?
How can I update the data listed in the combo box to show the most
TransText Method
Displaying Text Data in Pivot Chart
Field name derived from a string value returns a Run-time error 2465.
Auto fill field on form
Re: Order Form - Issue with Fields set up as combos
Selecting Photos from and ComboBox list then print on a Report
Filter Subform
Re: Retriving database properties
RE: forms
Pivot table form
Re: out of date items
RE: how to update a field record based on inputbox?
combo box control issue - working fine in '03, - not in '07
Wizard unable to open form in Form or Datasheet view
Creating forms from queries
Print a report from a form based on a query
Report Selector Form Disappears
enable/disable text box based on 3 combos
How to run event on other options
Trying to use DLookup
combo box fills in arbitrary value
Order By/Filter clause corrupted with aliases
Filter Table in Subform Control according to TextBox control value
mail
Continuous Forms Question
MS Access 2007: Calculated field based on subform:
List Box Percentage Formatting
Form Auto Populate
#name? error
Subform not refreshing in Access 97
New Problem - Buttons
Combo box finding wrong record
How to get one field to update based on a selection from a drop do
Filter SubFrom from Main Form using date
Cannot View Form in 2007
Re: how can I replace SQL query with VBA logic
Combo box that prints report
cant type more than 11 numbers
How to enable New/Delete record button when a form opened?
Sending a link for a form to the desktop - Access 2007
Access 2007
DLookup returns same name
Running Total from a Subform
Need a button to print 5 copies
Combo Box Filter
Conditional formatting not quite working
Quick Filters Issue
Conditional formatting not quite working right
Add consecutive dates w/ command button & parameter boxes
Creating a Form Desktop Shortcut to ACCDE
Re: Field Form
How do I sort a listbox by field
MouseDown event does not always fire
Sizing Access 2007 Forms
"free" ip number when I remove device from database?
Dlookup Question
Default Value =Date$() in UK Date Format
Delete record button not working (allowedits = true)?
Internet Explorer 8 Update problem
Hide and Unhide AC 2007 Navigation Pane
Quote Form With Options - Repost
Nee little help on tabs
How do I detect if item in lisbox is selected
stopping an unwanted requery
Unhiding a Nav Bar Object
WordMerge
Word Merge Data
Conditional format not working correctly
IsHyperlink not working for Unbound Textbox
Expression in forms
Form Caption Length
Use Parameter Data to populate a form field
Linking two Subforms & showing name in place of ID?
Refreshing tab problem
Viewing Attachment Photo on Form
Control Will Not Update
Opening a filterable report from a form
How do I get the combo box to link with costs field in the table?
Access frontend with SQL Server backend: my solution for ODBC Call error
Cascading Combo Box - help needed please.
Dirk Goldgar help please!!!
Form will not display records
Data Availability - Timing
"Too few parameters" error - sometimes
Help With SQL
2007 Forms - Quick Filters not working
Page displaying in design view, but layout view shows blank screen
Database - allocate software to device
Datasheet view change
Date Picker Default?
where is the "on timer" function for forms in Access 2007?
unbound text box filter by form on Split Form
Conditional format - Check for valid values
RE: subform problems
Multi Select For Query
Re: Open Continuous form with a few lines showing
TextBox reads entry as numeric instead of text
Toggle buttons dont turn blue??
Allowing Temporary Sorting
unbound forms
Filter
datasheet: ¿how to order by the 2nd column of a combobox?
Form Filter question
Details of how Filter By Form works
Hyperlink - partially opening
DatePart in Filter By Form field
compare fields in listbox
Radio Button multiple selections
stLinkCriteria Syntax
Table Help
ComboBox does not drop down.
allow user to highlight field on form
Access 97 form not properly refreshing
Are If statements possilbe in Queries?
Are If statements possilbe in Queries?
Re: Modifying the template Northwind 2007
Updated Charttitle not working in Access 2007
Re: After Event to automatically fill
Re: After Event to automatically fill
Access 2007 form won't open?
Allen Browne’s date range vba for more reports
CBO List
Re: Force user to click on Main Form First??
Multiple quotes for same job number using option buttons
Form Formatting
drop down list: how to open on cursor
Change form size
Form doesn't move to next record after update
Default Value on Form Help
The changes you requested to the table werenot successful ........
Recordset Update Issues
Conditional format of a control
Quote Form with Options
Recordsouce question
Clear Unbound Text box used as input parameter to query
hidden form
Who is logged in?
Auto Correct Function Question
Overriding constraint restriction message, when deleting record(s) from form
Re: Upgrade questions, re: 2003 to 2007
Re: Filter in the subform
Sub form validations
Form and subform for partial data entry
DLookUp Format
Re: Form label showing extra character at end of label
Help Please
RE: Regulating available options
RE: Search form with a checkbox.
Combo box problem
Make invisible with a checkbox
Re: how to requery on new record continuous form
Can't find posting
Forms - Option for user to leave some text boxes as blank.
pop-up that asks a question
Forms & Reports Labels on placing the field
Saving Form as Report in ADP
Adding an image to a form in run time
Locking Check Boxes
form - full screen
Undesired parameters requests in nested datasheets with comboboxes
Minimize access windows
Using list box adds blank record to lookup table
Cancel/BeforeUpdate Event Procedure
Data Entry Form.
Filter-by-form and Linked Tables
RE: Disable and Lock All Feilds wiht a check box
Re: Total in Footer
custom lines on pivot charts
Disable and Lock All Feilds wiht a check box
Set focus in a specific record within a subform
Re: Form opening to new record
Autofill text boxes
The disappearing form
Two subforms, one based on selection in the other
Fields Positioned At Bottom of the Form
Command button in a form
HELP WITH BUTTON
commerical construction-satisfaction of completion forms
Possible to link fields in a form to narrow selections?
Link two subforms in datasheet view (one sub-form, one sub-subform
combobox rowsource "All" if more than one in list
Re: Form Trouble
RE: Link Forms with multiple fields
Re: Requerying data on differnet tab
RE: Graph displaying dates alphabetically on x axis, not by date
Searching with a text box
Pivot table Control of height Access 2003
Subforms limitation
Setting up tables for grades
How to validate sum of fields (access 2003)
Tab sequencing not working
Parent Child Wizard Abscent
Blank Template with rows and columns
Comments Textbox
Combo Box not displaying properly
#Name? error in Form text box
dlookup with multiple criteria
Play a video file in form
Why do objects disappear in form view
Funny Split Form Bug?
Form Not Visible
Setting Font Properties
Filter on Subform Not Displaying as Expected
RE: Auto Fill Fields
Filter Form Based on Subform Combo Field Problem
creating Time Book Need help
Subforms
Names Translation
Duplicate Record command
Sub forms keep turning out like tables
Overriding constraint violation message
Tabular Form - Move Cursor Down
Automatic control names
Edit Union Query??
Data Refresh
Filter Frustration
Filter by form with linked tables
Why Does My Form Copy Values From My Lookup Box To The Other Recor
Filter Question
IIf statement sometimes works
Picture Property
SendKeys & Windows 7 Problem
Runtime Problem
Form not carrying names to table behind the subform.
Sorting empty fields
Re: Combox not getting into edit mode
Yes/No Format Issue
Re: Option Group question
Embedded Tabs in Access 2007
Populate a form based on a query using parameters
Changing font in rich text table
Errors 2448 and 3075!
Re: Combox not getting into edit mode
Cascading combo boxes - are they able to do this?
Making a Time book Form
Search Key Not Found while searching in a form
Exporting all forms record either in a table or Excel 2007.( Any m
Help Require (Macro Save button )?????
Re: Relationship diagram
Re: Relationship diagram
access 2003 no query results for a form
MS Access Themes not displaying on some Computers
Main Form with a Subform with Check and Command Boxes
Access 2007-Duplicate Record Field Capability
Form First Load Empty
Listbox Counting (not .listcount)
jumping data
Automaticly clear checkmarks
data entry in subform before mainform causes huge hassle, HELP!
Combo boxes like an option group?
generate a confirmation email
Formatting phone field based on value in another field
CONDITIONAL CELL FORMATS DONT SHOW ACCESS OFFICE 2007
RE: Count Instances in a table field
Re: Count Instances in a table field
Combo Box Search
Form Help
Loopup Box
Re: Message box for form regarding DOB
IIF Statement Help
Date format in a combo box
Re: Message box for form regarding DOB
Using a datasheet subform as record selector
Object or class does not support set of events
Calculated field in Forms
SBS 2007 Error?
Not Enough Memory
Access chart starts with too early a start date
IIf statement to show A, B, C
GetOpenFile() and UNC path