Recent content by ckleung

Hi, Eugin, Thanks a lot.

My database has a field [Time], e.g. [09:30:00] , I want to add a field in the query [ArriveTime] that show the time 30 minutes earlier than the [Time], how the formular set?

Hi, Mihail and SOS, Thanks for your advice. The problem has been solved. Thanks again.

Thanks, SOS, can you teach me how to write the code?

Hi, I create an inventory report which source is from a query. I have set a field "Date" displaying in ascending order in query. But the report cannot achieve that result. My code is: Private Sub PrtDelRec_Click() DoCmd.OpenReport "DeletionTransferRpt", acViewPreview End sub Can anyone...

I created an "Inventory" table with a field "InventoryNo". I want to add a barcode to a report that related to the "InventoryNo". I have added a Barcode control from ActiveX control in a report that contain 2 field: "InventoryNo" and "Barcode". However, I can only see the "InventoryNo".

Thanks Thanks for your advice. Maybe I do it too complicated.

I have 2 table that have the same field [DischargeDate], I want to auto update Table2 when I type in the data in table1. I write the following code, but it didn't work. Private Sub txtDischarge_AfterUpdate() Dim cnnDB As New ADODB.Connection Dim rsObject As New ADODB.Recordset Set cnnDB =...

HasData can't work Rich, I explain my problem once. I create a report that print the clients admitted in a month, the source is from a query. At the report footer I have a textbox. I write the code in the control source: =IIf("rptAdmissionCount.Report.HasData",Sum([This Month...

Still does not work Rich, It still does not work. I do as Smart say and write the code as you say. But it still prints "error" when there is no record found. Is there anything I have done wrong. Any way, thanks for your advice. ckleung

Does not work Smart, I have tried this before, but it can't work. I also try the following: =IIf(IsNull(Count([EngName])),0,sum([Total])) but it still don't work. Have any idea? CKLeung :confused: :confused:

HI, I want to generate the number of the result of the query in the report. But if there is no record show that means there is no admission in that month, the report footer will show error instead of "0" which I want the report show. I put the following code at the footer: =Sum(IIf([Please...

:confused: :confused: I have a form in which there is a button for printing report. When I press the print button just after completed entering one record, the report of that record would become error. Therefore, I need to close the form and re-open the record, then every thing will be OK...

I don't understand Dear Mr. Phile, Thanks for your advice, but I don't understand the above statement. What is "a set of Cascading Comboboxes?" How to do that? Should I make relationship among the tables I created as you said. Please give me more detail lession because I am too new for...

Hi, I create 3 tables, they contain the names of "Area1", "Area2" and "Area3." Another table named "Region" that contain "Area1", "Area2" and "Area3." Then I create a form. I want to achieve the following: I make two comboboxes. One conneted to "Region." How to do when I select "Area1"...