-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Passing on a value on an existing Access Report
by Shlizar Axis
- 0 Replies
- Last post
by Shlizar Axis
- I'm currently fighting with an Access 2002 Report. Here's the thing... I've created a report based on a query i've created. The query itself displays a series of receipts which have been added to the database via certain form. However, the user wanted to interact with the Report in a way that he could determine the content of the report by selecting a period between x and y.
I've done so by cre
-
- Digital Signature of Macro Project invalidated after saving Excel Workbook
by Dave Hary
- 4 Replies
- Last post
by Robo Coder 1
- I am having a problem loosing the digitial signature I have applied to the macros in Excel 2003. This also applies when using Excel 2000 to open the workbook.
Quite often and for no obvious or traceable reason the digital signature I applied to the macro project is rendered invalid after the workbook is saved. As a result, the next time I open the workbook I get the error indicating that &
-
- Newbie in VBA Drag and Drop..
by den2005
- 8 Replies
- Last post
by den2005
- Hi,
Do not know if this is possible drag and drop effect of items in dropdown control inside a word application
The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done
Thanks in advanced.
den2005
-
- vba macroes: how to pass data to an excel chart
by Andrea72
- 2 Replies
- Last post
by Andrea72
- Hello,
I would like to pass data (stored in an excel sheet) to an excel chart using a macro. Since the range containing the data, I want to pass, is dynamic, I can't use .Range("a1:b50") for example, but something like Range(Cells(1,1), Cells(50,2)). Unfortunately it doesn't work.
May you suggest me a way to achieve my goal
Thank you for helping me,
Andrea
-
- Fixed!!!
by PatrickRyu
- 2 Replies
- Last post
by bennymacca
- I am using MS Access 2002 SP3. When I run queries and the like the file size continues to grow until it hits ~2GB at which point I can no longer run queries, import data, or any other operation (I am given the error message "Invalid Argument"). I have deleted all but one table and all queries but the file size remains constant (and that table was reduced from 15 million entrie to just 80
-
- VBA read a value and not a formula
by Pompoire
- 3 Replies
- Last post
by Peter Mo.
- Dear All,
I have a question, I want to sum some values if a reference is equal to a date that I implemented in a cell that I defined as name (defined as string)
name changes in a loop.
I used the following formula
ActiveCell.FormulaR1C1 = "=SUMIF(R[-2]C10:R[-2]C100 ,"" = name"", RC[7]:RC[84])"
unfortunatelly it does not take the VALUE of the nam
-
- VBA automation
by Kazzle
- 0 Replies
- Last post
by Kazzle
- I am having difficulties using automation between excel and powerpoint in VBA. I have a powerpoint presnetation that has linked charts in excel. I have a macro in excel that does various other things before I need it to open powerpoint, update the links then save the presentation under a different name and break the links within the presentation.
I have used early binding to reference power
-
- Getfile with different extensions
by Jim@flambeauriverp
- 0 Replies
- Last post
by Jim@flambeauriverp
- What I am trying to do is retrieve different sets of files from a folder and display them on a page (see following)
' Get File Info
' You can easily filter results by name... I just want a list
' of all the files, but you could filter here if you wanted.
arrFileInfo = myDirInfo.GetFiles("*.pdf")
'arrFileInfo = myDirInfo.GetFiles()
In the arrFileInfo = myDirinfo.
-
- vlookup
by Namrata Prashar
- 14 Replies
- Last post
by Namrata Prashar
- Hello
can anyone help me with how to write the excel vlookup function in vba
the function in excel looks like this
VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE)
how can i get something similar working in a macro.
thanks
namrata
-
- trying to assign a control on a report a value from a table and am getting an error message described below
by Marsha D. Carpenter
- 2 Replies
- Last post
by Marsha D. Carpenter
- trying to assign a control on a report a value from a table and am getting an error message described belowI have a report module in MS Access 2003 and I know I have written code to do this before but I cannot get it to work! Please Help. A copy of the module is displayed below. when I run this code I get the following MS VB error: Run-time error '2448'; You can't assign a value to this object. I
-
- Microsoft CRM 3.0 rollup2 problem
by cycloneV
- 5 Replies
- Last post
by dash999o
- I am running outlook 2007 on a pc. I am trying to install CRM with the latest and greatest compatiability hotfixes. I am recieving the following error:
Action Microsoft.Crm.Setup.Client.InstallPstAction failed.
LaunchOutlookInstallerProcess failed
Any help
-
- Subtract a date
by F&#225
- 6 Replies
- Last post
by Fábio Nobre
- Hi, I'm creating a aplication whith Visual Basic and I need to subtract dates, now I'm using a simple method: Subtract a Month: ---------------------
If optmes.Value = True Then
(DateValue(Now) - 30) & " " & TimeValue(Now) Subtract a Year: ---------------------
If optano.Value = True Then
(DateValue(Now) - 365) & " " & TimeValue(Now) But this met
-
- IF statement
by DinnerPlates
- 3 Replies
- Last post
by Andy Pope
- Hi all, I am trying to write an IF statement that will affect two cells. So, for example: - In cell A1, I have the value 10 - In cell A2, I have the value 5 - In cell A3, I have the IF statement "=IF(A2<A1,"Order","Do Not Order") Easy enough. But, my problem lies because I have a cell next to A3 with text in it that needs to be cleared once the value is false. Does anyo
-
- Sept 2002 Action Pack - What was X09-59757
by SimpleSimon
- 1 Replies
- Last post
by MS ISV Buddy Team
- Can anyone tell me which CD X09-59757 was, from the Sept 2002 MS Action Pack
I've got a CD sleeve here with a CD Key, and the above number, but no CD to put in it.
...and since I'm asking, how about X10-17366. I *think* that it's for the Evaluation version of Outlook 2003, but can't verify this. This would be from the January 2003 Action Pack.
Thanks!
-
- Why I can't get my crashes in winqual account?
by Nikolai Bochkarev
- 3 Replies
- Last post
by Saar Picker
- Hi!
Continue working with WER Api in Delphi
Part I " Some questions about WER "I
I try to integrate WER support in delphi application and write own exception process based on WerReportCreate and WerReportSubmit functions.
I'm raise exception, get right Bucket ID ( 50248784 ) and view status : Report Sent (see next screenshot)
I can't get this^^^ report in
-
- 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
-
- Dynamic Lists in Excel
by SHolst22
- 4 Replies
- Last post
by suna2006
- I created a list in Excel as described in http://www.contextures.com/xlDataVal02.html
I want to have the following structure of dependant list.
List 1
List 2: Contents dependant on List 1
List 3: Contents dependant on List 2
List 4: Contents dependant on List 3
List 5: Contents dependant on List 1
I created List 1-4 using the method described in http://www.con
-
- MS Office document and image writer print driver
by GTH
- 14 Replies
- Last post
by Mary3480
- Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to
-
- 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
-
- 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
-
- Automatically Resize Access Form to Fit Screen Resolution
by Solomon_H
- 0 Replies
- Last post
by Solomon_H
- I was wondering how to have my Access Form automatically fit the screen for each individual screen resolution. Anyone have any ideas
-
- Loop causing MS Word freeze
by une
- 6 Replies
- Last post
by Andy Pope
- I tried to run a simple loop I created as a macro employing a user form that contains a label and a command button. I want the label caption to alternate between OFF and ON as the command button is clicked. There must have been an error of some sort as when I ran the macro it froze MS Word completely. No compile error ever appeared and the macro DID begin to run without protest. I looked
-
- adding text to cell with vba script
by Derek at Potters Clay
- 5 Replies
- Last post
by magicalclick
- I've done this before but I am completely blanking on what I am doing wrong with adding text or in this case a formula to a cell. The line I have and am getting an error on is
Workbooks("DSL Annual Rollup").Worksheets("DSL Annual Rollup").Cells(i, 3)="January!D"&i&"February!D"&i&"March!D"&i&"April!D"&i&a
-
- Importing Flat file into Excel Spreadsheet
by Peck Chun Hua
- 2 Replies
- Last post
by Mezhick
- Is there a way to transfer a flat file into Excel Spreadsheet using VBA codes
Example of flat file is:
mmccccc aaaaaaaaaabbb
zz4444444 4 44444444444
For 1st line mm goes to cell a1
For 1st line ccccc goes to cell b1
Fore 1st line aaaaaaaa goes to cell c1
For 1st line bbb goes to cell d1
For 2nd line zz goes to a2
For 2nd line 4444444 goes to b2
For 2nd