Search results for query: *

An excel question ----I have a situation where a PICC is inserted in a patient – I want to count the number of days that the PICC is inserted until it is removed………for example – if the PICC was inserted on 3/10/2013 and removed on 3/23/2013 – I calculate the number of insertion days with this...

I am trying to select the “VRE” within the dates Below – but I cant get the “AND” operator to work - HELP Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter Field:=6...

Private Sub CommandButton1_Click() ChDir "H:\PDOXSHAR\Monthly Reports 2009\MDRO rates Calc" Workbooks.Open Filename:= _ "H:\PDOXSHAR\Monthly Reports 2009\MDRO rates Calc\NOSOCOMIAL RATES KHD & PET 08.xls" End Sub The above procedure opens an Excel (.xls) file How...

This is an excel spreadsheet I want to select data where the "Culture Date" is > – this isent quite working Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter Field:= 6...

This is an excel spreadsheet I want to select data where the “Culture Date” is > 12/31/2008 – this isent quite working Private Sub CommandButton1_Click() With ActiveSheet If Not .AutoFilterMode Then .[H2].AutoFilter Range("H2").Select Selection.AutoFilter Selection.AutoFilter...

Here is my problem I have several command buttons programmed to select different criteria as per the below examples. The spreadsheet is stored on a file server – the click_events works fine from my PC, but when I go to someones else PC the commands don’t work – I get the error message “Macro...

How do I write a VB procedure that will display say 3 picture with equal delays if I set the timer1.interval = 500. So after .5 seconds the first picture becomes visible – then after another .5 seconds the other picture becomes visible … and so on. thanks

does anyone have a VB program module for fIBONACCI numbers? thanks

I have a spreadsheet with 12 columns and hundreds of rows of data. New rows (records) of data are constantly being added. One column has 5 different data specification. If I do an auto filter to show information for one of the 5 data types in the specific column and save the steps as a Macro...

I have a spreadsheet with 12 columns and hundreds of rows of data. New rows (records) of data are constantly being added. One column has 5 different data specification. If I do an auto filter to show information for one of the 5 data types in the specific column and save the steps as a Macro...

I create a one to many database – the tab order works fine on the “one” data entry form but when the entry continues in the next linked form – the tab jumps to the last field entered – and does not start at the beginning of that second form which is where I would like it to begin Using Msaccess...

can u use crystal reports to report on data in an excel spreadsheet?

Example, I have a database that save time of occurances in the following way 11:20:00PM 8:20:00PM 9:20:00PM 8:20:00AM 8:10:00AM 12:20:00PM I want to group these by AM and PM, how do I go about it?

Problems after upgrading MS Access 97 to 2000 and using Crystal 8.5 I upgraded my MS access 97 to Access 2000 I also upgraded Crystal Reports to 8.5 My database have several data entry form screens, but there are only 2 databases that the data is going into. The databases are 1. PATIENT and...

I have created a couple of databases in access and linked them in a 1 to many form. I used the wizard to create the entry form. The problem is to search a field I have to place the cursor in that field before the search will work. Is there an easy way to just type the search argument and have it...

I am trying to select {bl_exp.PERC_INJ} = “X” for {bl_exp.DEVICE}. there are 46 devices, I only want device 5,6,7,8 for the dates shown. Some how the report is picking up dates earlier than I am specifying. here is formula I am using: {bl_exp.PERC_INJ} = "X" and {bl_exp.D_EXP} > Date...

With this formula I am trying to select all the {bl_exp.PURPOSE} fields that have a “Q” or “P” for the year 2003. however for some reason the selection is not being limited to year 2003, i am getting the P and Q for 1995, 1996 … thru 2003. what is wrong with the formula below that I am using...

if isnull({profile.surgeon}) or {profile.surgeon} = "" or {profile.surgeon} = " " then "F" else "T" Question - why does this program work? how does ISNULL work? cant find anything in Crystal user guide.

I create a Variable eg StringVar Surgery := {profile. Surgeon}; if surgery <> &quot;&quot; Then &quot;T&quot; Else &quot;F&quot; //the column Surgeon list surgeon names where available, where there the surgeon field is blank I expect the variable SURGERY to return an F, it returns...