Search results

Sorry you see it that way . I am a novice and im doing my best to explain. Thanks for your help anyway .

The combo is on the split form that is open.This is the code in the query [Forms]![Vew all Invoices]![Combo57] As i say the combo gets its values from a table . it all works until i put a > before the number

Dont fully understand what your saying The combo is getting its values from a atable and i have code in the query criteria to get its criteria from the combo .i ihink i have this correct as it all works except when i add >to the number in the table

Help please I have a split form to display all my Invoices Currently the underlying Query displays all Invoices I Want a a combo box to display various numeric ranges .The combo Gets its ranges from a table where they are stored as text . My prolem is that no matter what I try I can only...

Thanks thats very helpful .Will try in format event

Hi i have a report that I use for an Invoice I have the price deposit balance due ect in the page footer Tried the report Footer But it Moves up the page and doesnt look professional The page footer is always in the right Place at the bottom of the Page .But if my invoice detail goes to 2nd...

Ok Thanks for your help

Hi sold at price ,Product ect are all fields in the products table when the product is selected via the combo box i want these fields plus vatatvatsum and InvoiceTotallIncludesvatAt to be automatically selected fro the products tabe and enterd into the new orders Table cant understand why...

Hi Jdraw this is the dlookup code Private Sub ProCombo_AfterUpdate() SoldAtPrice = DLookup("[Sell at price]", "Products", "IDProduct= " & [ProductID]) Product = DLookup("[Product]", "Products", "IDProduct= " & [ProductID]) Supplier = DLookup("suppliersfk", "Products", "IDProduct= "...

Hi have a subform called Newordersid and a table called NewOrdersID I use Dlookup to populate the sub form on afterchange event of a combo box It does this but does not populate its table I use dlookup for otherfields in the subform and table and they all work I have checked the spelling and...

Hi Is there a way to stop my report footer riding up to the last detail .i really need to anchor it at the bottom of the last page

Hi Mark Thanks for that i will let you no .Yes i do agree about the page footer on every page but it does seem to work really well

Hi mark are you saying i should use the report footer for all my calculation.If so i did do this when i first constructed this report .but found it gave me many problems . The page footer seems to work really well just apart from printing on every page .shourly there must be away of sorting...

Hi i have a report that i use as an Invoice .I have all my totals in the page footer but if my invoice goes to more than 1 page I get the totals appearing on the footer of each page . I need a way to only have the page footer show on the last page . I think it may be something to do with the...

Sorry Ive taken a while to get back . Thanks for your help, I had a feeling that might be the case

Hi Have a continuous form with 2 date fields in each record . If dateField1 is empty ,Then I want a way to make DateField2 Take its Place . I know how to make things happen with conditional formatting on one field by UsingIsNull , I have tried sending datefield2 to back.But cant work out how...

Hi Dave and everyone who has come up with idears I do keep hard copies of all my Invoices ,But after many years it’s a real Headache trying to find them I have also recently been scanning and saving them .It works well But sometimes I forget ,and its just another job I could do with out And...

Thanks for all your Help will give p baldy a try . Maybe there is a simpler way Gemma the Husky, asks why I want to change the Default I have a report that is a customers Invoice .This invoice report must never change over time.If i was to look up this report 2 years from now it should be...

Hi I have a split database ,and I need to update the Table default value of a field Rather than go into the table I would prefer to use a form I found this code but it wont work,I presume becouse my data base is split Private Sub UpdateInvoiceReportNumber_Click() If Not...

Hi Thats exactly what I need Thanks for your help John