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
I currently setup a form for a survey which works fine and all the information that is gathered is stored in an access 2000 database.
The thing i want to do is to only let the person fill out the form using only 1 email address. So if they try to come back and fill out the form again using the same email address, i want there to be a check on the database to see if the email is there. If it is the form wont submit and it will let the person know. If it's not in the database things will work as planned.
this is what i have so far, but when i submit the form it continues on, but it doesnt check and doesnt email or add to the database like it used too...
Code:<%Dim DSNtemp, Conn, SQLDSNtemp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DATABASE LOCATION"Set Conn = server.createobject("adodb.connection")Conn.Open DSNtempemail = Request.Form("email")SQL = "Select * From users Where email = '" & email & "'"Set RS = Conn.Execute(SQL)'HERE WE CHECK TO MAKE SURE THE USERS EMAIL EXISTS, IF IT DOES, WE STOP HEREIf NOT RS.EOF Thenx = "Sorry The Email Address You Entered Already Exist!"Set RS = NothingConn.CloseSet Conn = NOTHINGElse'CONTIUES ON WITH DATBASE INSERTION AND EMAIL TO USER.End If%>
I have some code that sends an email when the database is registered. The problem is that depending on a users security settings on their PC they can stop the email from being sent (2007) How can I add to the code to make it check that the user hadnt cancelled the email?
My code is:
Private Sub btnRegister_Click()
Dim olApp As Object
Dim objMail As Object
On Error Resume Next 'Keep going if there is an error
Set olApp = GetObject(, "Outlook.Application") 'See if Outlook is open
[Code] ....
I have a control called GoToId which afterupdate moves the user to a specified record where ID=GotoID. I want the control to only take numbers as input. I used input mask: 999999;;" " but with it the user can still press a letter on a keyboard and even though the letter doesn't get typed in, I think an empty string gets passed as value.
If I can't do it with masks, what's the simplest if statement in vba that will check if the value is a number and positive? (IF the value is Null, "", or anything else I want the if expression to be false)
I know how to do it with several if statements checking if is null, or if "", but there must be a clean way of asking it in a single expression.
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.
Can somebody give me the input mask for an email address?
Thanks!
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 1 Replies View RelatedI 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 ?
Hello,
I need to create a field in an input form that is simply the concatenation of two other text fields. I have tried all sorts of things, but when I look at the data in the table that field.
I have a field called ID that I want to be created like this:
=Format([UniqueID],"00000") & "-" & [Mosque]
This works well in my output fields, but does not work the same way on the input form. It needs to be based on the currently input values from the current record. Anyone have any ideas?
Thanks in advance,
--Robert
I have a form which has a button to email the data out in a standard email message.
Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String
[code]...
This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.
I work for a voluntary organisation in a hospital environment. Older patients coming into A&E will get sent a letter from us offering help.
We send out about 3,000 letters a year and have just over this number of records on our simple Access 97 database.
The problem I have is when we enter data using a Form in the field Address Line 1 if we have sent a letter to this address before I want somehow for the program to inform me of this. However, I do not want it to stop me from entering the same address again so I can't use the No Duplicates option. The reason being, we may have sent the patient a letter six months ago in which case we would want him to receive another but if we only sent him a letter say 3 weeks ago then we wouldn't send him another. Alternatively, his wife may now be a patient and will get sent a letter.
At present we look at the admissions list, sort our table into Surname order and check if they have been sent one previously, however this is very time consuming and would value anyone's thoughts.
Unfortuantely, I can't program so tend to use the design features and wizards of Access 97
Does this makes sense?
I appreciate the time any of you may take in answering this Thread. As you can see I am a newbie to this. Thank you in advance.
Robin
I've got an attendance form set up with check boxes for each day I want to check attendance. I have two problems with this form.
1) All the boxes start out with little squares (I want them to be blank)
2) If I try checking a box for one person, it checks all the boxes in the column (same with unchecking).
I'm trying to get a spell check to work on a text box on a form. i've got it popping the spell check window after the box has been updated but i'd prefer it to just highlight the errors in red, rather than pop the spell check box. another problem i'm having is when it's finished spell checking the box it moves the form back to the first record. this is the code i'm using.
Code:
Private Sub txt_notes_AfterUpdate()
If Len(Me!txt_notes & "") > 0 Then
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True
Else
Exit Sub
End If
End Sub
I have a Listbox on a fprm which has a button attached to it, the button allows you select one of the items in the listbox and append it to a table. the problem is that it currently allows you to add the item as many times as you like. How can I check for duplicates?
Code:
Private Sub CmdAdd_Click()
'Add new record to tblShootingTasks
strSQL = "INSERT INTO tblShootingTasks ( ShootID, ContactName, Task ) " _
& "SELECT [Forms]![frmTasks]![ShootDateiD] AS ShootID, [Forms]![frmTasks]![Combo15] AS ContactName, [Forms]![frmTasks]![Frame17] AS Task;"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
End Sub
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 developing a form where students have to enter their ID number but I want my form to check through a table of students and their IDs and flag up if the ID number does not exist in the table.
View 10 Replies View RelatedBelow is some code that I'm struggling with and I get an error message "Type Mismatch".
Description: The database contains multiple projects and the subset of each project is a release. The "PublishedNumber" can't be a duplicate within a release, but it can be a duplicate within the table where the data is stored. There can however be multiple occurrences of 0.
Here's my code:
Dim stLinkCriteriaRelease As String
Dim stLinkPublishedNumber As String
Dim DuplicateNumber As Variant
stLinkCriteriaRelease = "[AssociatedRelease]=" & [AssociatedRelease]
stLinkPublishedNumber = "[PublishedNumber]=" & [PublishedNumber]
[Code] ....
I want to check if data entered in a form field is existed
The form is bounded to a table
I used this code
If DLookup("Telegram_Number", "tbl_Violation_Of_Building", "Telegram_Number Like " & Forms!frm_Add_Violation_Building!Telegram_Number) Then
MsgBox ("number existed")
Me.Telegram_Number = ""
Else
End If
everything is ok but if the data is existed the database show the message and clear the field but i'm getting a Run-time error
'-2147352567(80020009)': the macro or function set to the beforeupdate or validationRule property for this field is preventing [ISF] from saving the data in the field
I guess the problem because the form is bounded to a table so he will save automatically
My solution is to unbound the fields and save the data via vba but is there any solution with a bounded form???
VBA Code to go in the on double_click event of a name field in a Subform bound to a table. The subform is just a copy of a data table and within the subform view, When the field "employee name" which contains e.g. John is double clicked, I would like access to Lookup and get John's email in the employee table under field "Email" and launch outlook application and insert it into the To field.
I assume hyperlinking the field can also achieve this similar to what excel does but I am fast learning that what is standard functionality in excel is a whole another story in Access..
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 Related[FONT=Arial]Hello,
in my form, which exists of cbo's and text fields, I want to put in new data in order to update my source table. In the menu properties, which is related to my form, I chose the right options to update this table, etc.
Here is my problem; when I go to the form display and making some attempts to put in my data, the following message appears in my status-bar: "Can't update this Record-set object."
I just wanna know how I can configure my form in a way that I shall be able to put in my data.
thanks in advance & grts
I have an command button, when once selected brings up a inputbox to enter a date is it possible to :
1 - add an Calender to the Inputbox to be able enale the user to select a date instaed of typing it in. I am able to add a date picker calender to a date text field, however i do not know or if it is possible to do this with a input box
2- Once the inputbox appears a message is displayed "Do you wish to fill a cylinder for works order number:-0003102647000001
However i need to split the two numbers 003102647 and 000001. It should say "Do you wish to fill a cylinder for Works Order Number 003102647 and For Line Number 000001". How would i amend the following code to do just that, the coding i am using is
My Code:
InputBox("Do You Wish To Fill A Cylinder For Works Order Number:-" & [Works Order Number] & [Line Number], "Please Enter/Scan Cylinder Serial Number")
3- Also as the inputbox is asking for a cylinder number, the user has to therefore type an appropriate cylinder number to be filled, at the moment the individual can type in any cylinder number, but i would like the cylinder number entered to be validated against the cylinder master table, which is a list of all the cylinders avialable, how is this possible, would it be a select statment.
I need to be able to query the service dates for the bill. So I can query 1509 for the .billYYMM and .readdate and it will give me the TO Date. How do I in the same query tell the query to subtract 1 from the BillYYMM that I just entered and give me the read date for that field in that query? So Query 1 MBRHISTDETL.BILLMOYR and in the criteria box use [Enter the Bill Month Year YYMM you want to search for] will allow me to run the query at any time for any bill month year that I enter. So another field in that query is MBRHISTDETL.READDATE. So to get the FROM date and the TO date i need the following MRBHISTDETL.BILLMOYR (whatever I enter as input) and MBRHISTDETL.READDATE that corresponds and then I need [MRBHISTDETL.BILLMOYR]-1 and MBRHISTDETL.READDATE. The first gives me the TO date and the 2nd gives me the FROM date?
View 5 Replies View RelatedI have made a query with the name "Confirmation" and it is setup like this:
Name trainee Email Training
John John@mail.com Tr one
Mary Mary@mail.com Tr two
I also made a button in a report with the title "Send Mail" now is my goal that if i press that button automatically multiple e-mail message's will be generated with data from people in that query. So if click on that "Send Email" button i want two different mails messages generated that will be send to John@mail.com and Mary@mail.com with in the mail body their data.
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