Microsoft Access Form Coding [Archive] - Page 49

Index Linked Table
disable field update in a form
Transfer Textbox value and run code
on change event when editing a sub-report grid?
1 button many reports
forcing data
forcing data entry
Extracting filename from path
forcing data entry
How to select an entire row And append it?
getting value of unbound column in combo box
Form Labels Question Repost
Linking a Database to Multiple ODBC databases ?
monday of the third week from order date
Set Focus?
Validating field
how can i refresh MS access form every 1 minute
Sum Problem
Recordsets and Subforms
Continuing before values returned from Query?
after the linked field is updated on main form, the data on subform got lost
Defaulting a Required Yes/No field to Blank
Executing Stored Procedure w/ Param in ADP 2003
Form code fails when Openargs present...
Search-Edit record-Page-Subform
Grab previous records field
Help with "Visible" Code
Using a form to specify the criteria for a query.
Macros to filter
Error while generating Reports
can i use software no longer needed on a different machine?
Sequential number
Where Condition? - Passing Unique ID to My Report?
Need help with syntax
Export table data to text file
Using a multi-index in VBA
Assigning the value in recordset field to a variable
Dlookup Syntax
Casting to Date type
Dlookup Syntax
Virus definitions date
Selecting All Text
Fiscal Week Numbers
acFormReadOnly
check all combo boxes for a null value
Navigation buttons and form closing button.
CreateObject
Form Labels Question
Help with a calculation on a form
Calculating Speed
New Record not allowing data entry?
Skipping records in Data Entry Mode
conditional format based on other control
Re: intellisence acting strange?
uppercase first character
Allen Browne Audit Log
calculating on dates
I don't know how to use DSum
Referencing form-module variables
Find and Replace
Null error msg
Filtering subform and locking columns
Timer Form
Multipul report printing- Please help newbee
Error when I run Append queries
Re: HELP Error in generating reports
Using SQL in VBA to Load a Control
User Selectable Report Printing
RE: Passing over Requery
share access
listbox & Setfocus
combo box - select 1st item
User not alerted of duplicate 'key' records?
How to print an external file?
Re: Troubleshooting Techniques
Re: Problem using SendObject
Assigning postal code from definitions table based on address elem
DCount problem
re dsum
NotInList problem -- get custom entry box AND generic message -- Access 2002
EARN MONEY THE EASIEST WAY ( GANA DINERO FACILMENTE )
Looking for files
Problems moving results from Subform to Main Form
Modifying field properties in table using VBA
tab key and form sections
Unable to filter subform
DMax/DLookup help
Toggle between ASC/DESC order
Force the user to do something before the form updates!?
Sort order
Access backend and VB.net front-end
GoToControl not working sometimes
Making a one time function
Re: docmd.requery on change event
list box is not populating my table
Opening Forms with Textboxes
Need something similar to smart tags but using Access 2000.
Sum Function as Control Source
Button to increase value of text box but 1
Count Textbox Characters
RE: HELP Error in generating reports
Deleting From ListBox
Concatenate
Disabling a text box until a tick box is checked?
Programatically Select From 9 forms from primary screen
dsum problems
Lunch a form faster
Problem with 'Sunken' Special Effects in Access 2003
Re: Code will not execute
After Update help needed
Re: intellisence acting strange?
MinMaxButtons
Setting Default Value
Transfer my access query result xls sheet to ftp folder?
setting the visible property
How to make automatic refresh / realtime form datasheet
Save deleted or pre-updated record
How do I link unbound combo boxes in a subform
Missing Data
Relative addressing
DSN-less connections
How can I open a Word merge document from within Access?
Please Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
reading binary file, then writing
cbobox that has duplicate values?
User ID
Auto Date Field
Prevent unauthorized changes
Code to Create Right Mouse Click
Open Form with Criteria
Refreshing Data
updating text field in a form
using dlookup as control source
allocating jobs to people based upon choice?
Re: Help with adding a condition to existing code
Connecting two forms with one field in Access when you click a button.
Run-Time Error On Form Open
Filter based on Combo Box
Split Function ALWAYS base zero?
Re: access project
Re: need help with form events - populate data to new record
Send Data to Website thru Command Button
record set trouble
Programming After Update Event
ActiveX-component msinet.ocx
Re: Private To Public
Roster - How do use
Conditional formatting on a continuous form
Stop Steve, the advertising machine
Update field based on another field in form
Required Options
Date Format Problem - mm.yy
Assigning list to ListBox
Listbox value copies to two fields?
Compound loop conditions
option buttons in frame problem.
Datasheet's Recordset
Updating a listbox
Is an Amphersand ("&") Allowable in a Command Button Caption?
useing a form to enter and update multiple records?
Strange problem/question
Re: Use a Form instead of a message box.
Re: Subforms using SQL Server Data
Re: Loop through folder and grab/link all tables
Re: Limiting large sorted queries
IP Address
My Form Will Not Respond To Me.AllowEdits
Use Windows ImageList for program icons in treeview control?
Runtime error opening form
Re: Running form code from another database
Re: Help With Dcount syntax
finding a name on list
Open access-application with fixed size
moving from VBA to VB
Altering recordsource on a subform
Re: Mouse Over etc
unselecting the "filter" toolbar button
Passing arguments
My Cancel Button Is Not Working
Determining number of records returned...
Append Problem
Combo Box -- saving data to multiple feilds
Re: why is year function not recognized in an access 2002 form's code.
Code to delete record and linked file
Re: Comboboxes and validation rules
How to add the names of tables to a combobox
scrolling in unbound subform
Prevent move next on Enter
Re: Printing Form w/Subforms
Run Time Error opening form
Re: Wrong Data Being Returned from Combo Box
Event procedures
Re: Wrong Data Being Returned from Combo Box
Re: Restricting responses in combo boxes dependent on previous fields
requerying a parent form from a subform
Re: Working out Time Difference Between 2 Dates?
Call Public Sub from other form
Auto Insert Date by Ticking Check Box?
Re: I have 1 user of my front-end whos calendar objects never work.
public variables
Re: how to mimic code
One step forward, two back
records aren't appending...don't see an error!
Display all records when TeamLeaderID = 4 has been chosen in
How do I programmatically delete a link to a table in a linked file where the table has been deleted?
PLEASE HELP - COMBO BOX PROBLEM
Appending a record
Form with two tables?
Assign next value automatically
In MS Access assigning RecordSource doesn't report errors
"#Name?" In Text Box
autofit columnwith in listbox
Re: No Unique field
Re: update blocks on form
Make MDE File Causes Access 2003 to Stop Responding
Combo box needs data input
Best way to select records
use password prompt for editing form
seting forms record
Saving Subform Fields to Table
subform updating
Storing SQL Count to Variable??
missing records from coded recordset when compared to qbe
Feasibility
Deleteing Multiple records from a sub form in datasheet view
Cascading combo box add text
Object
Can't save record after change
Unbound Combo Box Protect/UnProtect
Getting Excel To Access
Canceling a double-click event
persistence of form recordsource
Execute SQL Server 2000 stored procedure from Access 2000
problem with DCount
correct way to handle excel files stored in mdb
One file or multiple files
setting rowsource on combo box
Update controls programmatically
Subform runtime error
Generating an Audit trail in SQLS 2000
Storing and managing images - Advise
Use string variable as RowSource for listbox
Pass value between forms
Insert special character in a field with the press of a button
problem with openform function closing the previous form
Compacting old Access-database
Re: I have 1 user of my front-end whos calendar objects never work.
Keydown Even No Working In Form
Linking more than two forms?
Need help w/ Custom Primary key with letters and numbers?
Change printer tray through VBA
I have 1 user of my front-end whos calendar objects never work.
Not Valid Bookmark Error
How do I know if I already have Service Pack 3
Calculation down a coumn
Code For Required Fields
using send object to send a specific record in a report
Re: On Change Event Not Firing?
Filtering a form causes a crash
More difficult request...
Printing Global Variable
Excel via Access help
Refresh, Repaint, Recalc, Requery...Nothing Works!
Add Record Not Working
Email
Pre-filling a text box from another source
Simplify, simplify...
Passing a parameter to an MDE with ShellExecute
GoTo Record Selected in My Combo Box
How Do You Debug These Problems?
new record insertion, PK conflict
Bold Text is String...
Create comma separated list from data
Help With Public Function
dbl click unbound text box to bring up that report
Re: Importing .Dat file???
Refering to Subforms through Code
I can't scroll thru records using my combo drop-down.
indent VBA code
Filter Total Records
Upload document to SharePoint via VB
Finding Current Record From Drop Down
date stamp a record
Adding All to a combo box
Make MDE via VB
Error Message
Event Coller Question
File copy and rename in access
Requery Combo of Current Record in Datasheet View
Launch a web site address
input mask question
Form Design Problems
Error loading DLL
A Point & Click Calendar in my Form?
Custom OrderNumber?
is table already created
Send Object in PDF Format
Missing multiple field values
Import data from Word using a form
Access to Groupwise
Automatic field generation
validation rule
Using Global Variables
form cbo box 2 columns saved to two fields?
Citeria like xyz does not work
Reading E-Mail Addresses from WAB
record becomes read only after updating
Temporarily switch off records autonumbering, then restore records autonumbering.
Sub Forms and Parameter Queries
Is accessing the current time and waiting for it to change possible?
calculating the # of weeks in a period with variable start and e.
Count Yes/No Field = True
Navigating records from a alien form???
variations on entering a date?
Extend formula to apply to every cell in a column
Networked Database, locking Edited Records
Help with ADO stored procedure
Weekday Name when Monday is th first day of the week
Vb Run-Time Error 2105
Can't find project or library
ODBC DSN Connection
auto-populating fields
Adding a Record to a Table in a Sub-Form
Help needed on Leban's JpegGif
Disable the caps lock in data input form
Field up date only put in part of data
Copy From Parent past into Sub Fm
Function to convert text to date
Converting string to Date
Clear or Break Table Links
Can't open new form AND go to new record?
Set timer for invisible form
how to use IIf statement
Public variables become empty???
Is there a way to make access application stand alone?
Opeing a File
Runtime error 80020009
new hosting for me
How Can Import Excel.
Editing Mainform and Subforms Simultaneously
Form Button to Save Current Record to RTF
listbox to open files
No value given for one or more required parameters
Recognize change immediately
text field Visible based on a combo box
Error 3021 No Current Record
Detect if another form is already open.
Filtering Subform by Textbox from Parentform
Calculating Date Interval
Referencing parent forms through one common subform
Controlling Form Size - Followup Question
Date notation swop via VBA-Filter
For Each
Access help
Check for empty controls
Checkbox question
Confirm that E-mail was read.
How do I create a subform programmatically?
How can I create a subform programmatically (ie dynamically - not.
show/hide controls when opening a form with another form
Invalid use of Null & runtime error 94
Numbers in Standard format in a listbox
Coding a form for a normalised Database
Format top 5 rows in a list box
popup forms and previewing reports
Using SendMailWithOE
orders form... performing lookup or manual entry..
Help with this email code
Open Form In Edit Mode For Current Record
Insert statement
Auto List Members not working
One list box to control the cource of another list box
Open New Edit Form
Synchronizing/Refreshing SubForm Data
Why does this DMAX code fail
Filtering unbound subforms
Populating Fields On Subform
SQL syntax from Filter by Form
Variables won't print to printer
keeping a control property after run time
On Not in List Event
Controlling form size
text field value remain selected
Finding Records
Event procedure not matching
Add New Record To Form With SubForms
Remove Hours, Minutes and Seconds from Date Field
Does a form know which open forms are it's child?
Add A New Record Using SubForms
Setting focus on a main form from a subform
Meeting request
Update field using String?
Call an Edit Form from a view only form
New record when Enter key pressed
Dbl click code
Weird behaviour when controlling Excel from Access/VBA
Run Time Error 13
populate data in subsubform based on what's selected in subform (d
run time with FileDialog object
Help designing a Selection Form
Running Sum Effect on Form
Locked record
help with creating an orders form...
Lookup matches while writing in a form
supress error messages from db
navigation and validation on continous form
Make text box invisible
If..Me problem
Symbols in a label?
Deleting temporary tables
Search Code
calling functions
Error troubles!
Forms - subforms - after update event
Putting Null Value in String Variable
Form Opening without Records
Help with custom menu bar
Application vs. Process
Combo box visual basic
Round decimal to fraction
getting a string into a textbox on form
Delete Records on form and subform then macro msg box appears
SendObject and Netscape
Relationships
Functions to produce fully justified (Lebans)
Syntax for a Variable
Can't access web sites from e-mail
update unhidden column of a form in Datasheet view
Bound Text
VBA code to "Run Application" and open jpg file with path in a fie
Object Change to Open Report w Correct Value
Inserting calculation field on form
Lock record
Combo box problem
Dialog Boxes
Access Flash
Find First / Find Next
Lebans.com CanGrow
Finding Missed Controls
Referencing a field in a form?
find a word in the email address
how to create an array of buttons on a form to reference by index.
Listbox with selection of start and end date
FileSystemWatcher stops working
refreshing a combo box
Navigation for single form view
exporting a table
Invisible Label
Undo doesn't reset unbound controls
Displaying multiple lines
Access 2003 / Forms / Data Entry
subform control question
multiple instances of the same form?
Allow Edits not letting me use Combo Box
Control Source
Index (no duplicates)
subform to a main form
Combo box set values
Subform Navigation
Setting up ODBC via code
Task Scheduler
Syntax error in INSERT INTO Statement
Test conditions on Close
orders form... using DMAX to assign new order number
Run Private Subs
Please help...losing my mind on this one.
ODBC Error
Trying to "Drop-up" a dropped-down combobox
Command button and Recordset
Preventing user input While file operations are running
how do I run queries in access on external data?
Form to Select/Create a Report
DoCmd.RunSQL Problem
Closing Access
Date Drop down list minus quarter
Using text boxes to enter a date range to control subform contents
Mainform field to subform field
ADO listbox form navigation issue.
Help with multiple selection list boxes...
Mailto command button in Access.
Re: Share a Printer connected to Windows 2000
locked table error
ftp to unix in Access 2003
Key Down Event Question
Calling Sub Procedure In Other Form
Multiple Requeries Needed at Runtime before Records get displayed.
mainform - subform problem
Combo Box on Continous form
Add Items From List Box To Table
Access Startup properties
Hourglass disappears suddenly
Help writing code
Starting a Report
Seperate text
Pick the larger of 2 text fields
Greenbar
a lazy Insert Object command
Field on Main Form needs to update field on Subform
Set focus problem
Too many forms, I Think?
IIF statement problem
IIf expression prob
Dates and Access
How does one calculate direction?
Disable Screensaver???
Run Function on any data change in a Form?
button generates file not found vba6.dll error
How to check if data has been entered on a form?
Return Key Value from Data View
Creating a maintanence History Table
RE: How to check if data has been entered on a form?
Adding values to lstbxs
Combo based on another combo
Running Sum
Changing the delimiter of a listbox
Conditional fields
Mysterious SQL statement hating tables
Saving Date in File Name using TransferSpreadsheet
Multiple combo boxes controlling contents of subform?
Compile Error: Constant Expression Required
Change the path of a hyperlink field
Referring to object in SubForm
Record in a listbox
ADO recordset
Sub Form child link updated when main form combo selection is made
Use autonumber with a existing table with number
Help with code
Printing Excel File From Code
Re: double click event on tab control?
Fill a combobox from code
open excel spreadsheet
Pull name form table using code
Set filter problem
openrecordset problem, runtime error 3091
Number Round Off
Two problems with field data when using Dates & Currencies
Grayed-out fields on New Record?
ShellWait
Opening same Form more than once at the same time
#Error displaying in form control
End of statement missing?
Determining if a Table Exists
KB Article on Programmatically Linking to Tables
Lebans CanGrow Ver3
Problems with MSHFlexGrid
List box Help
VBA Code Replication
Same Code under several Command buttons on a form
How to refer to Parent of Parent form?
Update a table using CreateQueryDef
Error Handling Idea
Run a query using code.
Is creating this shortcut possible?
Error 2486
#Name? error from Default Value expression
Date Formating Changes
Is there a VBA statement that will return the string of the procedure that is executing?
lookup table/query
Temp Form holds previous values
Validation Rule
How to auto populate a subform based on pk
Filtering One form from 2 fields of another
Icon Flaw in access
Delete records on reprint
Popup Frustrations (removing records)
Updating a TextBox with More than 255 Chars with VB and Access 2002?
Reference problem vba
Code to Check a Checkbox
Suppress warning/error message "record can't be saved"
VBA question
How to wait till the Report is printed from a form?
Summing Text Box in subform with actual table columns...
Listbox selection
Move a subform to the last record
Database / forms corrupt - decompile doesn't help
Memo Field Creation
How To put the Control on A Row in Subform
Select the last record in a listbox
TransferSpreadsheet problems
Synchronized Combo boxes on a continuous form?
Resizing forms
Opening Forms Faster
duplicating control and incrementing another control
Update Front end form
OpenReport from form Problem
Display last entry from continuous subform
Pop Up Property question
Recordset getRows to string
'Not aggregate expr' When Grouping
Pre load combo
Splash Screen
remove bad rows to another table
Missing Leading Zero on records
Main form to display records when subform row is clicked
Combo Requery problem
Screen jumps when going from form to form
How to refresh a subform
niggling few errors
SQL Grouping / Sorting Question
curser stay in the record.
Problem with Insert
Data Type Mismatch in Criteria Expression
If table has no records?
2 Crosstab query report
Hyperlink to open specific record/form?
If condition in a continuous form
error in loading DLL
Serious problem with access !
Prompt for text
Re: Attempting to add reformatted data to a subform
run time error 3075.
Licensing and MDE
Street Address Search Form
MapQuest directions
linking Main form in single form view to subform in datasheet view
I want to automate the input of Serial Numbers
Access is like a fine car
Dlookup form printing problems - strange behavior
renaming a module
Form Code Question
Missing reference msador15.dll version 2.8
How to not open if someone else does
Setting Links for subforms with Code
Calling a procedure from another form
Fractions calculation
.tlb File Not Registering
Dcount function to only count customer once and maximum of 16...
vba code to open filtered form -- Run-time error 2448
Moving focus to Print Preview Window
ACCESS 2003 has bug in referencing data from subforms
Hyperlink from cd
Application unload event
Highlighting Active Field
exporting codes
DMAX() - Text Field Issue
extract numbers from string
combo requery
question regarding checkboxes
checkbox on a continuous form..
remove records
Re; Frontend problem
Moving focus from 1 Form to another
msg box code
What On Event procedure do I need?
setting controls in report from form
Expression error
Adding Attachments to an Email
how to export to excel?
Programming navigation button off and on.
Ctrl Minus revistited
LOCKED OUT
releasing new code
question re: acQuitSaveNone
Error Msg stLinkCriteria
Text not selected in forms memo field - how ??
calling sub-routine
learning ADO; finding a record
Form Control Source
supress an error
LDB file
Errors using ADO, running Excel automation
FORM button If then else statements
Coding Problem
Subform refresh
setting the path
Set visible control in continous form
JPG's on Access form and printing
Error 3045 when linking to a table dynamically
Update Underlying Table
add a help for a form control
How do i link one box on a form to two databases?
Dlookup
Form coding Help - Part 2
Detail Line objects problem
Using a Check box to lock fields
copy text in textbox to another textbox on click
I.D. or color code a file folder
Set Filter problem
Orders Form / Mutiple Order Types
Required?
Hide Windows Toolbar
Sort a collection??
dcount syntax
Count Zero or less
Getting the focus to stay in a field
Form to view older values.
Here's a basic one
SendObject Action
Combo Box won't accept selection
Using a Timer with Registry
Access97: Combo Box and FE/BE split
code to delete a record in one subform when a record in a related subform is deleted
stLinkCriteria
Subform Problem
Passing data from a subform to another form
insert a watermark to a excel spread sheet
Adding a file path to a form field using CommonDlg
Determining current file size
Set focus
Custom Help Context ID in subform
Make a button active only when user is on last record or form
Skiping code?
Dsum adds the same record twice
open access VBA shell command without Netmeeting
Date Picker - Question
Locating Add-ins Path
ControlTip text based on data in control
Select Case fails to find record
Hiding subforms
Formula's to show a next calculated date in a record
maximize a form
FollowHyperlink and form positioning
2 Questions: Create Error Pop-Up
Need help with a strange problem
Border goes Solid on Conditional Format
coding question
Test if subdatasheet is expanded for a particular record
Updating Entries Without Duplication
getting printer settings for access form
If the user finds that the data required is not in the combo box .
File name as text box name
Trim spaces in SQL
how to populate the selected item in listbox in text in MS-Acces.
Porting app from AccK to Acc2003
Sub routine jumps to wrong place
calling subroutine
Error 2486: You can't carry out this action
Getting limited records..don't know why
paypal salvation is your's
e-mail and to play in a table.
Serial Date
Option Group Control
Bind a calculated result in a form to a field in a table
Detect Table
Adding Records to a table
Disable scroll w/Mouse wheel
Error (2450) when changing a forms recordsource through code
Adding Records into two tables, I think...
The data has changed...
Opening Word Document
Latency Dropdown Control
Moving Containers
Containers in Access
Update on command
locateing an item in a combo box.
Data Entry mode does not work in subform.
How to write this code for an event procedure or query?
center form?
layout of a field
Screen Resolution