Hi, first of all sorry if I posted this in the wrong section, but I think I'm ok!
Secondly, I don't have much knowledge in access, so anything may help me ;)
I want to create a football spreadsheet something like this one:
http://www.databasedev.co.uk/user_interface_3.html
It doesnt need to be too similar, but it needs to have somewhere for the user to put in results of matches - like on the form on that one.
All I have so far is two tables - one for team names and one for player names.
Do I need to make a form as a place where results can be put into the database?
Also, I need to create a league table, based on the results. 3 points for a win, 1 for a draw (real football rules) but I don't know how to make the table. Would it be a table, a query, a report? I'm clueless on that part really ;) So any help would be good.
Any help on the relationships I need would also be great
I am trying to build a database for a local football team, and am having trouble with the design of the tables. The database contains numerous tables but my main problem is that within the database there are 4 types of people information:
Players:
(a player can have more than 1 guardian attached, eg mother, father, uncle, etc A player could also be a member of staff eg coach) Guradians of the players (a guardian can be attached to more than 1 player, eg two sons playing for the same club a guardian could be a member of staff, eg manager). Staff Members (A staff member can also be a guardian) Doctors (a doctor could be a staff member and also a guardian).
What is the best way to approach the design of these tables as i dont want to have to enter the same name, address details etc, more than once for if a person is in more then one of the people information categories.
The main focus of the database is driven by the player Information.
I want to show what guardians are responsible for each player, who the players doctor is, etc.
For a couple of years now I have been keeping a spreadsheet record of UK football match results and statistics - I use this as the basis for gambling on future matches. I now want to migrate this information into a database so that
1) It is much easier to enter the new data(via picklists) 2) I can generate reports on particular teams to help me on future betting decisions
Being almost completely new to Access I am struggling with the design. The information I'm capturing is: Match Date Competition(table including five) Home team/away team(table including many depending on competition) Home formation/away formation(table with standard list) Home goals/away goals(numerical) Home corners/away corners(numerical) Home bookings/away bookings(Numerical) Referee(from a standard list) All the above is in a match results records table with relationships to each data element table.
For the form for data entry, I want pick lists for all non-numerical values - eg team, formation etc. I would like to get a little cleverer and for the team pick list to only contain teams that are in the competition I've selected(eg Uk or European).
I've created some tables and relationships, but when I create a simple form with combo-list boxes, the list itself comes up blank even though I've linked the field to a particular table of options(eg a competitions table).
Can anyone help on suggestions for the overall design(should I have separate match results tables and team tables for each competition?) and with this particular combo-box problem please?
I am trying to create an Access system for a 5 a-side football company. They have both League Fixtures and private bookings. The aim of the system is to allow for input of new teams, referees and fixtures and also for private bookings.
Im really struggling with this one. I have had a go at designing it in Access but the forms wont work.
I wanted the system to have the following fields:
TBL_Booking Booking ID Pitch Number Date Time Fixture ID Customer ID (Only one of the last two fields will be filled in one being for a league fixture and one for a private booking)
TBL_Fixture Fixture ID Referee ID Team1 ID Team2 ID
TBL_Customer Customer ID Customer Name Contact Number
I have a lot of help on some reports but I keep running into a problem when dealing with ranges. A football field is 100 yards long. It is broken into field zones by yard lines. For example, -1 to -10, -11 to -25, -26 to -49, 50 to 26, 25 to 11, 10 to 1. I am trying to find some percentages for those field zones.
I know you can create an IIf statement that could give it another value, but how can I create a query asking for all plays or values when the field position lies within a certain range (ie. from the -1 to -10)?
If anyone has any ideas, I would appreciate it. I am a novice Access user and we are trying to use Access for our recruiting database and our Scouting database.
Firstly I'd just like to say HHHHHHEEEEEEEEELLLLPPPPPPPPPPP!!!!!!!!!!!! LOL
I'm creating a fantasy football database for a skool project but have hit somewhat of a stumbbling block with the way to display the team. After discussion with my teacher we decided combo boxes was the best solution (im open to other suggestions) However we cant come up with method to cascade the combo boxes :confused:. I need to cascade the four defenders boxes together, the four midfielders together and lastly the two attackers.
Ive tried to do this using an update query but the problem with that is its updating all the records rather than jus the one I dont no what else i can do and im really hoping one if u's cazn help. Im also tryin to make the user not be able to select more than 2 players from the one team if anyone knows how t create some sort of validation rule for that
I'm currently trying to create a form which allows the specific users to book a seat at a football match.
I've created all the relevant tables, but I'm struggling on how to interpret the data into them to make the form work. I am new to this sort of design, this design is currently for my university dissertation and I am struggling to get it completed in time.
I have attached my document below to show how far i have come.
is it possible to create a league table on those results.
1. There is more than one competition in the table so it would have to be by compID 2. There is fixtures without results so they would have to be excluded as well.
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application Call AcApl.OpenCurrentDatabase(strfolder, True) Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.
I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.
Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.
I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.
Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
Is it possible to access a table in one Database (Database A) from a separate Database (Database B) and if so how. I should clarify that this is an Access Database.
I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.
the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.
Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?
I was thinking to create a VB code for the database to delete all data on the tables when the database is open. and before closing the database exporting all the data to a txt file or something.
Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.
This way we can have several txt file for several project and use always the same exe database.
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
I have a car dealership database and have a servicing section.
I want to create a form to service these vehicles.
The only vehicles which will be displayed on the from are the sold ones (because you cannot service a vehcile which hasnt been sold) which i have a query for.
I also want the form to display the customer who owns the car the service details (eg what they need), the parts availiable and the parts required for the service.
The calculations i need to make in this form are as follows
quantity needed (parts required table) - quantity in stock (purchasing customer parts table)
i havent been able to figure out how to get my subform to work properly.... i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 )
it is really important that i figure this out so that i can keep my job..
how else can i obtain help? even if i have to pay for it?
I was playing with passwords for one of my access db.
I tried opening the db with the password, but it won't work. So, I thought I forgot the password. I checked some posts on this forum that helped in retrieving the password and it's the same that I have been trying. I am not sure if the Name is correct, is there a way to retrieve the log on name?
I also noticed that when I try opening any other db on my system, it asks me to log on, I though I was only applying a password to one file.
I have been tasked with setting up a database for all employees the info contained is along the following lines:
Employee Number: Name: Qualification Status: Qualification Run Out Date:
To name but a few of the parameters
I have currently set up the start up screen, main switch board and the complete employee records table with form (for simple viewing/input).
My problem is this we have four departments that require access to the database
Admin - Require access to all employee records (View) 1 Dept - Require access to their employees (View and update records) 2 Dept - Require access to their employees (View and update records) 3 Dept - Require access to their employees (View and update records)
Currently i have created one complete employee record table (Admin) how do i break this down for each department so that when the info within each one is updated it in turn updates the main Admin table?
I started by copying and renaming the Admin table for each department but this never updated.
Any help and info would be appreciated.
On a slightly less important note for the time being at least can i password protect each command button on the main switchboard?
