Recent content by Gerdagan

@Beetle, that's exactly it. @Pat Hartman, I've checked this also and all is fine.

Thanks Beetle. My form isn't continuous no.

Thanks missinglinq, I did try it with the 'IIf' at first, but i didn't get anything from that either, so I assumed it was a typo. My current statement is: =IIf([TBDUEDATE]<Date(),"Overdue","") I have had to remove the reference to the form '[ME]', as this returned the '#NAME?#' error...

Thanks Alansidman, But I just can't get this to work. When I view my form, all I get is the '#NAME?' error. I have tried the following variations: =IF([ME].[TBDUEDATE]<Date(),"Overdue","") =IF([TBDUEDATE]<Date(),"Overdue","") =IF([FORMNAME].[TBDUEDATE]<Date(),"Overdue","") Any ideas how...

Hi all, I hope everyone had a good Easter. I have a very simple addition to make to my database, but I cannot figure out how to do it. I have a text box (TBDUEDATE) on my form that holds a date. I have another unbound text box that I need to display the words 'overdue' if the date in...

Thanks John, I've looked at the 'date pick' example you gave, but to me that looks more uncomplicated and un-normalised as my T-Dates table. I've taken a look at the un-normalised info. on Wiki, but it just confuses me. And the DataPart() link leads me to the Wiki also. Thanks a lot for taking...

Thanks John, But I am still struggling to see how I can apply this to my DB. I have uploaded an example. What I am trying to do is open the Form 'F-Booking' to the matching record as stated in the Form 'F-Date' when the date is selected using the combo boxes. I hope someone can help...

Hi all, The question I have is quite specific. I have looked through the forum, and the big www, but I can only find general examples, and I just can't seem to make them fit my needs. Here is my set-up. Table name: T-Dates Fields in table: Date (e.g. 01/01/12), Day (e.g. 01), Month (e.g...

Hi all, I am looking to create a database to allow users to make new and view existing reservations of office resources (e.g. projector, conference phone, etc) and pool cars. I am stuck where to begin with this. My idea is to have a calendar style view (as in Outlook) that will allow...

Thanks for that Goh. How would a write the coding for that? I'm having some trouble figuring it out.

Thanks very much, the append query worked. I had to change a few things to make it work but it is much easier than anything else I could have tried. Thanks.

Hi all, I have a form that is sourced from a query. Sometimes there may be no records to display. Is there any way of having a label in the detail of the form that states "No records available" for example. Thanks. Ged.

Thanks for that. But I've been taking a look into Append queries further (as suggested by GinaWhipp), and this seems to be the way I will be able to do what I want to do. Thanks for all your input guys. I really appreciate it.

Well I've set-it up as you said, but its still not working. When you say is the form bound, do you mean it has a source? If so, then it is bound to the Due for testing query. The two tables, Equipment and Test History are linked with a unique ID. Do I need to include this in the coding? Is...

Hey thanks, Unfortunately, I can't use data entry type, as the query is in place to show me equipment due for testing. So the form shows those records, with a check box which confirms receipt of the equipment for testing. I'm pretty sure I can do what I am looking for by amending the event...