Search results for query: *

I have a VB6 program which work for years until recently my company has moved from PCs to Citirx Environment using WYSE terminals (we no longer have PC now). This means that all the software are installed centrally on a server instead of C:\ drive (base PC). Unfortunately this has upset the...

I have a VB6 program which work for years until recently my company has moved from PCs to Citirx Environment using WYSE terminals (we no longer have PC now). This means that all the software are installed centrally on a server instead of C:\ drive (base PC). Unfortunately this has upset the...

I am trying to extract result from an existing query but with or without where clause. The query is if myDepartment is * then display everything else just display certain department name. The codes below seems to work BUT only where myDepartment contain only one word i.e. "Sales" but when it...

I am (trying) to design one Main Report with a sub-report containing Financial Information. However, there are 6 different Financial Information subreports and only one is required. How do I get the Main Report to select one particular subreport? The Main Report included a UnBound subreport...

I am trying to Import data from Word Form into Access. One Access's column is named "Narrative" and Data Type is set to Memo. The Word Form maximum length is 1000 for this same field. However, the ADO VBA code is only importing 255 data whereas this field on Word has 372. How can my code...

Is there a way to have one query to work on many table with same column names where the table name only differ by number? For example...Table Name.. Table1 Table2 Table3 all have column column names, so on the query can I add a parameter to the Table name like FROM Table[MyNo] I just wanted...

Previously my Excel VBA works OK sending out email until IT had switched off our POP3 and SMPT email address as one year ago we moved to Exchange Server and now uses Outlook Web Access. My code... oEmail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") =...

Hello. I have a word document containg several pictures from Excel spreadsheet. These pictures were entered into Word using the Paste Special as 'Microsoft Excel Worksheet Object; without paste links. I need to write a macro in Word to check the validations of the amounts within that embeded...

Below is tipical code to show custom menu etc... With .Controls.Add(Type:=msoControlButton) .Caption = "Time Sheet" .FaceId = "1106" .OnAction = "OpenTimeSheet" End With On Standard Excel (2002) you can able to 'Edit Button Image' via the Customize Dialog box. It is...

Hello, my VBA is working fine, it is creating a report base on same reports from several files - these files are varies in row numbers. The formula got too long ... =+'S:\fincon\(3)OneWorldAccy\Budget 08-09\test\[BUDG0809-RES-DCX.xls]D Report'!$B$30+'S:\fincon\(3)OneWorldAccy\Budget...

I am trying to print every items listed on the "CurrentPageList" within the Pivot Table. Below is an extract from VBA Excel Help Page... pvtField.CurrentPageList = "[Product].[All Products].[Food]" How can I count the number of items within CurrentPageList so that I can go thorugh each items...

Hello there. This VBA scripts in Excel 2002 doesn't seems to work for people with Excel 2000 or earlier. ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingRows:=True, AllowFiltering:=True How can I overcome this, i.e the user should be allows to use the...

Just a quickie, I have created a form on Excel which when completed by the recipitant is mailed back to me via a button which I have placed on the form and written the macro for. What I wondered was you might know how I can get the users' e-mail address. So that when they click the send button...

I have written Excel VBA for one of my department to created several monthly reports. They new have a new method, rather than emailing the report out, they set up several folders on the Novell Network (v4.90 SP2). They asked me whether I could write a Excel VBA to check each month if the...

I am in the middle on building a VBA in Excel that have DAO connection to Access. I am just started to learn about DAO and ADO. I am confused. Is there a DAO version of ADO's DoCmd.Transferspreadsheet (import) VBA script?

I am trying to build a Function that return with a message plus color coding. The Function does work in term of return the necessary string and it does set the Conditional Formatting criteria BUT not the colours. On the Condtional Formatting box, its stated "No Format Set". Why can't the...

Hello. I am trying to make my Excel Form (from VBA) disign to look very professional. On the Form, I have a button which Open the Access Database, but this button's text is displayed as "ACCESS". Is it possible to replace this text by a picture, I want to see the FaceID = "264" (the Access...

Worksheets("Sheet2").Activate Range("I7").Select ActiveWindow.FreezePanes = True Why can't I use... Worksheets("Sheet2").Range("I7").FreezePanes = True The worksheet is Acitvate on Sheet1. YOu guys told me to reduced the "Select" and "Activate" method.

I am struggling to control the font size! Below, the Chart Title ended up with size 19.75 and legend font as size 11.75. Why? Sub MakeDoubleBars(endrow As Integer) Dim DCht As Chart Set DCht = Charts.Add Set DCht = DCht.Location(Where:=xlLocationAsObject, Name:="D Chart") With DCht...

I write macros to manipulate text files, some takes a while to complate the whole job. Other department now have my macro, but when they start running the Excel macro they manually switch over to other applications therefore causing the macro to crashed and they blamed me! Is there a way of...