Continuous Form Select Record


Hi there.

Am having a problem that I can't seem to work out.

I have a continous form that displays records based on the output of a query. I want to have a button by each record that once clicked opens up the full record in a new form.

I have looked on the web and most people say use the button wizard. When I do this it cannot seem to find any records on the first form to select to match with the second form (record ID). They are both bound to the same query. Any ideas?


Sponsored Links:



I have a continuous form that opens all of the records for a specific user on a specific date and displays them in a continuous form. Each record requires an approval check box be marked before it can be processed for reporting. I want the approver to be able to click a button and mark all of the records displayed at one time. Currently my button will only mark the current record. How to I select all of the records?




I would like to be able to alter the color of the currently selected record in a continuous form.

Has anyone done this before or can offer any suggestions?




I am new to Access and hope someone can help with this issue.

I have a continuous form that has a query as it's record source. This form is only for viewing existing records, not entering a new record. All the records are displayed correctly, except the last record on the form is a blank record. Is there a way to prevent the blank record?

Thanks for your help.

Bill Echert




A2K

I have a form set to continuous forms.

I have only one record/line displayed and can scroll up and down etc etc.

I've tried designed the forms so I can see multiple rows but everything I seem to do doesn't work.

I know its something to do with the form properties becuase I fluked it last time.

Can anyone help, please?

Thanks




Hi All,

I have a continuous form on my access app.
I use one of the forms as a continuous form.
Every record has a checkbox and i need that if the user will check it - i need to enabledisable the relavant field in this record only to be enabled.
I'm familiar with reffering the field somethink like:
Me.field.enable = true
But in this case it enables ALL the fields on the form and not only the matching field in the record i've checked the checkbox.

How can i reffer only the relavant field in the checked record ?

Thanks !




Hello,
I have form which the Default View is set as Continuous Forms.
Its Record Source comes From tblBatchAmt

tblBatchAmt
Company_Id
Check_No
Amount

In the form, I added the three fields from tblBatchAmt, alongside of it is a combo box called cboQuickSearchById which the RowSource comes from a tblCompanyInformation

tblCompanyInformation
Reference_Id
Company_Id
Company_Name

Row Source:

	Code:
	SELECT tblCompanyInformation.Company_Id, tblCompanyInformation.Company_Name FROM tblCompanyInformation ORDER BY
tblCompanyInformation.Company_Id, tblCompanyInformation.Company_Name;

Bound Column = 1

So what I am doing is displaying
cboQuickSearchById | Company_Id | Check_No | Amt
(txtId) (txtCheckNo) (txtAmount)

When I click on the cboQuickSearchById and search for an ID number, after update, it automatically populates my Company_Id field, this works great. But after I use the combo box, it creates another record below with the same row, but the combo box, reflects the same value as the first combo box. If I change either combo box, all other combo boxes change too. I want the combo boxes to be independent of each other for each record.

What am I doing wrong?

Thanks.




Access 2010 accdb.
A continuous Form has records of Loans Issued on a Date.
It includes how the funds were issued and this works fine where One transfer was done.
Where there may be two or more funds transfer records, it would be handy to have a 2nd or third row in the form (and report) that displayed the additional data. This would be like a sub form to a continuous form.

Is there any way to achieve this ??

If there was just one Loan Issued each day then a Main Form and numerous Sub Forms would achieve the result but with multiply loans then ??

This would be like a 2nd line of description in a price list.

Appreciate any advice




I'm using a continuous form as a subform and wish to disable all fields of each record, other than the new record form.

Does anyone know if achieving this is practical, or indeed possible? And if it is, how to achieve the effect?

Update:
I've tried using a macro to set the property of the control that I want to disable, but can't get the macro to recognize the form "Can't find the form .... specified in a macro...". Although this does not occur when I open the subform by itself (only when it is open by the super-form) - and my setting technique doesn't work yet....

Tim.




Let me preface this with I know just enough VB to be dangerous
I'm working with a form that has a subform. The subform is formatted to display multiple records from a query in a continuous form. Each record has several yes/no checkboxes. I want to disable several of the checkboxes in a record when one particular checkbox is "true". I put this simple bit of code in the "on click" event behind the checkbox that I want to trigger the event.
If [workdaycheck] = true then
[3pct].enabled = false
else
[3pct].enabled = true
end if
Simple but.........this effects ALL of the records (disables all of the [3pct] checkboxes) in the continous form, not just the record that the [workdaycheck] was made true. How can I isolate the action to a single record and not all the records in the subform? Thanks!




I have a continuous form, which is used as a sub form in a main form. How can i put some code on a control which will work only, if the focus is on the last record (the event i would like to use is onKeyDown). I have tried using:

if Me.CurrentRecord = acLast Then ....

but to no avail.

Any suggestions please ?

Thank You




for search form, i have textbox as a user input, n list box to filter the record..
what i really want is to double click the highlighted record to display full record which in other form.. here is the code

Code: Dim stDocName As String Dim stLinkCriteria As String stDocName = "USER" stLinkCriteria = "[Service Tag]=" & Me![search] DoCmd.OpenForm stDocName, , , stLinkCriteria however, the code run to be error at stLinkCriteria..
i dont know how to configure the problem since i just copied the code from my research.
or do i have another way so i can display the selected record from listbox.. anyone pls help me.




I have a continuous form showing records sorted by date.

I want to add a calculated field to each record to show the percentage change of a value from the previous record.

How can I do this?

Thanks a million :-)

Paul




Hi,

This is an intriguing one- and never thouroughly solved on this forum? I have a continuous form with records PK- [item_ID]. when this [item_ID] = "hd" it needs to make visible a yes/no control: [new] .....

BUT....

just on that one record on the continuos form, not on all of them!

I can make the control visible on this event on all the records- but I've heard it is impossible for access to allow this functionality?

I believe in Access!! Can you keep my hope alive??

All the best

S




Hi there,
I have been looking for some way to loop through the selected records of a continuous form. (I know it is easier with multiselect listbox but I didn't find a way to wrap the text there, which I need, since the display text is long and formatted.) Could somebody help me with this one?

Many thanks.
SWK




How to Count selected record on Continuous Forms before delete this records?
Thank you
Mike




Hi All,

Is it possible to use the record selectors on a continuous form to do anything useful? I have a continuous form as a subform which displays a list of customer contracts and some related data and it would be nice if I could select multiple records and print them.

However, I have noticed that although you can select multiple records, as soon as you press a command button the selection changes to a single record.

Is this fixed behaviour, or does anyone know if it can be altered?

Thanks
Emilio




I have a continuous form, based on a query that displays all items for a certain location.
At the moment I can change all the records to another location, but I would also like to give the users the option to select various records if they require only some to be moved to another location.

I had this working before but seem to have lost it.

Great if you can help

Thanks




We all know about the limitations of the continuous forms in Access. Selecting multiple non-contiguous records is only one of them. However this must be possible since Acces itself offers this possibility when you are in the design view of a Table. There you can easily select (and highlight) multiple records randomly.
My question is: is there anyone who as a tool or an add-in who provide those functionalities or maybe an entierly new kind of form... any help is welcome as I found very few things on the net.
You can easily contact me by mail gulio2000@hotmail.com.

Thanks

Jules




I have a continuous form, and I would like to programatically find and select one of the records with VBA if it meets certain conditions. How would I do this? Basically trying to control the record selector arrow with VBA.