Search results

Thanks. I found it.

Thanks for the direction. I followed the link but it is difficult to follow because I cant find the referenced popup properties anywhere on my property sheet. I am able to select the "product" form by the "Order Details" form remains in the way blocking the others.

Good day all. When a click a button on form "Order Details" it opens form "Products". "Order Details" remains in the foreground and "Products" opens in the Background. This restricts access to "Products" unless "Order Details" is minimized or closed (neither of which I would prefer). I want...

Thanks. I tried it but in the viewer it cannot get smaller

Good day, I am inserting a logo in jpeg format to a report. unfortunately the logo comes in very large. the frame around the logo can be adjusted but the image does not; it remains large. Can anyone offer assistance with this problem? Thanks in advance

Hi there. This explanation works fine; but I want to add a text into the cell rather than sum or some other calculation. How can this be done? Actually I want to put the work "Total" in the cell

ok I tried it as an attachment

I have 2010

The Datasheet distorts when placed in this window. And I can't get an image import.

That was incorrect.

Hope this helps. Order Subform for Order Details Product Qty Unit Price Discount Total Price Status Lamp Shade 0 $10.00 0.00% $0.00 None Table Lamp 6 $40.00 0.00% $240.00 Allocated Table Lamp 20 $40.00 0.00% $800.00 Allocated 26 $1,040.00

Thank. not really; there in no calculated control. The sum of the field is directly on the bottom of the same Datasheet. Actually it is in the 2nd row below the last record

Thanks for this useful explanation: however, I am trying to understand how to get the totals displayed in the actual datasheet. I am seeing this example in the Northwind sample database in a form "Order subform for Order details". I want to know how this is done.

Thanks; but I can't find the totals-Icon you are referring to.

Good day all. My form is a datasheet with 2 fields: "Product" and "Quantity". Obviously I can't add a calculated field in this type of form; however I would like the word " Total" to display in the "Quantity" field just under the last record. I would also like the sum of the "Quantity" field...

Hi, Very simple solution but yet I did not know it. Thank and thanks also of the advise on the use of the keyword "Date"

Thanks for your response. I simply do not need the dates in the query the dates are needed only to obtain a specific date period for example: 1st Jan 2014 to 31st Dec 2014. But I don't need the dates to show up.

Good day all. My table is "Instructors" and two fields are "InstructorName" and "date". I want to run a query which would group by "InstructorName". Problem is that the names are not grouping where the dates are different for an InstructorName. Even when the date check box is unchecked the...

Good day. I would like to publish my access file in sharepoint but I know very little about sharepoint and how to attain a free or testing or trial account. Essentially I would like others to access and edit the file on the web simultaneously. All youtube sites speaks to how to get...

Thanks VBAInet. That was a wonderful Sunday morning treat. All's well. I can get going now.