Modifying subform's underlying SQL statement

  • Thread starter Thread starter DoDev
  • Start date Start date
D

DoDev

I am trying to make modifications to the SQL statement underlying a
subform. I make the changes using Access Query Builder view. However, after
I make the changes and save them my changes just disappear. This happens
regardless of what changes I make, e.g. I tried to add new columns, I tried
to add new "where" criteria. After making the changes I close the builder and
confirm that I do want to save the changes to the SQL statement.
Nevertheless my changes disappear.

Please help. I have been at it for hours and hours.

DoDev
 
Suggestions?

1. Ensure you have the latest service pack
Particularly if you are using Access 2007, there was a bug like this. Grab
the update from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en
or for previous versions go to:
http://support.microsoft.com/sp

2. After you close the query window and return to the Properties box, click
another property. This will help ensure that the property you just set got
updated (even if you don't have the SPs.)

3. If you're still stuck, follow the recovery sequence here:
http://allenbrowne.com/recover.html
 
Allen,
Thank you very much.

Allen Browne said:
Suggestions?

1. Ensure you have the latest service pack
Particularly if you are using Access 2007, there was a bug like this. Grab
the update from:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en
or for previous versions go to:
http://support.microsoft.com/sp

2. After you close the query window and return to the Properties box, click
another property. This will help ensure that the property you just set got
updated (even if you don't have the SPs.)

3. If you're still stuck, follow the recovery sequence here:
http://allenbrowne.com/recover.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
Back
Top