General :: Auto Email After User Input
Jan 10, 2013Access 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 RepliesAccess 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 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]....
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
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 ?
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.
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 RelatedWhen 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 RelatedI 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 RelatedI 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.
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.
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.
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
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 RelatedTrying 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.
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 RelatedI 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 RelatedI 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
Can somebody give me the input mask for an email address?
Thanks!
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 ?
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.
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 RelatedCan 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
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
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.
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 RelatedHello, 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.