Showing Last Record

Sep 6, 2004

hi all,

i have question about showing last record in a form. i have 2 table, ra and repair tables. each ra_id is consists of many repair. each repair have time and date stamped. I want to show in tabular view all of the ra records including the last update of each repair per ra_id in a form. When I select some fields in ra + time in repair table, the form showing only records that has repairs ONLY, but not all records. And also display time BUT not the last update, instead showing ALL repairs. can any one help, if i want to show all records plus time but ONLY the last update on the repair. I don't know much vba, so please tell me what to do in macro or expression builder????

View Replies


ADVERTISEMENT

Forms :: Double Click Event - Form Showing 1st Record Instead Of Selected Record

May 8, 2014

I am new to access and I recently encountered a double click issue

My form loads perfectly on double click event but it shows the first record instead of selected record.

My search is based on a PersonID but each PersonID has different WorkID that I wish to display on double click but it always shows the first WorkID instead of my selected record

I have tried changing the filters in the form properties but it still doesn't work for me.

Here's my code:

Private Sub SearchResults_DblClick(Cancel As Integer)
DoCmd.OpenForm "WorkForm", , , "[PersonID]=" & Me.[Searchresults], , acNormal
End Sub

[Searchresults] draws information from my Query

Query information:

PersonID... WorkID... Type......Location
1234..........1............Paint .....Address A
1234..........2............Electric...Address B
1234..........3............Floor..... Address C

View 7 Replies View Related

Second Form Showing Same Record As First?

Mar 22, 2005

Hi,

I have a main form that displays records with a couple of sub forms and it also has a button to open another form which is based on the same table main table but different sub forms.

All I am trying to do is open the second main form by clicking the command button and to automatically display the same main record as shown on the first form before clicking the button.

Sounds simple but I can't find how to do it.

Any ideas appreciated........Stuart

View 1 Replies View Related

Any Way Of Not Showing The Blank Record?

Oct 20, 2004

I've got a text box, populated by a query.
(it looks like a list because it's tabular view)

you can always see the empty record... any way you can stop it showing?

or failing that, I have a dblclick event on all the textboxes. But It doesn't work with the blank record..

this is quite frustrating.. any help please?

View 5 Replies View Related

Showing First And Last Record In A Group

Aug 30, 2005

I have a database in Access 2000 that contains multiple entries for each individual - in this case they are 'visits'. I wish to create a query that shows the first and last visit only on any particular day for each individual.

Can anyone help me?

View 7 Replies View Related

Forms :: Showing More Than One Record

Dec 26, 2013

After setting the source of a from to a table, a form shows a blank record and allows you to input one row of record at a time.But is it possible to have the form show a specific number of blank records, say 6, on each page of the form?I want the user to enter 6 new different records on just 1 page of the form without using the navigation buttons to move between records.

I need to design a database system for students to choose their modules.Each student needs to choose exactly 6 modules and I want the student to input all their 6 choices on 1 page of form, instead of using the navigation buttons to switch to a blank record to input each module.

View 14 Replies View Related

Some Record Not Showing On Query.something Wrong?

Oct 27, 2007

I have make relational table on query, but some record not sohowing on query, although i have the record on table.

for example, i can't see the record with code :
131401.007
541000.00*

is the anything wrong?

thanks

View 3 Replies View Related

Subforms Not Showing If Record Blank

Sep 23, 2005

Have a strange problem. I've created a form with multiple subforms and if there is a record for the subform to display everything looks fine. However, if there is no record for the subform it does not show anything on the screen or if printed.

I would like for the fields on the subforms to show no matter what but I can't figure out why it doing this. I've checked the display parameters and everything is set right.

How do I make the forms show no matter if there is data to display?

Any help is greatly appreciated -

Thanks

View 2 Replies View Related

Change Record Showing In Form

Dec 14, 2005

Hello,

I have another question about ACCESS forms. With VBA, I want to change the record showing when I open a form.
I see there is a member "CurrentRecord" so I tried in the class module

Me.CurrentRecord = 2

I compiles but gives runtime error that is write-protected and cannot be changed. In the ACCESS help I read you could do it but HOW?

What should I do ( I am using ACCESS 97 ) ?!

Thanks in advance

Victor


PS : Is it true that VBA in newer versions of ACCESS has more features/functions etc?

View 7 Replies View Related

Open Form Showing New Record Only

Mar 28, 2006

Hi all,

Is it possible to open a form so that it shows the new record fields only? I want to create a form that only allows the user to enter data and not view any of the records in the table the form is linked to.

Cheers,

Matt

View 1 Replies View Related

#Deleted Showing Up After Deleting Record

Sep 5, 2006

Hello,

I've searched and searched but I cannot find a solution to my problem.

I have a combobox with a list of manufacturers. When you select one, the URL of their website shows up in a text box below.

I have a 'remove' button on the form and when you click it, it removes the manufacturer from the database. This works fine, but '#deleted' gets displayed in the text box. I've tried Me.Refresh, Me.Recalc, and requerying both the form and the field (I'm using Me.requery on the combo box, and it works fine there). I've also tried assigning the text box a blank value, but this doesn't work either.

