|
Email out from Access
Hi,
Is there a way to send an email from Access. I am building a form that
gathers information from a user. All information are kept in one table. I
would like to have a button within the form that will send email to a
specified email address. How can I do this?
Thank you,
Boon
...
|
2 |
12/3/2008 8:54:41 PM |
|
|
List all control names
Hi there,
I have created a database that has login names and users. In this
database, I have a datasheet form which can allow users to Hide/Unhide
columns using format -> Unhide columns. I am trying to make the
database remember which columns were hidden by which users so that the
users don't constantly have to hide/unhide the columns they want to
see.
My approach to this is the foll...
|
2 |
12/3/2008 8:40:48 PM |
|
|
How to find out what events are firing?
I just started getting a 'no current record' error on an ApplyFilter
statement (it worked fine before). However, the actual error is elsewhere -
in some event being fired. I know the Current event is firing but I think the
error is somewhere else. How can I find out where? I tried setting a
breakpoint and stepping through but it always stops on the ApplyFilter
statement and says "you can...
|
3 |
12/3/2008 7:50:39 PM |
|
|
Combo box sync
I found this code a while back and cannot get it right. Please help!
Private Sub cboClient_AfterUpdate()
Dim sRS As String
If IsNull(Me.cboClient.Value) Then
sRS = ""
Else
sRS = "Select InvNum,Service,StartDate,EndDate,JobLabor from [tbl 2
Job] " & "Where ClientID = " & Me.cboClient
End If
Me.cboInvNum.RowSource = sRS
End Sub
When I select the...
|
3 |
12/3/2008 7:42:46 PM |
|
|
dlookup and 3464
I have run the following "event procedure" from a combo box and am
getting a "data type mismatch error: 3464"
Private Sub ModelRetailPrice_AfterUpdate()
Forms![frmQuotes]!ModelRetailPrice = DLookup("ModelretailPrice",
"tblModel", "ModelID = " & Forms![frmQuotes]!ModelID)
End Sub
I am trying to populate the field [frmQuotes]!ModelRetailPrice with
the ModelRetailPrice from the tblModel ba...
|
5 |
12/3/2008 6:19:57 PM |
|
|
Filtering based on a Text Box,
I have the following code for a filter based on an unbounded text box.
If Not IsNull(Me.DescriptionFilter) Then
stText = Me![DescriptionFilter]
StCriteria = "FCSI_Description Like *" & stText & "*"
'Sets the filter fot the priority selected on form
'If priority is not set, no criteria is enforced
End If
The text box is named DescriptionFil...
|
3 |
12/3/2008 6:13:01 PM |
|
|
Access 2007 Conversion Issue
Our company is getting ready to upgrade to Office 2007 so we have been going
through all our files with VBA or Macros to make sure they will work. So far
we have found only one that is failing, but it is beyond me why it is. One
of my coworkers has a database that uses a VBA event to open an Excel file, I
believe to make a few changes to the columns and then import into the
database. ...
|
6 |
12/3/2008 6:07:01 PM |
|
|
Bypass the first time user ID dialog with Access 2003? (2nd request)
I'm setting up users on a terminal services box (windows 2003) with an
Access 2003 application. For each of these users, the first time they
run the db, it's also the first time they've run Access on that box, and
they're asked to provide user name and initials. That's an Office thing.
How can I make that dialog go away without the user seeing it? There
must be a registry setting that I ...
|
1 |
12/3/2008 5:38:15 PM |
|
|
Changing color of a textbox in a subform
Hi Guys,
I am trying to change the color of a textbox in a subform, but so far with
not much luck.
The code that I am currently using is:
Me.textboxname.backcolor = 255 'To change the color of the textbox to red
Me.textboxname. value = "changeme"
The 2nd line of cocde works but unfortunately I cannot get the background
color to change. I don't know what I am doing wrong.
I have ...
|
9 |
12/3/2008 5:37:35 PM |
|
|
Me.RecordsetType and NewRecord
I want a form to be kept sort of readonly until a newrecord button is
pressed:
In Form_AfterUpdate() I use:
If Me.NewRecord = True Then
Me.RecordsetType = 0 'Dynaset
Else
Me.RecordsetType = 2 'Snapshot
End If
Then, when the button is pressed I use:
Me.RecordsetType = 0 'Dynaset
DoCmd.GoToRecord , , acNewRec
Then I get the message that "you c...
|
7 |
12/3/2008 5:26:57 PM |
|
|
Controlling Columns in Datasheet View
Is there a way to control which columns the user displays in Datasheet view?
I have certain fields hidden, and I want to prevent the user from being able
to display them by going to Unhide Columns.
Is there any event that is triggered when the columns in Datasheet view are
changed, or is there some other way to control which columns are displayed
in Datasheet view? I'm using Access 2003...
|
9 |
12/3/2008 5:15:00 PM |
|
|
go to specific record in form
Hello!
I have a form that users use to enter inspection data. The unique index is
based on a combination of two fields, LotNumber and SubLot. If a user tries
to enter a LotNumber and SubLot number combination that already exists a
message box pops up telling them that. I want them to be able to find that
record if the combination already exists. I have added two text boxes and a
c...
|
3 |
12/3/2008 4:43:01 PM |
|
|
Field Color not changing using Conditional Format or On Not In Lis
I've got a single form with a combo box field ([Combo_NSFCertified]) whose
control source is a field from a table. When the form is opened I want the
field background to be colored red if the value of the field is not one of
the acceptable values from the combo list. I've created a hidden text field
([NSF_Certified_Unmatched]) from an unmatched query, which compares the value
to the acce...
|
5 |
12/3/2008 3:19:01 PM |
|
|
Command Button to Find and Filter Records
Hello,
I have Access 2003. I have a form with a Find Command button. When the
user clicks on the Find button I need it to prompt for the file number.
Then, when the enter a number like 5666533c it should filter for all records
like US5666533c (e.g. *5666533c). Below is my code. The results now finds
the exact number, but it's not filtered and I can scroll to other numbers.
Dim...
|
2 |
12/3/2008 2:34:10 PM |
|
|
Record Selection in a Form
I am using 3 subforms, 2 visible, 1 hidden.
frmFilters is a filter selection form.
frmArchives displays all records (abridged) in a continuous form.
frmArchiveTicketDisplay is a single record detail viewer which is hidden.
The filters are working fine, allowing multiple filters.
I am trying to write code so that when you doubleclick the PrimaryKey in the
frmArchives, it populates the rela...
|
1 |
12/3/2008 12:25:02 PM |
|
|
r3m5p3p6t
Hello evrybody
I have created an application with forms, Macros , as well vba codes
(modules) and SQL request ) under access 2000...i'm a beeginner in Access
and VBA too.
I used an AutoExec Macro wich open a form called 'Menu' at the opening of
database .
This is the code that allow me open the form :
----------------------------------------Begenning of Code
Once the form opened ...
|
3 |
12/3/2008 8:34:26 AM |
|
|
performance between recordset and dlookup
I have a report to support 2 languages.
I have 2 languages in the table and retreive depends on user prefer
language select.
The report has more than one hundred labels to print.
I would like to know to use Dlookup to assign label caption or using
recordset to get data in one shot and assign the label using tag
property.
I know that I can do some testing to compare.
If any one ...
|
6 |
12/3/2008 2:21:52 AM |
|
|
Combo Box for Data Entry
I have a form that I use for both data entry, editing data and finding
records. In order to use the form to find records I set my recordsource to
the table I am editing.(For the record the table is named tblFactory)
I have a separate table with Country names, It has both a 2 character
country code and a longer contry description. This combo box is based on
tblCountry. This allows me to ...
|
2 |
12/3/2008 12:35:00 AM |
|
|
Problem retrieving data from a subform
Hello there,
I’m working on an application that will be used to register people. The app
is somewhat complicated so first I’ll explain what the app does (or is
supposed to do) and then I’ll explain what the problem is.
The registration process is performed in two steps, each step being done at
a different physical location (in the first location a new record is created
but it ...
|
2 |
12/2/2008 11:00:00 PM |
|
|
If msgbox is yes then checkbox is checked?
Hi there
For some reason i cant get this code to work. On the "On Close" action of a
form, i want a checkbox to pop up to ask whether the data has been changed,
if the user chooses yes then i want my "revised" checkbox to populate with a
checkmark
'If MsgBox(" Have you revised this data?", vbYesNo) = vbYes Then
'Me.chkrevised = True
'End If
It doesnt seem to work, not...
|
6 |
12/2/2008 10:51:07 PM |
|
|
List all control names
Hi there,
I have created a database that has login names and users. In this
database, I have a datasheet form which can allow users to Hide/Unhide
columns using format -> Unhide columns. I am trying to make the
database remember which columns were hidden by which users so that the
users don't constantly have to hide/unhide the columns they want to
see.
My approach to this is the foll...
|
1 |
12/2/2008 10:12:49 PM |
|
|
Cancel BeforeUpdate Subf on Form Close
I have a Form BeforeUpdate command that displays a msgbox when certain fields
need to be updated before the record changes. However, the msgbox displays
also when closing the Form and it requires an individual to click ok, then
closes.
What code can I use to disable the whole sub on form close?
Thanks. ...
|
1 |
12/2/2008 9:45:02 PM |
|
|
set listbox rowsource from a command button
I'm trying to adapt Allen Brown's flexible search form dynamic criteria
builder to set the rowsource of a listbox. I've put the code in the Click
event of the command button. The strWhere is building correctly. My
question is where do I put the Listbox.RowSource = "Select field1, field2,
from table1" and how do I include the strWhere to filter the results?
Everything I've tried so fa...
|
1 |
12/2/2008 9:03:01 PM |
|
|
new Record
I have having issue storing data into an Oracle database.
I created a form(unbound fields) to capture the data and then send the data
to a similar form(bound fields) for final storage into an Oracle database.
Every is good except that it will not store the data unless I make a manual
change to the fields.
Am I missing something? Is there a way to store the data when I am ready?
...
|
8 |
12/2/2008 7:58:13 PM |
|
|
How to mark record as readed ?
Hello,
I have a screen let the user data entry/update record. This screen is
bounded from a table called Temp1.
Situation: table temp1 have 100 records. User edit some record (10 records)
for today.
Tommorow, she come back and edit next record (record #11).
How can I do that with link ODBC table ? or How can I design on the screen?
Thanks you for all reply.
...
|
1 |
12/2/2008 7:52:00 PM |