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.
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
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.
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.
What I am trying to do is have a form on an event display a set of records and pictures that are attributed to that record. A nice generic example of this is I have a query run to find all employees with the last name "smith". I want the form to display all the employee records with the last name smith and look up the picture file and assign it to an image box on the form. I have tried many different variations of code and queries and have not been able to get it to work. Can anyone suggest a more direct path than the hit or miss that I have been using? Really it seems to be multiple records that are the problem. I have many pictures coming up on the form based on a single response query.
here is a good example of changing a picture file on the fly in a form.
Public proff Public filestring As String Public picname As String Public proffpic As String Public fullfilename As String Public colore
Hi Good-Morning (its morning here in Jamaica) (Whatever time of day it is where ever it is that you great minds are in this beautiful world we live)...
I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record...
I now want to create a Continuous Form with the correct image displayed for each row or eachrecord///
The problem is all of the images are displaying the same picture, but i want them to show their correct pictures... I used an on current event which i guess is why tha is happening cause all the pictures change when different record selectors are clicked...
Please advise how i could get around this... I looked at the Northwind database, but that database uses an OLE object, I would like to use the filePath field that i have in my database...
i want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
First of all hi everyone, im lookin for some advice
i have database setup with record level locking for multiple users (havent decided weather its should be optimstic or pesimistic yet)
however either way i set this there is no idication that the record is opened/locked by another user is there an easy way to say pop up a msgbox when a user enters a record to say this is in use/locked and show who by using the username?
I am creating a query based on two tables: 1) tblClient (only one primary key "ClientID") and 2) tblContactDate (with two primary keys "ClientID" and "ContactDate").
Each client may have more than one contact date.
In the query, I only want the records from the tblContactDate showing for the MOST RECENT contact date of the client only; however, right now the query is producing more than one record for those clients with more than one contact date.
Not sure if I need add some special code to the "criteria" area in the Design View, or somewhere else. Your help is appreciated. :confused:
I need to write a query that includes the values of 2 fields from the following record. e.g
index Name Total Name2 Total2 1 Dave 8 Steve 4 2 Steve 4 Mike 6 3 Mike 6 Pete 4 4 Pete 4
I can get a partial success when I use the DLOOKUP function along with a sequential indexed field but I am working with 10,000s of records and any subsequent query based on the results of this takes an absolute age to run.
I have a "problem" in my database. I have a form, as you can see in the attachment. On that form I can choose different installations to which a spare part belongs to, but in that same list of installations it always shows a name of the first installation in the dropdown list. (a default record) This can cause some confussion, because you see the name in the list, although it doesn't belong there.
How can I fix this?
PS : If I'm not clear about my problem, pls say so, my English is not may native language.
I was having trouble adding my records to my subform. I think it was going into my main form, which is unbound. When I removed the navigation bars from my main form and added them back to my subform, I lost my records that i had. They are still in my table, but not showing in my subform. How do I get them in there?
hi, can anyone help me? i have created a database for the use of a distribution centre which consists of order details and other information. the main idea is for the system to show the next order listed automatically to the user. i have a table of new order details. each order can be one of three either completed, pending or awaiting delivery. so i want the system to automatically clear the completed ones for the user and for the next order details which are pending or awaiting delivery to be shown. how can i do this?
my table entries are reciept(primary key),name,reciever,address,amount...i want a query to show recently updated entry in table i.e only last entry from table
I would like to use a query to show only the records where "SRG" is not listed and where there is another group. So in the example data above, I would like the only record to show in the query to be the last record because it's the only one where SRG is not listed along with another group.
The logic behind this is when a problem is initiated and a group assigned, we do some things and document the results. So I am only interested in the records where we have not documented our results too.
Does anyone know how I can do this with a query?
Thanks, Jim
I want the query to only show the data where there is a user group
I have a form that is just a display/edit type form and I don't want a blank "new" report to show at the bottom when it is opened up. Is there any way to turn this off or disable it?
I am trying to create a textbox that will show a document number of the last record so when a user clicks add new document he/she knows what document number to enter in next. It must not involve the user looking a subform with the document numbers on it.
I have a Yes/No field for Tax in my table. Records that have this field checked will have 5% of tax added to its total cost. I did a DLookup on the On_Current event of the form and it does not work. My code is as follows,
i've designed a rental database (which seems to do what i want) - it's not perfect....
But i can't figure out how to accomplish this.
If i have a tenant, who has previously had a lease agreement on one of my properties, but then moves out, and then moves into one of my new properties, i can't seem to see how to get access to display just the new lease details.
I've attached a blank copy of the DB with some sample data to illustrate this.
you will see that test tenant has two leases, one expired lease, and one active lease, but on the main form it just shows the expired (original lease)....
I have attached a sample spreadsheet. Each store has a planned date which is calculated off the dates in column b and c. The second row is actual date.
As much of the data I have is in MS Access, I tried to use some extracts to appear in this format but no luck.