Search results

Hello all, I have an email alert for the user that will let him know when someones doctors notice will expire. Once the user receives the alert, he then can click "send" and Access will auto email the individuals that have slips ready to expire (this works fine). The problem is this: Let...

Isskint, I ended up with your first suggestion because I could not get the second one to work: =IIf(DateDiff('d',[L/D Start Date],Date())>=366,"*","")] Thanks for the help!

Thanks for the reply Isskint! I tried what you had mentioned: =IIf(Year(Date())-Year([L/D Start Date])>=1,"*","") but it still places an asterick next to everones name. I also tried this: =IIf(DateDiff(Year(Date())-Year([L/D Start Date]))>=1,"*","") Any ideas?

Hello All, I have a report that I would like to place an asterick next to records that are over one year old. I have created a text box that is unbound and in the control source I have placed this code: =IIf(DateDiff('yyyy',[L/D Start Date],Date())>=1,"*","")] When the report runs, it...

Ok, so instead of pulling the info from the subform, I decided it might be easier to pull the info from the listbox. I placed this in the query (QPSU) under the field "Case Number" : [Forms]![PSU Query].[lstQueryResults] and of course if I select "Case Number" , then I get the desired...

Hello all, Below is the code I use to populate a subform. I would like to create a report from the information in that subform. I have created a query "QPSU" and a report "PSU Report" for the subform. At the moment, I am getting all the records from the query in the report instead of the...

OK, either this question is too easy or it is too difficult.

Hello All, I have a access web form with two tabs. I also have two controls for adding new info and editing info. What I want to do is this: If the user clicks on the first tab (pgFocus) and then clicks on the "Add" button, then the Focus form will open (this works). If the user clicks...

Works like a charm pr2-eugin. Thanks for the help!!

I am sorry about all of the confusion. I did created two queries for the user: Rpt_All Personnel on LightDuty Rpt_Personnel One Year or More The user does not want to print out 2 different forms for his supervisors; he just wants one that will have an asterick next the to personnel who...

Hi all, I am still looking for some help if anyone has the time. I have since tried the following: =IIF(L_D Start Date] = DateDiff('yyyy',[L_D Start Date, Now())>=1,"Yes") Nothing happens, so I tried this: =IIf(Int([L_D Start Date])=DateDiff('yyyy',[L_D Start Date],Date())>=1,"yes","")...

So, I am thinking that I probably should create a new textbox on the report with the control source being the criteria: IIF([L_D Start Date]= "DateDiff('yyyy', [L_D Start Date], Now())>=1","*",) Does this seem to be the way to go? Ok, I tried this: =IIF(L_D Start Date] =...

I am not sure on this question. The user can add, edit, and delete records from a form, but he cannot delete fields or change datatype; so I guess that would be no, lol (sorry I am a beginner Access person). No. I just talked to the user and he said that he does not want to generate two...

pr2-eugin, Thanks so much for the reply. Yes, I was lazy and tired and could not think of anything else to name the field at the time. I was planning on changing the name (lol, I knew someone was going to get me on that, sorry). The user wanted a way to see, at a glance, if a person had...

Hello all, I have a table "LightDuty" with 2 fields: [L/D Start Date] and [1yr/+] What I am trying to do is when the form loads, I want the [L/D Start Date] field date to be checked to see if it is >= to one year. If it is >= one year then I would like to have an asterick placed in the...

Thanks for the input guys!

Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code? The user can then just paste over the original if it becomes corrupt.

Nervermind, I figured it out. Sorry! QUESTION: Do I have to open the recordset? Do I have to Set the db? Is there an easier way to code the above? Thanks!

Hello All, I have a table "LightDuty" with a field [Email Sent] that is a YES/NO field. I do not have a checkbox on the main form for the [Email Sent]; instead this field is checked (in the table) when the user sends an email to the receipient. I use the [Email Sent] field as a criteria for...

Thanks for your help Isskint; it is very much appreciated.