Access :: Displaying Information

Displaying Information In A Form

Jul 19, 2006

: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???

all help would be much appreciated! :)

View 1 Replies View Related

Query Displaying Repetitious Information

Jul 6, 2005

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.

View 3 Replies View Related

General :: Form Not Displaying Information

Dec 11, 2012

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.

View 14 Replies View Related

Forms :: Displaying Information Based On Selection

May 21, 2013

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.

View 1 Replies View Related

Displaying One To Many To Many

Feb 21, 2007

Hello!

I have been struggling with this problem for a while and I'm so deep into it I can't look at it clearly anymore. I hope someone can give me some advice.

I'm trying to set up an orders database, but instead of one "product" I have a service with many specifications. One service part can have many kinds of inspections, which in turn have many inspection criteria.

That part seems okay to me, I guess. There's a one to many relationship between services and inspections, and a one to many between inspections and criteria. The problem is displaying that in a form in a way that's not confusing to the users - I can't put all that info in one line, and I can't put subforms in continuous forms, the best I can come up with is to have separate subforms that display the inspection types when the part number is selected and the inspection criteria when the types are selected. The users I tested it on are totally confused about it. What's the best way to go about displaying it?

I secretly just want it to look like this!

PartNumber Service Criteria Price
1001 Gauging (for) Length $100000!
(for) Diameter
Sorting (for) Rust
2222 Sorting (for) Rust $10

Maybe that's just as confusing. A fresh perspective would help.

This forum has been such a wonderful resource to me and I've learned a lot. I feel kind of embarrassed posting because I know my questions are access-ignorant, but I'm really having trouble figuring this one out on my own. Thanks for any ideas.

View 2 Replies View Related

Displaying A .PDF File

Mar 27, 2007

I am having a proble displaying a .pdf file on a command button action.

Here is the part of my code that calls up the file:

Dim StrProg As String
Dim StrFile As String

StrProg = "C:Program FilesAdobeAcrobat 7.0Reader.exe"
StrFile = "C:Program FilesPolaris Medical Chart Ver3.3example.pdf"

Shell StrProg & StrFile, vbNormalFocus

Exit Sub

I get a file not found error. Any thoughts??

Thanks

View 3 Replies View Related

Displaying Percentages

Jan 13, 2008

This is probably simple but it's something I haven't had to do before.

I have a main table.
I have a filter query based on this table.
I have a report, based on the query, which displays the total number of records in the query.
In the same report, I would like to display this total as a number (already done, obviously) and also as a percentage of the total number of records in the main table.

How would I go about this?

View 1 Replies View Related

Displaying Data

Sep 3, 2006

Can't figure this one out. I am trying to get my query to show me which company's have not sent a supplier any money during a certain period.

However if I have the following data

abc company
1/10/02 �5
1/12/02 �10

an i search for any company who has not sent any money between 2/10/2 and 1/11/02 abc company does not show up because there is no data between these dates. If I had a record 2/11/02 �0 it shows up. So what criteria or query can I use to show this up?

many thanks

View 4 Replies View Related

Displaying QBF In A Form

Jun 9, 2007

Hi,

I'm using Access 2000.

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.

Thank you in advance.

View 1 Replies View Related

Displaying All Of The Same Value From Both Tables?

Aug 22, 2007

Hi, sorry if this has been covered before, I am a new guy around here.

I have two tables in a select query, both with a code field and a monetary value field. The codes are linked. This query is to show the variances in the values of each table as they are meant to have identical codes and values. However, each table has a small handful of codes that are not in the other, but all the query outputs is the variances for codes that are in "both" tables. I realise you can do one way relationships so that you can display all from one table and only those matching from another. However I need the query to show "all" the codes from both tables, and the value difference.

Any advice on going about this? Would be much appreciated! Thanks. :)

View 1 Replies View Related

0 Or Rejects Not Displaying

Jan 10, 2008

My query tallys the no of reject by plant and displays in a report, and this works great, but now it's a new year, only 3 plants have rejects (which is really a good thing), I need a 0 to display for the other 2 plants but don't know if this can be done, any ideas?

Plant (5 possible) group by;
Expression: Counts # of Rejects
by DateReceived 1/1/08 to 12/31/08

View 10 Replies View Related

Displaying Records

Feb 21, 2005

I have 500 Records in my Software Table, and I would like to display only those records that match my criteria that I place in my text box on my form called Software Name. So Once I have entered the software type in my text box, then I would like to display those records at the bottom of the screen as the selected records.... Any ideas??My table is called, Software, which contains Software Type, Software Name, Serial Id, Comments, Inventory Number, Version , Key and Company... I have a text box that is called txtSoftware, Which searches the databse and display the information in a list box called, lstResult, I would like to however, have the option, display in the list box but also display those records on the bottom of my form as it will look like in design view of my table. I have no idea how to ever start the idea ....

View 1 Replies View Related

Need Some Help On Displaying Picture

Sep 14, 2005

I have set up a bound object frame on a form, everything works good, only problem i have is the picture doesn't display but the name of the picture does, ie...picture.jpg. if i click on this the picture is displayed in microsoft office picture manager, I think I'm close..maybe just a shove away..

