Search results for query: *

Thanks for you help ken

Hi Ken Thanks for the information. I have to keep a record of what I get in and also what I distriute an to who. As you state I could keep the rolling stock figure on the fly. But I am not sure how to write the code for this as the ins and outs would be in a table. Can you help further

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...

Please guys I need more help with this?

Thanks for the help. The way you say the criteria should be written is exactly how I've entered it, but this is not working. Do you have any other ideas? Regrads

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...

Hi Sorry for the delay in my reply. In the table I have Jan, Feb, March,Etc. So its the same in the query. I do not want ot compare Date, i.e 00/00/00 with month , i.e. Jan. I want to type in my popup box Jan, feb, march, etc and that what it finds. Regards

Sorry ken I may not be making it clear. When I put [Enter Month] in the criteria box I get a popup box and hit the button for the report. When I put Jan in I get nothing. What I really want are the records that have Jan set against them. Regards

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...

Could be? when you press the query button a box pops up asking for the surname. If I want one persons details I want to put their surname in. If I want everyones details I want to put a star/asterisk in? Regards

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...

Hi Robert Thanks for your help that worked although I would never have thought of it. Regards

Hi Robert Thanks for your questions re my problem I will try to answer them in the same order. 1)Form two is contained within the child control of the main form and I am using a primary key to foreign key between the forms although the second form is indexed with no duplicate allowed as it...