Search results

One of my tables has "disappeared" in the query builder. You can see the link going to the table and you can see the yellow highlight of the table being selected, but it seems to be reduced in width to zero, so I can't grab it to move it out to the right. Anyone got any suggestions, please...

Ah. I see. Sort of. I see not to do it again, anyway. What is now going to give me sleepless nights is wondering how many other times I have made that mistake in other dbs over the past couple of decades or so... :eek::eek::eek:

Doh! Ok, thanks, that makes sense. Should probably be using a select case anyway. So what I effectively wrote was: If 55 then... Question is why does that trigger the if clause? What is the code deciding equals 55 to meet the criteria?

I have a form that allows the user to appoint members to various positions in a club. If the position is of a certain type, then I want the code to do certain things. For some reason, the code is running regardless of the position This is the relevant nugget from the beginning of a very long...

Hi, from the way I’ve interpreted what you said, I don’t think you’ve got the structure quite right yet (although you, of course, know your business better than me). I would be looking at a structure more like the attached: You will need tables for: your contractors, the services they offer...

Fired up my working copy of my db this morning, whole reams of code have vanished... :eek::eek::eek: Entire forms now with no procedures. There yesterday, gone this morning. Fortunately my backups are ok - but what the heck...?

To be fair, "Doc Man" does sound pretty super-heroish...

Before you can get on to forms, you need to work out what tables you're going to need to store your information. You'll need a table for your client companies. You'll need a table for your client companies' employees. You'll need a table for your contractors. A table for treatments offered...

If I wish to believe you're all super-heroes, stop shattering my illusions...

Hi. If I may offer something from the perspective of another relative beginner - and in order to manage your expectations a bit here, whilst it seems from what you say above that Access would be perfectly capable of handling the task that you envisage, actually making it do so is a lot more...

Thanks for all the answers. Can anyone please recommend a good easy-to-follow guide to how to get going on setting up a mySQL backend for my Access Front Ends?

Thanks. Which will be easiest for a neophyte to learn how to start using for the BE (keeping my Access FE as unchanged as possible)? (Small applications keeping only a few thousand records and probably never more than a dozen users at it's highest, normally probably only a couple)

Would they be quicker than sharepoint?

By that do you mean that if the BE was closed, changes I made via a directly-linked FE would not be uploaded to the sharepoint tables, until I opened it manually and synchronsied them? If so, I think that that would not be an insurmountable problem. The other users use the db infrequently...

Heh. The only reason I might not want to send my code out is to stop people from laughing at me...

Hmm. This could turn into something of a circular discussion. I can only go back to "it really isn't always that simple" (although, of course, it may well be to access experts, but that's slightly different…) In a situation where I have an incredibly complex series of relationships which...

I have an FE/BE db linked via sharepoint tables. It works, but it is really slooow. Usually a pause of several seconds for every form change, every data entry, etc. After a while, every second seems like an eternity. (It's slow everywhere, but this is really compounded by the fact that my...

I wish it was that easy... :( My DB is relatively small, only a few thousand records. However, it is all about relationships. It stores information about people, organisations, positions and regions. People can have positions in regions, organisations, clubs, sub-regions; clubs can have...

As far as I can tell, moving the code into the on format event appears to have resolved the problem - although I will have to do some extensive proof-reading to confirm that for certain. Thanks a million, everyone. :) You are all awesome as always :)

I will try the on format event, thanks. Difficult to replace the data when it's pretty much all contact details, therefore GDPR sensitive.