I have the control source of the text box set to the URL field of the table that serves as the source of the form.

Here is my code:

Dim ManufacturerList As Control
Set ManufacturerList = Forms!frm_EditManufacturerList!cbo_Manufacturers

Dim URLBox As Control
Set URLBox = Forms!frm_EditManufacturerList!URL

Dim networkequipmentdb As DAO.Database
Dim RemoveManufacturer As DAO.Recordset

Set networkequipmentdb = CurrentDb
Set RemoveManufacturer = networkequipmentdb.OpenRecordset("ManufacturerSites")

RemoveManufacturer.Edit
RemoveManufacturer("Manufacturer").Value = ManufacturerList
RemoveManufacturer("DownloadPage").Value = URLBox
RemoveManufacturer.Delete

Me.cbo_Manufacturers = Me.cbo_Manufacturers.ItemData(0)
Me.cbo_Manufacturers.Requery
Me.URL.Requery
Me.Recalc

Me.cbo_Manufacturers.Value = ""
Me.URL = ""

Any help would be appreciated.

Thanks

View 1 Replies View Related

Disable Showing New(empty) Record In A Form??

Apr 29, 2005

Hi,

I am currently working on a database and I'm using a form to view the records. A standard Access behavior is to show an empty record (new record) as the last one. is there a way to disable this "feature". I would like my form to display only the records, which are really filled with data and not show the blank one at the end??

Thanx in advance
Luke

View 3 Replies View Related

Missing Record - 325 In The Table, 324 Showing On The Form???

Sep 19, 2005

I have a database which has one main form linked to a table which has 325 records in it. The problem is when you open the form it says there are only 324 records :confused:
I have gone through the table comparing the records with the form records, I found what I thought was the 'missing' record. But when I did a find on the form I managed to retrieve the record.
Can anyone help as I'm a bit baffled.

Thanks
S

View 6 Replies View Related

Open A New Record Without Showing The Existing Records. THank You

Jun 27, 2006

Hi all,

How to open a fresh form without showing the existing records in the DB.


I.E I've 5 records in the DB. When I click on the add new form command button

Code: DoCmd.GoToRecord , , acNewRec

I want to have a fresh piece of form + I dont want the records which is in the DB to be shown.

Is that possible.

Thank You.

View 1 Replies View Related

Reports :: How To Hide A Record When Yes / No Box Showing False

Jun 23, 2014

How to hide a Record when "False" or a box is unticked on the report.

I've used a Query for the report and figured it would go in the Criteria for the tick box but can't find the code I need (I am sure it is simple)

View 2 Replies View Related

Modules & VBA :: Showing ID Of New Record When Click On Save

Dec 5, 2014

i want to get the id of a new record in a msgbox.this is my code

Code:
Dim MSG As Integer
Dim ExistentID As Long
ExistentID = Nz(DLookup("P_ID", "tbl_Personal_Information", "Full_Name = Forms!frm_New_Person!F_N"), 0)
If ExistentID > 0 Then

[code]....

my problem is with MSG2 when i click save it will save the info but it will not show the message MSG2.if i remove this {" & [P_ID] & "} from the MSG2 it will open.if it's existed she don't open and if i press again it will show the MSG1

View 8 Replies View Related

Reports :: Subform Only Showing Last Group Record

Feb 25, 2014

I have one query that the main form is based on and another query the subform is based on.

I linked the subform to the main form by a common field "Branch"

My main form displays Grouped Employee overhead totals based on Branch

Example:
Branch 1 Employee overhead cost...........15,000.00
Branch 2 Employee overhead cost...........25,000.00

The subform displays grouped branch expense overhead totals based on Branch

Example:
Branch 1 Branch expense...........125,000.00
Branch 2 Branch expense...........155,000.00

I am trying to display both the employee overhead total and branch expense in the Branch Header of the mainform.

Example:
Branch 1 Employee Overhead...15,000.00 Branch Expense...125,000.00
Branch 2 Employee Overhead...25,000.00 Branch Expense...155,000.00

