Search results

My company does this if you are happy for your backend to be migrated to SQL Server. Spoiler alert: monthly per user charge.

vOpenAt = "C:" Set ShellApp = CreateObject("Shell.Application").BrowseForFolder(0, "Please choose a folder", 0, vOpenAt) strFolderPath = ShellApp.self.Path Try this.

It was called the Data Dog, because it ran around burying bones in the data, and then when the bones were all buried we went thru and dug 'em up.

It reminds me of a Treasury department job I had in a bank where there were many classifiable reportable transactions coming in from all over, and we had to do a very similar thing. I added five new booleans to the input data, and we ran five big queries against it. We scanned the data set of...

Your description is interesting. You know what I would be tempted to do? After importing the data, run a big wide query against it, including if possible all the fields from all the tables that you will be checking - that is, link in the products and stock, supply windows, prices, original...

Also FWIW, where the task is very complex, as yours seems to be, consider your main sub to be just an index or ToC for the work you are trying to do. This is easier where the main queries are snapshots and you can confidently pass the variables into other subroutines. So for example Private...

This is a very complex area, and one option would be to get the C# version of the above library, and create a DLL that will format the numbers correctly. That might be daunting for you, but possibly a straightforward task for a helpful colleague, if you work in a large shop. And before you ask...

You might be able to get a clue about this by going to the microsoft doco regarding the Kerberos Configuration Manager. If you have a spurious SPN on the server, then there are ways to fix or remove it. I have zero-raised-to-a-mighty-power experience in this, but a download of the Kerberos...

Ah, ok, I was setting it in the Mousedown event and expecting it to display. In fact, you have to change the pointer before the mousedown. Got it now, thanks Kita.

Thanks. Hmmm ...

Hi, Once upon a time, Screen.Mousepointer = 7 would change the cursor to a double-ended arrow, but it seems to no longer do so. In fact, it does nothing at all. No error, no nuffin. If I put Debug.print screen.Mousepointer on the next line, it shows 7 in the immediate window, but there is no...

Yep, you have a two dim array created from "SELECT HorseID FROM tbHorse WHERE ... " etc So the array has: dimension 1=Fields (there is 1 field, HorseID, so the ubound for that dimension is 0) dimension 2=Rows (there are .recordcount rows, so the ubound for that dimension is recordcount - 1) The...

Hey CJ, I think you have an extra 'Me' in there ... Me!AbteilungFunktion.Form!Abteilung.Form!AbteilungCboBox = Me.MAF_AbteilungsID

Sometimes well documented RBAR in VBA can be great in a DB that is going back to an SME who has NFC.

Azure was fine last time I used it, conversion and upload is easy. But not fast enough for POS I wouldn't think. As arnelgp has suggested, you could download stock/barcodes/prices to a local table before starting each day. If your users via the internet need to access a local stock table at POS...

The OP is quite right. He is talking about design view, the cue being his reference to the button wizard. When you create a continuous form, and drop a button on it, the button wizard opens. If you then add the continuous form to a main form as a subform, the behaviour is different. If you drop...

You note that you can't link the subforms because the main form is a cross-tab. I'm not 100% sure what you mean by that, but you can master/child link a subform to any main form. The link uses the value of a control on the main form - it doesn't matter what the data is (the main form doesn't...

Hi, I'm about to create an Excel addin, and would like to deploy as an Excel task pane addin rather than a VBA xla. I prefer this path because it makes the code more secure, the pane is a great UI that will provide guidance for users, and it will run in Excel without needing to download and...

I think, of the top of my headlights, that it should be Dim ctr as Control

So this would be one (very quick) way to do it. Add a new column to the table with the surcharges: For the FET record, the new column would contain: oft/faf/doc/hcs For the TAT record, the new column would contain: oft/buc/psc/pss/thc For the EXW record, the new column would contain: oft/faf/buc...