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.
: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???
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.
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
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 created a form and a subform within it, I have managed to populate all the dropdown boxes from the tables I need. but I need to save all the information in putted to a table called bookingstbl and I do not know where to begin?
Basically, its a database for an entertainments agency, I've got a form for 'Artists' which shows the performers on the agencies books. I've tabbed the form so one screen shows the artist details and I want the second screen to show the bookings that the specific artist has.
I've linked to the 'bookings' table on the subform successfully, but I can't figure out how to filter it so it just shows the bookings that the specific artist showed has.
i.e.: I want it so that The Deltatones booking tab ONLY shows the deltatones bookings.
I have tried on different forms using more than a few different methods to make recordsets happen and to no avail. My current reason for needing to use recordsets is because I am loading a form with information from different tables. Instead of using multiple DLookups, opening the recordset only looks for the information once, speeding up the load time on the form.
Code: Dim Rs As Dao.Recordset Set Rs = CurrentDb.OpenRecordset("PreviousTRRetrieval2Query") If Rs.RecordCount > 0 Then ProjectNumber = Rs!ID Agency = Rs!WitnessAgency FileNumber = Rs!FileNumber
That is the start of my code and I keep getting an error, 3061 Too Few Parameters. Expected 1. Now when I run the query I get the results I desire, which is all the information I need at this particular junction. I am using Access 2010. Why I may not be returning any results for my recordset when the PreviousTRRetrival2Query returns results on its own.
I have done this before and can't remember how I did it and I can't fogure out how to do it. I have a form with textboxes that are for displaying info to the users. I want to lock them so that users can not click on them or high light the fields. So basically the user can only click on fields I want them to.
I have a form to record student information. On my student table i have a school I.D that links to the primary key of my school table.
My problem is that in my form, i want to be able to fill in the rest of the fields about the school info based on the I.D chosen.
i.e.
student table: Student id name address school I.D (FK)
School info table: School I.D (PK) school name contact name email address
My form that's linked to the student table needs all the information from the school info table in separate fields but i can only select School I.D in the Control Source Property.
Hi I am in the process of designing a new database using Access 2003 for my company. I have very little knowledge of access and what knowledge I do have is self taught!
The database is to hold medical records about patients that we see (we run a small medical centre)
The information that we put on it will include the patients personal details (name address etc..) and also details about treatments given to them.
Could anyone give me some advice on what type of database sounds best for this type of information. At the moment the database will only be used in the medical centre but will be accessed by more than one person at a time (not sure if that is relevant !
I really would appriciate some advice as some of you guys have helped me before and i value your opinions.
I Have this graph that needs to be run from a combo box selection. it doesnt seem to want to display any information at all. i have attached my database.
My problem is displaying data in many-to-many relationships.
There are three main tables: tblShops, tblOwners and tblMarketingEvents.
These are linked through two junction tables creating two many-to-many relationships:
1) Each Shop may have more than one Owner and each Owner may have more than one Shop. 2) Each Marketing Event may reach more than one Owner and each Owner may be reached by more than one Event.
Now I want to display for each Marketing Event:
1) the data of that event, (tblMarketingEvents) 2) plus the owners reached in that event, (tblOwners) 3) plus all the shops owned by the owners reached in that event. (tblShops)
Preferably, I want to display more than one record at a time without repeating any information.
Is there a way to display the data like this?
I tried a query: it gives the right data but does not display it as I need. It repeats the data from tblMarketingEvents and tblOwners for each shop.
I tried a form with subform: it can only display one record at a time and is hard to work with (printing etc)
I tried a report with grouping levels based on the query: Again, right information, wrong display. I need to group according to the records of the MarketingEvents table and not just according to a single field.
I have created a table with name "Main". It consists of fields ID, Author, Title, Abstract, Page and Published.
I have created a form named "MFORM" with text boxes Author, Title, Abstract, Page and Published,and then I created a search and clear parameters buttons below the text box.
Then I dragged my Search Query into the bottom of my form MFORM and named it as "All Results".
When I click on search then the results are displayed in the new tab instead of bottom of my main form in Search query.
If I enter author name as Mike and then click on search button then results should display all the details related to Mike on the bottom of my form.
All Results [At the Bottom of my page]
Should display all the details related to Mike.
I had attached my database. I just need the search results at the bottom of my main form in stead of displaying in new tab.
I have not developed a database application before. At my work I was seconded to fill in as a team lead for a change management team. We are in a production environment and need to track the progress of product improvements. The current system is very complicated using an enormous Excel spreadsheet and a very bid MSProject schedule. It is very handraulic in the way it is maintained.
Before I started I reviewed who inputs data, who uses the data, and what metrics are reported. I can reduce the amount of data that is recorded by only generating many of the existing Excel fields through calculation run when a report is generated or a chart populated.
I need to track the state of several hundred minor changes through the production run. The reference data I need to store is serial number against production batch. This is fixed data that is not changed, only used as to show the entry point of a change into the production line and which serial numbers the change is applied to.
I have two third-party library programs that allow you to type in an ISBN and the software searches, say Amazon, and grabs particular missing data: author, cover jpg and summary etc, and imports the info to the program. I'd like to replicate this process with Access. If I can type in an author, title or ISBN to Access, I'd like it to search Amazon to gather and input the missing data to my assigned fields. Is this possible? Or am I stuck to typing in the information separately.
I am using Access 2010. I have a database that on a form uses a multiselect listbox. That part works just fine. The list box is for selecting additional people to email. Now I have had no luck with returning just the email address that are in a hidden column (the persons actual name is seen and "selected"). The names come from a separate table and is used as a forgien key. On that same table are the indivuals email addresses. What I did was loop through to get all of the ID numbers I am getting from the list box (the ID numbers are stored in the table that the form is based on).
Once I have all of the ID Numbers I thought that maybe there was a way to retrieve all of the email address associated with the ID Numbers. This is what I have so far. I know that AllQuery returns the first email address from the list box. I just have no idea if the query is returning more than one record, or if it is how to then go to the next record. I have tried a few things with little to no success.
Code: Dim ListItem As Variant Dim AllItems As String Dim AllQuery As String For Each ListItem In Me.EmailAdditionEgineers.ItemsSelected AllItems = AllItems & Me.EmailAdditionEgineers.ItemData(ListItem) & " or " Next ListItem AllItems = Left(AllItems, Len(AllItems) - 3) AllQuery = DLookup("EmailAddress", "AdditionalEmailRequestQuery", "[ID] = " & AllItems) & ";"
I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Any all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs. The only thing I ever see though are files with [.db] as the extension.
If I open the one I have with notepad on a windows machine I see some of the info but some of it is not there and is garbled.
I want to display that query data in a Pie Chart, one chart for each theme with a section of pie for each Type (with the value of the count determining the size). Unfortunately my mind has gone blank. Everything I try does not appear correctly, some queries also require an repeated entry of the parameters but even if I do that it doesn't display correctly. I think I need to write another query to the format:
I'm wanting to create a way of searching through and displaying a large number of pdfs. These will be of different lengths and most will have images embedded in them. Each pdf will be categorised using a variety of fields to enable fairly sophisticated searches. I then want to link this database to a Joomla CMS website.
I downloaded a student template from microsoft and have been able to figure out most of it. I cannot see where to enter the emergency contact information. Also, when I try to see the student and guardian table/list, the guardian list comes up empty even though I entered this information when I entered the student info...
I have a field "Permit_Date_Expired" field automatically is created by adding one year to the "Permit_Date_Issued" field.
when the "Permit_Date_Expired" field exceeds TODAYS() date I want it to automatically change the field "Permit_Holder" to say Expired is this possible?
Using a combo box in the form "product details" I select a "part number " of which the part number and the associated description of the part comes into a fields called "part number " and "part description "
The part number selected then goes into a table called product details
Is it possible that when I select the part number , both the part number and the part description go into the table called product details.
