Search results

thanks guys, that sorted it :)

Ive got a table called tblHistory. It contains a field called MOTDate (this field is in date/time data type format set on long date. Im trying to make a query that will display any table entry that has an MOTDate within the next 30 days. I think i need to put something into the Criteria for the...

thanks m8, sorted it :)

Hi all, Ive got a query that deletes a table entry in tblMachineParts. On the form frmDetailsChangeParts i have a subform called fsubDetailsChangeParts which contains a listbox called List6 which contains the contents of tblMachineParts. This is my query SQL Syntax: DELETE * FROM...

ne 1 help?

yeh, ive created relationships using ClientMachineID, trust me m8, this is needed lol. Its a junction table as well. Right i did what you said, and yeh it worked. However i also forgot to mension i have a 4th table called tblMake in which the machine Make is stored in. tblMake table's structure...

Is it possible to set up a query that can lookup fields from one table to another table? For example, i have 3 tables: tblClientMachine: ClientMachineID (PK) ClientID MachineID tblClient ClientID (PK) Surname Forename etc tblMachine MachineID (PK) Make Model etc I have a combo box which...

Thanks for help ppl, got it workin :) Jim

Hi all, Im trying to get a textbox to be blanked out. In otherwords it displays the value i want, but it is like embedded into the form if you know what i mean. And the user is unable to click into it, but it does display a value. Ive seen this done before, i just dont know how its done. Ive...

thanks m8, i think your right, doing it this way can end up in duplicated entrys if im not careful. Ill try and sort it out. Thanks alot for the help. Jim

Its ok, ive figured it out myself. INSERT INTO tblClientCar ( ClientCarID, ClientID, CarID ) SELECT [ClientID] & "" & [CarID] AS Expr1, tblClientCar.ClientID, tblClientCar.CarID FROM tblClientMachine; Thanks any way m8 Jim

Yeh a composite key would work, but i really need to do it this way because ive been told to. I know there would be confusion etc etc, but is it actually possible to do it my way and concatinate clientID and carID to form the ClientCarID. All im asking is howto do it? Do i use a query? If so...

I know that. But im trying something here and need to know howto do it. U see ClientCarID is the primary key for tblClientCar. And i want to do it this way. Instead of the ClientCarID field been autonumber i want to make it concatinated between ClientID and CarID. It might not be the best way to...

Hi all, Ive got a table called tblClientCar, this is its structure: ClientCarID ClientID CarID I want to use an append query to concatenate ClientID and CarID together and putting the concatenated value into ClientCarID. How would i do this? Ive tried using a form a two combos so when i...

Pat can you post the 2nd combos query SQL syntax?

pmed you m8 with details. Thanks again Jim

Thanks alot m8 :) If i could use my original table structure it would be great, with the use of a query or 2 lol. But if i HAVE to change the table structure in order for it to work then i suppose ill have to. Its just i was told i could do it with my original table structure. See what you can...

thanks for the help m8, however it will not let me specify 2 relationships between tblCar and tblModel. I set up the table structures like you said: tblCar: CarID (PK - AutoNumber) MakeID (Number) ModelID (Number) Mileage (Text) tblMake: MakeID (PK - AutoNumber) MakeName (Text) tblModel...

Please Please guys i really need help with this one, its so important to the development of my system. Thanks guys

Im stuck in a similar situation. I really really need help please. This is my prob: http://www.access-programmers.co.uk/forums/showthread.php?t=78764 Thanks Jim