Codding Questions/Problems

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
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.
 
Nice samples...

--
Duane Hookom
MS Access MVP


Roger Carlson said:
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.
Click to expand...
 
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
 
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
 
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.
 
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
 
All that just for the CD's???

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

Thanks

James
 
Thanks for that...

I would like to ask I have had a look at the examples
shown and I am a little confused as to how these could
help as there templates for word and I am not sure how
they can help?

How would you say I should set out my tables and go about
my search button?

If you would like to have a look at it I would not mind as
its just a collection of my DVD's, MP3's CD's etc... Just
so you can get a better feel for the database and then I
will do as you ask for teh improvements on the database?

Many Thanks

James
 
I see this thread is going pretty well, but I get a real chuckle every
time I see the perfectly innocent typo in the subject line: Wouldn't
Codding Questions have to do with applying the theories of Dr. Codd to
database design?
 
Now, if we could just get MVP Boyce to reply... would that be "Boyce
Codding"

James,
There are Access templates for various collections.
 
Back
Top