Forms :: Create A Form Which Allow Specific Users To Book A Seat At Football Match

Apr 4, 2014

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.

View Replies


ADVERTISEMENT

Forms :: Create A Button To Open A Form To Show Specific Records

Mar 4, 2014

I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see attached .jpg)

This problem started to happen only recently, namely you will see that the left column under [Job Quote Form 10-2205] is blank, where normally there had been a number of fields to choose from. The fields are all still available, they are just not opening when I try to match two fields.

View 2 Replies View Related

How To Create Users In Form

Apr 21, 2005

hey guys,

i just needed a guide on how to create a form with different users in it.

also, is there a way in which i can create a button that will open the wizard to create a report ??

[guess wat, no deadline.... but that doesn't mean dont answer ;) ]

hope a reply soon..

thanks in advance.

View 14 Replies View Related

Forms :: Capture Users That Create And Edit The Records

Aug 27, 2013

What is the best way to capture the users that modify the records in the database?

Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.

View 5 Replies View Related

Forms :: How To Hyperlink From Query To Specific Record In A Specific Form

Jul 23, 2013

I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?

View 3 Replies View Related

Forms :: SQL To Add New Record Form One Table To Match Another

Mar 3, 2014

I have a form that I need to add a new record using embedded SQL rather than just binding the form and using an automatic new record. My form will display the needed random number in a textbox and that needs to be my new record number. So I need first to check to see if that number already exists as a record number then add it if it does not and either way insert or update a set of additional fields. Something like:

DoCmd.RunSQL "SELECT * FROM tblExceptions WHERE ReconciliationID = " & Me.txtReconciliationID
Psuedocode: IF Record Exists UPDATE Field1 and FIELD2
Else Create record and insert VALUES into Field1 and FIELD2
End If

View 4 Replies View Related

How To Create My Own Message If A User Enter A Value Not Match With The Data Type?

Jul 26, 2006

In MS Access form, how can I create my own message if the user enter a value that not match with the data type of a field in underlying table? Thanks a lot!

View 3 Replies View Related

Forms :: How To Create A Form That Can Edit Or Create A Record

May 13, 2014

I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?

View 1 Replies View Related

Seat Booking System For Theatre

Feb 27, 2007

Hi hope someone can help me out here,

I have been asked to research and then produce a simple seat booking system for a movie showing in a small lecture theatre using MS Access. I'm a relative Access newbie and have had little luck in finding information on how to go about producing this system.

If anyone could provide or link me to anything which could be of use that would be great.

Many Thanks,
Ross.

View 5 Replies View Related

Seat Booking Problem, Help Needed.

Apr 15, 2007

I have been trying to develop a system by which a air flight company can book seats on a plane for passengers.
I am having the problem with one of the requirments though, in that I cannot figure out how to display all the seats on a flight, as well as the ones that have already been booked.
This is required so that a form can be created for the user, so that they can give information back to customers on whether there is availble seats of their class type or not.
I have attached the database with this thread, if anyone could be of any assistance, it would be greatly appreciated.
Andi.

View 14 Replies View Related

Form For Comic Book Confusion

Apr 6, 2005

hello, this is frazzling my brain i cannot comprhend the answer :confused:
sorry werent sure were 2 post this hope this is the right place

I have an array of comics 300 they come out weekly, the first is Number: 344 this came out 26th September 1983, i have a form with a combo box were i select the comic number (344 - 700+) in this case i am selecting 344 and i press a button "command 11", i would like it to display in three text fields, date, month and year. This has well an truly killed off my brain. Any help would dearly be appreciated.
Need any further information just ask.
Paul

View 6 Replies View Related

Login And Redirect Users To Specific Directory, File, Or URL

Apr 28, 2005

Hi guys,

I need help in setting up a login page which would redirect users to their specific directory, file, or URL.
I'm able to create the login page without any problem but i'm unsure what exactly i need to do afterwards to get this to work.

can someone, anyone please help


your help would be much appreciated.


please mail me with any information you might have the1@studio9.shacknet.nu


thanks in advance.

View 1 Replies View Related

Forms :: Form Already In Use Or No Permissions When Multiple Users Are Accessing A Form

Aug 11, 2015

I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to

Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO

anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?

View 6 Replies View Related

Forms :: Add Some Instructions For Users Of A Form

Jul 8, 2013

I would like to add some instructions for users of a form. Any easy way to accomplish this?

View 2 Replies View Related

Forms :: Easy Way To Use Microsoft Outlook Address Book To Populate A Drop Down Combo Box?

Aug 6, 2014

Is there a quick and easy (or not so easy) way to use Microsoft Outlook Address Book to populate a drop down combo box? I am creating a form that needs to pull in Business Process Owners, all of which would be in our corporate address book.

View 1 Replies View Related

Interface To Allow Users To Create Ad-hoc Queries

Oct 20, 2005

Hi All

I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer.

I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords.

Dave

View 3 Replies View Related

Forms :: How To Invisible Some Records Of Form For Other Users

Feb 5, 2014

I have a database that it has 2 forms. Form 1 shows list of received letters Form 2 shows list of send letters Now database has been splitted and back end is on the shared drive and front end there is on each computer and myself and other users have read/write access to the shared drive and me and other users can see all the records. .Now I would like to add something like a check box field to the forms. When I tick the check box for each record other users cannot see that record on the form.

View 1 Replies View Related

Forms :: Pop Up Form That Users Need To Fill Up Whenever They Need To Add New Records

Aug 13, 2014

i have a pop up form that users need to fill up whenever they need to Add New Records. everything is working fine. BUT, what should i do that in the next time the user will click the Add New Records it will not show the previous items that have been added? since it is added in the Main Form already, no need to show in the pop up Form again once they wanted to add new records. Once they are still in the pop up form, they can see the newly added items BUT once they exit the pop up form, they cant see those items anymore in that form instead it is in the Main Form already.

View 3 Replies View Related

Tables :: Create Log For Table To Capture Changes By Users

Mar 2, 2015

Is there a way of creating a log to capture changes in a table by users?

In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.

So, if I would be able to have a log that records all the actions taken by users, I could at least see who did what.

View 13 Replies View Related

How To Create Users And Permission In MS Access 2010

Apr 29, 2013

how to add security features into My Access database. i.e create users with permissions/login.

View 1 Replies View Related

Forms :: Form Gets Error Message With Multiple Users

May 1, 2013

I have created a profiling form for my school. Each boy can access his form using his admission number ( Adno) which is the primary key. On the form are lots of sub forms - for things like favourite authors, clubs, teams played in etc - but these don't have a primary key ( as they are automatically linked to the Adno via the main form ). Unfortunately when several boys are filling in their own forms at the same time I keep getting error messages, one says that the data can't be updated and another says that there is a primary key problem.

View 8 Replies View Related

Forms :: Access 2010 - Form Shows Similar Match In 1 Table - Alter Another Table?

Dec 16, 2014

I have two tables (Access 2010). One with a list of names (List1) and another with a very similar list of names (List2), but they differ in very small ways. For example, List1 might have John Smith, and List2 would have Smith, John L.; and Smith, John. List2 also has a unique ID associated with these names that I need to append to List1.

I need to design a form that will allow me to look up names in List1, and have it return all names that are similar in List2. I then need to be able to choose with record in List2 matches with the List1 entry (based on a few other columns in List2, such as birth date) and have the form add that unique ID to the List1 record.

PS: I am using Access 2010

View 1 Replies View Related

Forms :: Recordset Filters From One User Affecting All Users On A Form?

Jul 10, 2013

Here is the environment:

Currently, I have 10 Users running a front end form that connect to back end data where they add to current records and eventually check that the record is complete.

I also have an "Apply Filter" button on the right hand side of the form that allows the user to apply filters to the records to show specific data that is not complete.

I am currently hearing that while the user is working, whether they apply filter or not, it seems as though all of a sudden, all of their completed work dissapears from their recordset hence not allowing them to go back to make changes to it if needed. I can only conclude that when a different user clicks apply filter, all users are affect some how... here are some examples of the code for the filter:

Code:
Select Case [cboFilterValues] ' Where the user selects a filter parameter from a dropdown
Case "All Data"
strSQL = "SELECT * " & _
"FROM [Data Table] " & _
"WHERE [Complete] = No

Then it does:

Code:
Me.RecordSource = strSQL

I am basically trying to find a way where only the user wanting to view the filter is affected... FYI, the other users arent actually seeing all the filters from the other user filter choice, they simply loose all their completed work from their form.

View 1 Replies View Related

Help With Football Database

Jan 18, 2007

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

View 7 Replies View Related

Please Help Beginner With Football D/b Design

Nov 30, 2005

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?

View 3 Replies View Related

Forms :: Open New Form With A Specific ID (or Name) Filled In

Feb 4, 2014

(MACROS ONLY)I am looking for a way to open a form in order to add a new record. The idea is that I open up the form with a MemberID and possibly the name already filled in on the relevant form. It is merely for ease of use regarding the user.

I have got as far as opening the the new entry form. I just need to pass the MemberID into the relevant field. If I use the wizard it is just finding a record of a pre-filled entry.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved