data in date format

[autoIT]

I have a field of a table that has a date in the following format:

OCT-1-06

I wrote a data base in VB that will do something specific if this field is OCT-1-06, or will do something else if this field is OCT-2-06, so on and so forth. My dilema is actually checking what the information is in this field and my coding is basically the following. Please tell me what I need to do differently to not get the EOF BOF error:


Dim Period as Date/String(not sure which)
Period=tblO1.fields.item("Period")

If Period = "OCT-1-06" Then
more code will go here
else if Period = "OCT-2-06" Then
do this instead
end if

Not exact on the rules here. What is the correct coding for this.

Thanks
Adam

 

[SkipVought]

Hi,

Dates are not STRINGS.

If Period = #OCT-1-06#Then

Skip,
[sub]
[red][/red]
[/sub]

 

[autoIT]

skip,

never saw the pound sign coding before, would this work if i'm using access 2007 and vb. What do the pound signs represent, are they a wild card of sorts?

Adam

 

[autoIT]

just tried it and i see what it does, but it turns the date into xx/xx/xxxx format and it needs to be OCT-1_06 format because OCT-1-06 represents first 10 days in October OCT-2-06 represents second 10 day.....

 

[SkipVought]

Converts a STRING to a DATE. Period must be defined as a DATE.

If Period = #OCT-1-06# Then

You might take a look at Select Case

Select Case Period
  Case #OCT-1-06#

  Case #OCT-2-06#

  Case Else 

End Select

Skip,
[sub]
[red][/red]
[/sub]

 

[autoIT]

thought about the selec case and by your suggestion tried it but still getting the bof/eof error:

also have period variable set as date and column in table I'm sending the data to and the colum in which the info is coming from set to date as opposed to text. Just not sure what else to try.
Adam

 

[SkipVought]

If it's still not working, step into the procedure of put a break on that statement.

Ues the Watch Window to observe the VALUE in Period and the VALUE in #OCT-1-06#. Are they EQUAL???

Skip,
[sub]
[red][/red]
[/sub]

 

[autoIT]

im aware of how to step through but where is the wtach window.

 

[autoIT]

what i meant was i know where it is but im not familar with how it works

 

[SkipVought]

View/Watch Window

You can select a varible/constant and open the WW or enter the name directly into the WW.

Skip,
[sub]
[red][/red]
[/sub]