Search results

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...

Just to elaborate on Doc's point. Type L in the command bar, click on two spots: you have a line Type L in the command bar, write the coordinates of first point, then the coordinates of second point: you have a line Type L in the command bar, click or write the coordinates of first point, then...

Hmm theRecordset.Fields("FieldName") ✅ ------------^dot---------------- theRecordset("FieldName") ✅ theRecordset!FieldName ✅ theRecordset.FieldName ❌ The default member of a Recordset object is the Fields object, so it can be bang'd.

I'm afraid there are many many more ways to do your references, here's a list of some: ' DOTS Debug.Print Application.Forms.Item("Main_f").Controls.Item("Project_Menu").Name Debug.Print Application.Forms("Main_f").Controls("Project_Menu").Name Debug.Print...

The default color is 0. More on colors: You can get and set a palette of colors using ThisWorkbook.Colors(index), where index is a number from 1 to 56. If you have not set them, you can use the colors loaded by default in there, they are bright and nice. You can view the colors with something...

Yes, it was possible at some point. But after some update ALL of my folders had group by modified enabled by default and setting the group by none to all folders would not persist. The folders would go back to that grouping option again on their own.

I used WinSetView for the issue of having all my folders Group By Modified Date as default. The rest of the annoying defaults can be modified in other ways.

Yes.

Hi. That's not related to the SQL code I posted. You have something set up incorrectly. You could make a new thread for that. Get ready to post a sample database, because it'll be easier to figure out that way.

It does not seem like you're using two different forms, so why don't you just modify the SQL statement for cboSiteTitle to: SELECT CustomerSite.CustomerSiteID, CustomerSite.SiteTitle FROM CustomerSite WHERE (((CustomerSite.[CustomerID])=[cboCustomerName])); You could do that because both...

In my opinion, nobody learns classes by not writing classes. To understand what classes do, one must actively write them regardless of others' views on their purpose. Additionally, classes aren't always designed with reuse across projects in mind, if instancing something makes sense, then you...

You might not require Reminder_Date. Since Reminder_Date depends on Due_Date, Reminder_Date could be a calculated field or it could be something a form or something else takes care of by looking at Due_Date.

Strategies in order of convenience: 1. Log sessions in a table 2. Log sessions in an external file 3. Log sessions in a registry key 4. Log sessions on the internet The idea is to make the count of sessions persist. Once you choose a strategy, choose when to store the session. For example, you...