Help here please for beginner!

[markpastoril]

please tell me how to convert ms access vb code to run to sql code?



like this one?

Dim DOW As Integer
DOW = Weekday(DueDate)


Select Case DOW
Case 1 'Sun
GetNewDuedate = DateAdd("d", 1, DueDate)
Case 7 'Sat
GetNewDuedate = DateAdd("d", 2, DueDate)
Case Else 'all other days
GetNewDuedate = DueDate
End Select

please tell me if this code will take effect on my ms access application even if I'm using SQL Server?

[June7]

That code should work in VBA.

[markpastoril]

thank you for reponse sir,
so that will work? even when I use the sql server database sir?

[June7]

I don't use SQLServer but it should work. Why haven't you tried?

[markpastoril]

i did try it now and it worked, thanks a lot

[markpastoril]

on the other hand sir, I want to use List Box as a Child field instead Subform in my form, I would like to know how to do it?

[June7]

Why would you want a listbox instead of subform?

[markpastoril]

coz I think it's clean to look for my project, if ever?
could you look the at my new thread sir?about passing new data from other form?

[ArviLaanemets]

You wanting to use listbox instead of subform probably means you want implement a multi-value field. SQL Server does not support multi-value fields. If you fill a text field with comma or semicolon delimited strings, there is no way to make SQL Server to handle them as separate values. All this must be done through code in front-end (in case this is possible at all). My advice is - avoid them even in fully Access-based Applications.

[markpastoril]

i see, now i understand btw, am using subform on my database. thanks for that