Search results

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

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

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

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

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

Linking Combo Boxes - Help Hi all, Ive attached a test db to this post so u can all see wot im trying to do here. Ive basiclly got 3 tables with fields: tblCar: Make, Model, Mileage tblMake: MakeID, Make tblModel: MakeID, Model If u look at the relationships ull see how ive set them up...

Hi all, Ive got a form called frmAddMachine, which adds a new machine to a table called tblMachine. tblMachine has the following fields: MachineID, Make, Model, SerialNumber, YearManufacture, RegNumber. I have also got 2 other tables: 1 called tblMake and 1 called tblModel. On frmAddMachine ive...

Hi all, Im new to access and i need some help. This is my situation. I have a listbox (called list0) on a form (called frmDeleteClientContact). The listbox displays a list of clients by Lastname and Firstname from table tblClient. tblClient contains other fields but they are not relevent as all...