How To Show The Whole Table In A Form ??

Feb 21, 2006

Hi all,
I have a table shown in a form, beside that table a textbox with a button.
How can I multiply the numer entered in that textbox by the the number displayed in the table, and view the result in the same table??
Please help me as soon as possible?

Thanks in advanced and sorry for bothering you.....

Regards,

View Replies


ADVERTISEMENT

Show Table On Form?

Mar 22, 2008

Hoi!Basically, I've got a form:21250And as you can see, in order to select the right loan (Or even see the loan details, Nursery name, book name, author etc) you have to look in to the loan table and then remember the Loan_IDGO back into the delete loan table and select the right loan_ID from the combo box...most people will probably forget before they even get to the delete_loan form :')So, somehow i'd like to insert some kind of 'sub' table at the bottom of my form..which will list all the loans from the loan table..I've tried sub report/sub form.. but it kept updating every time i chose a record in the combobox..(Lets say i selected #5 in my combobox, the table would then only show #5) I don't want to do anything with it, just show the current loansIs there any way to do this?Cheeeeeeèrs!

View 3 Replies View Related

How To Show A Value On A Form Which Is Different To The Table

Jun 27, 2006

I am fairly new to access, as i have been asked to put one together for my work.

In my database I have a table and one form, on the form is text boxes and if needed a 'X' is put in there, how do I change this X to word or sentence in the selected field in the table. I don't how to this or where to start?????????

any help much appreicated

Neal

View 2 Replies View Related

Show First Free ID From Table On My Form.

Nov 9, 2006

Hi there.

I have a very simple dbase.

Table ( ID, name, surname , etc etc)
Form - I use this form to add new records to my table.

On this Form I should be able to see the ID number ( from next blank record)

So let say I have 1002 records on my table.So on my Form ( while I ma openineg to add new recrd) I sholud see ID=1003 ( so I should see next free ID number)

ID= autonumer


Any idea how to create this little button ( window)????

cheers
Dorota

View 1 Replies View Related

Show Results In A Form Or A Table

Nov 20, 2006

Hi,

I have a list-box(Category) and a 'ok' button on the form.

My OK button has the following [Event Procedure]:
Private Sub OK_Click()
Me.Visible = False
DoCmd.RunSQL "Select [Barg Unit],[Medical Option],[Medical Coverage Tier] FROM RetireeCensus Group By [" & Category & "];"
End Sub

First of all, is my syntax correct in the above codes?
Second, what VBScript codes do I need to add in so that when I click the 'OK' button, a report or a table will show the query results from my 'Select' statement?

Thank you.

View 2 Replies View Related

Form Is Calculating But Table Does Not Show Result?

Mar 5, 2005

Hi Experts,

Novice here,

I managed to create a FORM that has fields that calculates basic additions/subtractions formula but for some reason the fields on the TABLE does not update?? Any suggestions?

Thank you,
jola

:confused:

View 8 Replies View Related

Show Total Entries From A Table On A Form

May 14, 2006

hi

i am trying to show the total number of records that are in a table.

there are currently 8 entries in the table 'applications'

now i would like to show this on a tabcontrol in a form. I have been told to use Dcount. I have read about this and tried this on my form but unfortunately its not working.

Can anyone show me an example of how i would do this.

View 1 Replies View Related

Forms :: Show Single Form With All Rows From A Table?

Jul 11, 2015

I'm building a simple access database to be used in a factory. It's pretty much there now, in the sense that it does all it needs to do, but some things feel a little "clunky". One of these things is the page where new products are created.

When a product is created the user has to specify what raw materials it's made up of and that works great, there is a continuous sub form that lets the user just add a row for every raw material. Having it as a continuous form makes sense as there can be lots of rows or just a few, so it's flexible.

Currently though the labour/time on that page works in the same way. But it feels a bit silly as there are only 3 sorts of labour (at least currently, they might add a couple more later). The labour types are..

- Build
- Finishing
- Handling

My question is, how would I go about turning the existing continuous row-by-row subform for labour into a single form that just listed those three types of labour (read from my labour type table)? So that it just shows a row that asks for quantity of each available labour type.

Not all products have all types of labour but it would be fine to write a 0 in the labour table for (for example) Finishing against a product that for example didn't need Finishing Labour. Obviously with the current continuous form approach no row would be written for Finishing if the user didn't select that.

I guess I could hardcode a single form to show the three current types, but ideally it would be flexible, coping with new labour types when the users find they need to add them.

View 5 Replies View Related

Forms :: Show Newly Appended Records In Form Based On Table

Jun 26, 2014

I have an append query that appends records to a table, and I have a form based on that table.

Users will click a button that will run the append query and then open a form for users to fill in remaining empty cells. How can I filter the form to show only the newly appended records?

View 3 Replies View Related

Forms :: Combo Box Query - Form That Searches A Table To Show Certain Criteria

Jul 21, 2014

I have created a form that searches a table to show certain criteria. I am having trouble with a part where the table uses a checkbox and I am trying to use a combo box on the search form to return the results based on is it checked? Yes/No or both. When I test it I keep getting Runtime error 3075 missing operator.

The sql I am using is below and when I try and see where it is going wrong it highlights the line.

Code : Me.Filter = strWhere

Code:
Private Sub cmdFilter_Click()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "#dd/mm/yyyy#"

[Code] .....

View 1 Replies View Related

Forms :: Combobox On Navigation Form Header - Query Table To Show Right Info

Mar 24, 2013

I created a navigation form on which I put a form call [frmAnimal Setup].

I then placed one combo box on the Navigation frm Header. I have bound it to its source and it actually queries the tbl and show the right info. However when I select one, it will not let me.

In addition, [frmanimal setup] will not allow me to select a breed although it does query the tbl and shows the right information.

View 1 Replies View Related

Access 2010 - Getting Form To Show Update Data To A Table When Two Tables Referenced

Jun 27, 2012

I have a form with two tables referenced. I am using the form only to update one of the tables. I am using the other table to pull a reference field. When I add my second table using the query builder, it makes it to where I can't edit/add in my form. I assume its because of the SQL insert statement, but I don't see this statement and can't find where it is to edit it. How to have the form only update one of the tables, while just using the second table as a reference for a field?

View 1 Replies View Related

Search Record In Other Table And Show Result On Current Table

Apr 11, 2012

Actually I have a small form of customer details, that i made in excel, the field name mention below,

Customer Details Table
First Name
Last Name
Contact Detail
Address Detail

Postal Code
Last Purchasing Date
Remark

Now i want to make a search form like this

Search Form

Contact Details

& the result is show which I insert the contact number.......

View 1 Replies View Related

How To Make Values In One Table Automatically Show In Another Table?

May 22, 2007

Hi, I have a problem, I have a table were I list networkservices and their logical ports and I have another table were I list IPaddresses used by different machines. I'm using a multivalued lookupfield to pick which services I'm using for each Ipaddress, and thats working fine, but now I want to make the ports which is listed in another column, to automatically show in it's own column in the IPaddresses table depending on which services I'm choosing for the different IPaddresses. Is this possible?, and if it is how can I make this happen?

View 1 Replies View Related

Show All From Left Table Who Match Right Table?

Mar 22, 2006

The part that I'm a little lost on is the WHERE part:

Table1
-----
UniquePersonNumber
blah
yadda

GruntSounds
-----
ooga
booga
blargh

HowSpeak (1 to many relationship with Table1)
-----
UniqueNumber (lookup to UniquePersonNumber field in Table1)
Sounds (lookup to GruntSounds table)

The part that I'm a little lost on is the WHERE part -- the "matching" portion of the FROM was shortened for brevity:
SELECT blah, yadda
FROM Table1 LEFT JOIN HowSpeak ON "matching UniquePersonNumber"
WHERE
"a person makes both an ooga sound and a booga sound but doesn't make a blargh sound"

I hope that I gave enough information from this fictional project to make it clear how I'm attempting to structure the WHERE in the statement.

View 3 Replies View Related

Modules & VBA :: Button On Form Which Calls Module To Show Calendar Form

Sep 11, 2014

I have a button on a form which calls a module to show a calendar form. The user picks date and time, and saves it. The calendar form closes and adds the date and time to a text box on the initial form.I want to save the record so that the underlying table/query is updated, but it's not working. The record is not saved until the initial form is closed.Here's the form vba...

Code:

Option Compare Database
Option Explicit
Private blnFlag As Boolean, blnSaveIt As Boolean
Private Sub btnDelete_Click()
On Error GoTo Err_btnDelete_Click

[code]...

View 3 Replies View Related

Creating Search Form And Show Results Inside The Form?

Jul 27, 2015

creating a searching form and to show the results inside the form! It's like a Library type searching. u want to search for some type of monument or so and it shows the results, all the info, photos and that!

View 6 Replies View Related

Queries To Show Changes In Table

Feb 13, 2006

Hallo!

I'd like to make querie to show all changes made in database (one table) in some period of past time.

Please help me!

Robi

View 3 Replies View Related

Show Only Last Record From A Table

Feb 18, 2013

my table entries are reciept(primary key),name,reciever,address,amount...i want a query to show recently updated entry in table i.e only last entry from table

View 3 Replies View Related

General :: How To Show Table In A Post

Aug 12, 2014

I've done a YouTube Video, showing 3 different methods of posting your table structure to a forum HERE:- MS Access - Copy Table Structure for Forum

Here is a Google Doc showing the first procedure of the three:- MS Access - Copy Table Structure for Forum (First Method)

Here is a Google Doc showing the Second procedure of the three:- MS Access - Copy Table Values for Forum

Here is a Google Doc showing the Third procedure of the three:- MS Access - Copy Advanced Table Structure for Forum

View 7 Replies View Related

Queries :: Only Show If ID Is Matching In Other Table?

Jun 12, 2015

I have two tables. One with a persons name and ID, DOB, GP etc (TblName) and one with the persons ID and medication they take (TblMedication). I have a query that runs a report. The header is made up of the first table (TblName) and the body of the second table (TblMedication). All works fine but it shows all records from the first table (TblName) regardless of whether they have medication or not so the body shows up blank. I want to run the query with both tables information but only show the persons header if they have medication.

View 14 Replies View Related

Queries :: Show TOP N Records In Table

Jun 15, 2014

I have a table that includes a date/time field. I want to query that table and show all but the TOP N records. Since the number of records will always be changing I cant do it using the BOTTOM N records.

View 2 Replies View Related

Forms :: Show All Items On Table For A Particular Key

Oct 29, 2014

I have a form which when displayed shows all the items on the table (usually 1 or 2) for a particular key.

The following row is part filled in awaiting further input for the rest of the fields of that row.

I have a button (exit) which basically closes the form but it also validates the (potentially) partial field ultimate row. If the user hasn't added any data to the partially filled row then I delete that row with this code.....

If IsNull(Me.Field1) or IsNull(Me.field2) Then
....If Not Me.NewRecord Then
........ DoCmd.SetWarnings False
........ strSQL = "DELETE * FROM [Component Swaps] WHERE [ID] =" & [ID]
........DoCmd.RunSQL strSQL
........ Me.Refresh
........ DoCmd.SetWarnings Trye
.... End If

.... DoCmd.Close
.... Exit Sub
End If

This works. I have copied the exact code into the close event for the form but it seems like in that part of the code the previous row is being picked up.

So for example if I have 2 records on the table I display 3 rows (as 1 is created with partial data) thus

ID.....Prefilled Field......Field1......Field2
1......fromrow1............F1...........F2
2......fromrow2............F11..........F22
3......generatedrow3.....NULL........NULL

If the code goes through the exit event then Me.Field1 and Me.Field2 are Null and the record with the ID=3 gets deleted.

Going through effectively the same code for the close event Me.Field1 = "F11" and Me.Field2 = "F22" and the record doesn't get deleted (ID=2 as well)...

View 6 Replies View Related

Show Different Value From Different Table Based On Existing Value

Nov 11, 2014

I feel like this is one of the standard uses for Access but for the life of me can't get it to work with an existing Table.

Essentially a table with a ton of records is imported via VBA. One of the fields is ObscureCode, for argument sake there are three codes: 001, 002, 003.

Is there any way to say when the ObscureCode cell value = 001, display Code Red. When it's 002, display Code Yellow.

I have tried setting up a relationship but that just clears all the fields in ObscureCode column. Is there a way to do this through VBA? I ask because I imagine when someone imports new data (the table is deleted and re-created with new data) the relationship will break. SO I will need to put in the VBA a way to link them back up.

View 14 Replies View Related

Listbox To Show Contents Of More Than One Fields In Another Table

Jun 23, 2005

I have a field called "Bad Pc Part" which is a listbox. THe problem is I want it to display the contents of 3 other fields from another table.

I created a query for the Bad Pc Part field but the problem is it only displays the information in the first field of the table. It doesnt show the contents of the other columns. I need it to do this.

Please Advise3.

View 1 Replies View Related

Show All Records That Have More Than One Matching In A Related Table

Dec 16, 2005

Hi,
I've been trying to get this for ages now - both in the design view and in sql:

I have 2 tables - one called DrawingsRegister and a related one called DrawingRevisions. Each drawing has one or more drawing revisions. I want a query that will show each drawing (just once) that has more than one revision:


SELECT tblDrawingsRegister.DrawingNum, tblDrawingsRegister.DrawingName, tblDrawingRevisions.DrawingNum

FROM tblDrawingsRegister INNER JOIN tblDrawingRevisions ON tblDrawingsRegister.DrawingNum = tblDrawingRevisions.DrawingNum

WHERE ((Count([tblDrawingRevisions]![DrawingNum])>"0"));

Thanks for your time,
RCurtin.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved