Search results for query: *

Hi, SQL VBA form question. example of the problem. If I have two tables, table one tblnames with fields FirstName, Lastname, Dept in it. table two tblProject, with a combo box cboLastName, which is linked to tblnames, so you can see all the fields of tblnames in the drop down. How do I...

Hi, I have a form with a continuous subform in it. In the subform, if I make a VBA button to disable a text box called txtBox, every txtBox in the form (continuous) is disabled. How do I get the button to disable only the record that the button is clicked in to be disabled. eg. the code is...

Hi, Best explained as the example. Say I have two tables tblContacts and tblServices. In the tblContacts, there are the fields lastname, firstname, address1, address2 In the tblServices there is a lookup to the field "lastname" in the tblContacts table. In a form with recordset tblServices...

Hi I have 3 tables, tblpersonel IDPersonel autonumner FirstName text Surname text IDDepartment number ---(many)-------------- | tblDepartment | IDDepartment autonumber-(one)--------------...

Hi, I have a problem trying to get a check box value from one form, as a criteria of a query in a subform. I have 2 forms, form 2 is a subform of form 1. form 1 has a checkbox called chk1 In form 2, there is a combo box which has a drop down field (with two options) which needs filtering...

Please can someone point me in the right direction of how to setup an executable to run as a service on a W2000K Server. many thanks in advance. Allen

Hi, I could do with some advice on howto decommision a domain with one NT4 PDC, DOMAIN1. This PDC is also our exchange 5.5 mail server. The mail users are linked to DOMAIN2, through ADC. The second domain is an Active directory domain, DOMAIN2. Any advice, pitfalls in howto decomission...

I have a problem with one user, setup on exchange who recieves email to his exchange "delivery" option in outlook. He can only recieve the mail when he presses F5 or selects another folder in outlook. Has any one had this problem? We have 90 users and this is the only time I have seen this...

Hi, I have written a very simple database to log purchase orders. Its just one table. I have split the database into a front and and back end database, with the front end having linked tables. The front end databases are used by 3 users, all linked to a back end database over a network. My...

Hi, Does anyone know how can disable a "local area network" connection from a batch file. Thanks Allen

Hi, I have been trying for days to sort this one out! any help would be welcome. I have a subform with prices and qty, based on fields of a table.... The main form is linked to the sub form by customer ID (if that has any relavence) I then have a text box in the subform multiplying the qty...

Hi, I have a data base which I have to convert a "date" field which is in Text format, to a date format. Currently all data is displayed as (sample) "August 6, 2002" Many thanks in Advance.... Allen

Hi, Firstly thanks in advance for looking at this. I am quite new to VBA... I have VBA code which looks up a price based on a customer and part field of a table... The result always rounds up or down to the nearest whole number, I need to show 2 dec places for currency... Any help, thanks...

Firstly, thanks in advance for any help..... How do I look up a field (price) from another table whilst in a form, One table makes up the form, and the other table I need to reference, "price" , are linked by a "part no" field. I need this to insert the price in the form...

Hi How do I look up a field (price) from another table whilst in a form, One table makes up the form, and the other table I need to reference, "price" , are linked by a "part no" field. I need this to insert the price in the form. The field in the form a text box. I know...

Hi I have set up a w2000 server SP4 with 2 disks, disk0 and Disk1. They are set by W2k as a soft mirror. The c drive (mirrored) is the system disk. There are no other volumes, but a couple of Gbs free unused disk space. When testing this for failure, I disconnect Disk1, (slave)...

Hi Experts, I have sucessfully setup a VPN server on a W2k member ISA server (through RRAS). We use PPTP with strong encription. There are about 10 client PC's mixed bag of W98, XP Pro and Win2K, that connect via GPRS mobile cards or POTS, via an internet connection. There is no problem as...

Hi, I have been given a spread sheet which is very large. I need to be able to print parts of the sheet (ranges of data, which are in different areas of the sheet, to multipla pages for a report... Please could someone give me a clue how to do this? many thanks in advance. Allen

HI, We have an ISA server (W2000) Server), and would like to set it up to except VPN connections from remote clients. When ever I setup RAS on the ISA server, Lan users cant browse the internet. As soon as I stop the Ras service, Lan clients can connect again. Any ideas, or help on this...

Sorry if this is a dumb question. I have been asked by my boss to put our web site on a cd rom for our sales guys. The site is all asp, with a access database for products. Any ideas on how I do this, running it from a directory doesn't work.. also when I try running from IIs 5 which I...