-
- Controlling Tables within MS Word
by LeVraiNinjaneer
- 0 Replies
- Last post
by LeVraiNinjaneer
- Hi!
I need to do calculations within tables on a document ni MS Word. The table needs to work out the number of knives, forks, plates table and chairs needed for a user-specified number of people (pax) at a wedding. The tables have to be formatted to look attractive as well, (with colours etc) How can I do this Thanks in advance for any help, I really need it Pieka
-
- Identifying blank cells with VBA
by veerle
- 1 Replies
- Last post
by MyLady
- Hi,
Pretty new in VBA, and trying to figure out how to identify a blank cell with VBA, but I can't figure out how.
Have tried cells(x,x).formula = " ", but that doesn't seem to work
Anybody who can give me a lead
Tx
-
- Edit the Recordset
by Tantani
- 5 Replies
- Last post
by Tantani
- Hellooo, I use Access VBA 2003 with DAO. Does anyone know how can I move to the first record of an Quantity attribute in order to change or Edit it like this: Quantity 0.50 1.40 0.70 ..... Goto first field (0.50), if it is lower than 1, then change it to 0 Goto second field ( 1.40), if it is lower than 1, then change it to 0, otherwise change it to 1. Thank you in advance!
-
- Create User Profile throw webpart
by hatem elshenawy
- 1 Replies
- Last post
by TruptiG
- i have trying to use CreateUserWizard control to add new user to aspdb and add new user to some groups and create profile , all the steps works fine by console application ,but when i create webpart , i can add new use and add him to groups but when i try to create user profile i get this error. "UnauthorizedAccessException: Access Denied: To create a user profile, you must be an administrato
-
- update plots with cell info change
by Jonas.S
- 2 Replies
- Last post
by Jonas.S
- Hi,
I have a plot macro, see code below which I would like to continuously update the plots when a change been made to reference cells(E45:G45 and N3:P3). Anyone out there who can help me with this
Sub Engine() COG_t = Range("E45:G45") Eng_s = Range("N3:P3")
'Declaring variables Dim xmax, xmin, ymax, ymin Dim x, y
'Calculats the engine's position
xmax = COG_t(1, 1) +
-
- Adding alt text, name, and hyperlink to pasted images from another worksheet.
by jrc1378
- 5 Replies
- Last post
by Andy Pope
- I have a workbook with the following sheets:
Display (Sheet1)
Data (Sheet2)
Images (Sheet4)
My sub is built to read reference data from Data! that tells it to copy a certain picture from Images! and paste it onto Display! at a certain location. It also grabs a label name from Data! and puts it to the left of the image just pasted.
All of this works fine, but I also need
-
- .mdmp files not being created
by David Ching
- 28 Replies
- Last post
by David Ching
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- Sending email via MS Access - problems using CC and/or BCC
by Valery123
- 3 Replies
- Last post
by magicalclick
- I am new to this coding business. I have search and tried so many ways to fix this in the last week - I am exhausted! Please help! Please provide simple asnwer; do not assume I will know where codes need to be inserted.
Please provide full coding as it must be inserted in the Event Procedure.
I am trying simply to send an email from a form. I am using the following Event but it returns
-
- .mdmp files not being created
by David Ching
- 28 Replies
- Last post
by David Ching
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- Unable to access the System Settings and Reports areas in a new CRM 3.0 installation
by jjbranc
- 2 Replies
- Last post
by Stephenho
- I have CRM, SQL and SRS on different servers, all within the same domain. I am unable to access the System Settings (I'm the Administrator) and the Reports. From what I've read on Google and Microsoft's sites, there's a configuration problem with connecting to the SRS server. I can use http://<reportserver>/Reports to see all the available reports.
Does anybody know how to solve this pro
-
- 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.
-
- Use VBA to compare two columns in Excel and highlight the cells that are similar
by Sreeja561936
- 2 Replies
- Last post
by doublehapiness
- HI, .
I have a workbook containing the data ..I am trying to create a macro in excel which compares values in each column and highlights the cells which have similar values...
Pls help
-
- 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
-
- Can you use VBA to access a spread sheet embedded in a word doc?
by Trisped
- 13 Replies
- Last post
by Trisped
- I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated.
-
- How could I count the last column in first row? Thanks so much!
by lyp_sj
- 1 Replies
- Last post
by Andy Pope
- How could I count the last column in first row Thanks so much!
-
- How do I display the same modified embedded chart each time?
by Steve. S
- 3 Replies
- Last post
by Steve. S
- How do I display a modified chart when a command button (cmdShowTemp) is clicked on a worksheet I used the code generated from a macro I recorded creating a chart using the wizard - using the data and making the changes I would like to see i.e. wider chart area, fill color etc, for this command. But I notice in the code the line Charts.Add, which I assume is why every time this command is clicked
-
- HELP! Please solve this problem...
by alexthian
- 1 Replies
- Last post
by Shasur
- I already make an exe of my VB6 project. My project contains 'user-password' form, 'key-in data' forms and data reports. I only copy the exe file and access file to test the program (exe) in other pc, i run the program and i get this error message: run-time error '713'. class not registered. looking for object with CLSID:{00000010-0000-0010-8000-00A006D2EA4}. So how to make this message 'disapp
-
- 3 consecutive periods = 1 character
by une
- 3 Replies
- Last post
by une
- I am using VBA under MSWord 2002. It seems that MSWord 2002 often treats 3 consecutive period characters as a single character. This is causing me grief as I am trying to write code to count punctuation marks in text. Thus my code counts 3 consecutive periods as 1 period. How can I get around this
-
- Using all controls inside a frame, but in the right sequence.
by My_Head_Hurts
- 8 Replies
- Last post
by My_Head_Hurts
- I have created a form to present a user with a list of choices. These are determined externally, so I read a text file (one line per choice) and then use the text to populate the Caption attribute of an Option (radio button) control. I populate the option buttons in rows and then make the unused ones invisible, adjusting the height of the frame and form accordingly. This all works beautifully exce
-
- New to Visual Basic
by darnold
- 5 Replies
- Last post
by darnold
- Im trying to do the following:
I created some command buttons that has the number 1, 2, 3, 4 on it, like a keypad or a calculator. When I press the button I want it to give a value (variable) of 1, 2, 3, 4, etc. At the same time if I press 1 and 4 on the keypad, Id like it to indicate 14 or 9 and 8 I would get 98.
What I'm trying to do is:
Button 1 = 10 * (number pad syst
-
- issue in vertical writing support in Uniscribe!!
by VNAHATA
- 3 Replies
- Last post
by MS ISV Buddy Team
- There are cases when copying a glyph from charmap into WORD rotates it 90 degree or sometimes 180 degree in case of Vertical writing .Does this information about rotation come from Uniscribe and if yes,how to get this info Examples of glyphs which are rotated 180 degree in vertical writing are U+2523,U+2517,etc and most other glyphs are rotated 90 degree(braces,brackets,etc).Please help me how doe
-
- How can I see the stack trace from the .mdmp file?
by Vedratna
- 14 Replies
- Last post
by Vedratna
- hi, everbody
we have recently created account in winqual and also successfully mapped our product over there. We also receive some error reports(buckets) in it. We have downloaded some of them in form of cabinet file. After extracting it we get the file having extension of .mdmp. I have opened it in windbg through open crash dump option. It opens it successfully but I can't see any stacktrace i
-
- Obtain Unique Work Units via SQL
by AlDeb
- 14 Replies
- Last post
by AlDeb
- Below is the SQL I have for a Query. The results of my query are below the code. Everything works great except for the WorkUnit totals.
I am getting the total Records for the date range and I really need the Unique workUnits for the date range. For this particular daterange I
have a total of 197 WorkUnits but in reality there really are only 89 Unique WorkUnits.
In the example below on on
-
- Compare Word Documents c#
by Ravi&#64;asp.net
- 5 Replies
- Last post
by Ravi@asp.net
- Hi All,
I have to compare the text of two word documents using C#. These word documents contain images and text also. But I just wanted to compare the text.
Can anybody please let me know how to do this
Thanks,
Ravi Mullick
-
- Live Communication Server 2005 SP1 - Specified backend for the pool is current in use
by Jensan_Ahsay
- 7 Replies
- Last post
by Peter Gu
- Hi,
I have installed the Live Communcation Server 2005 SP1 on my x64 computer with Windows Server 2003 R2 SP2. I found that i have given the wrong name for the DNS, and therefore i am trying to re-install it. However, when doing the step "Create/Upgrade Existing Pool", it gives the error "[0xC3EC78BA] Specified backend for the pool is current in use". The error is unders