Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: MajP
Forum: Forms 04-15-2019, 05:43 AM
Replies: 7
Views: 153
Posted By MajP
Re: Close/hide a form from which another form is opened in acDialog

you could put the code in the on load of your form to check if the search form is loaded and if so close it.
Forum: Forms 04-15-2019, 05:29 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

I did not get around to it in the demo, but it should be easy when you add a user to a location to add all the appt types through an append for that user for that location. Same thing when you...
Forum: Modules & VBA 04-13-2019, 09:09 PM
Replies: 7
Views: 150
Posted By MajP
Re: Do while counter resets after returning to function

Also as I explained in a recent thread you can force ByVal by using extra bracketing in your call
...
Forum: Forms 04-12-2019, 01:16 PM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

Here is the demo. Still needs lots of work. I added another junction table for employees and locations, but in truth you could do without it. However, you are going to need some code when you...
Forum: Modules & VBA 04-12-2019, 12:38 PM
Replies: 49
Views: 673
Posted By MajP
Re: OpenArgs lifespan

For those interested in multiple forms a recent thread here with example code showing displaying multiple instances at one time.

https://www.access-programmers.co.uk/forums/showthread.php?t=304671
Forum: Forms 04-12-2019, 11:31 AM
Replies: 8
Views: 162
Posted By MajP
Re: rename multiple instances of forms

This version was pretty basic. The idea could be expanded to actually determine screen size then resize the forms as needed to fit. I hard coded the number of columns, but this could be calculated. ...
Forum: Forms 04-12-2019, 11:27 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

If you post an updated db, I can do a quick demo. It will not be aesthetically pleasing (you can do that), but I can quickly demo the capability. None of it is real hard, but would probably take me...
Forum: Forms 04-12-2019, 09:23 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

Create a new junction table with nice naming convention. I would have fields
EmployeeID_FK
LocationID_FK
ApptTypeID_FK
Preference ' text field

In the appointment table rename it to...
Forum: Forms 04-12-2019, 08:31 AM
Replies: 18
Views: 227
Posted By MajP
Re: Multivalue Fields Pros and Cons

I do not think that is a multi value field as we are talking. That is a single field that represents multiple different pieces of data, not a field containing multiple child records. That is a...
Forum: Forms 04-12-2019, 07:51 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

If they get all the appointment types then you can still do this.

so you can take that data and cartesian it with the appt types. Then you will get the 30 appt types for each employee at each of...
Forum: Forms 04-12-2019, 07:46 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

Couple of things. Do not use spaces in any field or table names.
Appt_types, ApptTypes for example.
Most people identify with a three letter prefix
tblApptTypes 'table
frmAssignPreferences...
Forum: Forms 04-12-2019, 07:29 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

If every employee will have a record for every location and every appt type. You can preload the entire database and then just enter the preferences. If you have a table of employees, locations, and...
Forum: Forms 04-12-2019, 07:22 AM
Replies: 18
Views: 227
Posted By MajP
Re: Multivalue Fields Pros and Cons

So to understand just how convoluted this is, imagine you have a mvf field that holds selected employees for your inspection event. For InspectionEvent A with PK of 123

In the field you see
John...
Forum: General 04-12-2019, 07:09 AM
Replies: 7
Views: 142
Posted By MajP
Re: Format time field

That one would not work, because that format "hh:nn" can only be correctly applied to a datetime value. 0600 is a string and not a datetime value. The computer stores the datetime value for 6:00 AM...
Forum: Forms 04-12-2019, 06:49 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

As mentioned you may want to have a master form and then at least one subform. The master form would be employees with details on the employees. The subform would be in continuous view combos for...
Forum: Forms 04-12-2019, 06:00 AM
Replies: 18
Views: 227
Posted By MajP
Re: Multivalue Fields Pros and Cons

Also I think you mentioned this may get moved to SQL backend, so then you would have to redesign in the future.
Forum: Forms 04-12-2019, 05:59 AM
Replies: 18
Views: 227
Posted By MajP
Re: Multivalue Fields Pros and Cons

If you completely understand how these work then I would consider it with caution. I understand them and how they normalize the data behind the scenes, and I am very cautious to ever use them. But...
Forum: Forms 04-12-2019, 05:37 AM
Replies: 30
Views: 300
Posted By MajP
Re: Form with multiple dropdown filters

Yes very easily. That would actually be the easiest form you could make and would not require any forms or subforms.
The first three emp, loc, and appt type would be combo boxes the last would be a...
Forum: Tables 04-12-2019, 04:34 AM
Replies: 4
Views: 102
Posted By MajP
Re: Understanding how someone setup table

To echo what DBGuy said.

Besides what you found out that what you see is not what is really there, here are other reasons we consider them Evil.
http://access.mvps.org/Access/lookupfields.htm
Forum: Forms 04-12-2019, 03:16 AM
Replies: 8
Views: 162
Posted By MajP
Re: rename multiple instances of forms

Function StackCompanyForms()
Dim wdth As Long
Dim hght As Long
Dim rowCounter As Integer
Dim colCounter As Integer
Const twipstoin = 1440

Const conSQL = "SELECT * FROM...
Forum: Forms 04-11-2019, 06:09 PM
Replies: 3
Views: 82
Posted By MajP
Re: Need help picking out random records without any duplicates

Without knowing your table structure it is hard to give a specific answer. However the normal trick is to sort a query first sort by count of previous selections then by the random number. This way...
Forum: Forms 04-11-2019, 01:32 PM
Replies: 8
Views: 162
Posted By MajP
Re: rename multiple instances of forms

You Cannot name the instance. The name is a shared property of the class and each instance shares the same name. That is why you use a collection to manage your instances. Use the form move method...
Forum: Modules & VBA 04-11-2019, 09:07 AM
Replies: 23
Views: 340
Posted By MajP
Re: SQL Output - Characters found after end of SQL statement

There is no way that vba makes the below string, you must be missing something that does the ATA2DIGIT

more readable

SELECT tbltcaog.id,
tbltcaog.DATE,
...
Forum: Modules & VBA 04-11-2019, 08:36 AM
Replies: 3
Views: 77
Posted By MajP
Re: Don't ask user for Query Parameters

There are lots of techniques for building a filter string from multiple controls. In this thread I describe mine.
https://www.access-programmers.co.uk/forums/showthread.php?t=304424

I often have...
Forum: Modules & VBA 04-11-2019, 08:30 AM
Replies: 3
Views: 77
Posted By MajP
Re: Don't ask user for Query Parameters

If the query of the subform is complex and you do not want to builld it in code as suggested, you could do the same as above and just build the filter in code which may be easier than building the...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:10 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World