Search results

Does access have the ability to automatically email specific people and messages based on results of a query!

Cheers I think Ive sussed it from the advice, it shows what i want anyway. One more thing it may be straight forward how do I restart my autonumber so it starts at 1 again, i was testing the data, and it keeps going up, when i delete all records it doesnt start at 0.

Yeah stuck, I have onr table NameID(Autonumber) Surname Forname Job Title table 2 I have all the questions for each assessment NameID QuestionsID (Autonumber) Q1 Q2 Q3 Q4 etc ti Q20 How do I get it to link tables, so i can enter multiple assessments for each name!

Ive been given a task, and wondered whats the best way to go about it, the form as an assessment which takes place regular, so one person can have many assassments. I would need to create a database which has one persons details then underneath using a form enter the assessment details for each...

sounds good advice I just want to make my mark, I am only a starting analyst, but I ose these forums and many others to get top quality information to assist in my job, many thanks

Afternoon all, I dont know if i am in the right area so apologies, I am starting a new job next weeks as an Analyst for the NHS, and I asked then to send me some infomation because Ive been off work through redundancy for 6 months and am bored out my brains. The information I understood, but I...

I have a stock code "84ELE7000" and I need Syspro to send me an Email notifying me when the stock level goes above 20000 Is the forumla below correct because I am not getting any emails %key = "84ELE7000" AND %wh = "A" AND %onhand > 20000

Hi my Help is not installed on my PC at work, I just wondered when doind a formula Date + 4 = Date, I want the answer to always need the answer to fall on a weekday, weekend do not count. I need to get a due date in a report, but need it to only count the weekdays! So if it is due on Monday the...

thanks, I will try to be a little more specific in future, and to also reply to the above, thats the book I have and am stuck on. Even though I have the solution to Chapter 4 (POWER), I just don't get it. I don't have access to an internet at home, which is where I do the course from, so I will...

I am new to this site, and hope to find it useful, I am only a beginner developer, have little to no VB knowledge as yet, however have designed in my opinion site good Databases, however the more I seem to do, the more people want, and I find miyself going into uncharted seas. SUMMARY I need a...

I am new to this site in the hope I can progress further. I am currently doing a course - MCDBA (Microsoft Certified Database Administrator), and having swiftly passed through the Step by Step Access book, I find myself unable to get to grips with 'Access 2000 VBA', I just don't get it, and...