Search results for query: *

it spans across the network. I have tried placing the database at the root of the directory thinking that shortening the path will speed it up but i have had no such luck. I changed the ODBC data source from the default value of 5 of page timeout to 5000. I still see the lague time when...

correct

We are experiencing access (2000 and 2003 are running) issues when running an update or append query within a macro on our network. The database is out on a shared location on a windows 2003 server. I am not sure whether or not our antivirus is scanning every the database before it runs...

that is what i was going for aceman...appreciate it...thanks

I know how to hide the menu bar in access; but is it possible to hide certain options in the menu bar other than creating a new toolbar. thanks

i have a function that is going calculating the distance between two locations using the latitude and longitudes for two points assuming the earth is flat and the lat and long are perpendicular. I called that function distance. My issue in moving forward is taking the distance i am given from...

I have a field in excel that is a date i.e. (10/20/2007). I have formated the cell in table to show OCT-20. When i create a pivot chart from this table it shows the mm/dd/yyyy. Is there a way to exclude the YYYY from the chart so it just shows OCT-20. any help would be great, thanks

Solution: I had a formula =IF((O2-L2)> 93, 93, IF((O2-L2)<-32, -32, (O2-L2))) that determined whether or not something was greater than 93 meaning the days were over 93 or less than -32, otherwise take (02-l2). In the next formula i assumed that everything would happen on the first of the...

if you are looking to sum the columns for total you can do the following. =SUM(Sheet1!A1:A3)+SUM(Sheet1!k2:l9). hope that helps

i got it to work...thanks very much for everyones help. Here is a question for you...in a pivot table..if a field contains no data that is selected...is there a way to hide it from showing up in the drilldown?

Acct C_D Julian Date_Ed Cur_Date a 6/10/1999 93 8-Oct-07 b 3/13/2007 93 c 5/2/2007 93 d 4/4/2007 93 e 7/18/2007 82 18-Jul-07 f 9/11/2007 27 11-Sep-07 g 7/30/2007 70 30-Jul-07 f 9/4/2007 34 4-Sep-07 i 1/31/2007 93 this is just a quick snippet of the source data. I...

Count of Account Year Custom_Date 2007 2006 2005 2004 2003 1 1457 1927 2474 3190 3581 7/9/2007 1461 1927 2474 3190 3581 7/10/2007 1467 1927 2474 3190 3581 7/11/2007 1472 1927 2474 3190 3581 7/12/2007 1478 1927 2474 3190 3581 7/13/2007 1485 1927 2474 3190 3581 7/16/2007 1489 1927 2474 3190...

thanks guys the post worked but im still having an issue....here is where I am confused on if it will work or not...my dates are going back as far as 1999. I have a separate column (=IF(Q2<=93,$T$2-Q2, ") that i am determining whether or not the date shows up as being less than 92 days. I then...

I am trying to reproduce a better way in building a pivot table. I am dealing with years of data but I want the end user to select a date say November 1st and then show the past 90 days in a pivot table. Is it possible with checking all the dates in the drop down. Any help would be great

thought i could get my code to work but it is saying it is having issues calling access from my button. The command you used to start Microsoft office access contains an option that microsfot office access does not recognize. Below is the code i used to call MS Access and then the macro in the...

i thought i could get my code to work but it is saying it is having issues calling access from my button. Does anyone have a snipet of code that allows the user to click on a button and then it will call a macro and/or does anyone know where i went wrong in my code. Any help would be great...

i have 3 radio buttons that produce some different links below them. I am having an issue with javascripts onchange feature. When one of the radio buttons is selected it should refresh the page. Unfortunately it is not. Any help would be great. Here is the function i have created. When you...

Hey all, I am having issues attempting to get this code to work. I can get the code to work if i just pass it to an html page. When I try to send it to the form is when i am having issues. I have tried two different ways of sending the data. my first method is i have a form that has 3...