Search results for query: *

Have come up empty in searches so far. Does anyone know if there is a way to instantiate and control an MS ACCDB from SQL Server (2016 in this case)? I was thinking maybe APIs, command shell, etc.? This is not my area of expertise. The request is to automate some end-user ACCDBs that have...

Using an Access form with timer as an automation server. While active, the form vanishes after a short time. Clicking on it in the navigation pane will usually cause it to show itself, but the operations people need to have it stay displayed in the environment. I cannot find any option or...

I can't seem to be able to define custom colors on a chart in Acc2K7 as I could in Acc2K. Specifically, custom background color on the chart title. Can't get property page to pop up when the label has focus, and the only format option has predefined colors only; missing is the "define custom...

Win XP Pro SP3. Lately the active title bar color changes itself to bright blue (instead of default grey) for no apparent reason. I change it back in the Display applet, which "sticks" for awhile, then it changes itself back. Virus/spyware scans are negative. Anyone know what's happening here...

The following code works perfectly in Access 2000 thru 2003: 'strReportCode is Dimmed & assigned earlier Public prt As Printer DoCmd.OpenReport strReportCode, acViewDesign Set prt = Reports(strReportCode).Printer prt.Duplex = acPRDPSimplex prt.Orientation = acPRORLandscape prt.PaperBin = 3...

http://www.tek-tips.com/viewthread.cfm?qid=1528946&page=1 Or perhaps just struggling with what that red wavy line under the word means? Spell check, perhaps? Ever notice how fast Windows runs? Me neither.

Card shark, or card sharp? Never thought too much about it, but good arguments for both here: http://www.snopes.com/language/phrases/cardshark.asp "Don't be irreplaceable. If you can't be replaced, you can't be promoted."

I’ve never heard of this - does anyone here use it? The irony mark or irony point (French: point d’ironie; also called a snark or zing) is a punctuation mark that purports to indicate that a sentence should be understood at a second level. It is illustrated by a small, elevated, backward-facing...

Dim fso As Scripting.FileSystemObject Dim fol As Scripting.Folder Dim fdr As Scripting.Folder Dim fil As Scripting.File Dim flc As Scripting.Folders Const conInputDirectory As String = "G:\OUT\EmailTest\" Set fso = CreateObject("Scripting.FileSystemObject") Set fol =...

I KNOW I found the answer to this before, because I have used it, but sure can't scare it up now: I have an x/y line graph that displays dates along the x-axis. There are tick marks for each date, but only every other date is displayed. The answer is not checking the "category" vs. "automatic"...

Just installed Office 2007. Access 2002 mdb seems happy, except for code that was written utilizing the workspace object with the ODBCDirect param. Project references look good. Error message simply states "ODBC Direct is no longer supported". Short of rewriting everything in ADO (which I would...

I have a VB6 app that uses SAPI. So far my other VB6 apps are playing nicely with Vista, but this one can't find its objects. Anyone know if there is a patch? Can't find one on my MSDN CDs. Thanks (I hope)! It's always darkest before dawn. So if you're going to steal your neighbor's newspaper...

Anyone know how to get a handle on the background color that's behind the control tip text? Silence is golden. Duct tape is silver.

Using VB6 SP6. The open data report is displayed in a container that has a print button in the caption bar. I need to know when that button is used, but can't find a way of getting at it. Anyone know how to trap its click event? Maybe an API? Silence is golden. Duct tape is silver.

VB6 exe MDI app - I use App.PrevInstance to check for an open instance when the app starts. Occasionally it returns true, even though there is no open instance of the app. When this happens, the app is listed as "running" in task manager, even though there is no instance running. All connections...

Anyone know if the chart object can be programmed to change the color for a data series (for a single bar on the graph)? ChartFillFormat.ForeColor changes color for ALL the bars. Can't find anything useful in our FAQs, MSDN, MSKB, or Google....... Need the bar to turn red if it displays a value...

I have several Access reports that contain embedded graphics (NOT linked - OLE unbound). They will manually print fine from the dropdown menu. When I print them fom code using the printer object the graphics are omitted. In the following code, strReportCode has been populated with a valid report...

Access 2002 has an image frame control (I copied it from a form in the sample Northwind database). NOT an image control, not a frame control, not an unbound object frame, not a bound object frame. Properties include .Picture (which I am using successfully). Does anyone know where I can find this...

Anyone know of an undocumented property for the printer object that will rotate the report 180 degrees? The orientation property only allows portrait & landscape; I need this as well as the ability to rotate the report (which our Ricoh printer driver currently does). I have great faith in...

I've never developed and shipped a VB app with an Access .mdb for users that do not have Access installed (although it does work fine). Does anyone know if there will be compacting issues after repeated use of the database? I'm a bit concerned since I can't shell out the compact if the user PC...