Search results

Good day ! I have an Access programme which used for last one year without any issue. However, recently noticed that few issues as follows; 1. Some data delete from the tables Automatically 2. Sometime it is not allow to access the database through the front end and when Database file open, it...

Good day ! Seek your kind assistance on below; Table name :TblMain Field 1 : Bkg_Number (text) field 2 : Container no (text) Field 3 : Size (text) Field 4 : Weight (number) Table Name : TblBooking Field 1 : Bkg_NUmber(text) Field 2 : Customer (text) field 3 : Vessel (text) Field 4 : Voyage...

Hi, Table name :Imports Field1 : ContainerNumber Field2 : Bkg_number Field3 : Size Field4 : Weight I have created a form which is having the above table as "control source". When data entering, if select a booking number from a Combo box, should checking how many records already having with...

Hi, I have a query which i need to get Zero as a result if NULL value. How Can i do this ? Present SQL code is as follows; SELECT tbl_Impts_main.Bkg_number, Count(tbl_Impts_main.Bkg_number) AS CountOfBkg_number FROM tbl_Impts_main INNER JOIN tbl_booking ON...

good day ! Need to generate a unique reference number each record wise while data entering by a form. How to do this by using a command button ? After entering all fields related to the record, when click on the command button, unique reference number for that record need to be generated and...

good day ! Need an assistance on below. table name : Schedule Field 1 = Vessel code Field 2 = Voyage Field 3 = ETA Field 4 = berthed Field 5 = Sailed there is a query by using above table and data entry form based on that query. need to add following facilitate While data entering, if...

good day ! I have an action query. When runs it and no result, need to give a msg "There is no data". How can i do this ? below is the code which i have used presently. Private Sub Command0_Click() If MsgBox("You are about to asign Vessel/Voyage for imported data.", vbQuestion + vbYesNo +...

good day ! need assistance on below. have two tables as follows; Master file:Vessel_master Vessel_code Vessel_name main data table:Main Vessel_code container_no size Voyage weight by using above two table have made a query as follows; Vessel_name:Vessel_master Vessel_code:Main...

good day ! There is a numeric field which containing weight of some items. need to make a calculation like below. if the weight is >9 then need to multiply by 10 (eg 270 ) if the weight is =<9 then need to multiply by 10 and also need to add "0" infront of the figure. (eg 050) is it possible...

Good day ! I have a Access data base (2007) which i splitted and store the back end database in a file server where all users have full control and the individual copies of front end put in the users computers. Unfortunately when one user is using the programme, others can not use. Following...

Hi, I have a datasheet subform where i need to select some records by clicking a check box and update a certain field/s of only those selected records. How can i code this ?

good day ! I have a form and subform where i have table data in the subform and 03 Combo box in the main form header. I need to do some filtering using combox box1 and out of that filtered records i need to do one more filtering using combobox2. then again another filtering by Combobox3. ( same...

good day ! need your kind assistance for following. i have a form and subform. need to do some filtering while form is loaidng. for that i put following code in main for "on load" event. Private Sub Form_Load() Dim disCon As String disCon = "Select * from tbl_Impts_main where ((disConfirm) =...

good day ! could you kindly explain how to generate an export specification file by using Access 2007. Many instructions says click on "Advance" while exporting a text file manually but unfortunately i can not find that "Advanced" option in my access software. Could you kindly help me on this...

good day ! Forum, I am trying to append some data from an excel sheet. Following code used for same and successful. However, i need to put few condition while importing the data to the Access table. i.e; Table : tblMain Filed : Vessel, Voyage, contianerNo, ......, ......, ....., while...

good day all ! I have a table. Also i have a text file which some of the fields are matching with my table fields ( lets say field A and B ). Now, i need to do compare of these A & B of my table against A & B of the text file and give a result as follows; 1. "Field A" not in the table but in...

good day ! Could you please advise how can i change the combo box fields headings. by default it comes according to the table/query field name. I need to put some thing meaningful. Kindly help. brgds Htadis

Good day ! i have a form where i put following two codes under two different controls. for the control Vessel Private Sub Vessel_AfterUpdate() Me.Vessel.DefaultValue = """" & Me.Vessel.Value & """" End Sub for the control Combo121 Private Sub Combo121_AfterUpdate() Me![Vessel] =...

Hi All, Would appreciate much if someone could help me on below. I have a table, when entering data i need to check two fields. If field 1 and field 2 filled with similar data like in the previous records, error msg should appear that filed 1 & 2 are already exist. however, if field 1 is...