Search results

It's Chr(34)

WRONG! :) That's the $ character.

See! I knew someone would have a better way of doing this. Thanks, rube.

What is the VB character code for a quotation mark?

Nevermind, must have typed something in wrong... or Access 2000 is buggy. It works now.

The following works for a text box control called "TextBox": Dim CurrentControl As Control Set CurrentControl = Forms!Switchboard.TextBox CurrentControl = "Message" But let's say I want to alter the color of the font from the default (black) to red... how can this be accomplished? (This does...

Not quite, CALV. It was more like: (FROM FORM 1- the switchboard): DoCmd.Close acForm, "FORM 1", acSaveNo DoCmd.OpenReport "REPORT", acViewPreview, , "" acFormPropertySettings, acWindowNormal, "" (FROM FORM 2- the print options form): DoCmd.Close acForm, "FORM 2", acSaveNo It would probably...

When did I become a senior member? Does membership have its privilages?

Custom menu bar... you guys always tell me stuff I don't know how to do (which is pretty much everything, but that list is shrinking). Anyway, what I did was save the values in various text boxes on the form to variables. Then I closed the form with a DoCmd. (The report becomes active by...

Is is possible to print a report (that's already been generated and in "preview" mode) by hitting a "print" button that's on a form? I'm trying to do this with DoCmd.PrintOut I realize that this command will print out the currentlyactive object, so I'm thinking I have to make the Report active...

Right, and I read (in the Help file) that it only grows (or shrinks) vertically... I want mine to grow or shrink horizontally. I just changed the Width property on a case-by-case basis (there are a limited number of phrases that the Label will receive).

zoom box? I looked through the ActiveX controls and it isn't listed as one of the standard controls (next to/near the label and text box) as far as I can see. I'm using Access 2000.

Is there a way to have a Label or Text Box auto-size its width to its dynamically-changing contents with VB (like when you double-click it during design mode)?

Does anyone have some code to enable transparent back color on a list box? It was suggested that perhaps someone may have created a tweaked version of the standard list box as an activex control.

True, I was referring to a topic in that other thread, but thanks for the suggestion anyway.

Really. OK, say I find an ActiveX control that mirror's the function of a normal list box plus the ability to have it with a transparent background... How (easily) can I "embed" it into my DB and use it? Are there security concerns?

I intended to have an embedded picture show through the list box, which is why I wanted a transparent list box. As for the text, I have it bolded. No problem to read. Is there any way to make list boxes transparent?

Is there any way I can set my list box so that its background color is transparent?

Yes, DoCmd.SetWarnings is exactly what I was looking for. Thanks again, SforSoftware and WayneRyan.

It works! SforSoftware, I modified the RunSQL version of the code you suggested with brackets: DoCmd.RunSQL "UPDATE [" & SaveToTable & "] SET [" & SaveToTable & "].[Client Name] = '" & Me.ModTxtName & "';" and that works! The only minor issue I have now is that there's a pop-up box that comes...