Search results

Thought so. Thanks for help already given.

Well, We have buys and sells. For UI interface reasons and for the reason the info we enter for each kind of transaction differs a lot, there are two separate tables and two separate data entry forms, one for each kind of transaction. Then there’s a union query that unites these transactions and...

Ok, let's go once again. I have 4 stores holding up to 200 products each. There are only incoming and outgoing products (no backorders or anyhting else). I have reached the point of designing data input for purchases and sells but now I want to go further, I want to know the value of products in...

Brilliant thought! I can manually enter only transactions though, and by this way have the stock take updated only for the dates of transactions. So problem still remains for the days there's no transaction. Still can't combine prices table with stock take table, 'cause prices table is updated...

There http://www.access-programmers.co.uk/forums/showpost.php?p=1442526&postcount=1 lies my problem. Be kind to read the whole thread, as I later explain with more details. Thank you for helping. Last chance for me !

Sorry to intefere but, @RainLover please tell me if I'm wrong, in your sample, based on Allen Browne's code, stock take is a manual operation. You have to manually input the desired date for the procedure to calculate stock in hand. What if we had over 200 different products, multiple...

Thank you Doc, As I mentioned before, prices change almost every day, and I want to know each repository's whole value, every day, whether there is a transaction or not. I never said I have an issue on storing calculated data. The fact that stored calculations will never change makes it even...

Problem is not solved yet and won't be, but I mark it as solved as I abandoned it. Thanks to everyone who tried to help.

Excel by default has a number column in the leftmost side of the spreadsheet in order to uniquely identify each row. When data is transferred to access and rows become records there’s no such number to uniquely identify them. You’ll have to create your own identifier, in order to determine which...

It isn't unbound. It keeps its ControlSource Property but you define its RowSource after changing it to a combobox. You could find enough information here http://support.office.com/en-ca/article/Create-a-list-of-choices-by-using-a-list-box-or-combo-box-70abf4a9-0439-4885-9099-b9fa83517603...

Nothing, they are sitting there waiting to be sold, but I want to know their everyday value, in a way I can present. (Value changes almost every day). Suppose he have a transaction (no matter what) for productA on 1/7/2015 and then a transaction for productB on 1/20/2015 and then two...

Well now it seems we're getting somewhere Thanks for your contribution Doc, I'll answer to all your questions (rhetorical or not) as soon as possible....(sorry I'm doing something else more urgent right now).

Of course it saves the ID (number, first column of the lookup source) by default. Lookup fields are always numbers. That's a reason why you shouldn't use lookup fields in tables. Use them in the data entry form only.

You want to match tblProposals.ArchiveBox with tblLookupBoxLocation.BoxLocation but in your code you refer to Box.Number

It could be, yes, but since there are other stores, or there’s no obligation for any store to retain high availability for all products all the time, it isn’t for the time being. But…. What’s that got to do with my goal? I just want to able to know each day’s stock value for all products, in all...

That's the exact definition, a documented proof of Purchase or Sell. No there aren't such issues. Customer buys only 12 or buys from another store.

These are the basic business rules : Every store handles all products Every store does 4 kinds of transactions, buys, sells, money transfers to, and money transfers from (we don’t care for last two for the time being). Every store has its own vouchers and makes its own stock report Vouchers...

No ideas uh? Me neither! :(

I would try this : Private Sub btnDatumUpis_Click() Dim SQL As String Dim myDate1 as Date Dim myDate2 as Date myDate1= Format(txtOddatum, "yyyy\/mm\/dd") myDate2= Format(txtDodatum, "yyyy\/mm\/dd") SQL = "SELECT qrySearchV.VID, qrySearchV.MarkVoz, qrySearchV.ModelVoz, " _ &...

How about using WeekDay or WeekDayName functions?