Search results

Hi folks, Hope you can help with this. I currently have a database that is used to log customer transactions. The database also contains reports which are used as invoices for the various customers who have purchased items. However at present, I can create one report which shows all...

I currently have a parent report, with an embedded subreport. In the report footer of the parent, I have a selection of text boxes which do a series of calculations to give me report totals. I want one of them to take a figure from the parent (Total PurchasesIncVAT) and deduct a figure...

Hi, I, like most people can manage to report effectively from one table, however I am having some difficulty when it comes to reporting from two. I have a pupil transaction table and a "buyback" table (for purchasing items back from students). I want to create an invoice report for each...

I currently use a database into which I import a fair amount of data on a bi-monthly basis. Before I can import that data, I need to delete the existing records from the tables. I currently do this with a selection of delete queries which I call sequentially through a vb sub. Is there a...

Hi, I suspect this might be relatively simple, but I'm a bit lost. Apologies if this is unclear, I'm finding it difficult to explain my quandry. I've inherited a database which I need to develop a bit more. The database deals with school customer orders. These orders come from a set...

I have created a form which has a series of cascading combo boxes in it to assist the user in selecting the appropriate information. However I want to use this form as an input method to a table in the database. I know that I can link a field on a form to a table field using Control Source...

Hi, Firstly, I'm quite new to anything beyond a relatively simple database, so please bear with me if I am being a little slow on the uptake. I have a form which has been produced directly from a table (tbl_pupiltrans) as a means of input. However I want some of the fields on the form to...