I am logged in on the system with an NT account which has full permission to the database. The System DSN is set to use the sa account, which naturally has full permission to the database. When I change the System DSN to NT authentication, the program works fine. Kate
[reading]
Hi,
I have an application that sits on our server and generates pdf reports from various crystal reports from a SQL server. This worked fine on the machine I created the program on, but when I installed it onto the server (which has the SQL Server on it that the data comes from), when I try to...
I would prefer to try using the triggers, but I don't know how to set this up - I know where to set them up, but I don't know the code to put in there - could you help me please?
Thanks Kate
[reading]
Hi,
We have a web-based program that has a SQL server back end database. I want to be able to see what tables get updated when we add calls via the web-based front end. We are trying to customise this program but we need to see exactly what happens when you do anything in the front end. I am...
Thanks for that - didn't do it quite how you said, but I did get there from your pointers. Because the command line parameters will always be the same length, I used Left$ Mid$ and Right$ to split the string up and then use them with my crystal report exporting code.
Thanks again! Kate
[reading]
Hi,
I have a program that generates a pdf file from a crystal report, among other things. This report has date parameters passed to it via text boxes on a form, which the defaults are 1st and last day of previous month.
I would like to carry out this function by passing command line parameters...
Hi,
I want a real simple program that allows me to enable/disable a device in device manager. I installed a friend's PC with XP and their digital camera will only work if the scanner is disabled and vice versa (good old XP!), they have kids so they want a program that will do this for them...
Hi,
I just installed a friend's PC with XP, everything was fine (well, as fine as it could be with XP!) except having installed the scanner, we went on to install the digital camera which stopped the scanner from working. Anyway, to cut a long story short, if the scanner is disabled through...
Sunaj,
Thanks for that - got it working (almost - just a couple of tweaks to pickup the right recordset!!)
Really appreciate your help with this! Kate
[reading]
Hi Sunaj,
I have edited your code as follows:
objConn.Execute "UPDATE Reports SET ReportNumber=fileName WHERE ReportID=ReportID"
Where fileName and ReportID are variables.
When I run the code, it says invalid column name "fileName"
Do you have any ideas? Kate
[reading]
Hi,
I have a program that generates Crystal reports. I want to keep track of the reports and when they were generated so I have a reports table and a reports history table (in SQL). My code adds a new record to the history table for every report, but what I also need is for a field in the...
Hi,
Thanks Joe, I managed to sort it out - I had to change the permission on SQL so that it picked up NT logins - now it works fine!
Thanks for your help, Kate
[reading]
Hi,
Thanks Joe, I managed to sort it out - I had to change the permission on SQL so that it picked up NT logins - now it works fine!
Thanks for you help, Kate
[reading]
David,
I don't suppose you found a solution to this? I have just created the simplest of forms with a completely straightforward report (no parameters) - and when I run the report, the viewer just flashes and then disappears.
Thanks for any help you can give, Kate
[reading]
Thanks for all your help - I think I will spend some time reading the books I have as I am sure what I am trying to do is really unecessary and there will be a really simple way to do it!
I will go and have a lie down and start again tomorrow!
Thanks again for all your help and the time you...
I have deleted my projects so far - I try something new each time, so I am starting from scratch.
I will explain why I am doing this and you may be able to suggest a much better way to do it...
I am really writing a small add-on - the SQL database was designed for a helpdesk and has a web...
Hi Sunaj,
I used the data form wizard but the 2 main problems with that are - I can't use a view from sql, only tables, and there doesn't seem to be an option where I can choose the UserID and view the other details?
This seems to be alot more complicated than I thought!!! Kate
[reading]
Thanks Joe, tried that - but it comes up with error message "Object required", then when I debug, it shows the line rs.source = "Select * etc.... - any ideas? Kate
[reading]
Thanks for all your messages - I am so sorry I am getting confused - I will explain myself a little better.
I have 10 records and 3 fields (there's a lot more, but doing it for this will get me well on the way!!) - UserID is different for each, and they each have Surname and Forename. On my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.