Search results

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.

Web browser controls do it. You will have to code it yourself though. The link in post #11 will take you to an example you can adapt. If you only require one level, you have a few options, such as: 1. Report embedded in report 2. Subform height programming 3. Section height programming If you...

Install Visual Studio. Add a new project. Pick the Excel VSTO Add-in template (for Visual Basic) or whatever looks close. Add some controls: add a ribbon, place some groups and controls in it, make them open custom task panes or forms. Add your VBA code. Convert the incompatible bits to VB...

I suggest writing a VSTO addin with the code that you want to protect there. There are way too many ways to bypass all forms of security in Excel. I remember one time some user simply exported a sheet in some way, he might have copy pasted something and the entire VBA project was there. But the...

Here's a version with master/child links instead

Check the attached file. I don't know your database structure, so I assumed there was a table with roles. That table feeds the combo box. The report's recordsource has a foreign key to those roles, so the filter simply filters by that Id.

Create a form Add a combobox to that form Add a subform control to that form and place your report there Option 1: Have the recordsource of the report read the dropdown content Option 2: Have the dropdown write the recordsource Option 3: Add a Filter criteria to the subform and then user...

How are you filling those textboxes? I suspect you just need to put that code in the form's current event.

Don't worry about the limits of AutoNumber keys at this stage of development. Just remember, your operating system and a bunch of apps (like Access and browsers) are running fine while you’re working. A column of numbers managed automatically by your database system isn’t going to cause any...

Here's an adaptation of a WIP of my Tree Grid using IE7 in the good old web browser control. It only requires a reference to MS Internet Controls and MS HTML. It has a tabular layout. For it to resemble the rest of what you want, it would require a few extra columns in the data array, extra...

A few tips: 1. Use autonumber fields for primary keys, you have tables without it. 2. Add a sort column for order control, you can calculate the current maximum Sort value in the filtered dataset by adding 1 to new entries using the default value, for example. This ensures items are inserted in...