Forms :: Pictures Show After Information In A Field

Jun 29, 2014

My idea is to have a field in my table that have ratings for example - 1,2,3,4,5,6,7,8,9,10. How can i make one star.jpg image to appear when I've entered rating 1, two stars to appear when I've entered rating 2, 3 stars for rating 3 and etc.... Is that even possible? If it isn't is there any other way i can make this?

View Replies


ADVERTISEMENT

Forms :: Getting Information To Show Up In Box

Jun 20, 2013

I am creating a new form and right now I only have 3 controls: Employee name, Employee ID, and Hire date.

How can I type in an Employee's Name and when I hit enter I get the info in the other boxes to show up?So what I am wanting is to be able to type in a name and hit enter and have all the other boxes populate in the form?

View 1 Replies View Related

Forms :: Subform To Show Latest Information

Sep 14, 2014

I created a vehicle database that includes a sevice subform to track service history. The main form is bound to the vehicle table that tracks the vehicles we have. (Vehicle_ID). The service history has its own table that stores its history and is link to the vehicles table. I created a report that shows my vehicle and its last history item. When i click on it, it will bring up the vehicle form where you can add information. Is there a way to create the form, so when i enter the latest information and i click on it, it will bring up my main form, and in my subform svc history, display the lastest information.

View 1 Replies View Related

Modules & VBA :: How To Use Treeview Click Event To Show Pictures In Folders

Dec 10, 2014

I have been looking into populating a tree-view with folders and files, and have found some great examples for doing this, How ever...I cannot seem to work out how to show files/pictures in a form based on the click event of the tree-view.

I have managed to do an onclick event for the files in the tree-view, but I cannot seem to get the onclick event for folders in a tree-view.

Here is an example which I am working on at the moment, but get the error Object variable Or with block variable not set.

Code:
Private Sub tvw_Click()
Dim tClient As String
Dim tParent As Scripting.folder
Dim fd As Scripting.folder
Dim fNode As MSComctlLib.Node

[Code] .....

View 14 Replies View Related

Need: Inserting Pictures. Need To Understand Or Need Better Way Of Adding Pictures

Jan 31, 2005

I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.

Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.

I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.

In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.

In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.

I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.

So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?

Regards, Roy (HerlocherR@aol.com)

View 2 Replies View Related

Forms :: Stock Number - Place Information In A Field Automatically

Feb 7, 2014

I have a stockist which includes " stock number", " description"

When I use these parts to create a "bill of materials" for a job I am presently selecting the material and this data is going into the table and the stock number just goes in the form not the table, is there a way that when I select the "stock number" the material will still go in the table and the stock number stays on the form. or also go into the table

The reason I want to do this is because the stock number is easier to remember than the description ...

View 3 Replies View Related

Forms :: Sequential Numbering Based On Information In Combo Field

Sep 4, 2014

Creating a form against a table with the following fields

EC
Project
Originator
Title
Full description
Effectivity
Etc....

Easy enough to create the Project combo box, problem comes with trying to systematically assign the next EC number.

When I select a Project from a combo box I want an EC assigned with format ECXXXX-### where XXXX is the project number from the combo box and ### is a sequential number. ECs should start at -001 for all projects.

Do I need to add an EC suffix field to hold just the ###? Then what?

View 6 Replies View Related

Only Show The Report If There Is Information

Jan 18, 2006

I have a form with a list box that shows a number of reports that are ultimatly built from queries.
Depending on what information I have put in, some of the reports will not show any information, which is fine. Is there a why that I can tell the report to open only if there is information present or maybe change the colour of the name of the report in the list box.
This sounds a bit complicated but hopefully I have explained enough for someone to help, thanks in advance.

View 4 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

Modules & VBA :: Save Input Into Array And Show This Information

Nov 23, 2013

I want to save input into an Array, and then show this information.To enter data I am using a textBox. After "Enter" it should save info into the Array.If textBox is empty, it should show information. I would like to use a textbox too, that shows all the Array after pressing Enter.

textbox on the Form: txtInput, txtOutput..I have the following code, but I am not able to get it work:

Code:

Option Compare Database
Public Sub Form_Load()
Dim Data(10) As Integer
Dim i As Integer
Dim j As Integer

[code]...

View 4 Replies View Related

Pictures In Forms

Jun 21, 2007

I know if you use pictures in forms it makes the database file size very big, if you have a products database and want to show a picture of each product, therefore each picture is different, is there a way of doing this and keeping the database size reasonable?

View 9 Replies View Related

Include Pictures (jpg/gif) On Forms

Feb 6, 2006

I am putting together a query-based form for an auction, that needs to include an image of each item retrieved.

One of the columns in the source table contains the name of the picture file (e.g. "pic001.jpg","nopic.jpg") to be displayed for each row retrieved.

How do I link this text with the presentation of that image on my form?

I have a pretty sound knowledge of SQL and I'm fairly comfortable with Access.

All contributions welcome!

View 2 Replies View Related

General :: Pictures As Backgrounds For Forms

Nov 20, 2012

Can I add a picture as a background for a form, rather than just a colour? I can't see how, but I'm sure I've seen others do it.

NB: I have developed my database in Access 2003, to ensure that it is usable by all computers networked on my system.

Also, would this dramatically alter the size of the database?

View 10 Replies View Related

Forms :: Pictures (BMP) In Command Buttons

Nov 3, 2014

I am trying to create command buttons with a picture (bmp) on it, and centering the label and the pictures in the middle. I selected bottom position for the label, but it seems to keep the pictures always aligned on the left.

