:confused: ok basically im trying to create a form for customer details for a project at college, what I want is:
select customer ID from a drop down list, which then should display all their details below such as address etc(from the linked table), which cannot be edited or nothing, like looking up information. can anyone help me please???
I a a new user to Access having only every ceate a couple of small databases using the wizards. I have just started a database where I have created my tables and I am now creating a form to display information. The problem that I am having is that when in Design mode I can see all the information and fields that I have used to create the form, however when i save the form then opening in display mode I do not see any of the fields, revert back to design mode and hey are all there.
First of all thanks to everyone who has answered my questions already, although I'm still having problems (more with my understanding and lack of Knowledge)
I'm creating a DB and I'm stuck, I'm trying to create a form that has three fields mailbox, applications & Drives. Each of these three fields need to be populated with many items. For example the mailbox field may have 5 different mailboxes required to be populated in this field.
What I want to happen is for the user to double click on the text box, then a new form containing a multi-select list box appears that you can select the items you need which in turn updates the role profile form. This is how I want it to work but if you have a better idea I'm all ears.
All I want is for someone to be able to view the role profile form and to be able to see what applications, drives and mailboxes are required for that role.
Basically I have no idea how you can get someone to choose several items and have that reflected and recorded in the required record.
I have attached what I have at the moment and any help or advice you can supply is appreciated.
In one table i Have component group Id and the description as fields then another table has the sub groupings for each Component Group Id
Example Component Group ID = 1 which is the primary key Description = Keyboards
Component Sub datasheet has Group ID = 1 foreign key Descriptive Options = USB, Wireless, PS2, Serial
I have joined both of these in a query but what i want is the query when i link it to the combo box on the form i have to only show the Group ID once and not repeat it for as many times as each subdatasheet has records.
Example: When i click External Device I dont want to see the word Keyboard being repeated 4 times (which is because there are four subrecords/types of keyboards) Please Advise.
On my form I would like the user to be able to select a company, and once the company has been selected I would like a box to display all the contact information for the specific company. I would also like this box to record the contact information onto my database along with the other information that will be gathered on the same form.The Contacts and Companies are linked with the COSYSNO and CoSysNo fields.
I have a split form that's like a list of pending tasks. The data source is a linked SharePoint 2013 list where users submit requests. The user takes the information from each record and performs an action. When it is done, the user presses a button and the task status changes from "Pending" to "Processed". The form record source is based on a query that finds only records with a status of "Pending" so when the user changes the status of the task, it is removed from the list. It works fine except when there is only one task left in the work list. If the user processes the last task, the form refreshes and it goes to a new empty record and I get an error message that says I must enter a value into one of the required fields. I tried making the field non-required but it just creates an empty record in the table.
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
After a very very very long time i've manged to crack my first QBF! When I click the command button to run the macro and display the results, the results are coming up in a table format.
Is there any way to have the results of the QBF displayed on the same form?
For example, if I have a table that contains my different products and their categories - in this example 50 different types of "toy trucks", 75 "toy cars" and 100 "toy trains" - and I then perform a QBF on the criteria of product type, in this example "toy cars" - I would want the first "toy car" record to show on the form in their relevant fields, and be able to scroll through 74 records before coming to an end.
This way I could easily place all my products in one table, then select which products I'd like to view in the form and scroll through them.
Any help would be greatfully appreciated as I haven't been able to find anything online.
Trying to display PDF in a form. Ideally, I would like to link one or more PDF's to each record in a table and be able to view the PDF within the form. Opening the file via double-click would be a nice bonus.
I've looked at a helpful post here http://www.access-programmers.co.uk/forums/showthread.php?t=100877 which describes doing this through ActiveX
Part of my trouble is I don't understand the ActiveX well enough. I was able to make this work with a sample file, but then I lost all the tool bars that were on the document and can't get them back. I also can't figure out how to get the double-click to open to work. Is there documentation somewhere on the ActiveX control?
I also tried using an OLE object. I can create a form in design view that contains a linked PDF, but I can't figure out how to index off a table. I also can't figure out how to resize (for a thumbnail, for example).
To display images on a form (Access 2003) I used the same code of the Northwind database sample (Form Emplyees).
when changing the Picture's location it returns a bug in the code (Couldn' open ...the file), or the ErrorMessage Label should have the value: "File not Found".
Here is the code:
Private Sub Form_Current() Dim res As Boolean Dim fName As String Path = CurrentProject.Path On Error Resume Next ErrorMsg.Visible = False If Not IsNull(Me![ProductPicture]) Then res = IsRelative(Me![ProductPicture]) fName = Me![ImagePath] If (res = True) Then fName = Path & "" & fName End If Debug.Print "fName: " & fName Me![ImageFrame].Picture = fName showImageFrame Me.PaintPalette = Me![ImageFrame].ObjectPalette If (Me![ImageFrame].Picture <> fName) Then hideImageFrame ErrorMsg.Caption = "File not Found" ErrorMsg.Visible = True End If Else hideImageFrame ErrorMsg.Caption = "Click on Add/Edit to add the Product Picture" ErrorMsg.Visible = True End If
End Sub
Function IsRelative(fName As String) As Boolean IsRelative = (InStr(1, fName, ":") = 0) And (InStr(1, fName, "") = 0) End Function #
:confused: I am setting up a referral system with a datebase on access. I want to have a form where I can enter a date of referral and the results are displayed in a form style? How do I do it?
I have set up a form to enter the date, with a submit button, and this return the results in a dataview/spreadsheet style. But I want to display in a form so that I can edit later.
I recently have made some changes to a bound form that someone else created. Since I made the changes, simply adding a couple more linked textboxes, the form will not populate any of the fields until I lose focus from this main form to another form and come back. I have tried adding me.requery, me.refresh to the onActive event, but it does not work.
Also this only occurs on 2 machines. If I try it on mine or a couple of other computers in the company the program works fine.
I am at a complete loss as to what to do and could really use some help on this one.
I have a table which has a yes/no field, in the table everything displays as either Yes or No, unless you click on it to edit it, whereby No become 0 and Yes becomes -1.This isn't a big problem as users can only access forms. On the input form this is a check box, checked for Yes and unchecked for No. This used to be a drop down selection box of Yes and No and the same problem was occuring, so I know the problem doesn't relate to the check box.
I have a second reporting form which has multiple combo boxes to filter down results in a subform. In the subform the field correctly displays as Yes and No, however, the filtering combobox for this field has the options 0 and -1.
The combobox is set up as Yes/No, the table is Yes/No and the results are Yes/No. There is no other formatting or input options that can be changed to tell the database this is a Yes/No field.How can I get this combobox to display as Yes/No? It's causing a lot of confusion with users as they are having to select 0 or -1.As a note, I've already tried the following:
-Deleting the combobox and starting again. -Deleting the table and combo box and starting again. -Deleting all tables, queries and forms which use this field and starting again.
None have worked, this seems to be something Access is doing rather than an error in what I've done.The filter form uses this code, which may be the cause:
Code: Option Compare Database Option Explicit Private m_colCombos As Collection Private m_strFilter As String
In my table of assembly numbers where each assembly number has a set of work instructions as a pdf file. I'm wondering if it is possible to display the pdf file as an object within a form..?
I know its possible to open this document as a hyperlink but I want it to be embedded within the form.
Bit of a nightmare, put loads of information into my database, and when i look in the table all information is still there but can not get it to be displayed in my form, what has gone wrong??
I am attempting to place a label on the top of a tabbed form and I am having a problem. Here are the important parts of my database:
tblInstructors InstructorID Autonumber PK RankID FK to tbl Ranks LastName FirstName
tblRanks RankID Autonumber PK Rank
I have a tabbed form with a combo box for RankID and text boxes for FirstName and LastName. Obviously there is more information than this on this form, it is tabbed and I would like a label on top of the form that shows the name and rank of the person's record that is being edited or viewed while the user is on another tab. Normally I would use =[RankID] & "" & [FirstName] & "" & [LastName], however this isn't working since the RankID control is passing the Autonumber from tblRanks instead of the actual rank (yes this is military rank abbreviation). For example I get the number six instead of TSGT. I need to find a way to show the text value instead of the autonumber that represents it.
I have searched to the best of my abilities to find anything on this forum about this as I am sure it has come up before but have been unable to find anything.
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
I have previously posted this on another message board with no responses. I am hoping that someone here can help.
I have a form that has several subforms. The forms are linked Child to Master using a Company Name Contol. In the table where the Company Name is set up, it is not indexed. It is not a primary key. When the EU (in test) enter data with the company name a second time (a second record for the same company), all the information in the first record populates the second record. If any changes are made to the second record, then it is also reflected as changed in the first record. I hope that I am clear in my explanation. What have I done to cause this?
Im having problem with my database, i have managed to set up a calcualtion so it does the sub total thanks to a query, however i want the information to be displayed in a text box on the original form. Is there anyway i can transfer the ammount over to the original forms text box?
I have created a Query to search for clients in my database, the query and the search all work fine, however it would be nice to have the query post the results into a form I have created to display clients data rather than posting the results in a tables view.
I have a combo box with a list of names in, and a table for each of those people.
When one of these names is selected, i want the contents of the corresponding table to display in a form. Easy Enough.
But...how do I get these tables displaying in one form depending on which name is selected, to save me having 7 copies of the same form just with different sources. All the field names are the same.
One solution I thought of is to put all the data in one table, but would really rather keep it separate.
Forgive me for what may sound like a dum question -- Access is completely new to me.
I have my table. I have this displayed as a form.
At the bottom of the form, I have a text box and a command button.
The user enters in a key value. The command button triggers a macro that runs a query.
Now, I'd like the form to display the data returned from the query. How?
I tried creating a new form with its Record Source set to the query. I had the macro close the original form, run the query and open the new form. But before the new form could be opened, Access prompted me for a 'parameter value' (I assume so that the query could be run again).
I searched the archives and Access Help and couldn't quite find the answer to this question, which is no doubt simple.
I have a form showing Projects with an embedded subform showing all the Buildings associated with a given project. In the form footer section of the subform, I would like to display summary information about the buildings in the project being displayed, such as count of buildings, count of residential buildings, count of commercial buildings, and so on, and I would like these summary values to update as users add or change building information.
I know how to write the SQL query to pull this information, but do I use a text box or some other vehicle to do this? Using a text box as a calculated control, I was able to produce the count of buildings using:
= COUNT([UnitID])
To get the count of residential buildings, I need to be able to specify "WHERE bldgtypeID = 'R'"...I can't get the text box to display results of an SQL statement. Can text boxes handle SQL statements?