-
- 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
-
- Projects, objects & modules
by une
- 14 Replies
- Last post
by une
- I
started learning VBA in MS Word yesterday. I have some programming
experience in C++ and Java. I am trying to understand how the
environment is structured and what Projects, Objects and Modules
represent.
For example I recorded a few macros using the macro recorder and
then opened the VB Editor to see what was created. I notice that under
"Project" are 3
folders. One is named
-
- Creating Excel File Error
by CoderMike
- 2 Replies
- Last post
by CoderMike
- Hello,
I'm trying to create an Excel file using ADO. I can read from an Excel just fine, but creating it has been more of a problem. When I try to open a connection to a file name, I get "object not found" error. According to the MS article I read, the workbook should be created automatically when I create my first table in the workbook. However, I can't see how I can do this if t
-
- VBA Help?
by NWAprog
- 6 Replies
- Last post
by NWAprog
- I'm new to VBA programming, while I understand Access a fair amount, I am continually running into the same problem. Can anyone help.
I am developing a program for my job that tracks times. I have created forms that are supposed to make the entry easier and faster. On the first form the operator enters the information relating to the trouble call, when the submit button is clicked, the info
-
- Is an Excel bug that set PivotItem.Visible to true will generate 1004 Macro Error?
by johnson hk
- 13 Replies
- Last post
by dionjuan2004
- In a Excel PivotTable, I want to programically hide or show some PivotItems of a PivotField. To hide, it works fine (just set mPivotField.PivotItems("xxx").visible = False). However, to show, it does not work: mPivotField.PivotItems("xxx").visible = True. Program breaks with an error 1004, macro error. When try to record a macro for setting a non-visible PivotItem to visible, m
-
- VBA Or Access
by Crysallis
- 2 Replies
- Last post
by Crysallis
- Currently I've written a db and on one of my forms I've used the builtin combo box tool and used it to have you select and item from the list and update the data on the form. Now on my machine I can, when I open the form, simply start typing in a number thats inthe list and it will seek to that number and I can press enter and it will update the form.
Now when I do this on another machine it gi
-
- Emailing data with Access
by DJRave
- 0 Replies
- Last post
by DJRave
- Hey there!
For my work I keep track of things in an Access database. I receive data, edit and regroup it and after that distribute it to other people. Every month I have to mail exported *.txt files to a group of people. And since not everybody gets the same data I need to select the files/emailaddresses manually. I want to let access do this automatically to reduce the work and chances of
-
- running access queries using VBA
by A Zhu
- 1 Replies
- Last post
by ADG
- Hello,
Say for example, I would like to using a dynamically generated query (using VBA) to select the records in such a way that, for example, the Client ID field in table A has to be found in the CID field somewhere in Table B and the Amount field in Table A should be differ by the AMT field in Table B by no more than 100.
How could this be accomplished using VBA
Thanks!
-
- SAP
by envi_ria
- 11 Replies
- Last post
by envi_ria
- HI
Does any one know what is the procedure and purpose of doing SAP.
What are the requiments, and how can I go about doing the training. What are the courses available for the same.
I am an IT trainer for the last 2 years would like to do SAP.
Supriya
-
- Attempted to read or write protected memory. This is often an indication that other memory is corrupt
by Girish Nair
- 4 Replies
- Last post
by Tan Check Leam
- I am getting this error when trying to open oracle connection from visual studio 2005.
I am pasting the stack trace here.
at System.Data.Common.UnsafeNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(OciEnlistContext pCtxt, IDtcTransaction pTrans)\r\n at System.Data.OracleClient.OciEnlistContext.Joi
-
- Disable macro toolbar button in macro itself
by oryan_dunn
- 2 Replies
- Last post
by oryan_dunn
- I have a macro that I want to disable after it is finished running. I would like to grey out the button on the toolbar. Is this possible If not, how would you recommend removing/disabling the button
Thanks,
Ryan
-
- Worksheet.Copy causes execution to stop
by pnp
- 11 Replies
- Last post
by pnp
- Hi
I am experiencing an odd behaviour from my VBA code in Excel.
I have some code that has worked until recently. We have gotten XP instead of win2k, which i could suspect is causing this in some strange way.
My problem is that i have the code below. In the line where i say Worksheet.Copy, the execution simply stops. No errors appears, nothing.
<CODE>
On Error GoTo ERROR: W
-
- 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
-
- Subscript out of range with a simple sql :-( [newbie to VBA]
by Maximus
- 14 Replies
- Last post
by Andy Pope
- Hi all, can anyone assist on this one (I'm newbie to VBA) I'm trying to get the list of items from mySql (I have a successful connection) for some reason I get this error message: Run-time error '9': Subscript out of range. thanks for any pointers!
Code Snippet
Private Sub btnTestReadInMysqlData_Click() Dim objDB, arrRecord, strRecord, strOutput Dim oRS, nRec, oFld Dim row '
-
- Spooler error 1068
by Terminator484
- 14 Replies
- Last post
by virginia3443
- I have been all over hell and high water trying to find some way to fix this error, but alas, my efforts have been fruitless; so here I am. The Situation: After moving about a week ago, I just got around to re-attaching my printer (a Lexmark X1185 ). I then discovered that my computer (Windows XP sp2) apparently deleted my printer drivers all by itself, so now I cannot use the printer. I downloa
-
- windows vista program files protection
by sharadam
- 2 Replies
- Last post
by Mo Nail - MFST
- Hai all, i am installing my application at c:\program files\ APPFolder. At the time of installation, default settings are stored in config file at c:\program files\ APPFolder\configsettings.xml . when i made changes in application , i am updating all settings to an XML file . when i unistall my aplication i am removing xml file. when i reinstall my application as admin , again config file with d
-
- Does Winqual accept WER reports from Vista systems?
by Claus Brod
- 14 Replies
- Last post
by Jason Hardester - MSFT
- Hi all, we recently registered for the Winqual site. Reports are coming in about crashes in our application which occur on Windows XP systems, so it seems like the whole registration process worked as expected. However, we also ran our application (same version as on XP) on Vista, and provoked several crashes (same type of crashes as the ones on XP) there - but don't see *any* reports on the Winqu
-
- 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
-
- Read data from excel through VB.NET
by Prasanth.P.P
- 12 Replies
- Last post
by Srini111
- Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim
-
- ExOleDB in Exchange Server 2007
by Alexander Basyuk
- 2 Replies
- Last post
by Young Developer
- I have developed an agent for Exchange Server. It use exoledb and event sinks for interacting with Exchange. For registration we use RegEvent.vbs (from Exchange Server 2007 SDK).
It works fine on 2000/2003 versions. But on Exchange 2007 even RegEvent.vbs script doesn¡¯t work. It shows ¡° Error Opening Connection : 3706 Provider cannot be found. It may not be properly installed. ¡±
I use
-
- Creating new table in Access 2003
by Tantani
- 2 Replies
- Last post
by Tantani
- Dear, I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA. Any solution Thank you in advance!
-
- iexplore.exe application error
by stargal46
- 6 Replies
- Last post
by Morena916
- Hi...I'm not sure if I'm putting this in the right forum, but here goes. I'm receiving an error message which says,
iexplore.exe - Application Error
The instruction at "0x66869bc7" referenced memory at "0x0000002c". The memory could not be read".
Click on OK to terminate the program.
I had trouble installing QuickTime player and then when i finally did get it t
-
- How to check is there duplicate value somewhere in Combobox
by Hoowah
- 2 Replies
- Last post
by Andy Pope
- I was wondering, is there a way to check if there is same string value in Combobox with Excel
Basicly I'm trying to make a check that makes sure, there are no duplicate value of the value I'm adding to Combobox. I tried to get the values like this, but it didn't work.
ActiveSheet.Shapes("Combobox").Select With Selection For i=0 To .ListCount If .Item(i) = someString Then
-
- Vba Excel 03 - Detect Shape Position and calculte related row number when sort / filter is activated
by ajliaks
- 6 Replies
- Last post
by ajliaks
- Hi guys,
I have an excel datasheet where each row has on it a Shape called "myShape" + the Number of the Row where it is located, in example:
-
- 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