Recent content by Jelloshot1

Hello All, This should be an easy one. At least that's what I thought. Here goes.... I want to generate a report based on the items selected in a ListBox. The ListBox contains Names. The report should put the names in order of Seniority. In the query that the report is based on I have the...

Hello all, I've inherited an Access97 DB that shows anyone that is logged on as logged on twice in the .LDB file. The DB is delivered to those who have access to it through their Novell Logon. (The DB icon that appears in the Novell Delivered Applications window is actual just a shortcut.)I...

All of the above answers are GREAT! I started out with NO knowledge of Access at all and the Using Access 97 (QUE)Book. I also found the samples databases, Nothwinds, Solutions and Orders to be very useful. After 4 years of using Access, my employeer finally decided to send me to the classes...

Hi all, I have a "small" problem that I hope someone can help me with. I'm running and access '97 application on windows 95. I discovered that some of the queries that the program ran were too "complicated" unless the full version (not typical install) was installed on all...

Hi Jeff, I tried your suggestion. It didn't quite work but it put me on the right track. What I ended up with was DatePart("yyyy",[DateField]= Year(Now)) Thanks for the help! Mary :-P

Thanks Jeff... I'll give it a try. Mary

Well Chris, I started over. Then I gave up! LOL I decided to use a different method to acheive my goal. Not the one I wanted, but it works. I did not give up on the Select Case statements though and have used them in place of several longer IIf Then statements. Thanks so much for your help...

Hi all, In my database (Access 97) there is a table for employee sick time used. I was wondering if there is a way to filter records in a form and report to show only those with a date in the current year? I've tried using **/**/01 in the criteria line of the query that runs the form. It...

Hi Chris, I get the spaghetti code. In fact I recently read about it in a Good Coding Practice post in this forum. I'm not new to Access, but am relatively new to coding. This all started out as a "hobby" for me. I work for a state institution and while I was on 3rd shift I did a lot...

OK, here goes again.... I changed the Else: Forms!frmStaffInfo!RDO = " " to Else Forms!frmStaffInfo!RDO = " " Didn't work. BTW, I don't know why access placed the ":" after the original "Else", but I tried to remove it and it kept coming back. Also...

I think I've found a way around this problem, but I'd love to find another (correct) solution.

Hi again, Tried that and it didn't work. Here is the entire code I'm using. it works fine as long as I scroll from one record to the next but I get the error (at the bottom of the code) when I try to tab into the next record. I know it is probably very primitive and has no error code in it (I...

Thanks All, I tried compacting again and there was a new db1.mdb. There also was a Paste Error table in it. The error message it contained said that me and another user were tryingto change the same information at the same time so the proccess was stopped. I am positive there was no one else in...

Hi All, Would like to say first that I have found this site and it's Q&A very helpfull! I'm learning more everyday. My question today is about If Than Statements and can they be combined as in If (IsNull(Forms!MyForm!FRI) And If(IsNull(Forms!MyForm!SAT) Then RDO="F/S" End If I...

Hi again, Well I checked evrything that you sugested. I do have all the correct rights needed. Another tried compacting another database that we use and had no problem. And I have the same rights to both. I finally split it into a frontend/backend, hoping that would solve the problem. The...