Search results

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

Take a look at Twin Basic. You could create an Add-In that helps with some of those. However, I do certainly believe the VBE is outdated as hell. VBE > Code folding: collapsing blocks of code > Multi cursor: editing multiple parts of the code simultaneously with the same keystrokes > Listing...

Maybe the referencing is done differently in those cases. If you have any sample, I could check it out for A2016 and A2021.

Yes, I understand you want to show the associated files somehow in your report. I've never used the feature you mention, but I've known some have managed to show Word and PDF documents through the browser control. But since the browser control seems invisible in print preview, I suggested the...

Maybe take a screenshot programmatically and replace the web browser control with an image control that shows the screenshot. Just an idea.

You could have 3 tables: facilities, inspectors and inspections. Storing the entire checklist in the inspections table, though unconventional, may actually be a viable solution. While it might seem like a sacrilege, validly, the reality is that many inspection lists rarely change. In fact, some...

Let's say that button's click event code looks like this: DoCmd.OpenForm "FormName" You might have other stuff there, but it seems you want that form to know who called it. One strategy is to pass the name of the form through the OpenArgs parameter of DoCmd.OpenForm like this. DoCmd.OpenForm...