Search results

That's exactly what I've done. Usually orders are processed manually and these checks run when a product code or nsn is entered using the AfterUpdate event on various combo boxes. As I'm importing the data and can't use events, these checks can't run, so I have to essentially perform them...

Let me try and explain what I've done here in a bit more detail, please bear with me. (You'll see why I tried to condense/simplify) First of all, these orders are always, and will always be from the same customer. My order system comprises two main tables: tbl_orders and tbl_order_details...

I'm mostly interested in how others approach similar multi-query tasks, that all. Also, maybe I didn't explain myself properly, but I have a spreadsheet with for example, 100, orders on it, I need to run checks against each individual line hence why I'm running queries per row.

Not specifically, no, as my subs for this process are at 1,000+ lines at the moment. I was just simplifying for brevity and simplicity. The logic is sound, though.

I am currently building an importer that takes data from a spreadsheet and saves it into a temporary table, runs a boat load of checks and then creates firm orders once all checks are passed. My process is to save the data from a speadsheet in a temporary table, then query each line of this...

It's interesting you should mention that, as that's exactly the approach I've taken with this complicated process I'm currently working on. There are 5+ separate checks that need to be run that all have their own queries and trying to keep all that in one sub was proving to be a nightmare and...

That seems like a very obvious oversight on my part and certainly helps minimise the code somewhat, so thank you. :)

Morning guys, This is something of a general VBA/query/structure question as I'm interested to hear how other people approach this issue. When you're writing a typical VBA sub which requires you to do multiple queries, how do you keep your code well structured, organised, clean and tidy...

It's not there a under the list of controls in form design. I'm using Access 365 but my DB is an MDB - is this limiting my options?

No I haven't, but I will investigate that now. Didn't even know it was an option.

Thanks for the update theDBguy. I tried your script and still have the same problem I'm afraid. One thing I haven't mentioned is that my Access Database is running through Microsoft Remote Desktop on an Azure Cloud server. I don't see that this should make any difference to be honest, but it's...

There is a new version, I'm uploading one speficially to test for this issue as my users are reporting it. My tests are all failing. Going directly to the URL shows the new version. Going directly to the locally-saved version shows the old version.

That's exactly what I'm already doing but it doesn't seem to refresh the image and still loads the old version from somewhere. 'Get the URL of where the image would be if it's saved Dim str_url As String str_url = "https://www.MYURL.COM/catalogue/" & Me.cbo_product_code & ".jpg" 'Check if the...

Hi ByteMyzer I've been using this excellent script of yours and it works very well for the most part, apart from one small issue. Let's say we have image1.jpg on a web server and we capture that image using your script, save it locally then load it on a form in an image control. If image1.jpg...

That solved it, thank you. :D It makes little sense to me that it should have worked, but somehow it did.

Morning everyone. I have a complex query that's being generated by code in VBA. It contains various fields that are supposed to be output to show progress, for example: Despatched: 50/50 Delivered: 50/50 Approved: 40/50 The problem is, and even though I'm escaping the characters, the slashes...

Oh as simple as that. I'd already set focus, didn't realise that's all I needed to do. Thanks arnelgp :D

Is it possible to have a control - formatted as a date - have its datepicker popup when a separate button is pressed? Basically I want to put a date field on a form with a calendar icon next to it. When the calendar icon/button is clicked I want the datepicker to appear. I know you can just...

As the recordsource is a complex query (sales_order_status) made up of 4 other queries, it's not directly editable. To combat this I made txt_so_promised_date an unbound text field that AfterUpdate manually updates the appropriate record and the form is then requeried to pull in the...

See the screen capture below which hopefully demonstrates what I'm trying to describe a bit better. Capture As you can see, when I select record 28605 where promised_date has a date saved, the form queries just fine. When I try 29299 which has NULL in promised_date I get the error. Then when...