Recent content by htadis

Minty, thanks ! after seen your reply, i realized that i have miss understood the first question of Galaxiom. actually FE not shared. each user has an individual copy as you suggested. only the BE is shared among all users. As i know we are using LAN. pls advise if any solution to solve the...

Galaxiom, thanks for the reply. Are multiple users sharing the front end? YES Is the network between the front ends and backend congested? YES, ALWAYS THERE IS A LAGGING. could you pls advise the solution to overcome this issue. thanks.

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

Plog & Minty, I don't know how to thank you two. After struggling days, at last done with your great support. Many thanks again. :D brgds

Many thanks Minty. my Bkg_number is a text field. (sorry about not mentioned in the first place). have put as u mentioned above, but still getting an error msg. "You omited an operand or operator......."

Many thanks for the swift reply Plog. But, it returns total number of data in the record set. How can i get only the selected data. Can i put Combobox value as criteria. if yes, could u kindly show me how to put that.

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

Brian, yes, some instance my query is returning nothing. at that point i need to show '0' in the count column. is that possible ? brgds

Expr1: Nz([bkg_number],0)

thanks ! But it did not work. following error msg, sytax error(Comma) in query expression

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

thanks ! but can we generate this when we click on a command button. if with some letters that is much better. eg XYZ/GAA021/RO001

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

jdraw & vbainet many thanks for yr help. Shall apply above and let u know the feedback.