Please help if you can,,
Thanks,
Jerry

View 2 Replies View Related

Displaying PDF In Form

Mar 16, 2006

Hi -

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).

Thanks for any assistance,

- gromit

View 2 Replies View Related

Displaying Only 1 Record

Jun 19, 2006

Hi guys

I have a problem. In form view, if you use the mouse wheel to scroll down, you switch to the next record. Is there a way I can disable this? Even if I switch the RecordSelectors and NavigationButtons properties in the Form Selector to "No", it still goes to the next record as soon as you scroll down with the mouse wheel. I want the Form to scroll down if you use the mouse wheel, not go to the next record as it does now.

Please help. I don't know what to do. Thank you in advance.
kruger101

View 2 Replies View Related

Displaying The & Sign

Aug 23, 2006

Hi I would like to know if it is possible to display the & sign. I need to beable to use this both in form titles and on command buttons. When ik type it in as a caption it is displayed but as soon as I come out of edit mode I am left with a _ in place of the &

any help would be great. Thanks Paul Evans

View 2 Replies View Related

Not Displaying The Record

Aug 24, 2006

I have the following code on the field date on a subform:
Private Sub TripDate_DblClick(Cancel As Integer)
On Error GoTo Err_DblClick_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Trip NV"

stLinkCriteria = "[TripDate]=" & "#" & Me![TripDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_DblClick_Click:
Exit Sub

Err_DblClick_Click:
MsgBox Err.Description
Resume Exit_DblClick_Click
End Sub

When I doubleclick on certain records on the subform it will open the form TRIP NV diplaying me the linked record, on other records it will open the form TRIP NV but a blank form with no records displayed!
Why is this happening?
Marco

View 1 Replies View Related

Displaying Records

Nov 2, 2006

This is probably a very basic question, but I'm going to ask it anyway.

I have two tables linked together, in a one to many relationship (a supervisor table, and an employee table). Each supervisor can have many employees that report to them. I then set up a forum to enter new employees as they come into the corporation, and need to referance which supervisor they report to, I have a drop down box that I want to display SupervisorLastName, SupervisorFirstName (for example, Williams, George) but is only displaying the SupervisorID (for example 60).

How can I make the forum display Williams, George instead of 60?

Thanks in advance for your help.

View 2 Replies View Related

Data Not Displaying

Nov 7, 2006

Hello All,

I recently added a couple cascading combo boxes to one of my forms and now the data from the underlying table that has already been entered does not show up unless I go in and reselect the options.

Anyone have any ideas on how to fix this?

Thanks,

View 6 Replies View Related

Displaying One Value Or The Other In A Query

Oct 4, 2004

In a Query, how can I display in one column a value that can come from 2 different fields based on a selection.

Say I have two date fields (Date1 & Date2) they can both be blank, or one or both of them could have a real value. To make it simple here is the logic I want to employ.
If Date2 > " " display Date2, otherwise display Date1. I want the value to appear in the same column. Can this be done in a query or must it be done in a report?
Thanks!

View 2 Replies View Related

Only Displaying Until Date

Oct 14, 2004

Hi,

I am creating an access DB that has job listings
and displays the DB online.

I am creating tables rows for 'BeginListing' and 'Endlisitng'
etc that are stored as a Date

How do I get the asp/vbscript to check the date 'EndListing'
of the entry and to stop displaying it when the date is
later than today (so it takes them offline when the date is
expired)?

My script is like this and loops through each record set displaying the
contents:

'Loop through the recordset
Do While not rsJobPostings.EOF

'Write the HTML to display the current record in the recordset
Response.Write ("<div class='sitetext'><br> Job Number: ")
Response.Write (rsJobPostings("Job_Number"))
Response.Write ("<br>Job Heading: <b>")
Response.Write (rsJobPostings("Job_Heading"))
Response.Write ("<br>")
Response.Write (rsJobPostings("ListingEnds")) .... you get the idea.

Cheers thanks.

View 1 Replies View Related

Displaying The Remainder

Oct 16, 2004

I am a new member and feel very glad when find out about this forum. My problem is:
How to make a field in a query displaying the remainder of another field divided by 6. The user will key in a number in the 1st field and I want another field to display the remainder of the number when divided by 6. Thanks.

View 1 Replies View Related

After Displaying A Window...

Jul 6, 2005

Hello all you experts and thanks in advance for your help.

I want to issue a message box after a window (a form) is displayed. I have attached it (in VBA code) to the onOpen event but the message displays before the window is displayed. So I tried, OnCurrent, then onLoad, but in each case the event triggers the message box before the window is displayed.

Is there an event which triggers AFTER the display of the window. Note that I don't want the message box displayed several times so onGotFocus is out.

Many thanks in advance,

Phillip

View 2 Replies View Related

Too Much Information

Jan 4, 2006

I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.

View 1 Replies View Related

Getting All DB Information

Jul 12, 2006

I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.

This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.

Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.

Thanx,

Tim

View 2 Replies View Related