Forms :: Show Picture When Hovering Over Product Name In Order Form

Mar 11, 2014

I'm creating a database for a flower shop for training purpose. I have a main form with a sub form that has the orders in it. when placing a new order for a client and selecting the product from the combo box, it would be great if the product could show up to the right in the form.

I have no clue if this is possible and how to get it working. I have included the database as an attachment, which way to follow. I remember that I could do this on a web page, but a web page is not the same as a database.

View Replies


ADVERTISEMENT

Forms :: How To Show Picture In A Form

Jul 9, 2013

Now I Making A FORM..... The detail i want is NEED INSERT PICTURE and DISPLAY picture in a box...

How to display a picture when i insert it? or other solutions to show a picture in the form after i attend / insert.

View 1 Replies View Related

Forms :: Sortable Lists In A Form - Show People Who Have Product

Jan 14, 2014

I have a form I need to sort based on criteria in a persons record. We sell certain products. And we need the ability to only show the people who have a product. For example, we sell EPLI and WCF. I want to be able to pick a drop down list and it only shows and goes through the EPLI people. How do you do this?

I attached my database can you take a look on how to do this?

View 3 Replies View Related

Tables :: How To Input More Than One Product Per Order

Nov 19, 2013

i am very new to access. Logic and method needed in order to create a data base that records weekly orders.

What types of tables do i need?
How can i input more than one product per order?
How do o group the information in a organized way?

Ideally i would like to Input the clients name the week of the order and then all the products etc that are ordered.

Then be able to see in an orders table each client that made an order and a subdatasheet (the small plus in the corner) that once clicked i see all the products that are in that order?

View 10 Replies View Related

Product Pricing DB Looking To Show Similar Products

Mar 7, 2013

We have created a database (electrical contractor) of all our customers, invoices, work orders, etc. and been using since 2000. I have created 'not billed' reports and queries for specific types of jobs. Next step for me has been to create a db for our products we purchase from vendors. they can be the same product from different vendors, or same type of product from same vendor but different manufacturer.

We use this to order inventory, check contract prices once we receive invoices from vendor, and provide estimates to our customers so, there are many people looking to search different pieces. I have a good product base entered, and have been looking through sample templates to try to find a way to bring up similar items when you find 'widget1 from vendor1' i would like to click or show somehow 'related items' window?

View 2 Replies View Related

Queries :: Product Per Date - Show Days With 0 Sales

Aug 11, 2014

I'm trying to build a query that adds up the total sales for a given product per date. The problem I'm running into is some products have $0 sales on a given day and don't appear in the table I'm querying. How would I get the query to add a record for that day for the given product with 0 in the sales field?

To give more details, I currently have one table showing the sales data. It has a record for every sale that includes the product of the sale, the amount, and the date. In the query, I'm summing the sales for a given day and product. Then I plan to export to Excel where I will run additional analysis.

If there are no sales for the product in a day, I'd like it to list the date and product with a $0 in the sales column.

View 5 Replies View Related

Getting A Picture To Show Up In Record

Aug 27, 2011

I am new to access database . I am trying to create a database for my stamp collection. I have created a table and no I want to have a picture of the stamp show in a report. I followed the instructions about creating a field that will be OLE object aware. But when I insert the path to the photo nothing comes up in the photo space. except the name of the path. I tried .gif .jpg .tif files none work.

View 1 Replies View Related

CheckBox.check = Show Picture

Oct 31, 2006

Hello I'm at a loss on how to get this to work.

I have a check box and I want it to show a picture if it is checked and hide the
picture if it not checked.
I dont know where to put it either, do I put it in the form load procedure or in
the checkbox procedure?
Basically I want the user to check the box if it is needed and when they open
it later they will see the checked box and the picture.

Here is what I am messing with.

If checkBox.?????? = ? Then
imgPicture.visible = True
Else
imgPicture = False
End if

I cant figure out how to do this.

I'm using Access 2002

Thanks for the help.

View 8 Replies View Related

Is There A Way To Let An OLE Picture Field Show A Link To For Example P:PicturesTes

Jun 27, 2007

In my table I have Picture (OLE) and Link_String (Text)
On my Form I have the OLE field and the text field.

