Open Form

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

I have got an issue with an mda/mde form.
Everything works fine on my pc, but when I install the mde(have tried the
mda also) on another pc I get the problem of ,
I have got a few forms that open another form to show the detail of the main
record. When I open any of the forms that open from another form ,I get a
blank record.

Before I was using
DoCmd.OpenForm "cview", , , "[po] = [Forms]![po1].[ppo1]![po]"
to open the second form

This morning I went back and changed it to
Docmd.OpenForm "cview"
Forms.cpurchase.Filter = "[po] = [Forms]![po1].[ppo1]![po]"
Forms.cpurchase.FilterOn = True
to open the second form

A little while ago, I changed to a query for the forms filter and used
criteria from the main form to set the query by. I used
Docmd.openform "cview"
forms!cview.recordsoucre = "myquery"
to open the second form

None of these will work on other pc's, but I have no problem on mine.
It is all of the forms that use a second popup to show any information

Can someone point me in the right direction?
 
If the commands you showed work on your PC and the other PCs are running the
same version of Access, I don't see why they wouldn't be working the same.

I would check:
1. Does the form, cview, open properly filtered if you copy and paste the
filter into the filter property? (Is the form on your PC saved with a filter?
Maybe the form appears to be opening properly because it is saved with the
filter you want it to have. If the syntax of the filter you pass to a form is
not correct, it may ignore it and use the filter with which it was saved.)
2. Check the double quotes and exclamation points on your filter. See if the
syntax works when you enter them directly into the filter property of cview.
I don't remember off hand, but maybe you can try the
"forms('FromName').Controlname..." format in the filter property.
3. Perhaps there is actually a runtime error that is keeping the form from
filtering that is not related to the filter.
4. If none of this works, you can try passing the value for the control to
cview, e.g. Forms.cpurchase.Filter = "[po] = " & [po].Value

Marvin
 
I checked the filters of the forms, and they are clear, and when I changed
to a query this morning, I set the allow filters property to "no"

I opened the query a few minutes ago and I think I might have found my
problem
I looked in the table and wrote down one of the records criterias that I am
looking for, then I opened the query and typed it in.
Guess What?
no record(funny because it goes to the record on my pc)
I found by removing the date from the query, it would populate the query.
What would be wrong with a query/table when you have a field named
date(which is a date the record was entered) and it shows the date to be
correct in the table, but when you enter the date(manually or copy and paste
from the table) into the query, it will not populate the query?

Marvin said:
If the commands you showed work on your PC and the other PCs are running
the
same version of Access, I don't see why they wouldn't be working the same.

I would check:
1. Does the form, cview, open properly filtered if you copy and paste the
filter into the filter property? (Is the form on your PC saved with a
filter?
Maybe the form appears to be opening properly because it is saved with the
filter you want it to have. If the syntax of the filter you pass to a form
is
not correct, it may ignore it and use the filter with which it was saved.)
2. Check the double quotes and exclamation points on your filter. See if
the
syntax works when you enter them directly into the filter property of
cview.
I don't remember off hand, but maybe you can try the
"forms('FromName').Controlname..." format in the filter property.
3. Perhaps there is actually a runtime error that is keeping the form from
filtering that is not related to the filter.
4. If none of this works, you can try passing the value for the control to
cview, e.g. Forms.cpurchase.Filter = "[po] = " & [po].Value

Marvin

David W said:
I have got an issue with an mda/mde form.
Everything works fine on my pc, but when I install the mde(have tried the
mda also) on another pc I get the problem of ,
I have got a few forms that open another form to show the detail of the
main
record. When I open any of the forms that open from another form ,I get a
blank record.

Before I was using
DoCmd.OpenForm "cview", , , "[po] = [Forms]![po1].[ppo1]![po]"
to open the second form

This morning I went back and changed it to
Docmd.OpenForm "cview"
Forms.cpurchase.Filter = "[po] = [Forms]![po1].[ppo1]![po]"
Forms.cpurchase.FilterOn = True
to open the second form

A little while ago, I changed to a query for the forms filter and used
criteria from the main form to set the query by. I used
Docmd.openform "cview"
forms!cview.recordsoucre = "myquery"
to open the second form

None of these will work on other pc's, but I have no problem on mine.
It is all of the forms that use a second popup to show any information

Can someone point me in the right direction?
Click to expand...
Click to expand...
 
I'm not sure if I follow you, but if you are trying to edit data from a
query, you may have to set the "Recordset Type" property to "Dynaset
(Inconsistent Updates)" if you are pulling from more than one table.

David W said:
I checked the filters of the forms, and they are clear, and when I changed
to a query this morning, I set the allow filters property to "no"

