Search results

  1. I

    Copying data

    I have an Access database that has been in full swing for a few months. Another copy of the same database I have been updating and improving. My issue is that I have converted a couple of fields from text to a lookup. I can't copy the existing data into the new database due to the field change...
  2. I

    Sub Report in a Form

    I have a "Stock Check" report that has a running sum and has a filter attached to it. Works perfectly. I also have a form that allows the user to adjust the stock level. What I want is to put the report as a subreport into the form, so the user can see the current stock level. I have the...
  3. I

    Running Total

    I am trying to get a query to give me a running total....and failing miserably. My select query is getting it's data from a union query (QCombinedInventory) and a table. (Goods) I want a running total of Qty. I have scoured the internet and have now lost the will. This is what I have at the...
  4. I

    Union Query & Combo Box

    Good afternoon I have a union query which is getting some of its data from a combo box result. Within the union query it is stating the First column rather than the second column. The data in the table does state the second column as I want it to do, but I can not get the union query to follow...
  5. I

    Query resulting in 556

    I'm back again and going insane. In a query I have Sum([Convert]*[Quantity]) [Convert] is a weight and [Quantity] is the quantity of labels needed. In another query this has worked perfectly, but in this current one it is already multiplying the quantity by 556. example: It should be...
  6. I

    Revove decimal if two in field

    I am trying to remove a decimal if it is the first character in a field. We get weights from a set of scales that appear as .2.450 which is 2.45kg. When manually entered there is no leading decimal so trim is not an option. Ian
  7. I

    Union Query & Combo Box

    Morning I am currently trying (and failing) to merge two tables with 9 identical columns. In the "Stock" column on both tables it gains its values through a combo box. When I do the union query, it gives me the stock id (combo - column 1)rather than the stock name (combo - column 2) SELECT *...
  8. I

    Easier way than hundreds of fields?

    Hello I am currently developing a traceability database for our butchery dept.When it comes to the labelling of the product is where I hit a wall. I have fields with all the information that appears on every label such as, Product, use by date, batch Id etc. I have managed to connect the...
  9. I

    Update main form from subform

    Hi everyone I currently have a main form that prints through a report to a label printer. I have now added a subform that will contain the weights. So each time a weight is recorded it tabs down and records the next weight. I want a field on the main form to pick up the weight in the latest...
  10. I

    Font Colour

    Morning. I know this is going to be a simple one for somebody, but it is driving me insane. My font colour in my table datasheet is white by default. How can I change this to black? If I do this in text formatting it won't change the default.
  11. I

    Print copies of report based on text box

    Hello All I am printing a report (which is a label) from a form using the command button. What I want to do is have a text box on the form, so the user can input how many labels are to be printed. My code so far is: DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "RLabelGoodsIn"...
Top Bottom