Search results for query: *

I am wondering if there is a way to use Javascript to pass a value between different pages - without creating a cookie or putting the data in a database. For example, on page 1 I have a text input field. The user enters into the input field "ABCD". Then the user clicks a link and goes to page...

thx

I have two tables - one for the month of June and one for the month of May - and each table has the exact same data fields (and very similar data). I am trying to determine what records have changed from May to Jun using a query. Here is an example of the two tables: Table May Table June...

Hi- I am having issues with the IIf function. What I am trying to do is use multiple conditions within an IIf function. At first, I created a calculated field with the following expression: Sort: IIf([ProjectManager] Is Null,1,0) This worked fine, giving null values a value of 1, and...

Thanks, RoyVidar! And yes, I did need a WHERE CLAUSE. Here's the final code: ' Take the value of txtAddOne Begin and ' txtAddOneStop and plug it into the SQL ' update query Private Sub cmdDoIt_Click() Dim intValueOne As Integer Dim intValueTwo As Integer intValueOne =...

I am trying to take the values a user would type into two text fields and plug those two values into a SQL update query. I am trying to do this using variables. Does anyone know where I might be going wrong... Thx. Here's my code: ' Take the value of txtAddOne Begin and ' txtAddOneStop and plug...

you're the man, ramzi! thx.

Thanks for responding. You're close, but I get a file CMDRpt.rtf31Jul03 which cannot be opened. It's like I want to stick the date before the .rtf ending.

I have automated the task of ouptutting a report to a file on the network using the OutputTo method but now management wants me to save the file by date - so that they can see the changes in the report based on what day it was generated. Here's my current code (I changed the location to my...

That works. Thanks Kevin! You're the man. There are times when the data shows 0,0,0,0 for employee hours on a project that I would rather not see. Any way to eliminate records where I get 0,0,0,0 in wk1, wk2,wk3, and wk 4?

I created a company timesheet table that looks like this: Project # Empl. Start Phase Wk 1 Wk2 1 Bob 06/30/2003 A 5 2 1 Bob 07/14/2003 A 10 0 2 Joe 06/30/2003 M 8 4 2...

Thx for the suggestions. I'll give them a try.

I believe you can create a new linked table in access and link it to your excel spreadsheet. Then you can run a query off the linked table.

Microsoft Excel 2000. Thanks.

I have an Excel master sheet which is linked to several other Excel sheets. On the master sheet I have a filter. I want users to be able to use the filter but not change the actual values in the cells of the master sheet. I have tried protecting the sheet but it doesn't allow me to then use the...

You guys are awesome. Thanks.

That's one way to do it... but I would really like the user to be able to see the tabs and navigate with them. I am creating timesheets that have dates in the tabs. I want the users to be able to navigate between time periods to update their timesheets, but I don't want them to be able to rename...

I would like to disable the ability for users to rename the tabs at the bottom of an Excel page. Any ideas on how to do that?

Ginger, this works. Thank you so much.

I am trying to sort a field ascending by date. Some of the records contain null values and those values appear first on the report when previewed. I would like to change the sort order so that the blank (null) values appear last. Any ideas?