Activity Stream

Bob, I first spotted it when I was on my tablet, but could not see how to copy the url on that. :( By the time I had worked it out, you had posted...

Thank you both very much for your help!

Thanks for the enlightenment Welshgasman I see that the OP often ends a post with the line: I doubt that I'll WASTE any more of it on the OP in...

Crossposted with solution...

Tables are for storing data, so I can't see why you might need this. Queries can be used to return data, so I would create a calculated field in a...

Hi Steve, Thank you for updating the database, analyzing it and inserting your sample sheets. I will take on board your other suggestions for...

There are 2 or 3 users that it seems to happen to more frequently, but it also works correctly for them just as often. Here is the code... If...

See Post #9.

I made changes to your dB - for a few tables, I renamed a few fields and removed spaces and special characters.(Should never use spaces in object...

Posting all the code for this operation might provide some clue. If this is always for the same user(s) that could be important too. I suspect the...

See if this helps

@gicu. Not sure I agree with your suggestion one license many users on Remote Desktop, unless things have changed my understanding is each user will...

Agree with micron, post all the code or provide a copy of the database with enough data to show an issue along with instructions to get to the...

In my second post I said posting pictures of code isn't that helpful. Since I can't read what comes before your recent pic (e.g. was db declared...

thanks. Isee why you say I should reference rs.fields("serial"). But, even hat throws an error?

Hi Louise, No Azure would still only be hosting the back-end only. You would still have Access as the main developer, and maybe the more permanent...

Create a new Access file and import the report and its record source which, if a query will need all of its source tables\queries. Then empty the...

Yes they could be potentially slower but with much bigger recordsets (thousands of records). You can do the same with totals queries and add them to...

Hi Rhi, To edit data you need to use a temporary local table (in the front-end) to hold the results of the unmatched query. What I usually do is...

Thank you , Gicu, Excuse this beginner's question: In this suggestion, where Azure has the whole of the database, front- and back- ends, would I...

This is a very large DB with lots of sensitive data. Not sure I know an easy way to do that?

Thanks Vlad, I'll try this with some modifications, for example I'll need to divide the total batch cost by average yield before adding on fixed cost...

Vlad, Thank you so much for your help. I followed your example and was able to get a count. The issue being, although I don't care which...

It's been a slow day Paul - half asleep.:o Puja welcome to AccessForums.net !!

An alternative that you haven't mentioned would be have the Azure BE with Access FEs for the main users and for the changing volunteers to have them...

Hi Micron: The action or macro is exporting the data from one of the tables to a .csv file and saving it to the "R" drive on our older tablets. ...