please help

[vivian]

I'm confused. We added another computer to our network and the forms work super great on the 6 other computers we have. I am having trouble with this new one with one particular form- Qty Moved Out.

At first, the regional settings were different, so the dates that were automatically entered by the form were way out of wack.

Now, I have fixed that problem and the automatic date for the main form works just fine, however the automatic dates for the subform do not work- they work on all our other computers but not this new computer. These dates are important, so if anyone can help it's much appreciated.

Thanks

 

[vivian]

change

sorry, I was just told that the date for the main form he has to enter as well.

The automatic dates do not seem to work with this new computer at all (it's not really new, just new for this purpose)

 

[keith_pyrasoft]

Can you say more about how those dates don't work?

 

[vivian]

more info......

ok,

well the dates that have been entered by the other 6 or 7 computers will show up in the "new computer". however the current date is supposed to automatically entered once a part number is chosen from the list.

This new computer doesn't put the date in, it leaves the field blank, (#Name-shows up in the new record field but nothing is entered- the other computers all work fine with the current date being entered as a part# is chosen).

thanks for any help you have

 

[keith_pyrasoft]

Vivian

This suddenly starts to sound familiar - is the new PC running the same operating system as the others? I had a date problem recently with Access 97 running under XP, where it had been fine under 98SE.

Keith

 

[Rich]

You have a Missing Reference, search here for solutions

 

[vivian]

hmmm

Keith,

Yes they are running different operating systems, the others are all windows 98 or higher and the one giving the trouble is windows 95. It is a bit of a slow computer and older so it came with windows 95. Is there any way to change this without switching to windows 98?

 

[keith_pyrasoft]

vivian

My occurrence of this problem was in a form I designed when I first started using Access, and was experimenting with techniques. I found that I had assigned =date() and =time() to the Default Value properties of the fields concerned so that they were automatically loaded for data entry. This worked in WIN98 but not in XP.

How have you assigned your date?

Keith

 

[vivian]

Yes, this is how I have assigned the dates. =Date() to the default value

 

[keith_pyrasoft]

OK.

Remove those assignments from the Default Value properties, and instead set the values against the Open property of the form (or the Current property, depending on how you want it to work).

eg:

Private Sub Form_Open(Cancel As Integer)
Me!CostDate = Date
End Sub

This should provide what you want. I don't know why it doesn't work in certain operating systems, and frankly it's probably not worth pursuing. Including it as code gives you more flexibility, too.

hth

Keith

 

[vivian]

?

Sorry, I'm very new to the coding thing.

When I tried the code
Private Sub Form_Open(Cancel As Integer)
Me!Date = Date
End Sub

I get the message

"Run Time Error '2448'
You can't assign a value to this object"

I did make sure that I deleted the =date() from the control default value.

I'm not sure what I'm doing wrong


Thanks for your help thus far!

 

[keith_pyrasoft]

Sorry - I should have been clearer.

In Form properties, click the On Open property and use the Code Builder to give you the

Private Sub Form_Open(Cancel As Integer)

End Sub

routine.

Insert the statement

Me!MyField = Date

where MyField is the name of your date text box on the form. This will place the current date into the field.

 

[vivian]

alright

OK, this is what I've got,
I open properties of the form and used the Code Builder

Private Sub Form_Open(Cancel As Integer)
Me!Date = Date
End Sub

I Inserted the statement
Me!Date = Date
after the ( [Date] is my field name)
Private Sub Form_Open(Cancel As Integer)
and before the
End Sub

and I'm still getting this error

"Run Time Error '2448'
You can't assign a value to this object"

thanks

 

[keith_pyrasoft]

OK

Try changing the name of the field to something else than 'Date'.

 

[vivian]

hmmm,

I'm wondering if I've stumped both of us now

I tried changing the [date] field to [date2] and I still seem to get this silly error when I go to view the form. I'm thinking it's because there are all those other dates in that field from before?

Maybe on that crazy computer he'll just have to type all those dates in there.