Search results

im still getting a syntax error..Am i missing something? DaysOccupied: Iif(IsNull([DateIn),DateDiff("d",[DateIn],Date(),DateDiff("d",[DateIn],[DateOut]))

Hey Rich! Im getting a syntax error.(invalid syntax) what is DateField?

Im using the date diff function to count no of days for a datein and dateout. This part is straight foward but how get it to calculate those record where the is no date out? So where there is a null in date out I need it to count it from todays date.

thanks for that. I would have done a search but I didnt what key works to use. I tried using the following : Right([Address],Len([Address])-InStr([Address]," ")) Obviously Im doing something wrong because the entired address updated to the Suburb field in the update query except for the street...

Help I have a field calledd address field that contains the street name and suburb. Is there any way to remove the suburbs and add them to a field called suburnbs in the same table. When i first did the db I failed separate the address details so that I can do report by suburbs.

Thanks!...i dont think I can do. we are still using A97 at work. Can I still do it from A97?.

would someone be kind enough to convert this to A97. Thanks!

Thanks..I'll do a search.

Im trying create a DB to book in tenants into our houses. I need to be able to do reports on who is currently in the houses and who have been booked. So effectively a house can have many tenants and bookings. the booking form should enable a user to select a tenant from the tenant table and add...

Thanks! I didnt know i needed to use two dlookups. I dimmed the results of the dlookup and then cancatenated (" & strRecordOwner & " , " & strGivenName & ") works nicely now! thanks a million :-)

Im trying to display the LastName and GivenName in a message box using a dlookup. I have the Message working nicely but becuase there many people with the same surname I need to have the Givenname to included in the message box strOwner = DLookup("[LastName],[GivenName]", "tblClient", "[SSN]='"...

Thanks!

how do you format a number so that the default is set to 05 . Ive set the format to 00 and then set the dafualt to 05 but he value is being stored as 5 which is what I dont want.

Ok! heres a sample of what you are trying to acheive!. I have plenty of other sample if u need any but Im sure if you look up cascading, you will find heaps of sample on this forum Jack has given you a good starting reference point.

I actually tried placing it in Onload Event but it didnt work. I thought that it should go else where and thats why I replied asking where does it go. I cant understand what the heck im doing wrong. The name of the Calendar control is simply Calendar. Me![Calendar].Value = Date. It has me...

Thanks jack. where exactly should I put it. Private Sub Calendar_Click() 'copy the selected date across to the start date field, 'hide the calendar and move to the end button If Me.cmdDate.Caption = "Set Start Date" Then Me.StartDate.Value = Me.Calendar.Value Me.cmdDate.Caption =...

heres atnother samples you might find useful

Im using the Active X MSCAL.Calendar.7 to set Start and End date fields on a form. My problem is I cant get the calender to default todays date. When the calendar opens, the date is set to march 2002. Any solutions anyone.?

awesone dude!! I was using GetUserName!!!!! instead if GetCurrentUserName I nearly had it!! Thanks for your time :-)

Thanks, I'll do a search. The only reasons that I posted my question was that I did a one stage manage to insert the UserName but removed it becuase at the time a felt it was necessary. Now I have completely forgotton how I did it. I wish I had a refresh button..hehe