Sending Combo Autofills To Another Table
Jul 7, 2005
I have a table of customers with Account Numbers that I wish to autofill:
Account Number
Customer Name
Address1
Address2
Based off the customer Account Number, I call this table tblCustomers. I have the autofill working off of an unbound combobox querying the Account Number. Im doing this by "=combo2.column()" method. My problem is I need this data to populate another table, when the form is closed. Seems simple enough but my inexperienced access mind is stumped and I desperately need to move on with other aspects of this task.
View Replies
ADVERTISEMENT
Mar 10, 2006
Hello-
I have a database form where I have a lot of like data I type.
Can I make buttons to automatically put text into the form field?
How do I do this?
-Tim
View 3 Replies
View Related
Jul 20, 2005
Is it possible to send a copy of a record to another table already created? if so what is the sql statements to do so or any other ideas that you might have.
THANKS!!!!!!!!!!!!
View 1 Replies
View Related
Apr 18, 2008
I have a form with (3) Text Boxes. Text Box 1 & 2 requires integer input, which is automatically sent/stored in a table. Text Box 3 performs calculations on values in Text Box 1 & 2, but does not automatically update the table.
The following Control Source code is used in Text Box 3 to perform calculation: =([Forms]![Plate Cash]![1-Dollar Bills]*1)+([Forms]![Plate Cash]![5-Dollar Bills]*5)
Thanks in advance.
View 14 Replies
View Related
Feb 25, 2015
I have records using a select query that I am sending to a make table. I would like to have those records excluded from being used again for 180 days, at which point they can be used again. Essentially, I have an ID and an email address which gets stored in the Make Table. I would need to ensure that if we send an email out in Week 1, we do not send an email again for another 180 days if there is activity from that same ID. On day 181, the ID/email address can then be resent.
View 6 Replies
View Related
Jul 19, 2013
In an Access 2007 module, is there a way of sending an email to a list of people stored as a list in a table in the database, rather than having to put all the names into the function?
I have a function I'm using to generate and send out an email to certain people, but the list is constantly growing so I'm looking for a better way to manage it! The main issue is having to kick users out of the database every time I need to update the recipients list... because it's stored in the code.
If I create a simple table containing all the names, how could I then ask it to use that instead?
This is the function I'm using currently - found on here and adapted to my own purposes
Syntax to use for the function: SendNotesMail "recipients", "Body Message", "Additional Text", "Subject"
Code:
Public Function SendNotesMail(strSendTo As String, strBody As String, strExtraText As String, strSubject As String)
'This public sub will send a mail and attachment if neccessary to the recipient including the body text and additional comments from the Active record
DoCmd.OutputTo acOutputReport, "REP09emailnotification", acFormatRTF, "x: endersgroup tendering databaseTenderUpdate.rtf", False
Dim Subject As String
Dim Attachment As String
[Code] ....
So I guess my question is: how do I get my recipients from a table into the strsendto?
View 5 Replies
View Related
Nov 5, 2013
i have a table with three column Named
1-State
2-City
3-Customer
on a form i m placing 3 combo box for each column how can i filter combo 2 from table after select value from combo 1
View 1 Replies
View Related
Nov 24, 2006
Ok my problem is this......
I have a form with a field "Property Status" on it. It has 4 possible values -
"C - SHELTERED (with warden charge)";"H - SHELTERED (No warden charge)";"J - WHEELCHAIR SHELTERED (With warden charge)";"M - WHEELCHAIR SHELTERED (No warden charge)";"X - DISCONNECTED"
When the value "X - DISCONNECTED" is selected in the form I want the record to be removed from its existing table and sent to a new table which keeps all the "X - DISCONNECTED" records together.
Any ideas would be greatly appreciated. How would this be coded?
View 1 Replies
View Related
Mar 29, 2013
I have a combo box (cboManifestNumber) that is based on the following table:
tblManifestData
ManifestDataIDPK (autonumber PK)
ManifestNumber
RemovedDate
ManifestComments
TsdfIDFK (FK frm tblTSDF)
This table is related to:
tblTSDF
TsdfIDPK (autonumber PK)
I need to be able to update tblManifestData with a new manifest number and manifest comments, along with assigning it a TSDF. how to be able to enter a new manifest number and the associated data without having it create two lines in tblManifestData. I thought that I could enter a new manifest number, then requery the table and form so it shows the complete list of manifest numbers (including the recently entered one) while staying on the newest entry.
View 2 Replies
View Related
Jul 11, 2013
I am trying to use a combo box to select the Company in an input record form for my Transactions. In the Transaction table, each record contains the Company ID, but not the company name (I have a relationship with a Company ID primary key in a separate table that has all the companies information).
I would like to be able to select the proper company in the combo box and have the form save the value as the Company ID number with the rest of the input data in a record (it will then refer to the correct company name in the other table if I query it because of the ID key).
View 3 Replies
View Related
Jan 17, 2014
I am trying to update a table with the value of a text box on the form where the table to update is as selected from a combo box on the form.I keep getting the following
Error message:
Run-time error 2465
Microsoft Access cant find the field & table_to_update & referred to in your expression..
But really can't see what I've done wrong. Have checked that the table_to_update string does contain the name of the table so guess it must be sql..
Code:
Private Sub Command91_Click()
Dim table_to_update, sql_string As String
table_to_update = Me.Combo49
Debug.Print table_to_update
sql_string = "UPDATE [" & table_to_update & "] SET [" & table_to_update & "].[Project] = """ & Text89.Value & """ WHERE [" & table_to_update & "].[ID] = " & Forms![T_entity]![" & table_to_update & "]![ID] & ""
db.Execute sql_string
End Sub
View 1 Replies
View Related
May 12, 2005
I would like to set a database password for my back end so that ppl could not "exidentaly" open the wrong .mdb file. Then i want to send a database password from my front end to my back end so that users who use FE would login my BE automaticaly? Is this posible? If so, how?
One more question. Is it posible to based on a login name(form in FE) open a BE readonly or normaly?
Thx
View 1 Replies
View Related
Nov 30, 2005
I am useing DoCmd.SendObject to send emails - however I get outlook opening an email with my To, BCC fields filled in , however I am stuck in the new email screen - ie can't get to a previuos email to copy and paste text - like it is dialog?
Is there any way around this.
Thanks Paul
View 4 Replies
View Related
Mar 4, 2008
how can i send text from a text feild from one form to another form using that text as the criteria to run the query?
View 5 Replies
View Related
Jul 14, 2005
Hi!
I got a question about emailing.... I don't think this is possible but I thought why not ask....
Is it possible to have a button on a form, that when it's pushed, it sends an email with a report included to a certain email adress?
thanks!
-jake
View 11 Replies
View Related
Apr 27, 2006
I have been able to create a form that will send an email automatically when the form is opened. Tha problem is, the email will not actually send until I open Outlook. Any ideas?
Thanks in advance.
View 14 Replies
View Related
Feb 8, 2007
I am looking to write some code that "OnSave" in a form will run some code
No worries about writing the code on an event, I will figure that out...
What I want to do is:
If txt box A is not null then send an email to some recipient.
QUESTION:
Does anyone have an example of code that will send an email to someone from Inside Access.
View 3 Replies
View Related
Apr 25, 2005
Hi guys,
i want to send an email to several people when someone else enters a complaint in my database.
I have a form which displays the complaint with a reference number, recordsource is "tblKlachten". i have query that is set to return only those emails i want it to send to called "qerMailBeheerder". In there is a field called "email".
Now, whenever i a user closes the form after adding a complaint, i want at the same time a mail sent to those ppl in the query with the subject the reference number of the complaint (field called "Referentienummer") and in the body other information from the fields on the form. Like the field "complaintdecription" and "clientname".
Now, i know about the sendobject thing, but i have tried alot and non would do what i want. Can anybody help me with the code.
Many thanks
View 8 Replies
View Related
Jul 27, 2005
Does anyone know what's the best way to send a mdb file via the internet. I've tried sending is as an email attachment and putting is on a webserver for downloading. Both wayes only gives errors.
View 1 Replies
View Related
Oct 3, 2005
I have looked through the message board, and cannot find an answer for this question.
I would like to send 2 different reports to the same person, in the same e-mail. Is this possible?
View 1 Replies
View Related
May 4, 2006
Hey
I have created a database system to book appointments between tutors and students in a school.
In the form, I want tutors to be able to send appointment details to students via email. I have created tables consisting of these details, however I don't know how to set it up for emails to be sent.
I am finding this very difficult especially with the visual basic codes. :confused:
Please help!
Thanks
ssslick x:)
View 3 Replies
View Related
Sep 16, 2006
Anybody got a working example / sample of faxing through Winfax10
Wish list
1.Use the FaxNo. On form
2.Send a Report
Looked through the threads but no conclusion reached
Cheers in advance
View 1 Replies
View Related
Oct 26, 2006
I am using Docmd.sendobject to print a report to Outlook so that I can e-mail the report. The method used to work. Outlook would open, I'd elect my recipients and could click the send button to e-mail the report. Now the send button is disabled once the report shows as an attachment in Outlook. I have to ctrl-alt-del to break the process and outlook gives me an error message regarding the ole object. Is there anyway to fix this problem or a possible root cause. Thank you
:(
View 1 Replies
View Related
Nov 1, 2007
Hello,
I am a little lost here. My prorgam has a form where I added a button. When clicking on the button, it is supposed to use some fields from the form and add them to an email with additional info which is added when the email opens up and is about to be sent. My boss uses Mozilla for his email account. What would be the code on the Onclick event be and do I have to set up anything else??
So far I have this code but it is for Microsoft Office Outlook not for Mozilla:
Set objOutlook = CreateObject("Outlook.Application")
Set ObjOutlookMsg = objOutlook.CreateItem(olMailItem)
With ObjOutlookMsg
.To = str_Recipient 'str_Recipient is obtained before this code
.Subject = str_Subject 'str_Subject is obtained before this code
.Body = str_Body 'str_Body is obtained before this code
.readreceiptrequested = lb_ReadReceipt
.Display 'to display the message instead of sending it
End With
Thank you very much
View 3 Replies
View Related
Jul 19, 2005
I'm sending an email from a form to Outlook express. But before it opens Outlook I get a question that states "a program is trying to access email address you have stored in Outlook" I then have to click ok and then another window opens and askes the same question. How can I eliminate these warning messages??
Thank You
View 4 Replies
View Related
Jul 25, 2006
Hi,
So far I know there is a wizard for being able to create a button that sends a Form Report. What I really want to do though is when the user clicks the button on the form, just the form is sent/attached to the email, effectively giving the viewer/receiver a screenshot of the Form in question.
Thanks in advance,
Barret
View 8 Replies
View Related
