Search results for query: *

I have developed an application that uses crystal reports for it's reporting but when I install this on a client machine it brings up a crystal error. Are there any crystal report run time files I can install on the client machine? Also how do I create an install package for a program that I...

Morning All, I have a problem with our new 2003 IIS 6 webserver. I can see normal html webpages but when I place my ASPX pages up it reports that it "could not load type '_default' the aspx project is using framework 2.0 and the IIS server has framework 2.0 on too. I have all my .aspx & .vb...

Dim strSQL As String 'Update Existing strSQL = "UPDATE cashier SET FullName = '" & txtName.Text & "', Address = '" & txtAddress.Text & "', Telephone = '" & txtContact.Text & "', Age = '" & txtAge.Text & "', NI = '" & txtNI.Text & "', EContact = '" & txtEContact.Text & "', EName...

I have the following script: drop table import_temp CREATE TABLE import_temp ([col1] [float] NULL, [col2] [float] NULL, [col3] [float] NULL) BULK INSERT import_temp FROM 'C:\test\tilldata\2100200850.csv' WITH (FIELDTERMINATOR = ',', FIRSTROW = 2) declare @f1 float declare @f2 float...

Morning, I have a function that gets all the file names within a dolder and lists this to a listbox. I already have the function that opens a file and then reformats the date in the file and then saves it in another file format for me. But as there are many files in the folder I need to do...

Evening All, Does anyone have any idea on how I can format a txt file that is already populated with text. The file comes as: ICR,Z1,50,1,14:55:07,15/10/2008 28,10.00,459.00 29,14.00,459.00 30,16.00,512.00 and I want it to just be one line ICR,Z1,50,1,14:55:07,15/10/2008...

Morning, I have some txt files in the format of: ICR,X3,51,2,10:37:40,14/10/2008 1,2,137.00 3,1,8.00 Here is the problem: I have my table laid out as net_sales | gross_sales I want to ignore the first row which I do with FIRSTROW = 2, and insert the other two rows into the columns but...

Afternoon, I am finding it difficult to send an email via a asp.net project I am working on. I have posted the code I am using below Dim mMailServer As String Dim mTo As String Dim mFrom As String Dim mMsg As String Dim mSubject As String Dim...

Dim strSQL As String strSQL = "UPDATE tblauth SET " strSQL = strSQL & "email='" & txtEmail.Text & "'," strSQL = strSQL & "telephone='" & txtTelephone.Text & "'," strSQL = strSQL & "mobile='" & txtMobile.Text & "'" strSQL = strSQL & " WHERE username='" & Session("UserName") & "'"...

Hey All, I have an application that is receiving a reponse from another program. The program sends it's response as: 1=9 0=999 Now the reponse is not always the same and I want to use a select case to read the reponse. Dim strReceive Winsock1.GetData strReceive txtReceive.Text = strReceive...

Morning All, I have a problem with a control array I am setting up to place some buttons on a form but the information like colour, caption, tag reads from a database. Dim strIndex As Short Dim rs As New ADODB.Recordset() rs.Open("SELECT * FROM tblButtons", conn)...

Hey All, I have come to the concluesion with POS printing. 1. I cannot find any good OPOS examples 2. Printer function in I cannot get it to format the receipt within code proberly. 3. When printing from vb there is a 15sec delay before it will print. So what I want to do is write the...

Hey All, I have the following code which prints out a reciept but what I want to do it Left Justify the frmMain.ListView1.ListItems(i).Text as this is the price. I want the receipt to print like so: 13/08/2008 12:00 Cashier : Richard Till: 1 1 x Kingsmeal £0.90 2 x Milk...

Hey Guys, I have a problem with connecting to a MS SQL database through a script. It works prefect on my login as I am a domain admin bu on normal users it fails to connect with the error: Login failed for user 'DomainName\Username' I have posted the code for you to review but I am passing...

Hey All, I have an issue with installing/copying/changing services on users that do not have administrator privilages. I want to know how I can pass a username/password either in vbscript or dos to install a application as an administrator basically preform a RunAs. Any ideas please let me...

Hey All, I have created a little script that will talk to AD and get certain user information and then generate a htm file and write a few registry keys to store that signature. It is used as part of a login script for all users. My Problem is we have outlook 2000 & 2003 clients out there and...

Hey All, When we buy a router from our cisco supplier we update the software to 12.4 which is great cause all our router functions work. Our problem is that when we try to connect the http interface via a PC at work or on a PC there at the store it will not connect. We have this in our script...

Hey Guys, I have a quick question, We have some retail stores that we connect to our network via a secure VPN link. We use a Cisco 837 on a 2mb ADSL line VPN'ed into our head office. We had a cisco guy come in to hook up our very first store for us as we are not cisco people and I know enough...

Hey, I have a Cisco router 837 and I want to unblock some ports I use a script to configure the router at present as I configure many for our stores. I have been asked to unblock some ports and when I try to do this via the web control panel it always dies whenever I try to save any settings...

Does anyone know of a web forum of where people post questions about what type of exams / problems / help they need for Microsoft training. As I have not beem able to find a dedicated forum for this. Cheers UKmedia productions http://www.uk-media.com