Search results

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...

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 '%' +...

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...

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, 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...

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 have an issue with a subform that I am enabling or disabling depending on the status shown on the main form. I have an event occurring at "On Current" on the subform that checks the status of the main form and if it is new record or status "open" set allow additions/edits/deletions to...

Hi, I'm trying to duplicate the records in a subform to a new form but keep getting a too few parameters error. Can anyone spot my issue? I've been staring at it all day. strSql = "INSERT INTO [OrderDetailT] ( OrderID, ProductID, Quantity, DiscountPercentage ) " & _ "SELECT " & lngID & "...

Hi, This is going to seem so easy but I cannot get this simple update query to work. UpdateProcess = "UPDATE OrderDetailT SET DepSubCompl =" & Date & " WHERE ID=" & Forms![JobCardandSignoffF]![ID] CurrentDb.Execute UpdateProcess If I run the debug over it UpdateProcess comes out...