Search results

  1. B

    Copying value from previous record in a continuous form

    Why would I put an extra field if I really dont need it?
  2. B

    Copying value from previous record in a continuous form

    Yes I know, I dont have a primary key because for one month I can have multiple rows.. And yes used green, balance black
  3. B

    Copying value from previous record in a continuous form

    Anyone...?
  4. B

    Copying value from previous record in a continuous form

    Yes here it is.. We are looking at the Cheques part. So the Cheque inventory details are the information on my main form and cheque inventory monthly is my continous form.
  5. B

    Copying value from previous record in a continuous form

    The only thing is that my "month" field is only a text field.. And sometimes I can have 2-3 rows for one specific month..
  6. B

    Copying value from previous record in a continuous form

    Yes I am confortable using vba and yes I need it per record because for the first record of the list I only have the balance.
  7. B

    Copying value from previous record in a continuous form

    Alright, so I have a continous form on a form and i want to take a value in the previous record (BLUE), subtract one value in the current record (GREEN) and put that calculated value in the field (BLACK). All this by pressing the button on the current record (RED).. Is it possible? I can...
  8. B

    Dynamic reports?

    What do you mean?
  9. B

    Dynamic reports?

    Yes, but in that tutorial, the report is only taken from one table and the only thing he's doing is filtering. It's not what I want
  10. B

    Disable query field?

    Anyone?...
  11. B

    Disable query field?

    Is there a way to disable a query field (Not only hide it), so when I run the query and see the datasheet view, it doesn't take charge of that field and doesn't display it. I would like to be able to trigger (Enable/disable) some fields with a button or a check box maybe? Is it possible...
  12. B

    Dynamic reports?

    I'm trying to find a way to do dynamic reports.. What I wanna do is be able to select the field I want and then create a query based on these field and show the datasheet view.. I was thinking about using a split form, so the user could select the information he want to display and then just...
  13. B

    Fill Back Color Of A Continuous Form?

    No, I think its better with the alternation because without it it looks just like a rectangle.. Have a look
  14. B

    Fill Back Color Of A Continuous Form?

    Well, this is a subform and i was trying to make it more professional by filling those alternated colors even if there is no records
  15. B

    Fill Back Color Of A Continuous Form?

    Sorry we cant really see the difference in the colors.. Here's an update !
  16. B

    Fill Back Color Of A Continuous Form?

    Hello, I have this continuous form and I'm trying to continue the alternated colors even if there is no more records to show. As of now, at the middle when there is no more records, only the grey back color continue to display but I want the alternation to continue.. Is it possible?
  17. B

    Query for total payment of each order number

    The only reason I designed it this way is because I'm doing a conversion from excel for people that were using this method for a long time... But we can always change it if I find a better way. Also, yes thats what I this with 5%, Total Payment and Total freight on the form. Its calculated...
  18. B

    Query for total payment of each order number

    Yes, but the reason i'm doing it that way is because I want my form to look like this : And Im not sure if you can do 3 subforms from one table with a filter on each for the CenterNumber?
  19. B

    Query for total payment of each order number

    This is what I have at the moment but it calculates only the first record of each order So for Cheque Orders 0088 = 1$ Cheque Orders 0088 = 1$ Cheque Orders 0091 = 1$ Cheque Orders 0097 = 1$ The big total for the order 001 would be 3$
  20. B

    Query for total payment of each order number

    I have a table, Cheque Orders Details that has only the basic information (Contract Number, Supplier Name, etc) of the order and with 3 one to many relationship. The 3 relationships are the tables for each production centers, Cheque Orders 0088, Cheque Orders 0091 and Cheque Orders 0097. So for...
Back
Top Bottom