Search results

Yes you are right in thinking that. My apology. Wrong example . I'll keep working to the examples you provided..its been very helpful.

No. Everytime a trenant is booking in, they are booked in a new record because they may be more than one tenant in the property ie single people sharing. So idealy, I only want to count those properties where there are no tenants occupying a property. Where tenants share ie 1 departed say...

Thanks Richo! works nicely but if we wanted to calculates the vacant between when someone departs and some else enters the property. effectively that formula is still counting a vacant days even if some else is residing the flat . I need it to somehow calculate the difference between last...

I took over an old DBs that is used to track tenants. The person who created it, no longer work for the dept . He created this query that calculates the days a property has been occupied. DaysOccupied: IIf(IsNull([DateOut]),DateDiff("d",[DateIn],Date()),DateDiff("d",[DateIn],[DateOut])) To...

Thanks Hudson, Works now! it now reads Resume Command118_Click_Err Thanks so much. :-)

Thanks for that Hudson Im getting a label not defined error Private Sub Command118_Click() On Error GoTo Command118_Click_Err Dim stDocName As String stDocName = "rpt4Week" DoCmd.OpenReport stDocName, acPreview Exit_Command118_Click: Exit Sub Command118_Click_Err...

Yes thats exactly the error message im getting. Im not sure how to trap the error message. I'll have quick look thru some post to see if I have a go myself first. If I cant figure it out, l'll get back to the forum.

I have a button that opens a report and in the report I have added a message if there is no records. How do turn off the message that is produced by access. Is an error handler involved, if so, how and where is it placed to stop the message popping up after the On_Nodata is run. 'button on...

thanks dude

I have a txtDateIn and txtDateOut and chkActive fields on a form. What im trying to do is make the chkActive field true if txtDateout is null. I tried the following but it not as neat as I would like. Basically when ever the dateout field is null I need the check box ticked and visa versa. I...

Perfect! Thanks Milo

Im using a combo box and I want to open a word doc depending on what I have selected in my combo box. I did a quick search on the forum but didnt find anything. e.g Case Select If Me.cboRegion.value = "West" then Open word doc c:\letters\4weekletterWest.Doc If Me.cboRegion.value = "North"...

Im just not getting it. Ive attached a strip down version of the list box. Im using the multiselect list box which allow me to selected multiple addresses is so that I can send the address to lotus notes at a later stage.

I dont know if this is effective but try this Dim StrInput As String StrInput = "mailto:" & Me![E-mail Address] Application.FollowHyperlink StrInput, , True

I think I will go with Me.lstEmail.requery but how do I delete the selected email address via the listbox and delete it. Should use something like this to delete the email address via a form: DoCmd.Openform "frmEmails", , , "[EmailID] = " & lstFound.Column(0) Me![lstEmail] = ""...

Yep! delete an item. The list box is populated via Table/Query

I have multiselect list box that hold emails addresses for contractors. There will times when an email address maybe obsolete therefore I need delete it. Ive search the forum on how to delete the selected item but I could find anything. I would like to delete the selected item via button on...

Ive found the problem..there was a missing bracket Iif(IsNull([DateOut), ] Thanks for your help guys!!!!!!!!!!!!!!!!!!!!!! awesome stuff!!

I copied and pasted Pats syntax and I still got a argument error DaysOccupied: Iif(IsNull([DateOut), DateDiff("d", [DateIn], Date()), DateDiff("d",[DateIn],[DateOut])) This was my original sql SELECT tblTenant_Property_Bookings.BookingID, tblTenant_Property_Bookings.PropertyID...

Now its telling me that the function I entered has a function containing the wrong number of arguments! Can I kick the computer now! hehe