Search results for query: *

Does anyone have a code snippet to call or execute a MAS 90 program, e.g. GL Transaction Register, from VBA or a batch file? I can successfully execute VB Imports but not other MAS 90 functions.

I will have multple clients setup on the same database using structurally identical tables. I'd like to select the database to use from a menu. I want to maintain separate database folders containing only the client tables. I'll be using a 3 character client code that I'd like to incorporate in...

I'm writing an Access application that prepares submission files for the IRS. I create the data file without difficulty and zip it to the specified folder. The zipped data file is then to be imbedded in an XML file that I create. The IRS documentation and tech support states that the .zip file...

Is there a method, function, setting to set a default value in a dropdown?

How do I get new contact city, state, zip to default or auto fill to company city, state zip in Act 2007?

How do I distribute my Access ODBC driver and implement it with my compiled application? Is there a Microsoft technical reference?

When a check box gets focus, the attached label is sometimes highlighted by a box, other times not. What causes this? I'd like the label consistently highlighted so my users know what control has focus.

Has anyone called Access from MAS 90 and passed arguments via a DDE script? What is the Access code to open the conversation and to place the arguments into variables? I'm planning to use a Command Button on the Inventory Maintenance Main Panel to launch Access and pass the Item No. and...

How do I distribute and update applications (forms, modules, queries) without affecting or overwriting the tables in use?

How do I search an Outlook contact file and gather fields for an Access table? I want to update a customer record in my DB.

Does anyone know how to change the $(AppPath) argument in the Packaging Wizard? I want to locate my application in a folder that isn't a subfolder of c:\Program Files. Secondly, if I can change the path, will the wizard create the folder I specify or must I do that myself?

I am attempting to get an external call to halt before continuing with succeeding code. I attempted to adapt CajunCenturian's module Thread705-667547 to my code that calls the Crystal Print Engine, without success - certainly my own ignorance. My call to the CPE: Dim stAppName As String...

I have four reports using the same table that I'd like to view as a single concatenated report and output to an .rtf file. Three of the reports have visible header and footer sections and present each record sequentially. I've tried three subreports in a main report and can get only one...

The following code calls the Crystal Report Engine: stAppName = "C:\WinTBM\rptProcReg.exe" Call Shell(stAppName, 1) Response = MsgBox("Do you want to update the Procedure Register?", vbQuestion + vbYesNo + vbDefaultButton2 + vbMsgBoxSetForeground...

I want to open a form and pass it an argument. On closing the form, I want to return an argument to the calling form. The called form will be used by many other forms; the argument returned being used by the calling form.

I have a text box that sets focus to one of two controls on a subform on losing focus. The form also has a cmd button (to exit the form). If it is clicked when the text box has focus, the onlostfocus property moves focus to the subform control rather than exitting. Any way to defeat the onlostfocus?

I have a form with 90 check boxes and 90 text boxes. The text boxes must be filled with text and some set bold based on an arrays of text and text box type. The check boxes must be set visible or not visible based on the text box type array. How do I do this in a simple loop?

I'd like the F2 key to open the list box in the same fashion as a left mouse button press. Is this possible? Many of my users prefer keyboard operation to mouse. Go figure.

I need a module that can scan, archive, fax and email documents that will be linked to a file. Routines must be modifiable. Any ideas?

I call reports using the Crystal Report Engine. However, msgboxes and other routines execute before the Crystal routine completes and returns to my form. How can I halt execution until completion of the Crystal executable?