Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 25
Search took 0.08 seconds.
Search: Posts Made By: Orthodox Dave
Forum: Modules & VBA 06-17-2018, 03:57 AM
Replies: 8
Views: 436
Posted By MajP
Re: quickly choosing option as you type from combo-box for invoice

This is my code I use to turn any combo into a find as you type combo. It requires the user to drop this code into a class module named FindAsYouTypeCombo (class module not standard module).

Then...
Forum: Modules & VBA 04-12-2018, 08:32 AM
Replies: 10
Views: 451
Posted By Pat Hartman
Re: BrowseFolder

You would use the MS Office xx.0 library with xx being whatever is loaded.

To pick folders use msoFileDialogFolderPicker rather than msoFileDialogFilePicker
Forum: General 11-02-2017, 06:36 AM
Replies: 7
Views: 19,331
Posted By isladogs
How to respond to advice given in forums

Comments made in a recent thread have prompted me to write down my own views on how best to respond to advice given

AS I hope everybody who posts here realises, none of us get paid for the time &...
Forum: Modules & VBA 09-04-2017, 09:09 AM
Replies: 8
Views: 1,085
Posted By isladogs
Re: The code in this project must be updated for use on 64-bit system

Yes - provided you use conditional compiling (and its not an ACCDE)

#If Win64 Then
'64-bit declarations here (PtrSafe & LongPtr)
#Else
'32-bit declarations here
#End If

If you also need it...
Forum: Modules & VBA 09-04-2017, 04:55 AM
Replies: 8
Views: 1,085
Posted By isladogs
Re: The code in this project must be updated for use on 64-bit system

I think you'll find that developers creating databases for external use / sale will know about this - if only by finding out the hard way.

For the past 6 years, I've had to convert all my...
Forum: Modules & VBA 09-01-2017, 09:15 PM
Replies: 8
Views: 1,085
Posted By nhorton79
Re: The code in this project must be updated for use on 64-bit system

Have a look at this...

https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx


Sent from my iPhone using Tapatalk
Forum: Modules & VBA 08-15-2017, 03:43 PM
Replies: 7
Views: 442
Posted By ashleedawg
Re: Probably an easy answer but i am having trouble with it.

@Steve2020 -
If..Then..Else can be on one line (without an End If) if you're only giving it one statement to execute, like shown on MSDN...
Forum: Modules & VBA 08-12-2017, 08:59 AM
Replies: 8
Views: 395
Posted By AccessBlaster
Re: on print tick the checkbox as printed

Yeah my example will not work for you as your fields names differ from the example. I only wanted you to confirm to the readers that your looking to update a Boolean field.

Sorry for the confusion.
Forum: Modules & VBA 07-25-2017, 08:18 PM
Replies: 8
Views: 558
Posted By Galaxiom
Re: How to get the Character Sequence for a number?

