Search results for query: *

No, it not a once and done. And the range's can change. I could easily do this in vba, however the person I am doing this for want's it done by formula.

Unfortunately, it is not in multiples of 10....

I have numbers that need to be assigned a value based on what range they are in and I do not know what function to use. E.g. SourceData 1 12 Range RangeKeyWord 1-10 testa 11-20 testb What I would like to do, is pick up the corresponding RangeKeyWord for each piece of source...

I have a report, that has many subreports and each of these produce a text box. Based on the results of evaluating the text boxes, I would like to make a subreport visible/not visible however I am having difficulty accessing the value of the subreport textbox in VBA. When I try to access the...

Thanks for you answer, it will definetly help. While researching this, I came across the function ENVIRON which gives the values for 27 environmental variables. You can just plug them in when needed. Thanks Again. This will list them all for you, I figured I would save you or anybody else the...

While converting some excel macro's (involving templates) to w2k I came across this problem. W2k does stores the templates in the local user directory. Which is used %userprofile% . How can I get VB to pick up this value? and write to the correct directory depending on who's logged on? The...

My company has removed the Server service from my w2k machine and I would like to reinstall it. Can anyone tell me how to do this? -Log

How would you go about assigning a printer an IP address in 2.5.1? I have a sparc 5 station on an existing company network. I plug the printer into the network and I have no idea how to assign this printer an IP. I am really really new to networking in UNIX. sorry.

When I put a stop in it, it works fine since and the msgbox comes up. But I can't get it to show will I am on the parent form.

Hello All, Thanks in advance for your help. I am working with a Parent form that has 3 subforms. Each or these is based on a single table. I have set up a delete button in each subform that erases the current selected record. However, the tables in the subforms have relationships that do not...

Jakhan, I am not sure how I would synchronize this account, what do I need to do? -Log

I have is set to an existing html page since I can't get any asp pages. When I turn off Friendly Errors I get this error Server Application Error The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more...

I just started working with ASP's, and I am having a problem getting them working. I get this error 'internal server error 500' whenever I try to load up any ASP page, including localstart.asp, a page that should load without a problem. However, if I change the extension to .html on any ASP...

I just started working with ASP's, and I am having a problem getting them working. I get this error 'internal server error 500' whenever I try to load up any ASP page, including localstart.asp, a page that should load without a problem. However, if I change the extension to .html on any ASP...

How about using the function dateadd E.g. declare @Date as varchar(20) set @date = '10/01/2001' set @date = DATEADD(year, 1, @Date) This adds 1 year to 10/01/2001 -Log

Got it, right before I saw your thread Bernadette. The dateadd function was the problem, it was cutting off the seconds. Set @endTime = (convert(char(30),dateadd(MINUTE,6,@endTime),108))) Thanks for all your help!! -Log

I did, I just keep getting the error, Syntax error converting datetime from character string. Even though everything is datetime. I can't even do this in a select statement, so the table design is not a problem. I just can't run a query with a datetime variable as a criteria. If I key it in...

It actually does work when I add the single quote ('). But I am losing the seconds on the coversion. If I select @endtime right before the query I get 1900-01-01 05:59:59.000 But the the query I would get 05:59 Or something to that effect. The coversion cuts of the seconds and I lose the...

Thanks for your ideas, however I am still having 2 problems. Both of your pieces of code led to the same problems, specifically. 1) The error message Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '1'. Here is a 'select' of the @strsql right before it executes...

I am having a problem running a query that uses a datetime variable in the where clause in a sp. Here is a cut of the code I am having a problem with. ________________________________________________________ Declare @StartTime as datetime Declare @strsql as char(200) Set @Starttime = '05:52:00...