Search results

Well, I finally found some time today. For a while, it looked like I might get away with the theDBguy suggestion: Private Sub btnBatch_Click() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("qryAisleInfo") Do While Not rs.EOF Call Shell("D:\_DB\_gateway\send.bat" & " " &...

I am on it tomorrow evening. We had new stock that was imported yesterday, so 2 days are we all over it. Generally, what I have to do with all this is to send proper information to workers at the warehouse (as mentioned). Main reason is that we are working with 50% capacity since february...

Thank you for your answers. I don't have much experience with it theDBguy, I mostly rely on examples that I can found and documentation. Batch file with 2 parameters (myfile.bat number ID), sends SMS message to our gateway (only way I could figure out how to communicate with it directly is via...

So, I am looking for a way to execute a batch file with 2 arguments. Arguments are values from a query. Query result has 10-15 rows, so it means that it should iterate through every row, pick up values from those 2 columns, pass them to batch file and execute. In order to start a batch file, I...

I did manage to get it done with this: LR = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row i = 1 Do While i <= LR If Cells(i, 13).Value = "FALSE" Then ws.Rows(i).EntireRow.Interior.Color = RGB(255, 0, 0) End If i = i + 1 Loop ws.Columns(13).Delete MsgBox "S&R finished", vbInformation +...

Well, my problem is that I have to visually mark it, otherwise the responsible person might miss it in the warehouse (happens very often). I am very thankful for your help, I am already on "highlight" thing, looking how to do it, and I will get back here soon with the progress report.

For the coloring, I thought about exporting the checkbox column. That would appear as True/False in Excel, then highlight all false and at the end delete checkbox column? After that, I could use an update to change it in tblItems.

Well, I have managed to get it with the search and replace (good call Isaac for idea about macro recording). Took me an hour to figure out that I have to include excel object library, but at the end there is some satisfaction when everything is working OK. Now to the most important part. I...

Isaac, thanks for suggestion. It works exactly as I wanted it to. Now, with wb declared, seems that there is more control over the entire process. I also don't have "save as" dialog when exiting Excel. Regarding the question about manual way, it was working perfectly (we have done it a million...

Thank you guys for your suggestions. As Isaac suggested, I started from exporting only, looked through several similar threads and I have something that is roughly working on the first segment of my question (exporting to Excel, and formatting first 4 columns as needed). I'm having little...

Thank you for your answers. Obviously I don't have enough experience with it. Will start as Isaac suggested, and get back here with progress.

Hello to everyone, I hope that all of you are in good health in these troubled times! I have a specific problem and I'd appreciate any help that I can get. I have an Access database and every day a result of specific query (stock level at the warehouse.) is exported to Excel. Due to the...

Very true. Maybe I mentioned that a bunch of stuff I had to do live, since time was an issue. I followed your first answer, found several links, and now it is already working (never thought of Dmax). Thank you again.

Thank you for your responses. Both of you have made valid and solid arguments. @Micron I don't have a problem with storing InvoiceNo directly into tblSales. It cannot create any problem in work. tblSales and tblSalesProduct are both used when customer is purchasing, so I can add or delete as...

First of all, I hope that all of you guys and girls are safe and together with your families. I do hope that we will all emerge from this corona thing soon. Now that we are inside most of the time, I started to play with our sales database, trying to remember what was done, how it was made and...

My mistake. It was place in lstCustomers OnClick event. Thank you for pointing that out.

Thank you, it worked. Could you please explain (if I am not asking too much), what is wrong with my line?

I have a select query that shows all orders placed during the day. The status of the order is "ordered". The query works fine, and it is placed on a form. What I have to do is to change the status of each order separately when the package is sent. I have created a column on query that...

Thank you both for your responses. You were actually both right, and I really appreciate both responses. Looks like this did the trick. It's placed on frmSales (OnCurrent event). If Me.Dirty = True Then Me.Dirty = False End If I will test it a bit more now.

Hello everyone, I hope someone will have an answer for the question that is bugging me. When I open Sales form and go to NewRecord in order to enter new sale, SaleID field (which is also AutoNumber field and a PK for tblSales) is blank. It says (New), and that is OK since nothing is entered...