Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: MajP
Forum: Modules & VBA 11-02-2019, 10:59 AM
Replies: 5
Views: 134
Posted By MajP
Re: Docmd.GoToRecord gets mixed up between two instances of the same form

Moving to different form instances to same record.

myFormsCollection(1).recordset.FindFirst "SomeField = " & someValue
myFormsCollection(2).recordset.FindFirst "SomeField = " & someValue
Forum: Forms 10-29-2019, 02:25 AM
Replies: 8
Views: 180
Posted By MajP
Re: Calendar View Form

I actually do have a version, but I would look at the multi month view
https://www.access-programmers.co.uk/forums/showthread.php?t=142732&page=2
Forum: Forms 10-24-2019, 03:18 PM
Replies: 16
Views: 251
Posted By MajP
Re: Multiple Filters Continuous Form - Same as Excel

Here is a pretty good fake. I did not add any functionality, only make it appear as if I do. This requires very little code.
Forum: Forms 10-24-2019, 03:42 AM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

These Active X controls can be a pain to register. They are really temperamental. If you are distributing your application, I would say it is not worth it. You can download mscomctl.ocx from the...
Forum: Modules & VBA 10-22-2019, 05:27 PM
Replies: 6
Views: 144
Posted By MajP
Forum: Forms 10-21-2019, 05:28 PM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

Thanks, but I am kind of confused. My function look like this
Private Function InternationalCharacters(ByVal strText As String) As String
InternationalCharacters = strText
'If you type...
Forum: Forms 10-21-2019, 03:23 PM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

@ironFelix,
You may find these classes of interest. You can do a lot with listboxes. Same idea of making a class module to turn any listbox into a find as you type or a to from listbox.
Forum: Forms 10-21-2019, 07:11 AM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

If anyone interested here is an updated class with a few more features.
1. Optional dragdrop
2. optional double click drop
3. Return a sorted column
4. return current value from specified column...
Forum: Forms 10-20-2019, 05:07 AM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

Works for me especially with the column count fix. Not sure the issue .

I would add a requery method.
create:
Private OriginalRowSource
in the initialize:
OriginalRowSource =...
Forum: Forms 10-19-2019, 09:16 AM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

@Isladog
I believe I stripped your code down to the bare bones to make a generic set of functions that return the row height and list index. It seems to work great, except not sure if there is an...
Forum: Forms 10-18-2019, 09:44 AM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

Here is an 80% solution using the up down buttons. This turns any listbox into a move up down listbox using a single line of code. This gives you the re-usability. Works with row sources based on...
Forum: Forms 10-17-2019, 03:04 PM
Replies: 83
Views: 1,629
Posted By MajP
Re: MS Access: custom control built in another language

Can you describe what your control does? Maybe you can fake it. You can roll your own custom classes and fake controls. You can raise your own custom events.

If you use MSFORMS controls you can...
Forum: Queries 10-14-2019, 07:43 AM
Replies: 4
Views: 134
Posted By MajP
Re: Modify Query Criteria Via Form

I basically do the same as Arnelgp. I usually add a way to change my search from and AND to an OR. I usually make it a function so it can be called externally, or you can pass the string as Arnelgp...
Forum: Modules & VBA 10-14-2019, 05:47 AM
Replies: 9
Views: 184
Posted By MajP
Re: Run macro from another, already OPEN database

you can use getObject or just add the external db as a reference.
Forum: Modules & VBA 10-10-2019, 11:11 AM
Replies: 12
Views: 256
Posted By MajP
Re: Passing values between forms

Maybe something like

Forms!MainOptions!PlantList.Form.recordset.findFirst "SomeIDField = " & me.SomeIDField
Forum: Modules & VBA 10-01-2019, 06:28 AM
Replies: 9
Views: 187
Posted By MajP
Re: Related field concatenation on two levels

This works with all your formatting. But rs2 needs to be based on a query that sorts Type on a type sort order.
Forum: Modules & VBA 10-01-2019, 06:21 AM
Replies: 9
Views: 187
Posted By MajP
Re: Related field concatenation on two levels

Public Function Concat2(ID As Long) As String
Dim rs As DAO.Recordset
Dim rs2 as dao.recordset
Dim rsType As DAO.Recordset
Const tableName = "tblActions"
Dim firstLine As Boolean

...
Forum: Reports 09-28-2019, 04:46 AM
Replies: 7
Views: 236
Posted By MajP
Re: Please help with this report

you can make it a subform linked by employee, or use dlookups in calculated controls.
Forum: Modules & VBA 09-26-2019, 05:17 PM
Replies: 24
Views: 398
Posted By MajP
Re: Multi select records in a shared back end database

This seems the easiest. Make a table tblSelected.
TblSelected
merchandiseID_FK
Selected ' yes no field

When you load the form simply ensure you have all the IDs by doing an append query....
Forum: General 09-25-2019, 04:48 PM
Replies: 5
Views: 132
Posted By MajP
Re: Tab Control

Just to be perfectly clear it is not really "visible on all tabs", it is positioned in front of the tab control giving the illusion it is on all tabs. So you can embed it into a page or "float" a...
Forum: Reports 09-24-2019, 03:58 PM
Replies: 5
Views: 149
Posted By MajP
Re: Can I tell Access NOT to print a line or to move on to the next Group

The following skips the row where carID = 3. Has to be done in print preview.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Me.carID = 3 Then
Cancel = vbCancel
...
Forum: Modules & VBA 09-23-2019, 03:54 PM
Replies: 12
Views: 222
Posted By MajP
Re: Continuous Forms - Highlighting records

That is normal behavior. Instead you can make the fields background normal and just put conditional formatting to the fields. See demo where I replicate your issue and the second is just highlighting...
Forum: Queries 09-23-2019, 11:23 AM
Replies: 13
Views: 195
Posted By MajP
Re: Week Number from Date for Fiscal Year

I do not believe the function works for dates in September in out years.
?fnkFiscalWeek(#9/2/2020#)
53
Believe that should be 1
Forum: Modules & VBA 09-19-2019, 03:31 PM
Replies: 41
Views: 462
Posted By MajP
Re: Populate the name of the active control on focus in a form.

Actually not sure if you are doing like I set it up. I had a box on the main form and the subform. If you want one box you have to do like this. If the subform wants to display on the main form it...
Forum: Modules & VBA 09-19-2019, 11:36 AM
Replies: 41
Views: 462
Posted By MajP
Re: Populate the name of the active control on focus in a form.

If you are going to do this throughout the db, then you will have different textboxes to display the hint. You may want to modify the code
Public Function DisplayHint(txtHint As TextBox)
On...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:53 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