Recent content by king07

Okay-- so the box is not bound-- which is no big deal for me to bind it except for one problem-- this field i have it set to auto sum with the following: =DateAdd("yyyy",1,[Last Review Date]) is there anyway to still bind it -- The main problem that the users are experiencing is that they...

not sure-- if it is bound what is the best way to fix it?

Good Morning Hopefully this makes sense-- i have my db setup for employee development. What i have found is that when a new record is created within my form not all the information from the form gets updated into the table. The problem that this creates is that when my users pull a query for...

How would i go about locking the field-- i looked in the properties and am unable to find it

Good Morning I am attempting to apply a filter to a query i have setup. I only want the user to be able to search for specific words within two fields (technical and behvaioural) i have setup. I know i have to use a WHERE expression but am confused as how to exactly setup the expression...

Morning everyone I am stumped with a query i am doing. I have my query setup and a dialog box for my users to select their parameters for what they want to search fo. When i test it though-- and use the combo boxes the whole table comes up and not just the search criteria i have entered...

when i enter that i am getting an invalid error-- "you have entered an operand without an operator" any suggestions?

Hi I have a quick question about queries-- I currently have a query setup to show the status of users career reviews- (completed,overdue and upcoming)- i want my query to just show the overdues in the status field, rather than all users (currently includes the other users who arent overdue...

Thanks Doug It worked!!

hello i have the following expressions: Status: IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),"UpComing",Iif([LastReviewDate]>=#11/1/2006# And([LastReviewDate]<=#10/31/2007#,"Complete"))) when i try to close my query and save i get the error of the expression you...

:o Okay Doug thanks BIG time for the help Here is what i have as an expression Status:IIf([Last Review Date]>=#11/1/2006# And ([Last Review Date]<=#10/31/2007#, "Completed",IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),”UpComing”,””))) and the error that now...

I believe you're going to need a record for every employee that details each review date for each fiscal year. If you don't have that, any "Last Review Date" less than the current date will logically show up as "Complete", when what I think you're after is the date of the review - if any - for...

Keith. I am now getting an invalid syntax error for using overdue. Here is my exact expression...what am i doing wrong?? Status: IIf([Last Review Date]>=#31 OCT 2008#,"Completed”,IIf([Next Discussion Due]<=Date(),"Overdue”,IIf([Next Discussion Due]>=Date(),"Upcoming”)))

The above expression is exactly how i have it written in my query (which i assume is the wrong way to have it). I do not want completed to be a parameter... i just want it to show completed if the discussion happened in the current fiscal year. How do i incorporate that?