Search results

As discussed above Trns_ID field here it is dbo_trns!id My Real life Scenario : MsSQL (Back End ) and Front End is (Ms Access) below mention is a Trns Form ( Delivery Order Challan). Main Form ( Invoice_Mast ), Invoice_Mast!Challan_No (Primary Key) Sub-form ( dbo_Trns) dbo_Trns!id is...

Trns_Id is a Key Field (Foreign Key ) , After I changed it to Foreign Key . and Trying to enter data in Transaction Form, VBA program is giving an Error at rs.movefirst Arnelgp, Kindly suggest.

Arnelgp you are Generous, I appreciate that you understanding the problems and writing a perfect Code. Reference you attached Ms Access File : I have one small query if use Multiple time select and drop item in combo box for eg "SPML" the Trns_ID got Increment every time. Pls stop it for...

I have created a Report in Ms Access File ( MDB) as attached, Wherein report is in Row wise format , but I want it in Column Format i.e in Label format In Three Columns (Sector -1 , Sector -2 ,Sector -3 ) in Small it is mentioned as SEC-1 similarly for all sectors. Two Class are there ( Crew...

Trans_ID is increment field as per record added (VBA Code is written for increment) It is Primiary Key ( Can't Reset) Kindly suggest for Bulk Record insert using Function getNextItemNum()

Trns_ID field is in Trans Table as Primary Key. It is an ACCB File Linked with Ms SQL. For easy Work i uploaded mdb file. Trns_ID got Increment using getNextItemNum() . I have not used sequence or Auto Increment for Increment value, just used the function. When entering single record...

Dear Arnelgp, In below mentioned VBA Code : CurrentDb.Execute "insert into tblTrans ( FlightID, ItmID ) " & _ "select " & Me.Parent!FlightID & ", ID FROM tblItems WHERE [Category] = '" & strCategory & "'" On bulk Insert records, How to use getNextItemNum()...

I am using my Ms Access 2003 database file is two different Ms Office Version's. I am using Excel file in it But Whenever I update the database and keep it is different locations, On Opening it is gives us an error "Your My.mdb database or project contains a missing or broken reference to...

Thanks you so much Arnelgp !!, It is working fine

Sir, Requesting you to attach it once again, Please. I am using Ms Office 2007 version

Sir, Requesting you to attach it once again, Please

Arnelgp, Thank for your efforts , but the file attached file is showing an Error "unrecognized database format", Kindly re-attach the same again.

No Sir, Flight Sector May vary ( Example : Single Sector Flights: DEL-FRA ( : double Sector Flights: DEL-FRA Flights: FRA-DEL ( : Multiple Sector Flights: DEL-FRA Flights: FRA-MUC...

Thanks a lot Sir for the attached File. It solved my issues, but as stated above I have Many Queries, Requesting you to please solve my the below mentioned query :- Table : tblFlight_Detail is added. tblFlight is linked with tblFlight_Detail (One to Many Relationship) ( Access File...

Thanks Sir, I am attaching the Access File in Zip Format, Requesting you to Please try to enter Qty Fields in Trns Form.

Sir, Please share the file again because the attached file is showing an Error "unrecognized database format"

I Have multiple Queries in Trans Form, but will ask one by one in each threads I Have a three tables : Item_Mast, Flt_Master and Trns and all are linked as shown in Snapshot attached. In Trans Form : All Three TABLES Data will be requiring in Trans form. Here...

Many -Many thanks for your Support, Requesting you to Please Share the sample code for sequence number generation.

We tried with Identity Column, but after adding Identity It is jumped when invalid data is entered

Please find below the requisite details : Transaction (Table-1) We are in trying to enter Delivery order(Transaction Form) for In-Flight Catering Services Project, wherein Delivery Order is fed for Meal Order received from SpiceJet Airlines for Specific flight e.g. Flight No. SG131. Flight...