There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen blue screen boot computer connection crash css dell drive driver drivers email error ethernet excel explorer firefox firefox 3 freeze hard drive internet internet explorer itunes laptop linux malware monitor network networking outlook outlook 2003 outlook express password printer problem problems ram router security slow software sound trojan usb virus vista windows windows xp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Movie Database


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
08-Jul-2008, 01:10 PM #166
I have added 4 new forms (frmMNumberSearch, frmTitleSearch, frmSearch, and a Switchboard). I am unsure if I want to continue using the tabbed form, or start using the switchboard.

Please review the attached database, and let me know what you all think I should do.
Attached Files
File Type: zip Movie_DB4.zip (88.1 KB, 4 views)
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
08-Jul-2008, 01:18 PM #167
I haven't looked at it yet, but on principle I prefer the Switchboard for "Admin" stuff, ie background data and the Tabbed mainform for all things "Movie".
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
08-Jul-2008, 01:20 PM #168
I was not really sure how to use the new search forms with the tabbed main form. Maybe the search forms were a wasted effort (not really needed).
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
08-Jul-2008, 01:46 PM #169
They are a good exercise, even you don't use them much.
See my latest posts on Mark's thread on how to create a "Multi-Search" form instead of 4 seperate forms.
http://forums.techguy.org/business-a...hed-db-10.html
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
08-Jul-2008, 03:13 PM #170
It appears that you have subform on top of subform. Is that correct?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
08-Jul-2008, 04:11 PM #171
Yep, neat isn't it?
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
08-Jul-2008, 04:13 PM #172
Very neat. The problem is.....will I be able to reproduce it...LOL!
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
09-Jul-2008, 08:20 AM #173
How can I take the frmCheckOut/In form add a combo box that displays the customers, and then CheckOut/In infrmation only for that customer.
Aj_old's Avatar
Computer Specs
Senior Member with 624 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
09-Jul-2008, 08:49 AM #174
Quote:
Originally Posted by gamecockfan View Post
How can I take the frmCheckOut/In form add a combo box that displays the customers, and then CheckOut/In infrmation only for that customer.
Make a new form base on the tblCustomers, put there all 3 field of the table, arange them on newly created form, after that add subform frmCheckOut/In
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
09-Jul-2008, 08:51 AM #175
I am not sure that you can do it with your current Form as it is linked to the MovieID, I think you would have to employ the Multi search Concept and have another (hidden) form on the Tab that is filtered by the customer combo and only made visible when the Combo is clicked. You could develop the Query and Form and then add it to the Tab after you have it working.
__________________
.
.
OBP
I do not give up easily
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
09-Jul-2008, 08:55 AM #176
Okay. I am going to start working on the Multi Search Form.
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
09-Jul-2008, 12:38 PM #177
Should I have a switchboard or just have the tab form open?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
09-Jul-2008, 12:42 PM #178
I would have both, but have the one used most as the one opened on top when the database opens.
computerman29642's Avatar
Computer Specs
Senior Member with 1,427 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
09-Jul-2008, 12:55 PM #179
When a new movie is added, how do I set the default availability to available?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,565 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
09-Jul-2008, 01:17 PM #180
Me.Availability = "Available"
in the After Update event of the Movie title field
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 10:00 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.