Search results

I waited for your reply. I tested your suggestion, it worked and handles Nulls. Sorry my mistake, i didnt mean to hurt your feelings. thanks for helping and making me realize. The credit goes to you because due to your experience the way you think about solutions , i cant. Sorry again. have a...

OK i tried your SUGGESTION Bingo it handles Nulls. You are great. Sorry my mistake, i didnt mean to hurt your feelings. thanks for helping and making me realize. have a Nice day.

I know that. According to your hint, i tried the following code If Not IsNull([StartDate]) Then If Not IsNull([EndDate]) Then If (Format(StartDate, "YYMM") = Format(EndDate, "YYMM")) Then Me.BillingMonth = Format(StartDate, "MMM-YY") Else Me.BillingMonth = Format(StartDate, "MMM-YY to ") &...

Thanks for the hint but i found more appropriate solution =IIf(Format([StartDate],"yyyymm")=Format([EndDate],"yyyymm"),Format([StartDate],"mmm-yy"),Format([StartDate],"mmm-yy") & " to " & Format([EndDate],"mmm-yy"))

Plz Help.

i have 3 textbox in a form with date type as date. 1- StartDate (bound to table) 2- EndDate (bound to table) 3- BillingMonth (unbound) i want to display billing month based on start and end date according to criteria that if startdate is 1/1/09 (format dd/mm/yy) and enddate is 28/1/09 (format...

Thanks For Helping. i did these blunders when i could not make the code work. The Solution i found was that there something wrong with my system file or the version of access 2003 i am using. i tried the same code on different Pc with another version of access 2003 and it worked. Now i am using...

same error.

i am using DateDiff to display difference between to dates , but it does not work. 1)-using vba code (after/before update ) event does not work. 2)-using unbound control source gives me error "the expression you entered has a function containing wrong number of arguments" i am using this...

i found the solution here is the Modified code Dim strsql As String Dim i As Integer Dim Msg As String Dim s As String 'Exit this sub if the combo box is cleared If NewData = "" Then Exit Sub Msg = "'" & NewData & "' is not currently in the list."...

I have a problem getting a proper case function to work in my combo box. I have a combo box [City] with some code in the On Not in List event that adds new entries not already in the source table. The proper case function (i.e. City = StrConv(City, vbProperCase) is used in most of the other form...

Thanks For The Info I would Prefer no 2 or 3 to prevent gaps.

It Works. Thanks For Helping.

Question: Wouldn't be better to store a copy of Autonumber in another table and when the form safely saves the record increment the number otherwise don't increment. so the next autonumber should be taken from the other table. In this way there will be no gaps between Autonumber. how would it...

Is there any way that ends user gets balloon tips when mouse pointer moves on a textbox or combox.

Thanks for quick reply . I will search the forum.

I am new to Database. i have a form with an Autonumber field and some other fields with validation rules. If user cancels or closes the form or if record is not saved, i want prevent Autonumber from incrementing. It should Increment if a record is saved with all validation rules fulfilled. In...