Search results

Hi Bob, I realise this thread is old but it is very similiar to a problem i am having and didn't want to double post! I need to do a dlookup on a query that will copy all data from the query to the subform. I'm stuck as to which way to go about it. i could either: A) Set query as record...

I have even copied the whole report from design view into a new blank report to see if it had corrupted anywhere.... Still nothing. It must be something simple i just cannot find it! Thanks James

Hi all, I'm hoping someone can help me. I've got a report/invoice that i want to print out with a simple header picture for the company. For reasons i cannot fathom the picture will not print. Print preview, Report view, print as PDF, XPS and even copy to a word doc all display the...

Sorry to all. I had a 2day long moron moment. I just used the filter i used on the form in the query parameters. sorry all!

Hi All, First of all my apologies for the title, i wasn't quite sure how to word what im after in a shortened version! I have a filtered form with a sub form displaying only non-printed invoices. The sub-form has a check-box (which is how the form is filtered) to only show unchecked (not yet...

For anyone else wondering the same thing as me I managed to achieve this result by simply filtering the form on load (Which i didn't realise i could do :banghead:) I simple put this piece of code in the record source: SELECT * FROM Mainstock WHERE Mainstock.Obsolete =0; And made a seperate...

Ok after much head scratching i'm still no better off. I've also tried this code Private Sub Command69_Click() If Me.chkObsolete.Value = True Then Me.chkObsolete.Visible = False Me.Refresh End If End Sub To no success. Every record has a tickbox in it which has a control source in the...

Sorry, my poor explanation. I mean any record checked in the chkObsolete field will not be displayed on the screen. The code you gave checked everything on screen. which is further than i managed to get but not the result i was after. Thanks for you help so far

Thanks CJ, Unfortunately its still will only refresh the data and not filter it. Thank you for your suggestion! James

Hi all, I realise this has been discussed in other thread but the ones i've found refer to unbound checkboxes and single forms/sub forms. I have a Split form displaying parts information and have all data displayed from the table including an obsolete field which is a Yes/No checkbox. I want...

Just starting out with Access 2013. Building a database for my Uni course so i will probably ask alot of questions and i'll try to be as helpful as i can! sorry for any silly errors!