Search results

I'm afraid you got to have a set of rules for these sequence numbers and I don't see you mention it somewhere. So let me try to clarify it. You want them to be autoincreasing but have a standard prefix depending on customer's sex. You want them to start from the beginning when date changes...

Thank you Minty for your contribution! I’m not against jdraw. There are some ‘business rules’ though (every store has its own system of invoicing, an invoice or delivery receipt could contain multiple different products, etc.) and for user interface reasons I’d prefer the table structure I...

Thanks again! I've already done that. And that's how I stumbled on the aggregate query. Still no solution in mind. I thought that if I run Allen's code somehow everyday (product prices are updated every day) I would create a table with StockonHand values on a daily basis. But Allen's code is...

Thank you for your contribution jdraw Of course your model is under consideration but, whatever the approach shall be, it’ll come a time that I’ll need to create a query with a DSum column. That column only shows the running total in hands of the product specified in each row (transaction) for...

Well I really wouldn't want to implement the "stock take" functionality either. And handling edits/additions/deletes doesn't seem to be an issue for the time being. But, I still can't figure out how I get to know which and how many products I have in hand, each calendar day. I want to store...

Thank you for your answer pbaldy As I said, I searched a lot, and it's impossible not to run into Allen's page. My structure is almost identical. Since you mentioned it, I would like to know where should I put this code he provides to get results, although I'd rather use the second alternative...

Stock Tickers are the abbreviated names of companies in the stock market. This is the way they appear in the stock market table, and this is the way you'll find them in almost all infromative datasheets. Further more, if I wanted to use them in a database, I would first create a table with the...

I’m trying to design a database that will keep track of the value of products in stock, for several stores. So we have days with buys, days with sells, days with buys/sells, and days with nothing. 1st issue is that, for those fine days of no transaction, there will be no record, none, nowhere...

Something comes in mind.... Create an unbound text control (let's say txtColor, no default value)with the exact same attributes as CellA, hide it behind CellA and make CellA transparent. Now give the CellB value to the background of txtColor. It's a little quacky but I think it does the job. A...

Well, Where there's a will, there's a way These : LPrice = DLookup("[Low]", "SubQryActiveStockPrices", "[PStockID]=" & [StockID] & " AND [TradeDate]=#" & Me.Parent!TabletDate & "#") HPrice = DLookup("[High]", "SubQryActiveStockPrices", "[PStockID]=" & [StockID] & " AND [TradeDate]=#" &...

Still nothing doing. I did find out how breakpoints work but it doesn't apply to my case because this is a form's control code, and it doesn't break if there is no error. My control brings up no error, it just accepts everything I input in, because code doesn't make the comparisons. I'm...

I'm afraid I don't how to do this but hopefully I'll learn....thanks.

Let me be a little bit more clear. I have two input forms, BuyTransactions and SellTransactions. When I register a sell price, code works perfectly alright, and if price is unreal, it brings up the proper message. Same thing does not happen in BuyTransactions form. There, it accepts anything...

Hi everyone, I use the following code behind the BeforeUpdate event of a control, to validate input. Private Sub StockPrice_BeforeUpdate(Cancel As Integer) 'strings used for the MsgBox Dim strTitle As String Dim strMsg1 As String Dim strMsg2 As String Dim strMsg3 As String Dim strMsg4 As...

Update! You won’t believe it! During form design, especially when I have to connect a bunch of subforms with a main form and with each other, I usually leave all controls (even the autonumber ones) enabled and visible so I can check if everything works right. In my case there were a couple of...

This http://www.access-programmers.co.uk/forums/showthread.php?t=258405 might help

Actually there's a main form, with two subforms, and the second subform has 4 subforms in a tab control. So there are 7 forms, and the underlying queries and tables, all of them with label captions in Greek. Data is also in Greek. It would be easier for me to redesign it from scratch than to...

No there isn't a pattern. I ran the code only using the *page.Visible lines and then only using the *form.Enabled ones. Still it stops whenever.... I'll try to replace the If statements with a "SELECT CASE" one just to see what happens, although I'm starting to believe that something is going...

:banghead: Now it stopped in another line. Everytime I run the code it stops in a different line :mad: Note that I tried it in two different versions of the same database with a slightly different order in code lines . Same thing happens. It's obvious it's not a specific line of code.

Done that already.Still the same.... Tomorrow I'll start it all over again....from scratch.......:(