I am working on a project and I am opening a table then using queries from
then on to sort through my data. I need to initially enter a date or edit a
date on the table and then run the queries but as I have it now it just opens
the table and runs straight through everything without the option to edit..
Can someone help thanks

Michelle,

The general concept with Tables is that their purpose is storage of data.
In production usage, they should never be seen, nor used for entering or
editing data. This is the purpose of Forms. I expect that if you open a
form based on your table, you will be able to then put a command button on
that form which can be used to perform the next steps, after you have made
your required data edits.

--
Steve Schapel, Microsoft Access MVP


"MichelleM" <(E-Mail Removed)> wrote in message
news:A64EEC67-7F7F-4D76-9EB3-(E-Mail Removed)...
> I am working on a project and I am opening a table then using queries from
> then on to sort through my data. I need to initially enter a date or edit
> a
> date on the table and then run the queries but as I have it now it just
> opens
> the table and runs straight through everything without the option to
> edit..
> Can someone help thanks

So I get that i need to make a form but im still not understanding how to
make the macro open the form enter a date and then continue to run the rest
of the macro.. is that possible?

"Steve Schapel" wrote:

> Michelle,
>
> The general concept with Tables is that their purpose is storage of data.
> In production usage, they should never be seen, nor used for entering or
> editing data. This is the purpose of Forms. I expect that if you open a
> form based on your table, you will be able to then put a command button on
> that form which can be used to perform the next steps, after you have made
> your required data edits.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> "MichelleM" <(E-Mail Removed)> wrote in message
> news:A64EEC67-7F7F-4D76-9EB3-(E-Mail Removed)...
> > I am working on a project and I am opening a table then using queries from
> > then on to sort through my data. I need to initially enter a date or edit
> > a
> > date on the table and then run the queries but as I have it now it just
> > opens
> > the table and runs straight through everything without the option to
> > edit..
> > Can someone help thanks
>
>

Michelle,

There are 2 ways to do this.

One is, in the OpenForm macro action, there is a 'Window Mode' argument, and
setting that to 'Dialog' will do what you want.

The other way, which is what I was trying to suggest before, is to take all
the Actions after the OpenForm out of the macro into another macro, and then
run that as a separate event when the user clicks the 'OK' (or whatever)
button on the form.

--
Steve Schapel, Microsoft Access MVP


"MichelleM" <(E-Mail Removed)> wrote in message
news:1CF5285A-553D-4861-948B-(E-Mail Removed)...
> So I get that i need to make a form but im still not understanding how to
> make the macro open the form enter a date and then continue to run the
> rest
> of the macro.. is that possible?
>