Search results

WiFi isn't good at maintaining the type of connection Access uses (SMB Protocol), so there will be a lot of behind the scenes connection renegotiation. Most WiFi setups are also designed to save power out of the box, so continually scale back things silently as well. This ultimately can lead...

The easiest route to do this is to take what yon need the All from (The courses) and then left then left join it bac to the people/courses query, something like (I cant work out your table names, it looks like you are missing a courses table? ; SELECT Course.*, CourseCount.CCount FROM...

Right Joins are seldom if ever required, as they effectively are the same as a Left join, just with the precedence based on the Join order. It's quite hard to see what you are trying to achieve without some sample data and your expected results, but suspect you really want to use a window...

We saw The The in London, September last year, having been a fan since the mid 80's as well. They were excellent, and Matt Johnson still knows how to hold an audience.

Yes - that's how it was set up, just a snapshot of when, what, and parts fitted.

Does anyone use tables anymore? I thought ChatGP stored everything....

I used to do this for previous repairs - a small list box with the previous job numbers and dates, most recent first. You could select any previous repair and see a pop up of the main repair data without leaving the current job.

Welcome Alessandro - I've followed you on linked in for a number of years. Ciao!

I think it depends on scale and number of transactions. If you are only dealing with a few hundred stock movements a month, then you should always calculate. If you are dealing with tens of thousands then I would probably have a routine to calculate and store it, to keep processing speeds...

It will be something to do with the report section settings (header, footer, detail, etc) , possibly force a new section/page after ... You will need to fiddle with all the settings to find it I'm afraid. You can tell in print preview how many pages it will be using, so try layout view and see...

Have you made the folder the Access database is in a trusted location?

I'll chuck my 2pence worth in here, as I had to deal with FIFO pricing for COGS at a previous place of work, and it's an unmitigated PITA. If you can possibly avoid it I would. From memory, we eventually manage to talk them into doing average cost based on stock held and date based purchased...

Possibly a daft question, but what format is the data in that you have downloaded?

You also need to add the form reference to the second instruction: Me.RefundSearchSubFM.Form.Filter = FilterSTR This >> Me.RefundSearchSubFM.FilterOn = True Should be Me.RefundSearchSubFM.Form.FilterOn = True

Just to chuck my 2p worth in here, in my experience CF definitely works more slowly on Azure SQL linked tables than Access ones. I have improved this sometimes by setting display "flags" in the views I connect to and using those to control things less intrusively than CF.

That would suggest (rather obtusely I'll admit) that Me.[Contact ID] is null. After you set strWhere add the following line Debug.Print strWhere & " " & IsNull(Me.[Contact ID],"Its Null!") And see what you get in the immediate window. (Press Ctrl + G in the VBA editor to make it visible if it...

I looked at in anger properly about 5 years ago. I didn't find it very intuitive, but I could see how an untrained user could probably get something useful from it depending on their ability to "click and see what happens" as the desktop version UI (was) is quite user friendly. IMHO, it...

What's the error being reported as ? A clue would help. Also can you edit that and put it in code tags (Press </> option in the editor and paste it in ) Edit : if you can Indent it and format it a bit better it might be more readable within the code tags as well.

Some Providers will provide static IP but remember it will only be for that site. A VPN can do this but will still only work for one site at a time, if people are using mobile hotspots, they would (I think) need to be connected to the same network/VPN.

If you brought all those fields into a Product combo box, (hidden from view) you could simply display them from the hidden column directly, no need to fill out that data separately at all. If the product description doesn't ever change then you don't need to store it on the order, you can...