Codding Questions/Problems

[James]

Hello I have a quick question...

On a timer event I would like the background colour to
move lighter and darker.... While the scrolling text goes
darker to lighter so it can always be seen...

Also I would like to ask yet another question I would liek
to encorporate a search facility onto a database which has
a setup to the following....

I have a main form where people look at the data so they
select the data type the wish to look through i.e. CD then
it pops up in a box with all the CD information and the
track listings for example... So I have the CD Title in
the top box and then the track listings in a memo field...
in this memo field on the form view it comes up and is set
out so that everything is below one another for example:

Track 1
Track 2
Track 3
etc...

This all appears fine... What I would like to do is have a
search button on each of the subforms to the main form...
Which search the appropriate data... I.E. CD's so I would
like it to look through the tblCD's and see if it can find
a track or a CD Title?

Is this possible? or have I not explained it properly?

Thanks

James

 

[Roger Carlson]

James,

You should ask each question in a separate post. I don't understand what
you are trying to do in the second question. However, in answer to the
first, I have a small sample database on my website (see sig below) called
"Animation" which might give you some help.

 

[Duane Hookom]

Nice samples...

--
Duane Hookom
MS Access MVP

James,

You should ask each question in a separate post. I don't understand what
you are trying to do in the second question. However, in answer to the
first, I have a small sample database on my website (see sig below) called
"Animation" which might give you some help.

 

[James]

Hello I have had a look at that animations thing and yes
it could help me quite alot... I will post again if I get
stuck though...

Right ok picture a layout...

I have a list box with 5 values down the left side...

Then you click on one of them it makes a form visible...

On that form it has two boxes one which is a memo field
which lists tracks on a CD... and a top box which has the
name of the Album.

Now I would like to add a Search button onto this form
which enables me to search for an Album Title or a track
title.

Is there any way of doing this? Or could I get one button
called "Search" search all the tables in the database for
any type of data... I.E. Audio tracks or MP3's? DVD'?
Anything in any table in the database?

Does this help?

Thanks

James

 

[James]

Hi

Right ok picture a layout...

I have a list box with 5 values down the left side...

Then you click on one of them it makes a form visible...

On that form it has two boxes one which is a memo field
which lists tracks on a CD... and a top box which has the
name of the Album.

Now I would like to add a Search button onto this form
which enables me to search for an Album Title or a track
title.

Is there any way of doing this? Or could I get one button
called "Search" search all the tables in the database for
any type of data... I.E. Audio tracks or MP3's? DVD'?
Anything in any table in the database?

Does this help?

Thanks

James

 

[Duane Hookom]

It sounds like you have a very inflexible table structure. Do you have
tables for each type of media? Also keeping names of all tracks in a memo
field is less than ideal. I wouldn't do any more work on this system without
making sure the tables were set up correctly.

Maybe you could provide more information regarding your tables etc. This
would either suggest I am wrong or possibly someone could help.

 

[James]

Ok tables...

Right well I have a diffrent table for each meadia yes...
The memo field if just for the track listings... If you
think it is inappropriate please let me know why and what
I should do...

Well each table consits of diffrent data i.e. CD's, MP3's,
DVD's etc...

Each one would either just give a title for the DVD or
some info on the DVD.. which is a memo field...

All teh track listings in the CD and MP3 ones and listed
in a memo field... How could I change all this so
everything would be good and work the way I wish it to???

Thanks

James

 

[Duane Hookom]

Take a look at
http://www.databaseanswers.com/data_models/cd_collection/index.htm. Tracks
should each create their own record. I would make the CD table more generic
so it could be a CD or DVD or whatever. Add a media type field.

 

[James]

All that just for the CD's???

Would you like to have a look at the table structure would
that help any?

Thanks

James