General :: Auto Email After User Input

Jan 10, 2013

Access 2007 DB. Is there a way to have an auto gen. email sent to me and or other admin. After user has completed input into form...

View Replies


ADVERTISEMENT

General :: Auto Sending Email With Wrong User ID

Jan 21, 2013

have a vba code written to have my MS Access 2007 tell Outlook to send an e-mail with several attachments to whom it may concern, but I need it to change the "From" field in the e-mail, because there's many people who can send this, but it's looking like it's all being sent as my user. This is the code, it all works, but it doesn't change the sender field. Should I make some sort of auto-login macro or something?

Call fctnOutlook("Reconsideraciones BCH", EmailTasador, Email, , Subjet, "Agradecer revisar la tasacin indicada, de acuerdo a lo pedido en email adjunto, y me des tu opinin. " & vbCrLf & vbCrLf & "Favor no responder a Reconsideraciones BCH, no recibe correos es solo para enos, enviar a visador indicado en el email" & vbCrLf & vbCrLf & "Le saluda atte." & vbCrLf & vbCrLf & usu & vbCrLf & "Seccin Tasaciones" & vbCrLf & "Banco de Chile" & vbCrLf & vbCrLf & vbCrLf, Nz(Tpath), "Yes;No;Maybe", 2, True)

With objMail
.To = EmailTasador
.CC = Email
.Subject = Subjet
.Attachments.Add (Tpath)

[code]....

View 2 Replies View Related

Auto-modify User Form Input

Feb 2, 2006

I have a form where a user will enter a 11 digit number (12345043456). Using ASP (VB) this string of numbers queries an access database and returns the entry for that specific number to the user.

