Microsoft Access Form Coding [Archive]

Data Entry VBA
Data entry for a table from a form
Sort of list within list within list
Calling Error Handling in VBA
Using "tiles"
Re: VBA code returns no records hwenKey ID is added
color coding values
Re: Project is unviewable
lookup question
Calendar Control - help to avoid resetting to Date() ?
Order of Events
display attachment control in report depending if empty
type mismatch
Re: Applyfilter
Coding wildcards in search criteia
Additional Code for Idle Time VB?
Form to LoadingForm to run Queries for Report?
Lookup current record with ComboBox, any changes create new record
Create / Edit a Manu Bar in Access 07 or 10
Re: main form/subform
Combobox Select All?
Getting a caption without naming the control
get machine specific from network
Insert Picture Ccommand button
Creating a new record but passing information
Sort in VB using a ComboBox Column Other than the Bound Column
LIst of KeyCodes
Passing the value of ActiveControl to Unbound Text Box
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has an IDENTITY column
Help needed passing data from the form to a table.
duplicate form after selecting value in combobox
Re: Can .PST file size be reduced? How? Not by "compacting' them.
Connection Error (3709) in Opening Recordset
DCount alwaysreturning 1
Cannot find C:\OEL.mde
print a pdf file from a table link
Storing Rich Text and using in Access and Word
another find as you type question
Find as you type question
Stumped By Dates
Access 2007: Help filtering a report query based on a form field
Return values based on 1st column
adding a run macro function
email subject line
email subject line
Dynamcially add a field to a query?
Combo box blank due to record source query only selecting records marked as active
linking to SQL Server db table
Adding records relating to intervals between two dates
Plz Help! Create table when submit form
DoCmd.GoToRecord , , acNewRec is not working
Search combo box
My function returns the string containing field names rather thanunderlying values.
Access 2010 eval copy
Folder access (Access 2003) - II
Re: Turning Check Box into a Button
Re: Trouble Filtering a Sub Form With Combo Box
Re: Turn Off Action Query Notification A2007
Why wont the Wildcard * work in this?
Re: Month of year in code
Re: Month of year in code
Select Specific Fields of Query Based On Variable Field
Need help with Form objects
retrieve name of object user clicks on
Execute code from string
Access 2003 --> Access 2007 code no longer working
proper code placement
Open Windows Explorer at specific filename
Re: Access Combo Box question
How to get Smart Tags to populate multiple fields in Outlook?
pure time format
List box loads slowly first time but quicker on subsequent requerying
Folder access (Access 2003)
Calendar help with dtCriteria1 = StartDateCalendar.Value calendar
Access 2003, how do I know if a listbox has no row selected?
Can't seem to retrieve primary key number of newly created record in VB
Create a SubForm on a Tab Control
What is wrong with this?
How to code report to automatically zoom to 125%
Page Header text
Coversion to A97
access 2002 report header
List Boxes - Access 2003
looping through a continuous form recordset
Growable Text Box in Report
Re: AutoExec - Delima
proper control names
...Regarding the CHANGE MAKERS...
Runtime error 3734
make field invisable
formatting a number in a text box
Print Labels
Re: Brackets in A Query Criteria From a Combo Box/Text
update time value issue
Import Spreadsheet Problem
Address selection on combo box help
OpenForm and Navigate to Subform Record?
Testing for required data entry in form fields.
MS Access DTM Picker - Query - Reg
trying to close a form
write conflict
Database crashes on entry into API Macro or Visual Basic in WindowsXP but not in Windows 7
could not lock file
Fire up IE7 by clicking hyperlink field?
format phone field
Trouble with the following
trouble with QBF and multiple choices
Inserting information to a table on form close
Referring to control in the active subform
filtering a form based on a filter on an open form
The objest was saved in an invalid format and cannot be read
Combo Box case sensitivity
upper case - lower case issues - dropdown box is case sensitive???
Code help
pass throught query by parameter
round up to the next 1/2 kg....formatting
round up to the next 1/2 kg....formatting
round up to the next 1/2 kg....formatting
round up to the next 1/2 kg....formatting
round up to the next 1/2 kg....formatting
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an IDENTITY column
After Update: Pay Period Date
Confused about setfocus
when to update and when to leave alone
DoCmd.OpenForm Suddenly Fails
Assigning specific record data to fields on a form Access 2003
if a # then sum, if text leave null
If null then update
COMBO BOX vs Uppercase
Control location on screen where form opens?
DLookup Syntex error it is killing me
Changing Bound Text Box Border Width Property Screws Up Tab Order
Select Found Subform Record
VBA code issue...Would love expert help.
Inconsistent Add Record Performance
Copy value of primary key to field in continuous form
Re: How to do Make A Report
Error 3044 'Z:\xxxxxxx.mdb' is not a valid path
Pls Help - default value in a subform
simple formatting
pasting unwanted data
Input a value in a form and display in a report
Hoe to Close a NoData Report
Resize Form With Vertical Scrollbar Problem
Center the forms controls on screen on maximize
Question about charts
Summarizing control based on unique values different field
Filter main form to records with no related records in subform,maintain updateable recordset
Re: Launch a URL and paste
Restrict subform from accepting new records
Can I hide/remove the field that joins subform to main form?
2 actions in one procedure
2 actions in one procedure
Simple Auto increment
Re: Update Field By Code
2 options based on result
ApplyFilter gives error only when subform is placed on main form
Posting a dataset to a SQL table using VBA
Re: Subforms within a Tab control
VBA code - Access 2007
Fax Individual Report via command line
Access 2007 suddenly stopped working properly
Access 2010 Visible Property having no effect
Access Form coding question
any function key combination to access my function definition
Run-time error '9' when calling LBound on a dynamic array
Rererencing a Control in a Form
Referencing to a control on a subform
Auto increment Not Functioning Correctly
Duplicate record in Form and Subform
drop down box issues
I am Going CRAZY
Apply Multiple Payments
Copying Data from a subform to another form
updated field
VBA Macro Copy Table and Increment by One Letter
Hide textbox on a record - Continuous form
Need loop help, add records by field that match query records
Return 0 when value is Null
DoCmd.RunSQL - Need help!
Setting field value if a value exists in another table
record set for pass through query
Update multiple record values from form/query
Update multiple record values in form/query
Update multiple record values
Update multiple record values in form/query
Update multiple record values from form/query
Update multiple record values from form/query
BeforeUpdate to determine length of entry and allow or not the entry
Help Pls ? Continuous Form Forecolor change
MS Access 2010 runt time version
how to run several different functions at form open?
form objects lose association with VBA code..
Weeknumber and date
subform in Continuous Forms
details record on the form
equals the same otherwise give an error message
You know you're from Louisiana when
lookup then set a filter
Automating Access: running your own functions/passing arguments
MDE problem
passing-parameter-url-without-username-password
Deployment and Package Wizard Problem
formatting questions
allow additions confuses user
if equal open form otherwise update with message
is Null then update problem
migration performance question
Multiple Subforms in a Tab Control
insert sql form-subform problem
Pause vba execution
Use Public Function UserName to populate Form field and bind it to table
Auto-expand page header of report in response to test box "can grow"?
Formatting decimal place with form name etc.
duplex printing
Re: Unbound control on continuous form goes blank
Unbound control on continuous form goes blank
Access Form - Dynamic Selection
Access 2010 Application Parts
access database form problem
Find Matching / Duplicate Data - Please Help
HELP! Baffled by Syntax error resulting from INSERT INTO
open a form if user inputs specific text
fomatting vol wgt in kgs from cm or inches
emailing a multi-page access report ??
Re: hiding "text" for null values
hiding "text" for null values
formatting decimal places
summing 2 different totals in a continuous form
formating an unbound text box
Re: datepart function
datepart function
Keep form open until loop completes
Combo Box help
set as default
extra record in continuous form
pull the higher of the two values
rounding up a number
When record Deleted, also delete file connected to a link
VBA to change database password?
Count or Detect Graphic Objects in an Excel Spreadsheet Opened in Access?
Combo Box Showing only bound column when choice is made -- the new normal?
Verify existence of a field
notationproblem textfield
Re: filter on combo box possible?
filter on combo box possible?
INSERT INTO not inserting anything into anything :-( !
Strange value added to table
Volume problem
view format problem
field formatting issue
Re: Text box changes from code. What EVENT fires?
read text file
E-Mail Addresses Problem
Finding hidden objects in Access 2003
Read and save MS Outlook attachment
Help with searching in a string
Not All Fields Update my Table from my Form
Re: Access 97 database error after standby mode
Requery Not Working According to Plan
report fields
If Statements
Access 97 database error after standby mode
Re: How do I Link...............
Re: Dir and FileCopy don't work???
Re: AfterUpdate Question
hiding an open form
Checking wether a karakter is a number
Re: format text box
format text box
windows open and close
Re: 13 - Type mismatch
save file time
input mask issue
Formatting combo box drop-down list
find file exists
save voice file
BARCODE IN ACCESS
Storing E-Mail Addresses in Access Tables
BeforeUpdate and KeyDown
continuous form & extra record
Re: 13 - Type mismatch
Implementing public VBA function in Access 2003, passing multiple parameters
Re: Split statement error
Re: Split statement error
E-Mail Addresses
Using VBA to Copy Rich Text Cell Data from Word Table to ADORecordset Field
set DateTimePicker value to null issue
check form open and bring it to front
set focus to control on subform
Report VB Code
sync data on data field from key field in the sub form
Combo box Selection
a control for time
disable pop up box
VlookUp or something?
email from text in a form
can shrink / can grow
how to toggle between windows
Snap to Grid - where did it go???
Worked in Windows 2000 but not XP
First Effort Using VBA Code on ComboBox
Set dynamic reference to a control in a public function
expression in SQL works in control property but not in VBA
How change Report's PageHeader Height programatically in PageHeaderSection_Format?
The Remote Server Machine Does Not Exist or is Not Available
operation must use an updatable query
execute a query
Can't cancel an automatic Access message
Strange behavior and Error 2105 when oncurrent event cycles
how to determine if the rows selected in a simple multi-selectlistbox have been changed?
Cancel timer event if criteria not met
Clicking label makes Dirty property True
Re: Edit records in a subform
Cancel = True "variable not defined"
Re: RecordsetClone & Bookmarks
Inserting a beginning record in a subform
Default date
space limitation for MS Access front end application
How to Build an SQL Query on the Fly for Data Export to Excel
Re: Filter & Requery Subform
Re: error 3061
Need help changing focus between open forms
Open form relative to another form
Re: Arithmetic with "Double"
Re: Record Deliniating
Re: PROGRAMMERS - We could all use a good laugh
Re: PROGRAMMERS - We could all use a good laugh
Formatting continuous form field in current record only
subform to change from combo with csv source
Close popup form from a continuous subform
erratic OpenArgs behavior
Access 2010 is a disaster
"On Current" event and ActiveX controls
"Cannot open any more databases"
Managing Sequence numbers between 3 sub forms on 3 tabs populated bythe same table
Update a date field in sub-form from dates fields on main form
Criteria when opening form
Update a table using the table as a recordset
Restoring line breaks in memo field
Dlookup only returning the first record
Re: Setting a subform's SourceObject to a member of a collection
Re: Copying a field from one form to another by code.
Setting a subform's SourceObject to a member of a collection
Command button stops working when code is added
Help - onclick sub never runs
Re: Properties search (a la Speed Ferret)
Re: Properties search (a la Speed Ferret)
BeforeUpdate Problem
selecting a record from continuous form
Re: Definitely more sparse code, but negligible difference inperformance.
in range and pause
DLookup not recognizing variable
how to display day of week
Parameter query
INSERT INTO from query
Password HELP!
OWC (office web component ) chart , stacked XY scatter
Adding Records
Creating unique calculation form pop-up
The remote server machine does not exist or is unavailable (Error 462)
Replacing DCount With SQL Statement
Instant Totals on Continuous Forms
Total in Continous Form
action query message
Send subform datasheet with Formating to Excel
Help! When running SQL statement string treated as expression - whatis the cure?
Requery main form after subform update and not lose place in main form.
NumLock Key -- Keeping it On(?)
link excel spreadsheet
needing to convert?
getting subform information
ADODB code problem converting to Access 2007
Return query records in groups of 500
comparing fields help needed
subform
text box select text
Form: OrderBy minimum of fields
Cannot access foreign database Msysobjects - No read rights
Exists() function seems broken.. Any help?
Exists() function seems broken.. Any help?
get access edition
Tables/Queries Exists() Function
stLinkCriteria Statement with multiple criteria
function use with table
Re: Part of a text field
getting type mismatch
Re: Batch loading file names into a text field
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff.
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff.
just a general question
remembering the amount
disk or network error
link table using UNC
Refresh data in sub forms when one sub form is edited
Run a query after selecting from combo box
main form and popup
reference table and where condition
needing IF help
Access 2003 and SQL Server 2005 and DAO recordset
Delete is not happening
Unbound continuous form?
Re-using a recordset
Can I reference only detail fields?
smtp email
referenceing tab control tabs(pages)
subform total to mainform
using sql server function
Tablet PC / Access 2003 and Capturing Signatures
set text box run time
Can't get text box on report to display all of text.
update textbox with total
calling sql server 2005 function in access
Sort form records by field looked up in another table
textbox event
Filtering and Removing Filter based on a combo box
calling/using a sql server scalar valued function
textbox - combobox
Before update, after update or change event? or does it matter?
Avoid duplicate names/entries
Stop all VBA code running
Office 2002 to Office 2010
How to Drag and Drop text to a text box?
overwriting rows in a table
Access Returns different values if code is run from "close" event
Multiple Ribbons
Query, filter and math
[Access 2000] Images on Form
Compile Error Help
Enter Parameter Value popup on going to new form.
update query null issue
needing help with loop issues
Attachment datatype linked to a ComboBox
subform LostFocus
Mark duplicated records for deletion
Form Problem
In a Control: Type some text, then hit a hotkey to append more text (?)
Re: How to copy current db
How t o reference a specific control from a function
Re: Cascade deletes temporarily
Pass a control.value to SQL statement??
Why does me.requery result in "no current record"
limiting the number of login attempts
Winsock control
Send Multiple Emails from Form
Trouble with my data parsing
Why "no current record?"
Sizing continuous form
Reference an open recordset in VBA using SQL
Does Filteron = True provoke Form Current event?
Filter for Dates and/or text is same statement
If I open a form, add a new record, close the form (without saving or changing records) will it still save the new record?
Tables("MainTable").mycombo = Me.CurrentRecord.IDField ?
help information using F1 key or special key
Specify the Access application window size
yes/no and byte field type
Locking Down Database but still be able to use Pivot Charts
How to use Optional parameter?
Passing a UK Date to SQL statement as criteria
move combo box with button
SQL Syntax for multiple table joins
I can identify this month (Month(Date())) but how do identify this week?
Combine two records in a table
Correct test for an empty date?
Can't get the code to sort the data properly.
You can't assign a value to this object
import a text file in to MS Access table
Disadvantages to using variant datatype?
task schedule to run MS Access
Populating fields via a Record Select Combo
I want to set some menu options is that possible?
Is it possible to open MS Word merge from Access form????
What will happen to this newsgroup?
Supress "Opening this document with run the following SQL command"
Is my Error trap working???
Pass criteria to a query design
OrderByOn = False
Event Timing OnDelete
Data parsing
How can I switch errors back On?
If I use a filter on my form, will the recordsetclone reflect the filtered form or the unfiltered form?
How Do I exit/stop/end execution completely???
What is "the access way" to validate a form?
Is Form Load event first????????
How do I move existing textboxes onto a new frame?
I'm not sure how to return the value using the SQL statement?
What is "the Access way" to delete a record from a form?
VBA to split name ?
How to interrupt a form close?
Trouble with reference to Microsoft Access 14.0 Object Library
Connect to a back end in code
Using an Access form to Mass Update a table
Can combo box be wider than its owner control?
How to switch combo boxes?
Ways to put code into a subroutine?
How would i refer to a closed report?
Anything obviously wrong with this code?
Subform how to
Parameter query prompts twice
A2007 working with Outlook 2007
How do i refer to a query?
Combo Box After Update Problem
read ODBC Connection
Me.Recordset vs a recordset variable.
Old db Name in "Compile"
Dynamically creating rectangles at runtime
How to get the value of non-bound combo box column?
Invalid use of null
Why two rows in the form and only one in the recordset?
Current is executing before Open
Why "no current record" when there is a "newrecord?"
controlling outlook from access 2007
How to change contents of combo box?
using active directory
Using a Form to Mass Update a Table
Records aren't being retrieved.
Data doesn't show up in bound fields
Sending Emails With Attachments In Access
Should I re-create criteria using form filter of just use the relevant query as recordsource?
anyone come up with google type auto complete text box
changing to a function or sub
Microsoft Access HTML Viewer
Remind me folks - what is the event that fires every time the record changes ( i want to display the record number)
I have value list for a combo - the source is "Level 2";"Level 1";"Entry 3";"Entry 2";"Entry 1".....
printing from multiselect listbox
Open a database without running the main form?????
DBF linked the problem blocked
error 3188 record locked
'Triple state grey' versus 'use windows themed control on forms'
Two few parameters. Expected 2
I have this error. how do I fix this?
Re: Unable to extract records filtered in a datasheet - Access 2010
moving _be to sql server 2005
Design of a simple sales entry database form
tab index
user design IDE
multi thread application
Buggy selection in form.
using web services
syntax docmd.openreport with more criterea
NotInList help
checking subform for records
Basing a subform on a selection from either of two subforms
Microsoft Web Browser / Adobe PDF Reader OCX Controls
Pass Subform filter to subform in report
Look at value of global variabls in debugger?
Help! code in "Form_AfterUpdate()" prevents saving of record
going dsn-less
Need help on auto pop through a form
How many parameterscan I use in a Query?
Grouped Controls In VBA?
ODBC Update on a linked table 'table name' failed
Double definition
An interesting problem I am having
Ceiling function
dsn issue with windows 7
On Click Function Open Different Forms
=CStr([Recordset].[AbsolutePosition]+1) works, and doesn't work
error message
Access2003 to 2007 problem
Microsoft Web Browser
transfer data between forms using Macro and VBA
access 2007 and windows 7 issues
Start Earning $15 - $105
pop up box message
Networkdays Conundrum
memory not enough error message
list box bound column
needing UPDATE assistance
Help with WHERE filter on opening report from dialog
counter function
Combo Box Choose Record Problem
Refer to a subform
puzzling data mismatch error
How to enter multiple RTF lines in memo text box
Spell Check specific fields on a subform
Exporting curretn recordset to Excel - only working first time!
Re: Automating 'From'
Text box with help instruction
Can not get size of list width
Open form to ID and add in the record if not there
Australian dates in access
NumLock
Combo box causes crashes
Data Entry = No
Forms acting strange.
Closing Access While Form Is In Print Preview Does Not Trigger Form Unload Event
looping thru a continous form
2 list box iteration
Re: Number Error Problem
Tracking changes to a form's fields---still searching for an answe
create a form that collects parameters
Login with pwd & Open the main form depends on pwd
Set focus
RE: After server upgrade some command buttons do not work?
recording the print date
Tracking changes to a form
OutputTo isn't avaialable now
Adding a command to a picture
Show only queries w/table source combo box
Testing numeric input
shorter method than elseif
Multi-select list box for multi-column query
Delete code competing with BeforeUpdate validation
Add totals of record type to a form footer.
AutoNumber, messed up sequence, duplicate values.
Re: Dlookup related records
Why is my DB always crashing when clicking the dropdown on ComboBo
Locing records i nmulti user
Database crashing
coding between subforms
read focus of controls
How parametrice query by selecting the row
RE: Apostrophe Problem
Change GROUPING programmatically in reports
Employee Time card form
Pass a String Var to a Function
Subform Code Question
MoveNext
Continuous form record number
Can not choose in combo
record Locking multi user
More efficient code for multiple If...End If statements
How to rip DVD movies and convert video to ipad
Syntex Error
Combobox and error 3314
Re: Help with Relationships please
Want to avoid the possibilty to edit field in listbox
Calendar and Calculator Controls
Problem refreshing subform
Matching from a form to a subform
How do I use Access 2007 VBA to print external pdf files?
PopUp Form Help
button and path question
Annoying Data Type Conversion Error
Error 2147352567
Export Table Records to txt file
Auto Increment by 1 Letter
Auto Increment by 1 letter
Help implementing Steven Lebans' Get/Set Scrollbars with GetCurren
Auto increment by one letter
Any suggestion for Access forums after June 1?
Richiesta salvataggio modifiche in una mascehra
label formating
A Great Big Thank You!
Filter List Box
RE: label formating
Checking a forms fields for null
RE: Richiesta salvataggio modifiche in una mascehra
Calculate conditiona total at bottom of continuous form.
Syntax error in Update statement
RE: label formating
Date Differences in Years
How can I scroll page up/down with arrow keys
Breakpoints Window
Images won't print on extended form
Re: Conditional Formatting Need for more than 3
we hoping dat you kan give up 100$ to roshankaiburns@hotmail.com
Refer to SQL statements globally
Assigning work to team 1 and team 2
datetime field display
Webbrowser Activx Control
Canceling an OnClick Event
Please Help!!! Macro required to select new record in Subform
Pop up form closing - required/validation code
Pop up form closing too soon - required/validation coding
HELP: Compare Column values with column names in different tables
Re: Macro for Opening an Excel document
List Box to create a Report based on crosstab query
Form_Delete event can't fire requery in other form
Double_Click Control Event firing too soon, why?
return Subform Name on Tab control
Help with dCount - “Data Type mismatch in criteria expression”
Error 2465; Can't Find Field
Allen Browne's Recurring events
Adding data in a continuous form
How to add record in Subform which is in another Subform
Combo Box Auto expand List Width
On Close assign a value
Re: Business days code
Objects on form are hidden
Using text field to display images on a form or report
Custom Record Selector Controls that don't work like the built-inones
Need to change Data Entry to "No"
Check for duplicates with multiple criteria
How do I call a procedure in Main form from sub-form?
Referring to text control in a form
Bound Form Search
Display msg when value chgs to zero.
Display data in a subform
Using atachment fields in a form
switch to split form from single form with code
Recordsets-Old and New
error 0
Buttons for multiple subforms...?
Stephen Leban's Conditional Formatting
Filtering, RecordsetClone, Main Form - Subform Issues
Allen Browne’s Name table design
Column Orders
Moving The Cursor By Code
Display Name of Field from 1 form in an unbound box on another for
Open Add Printer dialog...
how to trap the sort event?
list box remove item
Cant get reference to subform properties in VBA
Getting the auto generated number.
DSum and Dlookup issue
How to Show Form ComboBox value into other Form Label caption
archiving data
FRUSTRATED: Enable field depending on value of another
Sharing VBA Code between Word and Access 2007
Win7 taskbar prograssbar from VBA
How prevent input mask appearing in locked date field?
list box requery
synchronizing Combo boxes
choose function
Tracking changes made to a field on a form
The data has been changed message
Running tally on form
Invalid use of Null --> Help Please
Using Access to create an appointment and add attendees
Actioning Icon
Re: Option Group Type Mismatch
DISABLE printing by Ctrl-P
=Len(Nz(Me.txtAuthor, 0)) is returning 1 even when the field is blank !
simple ?- unable to edit text box quandry
code to use Acrobat menu?
Option Group Type Mismatch
Linking Powerpoint show to a button
Access 2007 and Cancel Key - Strange behavior
Page visible when check box marked
Re: Business days code
Re: Business days code
Check boxes - Can I intercept the checking of...?
RE: auto date not working
Re: auto date not working
Suggestions
Operation not supported in transactions
How to change existing table record value by VBA and How to add newrecord in existing table by VBA
Populate date to another
Problem with Combo Box FindNext
Change Forecolor based upon if statement
Using textbox using a variable
Invalid use of Null ----> Help Please
RunTime Error 3070
Help with code --> Invlaid use of Null????
designing form for inserting records into separate table
Re: Use DB for a limitated period of time
Working days inbetween 2 dates where Friday is the only holiday
Filter Subform