Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: MajP
Forum: Forms Today, 09:28 AM
Replies: 14
Views: 255
Posted By MajP
Re: Calendar View Form

Interesting. It appears that you can. I was able to create 800 controls in code.
Forum: Forms Today, 07:58 AM
Replies: 14
Views: 255
Posted By MajP
Re: Calendar View Form

That's interesting. I would have thought that forms and reports would have the same limit. When I built the form I used code to build it. I am wondering if that allowed me to exceed the limit. I will...
Forum: The Watercooler Today, 06:03 AM
Replies: 49
Views: 781
Posted By MajP
Re: Is OOP actually useful?

https://www.access-programmers.co.uk/forums/showthread.php?t=308038

I provided some interface discussion in the thread.
Forum: Forms Today, 05:55 AM
Replies: 14
Views: 255
Posted By MajP
Re: Calendar View Form

I would not think there would be an issue. Can you better explain the issue?
Forum: Forms Yesterday, 04:17 AM
Replies: 15
Views: 183
Posted By MajP
Re: Edit List Items

See your other thread

No, the other thread explains why.
Forum: Forms Yesterday, 04:12 AM
Replies: 22
Views: 361
Posted By MajP
Re: Search as you type in combobox.

Because of how the class works, the native list items edit form will not requery the list, and even if it could I identified a bug in my code. Unfortunately there is no way to trap the event of...
Forum: Modules & VBA Yesterday, 03:16 AM
Replies: 3
Views: 126
Posted By MajP
Re: Interfaces in Vba

The Pearson stuff is all good
http://www.cpearson.com/excel/classes.aspx
Forum: Modules & VBA 11-19-2019, 04:20 PM
Replies: 3
Views: 126
Posted By MajP
Interfaces in Vba

So recently there was a discussion on the value of Object Oriented Programming, and I will contend that since this is an Access forum that, that question makes no sense. Everything you do in VBA is...
Forum: Forms 11-19-2019, 12:42 PM
Replies: 15
Views: 183
Posted By MajP
Re: Edit List Items

I will take a look later. One thing you have to use the class requery and not the control's requery
for a complicated reason
Forum: The Watercooler 11-18-2019, 03:49 PM
Replies: 49
Views: 781
Posted By MajP
Re: Is OOP actually useful?

So I played with this and It is not a game changer, and not huge. I think for those of us who understand the limitations of VBA it was a potential hopeful extension to those limitations. My...
Forum: Forms 11-18-2019, 10:58 AM
Replies: 5
Views: 163
Posted By MajP
Re: WithEvents OnAfterInsert not working

Events have names that start with prepositions telling when they happen which are
Before
On
After

So OnAfter would make no sense.
Forum: Forms 11-18-2019, 04:12 AM
Replies: 17
Views: 230
Posted By MajP
Re: Option Frame: Get Name and Tag text

FYI, I rarely post non working code, and if I do I preface with "Untested" or "try something like.." If it could not be done, I would tell you.
Forum: Forms 11-17-2019, 04:54 PM
Replies: 17
Views: 230
Posted By MajP
Re: Option Frame: Get Name and Tag text

Yes.
..................................................................................................................................................... Extra...
Forum: Forms 11-17-2019, 04:32 PM
Replies: 17
Views: 230
Posted By MajP
Forum: Forms 11-17-2019, 02:26 PM
Replies: 17
Views: 230
Posted By MajP
Re: Option Frame: Get Name and Tag text

Ahh. NO.

Extras characters.
Extras characters.
Extras characters.
Extras characters.
Extras characters.
Forum: Forms 11-17-2019, 02:01 PM
Replies: 17
Views: 230
Posted By MajP
Re: Option Frame: Get Name and Tag text

That does not address the question asked. That simply provides a return value.
Forum: Forms 11-17-2019, 12:59 PM
Replies: 17
Views: 230
Posted By MajP
Re: Option Frame: Get Name and Tag text

Private Sub Frame0_AfterUpdate()
Dim ctrl As Access.Control
For Each ctrl In Me.Frame0.Controls
If ctrl.ControlType = acOptionButton Then
If ctrl.OptionValue = Me.Frame0.Value Then...
Forum: Forms 11-16-2019, 10:35 AM
Replies: 20
Views: 272
Posted By MajP
Re: Time picker

Using Micron's form and a little extra code. Here is a reusable pop up.

You will need a version of this every time you call it
Private Sub cmdTime_Click()
Dim theTime As String
If...
Forum: Forms 11-16-2019, 10:20 AM
Replies: 20
Views: 272
Posted By MajP
Re: Time picker

Do you want a Popup control or build it on your form? I think Micron was suggesting to build this directly on your form. But you could make a popup.
Forum: Modules & VBA 11-15-2019, 10:16 AM
Replies: 15
Views: 247
Posted By MajP
Re: Hangman Style Search

Instead of command buttons if you want it to work like the second version where you type into a textbox here is the code.


Option Compare Database
Private strWord As String
Private strLetter As...
Forum: Modules & VBA 11-15-2019, 09:22 AM
Replies: 15
Views: 247
Posted By MajP
Re: Hangman Style Search

My fault, I thought you were talking about the first db. The first DB is nicer in my opinion, but should be easy to modify the code. If you do not want the command buttons
Forum: Modules & VBA 11-15-2019, 08:17 AM
Replies: 15
Views: 247
Posted By MajP
Re: Hangman Style Search

The code is not locked, just select show all access objects in the navigation pane.

Import your form into the database
Change code to
To modify the hangman to use a selected word instead of...
Forum: The Watercooler 11-15-2019, 04:14 AM
Replies: 49
Views: 781
Posted By MajP
Re: Is OOP actually useful?

From Jdraw

Am I the only one who was blown away by this? I been doing vba for 20 years and have read everything I could. I had no idea that you could define an interface. Never seen an example...
Forum: General 11-14-2019, 01:16 PM
Replies: 113
Views: 36,563
Posted By MajP
Re: Yearly Attendance Tracker/Calendar

That would be easy. Change the supervisor table to the Department_Branch table. Now you will have to update the supervisor combo to use the new table and new fields. You will have to check...
Forum: General 11-14-2019, 04:46 AM
Replies: 5
Views: 126
Posted By MajP
Re: DoCmd

Forgot the ampersand
"[ContractID]=" & Me.ContractID & " And [sellerID] = " & Me.txtSellerID
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:42 AM.


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