Recent content by rdev

Hi Paul Tell me where i am wrong , I have twigged the code for it to run from the query qractivity SELECT qractivity.Ship_Name, Sum(qractivity.cost_of_charge_put) AS TotalAmt FROM qractivity WHERE (((qractivity.activity_type)="Garbage")) GROUP BY qractivity.Ship_Name; The above is giving me...

Thanks Paul But how to set it in the access where do i copy these Am absolutely a virgin acccess user

I have a query with the following fields extracted from two tables:- ID Activity_type( can be Garbage removal, Tug, Towing, Ship_Chandling) App_num ( approval number for each job done) Ship_Name (name of ship) Cost_of_charge_put (charge for each activity_type) The Ship_Name and App_num(...

I have the folloawing tables:- tblshipmaster with fields( IMO_Num,Ship_Name) tblvoy with fields (Voy_num,IMO_Num) tblquotation with fields(Quotation_Num,Voy_Num) tblapprovequote with fields (App_Num,Quotation_Num) I have relationships set between the tables When I put a query , which I'll...

I have a table called tblapprovedquote with fields App_Num and Quotation_num I have another table tblquotation with fields Quotation_num and Voy_Num Both tables are related in a in a one-to-one relationship . I have a query which pulls fields App_Num , Quotation_num from the tblapprovedquote and...

Sorry to appear stupid How do i activate the combo box menu , i click andf drag it in the form in design view

Thanks am new and at my very first project , how do i do the combo box on the form

Please see attached file I have tblShipmaster I have tblshipvoy In the table tblshipvoy , the primary key field is Voy_Num. The IMO_Num field is same as the one in tblShipmaster, so that I can create one to many relationship , different voyage number can have same IMO_Num as a ship can come...

Thanks for the code , but how do I integrate it in the database, I really new and do not know how to handle macros currently

Thanks But when I open the form , I can edit the previously entered data, so a user can change my previously entered data. how can I stop this

I have a table named tblShipmaster with fields IMO_Num(Primarykey),Ship_Name,Vessel_type. The Vessel_type field picks up value from a lookup field of a table called tblshipcategory I have a related form to enter data in the tblShipmaster, the form is known as frmshipmaster. After a few records...

I have a table named tblShipmaster with fields IMO_Num(Primarykey),Ship_Name,Vessel_type. The Vessel_type field picks up value from a lookup field of a table called tblshipcategory I have a related form to enter data in the tblShipmaster, the form is known as frmshipmaster. After a few records...

Thanks for the valauble input , I have yet to acquaint myself with queries , a hint would help Cheers!

Hi I have a table named tblShipmaster with the following fields:_ IMO_Num ( which is the primary key) Ship_Name Vessel_Type Reg_Coun Call_sign I have another table named tblshipvoy with the following fields:- voy_num( the primary key field) IMO_Num Ship_Name Exp_arv_date Exp_dep_date What I...

Hi I am new to access and have little experience working with it . Yes reading through text books and other tutorials are the very steps to acquaint to it , but as a self-starter help from forums of this sort is a real companion to experience the power of Access .More important when you are...