Search results for query: *

Hi there, I've been searching all over and can't find exactly what I'm looking for. I have the following data: Team Rank Points CAN 5 11 SLO 2 20 GBR 6 10 KOR 1 25 CAN 3 15 CAN 3 15 CAN 7 9 CAN 8 8 USA 9 7 CAN 10 6 USA 11 5 JPN 12 4 KOR 13 3 USA 14 2 USA 15 1 USA 16 11 AUS 17 11 USA 18...

Hi there, I've been digging about and just can't seem to find what I'm looking for. I am trying to format Column C contents (after they have been entered) to Ucase(). I'm not familiar with the Private Sub Worksheet_Change(ByVal Target As Range) End Sub method and am not sure how to pass the...

I think I've been looking at this too long and feel like I'm beating my head against the wall. I am trying to add an expiration date to my report based on NOW() and adding 10 days to it. Ultimately, I'd like the report to expire in an hour, but I'm trying to break the peeps in slowly... Any...

Hi there, I have several worksheets in my Excel file and would like to know how I can do something like the &[TAB] function that is available in the Custom header/footer area and put that value in one of the cells in the worksheet. Thanks! __~o `\<, (_)/(_) MTBChick...

I have a form that has a list box that displays items based on it's id in the database. It has been working for several years, but today, decided to give me this error. I am over 45000 id's. (Just added a ton of new products.) Could this be the problem? Here's where it's balking With rs...

This may be pretty remedial, but I've been banging my head over it for several projects now and thought I'd see if anyone in here has any ideas. [sadeyes] We have a list of 400 properties in an Excel Spreadsheet. They only have three items of data associated with each property, Unit Name...

Hi there, I have a report that I have generated that needs to assign start times every 30 seconds automatically. The basis is a report that I developed that would automatically number a position. So under detail I have a box called Start with the following properties: Control Source =...

I have a report that I need to automatically number the lines for each detail record. Here is what I have so far: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) lngPlace = 0 End Sub And here's where the detail gets counted: Private Sub Detail_Format(Cancel As...

I am timing an event and need to calculate the runner's time back from the leader. The times are coming to me in string format as such "1:03:22.177". In VBA, on the GroupHeader_Format Event, I'm trying to convert the winner's text box into a CDate tmWinTime = CDate(me.txtResult) but I keep...

I have W2K installed on my personal laptop. I had my former job's IT guys intall Novell Client Server on it so that I could access the company network while I was in the office. I want to uninstall this so that I can set up a wireless home network. I have no networking experience, don't even...

It's been awhile since I've coded an .asp and now I'm in the midst of one, so forgive me if this is a simple question... I have an input page where the user can select several items which changes the sql query to the database. Basically if the user enters info in a text box, I want the default...

I have set up some code that will automatically generate an email using Groupwise. The problem is, I need to pass the user defined parameter in the DoCmd part of the VB. Here's what I've got: Private Sub cmdGO_Click() On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset...

Hi there, I've searched the FAQ's and found hundreds of suggestions on how to automatically email using Outlook, but we use Groupwise at our company. I have an Access query set up that will generate a list of new events and the contact email for the events that I have used to create a form. I...

I am trying to write a query that will take the best two sales for a single salesperson, then average them. Some salespeople have one or two sales, and some have several hundred. My table is set up thusly: SalesID, SalesAmount, SalesType SalesType doesn't matter. I want to take all types in...

I am trying to write a query that will take the best two sales for a single salesperson, then average them. Some salespeople have one or two sales, and some have several hundred. My table is set up thusly: SalesID, SalesAmount, SalesType SalesType doesn't matter. I want to take all types in...

I am running Windows 2000 Professional on an IBM ThinkPad and have 'attracted' one too many viruses (viri?) that have forced me to make the decsision to reformat my harddrive. It is currently partitioned into 2 drives - C and D. I have reformatted the D drive without a hitch. However C will not...

OK, I'm going crazy... Is there any way that you can change the formula in pivot table to reflect a COUNTIF situation instead of just COUNT? For example, I have a series of data but only want it displayed in the Pivot Table if a criteria is true. When I try to paste in my original formula, I...

I have two tables that store time as string in this format: 01:20:21.92 (ex.) with a bunch of spaces after the time. Ultimately, I need to add the two times together, but when I trim the spaces and then set the properties of each field to Long Time in a query, it still concatenates the two...

I have two tables that store time as string in this format: 01:20:21.92 (ex.) with a bunch of spaces after the time. Ultimately, I need to add the two times together, but when I trim the spaces and then set the properties of each field to Long Time in a query, it still concatenates the two...

I am creating a report that will list the participants in a race. Ex. John Smith, M, 20-29, 1:03:41 Chuck Jones, M, 20-29, 1:04:00 Bill Watson, M, 30-39, 1:03:15 Jill Johnson, F, under 40, 1:20:02 I've built queries to sort by age class and ascending time, but I need to calculate their place...