Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 155
Search took 0.05 seconds.
Search: Posts Made By: ListO
Forum: Modules & VBA 10-05-2014, 01:28 PM
Replies: 2
Views: 473
Posted By ListO
Re: Mismatch between Yes/No and Boolean

Success! Thank you, thank you, thank you. I couldn't find anything in my books that would lead me to this solution.

I've very glad that I didn't simplify my example by changing variable names. ...
Forum: Modules & VBA 10-04-2014, 04:17 PM
Replies: 2
Views: 473
Posted By ListO
Mismatch between Yes/No and Boolean

On a form called "MainLarge" I have a field from my table called "Tag," which is Boolean.

I want a public subroutine to process the state of that field with the following code (truncated here for...
Forum: Forms 08-05-2012, 07:27 AM
Replies: 4
Views: 4,968
Posted By ListO
Re: How to tell if combo box is dropped down

Wow- good for you to search back for this solution!

I did not find a better way to do this. It was pretty easy to paste the module into my program, then it only requires a call to fIsComboOpen...
Forum: Forms 07-06-2012, 04:46 PM
Replies: 2
Views: 4,921
Posted By ListO
Re: How to make a selecting matrix form?

Bob, you're a wiz with this stuff. Thanks for the great reference.

I'll have to study it a bit, but it appears to be just what I want.
Forum: Forms 07-06-2012, 04:22 PM
Replies: 2
Views: 4,921
Posted By ListO
How to make a selecting matrix form?

I would like to create a form with a selecting matrix. One set of records as Column Headers and one set of records as Row Headers, with a grid of checkboxes at the intersections. The user could...
Forum: Modules & VBA 03-15-2010, 04:49 PM
Replies: 7
Views: 2,048
Posted By ListO
Re: Common Dialog: Choose Font

Yes! Exactly what I need. Thank you very much for that. I haven't gotten a chance to study the code, but it looks to be what I'm seeking.
Forum: Modules & VBA 03-14-2010, 02:51 PM
Replies: 7
Views: 2,048
Posted By ListO
Re: Common Dialog: Choose Font

No.

The problems are across the board for all common dialog calls using the ActiveX object.

I'm not having any special problems with the API call for the ChooseFonts, except that I cannot find...
Forum: Modules & VBA 03-14-2010, 01:38 PM
Replies: 7
Views: 2,048
Posted By ListO
Re: Common Dialog: Choose Font

I want this to be a pop-up. I had been using the common dialog ActiveX object, but this is not working correctly for a couple of my users who are running Windows on Macs. Some research through the...
Forum: Modules & VBA 03-14-2010, 01:21 PM
Replies: 7
Views: 2,048
Posted By ListO
Common Dialog: Choose Font

Does anyone have a template for an API call to the ChooseFont of Windows Common Dialog? I've searched everywhere I can think of and have only encountered examples which don't really work. I can get...
Forum: General 11-29-2009, 05:24 AM
Replies: 2
Views: 764
Posted By ListO
Re: Keytips don't work on first try.

Hey, Bob. Thanks for the response.

Perhaps I did not explain this well enough, but I don't believe my db is working correctly.

When the application is first opened, I can press the Alt key and...
Forum: General 11-28-2009, 04:22 PM
Replies: 2
Views: 764
Posted By ListO
Keytips don't work on first try.

I have an application with a custom-built ribbon which includes keytips for the tabs and for buttons in groups in those tabs.

The first time that I use the keytips after starting-up the...
Forum: General 07-21-2009, 11:00 PM
Replies: 18
Views: 6,926
Posted By ListO
Re: Which image formats to use with ribbon buttons?

Am I the only person here having this problem?

A long internet search reveals a few others out there with similar problems, and a couple of solutions which involve some very complicated coding to...
Forum: Modules & VBA 07-11-2009, 10:37 PM
Replies: 2
Views: 560
Posted By ListO
Re: Referencing form labels from code?

Thanks, Bannana. That worked as desired.

I was trying something a lot more complicated on the theory that three right turns would make one left. But I missed a turn.
Forum: Modules & VBA 07-11-2009, 07:40 AM
Replies: 2
Views: 560
Posted By ListO
Referencing form labels from code?

I thought this would be easy, but my brain doesn't seem to grasp the concept...

I have a number of forms, each of which has an invisible label with the same name (DoneLabel).

From time to...
Forum: General 07-09-2009, 08:09 AM
Replies: 18
Views: 6,926
Posted By ListO
Re: Which image formats to use with ribbon buttons?

Thanks for the help, but I have tried just what you suggest. Although the .gif images I make have their transparencies set correctly, the transparent colors are not transparent in the ribbon. They...
Forum: General 07-08-2009, 09:17 PM
Replies: 18
Views: 6,926
Posted By ListO
Which image formats to use with ribbon buttons?

I'm trying to add my own images to buttons I'm adding to a custom ribbon in Access 2007.

I've done fine adding .jpg or .bmp images, but I would like to utilize transparencies for these images so...
Forum: Forms 06-10-2009, 01:39 PM
Replies: 2
Views: 571
Posted By ListO
Re: Menu Bar

I think this needs a bit more info. What part does the Control Box play in this?
Forum: Forms 06-10-2009, 01:34 PM
Replies: 4
Views: 510
Posted By ListO
Re: Form Fill from ComboBox, with a twist

The three fields with #ERROR are trying to calculate an entry but are receiving bad input to their calculation, thus the ERROR.

You COULD make their source conditional, by using an iif()...
Forum: General 06-10-2009, 01:12 PM
Replies: 0
Views: 733
Posted By ListO
Access 97 and Windows Vista

Greetings from a Luddite.

My WinXP laptop died- again- and I'm going to have to replace it.

Has anyone experience with running Access 97 on Vista? There's all these different incarnations of...
Forum: Modules & VBA 04-12-2009, 10:00 PM
Replies: 5
Views: 859
Posted By ListO
Re: How to change form's properties from code.

That is, of course, the solution. Thanks for putting up with us.

-Curt
Forum: Modules & VBA 04-12-2009, 07:07 PM
Replies: 5
Views: 859
Posted By ListO
Re: How to change form's properties from code.

OK, that got me a little closer, but I don't seem to have the right structure here.

Here's what I have thus far, and it's riddled with errors.


Function ChangeSort(SortType)
Dim Fname As...
Forum: Modules & VBA 04-12-2009, 04:35 PM
Replies: 5
Views: 859
Posted By ListO
How to change form's properties from code.

I'm trying to create a menu item which changes a property on the currently-active form. I would like the code to work on whichever form might be currently active.

I can easily put a button on a...
Forum: Modules & VBA 04-04-2009, 10:13 PM
Replies: 18
Views: 1,954
Posted By ListO
Re: Legal ways to exit if/endif block

Hey, thanks for the tips. I find I don't often use the Else If very often - possibly that can help.

Your structural suggestions are appreciated.

-Curt
Forum: Modules & VBA 04-04-2009, 06:37 PM
Replies: 18
Views: 1,954
Posted By ListO
Re: Legal ways to exit if/endif block

I agree with your philosophical approach - there are always ways we can get things done, but are they the most elegant ways? I struggle with this always.
Thanks for the comments.
Forum: Modules & VBA 04-04-2009, 02:18 PM
Replies: 18
Views: 1,954
Posted By ListO
Legal ways to exit if/endif block

Greetings

I know this is kind of a basic question, but I'm having trouble finding the answer.

Does it matter how an If / Endif block is exited? Would the following code cause problems when...
Showing results 1 to 25 of 155

 
Forum Jump



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