Seached Forum For Automation Of Emails, But Still Stuck-cos Im A Newb
Dec 30, 2005
Hiya,
Sorry to add to the email threads, already posted on this forum. I have already searched on the forum for the relevant help but im still struggling. As am a newb when it comes to this sort of thing, and everythink is an on going learning curve.
Background, i work for a architectural firm, my boss would like the database to send out automated emails, to the local planning authority.
I have a query called "ApplicationEmailCouncilQuery" in this i have the following fields. ApplicationProjectID, ApplicationSubmitted, ApplicationRef, ApplicationDecisiondate, ApplicationContact, PlannersEmail, ApplicationEmployee, Email.
How do i get access 2k to automatically send out emails to each of the results individually as produced fromt he query, every 2 weeks.
I want the email to use the fields from the query.
To: "PlannersEmail"
Send: Your Application ref is "ApplicationRef" submitted on "ApplicationSubmitted"
Message: To ApplicationContact,
Please could you give me an update on the application "ApplicationRef" which we submitted on "ApplicationSubmitted".
Please reply to this following address "Email"
Yours Truly
"ApplicationEmployee"
-----------------------------------------------
Sorry for the long post, any help on the above matter would be greatly appreciated.
Hoihoi, Well, Hello..Never thought I'd register on an Access forum, but, hey, why not!I'm new to Access, never really liked it..but this assignment has changed me.. i really like Access and well DBA'ing in general!I need a bit of help with a few things:-----I hate registering on sites JUST asking for answers >< I hope to learn a lot of stuff from here!-------Just like to add it's for an Assignment at college, i KNOW I KNOW you people can't help with assignment work, BUT it's not like i'm asking you to do it for me, just need a bit of help Basically,I've got a database -It's based on a Mobile Library which visits nurseries.The nursery can loan a book, if a book is currently being loaned by a nursery and another nursery wants to loan that book, they can reserve it untill it is returned.Basically, I've got a few forms:21233I can do everything fine!Everything seems to work, i can loan and reserve..i can add books, nurseries and authors..HOWEVERwhen it comes to deleting.. it's a different story!On my delete_author form, I've got a Combobox which loads the authors and then i've got a Delete button which should delete the author which is in the combobox---- I've google'd for ages..and can't make much sense of any of the replies people have had..Is there anyone who can help me with this?Delete the author which is in the combo box..I can supply any details if people are willing to help :oWould LOVE to hear a reply from anyone!Cheers :)
I have a form that I created using autoform from my main table. The form is just for the user to enter a new record. But when opening the form, how do I get the fields to be blank and on a new record by default, rather than starting on the first record with the fields already populated?
And then if I make a button that says "add" but just closes the window, the data should automatically save right?
I am fairly new to access so please excuse my lack of knowledge. I am using Access 97
What I am trying to do is create a system where I ask for a zip code, then disply the closest 5 results to that zip code.
I currently have every single city with ZIP code in Michigan. I also have the list of results with their zip codes.
Since you cant relay on ZIP codes going in order, I also have the Latitude and Longitudes for each ZIP code. Of course I have the lat and long for my possible results.
How can I get the 5 clostest results based on two different factors (Lat & Long)? Would I want to construct a Query to do this?
Any tips or sites you can refer me to would be great! Thank you!
Am new to the forum and it seems a good place for help,
Am having some big problems with a database that i am using for a company. The problem being that users need to enter ref numbers for each record on to the database called "c3" numbers, there could be a unlimited amount of these numbers(they do need to be able to reported on though) per record
At the moment i have a serperate form linked to my original form with a lot of seperate fields labelled like "c3number", "c3number1", c3number2" and so on which the user enters the c3 numbers into ans saves
however it is becoming very hard to do counting reports with it set up like this.
has anybody any ideas's on how i could make the setup simpler?
Ok, I have studied up on relationships, and read a lot of these threads but, I still have yet to find help. It seems a lot of the people on here have difficult problems that require dificult answers. Basicaly I have two tables Tblresort and Tbllifts, now there can be many chair lifts for each ski resort, so this would call for a many-to-one relation ship. Now, I create a relationship for the fields, and enforce refrencial integrity and all that. Now what do I put into the related field in Tblresort to get the lifts with ID#'s 1-8 to be related to the first resort.
I hope this all makes sense, so far I can only get one lift conected to the resort.
I have to create a new table for some data I have from work. The data was imported within quotations though, so it won't let me copy and paste it untill the quotes are removed. I have over 3000 data values in each column, so I can't just go through and delete every quotation mark. Is there any way for me to select a column and remove the quotations around every value?
I am brand new to Access/VB as of Thursday. I am an aspiring programmer still in college. My proficiencies are more to the c++/HTML side of things right now, but I am in dire need of some assistance. I was recently given a series of projects to determine if I am qualified for a particular job. I have completed them all but one. I am modifying an invoice form in Access. I have accomplished all but two of the tasks on this last project. I need to modify the invoice form so that whenever a payment amount is entered, the payment date box I created populates with that date. I know I'm really close to it, but I keep getting errors and the only thing populating the box is #Name?. I also need to open up the print/preview mode of the invoice report when I click the print button as opposed to the current form it opens up to print from right now. If anyone could offer any assistance/advice on anything...even a tutorial that might point me in the right direction that would be excellent. I have until Tuesday to figure this out =) Thanks a bunch in advance!
P.S. This is where I thought I needed to execute the update for the payment date since it is where the payment is entered. If this doesn't help at all then I apologize.
Private Sub I_Payment_Exit(Cancel As Integer) Me.I_Tax = NullToZero(Me.I_Subtotal * Me.I_TaxPerc) Me.I_Total = Me.I_Tax + NullToZero(Me.I_Subtotal) + NullToZero(Me.I_ShipChg) If Me.I_PaymentLock = True Then Else ' Me.I_Payment = Me.I_Total End If Me.I_Balance = Me.I_Total - NullToZero(Me.I_Payment) End Sub
Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:
Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?
Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?
Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.
So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.
I'm not very technical with access (not yet) so things might be done differently than I do to speed up things
Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.
So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.
My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.
Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:
Database Design Tables Queries Forms Reports Macros Modules Other Issues
I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.
Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:
So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.
Any recommendation is welcome.
I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.
There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.
I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.
I know that the user will be looking at a web front end which in turn will be accessing the Access Database.
I'm trying to design a system for an electronics shop. I have two tables, one called Products and another called Suppliers. The Products table has the following fields- - 1) Product ID 2) Supplier ID 3) ProductName 4) Information 5) Price
The Suppliers table has the following fields- - 1) Supplier ID 2) Company 3) Address 1 4) Address 2 5) Address 3 6) Town 7) County 8) Post Code 9) Country 10) PhoneNumber 11) FaxNumber
Basically I want to create a form to show the supplier name and ID and then implement a sub- forum which shows all the product details for that supplier. How do I do this? Do I have to use a query? Thanks
Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes. Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL. Has anyone got some recommendations ?????
Did you know that you can use Google to search the Access Forum and get a more refined result?
I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.
To get this sophistication do this:
Open Googles advanced page: (http://www.google.co.uk/advanced_search?hl=en)
The first section of this page is shaded blue, and contains the following items:
with all of the words with the exact phrase with at least one of the words without the words
You can add words to varying degrees of sophistication for your search.
This is the important bit! Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:
http://www.access-programmers.co.uk/forums
Now give it a try! Try searching for: "Date Selection" (without the Quotes)
If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.
Caveats: Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.
Hi, I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access. Any answers can help me. You could send me a link to a webpage that tells me how to do this stuff. Any Tips?:)
hey all, i'm making a database to catalogue a whole bunchs of projects of mine. i have a few questions but i'll ask one for now. i have made a form with a check box and i want it so that once that check box is clicked, another element appears or becomes un-grayed or something. basically if the check box is checked then i have to specify a file location for the file that i'm confirming exists. (if that makes sense)
How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.
