Search results

Hi, Please can I have some help with VBA to dynamically change the color of a bar chart based on the value of "SumOfPercentage". It's frustrating that Access doesn't have a built in conditional formatting option to do this. If value is under 50 - green If value is between 50 and 90 - orange If...

Hi everyone, I am looking for some guidance on how to approach building an automated production planning system into my existing orders/stock database. A little background on our business operations and current set up: We manufacture fire barrier insulation using various machines and staff to...

Hi everyone, I'm hoping for some assistance in automating label numbers for pallets. I currently have a manually entered Pallet_Number field that stores the pallet number for each item on a shipment and groups the items together so they can be printed on individual pallet labels. However, each...

Hi everyone, I'm trying to add an optional variant to the below inventory control code. I would like the code to output the current inventory for a particular zone of the warehouse if specified when calling the code. If a zone isn't specified, the code will return the current inventory for all...

Hi all, I have a list of products in a form which make up our inventory and when a product is clicked on I would like a pop up form to open just above the mouse cursor displaying the stock numbers for that product. I have this all set up and working except for the placement of the pop up form...

Hi all, I'm hoping for some assistance to help me build a function which calculates the average cost price (ACP) of our stocked products. I have had a look online to see if anything already exists but couldn't find anything suitable. I have attached 3 examples taken from an Excel workbook to...

Hi everyone, I have been using Allen Browne's Inventory Control code for quite some time now and it has been working perfectly. However, there is now a requirement for one of the stocked product's quantity on hand to be displayed as a decimal number. I have changed the data types of the table...

Hi all, I am trying to make a crosstab query with a date range as the column heading. My 'Shipments' table contains a field called 'Despatch_Date' and I would like the crosstab query to use this data as the column heading starting from today's date through to the maximum date in the data...

Hello! I'm hoping for some advice and guidance but first a little bit of background on my set up: The office has two PCs and two printers, the default printer is called "+25" and the other printer is "Zebra Printer". However the Zebra printer is also called "\\4H1Z742\Zebra Printer" because...

Hi all, I'm seeking some advice on a good way of implementing an order status field for my Shipments table. This field will be displayed under the shipments section of the orders form to quickly show the user what stage of the process the order is currently in. I would like this to be a field...

Hi all, I am using a report to create a custom layout for printing onto labels which stick onto pallets. Each label can have up to three product details on it and the report is grouped by pallet number. The report detail height is fine when a specific pallet number has three items but if the...

Hi all, I am using the below code to check if fields are blank before closing the form. However it's not completely what I am trying to do as it will still close the form even if only one of the fields is blank. What I want it to do is to only close the form if ALL the fields are blank. How can...

Hi all, I'm looking for some advice on how to solve an issue I have with the combos in my subform. I have attached a screenshot to help me explain. I am using a query to limit the items in the 'Product Name' combos and then using this selection to limit the items in the 'Dimensions...' and...

Hi, Can someone please help me write some code which copies C2 : D6 (including formulas) and pastes this to the next available row underneath. This will need to loop 4932 times. I also need the code to fill down columns A, B, F, G, H, I and J until the last row. Column A will need to be filled...

Hi all, I am looking for some advice on what options I have to mimic in Access what I have in Excel. I work for a manufacturing company where we make bespoke fire barriers for walls and floors, as well as other products. A while ago I created an Excel workbook which allows staff to create a...

Hi, Please can I have some VBA advice. I am writing some code so the Order_Status field back color changes depending on what text the field contains. This is what I have done so far: Private Sub Form_Current() Dim lngOrange As Long, lngPink As Long, lngYellow As Long, lngGreen As Long Dim...

Hi all, I have created a union query (I have used a union query because my order form has multiple subforms) and I am then trying to use DMax in the order form to show the last modified date and time of the order. As shown in the attached image, I am trying to display the time highlighted in...

Hi, I have created a company stock database which is working well but I am looking to expand its functionality to more of a customer orders database with the stock side of things being a feature rather than its primary use. I have been updating the customer order numbers manually based on...

Hi, I have a query which runs the following syntax to show the inventory totals for all products based on a specific date (Onhand is the function to calculate the inventory totals): OnHand([Product_Code],Format([Enter stocktake date to report on],"mm/dd/yyyy")) In this instance the user...

Hi, I am using the Filter property in the Report Property Sheet and it is working great when filtering one field. However, I would like to filter by multiple fields at one time. This is the syntax I am currently using in the filter property: Date_Due_In...