Search results

@June7 Your test is correct, but that is not what the OP is doing. As you said if you enter a time component only with no integer portion then when you click in the text box it will only show the time. However, for some Unexplained reason the OP is entering a date (integer) portion with an...

No, the reason that code was commented out was this is a copy from the cited risk database. So the code would have to be written for this DB, but the idea would be similar. However, the demo I did is to show a concept of locating things on an image and saving those locations. As demoed it does...

This question makes no sense. No only is it possible, but requires no code. Every form in a subform is an instance of that forms class. So of course you can have as many form instances as you want. So if you add four subform controls and they all have the same source object, it creates four...

See if this is of interest. You can look at that video on risks to see possible features you can add. I had multiple ways to filter the list. I did not add the filters, but I have a listbox on the left where you could turn on and off the display of different states. I set this up where you pick...

No this is very basic. It is only to show that you can give a sense of animation even though there is really no animation. There are 48 hidden lines The table has the x,y position of each capital You pass a hidden line to the function and what cities to connect. Each city is in the table and...

To see some animation in access, here are some Heuristic solutions to the Traveling Salesman problem. You can watch the solutions unfold. 1. Add all the capitals to your selected cities in yellow 2. These are improving algorithms so you can start with Closest neighbor, then 2 opt Swap, then 3...

In my method this would take about 5 minutes. Just drag the label into position and it will save it to the correct location to the table. Now you just read the table to move to that state. Once you drag them once you know the label position for each state. For the checkboxes I would just put...

I have all the code to do this. If you send me a map you want to use. I can code all the labels faster then I can explain the code. It would generate the 50 labels. You then drag them one time into position and they would be saved dynamically. If you want to see a demo of this. To see a demo...

Store the X and Y position in a table. I will post an example allows drag and drop of the lables.

However, that test is for a local table. I cannot test SQL backend to see if it works differently. But what is confusing is how MS describes a filter "Since the view you get after you apply a filter contains only records with the values that you selected, the rest of the data remains hidden...

Maybe I am missing something, but this seems like a very simple test. 1. Open a continuous form to a single filtered record 2. While the form is open go into the table and modify, delete, or add some records 3. remove the filter All changes show, so would it not have to re-pull the data?

Do an aggregate query (group by employee and shiftdate) maybe add where count > 1. Then if there is any record in this query for an employee and shift date you can do conditional formatting. Then I would build a function Public FunctionHasDupe(empID as long, ShiftDate as date) as boolean...

Here is a pretty functional Wardrobe Builder. Allows you to pull from the parts list and make any wardrobe composed of those parts. Basically I just added a couple of details to the generic Assemblies Sub Assembiles (Bill of Materials DB) 1. Create a Wardrobe by hitting the Create New BOM...

You are begging for problems with name schema like that. Never put spaces in a name, but for sure never put a space in a name with something like "And " or "Or" DD_or_RTGS_NO is fine. Readable. SELECT [master data].[dd or receipt no], [master data].[material supply date]...

I do not. Everything is a component and goes into a single self referencing table. If that component is an assembly then it has related children. But I never build a separate table for components. You can but it only complicates the data structure.

I would look at using a treeview for this. This is a self referencing form with multiple levels. Click on the node you want and see it s details on the right, and details for its immediate children. I discuss in detail working with hierarchical data and self referencing tables. I would look at...

Even so, after that all those other second lines should not compile. So it would be pretty easy to hit compile and find all bad lines.

Really? I do not even get what you are trying to say, but makes no sense to me. I am pretty sure most people know that tables are unordered, but you can sort on the bins thus sort the individual orders. The OPs example did not show if multiple items can be put into a bin for a given order, but...

Sounds like a game-changer, but how do you assign to the target if you cannot scroll to it?