Topics Search

show all record in form

show all record in form
Views: 27
I have form "FrmLap" but that showing just only one record if I want to see all record what I should do?

I have main form "FrmMain" in that there is subform "SubLap" that is in datasheet view where I can see all record
and when user click in record selector on any record I can open just that specific record in "FrmLap" form but I want to see all record and when "FrmLap" open it should display that record.

suppose in my datasheet there 10 record if I click on record number 5 , I want that form should open with all 10 record but it should display record number 5 and if I click on next recordit should also show me record 6 like that.
Sponsored Links:

More topics

 

Close form and open the next record but have the same record show.

Preview
I have a form that is set In a split form that I use as a search form. It has the same fields that I have on my main form nthe problem that I am having is that once I select the record I find in the split form I want to be ale to close that form and to have the main form show that record.
 

Open a form to show the same record.

Preview
I need some help on creating a macro that will open a form a show a specific record automatically.

I have a form that shows some fields of a record, on double click I need to open another form that shows every filed of that specific record.

I need this to be as simple as possible.
 

Form Refresh stopped working

Preview
In access 2003 I have a simple bound form with a few controls for name and address. The query in the recordset returns only one record so as to reduce network traffic.

I have a procedure that edits the query criteria so as to return just one record and then requeries the form to display the next record. Only problem is I cannot get form.requery to produce any effect.

If you run the query you see the new record while the form still shows the old one. Only when you re-open the form does the new records show. I've tried editing and saving the query manually to make sure that's OK but still no joy.

Is there any way to display the new record without re-opening the form? The query that is the record source of the form is:
 

Split Form Sync up

Preview
I am currently working with a split form in Access 2007. I don't know if it is possible, but when I go to update an existing record, The record on the bottom table area still has the old record values until I click on the record down there.

I know for new records it will show as soon as, changes are made in the upper form area. Is there a way to do this while updating a record
 

How to show new record page upon open split form

Preview
There may have a long listing of record and only some sort of record will be showing first page when split form is open, the page of record may not be at the new record, thus, i need to click the navigate record to "new", in order to insert new record.

So, i may want to set the split form to latest record page (do not in the midle of record) when open form.
 

how to show new record page upon open split form

Preview
There may have a long listing of record and only some sort of record will be showing first page when split form is open, the page of record may not be at the new record, thus, I need to click the navigate record to "new", in order to insert new record.

So, I may want to set the split form to latest record page (do not in the midle of record) when open form.
 

Form - New Record - Don't show existing

Preview
I'm developing a new database and have an opening form (A) with 2 options.
1) select an existing record number on Form (A) and open Form (B) only showing data belonging to that record. This l can achieve ok.

2) click a new record button on Form (A) and open Form (B) with a new record for editing but not showing any existing records and no way to go forward and backward in the record set.

I've tried changing the values in data entry but without success.
 

Message box if yes add a new record in the opening form

Preview
In the main form I have a button.On the click event the Msbox ask you if you want to add a new record or not in the opening form.
If yes I would like that the opening form was opening on a new record instead to show to me the last one. I tried with DoCmd.gotorecord,,acNew. but it doesn't work at (in fatc theopened form shows me the last record instead a new one)
 

Show all recordset in form/subform

Preview
I have a form that is set as single form and the subform is set to datasheet view. I want to show all records instead of just the last record that I created in the embedded Macro. No matter what I do I can't get all records to show. I like to have a new record on top with the rest of the records after.
 

Show all recordset in form/subform

Preview
I have a form that is set as single form and the subform is set to datasheet view. I want to show all records instead of just the last record that I created in the embedded Macro. No matter what I do I can't get all records to show. I like to have a new record on top with the rest of the records after.