I opened the query a few minutes ago and I think I might have found my
problem
I looked in the table and wrote down one of the records criterias that I am
looking for, then I opened the query and typed it in.
Guess What?
no record(funny because it goes to the record on my pc)
I found by removing the date from the query, it would populate the query.
What would be wrong with a query/table when you have a field named
date(which is a date the record was entered) and it shows the date to be
correct in the table, but when you enter the date(manually or copy and paste
from the table) into the query, it will not populate the query?

Marvin said:
If the commands you showed work on your PC and the other PCs are running
the
same version of Access, I don't see why they wouldn't be working the same.

I would check:
1. Does the form, cview, open properly filtered if you copy and paste the
filter into the filter property? (Is the form on your PC saved with a
filter?
Maybe the form appears to be opening properly because it is saved with the
filter you want it to have. If the syntax of the filter you pass to a form
is
not correct, it may ignore it and use the filter with which it was saved.)
2. Check the double quotes and exclamation points on your filter. See if
the
syntax works when you enter them directly into the filter property of
cview.
I don't remember off hand, but maybe you can try the
"forms('FromName').Controlname..." format in the filter property.
3. Perhaps there is actually a runtime error that is keeping the form from
filtering that is not related to the filter.
4. If none of this works, you can try passing the value for the control to
cview, e.g. Forms.cpurchase.Filter = "[po] = " & [po].Value

Marvin

David W said:
I have got an issue with an mda/mde form.
Everything works fine on my pc, but when I install the mde(have tried the
mda also) on another pc I get the problem of ,
I have got a few forms that open another form to show the detail of the
main
record. When I open any of the forms that open from another form ,I get a
blank record.

Before I was using
DoCmd.OpenForm "cview", , , "[po] = [Forms]![po1].[ppo1]![po]"
to open the second form

This morning I went back and changed it to
Docmd.OpenForm "cview"
Forms.cpurchase.Filter = "[po] = [Forms]![po1].[ppo1]![po]"
Forms.cpurchase.FilterOn = True
to open the second form

A little while ago, I changed to a query for the forms filter and used
criteria from the main form to set the query by. I used
Docmd.openform "cview"
forms!cview.recordsoucre = "myquery"
to open the second form

None of these will work on other pc's, but I have no problem on mine.
It is all of the forms that use a second popup to show any information

Can someone point me in the right direction?
Click to expand...
Click to expand...
Click to expand...
 
Do not use Date as the name of a table's or query's field. It and many other
words are reserved words in ACCESS, and can create serious confusion for
ACCESS and Jet. See these Knowledge Base articles for more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763


--

Ken Snell
<MS ACCESS MVP>

David W said:
I checked the filters of the forms, and they are clear, and when I changed
to a query this morning, I set the allow filters property to "no"

I opened the query a few minutes ago and I think I might have found my
problem
I looked in the table and wrote down one of the records criterias that I
am looking for, then I opened the query and typed it in.
Guess What?
no record(funny because it goes to the record on my pc)
I found by removing the date from the query, it would populate the query.
What would be wrong with a query/table when you have a field named
date(which is a date the record was entered) and it shows the date to be
correct in the table, but when you enter the date(manually or copy and
paste from the table) into the query, it will not populate the query?

Marvin said:
If the commands you showed work on your PC and the other PCs are running
the
same version of Access, I don't see why they wouldn't be working the
same.

I would check:
1. Does the form, cview, open properly filtered if you copy and paste the
filter into the filter property? (Is the form on your PC saved with a
filter?
Maybe the form appears to be opening properly because it is saved with
the
filter you want it to have. If the syntax of the filter you pass to a
form is
not correct, it may ignore it and use the filter with which it was
saved.)
2. Check the double quotes and exclamation points on your filter. See if
the
syntax works when you enter them directly into the filter property of
cview.
I don't remember off hand, but maybe you can try the
"forms('FromName').Controlname..." format in the filter property.
3. Perhaps there is actually a runtime error that is keeping the form
from
filtering that is not related to the filter.
4. If none of this works, you can try passing the value for the control
to
cview, e.g. Forms.cpurchase.Filter = "[po] = " & [po].Value

Marvin

David W said:
I have got an issue with an mda/mde form.
Everything works fine on my pc, but when I install the mde(have tried
the
mda also) on another pc I get the problem of ,
I have got a few forms that open another form to show the detail of the
main
record. When I open any of the forms that open from another form ,I get
a
blank record.

Before I was using
DoCmd.OpenForm "cview", , , "[po] = [Forms]![po1].[ppo1]![po]"
to open the second form

This morning I went back and changed it to
Docmd.OpenForm "cview"
Forms.cpurchase.Filter = "[po] = [Forms]![po1].[ppo1]![po]"
Forms.cpurchase.FilterOn = True
to open the second form

A little while ago, I changed to a query for the forms filter and used
criteria from the main form to set the query by. I used
Docmd.openform "cview"
forms!cview.recordsoucre = "myquery"
to open the second form

None of these will work on other pc's, but I have no problem on mine.
It is all of the forms that use a second popup to show any information

Can someone point me in the right direction?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top