Search results

Ahh... No. All you are showing is a bunch of hard wired events procedures. So what? Not even related. The point was to handle of multiple events without writing multiple Event Procedure. More apples and oranges. Now I am confused why Dalski would give you a thumbs up, because I cannot see...

You will have to pull the thread on that one for me because I am not seeing it. The OP wants to trap the right click on a mouse down/up for multiple controls. This one is complicated because the event procedure requires parameters to be passed from the application Private Sub...

I assume you question is can you apply some settings to control what the wizard does. Probably not easily. The wizard uses a complex formula based on field data type, field size (i.e short text 10 vs short text 255), page width, printer settings. Does its best guess to make it close. The only...

So now you got me kind of leaning back the other direction. I have experience using simple numerics and ensuring the data integrity at the form level. I know that works without any issues. It is all these downstream limitations of a lookup field, I do not know.

That is kind of my thought, but sometimes I just do not know what additional baggage the Lookup field brings. I have started from the other direction and had a working access database that I moved the BE to SP. Because I had the data already I did not want to change all the foreign keys to...

I am sorry but this is 10 times funnier, because it is two completely unrelated topics. This is such a complete "apples and oranges" comparison that it makes no sense at all. Have you not been following the conversation? Explain again how the tag property will replace the capability of a...

Here is what the right click would look like. Form Private WithEvents RCTBs As RightClickTextBoxes Private Sub Form_Load() Dim ctrl As Access.Control Set RCTBs = New RightClickTextBoxes For Each ctrl In Me.Controls If ctrl.Tag = "RC" Then RCTBs.Add ctrl Next ctrl 'MsgBox...

Here is another approach that I have been using for years. I find it very intuitive, easy to use, and mirrors how you do things in Access. I am not disagreeing with Marks approach, but that is not how I would do it. The concept of the strategy makes sense to decouple the processing from...

The lookup and multivalue fields where needed by Sharepoint because of limitations in not having any real forms. You simply had a list. Now a lot of people are doing their data entry with PA and data visualization with Power BI and only using SP as the repository. If you are not reliant on SP...

In SP you can create a lookup field and allow it to pick and store one choice, or you can have it store multiple choices. Using a multi value lookup it will show multiple choices in a column. So you would have an issue and a column with 1 or more worktypes. Again that is only display and not...

If I was not using traditional Sharepoint as the interface for entry and viewing then I would go with 3 and simply store numeric keys. But how do you plan to display the Many to Many in Sharepoint? If you are not then OK. I am more a consumer of PA then a builder, but I would assume you would...

The three choices would depend on where you are doing the bulkof the data entry, editing, and visualization. If you are doing everything in Access then go with 3. You will have to enforce RI at the form level. If you are doing data entry and visualization in SP then go with 1. If you want a...

Have you read this because I will argue you can do this with multi select lookups (MVFs) or do it more traditional and still get the same capability. Although it may make your head spin using MVF lookups. However, you will need to understand what is going on in the background, because what you...

My point is that I doubt any of the lagging has to do with identifying and moving to the "new" correct record. So you have to do some other troubleshooting. I would see what happens if you test it without CF. You cannot upload a video unless you zip it as a file. To display you need to host it...

George beat me, but I think we are saying the same thing.

Not sure what that means. Issue_WorkArea is a list but acts exactly like a junction table in Access If you use a lookup field in your new the list Issue_WorkArea, when you pick an Issue description it saves the Issue ID even if you thing you are picking a descriptive field. If you pick a...

This is likely having to do with conditional formatting, I doubt there is a code issue. My solution works regardless of how you sort or filter the datasheet.

Works for me I think. Option Compare Database Option Explicit Private CurrentID As Long Private nextID As Long Private FirstRecord As Boolean Private LastRecord As Boolean Private Sub Form_Current() Me.txtLink = Me.OrderID ' for formatting End Sub Public Function LaunchDetails()...

I think I could get my head spinning trying to move the postion. I think I would add these properties to my form IsFirstRecord ' boolean IsLastRecord 'boolean CurrentID ' PreviousID ' ID of previous reocord or something like 0 is you are at first record FollowingID. ' ID of next record or...

https://www.access-programmers.co.uk/forums/threads/prevent-ms-access-to-autosave-data.325707/post-1854876