A Little Help Please

[kwazie_boy]

I am wanting to have a button on a home menu which links to another form and automatically goes to a blank record...I have looked through macros and I cant seem to find an answer there.

Any ideas? Thanks, Will

 

[jamesWP]

Ok, an easy way to do this would be through VBA, have you got any experience in visual basic at all?

 

[kwazie_boy]

:-( nope...just a novice

 

[jamesWP]

Ok, what is the name of the form that you wish the button to open?

 

[kwazie_boy]

i want to open 'Day' and go straight to a new record from the form 'Home'

 

[jamesWP]

Ok, from the main access window, go to the modules section, click on 'New'.
After that you should be presented with a note pad look-a-like, enter this into it;

Option Compare Database

Public Sub OpenAndNew()
Form_Day.Visible = True
DoCmd.GoToRecord acDataForm, Form_Day.Name, acNewRec
End Sub

After that save the module and go back to the main database window.

Go to your 'Home Page' form and create a button, cancel the wizard that pops up.

Right click the button and choose 'Build Event', choose 'code builder' from the list, inside you should be at the note pad look-a-like again, simply write down,

OpenAndNew

Save changes, go back to your main form and go into form view, clicking the button should now open up the 'Day' form and go to a new record.

Edit: Haven't actually tested this yet it's all guess work so just say if it goes wrong. Also the module code may need to contain the form name as it's not runningh on the form.

 

[kwazie_boy]

where in the code do I add OpenAndNew???When i build event on the existing button it is already full of code...

 

[kwazie_boy]

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

 

[kwazie_boy]

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

 

[kwazie_boy]

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

 

[kwazie_boy]

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

 

[kwazie_boy]

actually, i have now created a new button and pasted that OpenAndNew thing in there and when I click the button nothing happens

 

[jamesWP]

Did you cancel the wizard for the button? It should simply be a button assigned to do nothing.

 

[jamesWP]

Remove the On error resume next part from the module.

 

[kwazie_boy]

i have

 Private Sub Command9_Click()
OpenAndNew
End Sub
 [code]

and i get an error 'runtime 424, object required

 

[kwazie_boy]

btw, the module is called 'module1' if that makes any diff

 

[jamesWP]

If you click debug when the error arrives, which line of code is highlighted yellow?

 

[kwazie_boy]

Private Sub Command9_Click()

 

[jamesWP]

Try changing

Private Sub Command9_Click()
OpenAndNew
End Sub

to

Private Sub Command9_Click()
module1.OpenAndNew
End Sub

 

[kwazie_boy]

still nothing...thanks for ur help but i think ill find another way around it...maybe a new record button when the form is already open. thanks, will