Search results

I just went into Data Macros and the interface looks the same as any other macro. In that case, you should be able to just click in the white space, then Ctrl + A to select all, and Ctrl + C to copy. Then, open a new one and Ctrl + V. You can paste it elsewhere to see the XML :)

What happens if employee time needs to be updated/modified? That happens all the time with timekeeping. Your stored values would be wrong.

What domain are the recipients on? Unless I missed it, you never specified. Are they internal, exchange server addresses, or are any of them external, like Gmail? That can really change things.

I have as well, recently.

Unfortunately SendObject can only send plain text emails. I do not know what happens if you couple that with a template that is Rich Text or HTML. Perhaps that is where the hangup is.

That's correct. Also, I wonder if there's something about the 64-bit version causing this? I wonder if 32-bit users are having the same performance issues.

I avoid all of this mess the following way: 1. Open main forms maximized 2. Access Options > Current Database > select "Tabbed Documents" and unselect "Display Document Tabs" 3. Access Options > Current Database > unselect "Use Access Special Keys", scroll down, unselect "Display Navigation...

I would still use an autonumber primary key field and make this custom field separate from that.

In your first sentence you stated you were upgraded from 2013 to 2016; later you want to roll back to 2016. I think you meant that you went from 2016 to 2019. If so, I'm in the same boat. A couple of months ago IT updated us all to 365 which is comparable currently to Office 2019. Haven't ever...

I had been wondering about this - that is a great tip.

I turned that option on years ago for a spreadsheet I manage. The main annoyance for me is you get an email every time the sheet is opened as well...that could be either annoying or useful, depending.

It's possible that you've done more harm than good by dicking around in the registry...my $0.02. I hope not.

I guess what I meant was that it shouldn't change how this code works. Sorry for the overly broad statement.

Reports are not editable. I think you are going to need to make a Word template, and use VBA code to instruct Access what to do with it. I have no experience with that, though others might.

Well to be clear, it's only possible with a "hack"...like the text box on top of a combo box trick. But the thing is a continuous form isn't really necessary for this design. He only needs to be working on one form at a time, so use a record list, then click one and have it pop up to work on it.

Try a full decompile and recompile: https://www.access-programmers.co.uk/forums/threads/how-to-tell-when-an-access-database-has-maxed-out-on-total-number-of-objects.310767/post-1684991 Access updates have no bearing on your VBA code except in circumstances of changing bit depth. Otherwise...

I can't vouch for it as I haven't used inventory, but there is a working example in the Northwind Traders database from Microsoft. Look in the templates, it may give you some ideas.

You cross-posted this here: https://www.access-programmers.co.uk/forums/threads/query-not-working-by-changing-field-type-from-number-to-text.311337/ And the answer several have given you is to link the Master and Child fields. Best practice is to link them with the Primary and Foreign keys...

I understand your goal and will say that there is a limitation within Access in doing this the way you describe. You can not "cascade" combo boxes in a datasheet or continuous form. That means you can't have a combo box filter a second combo box. The workaround would be to have all the combo...

Another option, unless you want more sophisticated graphics, is to use unicode characters. This would work in any version of Access.