Command Button Won't Listen, Need to view Table....

[Fletcher]

Hi, I have a command button that I'm trying to use to view the table
that the form is linked to and I keep getting an error that says it
needs a table name. I have given it a table name, but it won't listen
to me. It continue to do nothing.

The command line is as follows:

DoCmd.OpenTable FSI_Particle_Data, acViewPreview, acReadOnly

That's all I want it to do, but it won't listen to me.

If you have any advice, I'm willing to hear it.

Thanks in advance.

 

[strive4peace]

Hi Fletcher,

If FSI_Particle_Data is the table name and not a variable, put quote
marks around it

DoCmd.OpenTable "FSI_Particle_Data", acViewPreview, acReadOnly

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Fletcher]

That works great, but now I'm running into a new problem. I can't get
the table to show above the form. The forms settings have it set to
pop up and maximize, so I don't know if it would be possible to get a
table to be seen on top of it. If you have any ideas, I would
appreciate them very much.

Thanks for the help.

Fletcher

 

[strive4peace]

Hi Fletcher,

if your form is maximized anyway, try this:

Popup --> No
Modal --> No

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Fletcher]

Having the pop-up enabled allows for the form to completely cover up
the bars at the top of the screen and this is what we would like to
have. Do you know of any way to have the table come over top of the
form? If not, it's not a very big deal.

Thanks for your help

 

[strive4peace]

Hi Fletcher,

if your form is a popup, it will be on top...

what you CAN do is make another popup form with your table, and if you
open another popup form, IT will be on top...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Fletcher]

How do you make a pop-up table?

Fletcher...

Hi Fletcher,

if your form is a popup, it will be on top...

what you CAN do is make another popup form with your table, and if you
open another popup form, IT will be on top...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

I don't think you can do that...you need to use a form to show the table
to make it a popup

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Fletcher]

So have a command button that goes into table view? How would that
work?

Fletcher...

 

[Larry Linson]

So have a command button that goes into table view? How would that
work?

Just the reverse, I think, of what Crystal said. She said you have little
control over _datasheet_ view of a Table, so you need to create a Form to
view it (either continuous forms view with multiple records, or single form
view to show a single record at a time). The Command Button can open the
Form, and, if you wish to limit the number of records you are dealing with,
modify the Filter or WhereCondition properties of the DoCmd.OpenForm.

Larry Linson
Microsoft Access MVP

 

[strive4peace]

Hi Larry,

I think we are saying the same thing... Fletcher needs to use a form if
he wants to be able to set a popup property

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*