Recent content by Scottigus

Okay, I just redid the formula, but when making the query, I just added in the actual field to show the date that they received it on. I think I have it working now, so thank you veyr much!!!!

Okay, I entered that into the appropriate place, but all it did was add 6 months onto the date. What I'm trying to do is have the query only show the date that they got their certification only if it is later than 6 months from the day they got it. Example: pbaldy got his certification on...

seeing as I am still somewhat new to this...where exactly would I put all that information (SELECT, FROM, WHERE) Thanks

Good day Gents! My problem is I have a database where I have recorded dates of when the employees last got certified for their forklift certifications (as well as others)...such as Person A - 8/11/2009, Person B - 9/2/2009, Person C - 7/2/2009, etc. After a certain amount of time (let's say 6...

I have a video taken from a cell phone, and the video file is in 3g2 format. I tried to download a converter and convert it into an AVI or WMV, but everytime I did, the video ran faster than normal, but the sound remained the same, so the video and sound didn't match...no matter what settings I...

Thank you very much bob. I am very grateful! You have been a VERY big help!:D -Scott

Wow that was a fast response...lol Okay, so I am unfamiliar with macros and such. I had training in access about 4 years ago and it unfortunately didn't work out so well as the school went bankrupt. Any help on how to actually accomplish this would be great. Thank you again for the quick...

I have been checking all over online but I cannot find it...so I thought I would ask here since you guys have been so helpful so far. My question is, how do I have a report start up when the database is opened. All I can find online is how to get forms to start upon opening the database, but I...

So now continuing with my problems... I did the walkthrough from here...http://support.microsoft.com/default.aspx?scid=kb;EN-US;209963. After doing the walkthrough I had some problems. It would always set it back in like 7/9/2003, even though I set the appt date for the next day like it says...

So now continuing with my problems... I did the walkthrough from here...http://support.microsoft.com/default.aspx?scid=kb;EN-US;209963. After doing the walkthrough I had some problems. It would always set it back in like 7/9/2003, even though I set the appt date for the next day like it says...

I followed the example exactly. Made the table, followed the codes and everything and did it step by step, and the results where as I posted above, appearing in July of 2003... I'll figure it out there. I'm sure I can play around with it and get it to work hopefully!! Thanks for all the help!!

Okay, so I got the button to work and all, but now I have 1 problem. I followed everything it said, but when I enter all the information, it appears twice on 7/9/2003 and the next Thursday afterwards. It does not pull from the form boxes. Here is what I have. Private Sub cmdAddAppt_Click() On...

Yes. The thing is, I am not even sure how Tab Controls work. Again, I used the Access Template "Faculty" And it comes with it already made. I just know how to manipulate the stuff. That is why I am asking. :rolleyes: And no worries, you were not to brash. I understand that you probably think I...

Okay, so here is what I am trying to do. My employer wants a program that gives him notifications. It is a Human Resources program I made for him. What he is wanting is this: When they are 80 days from their hire date, Jason (the human resource employer) will get a notification that their 90...

Now...here is my goal and I have no clue how to even begin... I started with the Microsoft Access 2007 Template for Faculty. It comes with Tab Controls as I have heard they are called. I have changed some fields, added some fields so it is customized for my work. The person who wants the...