Microsoft Access Form Coding [Archive] - Page 7

Create new records in form
Forms: Combo: display one field, save another
praca
Comments for Software Protection Solutions
Re: Help in filtering my subform
Beetle - I Need You Again
Show Record on subform based on current subform Line ID
Limiting the Data by Last/Present Quarterof Year
One text box - multiple table row updates?
Delaying an Event
Math with fractions?
Moving values between two forms
Create inquiry screen where users can enter name look-up info
saving a continuous form set at a certain vertical height
Re: multiple results in one textbox
need help with syntax
Pulling only Records After Last Payment Date
Beetle - What Do I Do Now
Re: Show signature on report
Resize Form Footer with code?
opening form based on another form
Cancel button to undo data on subform
Default Value to a Specific Date
Open Folder button coding
VB question, Combo box enables or disables others
Compile problem
How to grab value of selected item from CcXploreListView Control
Getting query into Excel
Requery Multiple Subforms
union query with "unique" and "is not null" values
Re: check status after update
Text Box Populated With Wrong Column
Text Box Populated With Wrong Column
Text Box Populated With Wrong Column
Run Query From AfterUpdate
Date and Time
Displaying input fields based on a combo box selection
Requerying combo box in sub sub form
Is there away
Yes/No in a combobox wierdness
drop down not allowing selection
Data issue
Error when adding record on a recordset openned by a view.
Column Property In Reports
Copy Record Date Won't Copy
Zoom not working in Access 2007 Runtime
Bypass Enter Parameter Value
RE: correcting data in subform
Re: correcting data in subform
Array issue
Loop Through Detail Section Record Controls
Does DateDiff Have A Bug
Event Procedures not working
Refresh Dlookup Values on Several Tabs
Opened/Closed Weekly count and YTD
grouping up date data
Calendar Control in 2007
Reading Tag value of Forms
Using a form to create a query
Combo box to show previous value
Textbox - IRR calculation with VBA
Access 2007, Passing parameters over to a query
Re: Selecting options and making it dynamic in forms
Update with SQL
Color Using Module
Problem witrh list box & forms code
Adding Records to Sub-Form by Default
appending more than 255 characters into a Memo field
is a loop the best way to create a delay
Image not displaying on form
RE: Switchboard
RE: Changing toggle button caption in sub form dependent on underlying
Syntax Error Driving Me Mad!
Showing Date Stamp on Form
SQL hates me!
RE: Display data based on selction from combo box
Cancel record navigation?
DateAdd Problems
Require help on slight twist to auto-incrementing a number
Form_Current, Form_Load error out in a SPlitForm in an ADP file (?!)
Filter unbound search combo box based on filter in form's OnOpenEvent
Re: Conditional Formating when control is locked
close shell issue
Help! Suck on copy data from form
Lebans MouseHook question
Bar Code Scanner - Insert Tab Character
Managing Visible Property of Label Control
Need Help with an insert query
Subform Select record
Disable controls on one record (row) of a continuous form
Split Form filter problem
Problem with SQL
syntax for setting a form to "PopUp"
Field Data help
Help with code needed: Import records from Excel CSV file
Copy Records
Re: Display Dates in listbox
Access Switchboard not Working - Private Function HandleButtonClick
Follow Hyperlink to .pps file
Validity of an e-mail address
Re: Display Dates in listbox
Parameter
cancel button to undo data entry
Marking a PO as Printed
Limiting Criteria to Exact String (not contain)
Coding Afterupdate of Combobox to modify data shown in Textbox
SQL statement with two ";"
More Message Box Help
form using DAO recordset- access 2003 Winxp
What To Do
Obscured report previews
Re: hide message bar
combo box setup
logic help needed - MPG calculation
Subform Help Needed
Reversing Case of eRR.function
Leban's rotatext scale problem
looping issue
Combo Box Select All
Text Box Refresh from Combo Box
Re: Options in MS access
Refreshing ComboBoxB with new criteria in ComboBoxA
code issues in 2007
Insert Into Table Field
Another Date ? Continued
Creating a Summary Field
closing the StAppName
combo box showing a field or a table list
Bentley Microstation DGN reference
Validation on entry against fields in two tables
ie versus mozilla
subform filters
Re: Deselcting check button in access
Re: Deselcting check button in access
Control dimension in OrderBy
Custom error message based on two sets of criteria
i want to stop macro in vba at access program. how i can do it??
About the command....
Date Problem
Opening Excel file read/write
How Can I Display Multiple Rows and Columns?
Check Box and Label
Re: Increment number in field when new record is selected
Insert order line numbers automatically by code?
Over flow error when runing a loop
Deleting Tables
Re: Problem with Combo box cascading
Another Date ?
Open file, use relative paths
access 2007 and transferDatabase
THE PROBLEM WITH THE DIAGRAM
Re: Adding a single row to a table
query & modifying table from form
Can Access code update dbf records?
SendObject Email
hi
Check if text string exists
Filtering on Like*
Re: Calendar Form Frustration
Re: cascading combo box
cascading combo box
transfer the image from Open Dialog Box
Is there a value a value in that listbox?
Listbox question
Memorial Day Specials, 2 Days Only: Sunday - Monday (5/24-5/25).
DOLCE&GABBANA bags
Friend
NotInList Errors
Repeat Question
Change the font color/background of a text box depending on value
syntax for stlinkcriteria
I'm Going Crazy, HELLLLPPP!
DoCmd Openquery qryMaxOfEvtInputNumber doesn't recognise the query
save oldvalues in new record
Combo Box Updates, but Form/Data Doesn't
email from subform
Copy/Save data from parent form to table
requery works at breakpoint but not otherwise
Focus a field
Read only form suddenly becomes editable
Automatic Calendar
RE: Calendar Form Frustration
Tables Question
Picture Link
Msgbox Troubles
recordset UPDATE error
Code for Shift-Click?
Re: Calendar Form Frustration
msoFileTypes
Creating a validation routine for multiple forms using an array
Dads & Grads Superstore
Run code by clicking on a label - Not working
how to log switchboard button clicks
A Weekly Count
Auto populate cbo based on other cbo if that cbo value exists in t
Delay running function
97 Error Message "couldn't find installable ISAM."
access 2007 OLE object problem
Adjustable Sofa Bed Futon Sleeper
Olympus Evolt E 330 Digital Slr Camera
Jacques Lemans Chronograph
Default value to previous record not working
SendObject
Refresh the subform?
Open Query in Design View from Button on Form (?)
Copy Master and Sub record to an exisiting record with specified P
Combine Subform field to one field on main form
Button Coding
Query Criteria Help
rename attachment
PRINTER LIST ON WINDOWS 2003 NETWORK
images shown on form
Picture Based On Criterior
Converting seconds to hh:mm:ss
select in listbox
use checkboxes to enter date on continuous form
Re: Turn off "select all" in datasheet field dropdown
report to PDF format
beforeupdate command not working in Access 2007
OpenForm with multiple criteria
Coding for an After Update Event - if field contains string "limited"then
Multiple Filter Criteria
access 2003 crashing
Hide message bar
The Elephant in the room
pdf send
Close form open another pointing to same record
My Dumb If
DAO 3.6 object library
e-mail code
Choosing records
Projevct Locked
Compacting
Test for multiple key press combination within a form
DoCmd ApplyFilter performing funny
SendObject and combo boxes
textbox for gradual filtering
Lotus notes email problems
Queries that run in 1 second take minutes on another server?
date part
Margins
Radio button enables Combo Box
VBA Code Required
Validation and Popup Calendar
Stop Close if Dropdown not chosen
What is wrong? Can you interpret this for me?
SPLIT with multiple delimiters? (general VBA question)
Concatenate hierarchy
So difficult for me - training reservation.
Multi Select
Access 2003
Main form with subforms
Syntax on Sync'd Subform
how to add calendar in form
Re: Find the last record on table
Subform date/time must be greater than date/time of last record
email query
Re: Can't get this to work
If else subform reference access 2007
delete record with blank required field
Disable Database Close
Subform Data Not Saving
New record on subform
Locate form position
Blank List Control when data is present.
Switchboard form no longer fills
Filling combo boxes with query / table data
automatically fill in text fields - more help pls
before update not working as I expect
how do I determin if a field has data
Revert back to Default Value
Editing select rows in Password Protected Excel file created using
Command Button to Lock Form Fields
select record based on record selected in the child form
Check Data on Continuous Form
Listbox RemoveItem
Need to print range of records.
Help with VB code
Copying data from parent form to subform
SQL / query syntax, and code about inserting records
Chart sometimes "alive" and other times not
Cancel insertion/delete last record
Re: invalid use of null when closing the database
Car Loan Database
Determining # of Week Days between Two Dates
subform resize???
Speed
Form doesn't refresh based on combo box value
sql update from runtime
Report Query
Auto fill fields based on combo box selection
Function not available? It was yesterday...
Filter Problem
Access 2007 MDI background Color
Help with Insert Into
How to get a text box to update from a subform question
Applying a filter with code
Amending the property of a control across a number of forms.
My earlier post was Horizontal Line
Subform email
datasheet view - sort upon clicking on column heading
can't add new record to sub-form (continuous)
Build SQL statement longer than 1024
expand combo drop-down list at form open
Filling controls based on a value in a combo box
SQL "insert into" code not working
stored procedure
Variable Font Color in Combo Box
Re: Delete current record from front and back end
set DAO.QueryDef to nothing
Re: Delete current record from front and back end
How to cross reference report numbers
Auto Purchase Order Number
Open form to a specific item from continuous form
Create a visual cue on a continuous form
Re: Retrieve Username
Find the last edit position in Text Box
access to word
Evaluate multiple controls for Null values
Formatting a decimal
How to fix Error 2465
If statement
Synchronize Combo Box and Text Box
Synchronize Combo Box and Text Box
OutputTo Excel ... Date format question
Stop subform from scrolling to new record line
Lock Previous Record Help!
set DAO.recordset to nothing
Access crashing and ?fix?
Re: SQL UNION sorting issue
Odd subform error
3 part form using plain paper
>> image.picturedata
writing to a text file
Referencing a field's properties in a Report
Change Screen Tip
ComboBox list isn't complete, gets cut off at 10000 items...
After Update
Using Access data for Word fields
update user and now()
The Object Doesn't contain the Automation object 'securityTicker'
shell.exe help
Miliary Time
Form to check if item used
Re: SQL UPDATE statement HELP
RE: SQL UPDATE statement HELP
Access coding with the mircosoft office clipboard
Replacing "null" with "(default") in a combobox
error 5
Reinstalled Access - Now buttons don't work
Avoid Password
Open form issue
Resetting Linked Tables DSN connection
Horizontal Line
running VBA code to run Crosstab query
Linking ALL Tables from BackEnd Database
Insert a crosstab to temp table
Capitalisation of names
datediff returns wrong amount of hours
Using a quick key to navigate wont work
Creating a Simple Form to Add a Record to a table
Yet another DLOOKUP question
Only one can open file
Re: Dynamic Subforms based on the number of records in Table
Re: Email sent using OIutlook 2007 from Acsess 2003
Add hyperlink button
Question: characters and writing to a text file
Re: Save Current Value to table
Re: Delete Current Record from Unbound Form
Re: Using strings in VB
Re: Delete Current Record from Unbound Form
Another Electronic Signature Question
Highlighting field in subform
Multi-Select List box AND Date Parameters
Number of concurrent users
RE: Load event - multiple criteria
Load event - multiple criteria
Spell Check in AC 2007
Return without GoSub
placing textfields in a specific place
Re: Using strings in VB
Changing another Record in same Table
Dlookup with multiple criteria error
Suppressing Popup "A potential security concern has been identifie
Re: Using strings in VB
NotInList Issue
Time Totals
Size to Fit Form programmatically?
Send from Access to Outllok help
How to stop Outlook message during Access Email routine
RE: Email sent using OIutlook 2007 from Acsess 2003
Created a Temporary Query in Memory VBA
RE: Email sent using OIutlook 2007 from Acsess 2003
Combo box to look at tables names
Problem passing value after requery into openargs
Variable Excel Rows
Dsum in Tabbed Form
Providing Dynamic Pop-Ups
Text Box Undo
Text Box Undo
Sub Form Display
Forms corrupting - so will create new FE - please tell me gotchas.
Re: Fields Won't populate
Does a textbox have to have a name reference, or can I use a wildc
Form---Click Field to Determine Contents for Subsequent Field
Need help with this code to find specific record
Opening a Google map from address in a form
Re: Turn off Visual Basic auto correct
Turn off Visual Basic auto correct
Can I have Sort Column Headers in a Combo Box?
Openargs Not Working
RE: Search for Record always goes back to the start before finding
Search for Record always goes back to the start before finding
Copy Value
Text box focus without font white on black
getting error message
Change Order of Controls?
Adding Money Up
RE: Text Files
Text Files
Correct syntax for using Print #() function to write all fields
Continuous form set value macro
Change form field upon recordsource change
Textbox formating
Using Combo Box to select records for update
Help with Code
Re: multiple attachments
multiple attachments
Handing over a String Variable from one Access Applikation to a second Access Application
Form_Close
Calling a method in a subform's parent form?
Help with Select Case/Set Focus/GoToControl
method of flagging change to single record in detail section of a form
Need help with a multi-column per date graph
invalid call procedure or argument
Display size of embedded Excel sheet
Out of Memort Error -- Frustrated!!!
Mail Merge Report Help
RE: Can't assign value error
Can't assign value error
Code Help Please
Code from Report to Form
Update a field which has a running total
Re: Combo Box
Combo Box
Electronic signatures
Command Button VBA
Counting yearly totals
adding 0.1 in VBA
update 1 field from 2 others
Modify Date procudure
Not recognizing specification
Switchboard coding
Field's lenght
DATEMODIFIED FIELD
Richiesta pratica per estinzione mutuo.
Displaying calculated variable
Validate field, reset value
Problem reading textboxes
Form filter on date
Strange behavior when closing Access through Exit button?
RE: Field to Field dilemma
Field to Field dilemma
Combo Box - Case Selection
Help Please with SQL yet again
Keeping Values in Control Source
Record logout time on close
VBA code from 2003 not working in 2007
Re: Getting the fields names
Runtime Error 2448 - Can't assign a value
Getting the fields names
Two multi-select list boxes
What is form doing when says "Calculating" in bottom left
TreeView
Need help with Allen Browne search form.
Why would a command in Access be unavailable?
Calling functions from one form to another form?
Add text to title bar of Open file browser dialog box
Multi Select List Box
extra class objects
datasheet subform checkbox to all checked
Continuous Form Issue
Pivot Table
cancel unload event on mainform from subform unload event???
validation matter
Use Textbox.tag properties to keep values
Recordset Question
Who can solve my Access Form coading problem ?
syncronising combo boxes
subform field to subform field
Re: Error 13 - Type Mismatch
Combo to find record does not auto expand
A Dirty NotInList
AfterUpdate code to achieve zero value in SubForm textbox
Conditional formatting issue
Unable to modify bound fields in datasheet view
RE: PDF opens then immediately minimizes
PDF opens then immediately minimizes
On Mouse Move the mouse pointer fick when using Image
Need help creating subform
error executing command
Glitched addressing, or just addressing controls incorrectly?
Disabling checkboxes when an "approved" checkbox is checked
vbOkCancel
product code
product codes
Combo-box lookup shows wrong value after user makes selection
Re: forms and variables help please
Re: forms and variables help please
Conditional formatting
1 sub-form appears in both Tab Controls
Email with Lotus Notes
RE: Input Mask Help
Refresh bound field on form when new data added
filter form open & refilter with user input
Textbox DatePicker doesn't show user-entered value
Make two recordsets from master table with unique & random records
subform to subform
List Box go to first record
Multi user forms
Re: rs.FindFirst help, re dates & time values.
Using Not Like In A Procedure
Pass filter based on combo box from for to report?
Error 13 - Type Mismatch
control default value
Using WHERE clause when launching Reports from Code
Print selected records
Open an Access Database Automatically
Access Report Coding
ppt2flash
Option Group to Text Field
Update query?
Error catching #error
Fill field in internet explorer from from
Centering a form
tabbing from header to detail section
Specifying conditional Criteria in a Query or Report
Option Group not requerying after remove filter
GoToControl with selection in a Combo Box
Look-up Box Condition
Requery subform after entry on main form
RE: Default value combo box current user
Default value combo box current user
Help with "WHERE" statement from different fields in multiple tabl
Block of keys such as CTRL+Z...
Switchboard button problem
Help with SQL
Re: Position of popup form
Loop through Record Source for form in code?
Re: Default 1st entry in subform to #1, auto increment next entry to #
Re: Position of popup form
large form being requested
Microsoft Chart Control License
RollBack on Bound Continuous Form
FORMAT to show minutes and seconds?
Why has this stopped working
Auto update Form
Elookup Error 3131
Re: The expression On Current...produced error.
Re: Forms and Records Help Please
Send To CD-ROM
What is best way to display error message on form?
Interrupt default behaviour of a control
If statement at open of Form?
Running a query and if successful run another
Re: How to: After 24 hours, User is not allowed to Edit the Order.
Re: How to: After 24 hours, User is not allowed to Edit the Order.
This code isn't working any more..
Open Form using Form with MsgBox Error Response
RE: =HoursMinutesAndSeconds ??
RE: =HoursMinutesAndSeconds ??
how to write >=Date()-1 And <Date()+3 in VBA
=HoursMinutesAndSeconds ??
urgent - Email report using macro
Controlling MS Word from Access 2007
Re: Unable to Lock/unlock form
Create a csv file
supress leading and tailing space
Access Form Issue
remove item from current item in list box
Filter output to excel
Conditional Statement based on active control
Function to test if TextBox entry is a 4-digit number.
Conditonal List Processing
converting data type in report
Re: Comparing dates problem
RE: Comparing dates problem
filter the record of opened form by using combobox.
Focus set to sub-form when form first opened.
Re: Comparing dates problem
Printing a Report to a Specific Printer and Tray
List subform items on main form
VBA to set Form’s *design* values
Help with linking a main form's combobox value to the subform
Invisible form
SubQuery Problem
Running Code as Access 2007 Shuts down
Checking for duplicates
access hyperlink using data from record on form
Uploading a Picture
Can't undo a form's TextBox entry that has a validation rule
How to add streaming video to your website
DoCmd.GoToRecord , , acNewRec Problem
public procedure
Error 2455
No Current Record
Filter report with Combobox AND Multiselect Listbox
Re: Method or Data Member Not found
Method or Data Member Not found
Making a forms "dirtied" record virgin new again
Multiple actions for one button
Moving data between tables
open form to Add New record not working
Class Module returning ADODB recordset that can be assigned to forms or controls.
Unbound Combo Box Default Value Based on Query
Re: Retrieving a Value from a Query
Retrieving a Value from a Query
Auto Populate Field
Duplicate Records
Update form field
insert a node in to tree view
scroll treeview list when drag and drop
Iif Form To Table
Re: One more Select Case problem
Re: Combo Box arrow
Re: One more Select Case problem
Combo Box arrow
One table too many!
DOLCE&GABBANA bags
Error when adding a new record.
Delete Query -- QUESTION
Display a random comment, remark, pun on a form
Re: Deleting Records from another Table
Re: Deleting Records from another Table
Deleting Records from another Table
Punctuation causing errors
Combo box auto populate problem with CAPS
Copy and paste into Excel brings in controls
First 7 characters
Dropping Leading Zero
Re: Chr(9)
Chr(9)
Select statement
Form Loads Slow/Combo Box Row Source Performance
NotInList not firing ?
Pass information from form to QUERY CRITERIA
open form to specific record number
Avoiding multiple queries
Security Feature
Problem with Combo Boxes using Filter By Form and sending to Repor
Multiselect List Box Problem HELP!!
Re: Sort Table by Field
Re: Sort Table by Field
RE: Sort Table by Field
Trapping the 'no duplicate values in a table' error
Combo Box selection / AUTO POPULATE combo box in a different form
Individualized image visiblilty in continuus form?
Enabled property use - Tab Control "On Change"
Enabled property use on Tab Control "On Change"
changing record source for form with option button
Counting Records in a Query Using Code
can't find error
Combobox How to? Use one field, Display Another
Securing data in a form field
RE: Play PowerPoint in access form
old data still showing in VB
Search at once in 2 fileds of the same table
Re: Problem with DLookup function
Re: Problem with DLookup function
Re: Problem with DLookup function
Problem with DLookup function
Use Yahoo email, when we click from the form
NEW & SEALED APPLE IPOD TOUCH 8GB 2ND GEN MB528LL/A
Sorry about the triple posting of combo box
Combo Box List diappeared
Dynamic reference to control in other form
Combo box is suddenly empty
Combo Box went Blank
Based on value from 1 combo box filter results in the next combo b
Zeros preceding a number
RE: Play PowerPoint in access form
ecm2001 v 6.3 torrent rapidshare download 17456600317711846521
Getting Type Mismatch on OpenRecordset -- ??
Still Working on tables
Works in Access 2007 but not in Access 2003
Need to use public variable via function in form
Keep Cursor in Subform
ac2007 button to open form
Change ListBox.RowSource - Is Requery needed.
0.6807205 Maybe We Can Help Each Other ... 0.6486765
On Current Event A2007
Re: DLookup Help
Using SQL inside a Form
Re: DLookup Help
Summary Report - Ability to Drill Down a line Item Detail
Error "No Current Record"
Filter a table for use instead of using a query
Select disintct I need to order by on a field not in the select
Filter Subform
Using Code to test if a value is in a list
Re: Coding Date Question
Coding Date Question
Move from one file to another
Eliminationg Access toolbar issues
Continuous form field value
Setting Text property of textbox used for dataType of Memo
strange behaviour button that opens zoombox
Database window is lost
Arrange data sheet witin a Form
vbYesNoCancel
datediff calculation on Access Form
Simple code
re-using variable throughout code
autocad electrical 2010 autodesk full download crack torrentrapidshare 44636455581212341640
Delete record from one table, set field in another table to no
Multiple Selection per field Query
Re-initializing controls on a form
Getting value from previous record
short time calculations
Access 2007 and SendObject
How do I retrieve history from an append only field in Access 2007
On Enter code error on subform
Need help with text box vs memo field.
Sums and forms and storage of data
Form doesn't sort records per the underlying query
Duplicates in a continuous form
Copying a File using API
Re: using radio buttons
memo field to .txt file
Many to Many junction table and subforms
combo box and what it shows
Can't get Me.AllowAdditions to work with command button
How to tell what's going on with complex queries on linked oracle tables
Windows Task Manager
RE: Help with Error response
Querying for combobox problem
Auto close form when mouse moved
Auto Populate Field
Passing information from one form to another
tree view list performance issue
Pop up Window
Forms with Options?
default field in subform from main form
Normalized Tables
RE: Date program calculation
FORM CODING EXPRESSIONS
Can continuous form be in a tabl control?
checkbox on form not working
Re: "object doesn't contain the automation object"
Bypass Filter