Search:
Type: Posts; User: Pasvorto
Search:
Search took 0.37 seconds.
-
Now there's an interesting approach. I never considered using a view. I am only supporting this company until the end of February. They are converting to a new system so there really is no long term...
-
That just seemed a bit more complicated. I have used aliases before, but I'm not a fan of them. I am leaning toward just inserting a sub-report that accesses data from that table.
-
I have a report that gets employee data from a table (Table A). The report works fine. Now, the user wants to include data from Table B. The problem with Table B is that the data is not normalized....
-
I got it to work. using this code:
For rep = 1 To 15
output_sheet_Current = Sheets("Admin").Range("D" & rep).Value
If Worksheets(output_sheet_Current).UsedRange.Rows.Count > 0 Then
...
-
I did a search and did not see the same issue.
I have Excel2013. Worksheet "Admin" contain the name of the spreadsheet to clear. I want to clear all of the cells on the destination worksheet.
...
-
Thanks to everyone. I got it to work over the weekend.
-
I was looking at your tutorial. For now I would like to develop on a PC that has Excel 2007 but use the Excel 2013 coding. Do you think that is possible? Once I have 2013 on the dev machine there is...
-
-
Here is my code
Dim xlApp As Excel.Application 'Excel object
Set xlApp = CreateObject("excel.application")
Dim xlBook As Excel.workbook ' Workbook object
Dim xlSheet As Excel.Worksheet...
-
I will post the source code tonight.
-
I wish I had the source code at hand, but I don't. However, on the Windows 7 PC with Excel 2013 it throws an error at the first line of code that is creating the workbook.
-
The development PC is a virtual machine with 2007 on it. I was hoping to do some sort of check before processing. If dir <> = blah, blah, blah and have 2 subroutines, one for 2007 and one for 2013.
-
I have an application that is written in VB6. In a number of places it either creates or updates an Excel spreadsheet. Everything was working just fine until IT upgraded the users from MS Office 2007...
-
Update:
I discovered that the VB6 IDE will not function correctly with Windows7 SP1. It compiles an app that gives automation errors on XP machines. You must uninstall SP1. Unfortunately, my...
-
Finally got a clean compile! Now to test.
Thanks for the help.
-
OK. That got fixed by running this
http://support.microsoft.com/kb/195353/EN-US/
One of my forms has an "input past end of file" error that I need to investigate now.
-
Wow. That was fast. I ran that and it completed successfully. However, in the compile process, when it get s to writing the EXE, I get the same error message. I tried compiling to a different...
-
I registered those and got the same error.
License information for this component not found. You do not have an appropriate license to use this functionality in the design environment.
No...
-
I think it is having trouble with Graph.ocx & threed32.ocx
Not sure how to register those using Windows 7
-
The new PC is running SP6. The old one is on SP5.
I got all the forms across by editing the vbp file and the frm files. Now the compile is stumbling over some 3rd party components. I hope to get a...
-
I think I may have gotten a hint of what is happening. As an example:
It loads
frmInvAdditiveParam but does not load
frmInvAdditiveInventory or
frmInvAddChg
** note the 1st 8 characters **?
-
I am moving my VB6 IDE to a Windows 7 PC. All of the forms have loaded except for 5. When I try to add the form I get:
Errors during load. Refer to 'C:\Program Files\Microsoft Visual...
-
Say there are 100 employees. Each one has 5+ records. I show the employee group with the average of field 'match', not the detail record. I want a total of those group records. So if each employee...
-
I am going through employee records from a temporary database table. The detail records on the report are suppressed. I have a field called 'match' in each detail record. I have a group for each...
-
I wound up reinstalling the program and that seems to have cleared it up.
-
I am having an odd problem with a report. First details:
PC is Windows7 pro
App is VB6
Crystal version is 9.5
Whenever I run a specific report (call it ReportA) to screen on this PC I get an...
-
I got it to work by taking out
CnxnPR.Properties("Integrated Security"). Value = "SSPI"
and replaced it with the properties of user ID & Password.
-
I do have a proper setup program. It works just fine (on the XP computers). There is just something fishy going on with the Windows 7 units. Maybe copying it to desktop would not solve anything...
-
I have some code
Private Sub Form_Load()
MsgBox "DAD Launcher - 10/19/2011 10:00"
Dim filefrom As String
Dim FileTo As String
Dim Command As String
-
have you considered a listbox instead of a text box?
-
textbox.text = "something"
-
deleted the LocalSettings\Apps directory and that solved the problem.
-
I created an application using VS2008. I am having a problem on only one PC. If I log on to the PC as the domain administrator, it deploys and runs just fine. If I log on as the user I get an error...
-
Set parameter fields on the report and populate thoise when you run the report.
Kind of like this (CR9 and VS2008)
Dim report As New ReportDocument
Dim...
-
I will give that a try, Wild Bill. Thanks all.
-
Due to how the Insert command is constructed, wouldn't I have to account for that field?
sqlinsert2.CommandText = "INSERT INTO POHEADER...
-
Hack: The field in the db is set up as a date format. Won't "NONE" give me a type mismatch error?
-
I have the following code:
If Trim(txtConfirmationDate.Text) <> "" Then
sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", CDate(txtConfirmationDate.Text))
Else
...
-
So, if I understand correctly... Employee 123 opens a transaction screen. The system adds a record with a start time. When the transaction finishes, the databases updates the completed time. The...
-
I would think that there are many packages available that do network monitoring. Why re-invent the wheel?
|
Click Here to Expand Forum to Full Width
|