Startup Hide access window &View myform,timer function, combo prop

[Guest]

If some one give me advice I will be very grateful. I have table with
ID,Code,Product_Img 3 fields.
I created form with above fields and combo Box . Combo4searching Code when
user enter the code. Its fine.
I include timer function to form on timer, and interval = 60000 First image
is comment: introducing my program.
User can search by entering code and view product picture and description.
Private Sub Form_Timer()
Enabled = True
DoCmd.GoToRecord , , acFirst
End Sub

Private Sub Combo4_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo4])
Me.Bookmark = rs.Bookmark
End Sub

Some time timer function gives me error.
I need to improve this. I am now to vb and access.

1. Need to improve form
2. How can I hide access window. View only form. exe file.(I minimize
database, But can not do anything with access window. I need to hide access
window. I set start-up – This Form)
3. need to correct error in timer function
Thank you so much
Chandrika

 

[Guest]

2. To hode DB use the code
docmd.RunCommand acCmdWindowHide

3. Create an error capture
Private Sub Form_Timer()
On error goto FormTimerError
' Enabled = True
DoCmd.GoToRecord , , acFirst

FormTimerExit:
Exit Sub
FormTimerError:
msgbox error
resume FormTimerExit
End Sub

 

[Guest]

Thank you very much it work. Now i am using barcode scaner.
Scan bar code in to combo. it find product and goto next record.
it mean after scan it find the record and enter activate. After scan
find the record and goto next & display the next record in the table.
when i am doing by typing through keybord it work properly.
1. i need scan the code & same record = bar code. How can i hold this
i am a student Please help me i will be very greatful.
--

 

[Guest]

Same process i have done using Parameter Quary.
it is working nicely. But do not like Parameter Quary
Dialog Box.
How can i do the same with out Parameter Q Dialog box.
it will be best same form kind like small dialog box
every time pop up. Or Combo Box to find the record.
Thank you very much in advance
Chandrika