Search results

That is where we are going in our company. We use SP but mostly as a data repository and navigation tool. A lot of the entry and edit is a custom Power App. Instead of views we use a lot of BI for viewing the data. This way the user is not touching a live list. I do not know if that is your...

I bet People displays a person name, but it is pulling data from the exchange server so I bet it is actually storing some kind of exchange ID. So I would think it is a kind of lookup field.

Here is another example. You say you have nine tabs now. But maybe this could grow to 15, or 20. If that is the case you can add 20 tabs now and then configure the ones you use at runtime. It could pull this data from a table. In this example a law firm has a different number of partners...

I would try testing it field by field. See if you can just add the title. If that works add another field. If that fails try adding a different field. I would think this would work even with a lookup in the table. I will tell you the default fields "Title" and "Description" always seem to...

I have the subform hanging over the tab so you can see what is going on. If you make the tab wider then it appears on the tab.

You can take a subform and put it in front of the tab, not on a page in the tab. It will look like it is on the page, but since it is in front it will seem as if it is on all pages. Then when you change the tab control all you are really doing is modifying the source object. The other way is...

Yes you should have one and only one form. In fact I would go further and say you only have one subform too. What is the parameter? is is a filter?

Update Query One common statement about MVF is that you cannot easily update them. However here again the update is exactly how you would do it in a traditional design. Like the other examples the hard part is understanding the hidden table. 1. The MVF Region field is a numeric storing the...

Union an MVF The question was asked here if you could union an MVF. https://www.access-programmers.co.uk/forums/threads/error-the-multi-valued-field-cannot-be-used-in-a-union-query.327050/ If by now you understand that an MVF if not a field but a display of a hidden table, then unioning an MVF...

You have a public variable myUser defined in two places. Defs and Defs_old. You cannot do that. Remove Defs_old

I am with plog, that make no sense. The only thing I can think you are trying to determine if that date already exists. If you are then there are easier way. if Dcount("*","qryWeeklyForecast", "LDOW = #" format (me.Ldow,"mm/dd/yyyy") & "#") > 0

From what I have seen, there is 1 and only one! You are looking at it. I have seen thousands of examples on this forum and other forums of inefficient designs. I have never thing anything even 1/100th of the purported scale of inefficiency. Everything else I have ever seen, you could help the...

I did not say there was not normalization problem I said it was not as much of a problem. 1. The OP probably does not have a lot of forms because the tables are not normalized, they have a lot of forms because they have multiple tables doing the same thing. Expense are expenses. Do not need and...

I find it funny that anyone would not want to use VBA over macros now a days. Since you do not have to write it yourself. I can ask chat to write pretty complicated things in vba and it comes out pretty complete. Maybe a little tweak if I did not ask the question well. It is faster for me to do...

Converting MVF to a Standard Junction / Child table. One concern about MVFs can be alleviated because if you ever want to convert it to a traditional junction table or child table, it is extremely simple to do. For example if you decide that you want to convert to SQL Server or another RDMS or...

If I provided assistance, I do not remember. However you can simplify the function a little. Public Function getParentForm(callingCtl As Access.Control) As Access.Form On Error GoTo errlbl Dim ctl As Object Set ctl = callingCtl.Parent Do While Not TypeOf ctl Is Access.Form Set ctl...

The before and after the collection is irrelevant. The inside and outside the loop is. Think of decorating Christmas Cookies, where you use a cookie cutter to cut out a christmas tree cookie and then decorate it. Think of this line Set dalsObj = New clsDalsTxtBox as creating a cookie with a...

Oh I see. You simply need one of the many available applications with the following 1. low code, no code application 2. supports unstructured data including free text 3. Allows development of graphics and speech based GUIs without code 4. Flexible to allow continuous additions 5. Design...

I see it now Private Sub Form_Load() Dim ctrl As Control Set mColRcControls = New Collection For Each ctrl In Me.Section(acDetail).Controls If ctrl.ControlType = acTextBox Then Set dalsObj = New clsDalsTxtBox dalsObj.fInit ctrl mColRcControls.Add dalsObj...

First look that looks correct. I will test in mine to see if I am not seeing something.