Delete Record On Continuous Form
Mar 2, 2006I need to have a button on my continuous form that deletes the corresponding record... I used the wizard to create the button, but it doesn't seem to work...
Any Ideas?
ADVERTISEMENT
Delete Command Button - Continuous Form
Oct 23, 2006Good Evening,
I wonder if anyone could help me please.........
I have found Ghudsons attached ‘Browsing2’ example to be of enormous
benefit/use to me when I have been creating various Databases, however I was wondering whether Ghudson or any other kind person(s) would either show or point me in the right direction as to how to create a ‘Delete’ facility which is very similar to the ‘Open’ command button on the continuous form.
I have attempted to adapt the enclosed 'coding' to see if it will come up with the result that I want, but unfortunately I cannot!
Attachment kind courtesy of Ghudson
http://www.access-programmers.co.uk/forums/showthread.php?t=97787&highlight=browsing
Your help or assistance in this matter would be very welcome...........
Best Regards
CarolW
General :: Delete Query From Continuous Form
Nov 9, 2012I have a continuous form with a button(delete). on click event I want to delete a record on another table. I though about doing this via a delete query. The sql is below:
PHP Code:
DELETE tblClientCourse.OrdersItemsID, tblClientCourse.ClientCourseIDFROM tblClientCourseWHERE (((tblClientCourse.OrdersItemsID)=[Forms]![frmDeparturesPaymentScreen-ItemListSubform]![OrdersItemsID]));
The only thing that is exactly the same between both records is the OrdersItemsID.
i thought that it was simple. when i run the query it would delete the record but it doesn't.
Modules & VBA :: Highlight Record On Click Record Selector In Continuous Form
Oct 23, 2014I would like to highlight record when user will click Record Selector in the continuous form. How to do it?
View 1 Replies View RelatedForms :: How To Get A Specific Record To Be First Record Of Continuous Form
Nov 8, 2013I have a continuous form for which the recordsource is a query that retrieves dates from 10 days in the past to 10 days in the present. I want the record with today's date to be at the top of the form. The record with the oldest date is always on top. Is this a scrolling issue? How can I get the record with today's date to appear on top?
View 5 Replies View RelatedContinuous Form Last Record
Mar 22, 2005I 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
New Record At Top Of Continuous Form
Mar 2, 2006Hi,
This is probably a stupid question and I expect the answer is no but here goes.
I have a continuous subform showing records sorted to show the latest first.
I would like the empty new record to be sitting at the top of the list rather than the bottom, so my users don't need to scroll down to enter a new record.
Is this possible, and if so what is the setting I need to use.
thanks
Sue
Search For Particular Record On Continuous Form
May 16, 2005I have a continuous form based on a query. In the form footer I have placed a text box and a command button. One of the text boxes on the continuous form is bound to the VIN field in the query. I would like the user to be able to place the last 8 digits of a particular VIN in the text box in the footer and click the command button to bring that particular record to the top.....
View 5 Replies View RelatedEmpty Record Appear First - Continuous Form
Jul 23, 2005In a continuous form, I know you can groupby in descending order. If you do this on a date field, then the newest record appears at the top. How do I make the blank record for entering new records appear at the top of the form instead of the bottom. Thank you.
View 1 Replies View RelatedHow To Highlight A Record In A Continuous Form
Nov 11, 2005Hello all,
This is my first post. I have been trying to find a solution for the following issue. I have a Continuous form and I would like to highlight the record by clicking on any of the fields in that record, tried everything with no luck, any ideas?
Thank you
Continuous Form Record Sorting
Mar 17, 2005I doubt this is possible, but I'll see if anyone out there knows how to do this...
so i have labor entries that consist of a laborID (the guy doing the labor) the serviceID (service being performed) and all the payment info (peripheral, not really important). what i would like to do is add a field, Area, that describes where on the house the labor is being performed, ie the roof, the master bedroom, the kitchen, etc...
is there any way to sort these using continuous forms (maybe 2 continuous forms?) kind of like in a report where it goes, for instance (ignore periods, for spacing only):
Area: Roof
.....Tearoff yadda yadda
.....Replace yadda yadda
Area: Kitchen
.....Redo electrical yadda yadda
.....Replace toaster etc etc
.....Fix plumbing etc etc
Area: Bathroom..... etc
thanks for any ideas...i know this is ridiculous, but i figured i'd give it a shot
Forms :: Continuous Form With Command Button On Each Record To Open Another Form
Jul 30, 2014I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.
At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.
continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"
pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"
This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):
1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid
2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid
3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria
4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub
Locking Fields For One Record On A Continuous Form
Jul 22, 2005How can i apply the following code to the immediate record in my subform. I would like when the assigned check box value = true, then the fields for that record become locked.
Ive written the following code to an onclick event for a check box labeled "assigned" on my form, the problem is it executes on all the records in my form.
Q. How do i apply the code to only the immediate record?
Private Sub Assigned_Click()
If Me.Assigned.Value = True Then
Me.Serial_Number.Enabled = False
Me.Component_Group_ID.Enabled = False
Me.TypeID.Enabled = False
Me.Description.Enabled = False
Me.Status.Enabled = False
Else
Me.Serial_Number.Enabled = True
Me.Component_Group_ID.Enabled = True
Me.TypeID.Enabled = True
Me.Description.Enabled = True
Me.Status.Enabled = True
End If
End Sub
Correct Picture To Each Record In Continuous Form
Jun 15, 2006Hi Good-Morning (its morning here in Jamaica) (Whatever time of day it is where ever it is that you great minds are in this beautiful world we live)...
I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record...
I now want to create a Continuous Form with the correct image displayed for each row or eachrecord///
The problem is all of the images are displaying the same picture, but i want them to show their correct pictures... I used an on current event which i guess is why tha is happening cause all the pictures change when different record selectors are clicked...
Please advise how i could get around this...
I looked at the Northwind database, but that database uses an OLE object, I would like to use the filePath field that i have in my database...
Any Ideas? Thanks in Advance
Use Specific Record In Continuous Form For Event?
Oct 10, 2006Hello,
I have a continuous subform that shows 2 records consisting of a text field and a yes/no field.
I was wondering if it was possible to take the state of one particular of the yes/no fields to trigger an event. Specifically, when one of the questions is checked [true] then I would like to make visible another subform on the main form.
Can this be done, and if so, how, or should I just leave my subform visible at all times?
Thank you.
Queries :: Combobox In Continuous Form Record
Dec 2, 2014A continuous form with fields Operation bounded integer, LibelBx unbounded combobox string with two columns as Sorter (Int), Phrase(str).
A table TargetTbl with field Operation(Int). A table TextArrayTbl with fields Phrase(str), Sorter(Int).
Relationship between TargetTbl and TextArrayTbl is one to many joined on Operation = Sorter.
I am trying to display the form. RecordSource = TargetTbl. LibelBx.RowSource = TextArrayTblQy.
The idea is to display every record from TargetTbl with Operation equal to Sorter from TextArrayTbl. The LibelBx combobox should display the Sorter and Phrase.
The queries are:
Code:
TextArrayTblQy = "SELECT TargetTbl.Booking, TargetTbl.Operation, TargetTbl.CodeBilan, TargetTbl.Debit, TargetTbl.Credit, TargetTbl.Total, TextArrayTbl.Sorter, TextArrayTbl.Phrase
FROM TargetTbl INNER JOIN TextArrayTbl ON TargetTbl.[Operation] = TextArrayTbl.[Sorter];"
Code:
TextArrayTblQy = "SELECT TargetTblQuery.Sorter, TargetTblQuery.Phrase
FROM TargetTblQuery, TextArrayTbl, TargetTbl
WHERE (([TargetTblQuery].[Sorter]=[TargetTbl].[Operation]));"
Code:
TargetTblQuery = "SELECT TextArrayTbl.Sorter, TextArrayTbl.Phrase
FROM TargetTbl, TextArrayTbl
WHERE (((TextArrayTbl.Sorter)=[TargetTbl].[Operation]));"
I managed to get the TexArrayTbl displayed in LibelBx combobox, but it displays all the records whereas I want it to display only the ones with Sorter = Operation.
General :: Continuous Form With Textbox Record?
May 15, 2014I'm building a database to control projects of new products for a company, the flow is easy:
-Step 1: Record the general information in a main table (db_master_info) (i.e. project name, description, date of launch, etc.)
- Step 2: Record the product codes in a detail table (db_units) (i.e. product codes and quantities)
-Step 3: Record monthly information like, production and sales forecast in the detail table (db_units)
-Step 4: Build a monthly stock equation(production minus sales forecast) and record a comment, in a comment table (db_comments), about the results.
The steps 1,2,3 and 4 I did successfully!
The step 5, I'm unable to think outside of the box!
I drew a sketch (form_stock and comments.jpg attached) that might be a possible solution...
Use a continuous subform with a unbound textbox with VBA to load record and edit/update???
How do I do this?
Modules & VBA :: Go To Last Record In Continuous Form And Highlight It?
Sep 8, 2014I have a log of items I currently inventory. When you click on an item, it opens another form with a sub-form that lists the history of changes for said item in a continuous form display.
What I want to be able to do is when that form is opened, the sub-form will highlight the last entry (either bold it, or change the background).
Forms :: Selecting Only One Record In Continuous Form?
Nov 13, 2013I wish having only one record display in a continuous form, after an "On Click" event. The database in which this question lies is attached.
On opening, the user first interacts with Table 1 (Continuous Form), then by clicking on ID on the details for that particular record appear.
What I would like to do is: When the user clicks on ID, only that record whose ID has been clicked on displays first on the continuous form, and then the PERSONAL form opens. To clarify further, my wish is that the sequence of events is:
User Opens Table 1 Form
User Clicks on ID (for example, let's take 2)
Only Record with ID 2 remains on the Continuous form.
Then details for record 2 display on the Personal Form that opens next.
The problem I currently have is with step number 3 above.
Forms :: Add / Edit New Record Only Continuous Form?
Mar 27, 2014I have a continuous form with unbound controls. These controls write new records into a table using rec.addnew
If possible, I would like for the user to only be able to add/edit the new record only and not to edit the continuous form below. When I turn off edits on the form, I only get the new record to show. I found some pages that reference using code like .allowAdditons, .allowEdits and .allowDeletions but unsure of how to implement them since I have more than one control the user is entering data into. I also found another site that says to use a control to determine if the record is writable to: I do have a control that is set to =Date() on the default value.
How To Identify Which Record In Continuous Form Was Clicked On
Nov 6, 2011I have a continuous form with an image and a text box on it. When the image is clicked, some text should appear in a text box. The problem is that the text appears in the text box of the incorrect record.
Suppose the first record is the 'current' record (i.e., having the record selector to its left), and the user clicks on the image in the third record. Then the text appears in the first record, not the third.
Is there a way to find out which of the records was clicked on? Or, can I change the current record to be the one whose image was clicked on?
Forms :: Refer To Specific Record In Continuous Form
Apr 15, 2013I have a main form with a continuous sub-form. On the main form I have a series of text boxes that I want to use as a makeshift status bar. The text boxes would be filled in if a value was entered into certain records on my sub-form.The problem I have is since the sub-form is continuous, how would I refer to the specific record on the sub-form that I want to check for a value?
View 6 Replies View RelatedUnbound Text Field In Continuous Form: Update One Record, They All Get The Same Value
Feb 20, 2006Hi,
I want to show some text from another table based on the values of the bound fields in each record of a continuous form. I thought it would be easy, but I can't get it to work.
I step through the records in the bound recordset and use some of the values to query another table. Then I use the value from the query to populate the unbound text field.
It works fine for each record. But every time the unbound field is updated, all the records in the continuous form are updated.
I'm stuck on this one. It's probably something simple to fix - if you know what to do!
Do you have any suggestions?
Thanks!
-Daniel
Forms :: Continuous Form - Saving New Record When Data Passed To It
Dec 11, 2013I have a continuous form it has a field (DateStart) and a field (DateStartCarryOver). There is an event on (DateStart) for the (DateStart.Value) to be passed to a new record in (DateStartCarryOver).
My probem is that the new record dosent get saved (i.e. it dosent get an ID so a record isnt created. How can I create that record once the data has bee pased to it?
Forms :: Combo Box On Continuous Form Updating Current Record Only
Jul 29, 2013Combo box on continuous form should have the control source listed as the field on the form that will be updated. The Row Source, however, is a query that includes 2 things: the field on the form that will be updated (this part will be nonvisible in your form) and the table/query of selections you want to show up in the combo box (visible). Then ensure the Bound column is set to 1 and the Column count is set to 2 with Column Widths as 0";1"
View 1 Replies View RelatedForms :: Display Button On Selected Record In Continuous Form
Oct 30, 2014I have continuous form in Access 2010. I highlight selected record. Now I would like when user will select record, that record will display button to give ability user delete it. For not selected records button not visible and disable. How to display button only in selected record in continuous form?
View 2 Replies View Related