Search results

  1. C

    Average Cost Price Function

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

    Solved Modifying Allen Browne's Inventory Control to display decimal numbers

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

    Date Range for Crosstab Query Column Heading

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

    Solved Selecting A Printer When Printing A Report

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

    Order Status Display

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

    Fixed Report Detail Height

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

    Close form only if ALL fields are blank

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

    Combo updating all subform records

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

    Solved Excel VBA - Copy range of cells and paste to next row x amount of times

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

    Excel to Access Advice

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

    Solved If Field Contains Specific Text Then Change Back Color

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

    Solved Time Last Modified using Dmax

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

    Solved Autonumber Advice

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

    VBA Alternative to a Query Parameter

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

    Report Filter in Property Sheet - Filter By Multiple Fields

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

    Change subform from datasheet so it can be edited

    Hi, I have a form with a subform and would like to change the subform layout from datasheet to tabular without having to redo the whole form, is this possible? Thanks, Chris
  17. C

    Optional Variant Parameter Help

    Hi everyone, I am using Allen Browne's Inventory Control Quantity on Hand code and it has an optional vAsOfDate variant, as shown in the code below. I would like to use this to show the quantity on hand for a specific date but I can't get it working. I am currently using the code based on the...
  18. C

    Return Quantity on Hand for all products at the same time

    Hi everyone, :giggle: I am new to this forum and hoping for some assistance. I have very little knowledge of VBA in Access and am currently developing a stock database. I plan to have a report which summarizes all products showing key information, such as the current quantity on hand levels. I...
Top Bottom