I am trying to add a profile picture to a dog database. The way I have it is that the picture is a file and gets renamed the dog_id, on the query for the form I have added the extra coloum
[code]ImageFile: "C:Gundog Training DatabasesProfilePictures" & [Dog_ID] & ".jpg"[code]
is there a way to create a profile on each person on my database, to show their contact details and whether they've made a purchase from me before, or must I literally just make a table entering each individual person and purchase?
My boss (in another job) showed me very quickly an extremely old database one of his old employees had made for him years ago containing all of his clients, each shown individually, and he was able to click through each one, and each window showed the client's name, contact details, personal details, etc. and he just had hundreds of entries for all of his clients and was able to scan through each individual one. I am 99% sure he said it was on Microsoft Access that he'd done it.I just want to monitor how many of mailing list subscribers have also made purchases and whatnot, as I do rewards for them, and it'll be much easier to view each person's profile and the orders they've made than have to scan through a table to find each separate order?
On a webserver certian files are stored above the root directory. Therefor the user of the website can never access those files directly. But he is utlizing that file.
For example: We use Hotmail to see our mails. but we never download the complete database.
So is there a method that we can secure the backend using roaming profiles or something else so the user has a link to the backend but cant directly access the backend.
I am using MS XP Prof and MS Access 2003. I have built a database for my model car collection. I have tried to creat a form that I can insert a picture of each model per record( similar to the Employees form in the Northwind sample database. I have all the catagory fields and labels and character boxes working fine but I need to know what sort of catagory or box to enter in the design so that it will accept a picture from the files in Jasc Paint Shop Photo Album. I keep getting an "OLE server" error If I need to I do not know how to open and install the OLEserver or register it necessary. I'm totally frustrated. Thank you,
My form has a Record Source of qry_Profile, it is a query that shows the user the records of the dogs that they currently own. I want to put a button in the form footer to allow the user to show the records of all the dogs that they have ever owned.
So my question is how do I change the record source with vb.
I want to send out my database to a client so they can add records into it via the forms i've created, but I don't want them to be able to change the coding etc. But I also want to be able to update my database and send it back out to them but obviously the records they've entered need to remain. Do i convert it to an accde and then back to an accdb, make my changes then convert again to accde?
I am building a database where one Form displays records from 14 different tables. For some reason, when I recently try to add a field on to a form from a new table, the ENTIRE form loses the record source, and every single field that is already on the form gets that green dot in the corner with errors surrounding a record source that cannot be found. What am I doing wrong? Am I exceeding some limitations with forms?
I understand that their are several ways to work with pictures and comboboxes. Working with an OLE Picture is not prefered. But I only need to add 5 little signatures. Previous attempts, like trying to connect with my SharePoint site and our server didn't work. So I have only one option left which is to work with an OLE object. Because the pictures (signatures) are just arround 15kb, I think it will not influence my database a lot.
Because I only have about 2 weeks experience working with Access, I can't enable to show the signature (Picture in jpg or bmp) when a person is selected in a combobox. I compared the code with several other posts but all do it very differently. Signature is an OLE field. In this field for each inspector I paste his Signature.
In the form I'm trying to show his Signature via a combobox. But I can't find out how I have to make the connection between the Picture field and the table were the picture is stored. And this in combination with a combobox. Here is my code were I'm struggling with:
Option Compare Database Option Explicit Private Sub Inspector_AfterUpdate() Select Case Inspector.Value Case "Inspectors_Name" Me.Signature.Picture = Me.Inspector.Column(2)
after spending wweks perfecting a database which centres on the ability to email the contents of what you have just entered i find that our stirling IT dept haven't actually setup any of my intended users with outlook profiles and do not intend to. Therefore whenever they try and send an email they get the dialog box you get when trying to connect to the internet for the first time. Which is obviously a problem.
Is there any way around this or is there any alterntive i can use? my IT dept dont promise to setup any outlook profiles soon and im hoping there may be something else i can do before the project gets binned.
Not sure if this is can be done: I have a picture and I want to change its color in accordance with values in another textBox. Is that possible? if Yes, then what would be the procedure and the codes?
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.
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.
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 ..
" 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.
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.
I have a form with a textbox with the "LinkedIn" profile address that I want the user to be able to pull up when they click a command button. It works, except that the link opens twice in two tabs in the browser. I've checked over the code for the whole form, and this code is only being run from the click event of the button, so why would it open the same tab twice? Here's the code:
Private Sub cmd_Click() Dim ctl As CommandButton Dim txthyper As String Set ctl = Me!cmd txthyper = Me!LinkedIn