TAbles ANd Data Update

[Crispy]

I have a main data form that will not allow updates when I edit - In any
field -

Anyone have any thoughts how this can be corrected or how to add a data
entry form for all the fields I want which come from a mix of tables through
a query?

Thanks

 

[Gary Miller]

Crispy,

It is probably the query itself that is not updatable if it
has a mix of tables in it. You can test this by opening the
query itself and try to make changes.

Post the tables and key fields along with what you are
trying to achieve and you will probably get some good advise
on how to structure your form.


--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Crispy]

I can make changes in all areas of the query in datasheet format format -
Just not in the view form!

HELP!

 

[Gary Miller]

Check the form data properties and make sure that AllowEdits
is not set to No. You may want to review the other Allow
properties while you are there.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[John Vinson]

I have a main data form that will not allow updates when I edit - In any
field -

Anyone have any thoughts how this can be corrected or how to add a data
entry form for all the fields I want which come from a mix of tables through
a query?

Doublecheck that the Form's "Allow Edits" property is set to True.

 

[Crispy]

Shouldn't that be YES for the "Allow Edits"?

Check the form data properties and make sure that AllowEdits
is not set to No. You may want to review the other Allow
properties while you are there.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Crispy]

I have and it it is!

I am really stuck here...

Any other thoughts?

 

[Crispy]

And how do I post that?




Crispy,

Since there are two active threads on this subject, let's do away with this
one and continue the dialog in the thread with the subject: Tables and Data
Update.

In that thread, would you post the exact SQL code that makes up the Record
Source of your form?

 

[Gary Miller]

Yes, "not set to no" = Yes. Sorry if I was not clear there.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Douglas J. Steele]

If it's a query, go to the query buiilder, open the query in Design mode,
select View | SQL View from the menu bar, and cut and paste the SQL string
you're using.

 

[Crispy]

This is what it gives me -

It makes little or no sense to me- I hope you can sort it out?

SELECT tblArtists.Artist, tblAlbums.AlbumID, tblAlbums.Title,
tblAlbums.Label, tblAlbums.Year, tblAlbums.Genre, tblAlbums.TotalInSet,
tblAlbums.NumberInSet, tblAlbums.NumTracks, tblAlbums.Owned,
tblAlbums.Price, tblAlbums.Quantity, tblAlbums.Owner, tblAlbums.Location,
tblAlbums.Custom, tblAlbums.Compilation, tblAlbums.MediaType,
tblAlbums.Rating, tblArtists.ArtistNotes, tblAlbums.AlbumNotes,
tblAlbums.ImagePath, tblAlbums.TotalPlayTime, tblAlbums.OtherNotes,
tblArtists.WebURL, tblAlbums.Condition, tblAlbums.SubGenre,
tblAlbums.CatalogNumber
FROM tblArtists INNER JOIN tblAlbums ON tblArtists.ArtistID =
tblAlbums.ArtistID
ORDER BY tblArtists.Artist, tblAlbums.AlbumID, tblAlbums.Title;


Regards

 

[Douglas J. Steele]

Try dragging tblAlbums.ArtistID into the grid so that it's included as a
selected field.

If you look at http://support.microsoft.com/?id=328828 (Troubleshooting
Errors That May Occur When You Update Data in Queries and in Forms), there's
a list of conditions under the topic "When the query is based on tables with
a one-to-many relationship, then the types of fields that you may not be
able to modify are as follows:", and the 2nd one is "The "many" side join
field does not appear in the datasheet."

 

[Crispy]

I don't believe it! It works exactly as I want it!!! And all for that little
change..Amazing!

I would never have got that one....

Doug - Are you a genius, or is just natural?

Many, Many thanks indeed....!

Alll I need now is to find out how to navigate from one form to another...!
And back again? - Any ideas?

Really appreciated - Thanks again

 

[Crispy]

I want to go from say the table that lists Artist and Albums and other misc
detail to a table that shows say the track titles for the album being
displayed, and from there back again to the main form to the artist then
displayed on the form I just navigated to.......I can do it through the
switchboard, but would prefer buttons on the forms...Seems I just cannot get
the buttons to work as I want.......Never show the right data or return to
the right place..!


Also, I ahve worked out how to show Album Cover pics without the 'bloat'
assocuated with OLE, van the same be done with sound bytes from sound files
of the albums? - If so - is there a way to do it without the computer
opening up WIndows Media Player?

Cheers

 

[Douglas J. Steele]

Your buttons need to use the DoCmd.OpenForm command.

If you're trying to open the form to a specific album or artist, you can
pass a filter as part of the command. Something like:

DoCmd.OpenForm "MyOtherForm", acNormal, , "AlbumID = " & TheAlbumNumber

The 4th argument (4th because the 3rd argument is being skipped by the , ,)
is any valid Where clause, without the word WHERE in it.

The best way to handle images is to store them outside of the database, and
simply store the path to the image file. Check out
http://www.mvps.org/access/forms/frm0030.htm at "The Access Web" for
details. You might also take a look at the PictureMgr database Arvin Meyer
has at http://www.datastrat.com/DataStrat2.html

Do the same, and store your sound files outside of the database. What format
are your sound bytes in? If they're .WAV or .MIDI, you can use the code from
http://www.mvps.org/access/api/api0011.htm : it doesn't open Windows Media
Player. If you're dealing with MP3s, though, I don't think you have any
options.