I tried using an IIF statement in a text box in the mainform branch header section to return the branch expense if subform branch = mainform branch.......When I run the report I get all of the Employee overhead but only the last record for Branch 2 branch expense displays.

Example:
Branch 1 Employee Overhead..15,000.00
Branch 2 Employee Overhead..25,000.00 Branch Expense...155,000.00

Then, I tried just putting a text box in the main branch header subreportName.Report.TotalField

When I run the report it returns all employee overhead with the Branch 2 total for every branch in the mainform...

Example:
Branch 1 Employee Overhead..15,000.00 Branch Expense...155,000.00
Branch 2 Employee Overhead..25,000.00 Branch Expense...155,000.00

View 4 Replies View Related

Forms :: Current Record Not Showing Up On Reports?

Jul 11, 2013

I have a form with command buttons to preview reports. For some reason only the first record shows up on the reports and not the current record.

View 10 Replies View Related

Showing User Who Modified Record On Form View

Dec 29, 2004

I used a macro to record the date and time the current record was modified and show that information on a form - the information on how I did that is here: http://office.microsoft.com/en-us/a...0345351033.aspx

That works wonderfully, however I would like to add to this the user that modified the record.

Is there a macro code for this??

I tried setting the Item to read [UserModified] and the Expression to be User() however that did not work.

Any help would be greatly appreciated...

thanks.

View 2 Replies View Related

Forms :: Selecting Record From Subform And Showing In Mainform?

Jul 28, 2014

My Database is really simple, it contains 1 table (called Querys) and a form called Dashboard.

In my main form (Dashboard) I have inserted a sub form which shows all the records in my table (called Querys) when I use my main form and add a record this sub table can then be refreshed and it shows all my records.

This part is fine,What I would like to do is be able to select a record in my sub form and it show the record data in my main form. This would really speed up the navigation process as the database gets bigger.

View 3 Replies View Related

Reports :: Open A Report But Only Showing The Result Of One Record In A Sub Form?

Jun 21, 2013

i want to open a report but only showing the result of one record in a sub form,

i have a field that is on all rows of the subform,[click to run] and what i want the user to be able to do is double click on this field and it will open the report with only the record information for that row displayed.

View 1 Replies View Related

Reports :: Showing All Detail Records If One Record In Query Meets Criteria

Mar 5, 2013

I am trying to create a report which basically includes the following:

Company, Wages, Contribution.

Each company reports wages for each employee every month. Then they also contribute to a general fund based on a percentage of the wages. For instance:

Company---Employee---Wages---Contribution
CompanyA---EmployeeA---$4000---$40
CompanyA---EmployeeB---$3800---$38
CompanyA---EmployeeC---$3800---$38
CompanyB---EmployeeA---$4200---$42
CompanyB---EmployeeB---$4200---$42

...and so on.

Each employee is required to contribute, in this example, 1% of gross wages to the general fund.

On occasion, the company does not pay in the required 1% of gross, say, for CompanyA EmployeeA, they only paid in $35.

Here is what I need to do. If any contribution amount for any employee is incorrect, I want to display all the records for that company, not just the incorrect ones. The report is grouped by Company, and may contain dozens of companies.

I am already passing a number of criteria to the report using a filter, including the date range and other fields which are informational.

View 6 Replies View Related

Access 2007 DB Shared Through Network Folder Showing Record Lock

Feb 6, 2013

I have an Access DB shared through a network folder. It is currently frozen and showing a record lock, however, none of the users have it open. Is there a way to kill the lock so I can restore it?

View 5 Replies View Related

Field Value Is There But Not Showing...

Apr 19, 2006

I have an unbound field that counts the number of records (=count(emplnumber)). When I open the form the value in the field is not there, if I click on the field the value appears.
It's almost like the field is being highlighted by the cursor and covering up the contents, but the cursor has it's focus set to another field.
Oh, the field is on the form footer if that matters.

Anyone know what I am talking about?

Thank you

View 6 Replies View Related

Menu BAr Not Showing

Jan 3, 2006

:confused: hi ,,,
i have this Microsoft Application and i have unchecked the check box (Allow full menus ) in the starup ... So when ever i run the application i only get
the menu bars : File, Window, Help, AdobePDF

how can i get the other menu bars ?


any suggestions

thankx:o

View 6 Replies View Related

Showing Variances

May 5, 2006

Hi All,

I have 2 sets of fields, 1 for this week and 1 for last week.
I would like to change the background colour of this weeks fields to show either an increase (green) or a decrease (red) from last weeks figures.

Can anyone help me?

Thanks

Twin

View 2 Replies View Related







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