Search results for query: *

It gets a litte tricky, when I save the form as a report. Then using .column(1) dosn't appear to work... thanks

Thanks Remou,

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

Thanks Duane, thats really simple! The db was just an example, the "surname" wont be the same. I just wanted to know how you do it. cheers

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 PV, many thanks for that, that works ok, .....until I set the default view to forms to "continuous form", any ideas, thank you, again. my code is now:... Private Sub Department_AfterUpdate() IDPersonel.SetFocus Me![IDPersonel].RowSource = "SELECT IDPersonel,Surname,FirstName From...

Hi PV, The trouble now is that when I go back to the previous record in frmProject. The personel field is blank, because the secect row says SELECT IDPersonel,Surname,FirstName From tblPersonel WHERE IDDepartment=1 Any ideas please.. thanks Allen

Thanks PV, it worked on the got focus of the IDpersonel field.

Thanks PV, I entered Me![IDPersonel].RowSource = "SELECT IDPersonel,Surname,FirstName From tblPersonel WHERE IDDepartment=" & Me![Department] Into the expression builder, dosn't seem to like the me! part. (I get an error) I see the idea.... I will keep trying! thanks Allen

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

I have fixed it using IFF. thanks

Hi PHV, Sorry, I have attached a rough (very rough) sample of what I mean. There is a combo box. If chkbox1 is true, then I only want to to see "ORA" in the drop down, if false then SQL. Sorry If I dont make sense, thanks http://www.box.net/shared/5ebv7qjsvr

Hi, It is a value list the row source is "ORA";"SQL" If the check box is true in form 1, I need the criteria to be ORA (then it will filter), if the check box is not ticked, then SQL. thanks

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 recently had to write a loggon script for XP, W98 and W2000 clients, I used a scritping programe called Kixtart http://www.kixtart.org/ It was excellent, and worked first time. you have to make a donation to chairity for using it.... Allen

This behavior can occur if either of the following conditions exists: The Setup.log file is damaged or missing. The Setup.log file is located in the drive:\windows\repair folder, where drive is the drive letter on which the Windows folder is located, and windows is the name of the folder in...

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

what a star, thanks