Search results for query: *

I have set up a table for a small stock contol. In the table I have the following: Initial stock - New stock In - Stock distributed - Rolling Stock. I want the rolling stock to recalculate itself everytime new books are ordered or others are distributed. I can get it to do this by using the...

I want to have a date box on my form where you click a button and a calander pops up. You can then click on the date and it populates the box. I know I have seen this on the site before but cannot find it. I think someone said you have to get a programme and then use through active x. Can...

I have had help on this before but I am still having problems. I have a table of car information included are the following colums. Registration No Taxation Class Taxation Date The taxation date is a dropdown box and includes dates as follows, Jan, Feb. Mar, Apr, Etc. I want to make...

I have had help on this before but I am still having problems. I have a table of car information included are the following colums. Registration No Taxation Class Taxation Date The taxation date is a dropdown box and includes dates as follows, Jan, Feb. Mar, Apr, Etc. I want to make...

I have made a form to preview car accident information only. On it I have attached a button that when pressed allows a popup form to input new accident information. When it pops up I would like this form to already have the ID Number of the vehicle in the preview screen on it. Can anyone tell...

I have a table with months in, i.e. Jan, Feb, Mar and so on. I have made a Query for a report and I want to enter criteria to enter the month for choosing the records I want to see. I know how to do this with dates but not in this case. Can anyone help. Cheers

I have appended some employee information to a history table. I have now made a report from a query for this table. I get the information on the report alright. However, when I go back to the query and insert the criteria "Surname" and then run the report I am not getting the...

I know this is easy but I am having a blank, its one of those days. I have set up a query and in the criteria I have put Surname. This enables me to just pull the information on one person. However, I also want ot be able to list all people. I know I can enter a star somewhere but I cannot get...

Hi I have had some help on this but am getting nowhere! I have two tables one Information about HGV vehicles the other about accidents that vehicle has had. I have made two more table, i.e. HGV_History and HGV_Accident_History. I have made two append queries to move data about any vehicles...

I have a database in which I have four linked tables by vehicle ID. E.G The first table has basic vehicle data when input the database gives each vehicle an ID number which I use as a primary key. Other data related to the vehicle such as accident information on loan details and such like are...

I have in my database a car table, linked to this by ID is an accident table and a defect Table. I have made another table in which I place records for vehicles not current by an append query, i,e, car table history. If I make history tables for the Defects and Accidents can I make the one...

I have created a form with 2 subforms made from forms from three tables. The first table has a primary key and the others do not . From the main table I have a name combobox linked by ID to the first subform. this looks up the second table and enters data that never changes for viewing. The...

I have put a query together to make a form from two tables. One table is Names and ID Numbers the others is a list of journey numbers and destinations. I want the lookup the names and have the other information put in automatically. How do I make the name box a look up in the query? Every...

I have put a query together to make a form from two tables. One table is Names and ID Numbers the others is a list of journey numbers and destinations. I want the lookup the names and have the other information put in automatically. How do I make the name box a look up in the query? Every...