Search results

In the version I was demoing for @dalski it has a table where you can define the colors for the different levels and/or types of nodes. In his version certain nodes can be at certain levels, but are of a specific type like a comment, or bill item. These always have a specific color. Headers can...

I believe the problem is that you need to set your database up to support as a "self-sustaining economy". See example.

That would make sense as long as reference table of standard rates. If not that would create a painful data entry. Assume you have 100 standard rates and 100 companies. TblServiceRates requires 10,000 entries. Every company and every flat rate and special rate. But if you are just making a few...

@LarryE, I think what @Sketchin is saying there is a Company specific list of special rates. So if Pressure Testing has a flat rate of 100 (for most people) Company A has an agreement that they will always be charged 75 Company B may always be charged 80. So you need that table...

I am going to modify the names here to make it more conceptually clear. But you can use your names. In my mind the entity is a Service item which has a description and a flat rate. IMO a standard flat rate for a service is property not the entity. tblServiceStandardRates --ServiceID...

After you re-import your modules. In your code that references these variables what happens when you type "modVariabiliGlobali. " Does intellisense show all the variables you would expect? I exported this module. Deleted it and re-imported it. It compiled with no issue. My guess you have a...

You can use a MVF in several ways You can use an MVF control to filter a standard field or an MVF field You can use a multi select listbox to filter a standard field or an MVF field. Since you want to have lots of other controls in you search form I think it would be easier to use a standard...

See attached mvf search form. Thread 'MVF Technical Discussion and Uses (If you plan to Use Them)' https://www.access-programmers.co.uk/forums/threads/mvf-technical-discussion-and-uses-if-you-plan-to-use-them.334422/ Yes very doable, but other alternatives exist.

Conditional formatting can tend to treat anything like text. And vba will coerce comparisions into text on the right side. That would answer why "44.2" is greater than "230" So I would do the calculation in the query and return true or false in a calculated control. IsGreaterThan230: iif([do...

Not sure what to say. Either look at the demo or look at the very clear summary. One of four uses a subform.

I do not understand that question. On a main form you can have a an multiselect listbox and not in a subform. This demo shows that https://www.access-programmers.co.uk/forums/threads/form-design-to-allow-multiple-selections-add-your-ideas.334421/ Here is a listbox on the mainform showing...

As @Pat Hartman stated they do not want you messing with the table because in order to get the presentation of an MVF the hidden table needs to be very standard. The hidden table has specific field names and datatypes. If you alter this it could easily mess things up. I think they could of mad...

1. The MVF control maps to a normalized table, as I have repeatedly shown. Maybe you mean a visible table or a user defined table. 2. If they did make this "bound multi select listbox " the properties would be so complex that most users would have to use a wizard to figure it out. And even...

If that is what is happening then yes it is a memory leak. But from what I have seen, that is not what is going on in these things that you call memory leaks. More likely you create A and then you create B. Then you destroy A. The fact that B is still hanging around is not a memory leak that...

1. This is kind of Mark's whole point of this and the utility of his code and the reason for not using the OnAction. The on Action is a global call and can only find a public method in a standard module. It would be similar to going to the immediate window and typing that method in. It will...

I did look at this template to see if there was something worth using. https://www.microsoftaccessexpert.com/Microsoft-Access-Veterinarian-Appointment-Tracking-Database.aspx and although it is not super expensive I could build something better than that in 20 minutes. That looked pretty bad, at...

See example Set myBar = CommandBars("Custom") Set myControl = myBar.Controls _ .Add(Type:=msocontrolButton) With myControl .FaceId = 2 .OnAction = "MySub" End With myBar.Visible = True .OnAction = "MySub" not .OnAction = "=MySub()"

The OnAction command should be the name of a function that is public. = "dalskiHandle" not "=Me.dalskiHandle()"

Access is different than other VBA forms. When you open a form that is modal in Access it does not stop code execution in the calling form. The code keeps on running. Other VBA forms and languages modal usually stops code execution from where it was called. So that requery happens as soon as...

FYI. One form demos saving some data to text fields and the seond form is for the attachment fields. Make sure to open the attachment demo.