I have a form that is bound to a table of chemicals. On the form I have a combobox that displays records from another table of chromatograms for each chemical. There may be none, one, or multiple chromatograms for each chemical.
On the form I also have a graphic to display the chromatogram (.jpg file).
I want to have the graphic of the chromatogram update upon the change of chemical on the form. At the present time, I have the graphic display from the after_update event of the combobox. This works fine.
Is this the best way to proceed, or should I use a subform for what I'm trying to do.
Hello, does anyone know if is possible to create some forms with different graphics like round edges etc. Does Access allow this kind of utility or are we stuck to simple ones? THanks.
I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form. For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form. Basically an "If this is true, show this picture" type thing. I've been trying a few things to make this happen, but to no avail... :( Any incite anyone could give would be most appreciated.
Just wondered what was everyones opinion on how I should best included a graphic file (just for the eye it has no functional purpose). At the moment i have just pasted it in but it increases the size from 1mb to 17mb.
I have read, mostly understood, and abandoned most of the KB and WWF suggestions on using images in forms. I am _this_ close to having it my way, but I can't seem to get there.
The paper form I am emulating has a medical diagram of the human body, and the interviewer circles, crosses, or otherwise marks a particular part (say head or foot) that the interviewee indicates is giving him/her pain. In order to do this on a form, I need to load a blank medical image into a field, and let the interviewer edit the image as they would on paper, by leaving cirlcles or X's.
One of the Northwind examples uses embedded images in an OLE field, and when I double-click the image is brought up in 'Paint', and I can edit. Close to what I want. I can also copy the employee photo from one record to a new record, and still edit. Closer yet. But when I try to put in a new image, I'm back to the icon-with-file-name, or 'package', or varous other ways of not seeing a picture.
I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use.
In order to retrieve the information from the harddisk, I got a cable between this computer and another one.
This is my plan:
When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this?
second question:
If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer?
Does anyone try to play with graphics? I use a form with 3 tabs and tree forms ..in the second form (tab) I get some numbers from a customer and in the 3rd form I got a graphics with these two numbers but there not working ..i try to get these numbers from the form direct .. I get it but I can see only the numbers and not the graphic… I try it with a query I get the numbers (Like CustomerId= forms!frm_customers!id or forms!frm_customers.id or what ever workd) I get the numbers but again when I try to see in my tab the form or the form only I can’t see the graphic// Does enyone know what happen?
I am in the process of creating a 'how to' knowledge database using MS Access. I would like to create an input form that has a large field capable of entering both text and graphics.For example, the data inside Field1 would say...
How do I change the resolution of a monitor? Step 1: Right click in the middle of the screen <Display picture> Step 2: Select Screen Resolution <Display picture> Step 3: Etc.
The total number of steps and pictures for each knowledge article would be different for each item. There could be 1 picture in the article, or there could be 50.
Sadly however, I don't see any field types that could support what I would like to do. So far I've only seen examples where the pictures and texts are separate and static. I'm open to using links to point to the pictures inside the text field to a remote folder. I'm even open to creating a report that takes all of the information on the input form and organizes it in a way so it looks like the example given above. Are there any scripts, controls, or template examples I could look at?
I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.
Code:
Private Sub Manufacturer_AfterUpdate() If (Me.Manufacturer.Value = "Siemens") Then Me.Model.RowSourceType = "Table/Query" Me.Model.Recordset = "SeimensTable" Me.Model.RowSource = "SELECT Model FROM SeimensTable" Else If (Me.Manufacturer.Value = "Samsung") Then Me.Model.RowSourceType = "Table/Query" Me.Model.Recordset = "SamsungTable" Me.Model.RowSource = "SELECT Model FROM SamsungTable" End If End If End Sub
But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?
How would I modify multiple comboboxes in subforms at the same time. For example.. In main form ComboboxA user selects 1992, Combobox1 in subform1 is also changed to 1992, as well as Combobox2 in subform 2.
Hallo. I need Help. I have two tables Contacts and Orders. And have a Form with data from table Orders and one One ComboBox with data from Contacts. So, when i chhose in combobox for example contact name, i need to see all indormation about this contact from table Orders. How to make this?
I have 2 comboboxes, the first one is called "activity", whereby I have 3 options to choose from, and the second is called "level".
When I click an "activity", for example Drawings, I want the "level" combobox to list a unique set of options for that category. and if I click on a different "activity" for example Planning, I want the "level" combobox to show a completely different set of options.
If anyone can give me any help on how to do this then I would be very grateful!!
I have a form containing a combobox with the values yes (1) and no (2).
In my query I have a date field. When the value of the combo is yes only the dates should be displayed. is the value no the the empty fields should be shown. I nothing is selected all fields should be displayed.
I tried this:
IIf(IsNull([Forms]![Form1]![cboDate]); IIf([Forms]![Form1]![cboDate]=1;[tblITEM]![date_ID] is not null; is null);[tblITEM]![date_ID])
We are struggling with the following thing. We already tried to explain it in this thread (http://www.access-programmers.co.uk/forums/showthread.php?t=111533) but we still don't get it :(.
We have a table, named "Tblapa". This table contains: ID, UK, Area, Tf, Tt and Number
We have made a query, named "Qrychoosearea" This query gets his input from the "Tblapa" (and thus, the query results in: Area, UK, Tf, Tt and Number)
Now we would like to make a form, named "FrmArea" with a combobox. This combobox lets people choose an Area of their interest out of the list of given Areas. Then they have the press an "OK" button
Upon clicking on the "OK" box we want to generate a REPORT based only on that specific Area (and the related UK, Tf, Tt and Number ofcourse) and thus not showing all Areas.
How do we have to do that? As we are just beginners in Access and have no feeling for VBA (yet), a detailed explanation or a link to a website who explains how to do this (with images or so) would be much appreciated.
Okay I have 3 forms. I have one form which is called frmEndOfTrial on this form there is a combo box which has two values--> Accepted and Return for credit.
I have two other forms called frmAccept and frmRFC. I have dragged those two forms onto the frmEndofTrial form and set there visibility to No.
What I want to happen is that when the user clicks on the 1st or 2nd option that corresponding form opens below the combo box?
I've tried a few things here but can't get it to work. I'm pretty limited in knowledge on access. Right now on hte combo box events I have this code for the After Update event me.sfrmRFC.Visible = True me.sfrmAccept.Visible = False
I know this is not what I want and not finished cause if I click on either accept or RFC it just brings up the sfrmRFC. How can I do this???
I have a minor problem. I have a table and form with a carpool. I would like to be able to display history by date with the help of the combobox which car you had last week. But I don't know how to go about it.
I have attached a DB and would be glad if someone can but their magic touch to it.
I have a basic design question that I am not sure how to address.
I am trying to build a simple data entry database with a form to take input from the user, store the values in a table. Once the data is gathered into the table I want to use this table to print a report of each record (entered using the form before).
To achieve this objective, I made a form (frminput) with some text fields. Most of the fields on this form are Bound fields to a query (qrymaster). One of the field is a Combo box (whose value is shown from another table). I have designed the RecordSource of this Form to be a Query (qrymaster).
This is a basic Data Entry form where the user selects the Combo box item and based on what he selects, some of the fields in this Form gets pre-filled. The rest of the fields on this form are bound to the query "qrymaster" and the user has to type these fields manually.
Now, I want a Save button here that would save all the values on this form to the table "tblmaster". How do I do this efficiently keeping in mind all the normalization laws on the database?
At this time, behind the Save Button, I have included a SQL statement to insert all the field values into the table "tblmaster".
I am sure there is a better way to do this. Can someone point me in the right direction please?
I am trying to build a form that allows the user to INPUT stock as it arrives. This is simple with a product form that shows all the products in the table. I just go to the quantity field and change it.
But, I want to create a 'search' function in the field. I want to allow the user to type in the Product number. Then the Product name, Product Price and Quantity is AUTOMATICALLY displayed.
The user can then change this value (items in stock).
I have a combobox that displays information about a current record on a form (much like a subform would show all information related to a certain record). So for example, there is a user and the combobox would list all the users applications. Now, when the record is changed (via the navigation buttons) I want the combobox to requery, but I don't know where the query should go. I tried putting the requery under the primary key's afterupdate method, but no go.
Can anyone think of a solution? Do you understand my problem?
I would like to have a form with a combo box open and then when a company is clicked on i would like for my report to open showng all those listings. I have the query and the report and the form but how do i get them to all work together they are not playing nice.
I use Access 2003 and saw Ken Higg's sample database to filter records in a form using a combobox. I managed to replicate his settings and wondered about an extension to the principle, but I don't know if it's possible.
In the sample, a value is selected using a combobox and all matching records are filtered so it's possible to scroll through them. Is it possible to have a second (or more) combobox on the form so it is possible to filter on one or another criterion? This would mean one combobox filling the other one and I realise that the one that Ken provided is unbound.
The reason that I'd like to do this is, for instance, if there are records with Surname, 1st, 2nd and 3rd lines of the Address and Postcode, I may wish to filter records by entering the Surname or Postcode. Each of these fields would have to be displayed in a combobox. As the sample is set up at present, only one of the Surname or Postcode has to be selected via the combobox and the other is a textbox.
It may be that what I'd like to do isn't possible - or someone may have come up with some other idea. I'd prefer to have the search/filtering on the form, rather than using the buttons on the Form View toolbar.
I do not like the look of combo boxes on continuous forms. I think that they really take away from an aesthetic I am trying to create. However, I really like their functionality.
What I would like to do is have a text box for the field when the control does not have focus, but switch it to a combobox when it does. Now, this is pretty easy to do - however, it ends up switching all of the text boxes on the continuous form to a combo box and back. I only want to switch the currently selected record.
Does anyone know if this is possible, or have any ideas as to how to accomplish this?
I'm working on a db that will track students for a summer camp. One of my fields in my student records (CamperInfo) is "School". Currently, the field is set up as a combobox in the CamperInfo Subform in the FamilyInfo form. I would like the combobox to be able to add schools if the school is not listed by a pop-up when the "add school" (or whatever) is selected.
Code:
Private Sub School_AfterUpdate() On Error GoTo Err_School_AfterUpdate Dim strForm As String If Me.School = "Schools" = True Then strForm = "Schools" DoCmd.OpenForm Me.School Err_School_AfterUpdate: MsgBox Err.Description End If End Sub
As you might have guessed, it doesn't work. no errors, it just doesn't do anything. I added the "Schools" data.
I have a form with a combobox. From this combobox I would like to trigger the opened of a different form with the name and surname of the patients selected into the combobox.
I used this vba code
Private Sub Find_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "ID Patient" stLinkCriteria = "[PTS]=" & Me.Identification
[Code] ....
The problem is that when the form Id patient is already opened every thing works fine but when the Id patient form is not opened it looks like if the combobox was not able to trigger the form with the name and surname of the patients!
I have a combobox (cbo_Breed) that Holds the Breed_ID, Breed and BreedType_ID.
On the form opening I want to look at the thrird column and if its a "1" then to do something. How do I get the form to look at the third column? This is what I have written (I know its wrong, but needed a starting point)
