Search results

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 the OpenFile and SaveFile to work, but I can find next-to-nothing on ChooseFont.

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 the little keytip letters appear over the tab buttons in the ribbon. If I type one of the keytip...

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 application, the keytip letters for the tabs show up after typing 'Alt,' but the letters DO NOT show up when...

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 force Access to recognize certain colors as transparent. Have any of you successfully used .png...

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.

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 time I would like to make that label visible for a second or so, then make it invisible. The operative...

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 are transparent when opened in MS Photo Editor or when viewed as thumbnails in the explorer.

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 they'll look pretty. Although Microsoft's MSDN information says to use .png files, they don't...

I think this needs a bit more info. What part does the Control Box play in this?

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() statement. Such as: iif(len(field1)<1,"",your_calcuation_here)

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 Vista too, so please note which one you've used. I don't want to stay too far back on operating...

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

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 String Fname = Screen.ActiveForm.Name Select Case SortType Case 1 OrderByOn =...

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 form which changes the property, but I'm lost when it gets to trying to address the form's property...

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

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.

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 executed a lot of times? I'm concerned that when condition1 and condition2 are true, I'm exiting both...

Is there a way to determine if at any moment a combo box is in the dropped-down state or not? I've got code which redirects keystrokes, and I'd like to have it not re-direct up- and down- arrows when a combo box is dropped down so that the combo box appears to function normally, but I don't...

Hey I think you've got the logic of your If statement backwards. It looks to me that if either [RTWI_PR] OR [selfcertrecd] has an entry then it will change PaperWorkReturned to "Yes". I'd suggest the following instead. Private Sub RTWI_PR_GotFocus() If Len([RTWI_PR] & "") > 0 AND...

Mystery Solved!: As usual, user error- not helped by Access error reports... I'm just getting my big database application going in Access 2007 converted from '97. I opened the back-end and converted it. Then I opened the front-end and converted it. Worked with some hitches. BUT I neglected...