Recent content by LaughingDev

Yes, each ProductType continues in the same column and page, I would like to keep it this way. Ive attached a screenshot of the report with the line in the details section.

Well, technically there are 44 rows, but some of these are used by the GroupHeaders (ProductType) which can vary depending on the products table.

Using the line control in the details section gives me 2 lines per page, I am positioning the line at the end of the first column and thus it is repeated at the end of the second column.

Excuse my ignorance, but could I ask for some noob friendly instructions on how I would code it and in which event so that the line appears only at the end of the first column and not the second as well. At the moment I have a textbox which is counting each row downwards starting at 1 and...

I probably should have mentioned, that the columns are laid out 'down, then across', which means using this method each column will have both odd & even numbers which will probably give 2 broken lines. Is there any other way to accomplish one solid line between the columns?

Hi, sounds like a good idea, but how exactly would one retrieve the current column number? Thanks

I am working on a report to print a list of all the products in my DB with the unit prices, essentially a price list. The report is split into two columns via the pagesetup and is grouped by the field ProductType. I would like to draw a single distinct vertical line between the two columns, I...

Thanks for you advice, it pointed me in the right direction and I have managed to resolve the issue. The problem was that the data types of the compared fields did not match, therefore even though the values were correct the conditional statement would not be triggered. I hadn't realised that...

I am working on a system which manages orders, purchases and the inventory for a small trading company, much like the northwind example. The db currently has 6 tables: Products, Customers, Orders, OrderDetails, Purchases and PurchaseDetails. I just realised that the CreateOrder form allows...

Thanks for the advice guys, So is it really not possible to have the AfterUpdate event on the combobox itself where its behaviour would be to either not allow selection of the product that is out of stock or produce a MsgBox and immediately remove that record/product. If it is could I ask for...

Hi all, Ive been working on a simple Access database system for a small business which buys/sells goods. Im currently trying to develop stock control on the CreateOrder form. The database is similar to the Northwind example, it has 4 tables thus far: Customers, Products, Orders &...