Search results for query: *

Hi. I have a procedure that has a list of ids in a recordset. I compare each of these ids against an external database table. However if an id does not exist in the external table i get the error 91 object variable not set error. If rsWellList.Fields("IDWell").Value =...

How can I join 3 fields from a single table together. I intend putting the result into a temporary table. e.g. Table 1 Field1 Field2 Field3 Output Field1,Field2,Field3 Thanks in advance.

Hi. I want to open a form based on the result of an autonumber for a newly added record. The form I want to open will be a data sheet with no rows as the autonumber value will not be present in the table. I have tried DoCmd.OpenForm "frmAssignments", , , "LessonID = AutoNumber" But it doesnt...

Hello, I have a script that compares data formatted as hh:mm. However the comparison never seems to work. FromTime is defined as a Long. If ToSheet.Cells(2, 3) = FromTime Then FoundTime = True Cells(YrRow, TimeCol).Interior.ColorIndex =3...

Hi. I am total newbie to this. I am trying to create a procedure that will show all records on a form that match the inputs of 3 separate fields on the same form. The procedure will run the On Click event on a button. Can anyone point me in the right direction. Thanks.

I have a cell K41 that contains a cell reference e.g. $B$23. This is obtained by by using =ADDRESS(L37,L35). How can I get the value of the contents of cell $B$23. Everytime I try and reference the value in a formula I get reference K41 and not the contents on $B$23. Thanks.

I need to search a cell for a particular value and based on whether the value is present I need to perform an action. What is the best way of searching a cell for a determined value. This search will be done row by row in the spreadsheet. So I dont want to specify the entire spreadsheet range...

Hello, I am trying to create a macro that will copy a selection from Excel and paste special into Word (unformatted text). Any thoughts on what I have so far. It fails when I do the paste special. Thanks in advance. Sub CreateText() ' ' ' ' COPY Data from Excel Cells.Select...

Does anyone know of a way to create a hyperlink that will run a batch file?

I am trying to email the inputs on a form to a user. However the inputs are not stored in the email on the name of the input fields. Does anyone have any ideas? Thanks in advance

I have an RH7.3 machine setup as an NIS client. However when I reboot the machine the domainname is always reset to blank. Where can I put this value so that it is permanent? Thanks in advance

Hi I am looking to upgrade a machine. to provide different cost alternatives I am comparing AMD with intel. However when I compare Celeron and P4 I am a bit confused. I see you can purchase a 400MHz Celeron chip. When I come to look into motherboards the all support P4 but none of them mention...

Hello, I have one machine that will not allow viruscan to be installed using EPO. When I send an agent install using epo then epo agent gets installed but the virusscan packages do not. The target machine is Win2K. Any ideas? Workarounds?

I have Arcserve 2000 Version 7.0 Build 1100. My server is Win2K SP2. I am backing up Exchange 5.5 SP3. I use the Arcserve Exchange backup Agent to backup the individual mailboxes. The problem is that more often than not the backup job will stop during during the individual mailboxes. The job is...

Does anyone know how to get round the following error: Session setup to WinNT or Win2000 Domain controller for domain is not responsive. The RPC call from Netlogon on client machine to domain controller has been cancelled. A reboot fixes the problem but it seems to recur every 2 hours. Thanks...

Has anyone experienced a problem where LSASS.exe uses all the CPU on a machine a basically renders it useless? I have a couple of machines that seem to be prone to this. Any ideas thanks.

we currently run a NT4.0 PDC with the logon domain being <localdomain>. Our company was purchased a while back and we now run a local DNS server on our DMZ with the domain name of <city.corporatedomain.com>. I need to promote a Win2k member server to be the PDC. When I upgrade the Nt4.0 PDC to...

I need to know how to copy all mail sent by a mail group to a public folder. Does anyone know how to do this? Thanks in advance.