In the text field I would like to put in a reference to a file on my computer (example: P:PicturesTest.jpg) and the picture OLE field should then show the linked to picture.

Is there a way to code this?

Greetings,
ACF

View 2 Replies View Related

Forms :: Picture In Form View Never Scrolls

May 19, 2014

The form is specifically made to be wider than the screen, so that there is a scroll bar at the bottom. I have an embedded picture for the background which is intended to be the size of the form, meaning that the picture is also wide.

In Design view, I can see that the background picture fits the form perfectly, which is what I want to see in Form View.

In Form view, though, the picture is squished to fit the screen. The only time it doesn't do that is if I set the Picture Size Mode to Clip, but then it only shows a portion of it, and when I scroll horizontally, the background picture doesn't scroll with it.

View 4 Replies View Related

Reports :: How To Show Picture On Report If Control Is True

May 28, 2014

I have a report called "orders" and on this is records for orders of the day inputted.

On this report I have a control called "urgent" and a picture called "UrgentPicture" with the picture set to visible.false?

If any of the controls for Urgent is True then this will show my image, but this is not happening?

I am using this in the current event on the report

If Me.Urgent = True Then
Me.UrgentPicture.Visible = True
Else
Me.UrgentPicture.Visible = False
End If

View 3 Replies View Related

Forms :: When Creating Form From Tables / Don't Have Picture Shown

Jan 31, 2015

When I have a simple table, users pictures inside maps (jpeg,png...) defined as OLE object, when creating the form from that tables, don't have picture shown, only name of the picture? I tried all the options, package, copy, paste... nothing...always the same... just picture name but no picture.

View 1 Replies View Related

Forms :: Changing Form Picture Based On Combobox Selection?

Jul 30, 2013

I would like to set up a picture in the form that changes based on a combobox selection, for example if you select from combo box list "design1", a picture that have a name : design1 will appear as a background to the form ..

View 8 Replies View Related

Forms :: Toggling Visibility Of Picture For Each Row In Form Detail Section

May 31, 2013

" Is it possible to toggle the visibility of a picture on a form's detail section for each row based on a query whether a certain condition is met? "

I have a form, which fetches data from a database and populates the content as a number of rows in the detail section.

For each row I want to test if a certain 'yes/no' condition is met on each query and the toggle the visibility on a picture that I have placed in the detail section.

I've tried seveal possible solutions now, like macros and VBA but haven't got it working.

Btw I'm using Access 2010

View 4 Replies View Related

Text Hovering Over Textbox

May 25, 2006

Hi

does anybody know how to get text to show over a textbox. until the user doesn't enter the text box it will show instructions or a label perhaps. i have seen it on some samples and now i can't seem to locate it. i think this is an easy one. i need to save space on a continues form. i would like to get rid of the lables.

thanks,

sam

View 14 Replies View Related

General :: Tab Control Auto Opens When Hovering?

Apr 1, 2014

So I ave a tab Control with 5 tabs. When I hover or move across each tab name it auto opens that page, so I don't have to click to open. How do I get the VBA for this?

View 1 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.

=Sort_1("Sort_1_Query1","LAST_NAME")

This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function

I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.

View 4 Replies View Related

Should Be Easy For Someone - Show Only Last Customer Order, By Date?

Feb 22, 2006

Hi all, i have a query which will be used for reports, and only the last order placed by a customer is needed to be shown. Here's the table used in the query:-

tblCustomerPurchases
CustomerNumber
PurchaseNumber - PK,Autonumber
DateOfPurchase
SeasonID
TotalCost

So obviously for one customer there can be several orders, but i just want to show the latest one by the date field. I have tried grouping by the date field on both Last and Max, but with all the other fields from the table in the query (i need to have all the fields from the table for the report by the way) it still shows all the orders for a customer.

If i only include the customernumber field and dateofpurchase field and then group by date i have 4923 records, which is the correct amount, only one order per customer (the latest one) but adding any other fields to the query gives me the full 7000 odd orders (several per customer).

Any help would be much appreciated, many thanks in advance.

View 9 Replies View Related

