Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Maybe an easy question! Pleaaase help!!

Author  Topic 

sm0wb04rd3r
Starting Member

15 Posts

Posted - 2004-01-23 : 01:56:31
Hi there Everyone!

I have a problem with my form! Please try to help if you can!

I have a form and a subform in it. In the form are the infos about the cusotmers and in the subform is their orders.
My problem is that the subform has its record menu (bottom-left). In the ms access northwind example database this menu is not visible.
How could I make that record menu disapper????

I hope you understood my problem!

My other problem is that when I want to display the date and time (tools menu/ paste date&time) the time is static (14:30:32). How could I make to display the time dinamically (you can see the seconds, minutes hours changing..)

Thanx a lot in advance!!!!

PS: I am a NEWBEE! :))

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-01-23 : 02:56:06
1. Open the subform in Design mode. Then Property sheet of the form.
And set Property "display record count" (I'm not sure how it goes in
English version (mine is Swuahili)) to "No".

2. Go to Events tab of the Property sheet of the form. In the very end
of it you'll find "Timer Interval", write in there "1000" (without quotes).
One line above it there is "Timer" event, activate it and put inside the
timer event subroutine this (see bold line below):

Private Sub Form_Timer()
Me.Name_Of_Your_Time_Textbox.Requery
End Sub
Go to Top of Page

sm0wb04rd3r
Starting Member

15 Posts

Posted - 2004-01-23 : 03:26:28
Thanx a lot for the solution!!!
Go to Top of Page
   

- Advertisement -