Search results

@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...

Hey, I've taken a look at an append query, but I don't think it's what I am looking for. What I was thinking was to add a DoCmd. to my event. My current event is below: Private Sub Check96_AfterUpdate() If Check96 = True Then Me.[Status] = "Returned (Pending)" End If If Check96 = True Then...

Hi GinaWhipp, I was updating the Test History table via the Master form. But I created the query (due for testing) and the new form (Test request) to allow me to enter data that way, for a number of records. The new Test Request form is a continuous form that allows me to view a number of...

Hi everybody, Hope you're all well. Here is my set-up. I have two tables: 1. Equipment. 2. Test History. I have one query: 1. Due for testing. I have two forms: 1. Master. 2. Test request. I have a master form, where for each record (from the equipment table) I have a sub datasheet...

Thanks missinglinq, I did try commas but I did " , " instead of ", ". Amazing what that little space can do! Thank you.

Hey pbaldy, Thanks for the post. It looks like I am on the wright track with this now. I've done some more research and found the cascade method best for me, and that is to source the row source of the changeable combo list from a different table. However, I am only getting one lot of options...