Search results

The hard bit is eliminating weekends, and especially public holidays.

It became harder because initially MS Office was installed as 32bit by default. Now it's installed as 64bit by default although 64bit is rarely necessary. The easiest solution might be to get your client to re-install 32bit office. If they need your solution badly enough they might do that.

Seriously as a developer you most likely need to offer both environments. It's one thing having a 32bit database. Converting it to 64bit may be relatively trivial, but it may also lead you to real problems, if you've used tools that haven't been ported to 64bit. I'm pretty sure there's more to...

Part of the problem is that there's some really useful functionality in the bits you are trying to hide. If you don't want users to see them, and you still want to use the functionality you have to programme access to do the same thing, and most likely you won't do it as well as MS did it.

Yes, it does seem faintly ridiculous that you don't have a record of emails you have sent. What if you wanted to check the list of recipients?

I would open a code window, and try to compile the project again. It's hard to see why you can't create a .de file unless there is a compile error. You don't need to have option explicit in order to compile - that just forces you to declare any variables before you can use them..

Thanks @GPGeorge I actually use Everything Access VBMapi rather than use outlook directly. I'm unsure whether that will still work with New Outlook. I have also used CDO, but the problem there was that it doesn't put the outgoing message into your outbox,. All you seem to be able to do is...

I went through the code carefully this morning checking everything, and found that some users didn't have the right settings to make the access/outlook integration worked. I tried fixing that, and everything seems to be working again.

I wasn't sure if an anything had changed. Thanks for the replies.

Can anyone confirm and circumstances in which access can no longer send emails via outlook. Would upgrading to Windows 11 cause an issue? Would clicking "activate new outlook" cause an issue? I just want to try and identify any likely causes of access no longer sending emails correctly.

You might get that sort of error if you have no records, and a non updatable record set. In that case, all variables are undefined if you will. Is that possible?

Take backups before trying to fix it. You need to get all users disconnected, then try a C&R. There was a spate of this several years ago, that I don't think was ever really solved.

In the code line you posted it has SAddresListName with one s in address. Has that been changed somehow?

Yes, you don't want unhandled errors but you might need to react differently depending on the actual error, and that is much more difficult to handle, and identify report and resolve the true cause.

Error handling is not as simple as merely making sure that there are no unhandled errors. Some errors might indicate a dangerous/catastrophic problem that can't be simply recovered from.

You aren't using a laptop and accidentally moving the mouse with the touch pad, are you? Also mouse behaviour gets erratic as battery power wears out. I get those issues from time to time, although I don't get forms being corrupted without realising it's happening.

What on earth do you mean by the above? Are you trying to say you have a master table for persons that appear in other tables? I think I would rather have the duplication by having the same person appear in more than one table, without the master table at all.

The thing is, do you want to remove an item from a combo box, or remove the item from the database altogether? These are different things, solved in different ways.

Am I not right in thinking that merely adding ptrsafe does not guarantee that the code actually works correctly in the different environment? It may depend on what the function actually does.

It goes back to consideration of your processes. When you say "update an invoice details", or "update notes on a job". Well I imagine the notes should be in a notes table, not in the jobs table. The invoice details should be in an invoice details table not in the job table If you normalise...