Search results

That worked like a charm! Thank you! :p

It's saying:"You must enclose IIf function arguments in parentheses." I'm adding this: CriticalityNumeric: IIf([Criticality]="Low", 1, IIf [Criticality]="Medium", 2, 3) as a new field in my query, right? I must be missing something...sorry... :confused:

I'm guessing it would be something like this, right? Criticality: (IIf[Criticality]="Low", 1), (IIf [Criticality]="Medium", 2), (IIf [Criticality]="High", 3) This is not working...returning an error. Not really sure if what I'm doing is correct. Thank you!

I have a field called Criticality with these values: Low, Medium, High. On my report is there a way to sort it by these values, lets say from Low to High? In the sort/group menu I can only sort in Ascending or Descending. Thanks!

I will try that. Thank you!

I have a form where a user selects a project, then a staff for that project, then managers name, then unit, and then a reponsibility for that person. After that I have 5 sets of calendars (5 start and 5 end dates: start1, end1, start2, end2, etc...) due to the type of report I want to get out of...

I have cascading Combo boxes and there is usually 1 value to pick out of the list once all selections are made. Is there a way to just fill in that one single value into a combo box rather than having a user click and select it? Thanks.

Thank you very much for all your time. The table structure is perfect, you guessed it just right. I appreciate your help.

As long as it works... and now I know it works. Thank you.

That intellisense isn't that intelli then! But thank you for all your help!

Thank you so much! That worked great! Much appreciate your time and help!

This still didn't work... See attached picture. I don't get that option unless I click on Application and then .visible appears and that doesn't work either. Any ideas? Thanks.

I have a report where sometimes text boxes have values and sometimes don't. What I want to know if there is a way to code If IsNull(Text10) Then Text10.visible = False End if There is no Events on those text boxes and even when I try and code text10. the Visible option doesn't come up at all...

I guess I'm not sure what that means, sorry... I'm just starting out with Access, so if you could provide a more detailed explanation, that would be great. Thank you.

I have a report where I need to manipulate some dates and I'm not really sure how to do it. I'm attaching a document so this would be easier to understand. Right now for each and every Project for the same person there is a new section with certain dates. Those dates are sorted in the right...

Anyone, please. I really need help on this one... I have tried so many different things yesterday and nothing worked. Any insight on what I can do... Thank you.

I actually tried that as well...still can't figure out how to make this work. :( Any help would be greatly appreciated! If there are any questions, please let me know as well. I really need to get this piece figured out. Thank you again!

I got the cascading boxes thing down and fixed everything in my database, however there is still 1 problem. When I click on my form to select a Functional Area, I'm not storing that value in FAID because I need up to 5 Functional Areas with 5 different sets of dates. I know I'm doing this wrong...

I've been at this all week and I hope that someone will be able to understand what I need. I had to take a lot of thigs out of my database (including my form) in order to make it fit to attach it. I'm also attaching a copy of all my relationships that I have in my database as well as a print...

Spasibo! I think everything works, i just have some duplicate records I need to look into.