Search results for query: *

Hi everyone, I'm trying to find the screen location coordinates of one popup form from another popup form. I will be using these coordinates to ensure the two popup forms stay together and move together. I know there's no event to fire this action, with the exception of the timer event, but I...

Hi Everyone, I've looked all over the POSTS for something on the subject of using CONSTANTS in a WHERE clause of an SQL Select statement. I can't find anything. This is a sample: The constant might look like this in the Module: Public Const FromThisDateToThatDate = "FromDate>=3/1/2015...

Hi everyone, Does anyone know how to show an image in a custom menu along with the text? I'm not referring to a button bar but a menu bar or more precisely a ribbon. When I add a custom menu it shows only text. I would like to include an image to the left of the text. The custom menu...

Hi Everyone, MSAccess 2010 db with linked tables. I am trying to resolve an issue with a table. I don't know if it's a table issue or a code issue but I thought I would start here. I recently had a wiz build a macro that would duplicate a record, seemed simple enough. All the columns...

thread702-634700 docmd.sendobject allows the use of a 'templatefile' for html output. Does anyone have an example of what a 'templatefile' looks like (actual syntax) and how to interact programmatically with it? Lamar

Hi everyone, I am using Office Pro 2013 and trying to use Access and the OVC with outlook.application object created in code. So... First, According to much documentation the control should show a .folder and .view method which can be set to the desired folder (in particular the...

Hello Everyone! I have a little problem I cannot find any information on. I have popup forms in msaccess. I would like to 'move' the parent(MDI) when I reposition the popup window with the mouse so that the MDI never becomes visible and follows the shape and position of the popup form. Is...

Hello everyone! I'm having trouble with something that I cannot resolve. It has to do with outlook.application What I would like to do is combine the contents of two different in boxes (AInbox and BInbox) such that a 'For Each' statement can process the contents of both as one box. Set AInbox...

Hi, Well, I can't find anything already posted. Can you direct me to the answer to the following? SELECT [Active Publishers].[Full name], IIf([Domicile]=0,'Hall',[Active Publishers_1].[Last Name] & ' Home') AS FSGDomicile, FSGDomicile.DoWTime, [Active Publishers].PIF FROM ([Active...

Hi everybody, I am using the msaccess webbrowser control to display and run captured html, added html components (checkboxes) and javascript. The rendered html works perfectly. However, in the control the javascript is not working at all. I don't think the webbrowser control knows what to...

I may have previously put this post in the wrong forum: ... "The value of the property <function name> is null or undefined, not a Function object". I was thinking the code had an error and thus not being recognized as a function when called by the onclick event of a checkbox. When I take the...

... "The value of the property <function name> is null or undefined, not a Function object". I was thinking the code had an error and thus not being recognized as a function when called by the onclick event of a checkbox. When I take the rendered code (html and JS) and put it in a text...

Hi Everyone! I have a problem I've been trying to solve by looking over the many JScript samples found here. They are all very educational but I don't yet see how to do what I need done. I have a VBA program that that opens a website and reads both the html and the text of the page. This...

Hi everyone, I'm trying to use the DoCmd to pop the printer dialog box which I have successfully done. I want to be able to tell what the results of the Dialog Box was. I've tried using something like: ResultCode = DoCmd.RunCommand(acCmdPrint) but it isn't working. Is there any other way to...

Hi everyone, I need to pop a system printer dialog box, any thoughts on doing this? I am in msaccess and so far using docmd.openreport. When the user wants to send the report to the printer I need to do more than just acViewNormal. I need to allow users to select the report then the printer...

Hi all, This is the best forum around. I have a form 22" wide which is in three sections. It is viewed in an unsizeable window approx. 7" wide. I want to click on a button to slide (scroll) the 22" form left or right in approx. 7.33" increments to bring the next/previous section into view...

Hi everyone, I'm setting up a test machine for Windows 7(64). Since I've installed my Office XP(32) on the windows 7 machine MSAccess is no longer running programs. Access opens fine and I can load an mdb fine but when I try to run the program previously written on an XP machine it complains...

Hi everyone, Currently I am opening the webpage in a browser, 'selecting all' and pasting it into a text field which is working fine but it's clumsy. I parse through the text which includes field names and save the data to a table. Is there a way from within access to open a webpage not...

I'm trying to reconstruct a portion of data that was lost as a result of a disc crash. The section of code has to do with using the Windows OS file browser. There is an API that can be used to launch it, and source code. Can anyone remember what keywords to use? I've been trying all night...

Hi everyone, Can anyone point me in the right direction? I want to run a public function() in one mdb's module from another mdb? I've looked through many posting and I can't find anything. Thanks in advance...