Search results

bump? can someone explain me?

how can i do that?

ahh.. still got problems with this piece of coding.. ive changed it slightly since i had unneeded variables, and changed txtDueDate to txtDateLoaned, but now it aint working. Also, the previous piece of coding i has undead "got focus" but thats not actually where i want it to work. I need it...

you want the filed to display the value Formated as Currency? ^^ that ill have a go at the format and ill report 2morow tnx edit: lovely, worked :)

Ok.. so ive been trying to convert a string to currency, but it seems its not working. Ive tried alot of workarounds, but still cant get it to work. Dim tday As Date Dim duedate1 As Date Dim amount Dim cur As Currency Dim difference tday = Date duedate1 = [txtDueDate] difference = Date -...

w00t.. sweet worked now.. i thought i tried that.. but seems i didnt ;) or i forgot the [] probably.. thnx

tried using = DateAdd("d", 2, Me.DateLoaned) in the text box.. also changed it to txtDateLoaned but i still get the "#Name?" error..

The source of information comes from [Date Loaned] from the "Loans" table which has is used as a subform in the main form am working with ("Members")

doesnt quite work.. i get a "#Name?"

Am trying to add (2) to the date found in the field Date Loaned, but it isnt quite working Private Sub DueDate_BeforeUpdate(Cancel As Integer) Test = "[Date Loaned]" Set [DueDate] = DateAdd("d", 2, Test) End Sub Ive tried different alternatvies such as [Loans]![Date Loaned], ive tried alot...