Search results for query: *

Hi i am no expert on SBS but I saw yjos today. If you go into the server management, then users and you click on the user in question, somewhere in there (I cant remeber exactly which tab) there is a tick box 'force user to ctrl+alt+del to logon'. As I say I am no expert but it would be worth...

Hi I have an issue on a server with SBS2003. I consider myself pretty computer literate but am no SBS expert. Basically the internet speed seems to be being slowed down inside the server on a random basis. I have a 2 NIC setup with one NIC connectd to a broadband router, I get a connection...

Hi Thanks for that, my code is in the afterupdate of the chkbox. Your solution sorted the problem, though I dont really understand why. The error messages I got while trying to sort this out don't seem to help. Anyway Duane Many thanks for your help Alan

Hi I am using Access 2003, I am trying to perform a calculation and put the result in an unbound text box, If my chkbox(LotPrice) is true I want the calc to be price * qty and if false just price. I have put the code below in the afterupdate event but I get an error message. "You must save...

I found something else out! I have now got my code in the 'current' on the subform. It seems to work there unless there are a lot of transactions in the table. Also it always work when I break the code and single step it.

Hi Thanks for that. I have tried both of these and it dosen't seem to work 'properly' not always giving the correct response. It seems that the it gives its response before the subform has loaded up (I think) Just a little more info. The application is an inventory, and the subform is...

Hi I have a unbound textbox (unitsonhand) where the contents are calculated based on data in a subform, this works OK. I have now added a textbox linked to a field in a table (discontinued). I have a form that displays records with these items on it. I want to perform a check when each...

Hi I have been trawling the net for two days looking for a solution to this, so I hope that somebody has some original ideas. I have a Small business server 2003 with a access db backend installed. On the network I have 10 XP sp2 clients, though until I solve this problem I only have one...

Thanks Adrian Thats where i started off, I used the wizards and I couldn't get anything to work, /server/connectcomputer, and even the internet connection on the server. i followed a Microsoft tutorial to manually set everthing up and all was good apart from the client internet access. I...

Hi Adrian Thanks for your reply! Yes I have a 2 Nic config one to the LAN and one to a Netgear broadband router. Regards Alan Edwards

Hi This is my first server installation and I have a problem with getting the clients to connect to the internet. I have a new server running SBS 2003 and new PC's running XP. The clients connect to the server and straight onto the intranet with no problems. The server has internet access...

Hi George I am using SQL Server Express. This seems to becoming a habit you helping me out!! Of course your solution worked perfectly. Many many thanks yet again, maybe you should give me your direct line for the next time.(ha ha) Thankyou Alan Regards Alan Edwards

Hi I am using VB6 and an SQl database. I have a sql statement where I want to select records that occur between two dates picked using the date picker, I have tried formatting the dates using format (date,ddmmyyyy) etc but have had no luck in making my sql work. I am convinced that is is a...

gmmatros Good question! It is the way I was shown when taking over a project some years ago and have stuck with it eversince. If there is a better way to reach different fields in a Selected recordset, I am up for it. Regards Alan Edwards

gmmastros Many thanks, that works perfectly in this situation. I would still like to know about the syntax using the ! for future reference. Thanks again!! Regards Alan Edwards

Hi I am using VB6 and an MS SQL Express database. I have an SQL statement that has a variable in the Select section. sql_str = "SELECT DISTINCT " & dist_filt & " from sessions WHERE " & filt(level) The dist_filt variable holds the field name i am interested in and the filt(x) holds a string...

Thankyou both BobRodes and Swi for your replies. I have to admit, I have never come across the Dictionary object, i will look into it. Thanks again. Regards Alan Edwards

Hi I have a VB6 program that is using data from an MS SQL database. Just wondered if there was an easy way to retrieve or filter DISTINCT values from a recordset, ie.without using a seperate Select statement I am creating a chart and need distinct values from the recordset to become the...

Hi The database is not on a server, it is on an Xp Sp2 machine. If i install the DB on the user machine with the records from the development machine inplace it works ok, if I delete all the records, to start afresh, i get this error. I am able to work around this, but would like to know what...

Hi I have a database that works fine on the development machine, however when I transfer it to the users machine I get the following. You can't assign a value to this object I am assigning a value to a field on a form in the onload event. I have the reference to DAO3.6 inplace. Any ideas...