Search results

When you go to login, the 2fa sends you a code to your phone (well mine does). You don't see the "send the code" button until you scroll down, and the number boxes are enormous. Maybe I've enabled accessibility options somehow. And a different thing, it's functionality rather than layout, but...

So there's an active structure in memory that would be de deleted/released by resetting the program. Wouldn't you get the same if you created a pointer to a remote table to maintain a permanent connection to the data. That would also be deleted on resetting the program, wouldn't it?

@BlueSpruce I imagine this is the sort of thing that if you don't know the answer might take a lot of time and resources testing to find out.

I don't quite understand. Do you mean there is no active event, but the program is still running and waiting for an event/interruption, (ie there is an open form) and therefore still won't allow certain code to be changed. The user would actually have to reset the program in order to make code...

But the forms opened by access will (should) work correctly as supplied, and will never cause a debug error. The prompt you are seeing must be caused because whatever you are trying to do is not compatible with currently running code. You won't see that by editing code while the database is not...

You even see things like this with a widescreen laptop compared with a square monitor. I was using the Coventry Building Society website, and it's clearly designed for a full screen monitor. On a laptop things are off the visible screen and it's not immediately apparent you have to or even can...

Let's say you have a problem with something when you move to a different record in a form. You will either have a current event with code, or the form/program will just sit and wait for you to do something. If you don't have a current event, the program can't jump into your code at this point...

You can set a break point to halt a program while the code is running normally, and the debugger will open and let you step through the code a line at a time. You can check the value of variables and so on. It's helpful for fixing hard to find problems. In this case you can edit the code, but...

I think if fixing the debug error needs certain code logic to change, then the debugger can't always continue, and has to close. Sometimes you can fix an issue, and sometimes not, in my experience. This is all part of testing, and developing a robust app that handles any circumstance without...

If the query for your form is not updateable, it won't allow you to add a new record, or edit an existing one. Is this a new/modified form?

I am not completely familiar with everything invoiced. Do the remote users not need any sort of special set up and/or training?

In passing, note that if the processing takes place at HO, but users are working from a remote location, you need to consider some issues. Namely, providing things like printing, saving output and providing integrated email and internet services at the remote location where those functions need...

Even if you use SQL server, you still need terminal services. If users are running the database at the remote location, they won't get an adequate response over a WAN. So they need to connect to HO and run on the TS at head office, assuming you still want some work to be carried out at the...

I always thought it was the same. It must be easier for MS to just produce one version and limit what it can do than maintain 2 different versions. I'll take your word for it though.

Ah, but runtime access IS full access,just not licenced. You can't run an accident without installing Access of some sort.

One other thought is "duplicating" your system at the new location, and running it as a separate standalone company on the same software. If you intend to merge the two companies into a single entity, then this won't be such a good idea, but if you want to keep them separate you then need to...

Because multi select anything is really not relational, more presentational. I had a system where selling prices were displayed in a grid with products as row entries, and packsizes as column entries. That's non relational, so I stored the data as relational, Rows with column entries for...

I think the difficult thing with web software is enforcing the time-sequential nature of things. The very way web sites work makes ensuring the logic flow of a commercial (database) application is awkward. Not sure what the technical terms are.

I don't think you can avoid that message with an unlicensed copy of access. You have to set the location/database as trusted somehow. You only have to click "yes" once on opening don't you?

There are some design changes that you can make in a accdb, but which aren't stored in a accde. For example, I think if you change column widths in a spreadsheet type form they don't get permanently stored in a accde. Error 2501 just means the form couldn't open, but doesn't identify the exact...