Search results

Hi Pat thanks for your comment but as i explained i cant use the footer as the document will print anything up to 100 pages depending on the data and i dont want to show this text and the end of the report or on each page, only page 2. Page 1 is an intorductory page to the report, page 2 is the...

Hi, i'm looking to print out some text "FooterTxt2" just before a page break on an access report which only needs to appear on one page, the 2nd page at the bottom. Above this text are 2 tables and a text box that need to grow and setting a top margin for the text has risk if the tables grow...

Thanks for sharing! You have a great site BTW great job @isladogs ! I have now bookmarked your site. :cool:

@Pat Hartman @Uncle Gizmo Thanks guys, i just got around to reading your replies and boom! (i think i was having a blond moment) Added the private sub to both subforms and BOOM!! its working exactly how i imagined. thanks again!

Hi @Pat Hartman i have been looking at your code above and would like to use it as it works well for my main form. How would include subforms to this code? thanks in advance. Sods.

Sorry i had to pop out for a bit but it seems to work well (testing over time will tell) i used @arnelgp method with a requery and then using the find method to go back to the original record, after it was lost during the requery. me.QuoteID = QuoteIDtmp Me.Requery...

I'm trying 🤭

Brilliant thanks for the guidance i will i am sure be able to to sort this (TOP 2 i didnt even know there was such a thing) and thanks for the refernce pages its making sence to me now... thanks again guys!

Hi I wonder if anyone can help.. i have this table... TblQuote QuoteID QuoteNo QuoteVer HideQuote 2107 2107 1 No 2109 2107 2 No 2111 2107 3 No when the user creates a new version i would like to know how to calculate and hide old records for a given QuoteNo (all...

@gasmanAll working now thank you... I needed your fresh pair of eyes and experience. issue was naming of the feild OrderLinkID

@Gasman thanks for your speedy reply The SQL i have tried... INSERT INTO TblOrderitem ( OrderMainLink, PartNo, Description, Qty, UnitPrice, SubPrice, OrderItem_Spec, Location, Supply, DelTime ) SELECT 113 As NewID, PartNo, Description, Qty, UnitPrice, SubPrice, OrderItem_Spec, Location, Supply...

Hi! I have taken a standard code for duplicating a form with its subform, but it falls over when trying to append the subform to its table.... Private Sub OrderCopy_Click() 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim...

@Gasman Brilliant thank you, Sir! The Like method worked a treat

I have a form that opens a query. In the query, there is a filter... [Forms]![FrmNote]![AC_No] Target objective If in the form [AC_No] is null then show data for all CustomerID in the query however if [AC_No] is not null then it displays the query for a specific CustomerID that is defined in...

Thanks Minty, I believe I am able to set no duplicates to a field that has multiple Null values but the populated invoice numbers must be unique.

thanks, I really appreciate all of your feedback. Let me explain and describe the business model and also the Order table that may have to be renamed Orders We supply spare parts for Products that are within 12 months warranty (90%) these are free and to create an invoice is not required...

Guys, I have a table called Order one of the fields is called [InvoiceID]. I have a button in a form that auto-generates a sequential Invoice number, by looking up the highest value and +1. I did this via a macro... Set Value Item = [InvoiceID] Exp. = DMax("[InvoiceID]","Order")+1 But I...

Thanks MajP, I will try to use the method you described next as I love learning especially new methods using fewer resources and faster results. But, As I'm a bit of an old geezer what life has taught me is that, if it ain't broke, don't fix it. :D Thanks again guys, what a great forum!

Absolutely Brilliant! That worked a treat thanks!

Hello Guys, Bit of a newbie so apologies in advance I wish to match 3 results if all 3 are true pop up a single message box appears, using the Dlookup method. 'If DLookup("Retailer", "OnSite_CoverTrue", "Retailer='" & Me!PURCHASED_FROM & "'") = Me!PURCHASED_FROM Then ' MsgBox...