Recent content by suzreid

I can't seem to find the answer to this anywhere but I'm sure it must be possible. I have an INDIRECT lookup function that concatenates various cells together to give a 'real' cell reference on another sheet. The formula is =INDIRECT( $N$9&$N$12&$J7) where $N$9 holds the sheet name, $N$12...

This is a bit difficult to explain so bear with me please. I have a workbook that users enter data in many sheets and there is a hidden sheet that consolidates all the data into a single sheet. All the sheets all have the same format. Sheet1 is the data entry sheet and Sheet2 is the...

I have a query where I want to retrieve the records where a date falls between yesterday and 7 days ago. Because of the timestamp on the current_timestamp I am missing some records. The condition I am using is where eventdate between current_timestamp-7 and current_timestamp-1 Event date has...

As you may know all the useful information in the repository tables are created as binary numbers and stored as decimal. Does anyone have / know where i can get a function that will convert the decimal back in to a binary string? Suz

I'm running Win 2000 Pro SP2. Yup, done everything you have suggested and I don't have a hosts file for it to use. Suz

I've been having some weird DNS problems since upgrading to broadband. My initial problem (posted somewhere on here) was that I couldn't resolve urls with IE. I couldn't even ping the url. Pinging and accessing web pages using the IP addresses was no problem. I managed to solve this problem...

I have a report that is split in to sections based on a location code. I have a VB macro written that exports the complete results set to a single sheet in excel. I need to put each section on to a sheet of it's own. Is this possible to do? I have tried using a filter on the report but when I...

I managed to sort the problem. I used a different driver from the one that is installed by default and that solved the problems. Thanks for the help Suz

I hear the CD through the speakers plugged in to the card not the CD player. Suz

I've checked the PC settings. None of the volume settings are set to Mute (or very low)and the speakers are working. It seems to be an AC-97 card that is installed. So you need any more information? Suz

I don't quite understand what you are trying to tell me. The underlying database is SQL Server. I can't mess with the database creating new triggers. It is a third party application. The initial report will count the number of records for a month. If the result is 0 then do nothing, if the...

I'm exploring possibilities at the moment. I have a document that needs to be refreshed automatically only when an upload to the database has been completed. When the upload is complete there is a record placed in a table in the database. Unless I can get Broadcast Agent to do a conditional...

Can a dataprovider in a document, be refreshed from another document? I have a document that I only want to refresh if I have a record returned in a second document. Is this possible? Suz

I'll check all this and get back to you. Suz

I have just bought a new PC for myself. It has Win2000Pro as the OS. My problem is that I cannot play .wav files. Music CDs play fine and I can record on to the PC with the microphone but I can't hear the resulting .wav files. Any ideas on how I can fix this? I don't know the manufacturer of...