Search results

Hi. I have now got my accmdfiltermenu command working on my continuous form but have encountered a problem with my code: DoCmd.GoToControl "Txt_Column1" DoCmd.GoToRecord , "", acFirst DoCmd.RunCommand acCmdFilterMenu Works great. The line to go to first record is so the filter menu always...

FInally figured out the issue and it was as basic as could be. WIthin properties i had allow filters turned to no. Stupid me.

Hi I have a form with a subform within it. The subform is a continuous form. I wanted to add some of the standard filter options you get on a datasheet so did some digging and the internet suggests adding code to the label header and use on click event for label and insert following code...

Hi Ranman Thanks for the help. THat worked a treat. I have tried introducing this guy to the 21st century numerous times to no avail. For my records though the pdf thing will be great.

Hi I have the following save button in a form. When i click on it the idea is to resetdata and move to next record. THis all wokred perfectly but then i wanted to add in a report to print out when i click the button so that the boss at work can check the inputs rather than have to access the...

HI I have an invoice form with a subform. THe subform show the products i have sold on the particular invoice. It is displayed as a continuous form. What i am trying to do is be able to delete particular rows from the invoice form by clicking the command button. See image. From help earlier...

Follow question. As you state golden rule is to use other method instead of recordset if possible should i use an apend query instead of a recordset to add invoice details to the subform? Set db = CurrentDb Set rs = db.OpenRecordset("Tbl_TempInvoiceDetail") rs.AddNew rs.Fields("Variety_ID") =...

PErfect. Worked a treat. Far simpler and should keep speeds up. Many thanks.

Hi I have an invoice form with a subform. When i press a cmd on the main form it runs the following code to cancel the new cancel and delete any entries that that been made to the recordset set contained in the subform. Private Sub Cmd_Close_Click() 'On Error GoTo cmd_close_Click_Err On...

THanks for the tip. That worked a treat and now deletes both sets of records as desired when i press the cancel button using following code which was from a macro conversion: Private Sub Cmd_Close_Click() 'On Error GoTo cmd_close_Click_Err On Error Resume Next If (Not Form.NewRecord)...

Hi. I have an invoice form with a invoice detail section and a subform with a list of prodcuts associated to he the invoice. See image of my form. The subform is not the actual invoice_product details table but in fact a neater query. The subform is locked and the products are added to the...

Hi THanks for response. Did as you suggested and get the following (slightly confusing code - well confusing to me anyhow) Private Sub Cmd_Close_Click() On Error GoTo cmd_close_Click_Err On Error Resume Next DoCmd.GoToControl Screen.PreviousControl.Name Err.Clear If (Not...

Hi My question is two fold. Overview - I have an Parent table named Tbl_Invoice and a child table named Tbl_InvoiceDetails. I currently have a relationship between the 2 linking the Invoice_ID. I have enforced cascading delete Question 1 - should i have enforced cascading delete or would...

Cheers for the respsone. Stupid question. How do i bookmark?

Hi Currently have an invoice form with various textboxes on it and a listbox. THe following code was provided by this forum for me so that when i type something into a textbox it filters the below options in a list box. Private Sub Txt_SearchFor_Change() 'Create a string (text) variable...

Cheers both for response. Tried both solutions and they both did what i was trying to achieve. THanks so much.

I have a mainform where i add invoice recrods and they are populated on the subform using the following code Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Tbl_TempInvoiceDetail") rs.AddNew rs.Fields("BatchNo") = Me.Lst_SearchResults.Column(1)...

Hi This is an odd one but i have a subform that fits nice and neatly. See image attached without scrollbars. When i get so many entries in the subform (which is a continuous form) the vertical scrollbar appears but annoyingly covers over the delte button rather than expanding the actual...

GOt it The solution was i am a plonker and wasnt referring ot the child form by the actual form i inserted into the child form. Like "*" & [Forms]![Frm_InvoiceMain]![Frm_ChildInvoiceForm].[Form]![Txt_SrchText] & "*"

thanks for link. Had found a similar loink but still not sure how that means i amend mine qry design. From the criteria being Like "*" & [Forms]![Frm_SubInvoiceDetails]![Txt_SrchText] & "*" Any ideas