Microsoft Access Form Coding [Archive] - Page 2

Displays Allen’s Browne filtered records in another form
Help screen for VBA in A2007
Export query to XML file
to run code when user click on CTRL-F
Ctrl- F for search
raise form events programmatically
Running Apend,Delete and Make queries with VB
Filter Form on Combo Variable
onKeyDown: ¿how to call my own function?
Run Time Error 429
printing multiple part labels
Baffled by missing data on printout
update cascading forms
Re: Problem in a query with DLookUp
MouseUP is firing when Form is Loaded
Test for a Combo Box empty or not...
Serial coding
Run Time error 2683
Recordset.Clone Help Needed
Tracking Time
If Checkbox Yes then Prompt
Conditional Formatting - Worked - Bad - Doesn't Work
Allow Temporary Edits In Form To Table Values
Proper code for multiple background color states in a text box
Calling Private Sub()
Click Checkbox then prompt
Creating a trusted area + splitting
cursor in listbox
Suppress "0" in numeric text box
Public Function to display in text box
Me.Undo Follow UP
Me.Undo
Delete record command not working
Form_current() firing multiple times
Filling a field with multiple criteria
Credit Card Integration
Combo box synchronization
default value for one field based on another
select and e-mail multiple attachments via Outlook
TextBox reads entry as numeric instead of text
Re: Reading xlsx using fso -logic..
datasheet: ¿how to order by the 2nd column of a combobox?
Filtering a Form Based on a Subform
link system table
repair database exclusive open
Access 2003 and Windows 7
Changed a form to have two tab control
Locked Subform still lets me delete a record
Controlling fields in continous subforms (hunting for ideas)
Combo Box Coding
Opening a query from a command button
not recognising a query
referring to an Active x spreadsheet control
change Caption menu Items
Tricky one...”Select”
Filter Combo Box Listing
How to modify Expression1 or 2 in existing FormatCondition?
Is it possible to have If statements in a query?
Are If statements possilbe in Queries?
Retain combo box order
Re: Use calculate age to write other fields automatically
Opening an Access 2007 form from Word VBA
MDE in A2003, A2007
Re: Use calculate age to write other fields automatically
Re: Combo Box Default Value based on a query
Re: Combo Box Default Value based on a query
cancel form unload
Populating a field automatically
Conditional Formatting question
Comparing data from a subform and form
Showing certain records in a form
Re: Not saving records till "save" command button clicked
AllowEdits
Referencing another field
Auto Expand a Combobox
Subforms
Search form via filter
Filtering using two controls
Can't sort
Error on filtering data in a from
ListBox and Navigation on Unbound forms
Forms doesn't move to next record
Be able to Center the texct in datasheet View
PivotTable object reference syntax
Default Path to the Desktop Folder
Cbo box Limit to list = No write question
On Click, Open a form, choose a selection then have it populate fi
NotInList is giving me grief
Button to Append then Open Form to Record
Yes/No Field
Copy a currency value from one control to another
Run-time error 3021
Reference a Popup field
Re: visible controls
Access 2007, Rich Text control. Cannot programmatically change font.Am I mad?
Re: mscomm32.ocx Windows Xp
Text box color code
Get PK or autonumber of Newly appended Record
Multiple Email Addresses in CC - April 30th deadline!
Run-Time Error '6' Overflow
Form will not update calculations
Switchboard to Datasheet view
Two After Update Events to calcalate?
Call function from on exit event
Lock data
Multi-select multi column list box
Close a form when it loses focus
Resizing Forms
Web Browser Contents
Form performance
Disable/Enable all controls on a form based on value of anothercontrol
Re: Need Help with subform
Re: Run-time error 3075
OpenArgs problem
RE: Run-time error 3075
Switchboard Label1 Missing
showing days of the week from the date
Subform not allowing data entry
Auto generating primary key number
runtime error 3075
Timer of Form
Error 2237
How to use Or in txrbox
Events for a multiselect list box
PLEASE HELP: Send email from Access with data in email body
RE: Opening A Form from a List Selection
Can't select - Combo Box
I can't see my last posted question and asnwer
Re: Legends
RE: Legends
RE: SQL question on my form
Re: SQL question on my form
Set focus issue
Issue with code SendObject 2
Issue with Code "SendObject"
countdown timer
Enabling a control based on multiple criteria
Using OpenDiag for alternative purpose
Combo Box Wizard
Slow form
Prevent duplicate selection from combo box on continuous form
RE: How To Go From One Form to Another
Input mask
Textbox Filter
Check box to filter subform
form closes on button click before DoCmd.Close acForm fires
RE: Getting 'Type mismatch' error after redesigning form
Form
DLookup
Ideas PLEASE
Another Question on Subforms
Pointing a specific line in a continuous form
Search Form with a SubForm
fOSUserName
postmessage to kill mdn application
cbo box Catch 22 situation
Passing Parameters between Subroutines
Add 31 records w/ consecutive dates w/ command button?
Applying Hyperlink in Access Genrated Email
ADDING values from one listbox to another on same form
Deleting records from a subform
Link BE with codes
dlookup using several fields
Add New Record for Combo Box
Update Y/N check box for all like records
Coding for shortcut keys
Using the DLookup function
List box with available queries question
My code stops after the record saves....form never closes
Form Query Refresh
looking for a way around a write conflict...
launch mdb to activate
Getting message when modifying
Validate/Verify entry in MsgBox
Pasting in Tab Control pages
SpellCheck Will it work on the Access 2007 Runtime?
Form tries to insert row when it starts
MsgBox
close mdb database from calling mdb
RE: Limit to List question
RE: Automatic backup daily - From developers point not storage team
Connect to sub-form without Parent/Child link
Delete files in directory
record count issue
Copy form datasheet to table
rs.RecordCount
Form Field Auto-Resize - Access 2007
Making a combo box enable for two case
does a window or dialog have a return value when closed
RE: Message box when DOB meets certain criteria
Selecting Printer Tray for Mail Merge
Re: Check Table, if found, fill Fields
need an acDialog clarification
Re: Do loop
RE: Do loop
close mdb from calling mdb
close all programs from launch center
Tabs disappear on tab contgrol
Change label if record exists
Re: Message box when DOB meets certain criteria
VBA to send email via outlook. Sendusingaccount
Subform Issues
Access - Outlook Mail Automation: SendUsingAccount
DoCmd.SendObject in AC2007
Total filtered record count on filtered adp form
Checking for Dups
Filter Juction Table and related tables
Command button in a form
Adding records to a table via a subform
First date and last date of the current month
Re: What if I keep my .mdb format instead of converting to .accbd?
Calender with available dates showing
Auto partially populate form
Creating an email in ACC07
Record Number
MDE problems gone.
Reference woes
Access-Outlook
RE: ARRRGGGHHH!! Syntax problem with requery on a form other than
fit to screen on any resolution with access 07
shell running multi instance
Make field Visible/Invisible
Looping Through All of the Fields in a ADO Record
Insert Form in Page
Display Number of Employees
RE: How to efficiently set up a sequence of checks for form validation
Finishing the application
shell to run another mdb
running another MS Acess
check instance running
create link table at run time
Capturing data from a list box
if and then in a form
Re: What if I keep my .mdb format instead of converting to .accbd?
Hlp! Requery Cbo Not Working
Select records with form driven input
read right registry
luanch center
RE: Displaying Information from one Form to Another VBA Code
VBA code to call first date of the year and last date of the year
Chart source setting with VBA
showing a subform based on the main form
RE: Q: File - Get External Data - Import
Changing subform SourceObject
Re: Using the Autonumber
Building a "save form and open next form" button macro
Re: Using the Autonumber
Problem with closing from from Close Button
Form Field/Function problem
Change color on date field in form for re-certification
Creating a string based on a query
Compile error: Argument not optional
Subform changes to totally different subform upon save!
Re: Absolute Field Validation
RE: laboratory data model design
Combo Box Null
RE:if..then..else statement in Microsoft access using the properties
COMMAND BUTTON CAPTION
Tickbox Update
dlookup not working -
Problems adding new record from form / subform
rename csv file by removing date/time stamp before importing
link form to report
Using Query Defs in a Form
Re: Convert a string to an object.
Multiselect in datasheet view?
Multiselect in datasheet view?
Using QueryDefs to Build a Dynamic Query in Access
Please Help: Append New text to old text
Problem with switchboard
Recordcount is always 1 step behind.
Dates with day below ten aren't found with docmd.applyfilter state
Go Through Records by ScrollBar Control
generate a sequence of random numbers
Bug 1 mdb With Tab Control works fine. Bugs with mde
Counting Weekdays in the Future
Re: IF ElseIf and Else
PLEASE HELP: Reload a subform with updated columns
3020: Update or CancelUpdate
RE: Combo Box AfterUpdate Problem - Access 2007
Problem writing to an "ini" file in Access 2007
using 'bold' in a continuous form
Tracking changes
How to add leading zeros to split field string
change all form properties with code
RE: FindFirst not working on second sub form
Num Lock Key Toggles Off
Synchronising two combo boxes
Broken Reference to Added dll Trashing Access 2007
Change position of acDialog form
Row to Column
Code that worked in 2003 doesn't work in 2007
Run-Time error 5
Send Appointments from Access 2007 to someone else's Outlook Calen
Changing total on one row in Continous Form
DLookup with mulitple criteria - error message
MDW Security and new Access instance
how to refer to all rows in a list box
get computer name, desktop and my document
Date reference in an IIF statement
ApplyFilter problem
Disable shortcut menu for page header only
Refresh Button Code
Calling Procedure in Hidden Form
querying a concatenated value
Opening document with specified font
Zoom question
Mail Merge
A2007 -> A2003 did not go well
Test please Ignore
Re: Unbound combobox invalid datatype error
Unbound combobox generating data type error
Syntax error (missing operator)
Recreate VLookup in MS Access 2003 Form Using DLookup.....
Remove sort and filters programmatically on form
Memo Box Resize in Form View
VBA in form to substitute for parameters
Access 2007 and Outlook 2007 integration
Abandon New Record
Keystroke shortcuts
Dlookup on form - help please
enumerating combobox's list
check subform for records
How to avoid duplicate entry in the subform
Transferring the filter from a datasheet form to a report.
Re: References are not working across computers
Form flashing
how to do this bit of code better?
syntax help requested
function help needed
Re: Full Join in MS ACCESS 2007?
RE: Keep getting error from code
Re: Keep getting error from code
"Can't go to the specified record" on Add
I want to transfer data from a filtered datasheet to a spreadsheet.
Re: Full Join in MS ACCESS 2007?
Need to use F9 to requery in subform
Using Findfirst recordset to search memo field type
Re: Access MODAL form does not seem to act "MODALLY"
PLEASE HELP: Assign column names to variables
Recognizing when a Print Preview window closes
Referencing Forms
Coding bug
datetime picker
a 'Refresh'ing question
inserting a new record from a pop-up, and returning to the main form at that record.
Selective use of Spellchecker to ignore forename
Format in Message Box
Report displaying behind form
cant find field
Re: References are not working across computers
Automatic Save when leaving a tab page?
Question on Transactions for Allen Browne
Using Access 2007 User Constants in Word 2007
crash detection in database
Access 2007 Runtime Error 3075
Access import CSV file with comma issue
Opening a blank form
Code to preview multiple instances of a form
Print Powerpoint pres
msgbox question
Change Field BackColours When A Tickbox Is True
PLEASE HELP: Refresh a subform
programtically change an Embedded picture of a command button
Cancel NotInList event
Getting Parameter box
#Deleted
loop through record set
Scrolling in VBA module
Any suggestions on a "Help Document Engine"
"Exit Access" Code
Substituting blank fields on a form
Opening the form
Filling a form field using check boxes
Change Label based on Two Combo Boxes
PDFC Reader Control
default
A way to bump posts??
Using Option Buttons to Modify a Query
Time Value Multiplied for Round Trip Calculation
Toggle Button
Continues Subforms Scrolling
Connection string for passthrough query on windows 7 64 bit???
Microsoft, I would like you to know...
HELP PLEASE: Display search results in the same tab below the crit
Calculating comboboxes
RE: Passing variable between tables
Combo Box to select a record and populate fields in a form
Sort with Listbox Selection On Top
Duplicate a Record
Change Subform based on record selection
PDFCReader Control
RE: Dumb question about tabs or tabs with subforms
combobox.dropdown event not working after error
Re: Access 2010 Forms - Converting 2007 Client into 2010 Web
RE: automate copying text in Word doc to Access db
Change Field BackColours When A Tickbox Is True
RE: Certain Form Load According to Combo Box...
Rcvd err msg: File Not Found
Coding HELP!!!
RE: Certain Form Load According to Combo Box...
Cancel On Lost Focus Event
Create A Search Field on a Form
Filtering a form - wait
ACCESS AND THUMBNAILS
open a form at a certain time
How to find the name of the present subform
Office 2010 beta issues
code closing multiple reports
two ComboBox questions
US Date Formatting
RE: Hyperlink not clickable
How to show what record number you are on in form?
Determine the WindowMode of a form
Almost got it. Change order on subform After new record added
Determine If Record Selector is selected
Split Database then error 3219
PLEASE HELP: Display results in footer section of a split form
OK my subform is not entering saving the key from the master datasource.
access to outlook 2003
duplicate prevention in form
Capture Delete event
Save record order in main table
Set a report's Sort/Group programmatically?
Re: Access 2010 Forms - Converting 2007 Client into 2010 Web
RE: Access 2010 Forms - Converting 2007 Client into 2010 Web
Including Null values in query design
access 2003 forms not workin access 2007
Hyperlinks in command button
Create a button that would launch spell check
Count number of rcd on continuous form.
Event when spell check makes a change?
Dynamic Form
Application.HyperLink vs controlname.HyperlinkAddress
Application.HyperLink vs controlname.HyperlinkAddress
Autofill field based on values from another table
Auto Populate a form field
RE: Spell Checker Issue - Please help!
HELP: Display search results in footer section in a split form
Creating a customer record in a child table
textbox info based on cbo
Re: Appending in a sub form
Can you add a Tab Control on the page of another tab control?
AutoFill On The New Record On NotInList?
Need help with calculating dates in records
Error message previously working program - Added to it - wrecked,,it
Missing operator Error
Form Security
move a scroll bar programmatically
Moving the record set
Open one form with different queries
open folder containing data for the same country
simple can't find form question
Form not Pre-Populating Correctly
SetDefault
If Checkbox is checked show msgbox
Using check box to make record active
Converting Now() into number value
Compound Index
Grid control only displays 1 record
Re: Passing values of listbox to other form's combobox
vba coding
Displaying Currency
Error 3021 but records exist
My posts are being canceled Why?
Export Column Info to Words or Notepad
Batch printing based on Combo settings
Re: subform not accepting new data
Command button plus message
toggling visibility of labels through code
Levenstein with * wildcards???? or other Search Suggestion..
Control1 GotFocus and Control5 RowSource
Auto Filling fields in form
Populate multicolumn combobox
RE: deleting a record after copying data
Execute .bat File Within VBA
Access Coding from 2003 to 2007
Access Coding
Using code to move to the top record of a listbox
Prevent Full String Selection after Change Event on Control
Re: Delete REcord isnt Available
Access 2007 problem with Command Buttons
Re: how to set form properties in vba access 2007
Sum multiple fields on a form using access 2007
Passing the value of a Combobox to another field.
RE: Can I use group by clause in DCount
Disabling and Re-enabling Keys
Printing a Report on a command button
Enter Parmeter Dialog Box
Change subform filter after lookup?
"File not found" and "The form name is misspelled..." errors
Cancel Add Mode with Required Fields
db backend upgrades
glitch: opening form to specific record using its ID
Custom menu trouble
import files to access
XP & Vista & Win 7 My Doc Directory Structure.
Dialing numbers using internal modem using vba.
Using a button to copy contents of one file into another.
Date function for "Last Quarter"
text box help needed
filling unbound form
me.requery
Clicking on Newly Opened Form
Error 2427
Office 2003 SP issue
Do I need .FindFirst?
MsgBox shown in background in respect to the window application
validate or not depending on value in another field
ygreiu fhg4yg
Evaluation timing
questiion about using <All> in a combobox
Suming Data in a Calculeted Control
Running A2003 in A2007 runtime
HELP PLEASE: develop a custom screener
hide label\combo box depending on option group selection
Absolutely Crazy Error
Create a button in a form to email a report
Re: How can I compare the column names from 2 tables and output them?
Certain Form load according to combo box value on currnet form
opening a popup from subform
Re: subform datasheet: one field does not show the values
RE: Look up data from a table in a text box
How to do ceiling in Access
Re: Look up data from a table in a text box
What's wrong w/ this SQL stmt?
Selecting varying number of chars in a textbox
Re: Create a new field with order number and their total orders...
Using a Combo Box for Filtering a Continous Form
Kill Focus on Subform
Pulling data into a form and making it save
Duplicate Data
PLEASE HELP: Design a Student Screener in forms module
Re: Problem with form serial number
Export to Excel Problem for One User
Use of Me in function
Changing data in Before Update
Validate form data before saving record?
calculating time help
Re: Another string manipulation question
Understanding Timer Pause Code
Space
How to import data from Excel that has password protected shee?
Data look up
error referencing a subform control
Input data check
Display problem on the SubForm
Open form with specific record, but other records accessible
Typing single letter into Combobox brings entire field
How do I save data on a form to my database?
Could somebody please tell me what this means.
Dynamic array
RecordsetClone on a subform
preventing duplicates but not totally blocking
Dcount Error Msg
Controlling Navigation Pane from a form
Hyperlink Coding (2000 vs. 2003)
Re: Frustrated with Form/Subform
Connect to Excel file to import data
Filling More than one field a combobox selection
RE: subform
Check Records After Update
Select all
Filter combo box based on another unrelated combo box
RE: Referencing a Control on Another Form
Re: Trouble calculating dates
Re: Trouble calculating dates
Re: Trouble calculating dates
Change Required Field Property in Table
synchronize my 2 combo boxes
Re: Open Table with Button on form
Re: Open Table with Button on form
displaying messages in the Status bar with the Status command
drag and drop with recount order
Adding "If Statement" with DSum
FollowHyperlink no longer working
textbox and combobox
Calculating Dates:
rollback combobox to 'BeforeUpdate' value
Access report design
RE: Open form - menu
Format a dialogue box to act like a password format "****"
vb code for 30 day trial limit
Need to change NULL to Space in Form
Re: using tab control
Adding a blank row, or "All" to top of Combobox list
Re: using tab control
Code working in 2K3, but not 2K7
Re: Validation of Image Path
Funky Syntax Error
Access 2K7 - Showing TIF files in a form via VBA code
Temporary recordsets
crosstab query question
like * problem
syntax for default value
Controls Lock/UnLock Password To Prompt only when UnLocking
Blinking labels are nice, but you never want them vanish into thin air, or?
Pass option box selection to combo box query criteria
IIf question
RE: Help with creating a model serial number
Re: Sequential Numbering
Rename Message Box
User-Defined type not defined
hello
Re: subform datasheet question
RE: Help with creating a model serial number
Issue creating sql authentication odbc system dsn
Adding to Table from Drop Down Box
Tab Form Coding
Email subform contents from main form
No crrent record with empty subform
Re: Help with syntax.
RE: Help with syntax.
Conditional Selections based on a Field
Problem displaying a form that runs queries
Re: I need help with opening a help file
Re: Help with Update Query
WHERE Condition with NULL
Returning variables from external form
Re: Sequential Numbering
UPDATE Table with multiple textboxes
Alternative for MS Excel VLOOKUP function in MS Access 2003 Form..
new messenger
Filtering a Form
Change paths to linked external data
Query Form
Missing Operator
SELECT FROM Query name
could not update;currenty locked
Detecting a Character
Re: Totals in main form
Add New Record / Make Existing Records Read Only
Geting travel distance from a map - add-in
Re: Searching Record
Opening Another Access Database onClick
Re: Detail in form goes blank
Unbound Form or Holding Table for Payment Section
VBA Code Written Once For All My Forms
Preparing a Access Database for a Website
Concatenation
Step Through Code if Private Sub
incorrect null value in combobox
Free Entertainment!
Code not giving the correct results
Re: Quick check with a second form
RE: Quick check with a second form
RE: Increase size on continuous forms to fit widescreen
subforms
Can I still use check boxes?
hey
RE: New MsgBox Code
How can I allow hyphen (or dash) in this validation rule?
Basic INSERT question
VBA sort code DESCENDING
Pagination on a Continuous Form
Parent.RecordSource in a popup
Access user
How Can You Force a Particular Popup Form Height and Width?
Make checkboxes invisibile based on combo box selection
FormErr 2473 0* expression On Open you entered
Why Bookmark and RecordsetClone to return to record?
Table Locking Problems
Customizing a Popup Form as a Message Box
Display Table Name
Using VBA to automatically add a new date to my table?
SQL Statement
Using one button to open two different forms
DAO and Table Locking
I am using VBA, how do you test for new record in a form
Reference a form
Opening a new record form but allowing searches
Using SQL Query Code in Form Module to Return Record Count
Multi fields search form
help with allen brownes Lock bound controls
change query criteria dynamically with value from a 2nd form
RE: SQL statement not working
Re: SQL statement not working
Which event?
Hyperlinks to pdfs and word documents are not working
Select statement
Date Picker issue
Enable control/field if in Add New Record page/form
Wrong data is presented after query
Re: Timer Event
Re: Page-Index of a Tab-Control from a SubForm
Re: Page-Index of a Tab-Control from a SubForm
Right justified field displays left justified
Re: Using DLookUp as the default value of a Forms ComboBox
Ensure correct date sequence
using VBA to set a keyboard option setting
Exit button
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8
oh...my...God...I'm having my day with this crap...
Using For...Next with Controls
Conditionally hide columns in Access 2003 Code
Windows 7
DLookup Issue
ID Pickup
RE: Using DLookUp as the default value of a Forms ComboBox
subform in subform
field not by that name
working hours between two dates
Student count for Class Registration
Error Message "Cannot apply filter on one or more fields specified
RE: REquery Subform
2 combo boxes
Re: Bookmark not working on subform
recordset clone
Checking the subform and changing the link on the fly
problem with Like "*" & ([Forms]![Main]![txt_exis_pt_name]) & "*"
Using one command button to open one of two forms
InputBox with calendar
Query Source for Text Box
How to calculate diffrence between two dates
Recognising the user switch between Form view and Data sheet view
How to Add Field with Index
SQL WHERE help
How do I get rid of this error message?
Use an Access form in Excel
Getting all records with same name passed from a textbox
subform default values
Export Report based on Filter
RE: How to program Subform as select list
Close Event for Database (?)
How to detect navigation
Close Event for the Database (?)
"autonumber" based on subset of "autonumber" field
update syntax error
GrandTotal based on fields in two separate subforms...
Calendar
check if form loaded and control on subform blank
Clone Code Complication
NoMatch now throws error
Mouse Move response based on combo box value
Copy 2 fields from subform into new form
Simplifying a WHERE clause
Sum of multiple boxes
Combo Box Data Row Source
Auto populate fields in new form
Continuous form / sequential numbering
Report Can Grow causing Blank Pages
CAPS
Duplicating records from one table to itself
Check Box - Need "Yes" value to return 1 to linked table
Date add Criteria on Continuous Form
Looking up a code on a Form
Opening images in another program on click?
RE: Primary Key that Contains Number as a String & starting with zero
Re: Command button on got focus not working
Re: Access Form Field filepath to external picture code