Search results

I am making a change to a website. the way the headings are set up is that there Capitalized so like this "I love MyServer" The heading in the CSS is set to be like that. does anyone know how to just with in the html code to change it to this "I love myServer" the main goal is to get the m...

IN all the times ive used homesite ive never came across this problem, until yesterday when I opened up the program. My resource windows on the left side were gone. When I go to view resource window they appear as there own window and then hide again Does anyone know how i can get those...

My report has a GroupHeader where its broken down into several groups. They are PunchIn, PunchOut, Injuries. My question is in code builder how could i Add the word minutes after a field in the detail row, in the PunchIn, and PunchOut Group headers. I was thinking something like this, and i...

do you have any sample code? i think its something like. If field = "late" then visable else not visable?

I have a report thats has 2 levels of grouping. One level is EmployeeID, and other is sources. The source headings are labeled like this Injuries PunchIN Under this Heading in the Detail part theres notes like Early, Late PunchOut TimeSheets Innovative Main This problem im having is i...

I got it using > Date() - 365

Date diff is difference between to dates, at least thats what i understand. But i wanna take the current date and subtract 365days or 1 year DateDiff("d",Now(),365) - this didnt work...

I have a date field in a query and in the criteria part of it, i want to take todays date and only show in the query anything within in the last year 365 days. i thought =today-365 would work but its not. Thanks.

I have 3 tables in my access database. upr00100, main, innovative each one has a primary key of employid. Im having trouble getting a query written so im not repeating data. im think i need a union but im not having any luck with it. heres the fields i have for each table: UPR00100 --...

do you have any sample code for this? it seems rather simple but im still having issues.

I have a yes/no field on a report. on the report its a checkbox. So if the field is yes,theres a check in the box, if now its blank. How can i have it so that if its yes it shows, if not its not on the report? Thanks.

SELECT tbl_TmpMFS_Account.AccountID, tbl_TmpMFS_Account.AccountName, tbl_TmpMFS_Account.CreateDate, tbl_TmpMFS_Order.InvoiceDate, tbl_TmpMFS_Order.OrderSubTotal, tbl_TmpMFS_RegionalMGR.Territory, tbl_TmpRepGroups.GroupName, tbl_TmpMFS_Account.Active...

Could someone attemp to rework my query to clean it up some? I am not having much luck with this at all. Any help is greatly appeciated.

Yep and theres no change with his suggestion either

I got rid of the function and theres no change in how long it takes to pull up the data. still taking along time? is there any good way to maybe break this down into a couple different steps?

do you have anything else that might help me if i leave that function?

I have the following query. When i run it, it takes along time to pull the data up. its only 2000 records. Does anyone have any idea on how to simplify it ot make it run smoother. maybe even how to break it down into a couple of steps. thanks SELECT dbo_MFS_ACCOUNT.AccountID...

I have a problem a client sent me an excel doc with names and addresses in Column E the header is city/state/zip i would like to break that out into 3 seperate columns city in E, state in F and zip in G heres an example how the orginal data came in ColumnE Goldendale, WA, 98620- Does...

Call this function for the end dates so that it will encompass all the times for the date after midnight. We don't call this for start dates though.

Between #1/1/2008# And GetAllDate(12/31/2008) when I did this I got no records returned. when there should be around 3000