Search results for query: *

I have some VBA code that copies the contents of one word document to the end of another. The code looks like this: dim obj_Work_Doc as Word.Document dim obj_Output_Doc as Word.Document obj_Work_Doc.Activate obj_Work_Doc.Application.Selection.WholeStory...

I periodically download (large) zip files from a website, and I would like to automate the process in VBA. The website url is of the form http://xxxxx/xxxx/xxxx.asp, and then I click on a link that displays a File Download window with Open, Save and Cancel buttons. I click on Save and save it...

I'm using Access 2010. Is there a way to turn off the "Backstage" (i.e. "File") tab at the top?

I'm trying to do the following with VBA code: Open an existing word document Insert a picture (company logo) from a jpg file at the top left of page 1 Insert text (company name and address) at the top right of page 1 Format the text (bold, font, etc) What is the command to move to the...

I'm using Access 2003, and I have a program that gives me this message every other time it is opened: "The document xxxx.mdb caused a serious error the last time it was opened. Would you like to continue opening it?" I don't know what triggered this message. I've tried going to Help /...

I have an Access 2003 database, and a little vbs program that runs every night to refresh a table from the mainframe. The vbs program looks like this: dim objAccess set objAccess = createObject("Access.Application") objAccess.OpenCurrentDataBase "c:\myDir\myProg.mdb" objAccess.Run...

Can someone provide some me with VBA code that will read thru the names in my Outlook Global Address List and get names, phone numbers, and email. Thanks

I'm using Access 2003. I have a report that is run with a wherecondition. The SQL in the wherecondition is rather complex. I just added a subreport that uses the same record source query. How can I get the subreport to also use the wherecondition SQL for selection? Several people can be...

I'm running a Crystal Reports 10 report, and get the following error message: An Error occurred in the Crystal Report tool: [No file found with such a name], The ErrorCode: 507, Expected: <#REQUIRES>, Received: <#failure> This report has been running successfully for over 6 months, but it just...

Hi I have a form called frmMenuMain which has button that opens frmReport. When the button is pressed, frmReport is opened, and then I do a me.visible = false to make frmMenuMain invisible. When the user exits frmReport, I do a docmd.close, and then have the following code: If...

Our HR department is wanting to setup an intranet site where an employee can log in and select from a list of forms (like direct deposit, W4, United Way, etc), and then fill out the form on-line and submit it to HR. Does anyone have any suggestions for a utility that could be used to design...

I have several applications on a server that are accessed by a number of people via Remote Desktop Connection. Currently, to give a user access to a particular application, I put a copy of a shortcut in that users desktop on the server. Is there a better way to do this? Is there a way to...

Using Crystal 10, is there a way to create a user defined function that's internal to the report? I would like to create a simple function that accepts a number and returns a string, and use this function inside a formula. Thanks

I have a form with 2 subforms. The first subform is used to update a detail file. The second subform has summary totals of the detail file. Whenever a record is added or changed in the first subform, I do a requery on the second subform to refresh the totals, and this works fine. However...

I have a bound continuous form, and in the footer is a text field with a control source of "=sum([TotalPaid])". The format is "standard" (3,456.79), with decimal places = 2. The sum is getting computed, but it always gives "00" to the right of the decimal point. For example, it will show...

What is the fastest way to copy the data from a result set to an Access table? Is there a way to copy in bulk, rather than looping thru and doing an insert for each record?

I have a form with the Data Entry property = yes, and it's bound to a table with 4 required fields. Say I enter data into one of the fields, and then decide to exit the form. When the DoCmd.Close executes, I get an error message: "The field 'tblxxxxx.fieldxxxx' cannot contain a Null value...

I'm using a form with datasheet view to update and add records to a table. This form has an unbound text box, and I want to control the properties of this text box based on me.NewRecord. If me.NewRecord is true, I want the text box to have a blank value. If false, I want the text box to...

I have a pcl file created by a purchase order application. I opened it using notepad expecting to see readable ascii characters. Instead, it looks like "garbage" or something I would see if I was opening a zip file using notepad. However, I have a pcl reader utility program, and it is able...

I’ve done a number of projects using Access 2003. My impression of Access is that it’s easy to develop small to mid-sized applications, with a small number of users and relatively small tables. The nice thing about Access is that it has a very powerful development environment. You can create...