Search results

I recall having used the count of properties somewhere to determine the kind of thing I'm dealing with, so yes, that and other things are mutating as we use them. For example, I created an unbound form with nothing in it: properties count is 250. Now I created a bound form with stuff...

An example of how to set a property for a database and how it appears in the debugger. Posted because because you wrote this: Multiple things allow adding properties. It can be checked with the object browser by searching "properties" as search term. I can see the following, as examples...

You mean something like this? Sub asdasd() Dim prop As Object Set prop = CurrentDb.CreateProperty("CustomProp", 1, False) CurrentDb.Properties.Append prop End Sub

Recuerdo que hablas español. ¿Entonces tienes campos vacíos en la columna izquierda? Si es así, ¿Qué quieres hacer con esos campos? 1. Asignarles un nombre genérico 2. Ignorarlos y pasar al siguiente

If I understood correctly, you have one table with two columns. First column has the names of the merge fields Second column must have the merge fields If so, try the following: Sub AddFields() Dim t As Table Set t = Application.Documents(1).Tables(1) Dim i As Long For i =...

May I suggest you simply go ahead and do the following? 1. Open the VBA IDE 2. Go to View > Watch Window 3. Right click > Add watch 4. Write "application" in the expression input box and keep procedure and module to "All Procedures" and "All Modules", respectively 5. Expand the resulting...

It could be as simple as this: Sub CopyVersions() ' Version1: delete query1 and form1 CreateObject("Scripting.FileSystemObject").CopyFile CurrentProject.FullName, CurrentProject.Path & "\Version1.accdb", True With CreateObject("Access.Application") .OpenCurrentDatabase...

Open the form in design mode. Then, go to Properties pane > Data tab > Record source property There should be some string in the Record source property, that's what your table is bound to. What does it say?

Thanks for the testing, Colin Here's another approach, it also hangs the Access app if the report is too big but, in return, it won't show any dialog because it runs in another instance as I was previously hinting. The code looks like this: Option Compare Database Option Explicit Sub...

I leave you with a playground file, if want to test, just open form1. I tried adding a DoEvents command in a few places of the code, but it did nothing in my tests. You could probably find where it should go with more precision. Here's what my playground setup does: 1. Open form1 2. Click on...

I tried by hiding the window using Win32 API calls and it does hide the printing dialog but it blocks you from doing anything else while it's running. After that, I ran a few tests and I think it could be possible to run the export from another instance of the application to avoid dealing with...

Yes, it's possible. These are two options for you in the context of MS Access: 1. Provide full version and limit it based on something. 2. Provide parts of full version based on something (this is what you're describing) BUT... I would keep this in mind, though: What if two teams with the same...

You could implement pagination in your class, but I understand: you have lots of data that shouldn't be brought at once. It does not even have to be pagination though, you could simply limit it to a few records that meet certain criteria. But it's a choice you've made, I also get that. If I...

Excellent example, that is indeed a valid reason. Thanks. I'm still open to knowing other reasons, but I can see the use in that.

Appreciate the clarification, but I still fail to see the justification for opening a recordset without records. While I understand the intention behind it, and thank you for that, I'm still trying to think of a valid scenario where this makes sense. Since others seem to use this approach, I...

Could you elaborate on what specifically makes your form unclear, forcing you to clear it? Is it based on a temporary table, or does it hold data in memory? Can you elaborate on why flagging a record as emailed wouldn't be a better fit? Is there no record about the email being sent so that your...

You negotiate the scope of the work and tell them what can and can't be done based on their budget. You could create something that lets them create their own tables and forms if that's what everything and anything means for you. But I suppose it's something along the lines of building a...

I gave it a shot and created this module: Option Explicit Private Declare PtrSafe Function SetWindowLong _ Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As LongPtr, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Private Declare PtrSafe Function GetWindowLong _ Lib "user32"...

Subforms don't, but the form inside them does, using that handle the OP can fade their form. But there is no sample code from them to test it.

Let me know if you need some help.