Search results

Why did you split this into two steps? You could also include the DogId in the Insert statement. If Reccount = 0 Then CurrentDb.Execute ("INSERT INTO tblDNAProfile (dnatestid, dnacategoryid, dnatypeid, DogId ) " & _ "SELECT dnatestid, dnacategoryid...

All your references to ResultPromote have a trailing space inside the square brackets. The square brackets make this space part of the Name that is being searched for. This control cannot be found and thus the error is raised. I believe, you cannot (and more importantly, absolutely should not!)...

None of the DAO.FieldX classes has an AttachmentCount property. - That's what the error message is trying to tell you. Isn't it enough to just check for: Not .....Fields("Sigend_Form").Value Is Nothing ?

Technically you can do that. But, as others in this thread, I strongly advise against doing so. You change the variables from being exclusive to the procedure they are declared in to global or module level variables, which can be accessed from a wide variety of procedures. Then previously...

Yes, that should work. It is generally advisable to copy the front-end to each user's local hard disk and thus give them their own file for exclusive use.

DoCmd.RunSQL "UPDATE tbl_Net_TicketDays SET " & [Forms]![frmBackground]![subfrmTickets]![txtTableFieldDay] & " = [txtMonday]" (Requires txtMonday to be in the active form, otherwise you will need to fully qualify it with Forms!...) Please note: This will update all records in the table! You...

I like this much better and I'm not aware of any naming conflicts, which of course doesn't mean much.

The name "Actris" conflicts with several existing company, brand, and project names. I recommend to change that name to avoid confusion and maybe even legal troubles.

Exactly. That's why you declared it as IUnknown, isn't it? It might even make more sense to not even do that but only store the reference to it in a LongPtr. - However, I guess then it's the developers responsibility to explicitly call AddRef/Release when appropriate.

I tried once quite a while ago. - I didn't have the patience to achieve success. On first glance, the code on MrExcel looks complex indeed, but I fear this is what is required to make it work with pure VBA/API.

I doubt this will help. The problem is not the hostname of the server, but the IP addresses of the clients used for restricting access to the MySql server to known hosts only, - Is this correct, @nector ? Even when using dynamic DNS services like DYN (formerly DynDNS), a reverse DNS lookup of...

When would that happen? If you define the data as an array of bytes, I don't see why it would change to a different data type without you doing it in your code.

The Backstage XML works unchanged even in the newest versions of Microsoft Access. However, someday in recent years, I believe in 2021, Microsoft introduced an entirely new screen to the Office applications; the "Home" screen. (The "Home" screen is different from the "Home" tab in the...

JFTR: VBA does not have garbage collection. Memory for object variables is released based on COM reference counting.

Ok, I misunderstood this, but ... ...actually... I don't think this is a good idea. And I think, you will agree... On my computer a .jpeg file will open by default in an application, which identifies itself as Photos.exe. Now look at the registry key you were referring to:

@KitaYama and @cheekybuddha, I get the impression that you completely skipped an important step: How do you know that Microsoft.Photo.exe is actually the application the user has configured for viewing these types of files? I really wonder why nobody pursued this approach, which, in theory...

@KitaYama , did you notice that the backslashes in the path were replaced with the Yen currency symbol in your screenshot?

...which might also include picture viewer applications the user started independently of the Access app. dllhost.exe may run an wide variety of DLLs for a wide variety of purposes. Not necessarily. See #6.

Good approach in theory. In practice there might be a problem.... The default picture viewer, as defined in the Windows Registry, will often be: %SystemRoot%\System32\rundll32.exe "%ProgramFiles%\Windows Photo Viewer\PhotoViewer.dll", ImageView_Fullscreen %1 However, the actual running process...

Trusted Locations are per Office Application. So, it will not work to use Excel (or Word) to define a Trusted Location for an Access file.