Recent content by A1ex037

Thank you for your responses. Last few days I have been playing with the original idea, that didn't turned out well (too much overhead with changing parameters on each order). I will try @The_Doc_Man suggestion. I appreciate the note on the stock tracking. Also, @CJ_London excellent comment on...

Hello everyone, I am trying to figure out how to split stock into 2 different warehouses. Our stock has been created (due to the constant change in order price) on a FIFO basis from here. We're moving one part of a warehouse to a different city (in a time, both cities will hold identical...

Nice, looks like this one is working. Many thanks for constructing this. I will look into it today and apply to my case.

I did that, just to enable back/ffwd movement in frmSales. What I'm looking is basically "CTRL+F" from current form to be performed on ID field in frmSales.

Hello all, I have a form that displays results of a query based on SaleID. If I try onClick event (on that ID), it will go correctly to that\record, but I'm unable to move back and forth from that record. It is displayed as "filtered" at the bottom bar. Is there a way to use DoCmd.BrowseTo so...

Well, this is the catch of the day! Nice find. Looks like it's working now. Thanks!

I have a query that has to be formatted on a daily basis (sometimes several times a day). There is a button that exports everything and performs search and replace. If I run it once, everything is OK. If I modify the query parameter (that is essentially the only change that is done), and try to...

Thanks, that did the trick. Had a criteria deep inside query that I have completely missed. Your suggestion did the trick.

I've decided to move existing forms to a navigation form, and first step is giving me problems. If I add basic form, it goes OK. If I try to add form that has search in a listbox, it displays an error. Error displayed on frmSearchItems is: Enter parameter value...

Nice! That is exactly what I was looking for. Thank you @plog and @arnelgp for your answers.

Hello, I am trying to figure out how to make a query that will have total sales (by quantity) of every product by year? Table SalesProduct has SaleID, itemID, Quantity fields (and a few others not relevant right now). Table Sales has SaleDate, SaleID (and a few others not relevant right now)...

Yes, same languages, same defaults (english). I will remove 2nd language now and see if it changes anything. Tried that, nothing changes. It's something with formatting that I'm missing. When I try to save it without last part of the name (date and time), it can save it. Found it. It was a...

I did that few days ago (honestly, didn't know that the order matters). Everything looks completely the same. I have compared all 3 computers. It has to be something related to formatting or regional settings, that's for sure. Here is an example of generated output name: 03275 - Marko Marković...

Yes, the computer is freshly installed. It's a nice thought, but everything has been done and configured properly. I have checked for updates, etc. It had to be something with the file name or Unicode chars for reportName. I have tested it again with fixed path (instead of filePath) and fixed...

I have tested each line separately, paths are correct. I have a bug at the back of my head that I had to do something on machine when it was first brought to work, but cannot remember what. That drives me out of my mind right now. Might be related to Unicode characters (file names contain...