Maybe this code (http://www.utteraccess.com/wiki/Base_Ten_to_Base_Letter) at UtterAccess is what you want?

It won't get the same results you have given as examples but they don't make sense...
Forum: Modules & VBA 07-19-2017, 07:31 AM
Replies: 8
Views: 846
Posted By static
Re: Temporarily Disabling right-click Shortcut Menus

Private Sub Command1_Enter()
ShortcutMenu = False
End Sub

Private Sub Command1_Exit(Cancel As Integer)
ShortcutMenu = True
End Sub

Private Sub Command1_MouseUp(Button As Integer,...
Forum: Modules & VBA 07-19-2017, 07:05 AM
Replies: 8
Views: 846
Posted By isladogs
Re: Temporarily Disabling right-click Shortcut Menus

I believe you are out of luck.
This is one of the startup properties for a database so by definition you have to restart it

I agree with you about ControlTips - also there is a delay before these...
Forum: Modules & VBA 07-17-2017, 11:09 AM
Replies: 7
[SOLVED] IsNull Problem
Views: 413
Posted By The_Doc_Man
Re: IsNull Problem

Just to explain why Paul's suggestion is a good one, VBA function and subroutine syntax can be ambiguous with respect to parentheses. There are times when you need them and times when you don't.
...
Forum: Modules & VBA 07-11-2017, 02:02 AM
Replies: 23
Views: 710
Posted By Minty
Re: Too Few Parameters 2

@Dave - This is a known issue - have a read here for a full description and some sensible ways to work around it http://allenbrowne.com/ser-36.html

I personally use a function to force all dates...
Forum: Modules & VBA 07-07-2017, 05:14 AM
Replies: 15
Views: 968
Posted By isladogs
Re: Add 3 Workdays to a Date

Oh I'm disappointed in you.... :rolleyes:

So you don't want to know that in 2099 Easter Sunday is on 12 April !
Thought you might want to start planning!

Anyway in case anyone else does want...
Forum: Site Suggestions 06-25-2017, 05:36 AM
Replies: 52
Views: 5,845
Posted By isladogs
Site suggestions poll

I like this site a lot & spend far too much time on it.
However like any site its not perfect and various users have suggested improvements

Currently it appears that suggestions for improving the...
Forum: Modules & VBA 06-23-2017, 02:15 AM
Replies: 17
Views: 1,458
Posted By isladogs
Re: Filtering a Continuous Forms Combo Box with a Meaningless Bound Column

Just retested this in A2010/2016 & realised that the hidden column is either a PK field or being treated as such for indexing

Try this

1. To switch off Limit To List, temporarily set the bound...
Forum: Modules & VBA 06-23-2017, 02:01 AM
Replies: 17
Views: 1,458
Posted By Minty
Re: Filtering a Continuous Forms Combo Box with a Meaningless Bound Column

I think I now get what you are trying to do, and you are dead right - Access 2010 has the same restriction.

The simplest (messy) way around your problem is probably to only restrict the displayed...
Forum: Modules & VBA 06-22-2017, 10:16 AM
Replies: 17
Views: 1,458
Posted By Uncle Gizmo
Re: Filtering a Continuous Forms Combo Box with a Meaningless Bound Column

Reading the rest of your question, I suspect you already know about the column width property!

Re:- "surely there must be a better way..."

I'm not sure it would work in your situation but it...
Forum: Modules & VBA 06-12-2017, 10:16 AM
Replies: 4
Views: 365
Posted By sxschech
Re: Prevent File Path To Show

I replicated the issue, sort of in Access 2013. My title bar says "Access".

I went into File, Options, Current Database. There was a box that says Application Title. Mine was blank. I typed in...
Forum: Modules & VBA 06-09-2017, 02:20 AM
Replies: 4
Views: 343
Posted By Minty
Re: Copy values from one record into a new record

I would do this with an insert query based on the existing ID, DLookups are a very inefficient method.

You can build it in the query designer and make the current ID on the existing form the...
Forum: Modules & VBA 05-23-2017, 02:39 AM
Replies: 8
Views: 362
Posted By isladogs
Re: Query to vba

You might find my VBA SQL converter useful. See this thread:

https://www.access-programmers.co.uk/forums/showthread.php?t=293372
Forum: Modules & VBA 05-22-2017, 06:47 AM
Replies: 12
Views: 1,012
Posted By The_Doc_Man
Re: Update Backend design from Frontend

There are many parts to this question.

You SHOULD start from a properly split database in which the front-end has either no tables at all or only tables used for a temporary staging area. Some...
Forum: Modules & VBA 05-18-2017, 02:05 PM
Replies: 4
Views: 1,074
Posted By static
Re: Strange problem refreshing ODBC Connect

https://support.microsoft.com/en-gb/help/303968/how-to-create-an-sql-pass-through-query-in-access
Forum: Modules & VBA 05-18-2017, 09:34 AM
Replies: 4
Views: 1,074
Posted By Royce
Re: Strange problem refreshing ODBC Connect

In most cases what you show is all that is needed, and I've used that for years also.

But I have a development situation where we need to frequently relink between a backend Access database...
Forum: Code Repository 05-04-2017, 05:52 PM
Replies: 2
Views: 5,018
Posted By isladogs
How to remove 'deleted database objects' from the MSysObjects table

EDIT 15/05/2017: Added additional information & an example database (with MSysObjects errors left in)

The system table MSysObjects keeps a record of all items in a database so these can be used by...
Showing results 1 to 25 of 25

 
Forum Jump



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