Bax can you take a look at the attached zip which is a VERY small sample database with the VB Code to make it expire in 30 days. It is pretty cool, you can not even change the system date on your computer because this will pick it up and give you an error message and not let you open the db. I can not get this thing to work with my database and I know I must just be missing something. It is real simple, 1 table, 1 Code and 1 autoexec macro.
I am a novice using VB and though I understand this code somewhat I am still missing something. I know you are good at this stuff and thought maybe you could help.
Bax, I am still dealing with that problem of getting my statistics form to show. Is it possible for me to set it up so that when a new player is added into the player information table that the statistic table will populate itself with the [Uniform #], [FirstName] & [LastName] and default 0's to all statistical fields?
I have searched this forum and found a few examples but cannot get them to work in Access 97, what i would like to do is email a single record by using a query for Repair No..
So i would like it to be a button, it's possible to do this via a sendOject command but that emails ALL records not give a option to type in your repair number and email that...
Thanks for any one who can help, im a complete noob an dneed some help
I had some work done on my Database a few weeks ago and it works great.
I just got an email from the guy who did the work and he wants me to pay him more money....he said he forgot to bill me for 6 hours.
I told him I didn't think that was fair and wasn't really willing to pay for more hours....he then said he never sent the "non-expiry" versions of the databases.....he also said I have 15 days left until they expire.
Considering I done additional work on them I was wondering if this is possible?
Bruce
P.S. I hate being taken advantage of.....he was really good to work with but now he's trying to rob me.
Good morning to everyone. I am hoping that you will be able to help me with a table that I am working on. I have almost no experience with access, so I am useless when it comes to this.
I have attached a condensed version of the database that I am working on (removed everything except the one table that I am working on) so that you can see and edit what I am working on.
The requirements are simply this. -If "Status" = 'new inquiry' and has not been update in 6 months, automatically changes to 'inactive' and "probability of order" automatically changes to 0%
-"Initial Inquiry Date" is set to the date the Inquiry was added to the table (but user has ability to change it manually)
-*bonus* If ship quarter has passed todays quarter then change "Status" to 'inactive'.
I hope I have attached enough for everyone to be able to help. Thank you very much in advance, I really appreciate it. :)
I have a form with a date of when training was completed. I would like to set it up so it displays the date of expiration which is one year from when the training was complete.
I'm working on a school database project and I am developing a Gym subscription/registration system.
Basically, once a user enters his/her personal info, they are taken to a second form where they can enter the subscription plan type (there are three plans).
Now, this is what I'm stuck on.. When a user enters a subscription start_date, I want the next field 'Exp._Date' to update to a year later, automatically.
So for example, if you enter 09/02/2005 in the start_date field, then the next field would automatically be filled with 09/02/2006.
Is it possible? And more importantly, how? I'm fairly new to DB's so please lay it in laymens ;).
Thanks guys.
PS: A screenshot of the form is located below: http://img226.exs.cx/img226/9293/dbsc3xi.th.gif (http://img226.exs.cx/my.php?loc=img226&image=dbsc3xi.gif)
My database keeps track of training for employees, some of which expires after a period of time, which is in the tables. I need to create a query that displays only the employees and the training that expires during the next 30 days. I have a query that displays the expiration date (this field uses DateAdd and adds the expiration term to the date the employee completed the training) I am trying to add a criteria to this field. I found <=Date()+30 in my searches but that displays all of the records from 12/14 and back. I have tried all kinds of versions of this (obviously, not the correct one) and either get all records or none. (Yes there are records in the database that fall within the the period I am trying to display - that is something that I have been known to forget)
Is it because I am using criteria in a field that is based on DateAdd or what would be the correct criteria for this?
I've built an an update query that updates a Yes/No field "Expired?" to "Yes" if the expiration date has passed i.e. if the current date is newer than the expiration date. I thought this would translate into the current date being greater than the expiration date?
UPDATE Alert SET Alert.[Expired?] = 'Yes' WHERE Alert.Current_Date>Alert.Expiration_Date;
When I run this, it identifies the records to be updated, but then stops updating the fields due to "a conversion failure."
I'm trying to build a query with an iif statement to calculate expiration dates within a query. For some reason what i'm trying to do is not working as expected.
Here's the situation. Every employees with an exception of two employees in the company has an expiration 2 years after the class took place. The two exceptions are the certified instructors who's training certification is good for three years.
I've created a query with the employeeid, training subject, and maxoftraining date.
I'm trying to write an if statement to give me the expiration date based on the above information. Here's what I have so far; however its not calculating based on the criteria.
Expiration: IIf([tblemployee]![EmpID]=1 Or 2,DateAdd("yyyy",3,[maxoftrainingdate]),DateAdd("yyyy",2,[maxoftrainingdate]))
At this point in time, all "expiration" dates are showing + 3 years rather than just the Employee ID's 1 and 2 and the rest +2 years.
I am trying to create a database to analyze expiration dates of multiple products.
Let me lay out what I am trying to accomplish.
I have 5 ambulances, each ambulance has the same quantity of medications on it. There are three separate locations medications are stored on each truck. Each month I need to be able to update expiration dates, query what medications will expire by a set date and where exactly they are located.
SO here is the structure as I see it.
Ambulance 1 contains, a drug drawer with approximately 30 different medications, a trauma bag with about 10 different medications, and a blood glucose kit with 2 different medications. Now some of medications are repeated in the different locations, but have different quantities. The medications will never all have the same expiration date, and medication 1 might have 8 vials, where medication 2 may have 4 vials. I would like my form to be dynamic based on the inventory level of the medications. That way if we decide to keep 10 vials instead of 8 the form will then require the 2 extra data points.
The tables I have created so far...
table 1 lists all the ambulances table 2 lists medications in the drug drawer and the inventory level table 3 lists medications in the trauma bag and the inventory level table 4 lists medications in the blood glucose kit and the inventory level
I need to create a table to store my expiration dates for each of the locations in each of the ambulances.
I need to create a form to simplify the entry of the data into those tables and I want the form and table to be dynamic to the inventory level.
Hi everyone I'm a very very new access user so many apologies in advance for when I have no idea what I"m talking about.
I'm working on creating a report that will display multiple expiration dates. Currently I have an employee database, not created by me, that has all of our employees professional licenses listed.
Prof license, auto license, liability, etc.
I want to create a report that will tell me what has already expired or will expire in the next 30 days.
I did use this Between DateAdd("d",-30,Date()) and Date() and it is bringing back info up to 2009. which isn't what I need. I'm sure I'm doing something wrong here.
I want anything that has expired regardless of the date from today, before today, and 30 days from today but I don't care about anything more than 30 days from today's date.
I noticed that when I looked at the existing database that the fields are set as text fields. I tried to change them to dates and it gave me a "deleting 106" records error message. Yikes!
Any help would be appreciated. I don't really understand expressions and I don't understand if I'm supposed to put the actual date in parentheses or what. Please pardon my ignorance.
