Search results

Hi, I'm rather new to databases to start off with and am using 2007. I'm creating an American Football Statistics database and I have a table which I then created a form from that table. In that form I input a formula in design view into one of the fields. When I switch back to Form View, the...

Okay. Should I have one central table with the stats in for every player then?

Yep, that's right. Sorry for any confusion!

Hi, I am making a statistics database for my Computing Coursework about a sports team. I have separate tables for different players' stats. I would like to have a form where I can add statistics for the players. Is it possible to have a dropdown box within this form which has a list of all...

Thank you so much, it works perfectly now! :D

Hi, I have a list box, with two columns: The first has the name of a carpet, and the second has the price. I have a textbox which looks up the price of the carpet selected: E.g. [Listbox].[Column](1) However, the textbox shows the value of the carpet, but not the £ sign next to it. The...

Thanks for both of your help! Much appreciated. :D

Hey, I am making a database about carpets. I need the Date of Fitting field validated so it won't allow dates to be entered which are before the dates entered in the Date of Quote field. E.g. if the Date of Quote field was: 01/01/2009, the Date of Fitting field could not be a date before that...

Thanks for your help! I'm sorry if this sounds really dumb, but I'm new to access and databases: What does the 'me.' and 'yardage' mean/represent in the code?

Hi, I am making a database about carpets (don't ask why, lol). I have a dropdown box named 'Plywood Base?'. It has two columns; the first is yes and no, and the second is the price of yes is selected. What I am aiming to achieve is something like this; When yes is selected from the dropdown...

Hi, On my form, I want the user to be able to choose a discount from a dropdown box for example, and for the discount to be taken off of the subtotal; The discounts are 0%, 5%, 10%, 15%, 20%. So if the user selected 5%, then 5% would be taken off of the subtotal. How would I go about doing...

Hi, Is it possible to create a macro in Access 2007, which when run (possibly via a button being clicked) shows a text box? If so, how would I go about creating it? I'm a bit of an access novice, hehe. Thank you very much in advance, Steven.

Thank you so much for your help, it worked. :D I have one problem though. The values show once I put the piece of coding that namliam suggested, but they don't update the table in question. This means that when I try to create a report, these values don't show, as they haven't been added to the...

Thank you both for your help! I'll try out both of them. Namliam, where would I enter that piece of coding? Sorry if I sound a bit dumb. :p Thanks for the welcome as well!

Hi, I'm pretty new to Access and to how it all works, and I have a problem. For my coursework, I have to design a database which includes customers, staff, and product tables. I've done all of that. I am required to produce a form that will act as a job sheet, so hypothetically, if a sales rep...