General :: Get Some Information To Show Up In Chronological Order?

Jul 17, 2015

how to get some information to show up in chronological order.

For example,
It is showing up like this..

Week 1
Week 10
Week 2
Week 20
Week 3
Week 4
and so on

I want it like week 1
week 2
week 3
week 4
week 10
week 20

View 8 Replies View Related

Forms :: Fields Missing On Tab Order Form

Apr 9, 2015

am trying to change the tab order but have noticed that some of the fields are missing from the tab order form. I am attaching a screenshot to show which tabs are missing.

Screen Shot 2015-04-09 at 21.44.55.png

View 7 Replies View Related

Forms :: Cascading Form - Numerical Order ID

Apr 2, 2014

I have a problem with a cascading form, which writes back to another table. The scenario is:

There are three tables. Users, Departments & SubDepartments.

Each table has an Autonumber set as the primary key .

The form is to write back to the user table, and within the user table there is a Department & SubDepartment field. These are linked to the relevant tables and all that works.

For the form I have two combo boxes for Department and SubDepartment. Department simply pulls from the Departments table and displays/writes back to User table correctly.

The SubDepartment is the one I am having problems with. I have got it to cascade correctly but here is the exact issue:

On the existing records the subdepartment is being displayed as a number (the primary key autonumber). The drop down list displays the text of what the subdepartment is (which is what I require) but then when that is selected it throws up the error that the value entered isn't correct for that field. I guess it's because it wants to write back the numerical record ID rather than the text from the other field.

The row source query is SELECT [qrySubDepartment].[SubDepartmentName] FROM qrySubDepartment ORDER BY [SubDepartmentName];

The table fields for the subdepartment table are SubDepartmentID, SubDepartmentName, DepartmentID and SDID.

SDID can be ignored for the purpose of this question and DepartmentID links back to the main department. Just to confirm visually the cascading form does work in terms of when you pick a department it only displays the subdepartments associated to it.

View 2 Replies View Related

Forms :: Order Form Pasting Data Into Table

Aug 20, 2013

Okay I have an Orders Form, which generates a SubTotal Price (ex VAT), VAT, Shipping & Freight Charge based on an IIF statment of being under a 50.00 order apply 20.00 charge. And finally a Order Total with it all added together. This works fine, however I cannot seem to find a way to post these prices in my Orders Table. When I click on Datasheet View for the form, all the details appear as they should.

View 3 Replies View Related

Forms :: How To Update Product Field

Nov 7, 2013

My Products field update issue in form...i have a created Products form with table require

they details are:
Ex:
ID--Brand --- Model -- Color -- - Product
----------------------------------------------------
1---LG Ref -- 123456 ---Red------LG Ref 123456 Red
2---LG WM---123457---White-----LG WM 123457 White
3---TATA-----223652---Silver-----

Brand, Model, Color & Product filed details are same. So above Brand, Model, Color Details are need to update in Product Field with automatically without typing. So any VBA code or any formula will be update automatically?

View 11 Replies View Related

Forms :: Setting Sort Order On A Form With Multiple Subforms

Mar 4, 2014

I have a tabbed form. The main form is titles ContractDtlsFRM. There are 3 other subforms in separate tabs. The first field in the ContractDtlsFRM is Contract No. I would like the form to sort in ascending order by this number.

I tried entering the following code in the Forms Order By event but it didn't work

Private Sub Form_Open(Cancel As Integer)
Me.OrderByOn = True
Me.OrderBy = [Contract No]
End Sub

View 2 Replies View Related

Forms :: Sorting Recordset Clone Without Changing Order By Of Form?

Sep 27, 2013

I would like to get the Min + Max values of the data currently in the form, but without changing the sorting currently on the form.

So I was hoping for this, but it is not working. The data in the recordset are not sorted.

Code:
Set R = Me.RecordsetClone
R.Sort = "SendOn ASC"
R.MoveFirst
MinDate = R!SendOn
R.MoveLast
MaxDate = R!SendOn

Any other method except iterating through the entire recordset?

View 3 Replies View Related

Forms :: Bound Form - Items Not Appearing In Alphabetical Order

Aug 2, 2013

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved