Viewing A New Form With More Details Of A Record

Nov 27, 2006

I have got a form with summarised data (of records) on view for people to look at. (this is a continuous form). For each record I would like to have a button that displayed another form with more details on it. So by pressing the button opposite a particular record it would take the Id value of the record and open another form (with more details) at that particular record.

I would be very interested in seeing this done with a macro if possible but beggers can't be choosers!

View Replies


ADVERTISEMENT

Input Fields To Change Record Details On A Form?

Aug 17, 2005

I have a query with the fields employee_name, shiftname, shiftdate and have set it up so that 2 input messages boxes popup allowing the user to input a shiftname (a,b,c) then a shiftdate. from this query i have created a form, but instead of having 2 message boxes popup on screen before the form is loaded is it possible to have 2 input fields on the form (one for shift date & one for shiftname) that allows the user to enter into these fileds whenever they wish provided the form is open and all the records bellow change matching the employee name with the corresponding shiftname & date?, any advice would be great.

View 4 Replies View Related

Record Viewing Within Tables

Apr 29, 2008

I was wondering if there is some setting that can be set such that certain records within a table are not visible when the table is opened, or a form is accessing its records.

It seems from time to time, some records seem to 'disappear' from view?!?

Other than a filter...

Does anyone know how this is possible, and what can be set or specified in order for this to be happening?

Thank you for any enlightenment...

View 2 Replies View Related

Use Previous Fields Record Details

Jan 7, 2008

Dear Guru's,
Happy New Year 2008.

:confused:

I have a task of implementing a fleet fuel consumption. I have made a form where user logs in previous odometer and current odometer reading. I have been challenged to make the system to automatically use previous odometer reading next refuelling. Please assist.

Joseph Njoroge

View 6 Replies View Related

Printing Only One Record Details On Report

Jan 6, 2005

I have a form which is used for data entry for a new record only. I then wish to print some of this record's details on a report, using a command button on the form. At present I cannot filter to get just the current records details on the report - I am getting the report containing all records in the table.

Thank you

View 3 Replies View Related

Updating A Listbox According To The Record You're Viewing

Apr 30, 2005

Hi

I have a database containing 3 tables (for now):
Customers
Orders
Catagories

Now i also have a form with customer information.
In that form is a listbox with a query statement, so that should display wich orders are placed by that customer.

SELECT Orders.[Order-ID], Orders.Description, Orders.Date, Orders.Category FROM Orders WHERE Customer=[Customer-ID];


Now this works for the first costumer record being displayed.
However when i view the next costumer, the listbox still displays the order information from the first customer.

How can i get the listbox to update itself when a diffirent record is viewed?

Thanks in advance

View 4 Replies View Related

Forms :: DLookup And MSGBOX With Record Details

Jun 18, 2015

I've got a form which holds data for employees, fname, lname, ..... and an entered date which defaults to now().

On the before update event, i have the following.

Code:
If DCount("*", "trainingdata", "[Empid]=" & Me!EmpID & _
" And [subjectid]=" & Me!SubjectID & _
" And [trainingdate]=#" & Me!TrainingDate & "#") > 0 Then
MsgBox ("This record already exists")
Cancel = True
Me.Undo
Me.SubjectID.SetFocus
End If
End Sub

With the above vba code, a msgbox pops up if the record combination already exists. What I would like to do is in the same msgbox have the "entered" date display and make the msgbox say something like.

This record already exists and was entered on 6/18/2015, [entered]...

View 5 Replies View Related

Forms :: Editing Record Details Not Allowed

Sep 28, 2014

I have had a form working for ages. It has a main form and eight subforms at the bottom of the form. The main form can be edited in all fields.

I have taken a copy, modified the form added new fields to the main source table and updated the query that feeds the form.

Now (in the copy environment) it won't allow me to edit any of the fields. All of the form control properties are the same as the working model (in the live environment) I can run the query by itself and all is OK

There is obviously some little control that I have inadvertently changed and can't see it.

View 1 Replies View Related

Queries :: Retrieving Record Details With Max Value Date Field

Mar 26, 2013

I am trying to retrieve data for a particular record.

When Project field matches a certain project number I want it to pick the record with the latest date in the date field field to select certain data fields(Owner & Rating) from that record.

Below is my attempt. However the problem is that displays all records with that project number and not just the record with the latest date.

Code:
SELECT [Combined PRB Roadmap].ProjectNumber, Max([Combined PRB Roadmap].DateField) AS MaxOfFDateField, [Combined PRB Roadmap].Owner, [Combined PRB Roadmap].Rating
FROM [Combined PRB Roadmap]
GROUP BY [Combined PRB Roadmap].ProjectNumber, [Combined PRB Roadmap].Owner, [Combined PRB Roadmap].Rating
HAVING ((([Combined PRB Roadmap].ProjectNumber)="NR-4237"));

View 2 Replies View Related

Getting Data From One Table Based On Current Viewing Record

Jul 30, 2007

Hey all,

I am working on converting someones Paradox Database to Access and making some modifications.

I have a table with people in it and they are linked to a number of interests. But i am struggling to create a query so that on each page of the form for the person i can call the interests and display them on the form as a list...

If anyone could point me in the right direction that woul dbe appreciated!

Give me mysql and a bit of php anyday!! hehe

I am using Access 2007 but i have used access before so i should be able to work my way through instructions for 2003.

thanks

RF

View 4 Replies View Related

Add Multiple Record Quickly (details Inside, Void Where Prohibited)

Mar 27, 2008

Situation
My database stores course information for faculty in my department and prints out various reports based on that information.

The 2 mandatory fields in the form are [AcademicYear] and as they create the potential for classes to be added to the curriculum.

Question
Is there a way to add multiple records to the db based on the which year and instructor combinations were use prior?

[I]ex.
2007/2008, prof-a
2007/2008, prof-b
2007/2008, prof-c
2007/2008, prof-d

This represents the 2007/2008 school year where professors a through d taught courses. Is there a way to add records for another academic year so that:

2008/2009, prof-a
2008/2009, prof-b
2008/2009, prof-c
2008/2009, prof-d

appear with just the press of a button?

I don't know if I'm being clear enough. :p

View 1 Replies View Related

Queries :: Double Click On Results In Order To Go To Original Record Or See More Details

Jun 2, 2015

Is it possible to once you have run a query be able to somehow double click on the results in order to either go to original record or see more details? Similar to "show details" in excel?

I have made some queries that are working well however they are specific in nature and once found display a list of results. I have left a field that uniquely identify them and are after a quick way to view the details of the results from the query rather than take the ID# and manually search the original table.

View 8 Replies View Related

Hide The Details Section In Form When Using Split Form View?

May 1, 2012

how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use

Code:

Private Sub Form_Load()
Me.Detail.Visible = False
End Sub

but that just makes the Details section look blank, as oppose to not having it there at all.

have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.

View 3 Replies View Related

Viewing HTML In A Form

Apr 14, 2006

I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.

My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.

Is there a way to get this memo field to display the formatted html text instead?

My access skills are pretty limited, so detailed steps would be appreciated.

View 3 Replies View Related

Form Details Colour Control

Jan 2, 2007

Hi,

I have a couple of identical databases in Access 97, they have lots of forms. My users use the two different versions of this database, but linked to different sets of data depending on what they are doing.

I distinguish between the two versions by making the background colour of the log on and Switchboard forms different. It would be nice if I could cause the background colour of the other forms to match the Switchboard without having to go through and change each form individually.

Can someone please give me a clue as to how this can be done?

I know using Me.Detail.BackColor = RGB(100, 100, 255) would work, but I can't see how to a) get the RGB values from the Switchboard.

Regards,

Bernard D

View 5 Replies View Related

Viewing Form When Database Is Opened

Sep 2, 2005

Hey there, when a user opens my database, I want the form to enter records to automatically open. Can someone plz help with that... thx

View 3 Replies View Related

Viewing A Subform On The Same Screen As A Form

Dec 8, 2005

Hi All,

I have a macro which runs from a form. The macro just opens up a subform. The problem is that the subform gets opened up in a new window. I have changed the property to modal, but this then still opens up the subform in a dialogue box.

Basically I want to be able to view both the form (top half of the screen) and the subform (bottom half of the screen) on the same screen.

Thanks,

Evan

View 4 Replies View Related

Viewing Past Records On A New Form.

Jul 18, 2007

Greetings All,

I'm not sure if this is possible but I've been asked to devise a way of viewing past record entries from an old form on a new form. Our database contains yearly records of student details; each year has a separate form. What my manager would like is that when a student ID number is typed into this year’s form, that old data from previous years is retrieved and placed in the database OR some sort of command button that searches past records for that particular student ID.

Hope that makes sense, I'm completely confused about the whole thing, I'm not sure if it’s even possible...any kind of help will be gratefully received!

View 4 Replies View Related

Open A Fresh Form With Few Details Entered

Feb 20, 2006

Hi there,

I am fairly new to access. I have searched high and low for help on this particular topic. Its something pretty simple, I just don't know exactly how to do it.

Basically, the user will have a client selected from the main form, when they hit the button to go to another form which has details on services done on that client at a specific date, i want the new form to have the clien'ts ID present and a fresh record present in which I can enter the date of visit, what was done, recommendation, etc.

Right now its popping the new form open with the client, but it displays the last record that was typed in that new form. Does anyone have any suggestions or ideas on this?

Thanks

View 5 Replies View Related

Auto Fill Location Details On Form?

Sep 14, 2006

I have stumbled through making a few new forms and tables for my new job, and have done alright so far (even if it takes me forever to do so), but there is one thing that keeps tripping me up. I just cannot figure out how to do it, even by looking at the designs and properties of other tables/forms.

Part of my form requires me to input location details. A table is setup with every City, State and Zipcode for usage on the form. Our old form was designed to auto-fill (is that even the right term?) the City and State fields upon entry of a Zipcode. These are all coming off the same table, and it works on our old form, but I cannot seem to replicate it on the new one.

I have 2 other issues with the form, and they are also both related to this auto-fill/auto-lookup hangup. Another table is set up with employee IDs, and their corresponding Last name, First name and Middle Initial. I'd like to be able to type in the ID and have the next field automatically enter the corresponding name. Similarly, I need to enter certain other data, and I would like the next field to fill in a short description of said data.

Can anyone help me or point me in the right direction? Like I said, I've pretty much made everything else work by learning from the designs of other tables/queries/forms we have, and by trial and error. But this final hitch seems insurmountable.

View 2 Replies View Related

Tables :: Entering ID In Form And Viewing Table With Its Corresponding Name

Dec 1, 2013

I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?

View 4 Replies View Related

Opening Main Form After Viewing A Report

May 19, 2015

I have a button on my main form that allows me to view one of my reports. In order to view the report I have to close my main form. My problem is how do I reopen my main form when I close the report that I have viewed? Some code that would reopen my main form when clicking on the X in the upper right hand corner of the report to close it?

View 13 Replies View Related

Print Mailing Label From Details Displayed On Form

Feb 23, 2005

Hi there,
I have created a form containing contact details for a 100 or so different people/companies. I want to have a button that will allow me to print an address label for the current displayed record (e.g. when I find the company I wish to contact in my form I wish to click [Print Label] and then get this company's address printed on my label).
Have some programming experience but not sure how to go about this in access?

Also as an aside question, is it possible for me to display a list in my form instead of individual records. What I mean is that I would have Name, Address, etc as titles accross the top and then would have a list of all records below these. Then I could click on a record to get more detail and also click on one of the titles to re-order the data by this field?......I know these are pretty big questions but a pointer to somewhere with this info or a sample app doing something similiar would be great. :)

Thanks for your time, regards,
Lavaghman

View 2 Replies View Related

Make MS Access Form Online And Viewing In Browser

Mar 17, 2015

I have developed on ms access project (MS OFFICE 2010) i am trying to make it online so anyone can open Forms through browser.

Does it possible to make ms access Form online and view in browser? if yes then how?

View 4 Replies View Related

Forms :: Change Form Details Based On Two Combo Boxes

Jun 12, 2014

I have two combo boxes in the form header and command buttons in the form detail. The combos allow the user to select either a customer or a prospect, then the command buttons open forms that only show records pertaining to the customer or prospect selected. Combos are "4Custcbo" and "4Proscbo".

1.How do I change which command buttons are available depending on whether the user has selected a customer or a prospect? Do I use two different subforms or is there a better way?

2.How do I hide the other combo box once the user has selected either a customer or a prospect?

View 3 Replies View Related

Forms :: Students Details - Form View Automatically Fill Fields

Oct 25, 2014

I prepared students details in access, but when i look the form view students particulars looks automatically (like name, age, weight and address). But what i need is students details has to come after I enter the name.

View 1 Replies View Related







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