I've got a data input from on my database. When I have input the data
(often a single item) I then:

close the form
create a report
print the report (a label)
run an update query

The update query (which asks me twice if I'm sure) is to remove a
"print me" flag and put the current date in the date field.

This would be so much easier if I could do it all from the input form,
preferably from a single button, but at this stage I don't know if the
underlying table has been updated with the data.

Even if I had to close the input form first, is it possible to
automate such tasks, as in a macro?

--
Nigel M

The ideal method is to create the report's design first and simply fill it
with data from the form. There are many ways to do this, but here's one of
the simplest (air code):

Sub MyButton_Click()
On Error GoTo Error_Handler
DoCmd.RunCommand acCmdSaveRecord

DoCmd.OpenReport "YourReport",,,,"ID=" & Me.txtIDField

DoCmd.SetWarnings False
DoCmd.OpenQuery "Your Update Query"

Exit_Here:
DoCmd.SetWarnings True
Exit Sub
Error_Handler"
MsgBox " Err.Number & ": " & Err.Description
Resume Exit Here
End Sub

There are better ways of running the update query, but that one is the
simplest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Nigel Molesworth" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I've got a data input from on my database. When I have input the data
> (often a single item) I then:
>
> close the form
> create a report
> print the report (a label)
> run an update query
>
> The update query (which asks me twice if I'm sure) is to remove a
> "print me" flag and put the current date in the date field.
>
> This would be so much easier if I could do it all from the input form,
> preferably from a single button, but at this stage I don't know if the
> underlying table has been updated with the data.
>
> Even if I had to close the input form first, is it possible to
> automate such tasks, as in a macro?
>
> --
> Nigel M

On Mon, 27 Feb 2006 06:22:58 -0500, Arvin Meyer [MVP] wrote:

>The ideal method is to create the report's design first and simply fill it
>with data from the form. There are many ways to do this, but here's one of
>the simplest (air code):

Thanks for your reply, but I'm afraid I don't understand what to do.

--
Nigel M

1. "MyButton" is the name of your button. In the property sheet go to the
click event, drop down the arrow and choose [Event Procedure] The click on
the ellipses button (...)

2. "YourReport" is the name of the report you wan to run.

3. Me.txtIDField is the textbox with the ID of the record on the form.
Replace "txtIDField" with your textbox name.

4. "Your Update Query" is the name of the update query you wan to run.

All the other code needs to be cut and pasted EXACTLY like you see it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The ideal method is to create the report's design first and simply fill it
> with data from the form. There are many ways to do this, but here's one of
> the simplest (air code):
>
> Sub MyButton_Click()
> On Error GoTo Error_Handler
> DoCmd.RunCommand acCmdSaveRecord
>
> DoCmd.OpenReport "YourReport",,,,"ID=" & Me.txtIDField
>
> DoCmd.SetWarnings False
> DoCmd.OpenQuery "Your Update Query"
>
> Exit_Here:
> DoCmd.SetWarnings True
> Exit Sub
> Error_Handler"
> MsgBox " Err.Number & ": " & Err.Description
> Resume Exit Here
> End Sub
>
> There are better ways of running the update query, but that one is the
> simplest.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Nigel Molesworth" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I've got a data input from on my database. When I have input the data
> > (often a single item) I then:
> >
> > close the form
> > create a report
> > print the report (a label)
> > run an update query
> >
> > The update query (which asks me twice if I'm sure) is to remove a
> > "print me" flag and put the current date in the date field.
> >
> > This would be so much easier if I could do it all from the input form,
> > preferably from a single button, but at this stage I don't know if the
> > underlying table has been updated with the data.
> >
> > Even if I had to close the input form first, is it possible to
> > automate such tasks, as in a macro?
> >
> > --
> > Nigel M
>
>

Marvin, you said that:
"There are better ways of running the update query, but that one is the
simplest."
Could you tell us what are these other ways, or maybe indicate a website
that contains such information?

"Arvin Meyer [MVP]" wrote:

> 1. "MyButton" is the name of your button. In the property sheet go to the
> click event, drop down the arrow and choose [Event Procedure] The click on
> the ellipses button (...)
>
> 2. "YourReport" is the name of the report you wan to run.
>
> 3. Me.txtIDField is the textbox with the ID of the record on the form.
> Replace "txtIDField" with your textbox name.
>
> 4. "Your Update Query" is the name of the update query you wan to run.
>
> All the other code needs to be cut and pasted EXACTLY like you see it.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > The ideal method is to create the report's design first and simply fill it
> > with data from the form. There are many ways to do this, but here's one of
> > the simplest (air code):
> >
> > Sub MyButton_Click()
> > On Error GoTo Error_Handler
> > DoCmd.RunCommand acCmdSaveRecord
> >
> > DoCmd.OpenReport "YourReport",,,,"ID=" & Me.txtIDField
> >
> > DoCmd.SetWarnings False
> > DoCmd.OpenQuery "Your Update Query"
> >
> > Exit_Here:
> > DoCmd.SetWarnings True
> > Exit Sub
> > Error_Handler"
> > MsgBox " Err.Number & ": " & Err.Description
> > Resume Exit Here
> > End Sub
> >
> > There are better ways of running the update query, but that one is the
> > simplest.
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads
> > http://www.datastrat.com
> > http://www.mvps.org/access
> >
> > "Nigel Molesworth" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I've got a data input from on my database. When I have input the data
> > > (often a single item) I then:
> > >
> > > close the form
> > > create a report
> > > print the report (a label)
> > > run an update query
> > >
> > > The update query (which asks me twice if I'm sure) is to remove a
> > > "print me" flag and put the current date in the date field.
> > >
> > > This would be so much easier if I could do it all from the input form,
> > > preferably from a single button, but at this stage I don't know if the
> > > underlying table has been updated with the data.
> > >
> > > Even if I had to close the input form first, is it possible to
> > > automate such tasks, as in a macro?
> > >
> > > --
> > > Nigel M
> >
> >
>
>
>

Check Access VB Help on the Execute method of the Database object (DAO) or
the Connection object (ADO).

BTW, Mr Meyer's first name is ARVIN, not Marvin.

--
HTH
Van T. Dinh
MVP (Access)



"b_bussoloti" <(E-Mail Removed)> wrote in message
news:FEA2EB36-9DC5-4755-B5F2-(E-Mail Removed)...
> Marvin, you said that:
> "There are better ways of running the update query, but that one is the
> simplest."
> Could you tell us what are these other ways, or maybe indicate a website
> that contains such information?
>
> "Arvin Meyer [MVP]" wrote:
>
>> 1. "MyButton" is the name of your button. In the property sheet go to the
>> click event, drop down the arrow and choose [Event Procedure] The click
>> on
>> the ellipses button (...)
>>
>> 2. "YourReport" is the name of the report you wan to run.
>>
>> 3. Me.txtIDField is the textbox with the ID of the record on the form.
>> Replace "txtIDField" with your textbox name.
>>
>> 4. "Your Update Query" is the name of the update query you wan to run.
>>
>> All the other code needs to be cut and pasted EXACTLY like you see it.
>> --
>> Arvin Meyer, MCP, MVP
>> Microsoft Access
>> Free Access downloads
>> http://www.datastrat.com
>> http://www.mvps.org/access
>>
>> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > The ideal method is to create the report's design first and simply fill
>> > it
>> > with data from the form. There are many ways to do this, but here's one
>> > of
>> > the simplest (air code):
>> >
>> > Sub MyButton_Click()
>> > On Error GoTo Error_Handler
>> > DoCmd.RunCommand acCmdSaveRecord
>> >
>> > DoCmd.OpenReport "YourReport",,,,"ID=" & Me.txtIDField
>> >
>> > DoCmd.SetWarnings False
>> > DoCmd.OpenQuery "Your Update Query"
>> >
>> > Exit_Here:
>> > DoCmd.SetWarnings True
>> > Exit Sub
>> > Error_Handler"
>> > MsgBox " Err.Number & ": " & Err.Description
>> > Resume Exit Here
>> > End Sub
>> >
>> > There are better ways of running the update query, but that one is the
>> > simplest.
>> > --
>> > Arvin Meyer, MCP, MVP
>> > Microsoft Access
>> > Free Access downloads
>> > http://www.datastrat.com
>> > http://www.mvps.org/access
>> >
>> > "Nigel Molesworth" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> > > I've got a data input from on my database. When I have input the data
>> > > (often a single item) I then:
>> > >
>> > > close the form
>> > > create a report
>> > > print the report (a label)
>> > > run an update query
>> > >
>> > > The update query (which asks me twice if I'm sure) is to remove a
>> > > "print me" flag and put the current date in the date field.
>> > >
>> > > This would be so much easier if I could do it all from the input
>> > > form,
>> > > preferably from a single button, but at this stage I don't know if
>> > > the
>> > > underlying table has been updated with the data.
>> > >
>> > > Even if I had to close the input form first, is it possible to
>> > > automate such tasks, as in a macro?
>> > >
>> > > --
>> > > Nigel M
>> >
>> >
>>
>>
>>

Many thanks for the help.... and sorry for the mispelling of Mr. Arvin Meyer
name.

"Van T. Dinh" wrote:

> Check Access VB Help on the Execute method of the Database object (DAO) or
> the Connection object (ADO).
>
> BTW, Mr Meyer's first name is ARVIN, not Marvin.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "b_bussoloti" <(E-Mail Removed)> wrote in message
> news:FEA2EB36-9DC5-4755-B5F2-(E-Mail Removed)...
> > Marvin, you said that:
> > "There are better ways of running the update query, but that one is the
> > simplest."
> > Could you tell us what are these other ways, or maybe indicate a website
> > that contains such information?
> >
> > "Arvin Meyer [MVP]" wrote:
> >
> >> 1. "MyButton" is the name of your button. In the property sheet go to the
> >> click event, drop down the arrow and choose [Event Procedure] The click
> >> on
> >> the ellipses button (...)
> >>
> >> 2. "YourReport" is the name of the report you wan to run.
> >>
> >> 3. Me.txtIDField is the textbox with the ID of the record on the form.
> >> Replace "txtIDField" with your textbox name.
> >>
> >> 4. "Your Update Query" is the name of the update query you wan to run.
> >>
> >> All the other code needs to be cut and pasted EXACTLY like you see it.
> >> --
> >> Arvin Meyer, MCP, MVP
> >> Microsoft Access
> >> Free Access downloads
> >> http://www.datastrat.com
> >> http://www.mvps.org/access
> >>
> >> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> > The ideal method is to create the report's design first and simply fill
> >> > it
> >> > with data from the form. There are many ways to do this, but here's one
> >> > of
> >> > the simplest (air code):
> >> >
> >> > Sub MyButton_Click()
> >> > On Error GoTo Error_Handler
> >> > DoCmd.RunCommand acCmdSaveRecord
> >> >
> >> > DoCmd.OpenReport "YourReport",,,,"ID=" & Me.txtIDField
> >> >
> >> > DoCmd.SetWarnings False
> >> > DoCmd.OpenQuery "Your Update Query"
> >> >
> >> > Exit_Here:
> >> > DoCmd.SetWarnings True
> >> > Exit Sub
> >> > Error_Handler"
> >> > MsgBox " Err.Number & ": " & Err.Description
> >> > Resume Exit Here
> >> > End Sub
> >> >
> >> > There are better ways of running the update query, but that one is the
> >> > simplest.
> >> > --
> >> > Arvin Meyer, MCP, MVP
> >> > Microsoft Access
> >> > Free Access downloads
> >> > http://www.datastrat.com
> >> > http://www.mvps.org/access
> >> >
> >> > "Nigel Molesworth" <(E-Mail Removed)> wrote in message
> >> > news:(E-Mail Removed)...
> >> > > I've got a data input from on my database. When I have input the data
> >> > > (often a single item) I then:
> >> > >
> >> > > close the form
> >> > > create a report
> >> > > print the report (a label)
> >> > > run an update query
> >> > >
> >> > > The update query (which asks me twice if I'm sure) is to remove a
> >> > > "print me" flag and put the current date in the date field.
> >> > >
> >> > > This would be so much easier if I could do it all from the input
> >> > > form,
> >> > > preferably from a single button, but at this stage I don't know if
> >> > > the
> >> > > underlying table has been updated with the data.
> >> > >
> >> > > Even if I had to close the input form first, is it possible to
> >> > > automate such tasks, as in a macro?
> >> > >
> >> > > --
> >> > > Nigel M
> >> >
> >> >
> >>
> >>
> >>
>
>
>