Search results

Bulk updates are not used here, except by me. Everything else is single record use only. I don't want two users changing the same record at the same time - this could cause problems. Each record is edited by a form, so when the user is done, they close the form. So far, I have not had a...

@ridders: That is very cool! thanks. @arnelgp: Are you saying that I should not set the Record Lock property to Edited Record in the form? Won't this allow another user to edit the same record I am?

Update: I logged off all users, copied the backend to my desktop and a backup folder, deleted the server copy, ran a compact and repair, and tested. The issue with those 4 records is gone, however, another issue popped up. This time, one field in one table refused to take data. I disabled the...

Hello all, The form in question opens from a click event on another form - showing the details of an order, with a subform that shows the line items. Everything has been working fine until today (about a year or so). I have 4 records that I cannot edit. When the form opens, it checks who the...

I haven't found any free form resizer code. If I remember correctly, the code i found was a little pricey, but it's been quite a while since i looked at it. I will check your other recommendations out. References checked: Prog B VBA MS Access 16.0 Obj Lib OLE Automation MS Off. 16.0 Access DB...

Oh, yes, these are network shared backends. The other odd thing (that i forgot to mention) is that he can open program A then B without problems. But, if he opens B then tries A, we have the problem. I checked that task manager, all seemed ok. One other tid-bit that may or may not have...

Hello everyone, I have a user that has a problem opening an Access database after another one is already open. The second program does not even seem to load, all I see is the hour glass symbol, and nothing appears in the Task Mgr. They are separate programs, separate backends. Both make calls...

I think the highest level is 13 in clash royale. I'm at eleven now, and still looking for that perfect deck. clash of clans you can get way up there, i don't know what the top level is, but it's over 140, and I think the town hall level tops out at 13.

plog: the first time i did not document the process well enough...but this time will be a bit different. Pat: interesting idea with the dup field. It sounds like part of that process would be manually checking each box if it's a duplicate. What about using recordsets to check for...

Yeah, I can see why companies charge so much for data migration!

CJ: nothing about this seems easy, lol. Pat: how would I go about cleaning the data through an append query? Are you talking about normalization or extra characters or duplicates? The problem I have found with duplicates is that I don't have an easy way to delete them -if I use the query wizard...

Hello, I’m working on this program (Requisition program in access) that is replacing an Excel version. I’ve posted various questions related to this project already, but this is regarding the Excel program. We keep a history of parts and supplies in Excel (and now Access). I’ve been able to...

Oh, I see. I missed your point, lol. Thanks.

I see your point. I think we can live with using an accdb file, which does not require trusted locations. However, in the future we may need to address this, depending on which way this project goes - either a new access database with multiple back-ends, or SQL server with Access/C# front end.

It looks like I can operate without the runtime version. It seems all users have the full version of Office, so that leaves me with securing the accdb files. Doc, currently we do not use a web/browser based system, though I am looking to move in that direction with SQL server as the backend...

That is interesting. Someone (in some post i read) said they did that and it didn't work...so, being the smart developer I am, I decided I didn't need to check that...Well, after deciding to re-evaluate my "smartness" seeing your post, that is what I needed to do, lol. Thanks.

After reading a couple of threads, I have the idea that to deploy a front end with some level of security against tampering, the runtime version should be used. However, I am left with dealing with a security warning from Windows every time I open it. To deal with this, it seems I need a...

Well, this problem has not been solved, as it came back, only "breaking" at a different location. See link above (CJLondon's post) for continued discussion.

Thanks, CJ, was just going to post that thread today. And for this group here, I apologize for not letting you know that I also posted on another forum, as one of the members there advised me forum etiquette.

Ok, Doc, let's see what kind of bone I can find. Broke/breaking - as in using a stop statment at the entry of the event sub routine, like a red code break for debugging. Access 2016 not sure what you mean by private or shared... split no external application. Does this have some meat to it?