Microsoft Access Form Coding [Archive] - Page 4

Code no longer works
Re: loading subforms in tab control
filtering a form
Find prev record on other requeried form
Assistance with Subform Synching
Require a field in search form
RE: Equipment List In Tree View
Tabbed form help
How to access an instance of a form in forms collection
Dynamcially change sort order on continuous form
How to stop receiving e-mails from this group?
How sort recordsets with fallback tiebreak fields
How do i search a subform from the Mainform?
Subform filter
Re: How to select an item in a listbox?
Re: How to select an item in a listbox?
how do i get records to append to multiple tables
Alphanumeric "autonumber"
Object Missing from Ribbon
Re: Don't reset the counter
Keeping track of which listbox has focus: Best approach question
View all – undo combo box filter
Repost: Will not save until ESC or Undo
Datalabels on Pivotchart
One form, two tables UPDATE help?
Report based on a filtered form
Re: Check to see whether a table contains a set of fields already
Error 429 ActiveX and DAO360.dll
Re: Accessing a new field
Check to see whether a table contains a set of fields already
RE: Accessing a new field
Accessing a new field
DoCmd.ApplyFilter problem
Null Field to Interupt Closing
Cannot use copy record button on form with lookup box
Adding and Selecting "All" to Combo Box???
tabcontrol page caption
VB Code won't run
Combo Box Formatting
#Name? problem
#Name? in a report
Link subform with main form
Docmd.Applyfilter
Error: You tried to assign a null value...
Complex coding question re: recordset
Re: DB times out
Conditional Formatting in Forms
loading subforms in tab control
Me.NewRecord and Me.Dirty
Opening up a file on click
Problem with Disabling a Cmd Button Based on Another field in the
Record is deleted error when inserting into a table
subform used for changing mainform record
Check for empty fields
Referring to access query from mappoint control on form
Continuous subform behavior
List Box Selection
Count Records for this week, this month, this quarter, this year
Deleting record on a form
OutputTo Excel (A3K)
Single parent form contains multiple instances of the same subform
clearing the values of all the controls in a form
I am using an expression in Access to obtain a year value.
Unpredicatable BeforeUpdate event
Date Time issue
Access 2007: Escape Out of Compacting Corrupts Database - Database1.zip (0/1)
User Login Filter
Code to add entry into Combo Box
Export table and form definitions only
Display Data by reference
Sort rows in a sub-form
Re: Error Handling not working properly
Add primary key dynamically to a subform within subform from the
Cmdbuttons to download
Calculate total amount on continuous form line in sub-form
Synchronized Combo Box Not Working
Masking - Form Password
Cannot leave and save current record when using SetFocus
don't want combo box to be empty
intercepting key from keyboard and rejecting it completely
Using the primary key in an autonumber
Subform Search Function
Question about finding specific record on a Form linked to a table
Re: DoCmd.ApplyFilter generates Parameter prompt
DoCmd.ApplyFilter generates Parameter prompt
toggle button nightmare
cbo box sql help req'd
DoCmd.RunSQL combobox column
docmd.accmddeleterecord not working
RE: Reading XLS 20th row to 39th rows and column 5 to column10
Drag a file(path) from an Access Form into another app?
RQuestion on Form Record Selector Bar
Command Find
Move Files after import
Can VBA change Split Form Size?
Can VBA change Split Form Size?
Application.FileSearch 2007 Reference
tab control question
How To: Ribbons
Text Box Calculation Formula
find existence of autotext entries
images with word automation
Re: trying to set up array - get type mismatch
Open a NotePad
Re: trying to set up array - get type mismatch
Re: trying to set up array - get type mismatch
Help with run-time error '2424' and '3265'
Will not save until ESC or Undo
Multiple conditions on combo box to show different forms
From-subform
Newbee needs help Combo Box access 2007
Renaming a linked Word document from Access
Multi Select List Not Working
Linked lists defaults
Code Disappearing
Re: two linked subforms on an unbound main form
FileCopy procedure creating corruption
how do i make a changed label caption stick
Passing a Control Value from a Form to a Query
Set Querydef SQL to Null (Open an empty query editor)
can I make access remember a last unbound number
fso replacement
Listbox execute SQL error
remove from list
Access2007 - drag and drop into a form
Call Shell wait before finish
Update a combobox on another form
Re: Display Search Results in Form
Filtered Records as source for appending records to a table
How to detect when user switches between open forms?
Itemsselected run time error
Passing Values between forms
How to make Access 2007 Navigation pane invisible?
Access 2007 Switchboard buttons stop working
Grouping
Not in list where cbo is null ie. tab through
Interumping continuous form
Change Tab Without changing focus
Re: change cmdButton if IsNll
Headers and stuff
Re: Tennis calendar creation
Modal = Yes Locks the Record
Show Access Print Dialog to Ask for a Printer
How do I show Microsoft Access Print Dialog
Re: Change Backcolor for the selected line
Query List
A couple of (hopefully) quick questions
Synchronize combo boxes
Limiting Field Input to 1/8 Increments
when I close my splash screen the switchboard fails to open
HELP - Selet Statement not working, Run-time error '3075'
Cascading Comboxes
Select record in a listbox
Generate product codes on the fly using DMAX or Count.
Re: return to first button click event after another button click event
SetFocus Quirk
Changing recordset based on multiple checkboxes
Referring to control on subform
Requery and return to last record on continuous form error
Embedded double-quotes in SQL
TransferDatabase method
Help with coding
Using an Object from a Current form for Criteria in a Query
Re: Copy one field in two or more fields
Subform/Form Referencing
Subform action not functioning - OnDblClick
Table uses a select statement as value to populate subform data
Re: Copy one field in two or more fields
Hiding Control BAsed on Check Box
Subform Visiblity Access 2003
RE: How to pass multiple Fields to another Form?
Programmable Data Entry
Event for moving to another record?
Date comparisons on data entry
Block Sequence Nos
Modify Code on Form
Looking for the Name of a Popup Shortcut Menu
CmdButton, Listbox and MsgBox in a Form
Simple loop question
Re: use of acCmdDelete & acCmdDeleteRecord
How to pass multiple Fields to new Form
DateAdd not working correctly. Need fast help!!
DatePart function
Checkbox = Not [intField]
Inches and feet symbols
Re: Decimal places will not display
Re: Create new tablefield and fill with current date
Date formats
Recalc & conditional formatting
custom error
number of Full Months between dates & partial Days calculation
Re: changing a record source
Count and Pad String
First Letter
Report Menu - Multi select Listbox Filter?
RE: Code Question
RE: Status tracker box
Code Question
RE: Object Identification
RE: Refresh Subform Current Record?
Shorten Width of Message Box
Refresh Subform Current Record?
Copy Record Button Function
RE: Help Transposing Columns into rows in access
CancelEvent
Dropdown recordsource on childform of continuous parent?
Requery subform control from Main form
Buttons and listbox to search in a form
Sort by 2 fields
Copy Record Button Function
save record on continuous form
Update ID to another table
Invalid settings for property
Query base on list box
Combo Box & Report Questions
Creating a QM form that calculates scores?
incrementing key field
Re: Use the Windows task scheduler to run a report
Summing on 3 different values
Re: Object Events for Object you Created
Re: Create Combo Box to Find a Record
balance B/F in access
DIR function stopped working on Vista
Charts in 2007 - Where are the new charts from Office 2007?
Enter value if certain criterias are met...
Re: Where to go from here w/ MS Access and Web development ?
Opening a PivotChart from switchboard
RE: Obtaining File Path
Re: Obtaining File Path
Re: Filling a combo box at form start
Can use some help w/ Internet / Object Close
How to code a "Like" query on a form
Same button code doesn’t work twice
Setting a value to a different field based on current field
RE: shell command
shell command
Add a combo box
How to list tables to open them
Help on help!
Allen Browne - Find as you type - Can I print the results
Proper Syntax Required
Re: Open Form with Current Record
Click button enter current time
Re: Validate visible fields only.
Update a value in the table upon clicking a button
OpenForm to show Last n Records
Combobox Value Will Not Change - Until I Right Click?
Resizing the Details Section Height and Width.
intermittent error message when editing data in a form
Re: RETRIEVING DATA FROM 1 FORM FIELD UPON ACTIVATING CHECK BOX
RETRIEVING DATA FROM 1 FORM FIELD UPON ACTIVATING CHECK BOX
Form set the Visibility of a Label in a Report?
RE: Type Mismatch error
RE: retrive the values if the patient already exist
Re: Syntax Help
Custom toolbar in advanced filter query window
Re: Temporary Form with 2 Sub form Update Main Form And its Sub form ?
is there a Dlookup to get entire record or multiple fields ??
Re: SubForm
Re: SubForm
RE: retrive the values if the patient already exist
Filtering a multiple item form
RE: Switching a Label on/off in a Report via a Form?
sorts query while including <all> at top of list
How to select a description in a combo box but return a ID value
Re: DLookup Path problem
Column order using OutputTo to Excel spreadsheet
How Can You Make Sure Users Save Subform Records Correctly?
Re: extract multiple numbers from string
Dropdowns And Dims
Re: Need A code for Visible/Hide base on Combo Box
Sub requery + other question
Re: Receive email replies in Access
Re: Test for a value on a subform
Re: Text box that updates a control IF it is EMPTY or Has Text
VBA to page down in a subform
File Attachment Help !
column named "group" causes problems with new SQLServer
using / register outlook view control
Using Access Forms On the Web
VBA for NotInList return to old record or BeforeUpdate value
Date based coding
Finding the first DAY of the week of a given week.
general conflict question
Re: Receive email replies in Access
Data to outlook calander
Copying Forms From One Database to Another and Back Changes Them
Format Memo field
Select Email Adress using Check Box
Comparing text and number fields
Notes table and IndirectDataInput / Date stamp in Memo field
dynamic combo box on subform- show full list Box on main form
After Update Save
Auto store date created & updated, EmpId created by and Updated by
After form Update event
Formatting a date different from the date options available
Problem with vba directory function
Clear All filters - not working right?
Spell Check Help
Re: Programatically Change Recordsource SQL of a form
RE: dropdown problem
Form save button
incorrect report from parent/child subform.
Cascade combo box help!
Images load from folder
Subforms won't refresh after new record
user notification
Date/Time stamp in Memo Field
VBA: How can I get the type of the control programatically?
find duplicate in last 100 records
OnChange combo box
Re: Help with Event formatting?
Form filter problem
Values from combobox = txtbox
Duplicate in Last 100 Records
Disable buttons while "calculating..."
Duplicate in last 100 Orders
Login Help!
Enable/Disable Text Fields
Visible control based on other inputs
Locked fields
Calculate Gestational Age based on months and weeks
Changing RecordSource Causes A Reload of Sub Form Destroying References
Subforms won't refresh after new record
New records don't display correctly in subforms after save.
Programmatically change Textbx/ComboBx/CheckBx Name in Datasheet V
Where to Hide Page in Tab Control
Controling two forms in tandem
ActiveX Control: Calendar
SendObject problem
RE: Refreshing the form / cmd button to effect underlying changes
Form Runs Non-Existing Function
Access Runs Non-Existing Function
Type mismatch in SelStart property datatype
How do I copy one table to another within a form
Why is RecordCount is 1 if no rcds meet SQL stmt's criteria?
Method 'CopyFromRecordset' error
Run time error '2001' You cancelled the previous operation
Field blanks after exit function
query or SQL string
Re: new vs. old record
Fields blanks after exit function
Form Not Opening Right
Multiple Criteria
Retrieve Full Path of Attachment in Attachment Field
Can't make sense of this
Character Map Help
open form during recordset update
Open a Form depending on Value in Lookup List
crack ecm2001 titanium torrent rapidshare download free Ak(PPZO@?K
Re-using a "Door Prize No" - Part two of the questions
Record Counts
Locking a combo box
Richtext in Access 2007 ADP
Do/Loop Dilemma
Multiple conditions one one textfield?
Automatically insert date when other field is true?
Pop Up Forms Linking to Main Form for Data Entry and Update
User Progress Box
RE: Coding for disabling a text box on a form
Storing Calculated Controls
Altering trajectory from a control
Problem with using function in a drop down query of a row source
Problem with code to catch duplicate Primay Key
Creating queries on the fly (Form not working)
RE: Need to Hard Code in Combo Boxes Instead of using a lookup table
Re: Need to Hard Code in Combo Boxes Instead of using a lookup table
How to move a control?
AfterUpdate cbo box from query based on other field
Pop-Up Phenomenon
Validation across Tables
Graying out few items in access combo box
RE: Highlight/color Whole Record When Condition is Met
Giving a value to the check box
Duplicate in last 100 records
Passing Dates To A Between Operator
formatting help needed
concatenating problem
Unlock text box for new record entry
Trouble with audit function
What is better ?
Re: acSaveRecord issue and required fields
How to insert code in a dropdown option of a toolbar?
Help Linking Subform and Form
Creating "key" fields when met, unlock the next step...
Images in MSFlexGrid
Re: Access 2000
Access 2000
Re: Add Record from Event Procedure
SubForm visible only when condition meet
Re: Insert Into 2 tables from a form & subform
suppress 12:00 time
Re: "The value in the field or record violates the validation..."
Dcount type of function on a form
multiple subforms linking
Three state bool
Syntax error
Return "No Matching Records"
Populating Combo Box With DB Objects
Transfer Spreadsheet Issue
set reference with VBA
Force Update of Subform Data
Combo Question
Calendar 12 AfterUpdate Function Missing
How do I select hidden fields
loop thru records to create a union query
Automatically update a text field when any entry changed
Afterupdate requery
Hiding a Form when a Report Runs
Tab out of subform
Can I hide the line between columns in a list box
Clicking maniacs…
Continuous form set focus
Run time question
setting form's recordset property
Continuous form refresh/requery
Docmd.SendObject
afterupdate requery on a tabcontrol
Record not saving correctly
Disable button
RE: Concentate combo box selection from a list to a field
Form Code to update the table
My Folder
Re: form filter
Populate field based on previous entry
Re: Tabbing creates new record, which I don't want
Re: DLookUp Issue
Code to Give the Italic Font only to selected tex
will using MSSQL2005 express as backend overcome danger of wificonnection to backen?
Popup Reports
Cumulative Sum Query
Form Background Color
Which Form Event
code wont recognizie that 10 is greater than 3
combo box - bound column
dsum error message
Using button in Access Form to search text field
Multiple fields in the CC argument
Message after duplicate a record
Recalculate fields in subform from Main form
deleting combo box entry in table
snapshot viewer ocx
Re: insert values into table from ACCESS FORM
Appending Codes from a list.
Locking a record without using the new record feature.
Re: List Box Deselect Issue
function assistance
Cursor Status
ACC2000: Switch report from design view to preview through VBA
Ms Access got an error and quit
populate form with a recordset
Sort by ascending on event
Sort by Ascending on button click
tolerance place counting
Access Not Responding when VBA Code Run
Lock a field after data entry so value cannot be changed
making selection group
Call a Public Sub-routine on a Sub-sub-form
macro help needed
Report Preview is hidden behing the Form
referring to Subform Total in main form
Duplicate sub form last record
Comboc criteria...Open and display combobox 2
OpenReport in a form's load event.
How to set several events to fire the same procedure?
.Filter = badString
Refresh/Requery combobox2 on combobox1 change
Combo Box Hell or Why can't I get this code to work?
right mouse click event
Re: Syntax for Referring to a subform
Re: Syntax for Referring to a subform
Syntax for Referring to a subform
Re: Combo Box hell or why do I get and error when I do this?
Combo Box hell or why do I get and error when I do this?
Format for MAC Address
Update Events in Split Database?
Cancelling an email using SendObject
Read only
What is best way to re-use an account number?
Pulling ALL records in subform into VBA drafted email
Re: Switchboard filter
ListBox Question
How to use Seek vs FindFirst
Form get User defined type not defined and stops
DoCmd.SendObject Fails
Rolling dates from text field
select value form combo box on a web page
Changing color on the screen
changing value of combo.column(1)
Error in string criteria / Wildcard
Data Type Mismatch
How to reference the Access' Masked Edit control from another appl
Dcount to create a new record in another table base on a record cr
How do I change the year 89 to 1989 in txt box.
You Cancelled the previous Operation 2001
limiting number of records in form
Form Navigation Bar
DlookUP...Dcount...
Activate cmdBotton on another Form
Once date is entered into a field lock the field for read only
Strange issue after loading latest data
Combo Box Synchronizing Problem
Transferring Control From One Database To Another Using Access 2007 Runtime
Drop field from table
Re: Double Click a List Item to Open an Associated File
Bypass code
Syntax yet again
Previous record value
Synchronised ComboBox Issues - Very Stuck, Please Help!!!
Visibility same as previous record
Check for value in List Box
Invalid Use of Null
Invalid Use of Null
Fields disappear on Access Form
Export to Excel setting field types
Object invalid or no longer set error
NotInList Firing Problem
Untangling MS Template
filter form with combo box using Like operator
MSAccess 2000 -- Error 91 problem
Unbound Form needing to add new record
Form opens fine on computer 1, opens hidden on computer 2
Filter for years and keywords
SetFocus Problem
Linked SubForm Issues - cannot edit in subform or move from main r
Create Table from a Form
Requery Parameter Problem
DblClick Event
How to create code
Looping between a MainForm and a Linked SubForm
Re: Merging data from multiple Tables to one table
Re: Merging data from multiple Tables to one table
Hide field 2 if filed 1 is null
capturing the size of the mdb file with VBA
Looking for *= in queries?
Access 2003 form problem
Before Update vs After Update
stLinkCriteria
On Current update issue
fomr opens to wrong record
Problem with text box
Cancel a listbox selection
Re: How to Open Excel to a specific file via Access Command Button?
Re: How to Open Report to Current Record? (Access03)
2003 to 2007 porting, functions not found.
RE: Exact match for Non numerical field using If Dcount PROBLEMS
Re: Exact match for Non numerical field using If Dcount PROBLEMS
Re: Exact match for Non numerical field using If Dcount PROBLEMS
add SQL query to report or otherwise enable to produce a report fr
Porting 2003 to 2007, Calendar helper
Porting fro 2003 to 2007 - 'Mouse wheel
InputParameter - compatibility 2003 - 2007 issue
Option Base 1
Cascading combo boxes
Cascading combo boxes
Re: Export troubleshooting
IsDate
Show/Hide custom Group in Navigation Pane Access 2007
DLookup?
Update field in related table
Combo Display Formatting
Need calendar form to display holidays
Populating the Criteria section of a query.?
Using a Where Filter to Open a form
sendto multiple addresses
HELP: Issue when exporting hyperlinked field from access to word/e
Vista problem?
Re: Double Control for Names?
Re: Double Control for Names?
RE: Double Control for Names?
MS 2007 template Error Message
Compile Error
Subforms Subform
Porting from 2003 to 2007
lock records after update query
Access 2003 and 2007 installation fight
Modified Allenbrowne Search Form displays error
36 KewaSa.com DDL Torrents
If and Msgbox
List box issue in Access 97
Re: Update Main form from continuous subform
Error on modified Allenbrowne SearchForm
Subform autoloading
Subforms
formatting help
fDialog use with form to export data
HELP: Error! No document variable supplied
After update find record on subform
RE: Export troubleshooting
going from A2K to Office 2007
Subform DataEntry Issue
Reports won't open - Default Printer is selected!
puzzling user request
make the value of one control dependent on another
Macro warnings
"Can't find project or library" on user defined variables. 2003 -
On Open code to find record
refresh report
Problems with filtering a subform
Time
Continuous forms coding suggestions needed.
how to double click a list box item to add to subform
Form.Detail DO or DONT allow edits to the controls (text boxes)
form to create record and update other records
subform totals to popform
Label based on drop-down box selection
Re: Radio Button UNDO
Referencing Subform 2 from Subform 1
After Converting to 2007
Sort certain records to top of list
Record lock error sent to log
Setting new lines in textbox
Compile Error
Record in one record matches record in another table
Weird Access Form & Subform behavior when linking to SQL Server 20
add but not edit combo box
HELP: Exporting from Access form to Word template and saveas word
Re: using lookup table in a form
Viewing variables in Debug
Command button to open report
Chart inside a form
Calculated Field
Disable subform textboxes
Not In List
Comand Button
Dlookup…DoCmd.OpenForm..or?
Re: specifying a field in a table in a Tab on a Parent form
Calculating the primary key
Control Type Property acComboBox
Code Help
Creating menu/submenus using Forms
Checking for zero is not working
bang(!) information
time calculations
Form needs to update two tables then ...
dlookup using variable as criteria
Can you auto write AddItem VBA code to a form to populate a Combo
Dynamically turn on debug
Modifying/Appending Record Between Subforms
diff colors for diff values in combobox
Using combo box when adding records to continuous form
Form opening to new record
Update command button
getting the File System Object to run File Save As instead of just File Save
Auto Dialer
Check box on a subform
Relink tables
Custom Ribbon (Splitform)
Enter data on an subform datasheet and link this to the main form.
Update subform's data from main form button -- A2007
re run query using new combo box selection
parse return string into table, separate records
Time Delay to Print Report
Enter a function - Very basic help
highlighting
Access 2007 - Can't close form; run-time error 2450
need coding for unique default value issue...
list box
Before Update Cancel = True
Parameters
72 Opinion Dsiconsolas.com
Redirecting after click on a query subform
Label's Caption Issue
Re: Remove item from box when selected
Access change My Default Printer for All the Reports
Display Message After Form is Visible
Invalid Argument
Filter subform with combo box on main form
Combo - If Not in list Open a Form
Help Help trying to convert from 2003 to 2007
Re: dlookup vs. sql query
Subform Attempting to Create Duplicate KeyID
get table name for field in form based on query
How to Pass value selected in Option Group to Form in OpenArgs?
Access to Word 2003 Mailmerge
two issues
RE: Whats the best method to take?
add one to a duplicated record that checks to see if one exists
Decimal point dissappears on form
Open Form / If not / MsgBox
3rd grade code returns extra zero instead of decimal or hides deci
Extract table name through form based on query
Subform Causing Duplicate KeyIDs
Setting DefaultValue
VBA -- SQL
how to se sendkeys
two issues
Allow only 1 Addition
Filtered Drop Down Menu Based on Previous Drop Down Selection
Problem with runSQL Update
How to Pass Option Group info to OpenArgs in OpenForm method?
Option group auto open - Repost Need Help Soon, Please-thanks!
How can I use Dongle to protect DB
After Update Puzzle
Changing Column Heads in Listbox
Help with a listbox
Re: How to send Option Group Info to New Form OpenArgs?
Form for payments - Access 2003
Query - Running Total Help
Order form
build the where clause...
DLookup and Duplicate Values
Compare Fields in Subform then format
Open form on file open
Text Box visibility Conditional on Date
Option Group - Blank Choice
SQL Syntax Error
The code disappeared from form!
One form or another depending on criteria
Code difference for single form versus continuous form
Close one form when another record is selected on another form.
Data Entry property keeps setting to False
Filtering subform not working
Follow up to prior posting (execution speed)
revert back to last value
Problem when opening another database
Highlight Search Result
DoCmd. Openform Error Message IF no records found...not getting it
I am not "getting" it.....DoCmd. OpenForm
Creating the Primary Key
A2007 - OLE vs. Attachements
Re: Form timer puzzle
adding and removing subforms from subform controls
Requery table from form
Navigating to another form
Subform Aborting
count in control in report footer on parent report
Re: Print Report w/o printer window
Re: Print Report w/o printer window
Drop Down changes background color
Form Filters causing Access Error and closes
Search form
Chaning Forms
Search Form Parameter Not Working
calculate after first calculation
Which Form Event should I use?
Textbox Control
RE: Combo Box
ado issue
Syntax (Missing Operator) in Query Expr ....
Toggle button control opening forms
missing items - but there - in listbox
can't get sendobject to open email
"no records" message for append query
Auto update datafield
using Shell to open an MS Excel file and run a macro
Re: Dropdown box
Values from textbox in criteria of query for report
Office DevCon in Australia
Changing a Text Box Control to a Combo Box Control