Search results for query: *

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 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...

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...

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 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...

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...

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 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...

Hi I have a form called calibrate which has a subform called calibrations which is in datasheet view. Dependant on a field (type) in the main form I want to control the visibility of a field in the subform (chk1). Any suggestions? Regards Alan Edwards

Hi I am trying to use remote desktop between two xp machines. I have a netgear router which I have setup to forward port 3389 to pc2. When I use the internal IP address 192.168.x.x remote desktop works fine. When I use the WAN external IP address, remote desktop can't connect and portqry...

Hi I have 2 tables 1)Gauges and 2) Calibrations, they are linked through the field G_No. I have a form that shows the fields in the Gauges table, I also need to display on the form the date of the last entry into the calibrations field for the current gauge (G_No). Any help would be appreciated.

Hi MS SQL Server Express 2005 I am quite new to this, so please excuse my ignorance. How do I create a new server (to be displayed on the registered servers window) Many Thanks

Hi I am using CR XI. I have a report that displays a number of records from my database. Is there anyway to highlight the record with the highest value. Any help would be appreciated.

Hi I am new to Crystal reports and so would appreciate some advice on the following setup. I have a small network (without a server). On this network I have a PC with the database and on another machine I want to use crystal reports to write and view reports based on the data in the database...

Hi I am using the data environment in VB6 to create reports based on a MS SQL Database. I am trying to pick items from the tables that fall on a particular date. I use a date picker on a form to select the required date and import it into the data environment as a parameter (?). The date...

Hi I am using VB6 and MS SQL Express DB. I have an app that uses a date picker for the operator to select a date, then I want to use an SQL statement to retrieve a record from the database that matches that date. The date in the DB is stored in Date/Time format, but I am only interested in the...

Hi I have the following query: SELECT Products.Material, Products.Description, Products.[Q No], [Inventory Transactions].ProductID, Sum(nz([unitsreceived])-nz([unitssold])-nz([unitsshrinkage])) AS [units in stock], Products.Discontinued FROM Products INNER JOIN [Inventory Transactions] ON...

Hi Can anybody recommend a good library of ocx components for use in a machine / graphical user interface application. Specifically I need a decent dial gauge which is able to change color depending on the value of the input. Many Thanks

I have a button that generates a report and sends it by email as a snapshot attachment. My problem is that instead of sending only the record shwoing, all the records in the table are sent. I tried adding a filter bu I got an error message saying that it was not allowed. Below is the code I...