Search results

Code doesn't work at all in the Open event (don't get that but anyway) Have solved issue. I've put it in the On Print of both the header and footer sections and it works there. Thanks.

The code works fine. The things items are in Header and footer sections. The issue is only on the OutputTo process.

Yes, it's a bound control on the form. This works fine if I run the report directly. It is only when I get vb to generate the report via the OutputTo function.

Private Sub Report_Load() If Me.SupplierOrderType = 2 Then Me.AirFreight1.Visible = True Me.AirFreight2.Visible = True End If End Sub On the Load Event for the Report.

Hi, I have a series of reports that are built to replicate the order forms of our suppliers. On each I have a text box for AirFreight that I only want visible when the airfreight ID is ticked. I have this working fine using an if statement on the Load Event of the reports. However when I use...

Thanks for your suggestion, MarkK. I'm not 100% sure I understand what you mean. While I was waiting for a response, I tried setting up an extra field in the table that holds the composite part number that shows the ID field of the Orderdetails table. This is the left side of the composite...

Hi, I am trying to join together a number of tables based on part number, where one of the tables the part number is embedded in a string in the field. ie PartNo RLT551A joined to 1234_RLT551a. I have googled and found the concept of a SELECT * FROM table a JOIN Table b on b.column LIKE '%' +...

Thanks pr2-eugin, The calculation is not going into a Table, that is exactly the point. I am unable to create a query that the whole form can run off as I have two different reference part numbers that can't be easily joined to make the form recordsource query. Hence I have to calculate...

Hi, I have the code below, that is required to calculate the cost of a part, based on the rollup of the component parts. I have the code attached to the subform On Current event, however it seems to be applying the RRP to all of the records currently showing in the subform of the main form...

Hi, I'm making some changes to my order management database to include the component breakdowns of parts rather than just the parent part numbers. Currently, I have my orderdetailsubF running off a query that joins together the orderdetailT to the partslistT to show the description and...

Thankyou so much Mark. I knew it had to be something simple. Working perfectly now.

Hi, This si such a simple thing but I can't work out why it's not working. I am wanting to create a directory based on the customer number and name each time the "Add Customer" form is closed. For some reason, the Me.CustNum and Me.CustName are returning the details for the first record in the...

Hi, Sorry, the above description isn't very good. I currently have an Order Details Table that holds the individual part number information for jobs. This table uses a couple of attachment type fields and as such is now getting very large. I am looking to split the table so that the attachments...

Hi, Can I please get some help with whether my logic is correct on a change I'm making before I start troubleshooting why it's not working. I currently have a Job Management System where the Customer Order Form displays all jobs via a main form and an order details subform. This form is used...

Hi Bob, There is a front end on everyone's PC. It has worked fine like this for 8 months. It was only once the back end databases were moved to the NAS that the corruption occurred.

Thanks Cronk, Do you recommend I rebuild all the tables to try and rectify the corruption? It is not only these 2 records. The Order db has had to be repaired at least 5 times in the last week. I am intending to rebuild many aspects including the Auto-number in the next iteration of...

Hi, I have an Access database that runs our Jobs Management. It has a front end and 4 back end database split into customers, suppliers, orders and partslist. It runs in a multi-user environment on a local network. It has been operating since 1 July 2013 without a single hitch. The database...

Thanks everyone. Turns out that it was working properly, I just hadn't let it go far enough through the process.

Hi, I am trying to use some code I found on this forum from Bob Larson, thread ID 207138, that loops through all of the controls on a form and looks for a message in the tag property and based on its contents either locks or unlocks the control. When I write the code it does not allow .tag...

Hi, I'm still struggling with this one. Any help would be appreciated. I probably should have added more of the code where I am trying to duplicate the order details from a previous order. I am using Allen Browne's code ser-57. Attached is the whole code - Dim strSql As String 'SQL...