-
- Access forms - record change event
by ADG
- 1 Replies
- Last post
by ADG
- Hi all
I have an Access form which allows entry / editing of product specifications. There are approximately 5 different types of specification. I want to capture an event when the record on the form changes so that only the relevant fields are displayed. I am struggling to find the right event on my form. Any ideas
-
- Reference to a String
by James Strater
- 1 Replies
- Last post
by Adamus Turner
- Excel 2003 VBA: I have a class module that needs to refer to a global variable, but I don't want to force every project that uses the class to declare such a variable - the functionality here is optional, yet I need the variable to persist. I also don't want to force projects that use this class to globally declare instances of this class, there are already quite a few projects that use the class
-
- LBound and UBound functions
by Keithyboy1
- 7 Replies
- Last post
by Shlizar Axis
- Is there a reference library I need to enable in the VBE to get LBound and UBound functions
They don't appear to exist in the Object Browser with the current reference libraries I have enabled.
Many thanks!
-
- Convert Excel sheet to PDF using VB macro in Excel
by JamelB
- 1 Replies
- Last post
by Bruno Yu - MSFT
- I am a beginner programmer trying to write a code to convert an excel sheet to a pdf file. I want to include this in an excel macro. HELP please!!!
-
- Problem: Macro not deleting columns I select
by Donaghy
- 6 Replies
- Last post
by Donaghy
- Hi all,
I have a section of code in my macro which tells it to delete a selection of columns:
Columns("C:F").Select Selection.Delete Shift:=xlToLeft
this is the first bit of code in my macro but isn't working correctly. Instead of deleting columns C to F its deleting columns A to H.
Any ideas why this could be happening
-
- Protecting formulas in cells
by chrstdvd
- 6 Replies
- Last post
by js06
- Hello,
Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the sheet is protected or not, so that formulas can not be erased or overwritten
Thanks Chrstdvd
-
- Checking the status of autofilter
by pps!
- 1 Replies
- Last post
by ADG
- I have an excel report on which i have to write the program for making formatting changes in that. But before that i want to check the autofilter (Selection.AutoFilter) status (whether on or off).
I want to check this in the midde of my code.. code . . if autofilter is ON xyz if autofilter OFF Make it on . .
How to do this
-
- vlookup for a range of cells
by vranjit138
- 4 Replies
- Last post
by vranjit138
- Hi
In Sheet 1 i have columns (A,b,c,d) "Names", "Marks", "Age" and "Location"
i have thrity rows of data for these columns
in sheet 2 i have one column showing the names (thirty rows) - Column A . i would like to populate in column B the data relating to "marks" or "age". The column reference in the vlookup formula should be
-
- Accessing a subform, error 2455
by storras
- 4 Replies
- Last post
by Andreas H
- I am trying to access the fields in a (bound) subform that exists in a tab control, inside a form dim ctl as control set ctl=me.controls("subformName") dim frm as form set frm=ctl.form.... here a crash happens at run time, with error 2455 (invalide reference to a Form/Report property) I am stuck in this subject, and I have been doing that many times, with no problem May I get some advice on how to
-
- Using arrows to select in drop down list in access
by RhysDavies
- 4 Replies
- Last post
by RhysDavies
- Hi - anyone know how to get a drop down list combo box to allow you to select an option using the up/down arrows on the keyboard in access rather than having to click on the down arrow on the combo box in access - user wants to do it by tabbing into boxes and using the arrows to select because its quicker.
thanks,
Rhys.
-
- activate a sheet containing a specific chrtobject
by JS
- 2 Replies
- Last post
by JS
- Hi all,
I have a macro that lets the usr mark a chart that the usr wants to add serie(s) to. After the usr has picked the data for the new serie I want the macro to return to the sheet that contains the pre selected chart. How can I get this sheet with the information set in the beginning (ACh)
Dim ACh as Object ''' Can be Embeded or chart sheet
Set ACh = Nothing
Set ACh =
-
- Overflow (error 6)
by une
- 5 Replies
- Last post
by Keithyboy1
- I have code that executes fine 99% of the time. The other 1% I get an overflow error (error 6) that relates to the following line;
startTime = Year(Now) * 365 * 24 * 3600 + Day(Now) * 24 * 3600 + Hour(Now) * 3600 + _ Minute(Now) * 60 + Second(Now)
startTime is declared as a double;
Dim startTime As Double
The value of startTime at this line (according to debugger
-
- Adding Outlook signature using OLE automation.
by jpas
- 5 Replies
- Last post
by jpas
- Is it possible to add a signature to an Outlook message using OLE automation
Outlook is configured to automatically add a signature to outgoing e-mails. If I don't try to set objMailItem.HTMLBody to any value after creating the Mail Item object, the signature is in the e-mail as expected. If the HTMLBody is set to a value, the signature is lost. Trying to pre-pend the application data to t
-
- Once copied, can we export as a GIF file?
by Perry Choy
- 14 Replies
- Last post
by duck thing
- How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much
-
- help required related LCS(Live Communication Server).
by kultuze
- 1 Replies
- Last post
by MS ISV Buddy Team
- i wanted to make a client that will get the status/username of the user from the LCS and initiate a collaboration chat session between the LCS users and between my client application.........is it possible our nt .
-
- this problem is also troubling me now!! :(
by Moim Hossain
- 14 Replies
- Last post
by WebDev2000
- Hello everybody,
I am getting some trouble around SharePoint Object model. I was intended to write a console or windows application that will connect two SharePoint site (One is SharePoint 2003 and the other is SharePoint 2007) and will move/copy documents from one to another. I have tried to connect to the SharePoint 2007 first and it was connecting fine. (I was running my application int
-
- Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset
by remitdlo1944
- 5 Replies
- Last post
by bbenz3
- I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal.
-
- WMI.Net 2.0
by GUYO
- 11 Replies
- Last post
by Gabriel GHIZILA
- The next manged code library for WMI was discussed at TechEd this year and has popped up in a couple of webCasts. -- The WMI.Net 2.0 is supposed to provide writeable properties and invokable methods from managed code.
Is there an update on the release Beta program etc... --
-
- Word document
by Ravi@asp.net
- 0 Replies
- Last post
by Ravi@asp.net
- Hi Friends
I have two word documents.I have to compare the both documents.The difference between the two document is that the second documents contains an image,insert some data or delete some existing data.I am able to find the changes and store the result in another document in which the changes reflects.Now our main moto is how can the end user identify that there is a change of only ima
-
- iexplore.exe - Application Error
by bennett1016
- 14 Replies
- Last post
by rreynard
- I get the following error message when I close my internet explorer.
The instruction at "0x62304320" referenced memory at "0x62304320", The memory could not be "read". Click on OK to terminate that program.
Any ideas what is causing this
-
- How do I deal with files of more than 65k rows?
by chilehed
- 8 Replies
- Last post
by chilehed
- I need my code to be able to deal with .csv files of well over 65k rows, but haven't the slightest idea how to do it.
I've heard of a technique called "paging", which distributes the data over more than one sheet but processes it as if it's on one.
How is this done
Thanks.
-
- Using VBA macro to locate next free column on worksheet
by rabbitoh
- 14 Replies
- Last post
by magicalclick
- I need a macro that locates the next free
column (i.e. has no data in cells) and then places the cursor in a cell on a
designated row. Would like search to start from column B and to place the cursor
on row 4 on the free column.
<>
My VBA code thus far:
Function NewColNumber(Range1 As Range) As
Integer
Dim j As Integer
For j = 1 To Range1.Columns.
-
- Setting a Bookmark to insert a Page Break in MS Word
by LeVraiNinjaneer
- 2 Replies
- Last post
by LeVraiNinjaneer
- Hi!
I know how to use setBookmarkString, but I need to insert a Page Break with a Bookmark. What Function do I use
thanks in advance
Pieka
-
- Macro - Replacing Contents of Cells
by rachel777
- 1 Replies
- Last post
by Shasur
- When dealing with the a spreadsheet, is there a macro code that would replace the contents of a cell with a "0" for all of the cells in each column in the Questions worksheet that do not match the criteria from a specific cell in the Solutions worksheet
I received wonderful help for a similar question on the same worksheet with the following original question:
I am trying
-
- Getting data from other workbooks
by Jeff DigiTech
- 4 Replies
- Last post
by Jeff DigiTech
- I have a master Excel file named (master.xls) and other slave files called ( slave1.xls, slave2.xls, slave3.xls ....salve5.xls and so on. ) master's structure is exactly the same as other of other salves where they all contain a number in cell A1 master will first select the slaves. And master wants to calculate the sum of A1(s) in slaves and have the result put in B1 of master.xls getting A1(s) f