Search results

Great ! I was thinking of that option (can grow/shrink) but was not sure if the row would get hidden. Thanks a lot !! Will try it out @ work.

Yes, there are 3 different types of taxes applicable. Depending on the type of order one or more taxes will be paid by the customer. And I may have to show the "Total tax amount" and "Total paid" also. Thanks for the help.

You are right ! But this table with Order_id, Order_Value, Tax1_Amt, Tax2_Amt, Tax3_Amt......and several other fields is drawn into Access from an Excel worksheet sent to us. And in Excel it's a strip of information in one row per order where the customer (depending on some condition) may have...

Hi. How do I suppress (not display) the empty fields in detail section of my report ? Table structure is as: Order_id, Order_Value, Tax1_Amt, Tax2_Amt, Tax3_Amt Report format is as: Ord_id : Ord1001 Ord_val : 500000 Tax1_Amt : 12000 Tax2_Amt : 3650 Ord_id : Ord1003 Ord_val : 965000...

Fantastic !! It worked.:) You always give such excellent solutions, and so quickly. Many thanks !!

Hello ! 1) I created a simple report using the wizard. It's in landscape mode. On screen it shows all fields within, but when I print it; I see that the last field with part of its data is spilled onto page 2. I've tried to adjust page margins etc, reduced the fonts etc., but still does not...

Great ! Thanks a ton !!

One more thing. Is there no need to convent the date into a string like str(format(.... ??

Thanks for all the help. Will try and see. Concern is the date part in the string.

Hi. I have a form in which I fill some fields (3 text boxes, 2 combo boxes). The last field is also a text field (255 chars) that needs to be populated based on the other fields. It's like a string concatenated. The fields are date_in, date_out, item_name, status. My code is as follows ...

Thanks a lot. Will try that.:)

Thank you all very much. I did try the me.undo attached to a cancel button on the form itself; but it does not work . Prompts with a 'cannot undo' message. ( Is the me.undo meant for the last committed record to be rolled back - just for my knowledge) BTW, I did not code Cancel = True before...

Hi. How can I clear all the contents entered during data entry fields on a form, after say I enter 8 of the 15 fields on a form ? What I mean is, I dont want that record to be entered. Access defaults to filling a record partly in the underlying table, as I am using a bound form. Is there a...

Excellent ! Thank you so much. :)

Hi, I have a Dlookup code on a field in a form. It fires properly and finds if a value already exists in the underlying table or not. And a msg box pops up are as per my code. But, it behaves erratically. Sometimes, it does not find a value that exists in the field at all. I need to refresh...

I think my initial post covered the expected results of the query. However, I'll re-frame the question and post again soon. Thanks.

Sure. Table : OrdersMain Fields : Slno, Itemcode, Itemname, QtyOrdered, DateOrdered. Status Records : 1,S100, Shoes,150, 12-jun-16, Delivered fully 3,S100, Shoes,200, 14-may-17, Partially delivered 8,S100,Shoes,300, 22-sep-17, Delivery due...

Hi. Is it possible to get a query result (grouped) as follows: ? Itemcode,Itemname,QtyOrdered,DateOrdered ( are the fields) S100, Shoes,150, 12-jun-16 .....................200, 14-may-17 .....................300, 22-sep-17...

Thanks ! I'll try that.

Hi. I have a table that records material received. The main fields are MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status. Any material can come any number of times in a month. Each time it comes, it is stored as a record. Example : MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status M121, Steel...