View 2 Replies View Related

Forms :: Embed All Pictures In Form At Once

Jun 26, 2013

I made a db with tons of forms and they all have pictures on. I want to know if there is a quick way to embed them all so I don't have to go in the settings of every picture and do it manually!

View 1 Replies View Related

Forms :: Displaying Pictures On Form

Oct 7, 2013

I'm trying to place a picture on my forms using a browse button code i found on the net. After picking a picture, the image won't display automatically during run time, i still need to select design view and finally form view just to display the image. Im using the events form current, and the text box afterupdate.

View 1 Replies View Related

Forms :: Show Records With One Common Field Value

May 23, 2013

I'm a beginner trying to build a simple database for work. I'm trying to track the performance of bonds from month to month, in this case January-April. Each bond has a serial number called Serial_ID, but we wanted to create a record for each month we own the bond, so we created a primary key combining Serial_ID and start date called Serial_Start_Date. So if we own one bond, its January record would have a primary key of "4553123A 2013-01-01" and February would be "4553123A 2013-02-01". I created a form that allows a user to select one individual month's bond and display that month's return. However, I'm struggling to find a way to create a form that allows me to just select the Serial_ID and display the four month's records. Right now there is only one table in the database.

View 1 Replies View Related

Forms :: How To Show Attachment Field In A Form

Jul 6, 2015

I have a table with an attachment field in it. I want to show this attachment field in a form

This attachment is a picture (I want to have the exact picture in my form).

View 10 Replies View Related

Forms :: Field To Show Count Of Records Between Dates

Apr 30, 2014

I'm creating a form to count the number of employees with birthdays between 2 dates. There are 2 unbound date fields; Start_Date and End_Date. I have an Employee table with DOB field. I've been stuck on how to get the field to return the correct number of employees that fall within the 2 dates.

View 2 Replies View Related

Forms :: Store User Name In Table And Show Up In Field

Aug 27, 2014

I managed to count the performance of users. The only thing I need to do is to put the names of the users on the form (under different tab) so I can select them and they show their performance. The best would that they are showing up there in the form till I change the names. I use now a text field to write the name, but when I close the database and open, I need to add the name again.

If I could use somehow the names from the users stored in a table, that would be great.

View 4 Replies View Related

Queries :: Multi-Field Union Query (Joining Questions And Pictures Into One Report)

Apr 5, 2013

I have two tables containing (let's say for simplicity) questions and attachments (pictures). I am trying to perform a union query to join all the questions and pictures into one report, but it won't let me union the attachment because 'the multi-valued field 'TableA.Pictures' cannot be used in a union query'.

I have searched and searched for a solution (and got kind of close) but i still can't get it to work. The best I can do is union everything like below, which gives all the questions as desired, but says #Error in the pictures column:

SELECT TableA.*
FROM TableA
Union
SELECT TableB.*
FROM TableB;

(Note tables A and B have the same structure, several yes/no and open text questions as well as one attachment field. )

View 8 Replies View Related

Forms :: Unbound Calculated Field - Show Results As Currency

Oct 16, 2014

I have an unbound calculated field [Txt1] that I would like to show the result as currency. The fields in the calculation are:

[CR] number, currency
[Commission1] general number, two decimal places
[Commission2] general number, two decimal places

The calculation is: CR15W * (1 - Commission1) * (1 - Commission2)
If I just set the field to currency it works fine. But I want the field to show the following:
"Some Text" & " " & Format(Calculation, "Currency")

When I tried to include the format it to currency I get type mismatch, run time error 13.

So I thought that perhaps I should try the following just to see where my error starts and I get the same error message when I use:

Dim Val1 As String
Val1 = CR15W * (1 - Commission1) * (1 - Commission2)
Txt1 = Format(Val1, "Currency")

Everything I have read says the formula is:

Format([Calculation], "Currency")

Is correct. So why won't it work for me?

View 8 Replies View Related

Forms :: Show Table Data Based On Date Field?

Jan 30, 2015

I have a form that each day needs to be filled in by staff of their activities.

By selecting a date, I want to the textbox to display the contents of the comments memo pad field in the table (tblToday...columns are t_date and t_comments).

My very limited access and previous SQL knowledge has eluded me and cannot fathom how to get the text box to show data based on the date selected?

View 9 Replies View Related

Forms :: Show Selected Subform Items In A Table Field

Dec 9, 2013

Given a subform that lists items:

a
b
c
d
e
f
g

Given a table that contains a coverage field

customer coverage
smith a, b, d, g

How would I create a relationship between a subform and a coverage field such that when i multi select items in the subform, it will show what items are selected in the coverage field as in the example.

View 1 Replies View Related

Forms :: Field Doesn't Show Full Length Of Record

Dec 4, 2013

My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields.

I don't know where the mistake is occurring or indeed I don't know if the error is in the table or in the form.

The form is showing full length of the text but when I look it in the table, it has just one or two bits of the full length.

View 4 Replies View Related

Adding Pictures To Forms And Reports (Access 2000 Vs 2003)

Apr 8, 2006

I have successfully used the recommended way to display images from a folder in a form as posted on the microsoft website.

http://support.microsoft.com/kb/210100/

These instructions were for Access 2000. I noticed that there are seperate instructions for doing this using Access 2003.:

http://support.microsoft.com/kb/285820/

My questions are:
1. If multiple users access this database using different versions of Access (2000 and 2003) will it not work for some?
2. do i have to modify code if i update to 2003?

Thanks for youir feedback!
~Bruce

View 1 Replies View Related







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