Search results

Yes it is, OK some basics, lets say your table has 3 columns, ProjectID, taskID and complete. Ok, so one project may have many tasks soem of which are complete and there may be may be many projects. In order to work out the percentage of tasks complete first you need a query that will...

Well the first table is OK, but the second needs more fields. In the second table have Staff ID (the same as the first table) Position (Managers, Team leaders etc.) and in a third table have Position (Manager etc) Training (courses that they can participate in) Start Dates (start dates)...

Is there a barcode on the physical film? (we are talking DVD here?) You can save yourself a lot of time with one using a simple hand held barcode scanner.

Could he print two invoices of, one to be sent out and keep 1 paper copy in a folder and retain all slips of rental paper to get him round the legal stuff?

This would be the best option, but lets give it a try. The easiest way to run a report would be to base it on a select query. Then use the report wizard and select the query you created to design the report. But before we start playing around with that here are a couple of things to think...

Thanks, will give it a go!

Hi, I have a table (Tbl_All) which amoungst other columns has the feilds "OrderNumber" and "Pages" (pages contains the number of copies of that report I wish to print. So OrderNumber has a value of "A". Pages has a value of "5" I have created a report with a page break at...

It may be a waste of time, but, nothing like jumping in at the deep end :D and the best way to learn. I suggest heading over to the Microsoft website and searching for Access templates, these are a good start and you can pinch ideas and code from them or use them as they are. They do one...

if you mean on your form then Create a text box on the form. In the properties of the text box under "defaultValue" type =[Booking Time] & [Booking Date] & [Facility ID ] this will fill the text box with those values concatonated. If you mean in the table just open the table in design...

Ok In that case we use the BeforeUpdate Event. This is used to validate data on the form before its entered into the table. You may need to add a cloumn to your existing table that is a concatonation of the Booking Time, Booking Date, Facility ID. Then on your form a hidden text box that...

Is there not a booking duration, or is it booked at a standard one hour block?

Ok on the form is it a text box that they fill in i.e 1st text box is room number 2nd text box is start time 3rd text box finish time etc? If it is we can use the "On Update" event to test to see if the values in the text boxes are already in the table.

Quite an undertaking. How good are you with Access, how are you storing the value that needs to be invoiced? And at which point may you need to change the default value from £25?

the function Weekday should do it,, http://www.techonthenet.com/access/functions/date/weekday.php

Without making it complicated then you will need 2 queries. 1. Create query based on LEAGUETABLE. Include fields HOMETEAM,HOMESCORE and AWAYSCORE. In the "Criteria" section of the field HOMESCORE type >[AWAYSCORE] This will give you all results where homescore is greater than awayscore save...

How are they booking it now. Is it through a form? And how do you record the booking?

Hi Burnsie, Yes the query will pick up the new data in the tables. As for the date range query have a look at this http://office.microsoft.com/training/training.aspx?AssetID=RP010970001033&CTT=6&Origin=RP010969981033 And another note when creating reports I find it easier to make a...

Hi Aiden, After looking into this some more it appears that unless you want to go the whole hog http://office.microsoft.com/en-us/templates/TC010184581033.aspx and have an all singing inventory management database then excel does seem to be the format to do what you want to do. I have...

Hi Aidan , Ill see if I can knock one up for you. It may take a coupl eof hours though as im at work.

Hi Aiden, Ive looked at your DB and have a few suggestions. Are you using transaction types; I.E, SA=Sale, PO=receipt, DA=Damaged Stock etc? You seem to be holding the product qty in the product table. Really this should only be used for product details. You need a seperate table for...