Microsoft Access Form Coding [Archive] - Page 29

Form will not display decimal Places
nextline in combo label
Relink Table
Duplicates custom error Msgbox with lookup
Rolodex
Compile error
The record source '<source_name>' specified on this form or report...
Leban's Tooltip on Continuous Form
Using a Module-level recordset as a recordsource
Adding on a form: 5+1 = 51 ????
Automatically create action item
edit button control subform and main form
Loop Problem
Sorting subform from cmdbtn on main form
Enter Parameter Value error when opening form
Re: Strategy with Access vs SQL
process for creating a subform
Can't get requery to work
Add text string to existing field by clicking button
On Open Form Gives Error Msg
Missing Operator in query
On click button command
Determine If a Date Falls on a Weekend or on a Holiday in Access 2003
MS Access Listbox won't synch
tab stop, subforms, and focus
Re: Strategy with Access vs SQL
Re: newbie with adodb
Re: Disable/enable menu acording to the login
Re: Creating a custom field list
Reading/Writing Data to a Text File using VBA
Invalid Argument when trying to print current record.
Re: Code stops running and opens vba window without any error
Re: Creating a custom field list
setting the vertical position of a tabular subform when the main form opens
Re: what should I do with the label is still there?
yes/no report help
Printer won't switch
Re: Save record question
Re: Can you disable the navigation buttons based on which tab you are
self updating form field (w/ typo corrections)
subform repositions unexpectedly
on open do to new record
Transactional processing with data-bound MS Access forms - how?
Form close error
Getting a form value
Please help - find function fails in spreadsheet control on the access form
Disable toolbars
self updating form field
Open New Record in Form B with Data from Form A
Re: Deleting a form programmatically
Linked Table Manager
Problem with RecordsetClone when form has filter property set
Detect focus on subform?
How to reference value from a table
Redundancy
Autofill/Copy data from previous record by clicking a button on a form
HTML Help files in Access my TOC displays but not page ? HELP !??
Pass a variable from one form to another
update cancelupdate
Re: Won't exit loop
Multiple Selection to Run Query
Strange value from BeforeUpdate code
Category and subcategory in the same combobox?
Re: Adding Value of Several Fields to Create a Totals Field
login table and login form
Filtering bound field content
Re: Disable a button
display date then new line
Re: Disable a button
Re: Disable a button
Re: nz function
Re: nz function
Converting from Access to MS SQL Server
confirm saving
Code line only works iwth a break point added to it?! - Very Stran
Checkboxes in a search form and VBA code
Re: Problem with Send Object
Re: Entering Dates in a Text field on a Form
Popup and Synchronizing
Re: Frontpage 2002 Forms - sending to different email address
no files found error
subform code question / additional advice requested
Microsoft Access 10.0 Object Library
import excel files
Re: textbox - make required
Re: textbox - make required
Minimize Open Application from within MS Access?
Re: Running event after AutoNumber is created
won't allow new records in a subform
using bound form
Re: DateDiff
ComboBox list values
Logo in report header
Re: Help with changing code for adding records on subform
Re: For Douglas about ListBox
Re: Help with changing code for adding records on subform
Show Last Record
Need help with date syntax error
animated gif
Using a desktop shortcut to various destinations
Re: Referencing Parent Form from Sub Form & SQL Union Qry Question
RE: DoCmd.RunCommand acCmdFind
works on some of my computers!!!
Sub folders wtih package wizard - developer
Large Application - Many Tables
RECORDSET
inStr evaluates to -1 causing export problem
Re: Combo Box Problem
Subform data not saving when focus moves to parent
OnError
Re: Add new records based on previous values
Re: Error Message Openning Startup Form in Northwind mdb
OLEObject
DoCmd.SendObject
Re: Date Validation/entry
Re: Date/Time Stamp
How can I email a hyperlink to a specific form & record?
Faxing through Outlook 2003 on a Server 2003 machine via VBA
Form On_Click Event
Design question
Email Report
Syntax error
InfoPath from MS Access
Is This Good?
Form sync via custom events independent of order of form opening
AlphaTabs to Filter form
linking record questions
Calculating due dates
Assigning a long value to TextBox strips first 256 chars?
ListBox in SubForm
whats the difference in this
Sorting A Database Using a Combo Box
INSERT INTO problem trying to use general date
Leban's "string lengths in twips"
formatting of text displayed in combo box
String length in twips
MsgBox position
Application.Printer
Option Base 1
Creating my own custom Help for application?
>> Printer Port list
Help populatin an Dynamic array with a TextBox
RunTime Error 5
OLE object
Passing a control name to a function
Linking unbound Boxes?
Error Checking not working
RE: Delete Button
year-only format
Unbound Combo Boxes go Null for no reason
HOW DO I RETRIEVE AN OLD COPY OF AN EXCEL FILE BEFORE LAST BACKUP
How to send e-mail to selected individual in listbox
Change row source in vba, and later revert to original
Small NotInList issue...
"#Name?" Error for only one cell of a record in a query? PLEASE HELP!
Object doesn't support this property or method
combo box missing values
Re: Command Button to Search a Field
Re: Problem with FindRecord
Does this code need improvement?
Can't get rid of ~sq_ files in list box
Re: Code not working
Re: a simple Do...Loop question
RE: use current record to create a record in antoher form
Re: Calculating Elapsed Time > Subtract 30 minutes?
pass values from Access to Word doc
RE: requery in datasheet view PLEASE HELP
Re: counting checkboxes in the table
Security-Same Data Same Time
Re: InputBox Cancel property
Using Mail.Send from Access to Outlook 2003 with multiple recipients.
Re: Selstart results in Overflow error
Creating Subforms that relate to information in the current table
Re: dlookup question
Re: display yes/no value as a check in listbox
Select
Visual Basic 6 help urgently needed
Re: Disabling Tab Controls
BackColor change
A97 Tab Forms - Colour Change
modifying Data type
RE: Need to add a new record with a next "free" number
modifying Data type
update query in form view
Re: Trapping Form Errors
Cannot update a disconnected (and then re-connected) ADO recordset bound to Access 2003 form
Re: What is the syntax to call a subform control?
Re: What is the syntax to call a subform control?
Change RowSource with VB
Re: Insert OLE Object Code
Re: Raise event in Access subform?
Re: Form Level Shortcut keys
Trigger with MDB
#Name? Error setting numeric default value
Cancel Error Message and resume
IIF Statement?
Updating only changed records
Unmatched Query Help Wanted
Different results to same query
Screen shots
Multiple combo boxes in subform
Hide a page from a tab control in a form and view page via a password
Auto expand memo field in continuous form
Basic IF statement question
Updating field based on info in control
Error message when opening form
check for null in listbox
Validation Rule
Double click on ComboBox
Subform datasheet - adding records
Decrement Number in table
add record problems
QueryDef multiple parameter
#Div/0! Message Driving me mad!!!
COUNT FILTERED REPORTS RECORDS
Coding one command button with two different commands or events.
combo box populate text boxes
Re: Visible control
Checking for entries in a table
filter form based on subform
Union query
#Error
Text Box
Which Event
How to inject a common field into reports & forms
Making viewed records read-only
Not sure if this can be done in access
Combo box problem
Fix so FindFirst works with Caps Lock On.
Txt box population of data based on input
Counting Records
Running sql from command button
Save parent form after transaction update
Question about Editing data & Locking Records
filter date
SQL inserting into a table
Error Previewing Report: No Current Record
BeforeUpdate Event with MsgBox
Help with export to excel
Merging Procedures
Buttons for Each Row in a form
Open Excel file - Simple Question I hope
Update record form help
Making form fields required
Access Main Screen
Oz's to 10th of a Lbs
Control Source/Record Source issue
Combo and Select Case filter not working
Navigating a tabbed form
date greater than text
Access to Excel 2000 Report Export with Code
Text update from form
Multi Select Names on a Form
buttons covered
Conditional format continuous form field
Time passed in months
Add code to close form
subform open to cbo value
Adding an option to shortcut menu
retrieving data from table into textboxes on form
Tab to subform will not work when adding new record
not in list event
Printing Carryover
Tab to control in subform - how???
Continuous form in continuous form
Which Property to Use
while typing value in filed show the user matching value in table
Unbound cbo Requery doesn't work
Problem with Dates
Limit No of records in subform
Filter Filter Filter
Order by
Filtering on a field in a table that the form is not based on
Datasheet Format color
Picture problem
FILTER REPORTS USING MULTIPLE CRITERIA
converting general date format data into short date format
Open Progran From Access
Field name expressions in a query
i need a brainstorm
Cancelling record
Checking version of Access
Filter REPORT using Checkboxes
Checking for new record
Counting of Filtered Records
Handling of ocx/dll in Access 2007
RUN TIME ERROR 2451
FILTER REPORT using FORM
Slider Control
dcount expression on subform
can't see new records on sub form
network error
Moving Info
Refer to subSubform
UPDATE NULL RECORD
counting records
Datasheet forecolor
filter list box with a combo box
Address book
DSUM not working for subdataform
Trasfering control to specific field
QueryDef Multiple Criteria
Concatenate elements of Combo Box to one string
Fancy Tooltips and .visible=false
Continuous subform conditional formatting
Initialize form fields
Decimal places in list boxes
report margin
Sound plays before form displays
Different results with opening form with docmd.
On Error GoTo Statements not working
can't retrieve value of Listbox control
Copying files
Opening a Form at a blank entry
cmd button visibility - dependant upon subform
strange error message
Filter not working
Navigation Button
Another Combobox filter
Vat and Zero Rated
Tab Width
tab control
Source code for directory search
passing record from one form to a subform of another form
OWC Spreadsheet Control on Userform
Open form btn with filter; create if no record exist??Help??
Handling incorrect number of variables passed into a function
Eligible date
Better way to count records
Changing View Size in the Design Mode
Error# 0
Access/VBA
Memo field truncating in form
Memo field truncating in form
How to disable a subform?
Image Preview
Trying to use Asterik (*) in sql
Filters
moving a main form and subform to a specific subform record
Output an Access Table or Query to Excel
continuous form records on subform
BorderType property on a diagonal Line (with "height")
Use * in SQL if Text Box is empty
Form vb syntax error on INSERT INTO
hyperlink fields
Error 91 (also in empty project)
how to use a date range to limit the results of a query
Required Field in a Form
layered controls on screen
Using TAB in Memo Field
Copying Data to a new Form
Change a graphic depending on the value in a field
Form footer equation
set focus help
Trouble with date format
Spell check in text box error
want to open Excel and Word document from Switchboard
Create filters for report based on list box
Alphabetical Buttons
GANATE 50 EUROS ,APURATE, SE DE LOS PRIMEROS
On Dirty
Cars NOT rented
insert header to report automatically
FILTER DATES
Slider Control A2003
display part of result
Output To Excel defaults to version 5-7/want Excel 10
adding record button
Error 400??
How do I get my info from second form to the first.
another setfocus 2110 question
Error: -2147467259
Binding a form to a disconnected recordset and making it capable to update such recordset
Get Table Field Value from Query
Spell Command
Code to Automatically Dial Modem Numbers & Log Results
Enter Time
Parameter Trappable Error Code?
filling field using bookmark method
Lets Think About Dates?
VBA Variable Won't Set
Error Msg
Sending attachment
Output To to output chart to xls
Colour Row in Continuous Form in Access 97
how to point to a field
Requerying a form after changes
F1 opens custom chm but minus the navigation pane
subform conditional formating
Selecting and storing the results of a multi-select list box
Date form and Report
For Douglas Steele
display the Lookup values
Delete subform records without deleting main form records
create records automatically
lookup trouble
Access report question
word in access report
How to code a button to EMAIL data?
Printing a Form in Data Entry mode
How to show a messagebox on null textbox or wrong data??
Tab Controls-4 subforms with the same record source?
On Delete Msg Box
Coulmn Headers
Re: Setting the Priority Number unique
Command button click initiating series of events . . .
Extracting Irregular Length String from Another Irregular Length String
Search for Text within Text
Place cursor at end!
Enable
Use of "IN" statement - easy question
Close command asking for criteria ...
Dlookup help
Re: Problems adding "All" to combo box
Continuous form problem
Sort listbox by drag and drop
Forms and Subforms
RE: Find Then Delete Table
Data not staying in form cbo
HELP with two queries
ACCESS (Query) to EXCEL
Public variables and input parameters
Stephen Lebans Month Calendar problem
Combo Box problem
Pause running code
How to open form for selected value??
How to open form for selected value??
image linked to a report
How to make this login form??
Vertical property - data not displaying
Trap Enter Key
RE: Searching Using a Combo Box
RANGE in ROWSOURCE, POSSIBLE?
disabling the Shift key
open form with record from other form
How do I write this SQL SELECT statement?
How do I do this??
Re: Repost: Calendar change needs to requery subform
"Set" command anomaly results in Null
Validation Code and Me.dirty
Enter records from one table to another using a form
Can't get Debug to work on "CBF" - code behind a form
Re: Custom Captions
create DSN not working
Update a form field from a subform's field?
After Update - Updating a different field
Issue with adding a new record to a bound subform
Passing multiple parameters to Stored Procedure
Perform Check on Data
Subform combo box visible issue
Selecting users from a form to print
help with select case and tab control with subforms
editing .txt with VBA - importing format question
Calendar change needs to requery subform
Simple Math Producing Errors
MSAccess in other countries
Command button Event procedure in Access 2007
What is wrong with this SQL
[address1].column(1): field info disappears when cycling records
Add/Edit
BETWEEN
Command button filter stops working when put in a subform
sql query
ACCESS ( or SQL * Server)back-end and PDA (IPAQ) front end in wireless network
error 2501 - openform cancelled
Data Access Page Auto Number
Form loading error
Delay the Call method.
Passing multiple parameters to Stored Procedure
When is 'Form_BeforeUpdate' triggered?
Using Record Selectors
Selecting ONLY the most recent record...
autofill Form
what is wrong with this code?
how to determine if a subform is loaded
Change caption - Datasheet Subform
Range
How to setup Progress Meter/Bar
Stop Macro in progress with cancel button
Find First alphabetic character
GetDesignerAddress() works one way but not the other, please help!
DLookup to populate textbox
Is form read-only?
Subform Add record
Numeric Combo Box Sort
pass message to another form
Launch Form only if certain fields are not null
How to use Hyperlink by coding
How to use Hyperling by coding ?
Error Occurs in different PC
IMPORTING Data from EXCEL file to existing ACCESS table
export text file in macro
Suppress popup on display of custom popup
Properties set in code don't stick
Syncronize subform with main form
Can't set value of controls in VBA code?
Preventing Duplicate Addresses
How to step through code
Binding a calculated check box
Binding a calculated check box
MS Access Newbie - Form Question
Why am I getting a run time error?
Lost Focus or On Deactivate
Test List Box
Problem updating one side of one-to-many relationship
open record based on search form
populate record base on another form
Changing a value on a parent form from values on a subform
Change AllowDatasheetView
Passing parameters before opening forms
Else without IF Help
How to requery a form?
Mail merge with a date range
Passing Autonumber to Linked Form
First letter to upper case
Display Last Record
"relating" records in subform to other than the parent form
Basing one ComboBox on Another in a Bound Form
Form - Primary & Foreign key
Unique value in query
F1 Help in form does not show content pane
highlight list
Combobox to autotab
How can I check a user-defined property in existence?
Check user
Check in Listbox
numbers not text
continuous form problem
Controls Flashon repaint
Refresh Tabbed Form with multiple subforms based on combo box on tab one.
Passing an autonumber field to the subform
odd behavior when form embedded in other form
Continuous Form With Subtotals
Update underlying table
Open Excel doc issues
Mutiple field search
Runtime Error 2024
Need a bit of Help!
Query by form in access 2003
Data Member or Object not found
totaling form
Recordset Help
Best way to devlopa favourite list
drop down boxes
DSum Problem
query two like tables
Updating a Form with a Subform
Checking all boxes on a form.
Popup indicating Success
How can I find out which rows have been selected in a datasheet view?
Record count results not consistent
File Search
Unknown error message
Hiding SubForm
Looking For Vacation and Sick Day Code Examples or Advice
Populating A Text Box
Do I need to code the text box?
Populate Text Box
Run Time error with Look up Box
listing the syntax of macro and a query
Search form
How can i create a Login Page?
Conditional Formatting
Front Page search form: change the wording when "no document foun
how to use form instead of msgbox to get answer
strMyString = the name of the text box
Changing Many Records
Setting field in another form
Multiple SQL Stuff
Close & Open form with code
Continuous Form on Tab Control
insert/replace ole object in table
Accessing The Windows System Information
SQL and Null
set focus not "setting focus"
Event Procedure
re-link table in code
Changing form ColumnWith
changing columnWith size
trying to uncode text
ADP - Copy mdb table to SQL Server
SubForm or what?
Display a date
Use of filter on the form
Going back to form after Parameter Value form is cancel
Cancel button with validation checks
Screen to Report
use values in table to table for query
Calling subroutine in a subform
Advanced functionality with Access
import excel data into access table
SQL Update - 2 tables
Getting error please help with this code.??
Selecting a new record
Remove ControlSource from All Controls on a Form
RecordSet Help
temporary recordset.
Suppress Loading Image Dialog
Executing MS Excel through MS Access vba
Microsoft Office Spreadsheet 11.0 -- DataSource
Update existing detail records upon change in master field
question about updating fields from main to the subform
question about updating fields in subform from mainform
Dlookup fails with 2 compo boxes
Edit registry key values
Control Formula displays different result when cursor is on it?
Calculating a Total
How can I set up that user can't read the database?
how to read what is in 'dirty' text box
conditional macro or code
find record in subform
scroll in mouse on a form
Updating Form after changing filter property
Error 2465
Synchronize Form Data to List Box After Update
Repositioning A Subform
Filter button
Filling in a listbox from a table in SQL Server from Stored Procedure
SQL to update a table...
Help with message box code
Obtain Month and Day in Code
Item Not In List Message
Help with SelStart. In textbox want cusor to be at end of txt on c
Find Record but Remove Filter
what is wrong with this code
Send object method - possible custom
using this WHERE CONDITION HOW do populate the textbox
Linked Image Loading Dialogue
Time Question
Awesome Information
How to loop through table and display in Listbox?
Check Box - Hide or Grey Out
Quer returns no records
The Click
Fix Database
Current event does not work
Filter from Form cbo to Subform cbo
Table relationships
search problem
User Level Security
VBA to run query record
IIF Statement in query
Code does not do what it should
Help with OpenForm Where Condition
FindFirst and Date Fields
Displaying new record not in list
Referential Integrity Mystery
Total time
Validation
How to share code
Output two queries to one Excel file
Repost: Requery To Update Issues
Requery a form based on a Query
SQL Update
Can Form_BeforeUpdate detect a specific control change?
Change Table name via Form?
TransferText - Conditions?
Help Doing a Lookup
Dynamic Query field changes from form values
Error message when using before update event procedure
Automatically populate fields
Current section of the form
Default control from a different forms control
msgbox in macro
file copy function
Synchronze Forms
With Affiliate Network Pro - Earn a generous commision
limit number of records with a linked table
restrict memo field entry length
Repeat (or not) same data to new record
Attach Hyperlink
Recognising the data type
Simple Date problem
help using subform to add new record...
Help with SQL UPDATE query
users running their own queries...
Combo/list box list to display as pop-up affected by autoexpand
Adding a custom quick menu
Check unbound combo content
running the query by design pane from code...
Automatically Delete and Import Table
SUMIF HELP!!!
Updating field question
Need help with coding runtime error.
On Change Update Subform
open query with a dynamic filter
Option Groups options counted
Form Filter by Selection used in combo box Row Source
Testing server
DCount
"Hidden" control appears on every record instead of current record
Looking for Mere Clever Way to Write Query
Two Questions on Forms for Access Database Project
Using VBA Query and passing data to different text boxes on form
Problem with Selected() and Requery on form
Problem with Selected() and Requery on form
Adding a filter to a command button that has a security password
Set listbox rowsource from collection - form won't stay open
Control variable syntax question
Checking all..... please I need help!!!!!!
navigating through sub forms
Using AND and OR in strLinkCriteria
Enter value and open form to that record
Pre-Print Purchase Orders
VBA driven method for saving images
Is anyone can see this?
What the event should I use?
Close All
urgent - split multiuser db
Sending email
Message Box for Subform
Error Checking for Entry in a Text Box
Problem with TransferDatabase export from back end
Scrolling a TextBox in code
dlookup in Control Source on a textbox
666
cascading combo, a different kind of query!
retrive sql filter
Field calculation resulting as 0 (second request for help)
Property let
ADO, how to move through this recordset
macro not automaticlly updating combo box
macro not automaticlly updating combo box
conditional count in report
Time comparison in a query
Collection of selected rows in list box
Adding "ALL" into Combo Box
closing a info(?) popup
.undo .OldValue problem
Cancel datasheet design changes when closing form
Location of custom DLL for use with MSAccess
Combo Box
if statment in query
Error 3164-can't update field
Testing a value using a validation string
Entering data into forms
Object Library 10. vs 11.0
Current Form name
SetFocus on embedded subform - error 438
Microsoft Access 10.0 Object Library
Method or Data Object Not Found
Filedialog err 438 Object doesn't support this property or method
Quering from a Form (Access 2003)
Autofill
Changing a subform source object with code in Access 2000
combo box
Specifying record source in a form control based on selection in another control in same form
Syntax Error
Change rowsource depending on option group;SQL conversion
Assigning Printers and setting margins