Unfortunately, the numbers in the access table are an 11 digit number with hyphens seperating the string like this 12345-04-3456 (the ndc # of a pharmaceutical).

So What i need is some code that monitors and modifies the form input so that the hyphens are added in to the string when the user is inputting the data.

If i cannot do this, then is there some VB that I can add which modifies the field in the text file when it is imported into access on a daily basis.


Thanks
Terrons

View 7 Replies View Related

Tables :: Auto Calculation In Sum Field After User Input (numbers) In Fields

Dec 28, 2012

I have a table, at the table I'v got these fields:

ID | num1 | num2 | sum

I want that the user put numbers at 'num1' and 'num2' fields and then the 'sum' field will calculate automatically the operator (sum=num1+num2).

I've tried to put any combination at 'Default value' of the sum field (all the fields are numbers , also tried to change the sum field to text...nothing works).

I'm getting a message that 'num1' field is not recognize at the table

(I tried =[num1]+[num2], without the '=', num1.table+num2.table , ...nothing works)

I also tried to do it with SQL command but it dosn't work.

There is any way to do it, is it possible? Or other way to do it at least at Form or at Report ?

View 7 Replies View Related

General :: Combo Box To Show Name For User But Input ID To Tag Table

Jul 14, 2013

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields:

uid, uname, city, state

The combo box is pulling and displaying a drop down list of uname from the USER table, with this SQL state in the "row source".

Code:
SELECT user.uname FROM [user] ORDER BY user.uname;

In the control source of this combo box I have seller, and the form's record source is AUCTION, tagging on the AUCTION table.

The problem is the form is putting the uname into the AUCTION table's seller field, but I want it to input the uid field, however that it should still show the uname list when the user click on the combo box to make a selection.

View 2 Replies View Related

General :: Taking User Input While Opening Database

Dec 7, 2012

In my database there are fields of type Date/Time, their default value is set to now(). But the problem is that those fields are automatically filled up by English system date. I want my own country's date format, without changing my system date format. So I decided, whenever database is opened it should ask for a date, so the user will give today's date and that date will be used automatically on those fields.

View 6 Replies View Related

General :: Sending Email With SendObject - How To Determine User Name

Apr 27, 2015

When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that?

View 1 Replies View Related

General :: Auto Email Personal Reports To Multiple People Automatically

Nov 21, 2013

I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a report to generate slips for subscribers whose subscriptions have expired. I would like to, if possible, generate reports and send them to the respective clients via email, all with the push of 1 button. I don't want to have to find each subscriber and do one off reports.

View 1 Replies View Related

General :: Auto Logout - User Settings

Jul 11, 2014

I am using this [URL] .... in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further.

Instead of hardcoding the times in these two values

intMinutesUntilShutDown = 10
intMinutesWarningAppears = 2

I'd like to give users the options to set these themselves as not everyone will be the same. I am thinking I would have to check for who is currently using the database, this is stored in a hidden form in the following field.

[Forms]![frmwhoson]![whoson]

This username matches the users First Name in table Employees and in this table I have two fields to store these values

logmeoutafter
showlogoutmessagefor

So passing these values for the current user rather than having the logout times hardcoded.

View 3 Replies View Related

General :: Access FE User Auto Copy Most Recent File

Jun 4, 2013

I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.

With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.

Questions: Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?

I am not sure how to create a bat file and what the code should be?

For version tracking I need to put a version table in the BE and in the front end correct?

have made a few significant changes but I'm holding out e-mailing it if I can get this version copying figured out and in place first.

View 4 Replies View Related

General :: User To Review Address Register - Auto Alert When Changes / Additions Made

Sep 27, 2012

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent.

The question I have is there a way for Access to send me a notification that someone has requested the change?

I know that sending an email is doable - in Access. However, that's not an option for our network here. I was thinking something along the command prompt "Net Send" command. However I've not been able to get that to work by itself - let alone within Access...

I have used VB code in the past to store what PC is using the database, I could modify that to alert me whenever I open the DB up from my PC. But I was trying to get away from having to open this particular DB up every day and check for changes.

View 2 Replies View Related

General :: Replace Input Email Address With Mailto Address

Sep 17, 2012

I have a form where the user puts in a email address, eg test @ myserver.net

So the link opens a new mail it has to be prefixed by mailto:

How can I automatically replace the address the user enters with the format mailto:test@myserver.net

View 3 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Email Input

Nov 10, 2004

Trying to discover an input mask (or validation rule) for the entry of an email address. I want to ensure that the user inputs the @ symbol when typing the email address.

Of course there is no idea on the length of the email address, and this is where I am having problems.

View 1 Replies View Related

General :: How To Send A Single Email Message To All The Email Addresses In Query

Jun 2, 2014

I have a query (Access 2007) that contains a field named "email" (which contains email addresses, of course). I want to email everyone in the query and they are all going to receive the same message. My email to them doesn't have to be personalized and I don't need to collect data from the recipients. I don't even need a reply to the email I send.

View 12 Replies View Related

General :: Send A Specific Email From Outlook To All Email Addresses Within A Query

Jan 21, 2014

I have a database that I can use to create a query, grouping companies by city. I then want to send a specific email I have created in outlook to all of the email addresses in the query.I do not need to include names.

View 6 Replies View Related

Checking Email Input In The Form

Nov 15, 2006

I need some direction. I have a table with a email as a row in a table.

I would like to make sure that the person entering in the data enters the same twice before submitting the data to create the recourd. I know to do this in PHP.

Thanks
Tom

View 1 Replies View Related

What Is The Input Mask For An Email Address?

Apr 10, 2006

Can somebody give me the input mask for an email address?

Thanks!

View 2 Replies View Related

Tables :: Input Data To Email Address

Oct 23, 2012

I am new to Access and i send an email to my user's to input the data to their email address.

I would like to know if I can get my "Email address" column automatically updated whenever they send an entry using their email address ?

View 9 Replies View Related

Ask User For Input

Apr 3, 2006

Hi,

I'm reasonably new to all this, and have read many posts and got most of my answers from reading the posts here! THANKS.

However I need some help with the following:
I have a form that allows someone to input information about products being booked in. However sometimes we have the same product from the same supplier with the same invoice number etc.. but they have individual serial numbers. So the scenario is I have ten items being booked in, they are all the same product from the same supplier but they have individual serial numbers. I have created a do while loop where I can duplicate all the information for each product, but I need it to pop up a box asking the user for the serial number each time it goes through the loop. He is what I have so far.

Dim MyQuantity As Integer
Dim TempSerial As String
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("BarcodesDB")
MyQuantity = 1
Do While MyQuantity <= Me.Quantity
'insert into table using either a recordset or Append Query
rs.AddNew
rs!Supplier = Me.Supplier.Value
rs!Date = Me.Date.Value
rs!Invoice_Number = Me.Invoice_Number.Value
rs!Pcode = Me.Pcode.Value
rs!Item = Me.Item.Value
rs!Quantity = 1
rs!Serial_Number = Me.Serial_Number.Value 'Get this value from user each loop
rs.Update
MyQuantity = MyQuantity + 1
Loop
rs.Close
Set rs = Nothing

Thanks in advance.

View 1 Replies View Related

User Input

Mar 30, 2006

I want to prompt for user input that allows a "start date" and an "end date" in a report. Is this possible?

View 1 Replies View Related

Auto Email

Oct 30, 2006

Can someone please look at this and help me as it does not work? It stops right away at the "Dim olApp As Outlook.Application". It tells me "user-defined type not defined". I have searched the forums and could not find a solution.

Thanks,
RichB



Private Sub Command154_Click()
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application

'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)
With objMail
'Set body format to HTML
.To = "Forms!FrmPersonal!Email"
.BCC = Forms!FrmPersonal!rateremail & Forms!FrmPersonal!rrateremail
.Subject = "AUTO EMAIL REMINDER"
.BodyFormat = olFormatHTML
.HTMLBody = "<HTML><BODY>Blah, Blah, Blah</BODY></HTML>"
.Display
End With

End Sub

View 2 Replies View Related

Auto Input The Same Variable From Last Record

Mar 15, 2005

How does one have variables automatically appear if one is adding another record from a previous record.

IE. My first record has ClientID and date. If I hit the add record button then how do I make it so the next record has the exact same ClientId and date?

Thanks

Eric

View 1 Replies View Related

Subtract Day From User Input

Oct 31, 2007

Hi,
Working on a query, what I have is a user will select a date on a form and hit submit.

I need the query that it runs, to pull all data -1 day from what they select.

So if they select 10/31 on the form, it needs to pull everything for 10/30 only.

I have this in my query now,
[Forms]![frm_change_report]![txt_Date]

Which pulls the data for the date they selected, but not sure how to subtract a day.

View 2 Replies View Related

User Input Form

May 22, 2006

I am trying to make user input forms for each of the tables in my current database. I have made the forms, but I am required to have the forms come up blank first (so they can create a new record), but allow the user to edit existing records too. How do I do this?

View 3 Replies View Related

Accepting User Input In A Text Box

Sep 9, 2006

Hello, all.
I have created a project in Access 2003 to track a student's progess toward a college degree. I want the user to enter their student id in a text box on a form, look up if that user is present in the student table, and if not show the form to enter their student information.

I can't get the text box to accept user input, and return the student info as a single record on the form. I have a query but I don't know how to set the proprerties to run the query.

Thanks for any help.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved