Search results for query: *

Hi I'm using Access 2010. I have a database of patient transfers where one transfer is one record. The hospital uses private transport companies (including taxis) and receive invoices monthly. Vendor is one of the fields in the record table and I would like to be able to have a form where...

Hello I am using Access 2010. I have a table of data for patient transfers. I have a different form depending on the transfer type and not all cases will require a nurse for the transport but all will require cost information. The db was created by someone else and I don't want to change too...

Hello I would like a form to open up on a new record BUT not have that record be editable until the user selects "new record". This might sound odd but because the user could be going into the form to search for a record to edit (there is an edit button as well) I want the step of adding a new...

Hello I am using Excel 2010. I have data in a worksheet (M1B) where all the columns are dynamic named ranges. Column A has dates and Column B has a value which I'm entering in manually. Columns C is the same for all timeframes, D is average of the range (calculated citing the named range), E...

Hello I'm using Excel 2010. I have a data set where the data is per month of activity. I want to use offset so that the graphs will change dynamically as I enter in data each month. I have a date range from A4 to A31 and the current named range is...

Hello I am using Excel 2010 and I realize that hyperlinks do not work when the worksheet being linked to is hidden. I have a dashboard where the latest value for the metric is displaying in column E. The metric description is in column B and I would like to have it where the user can select...

Hello I am working in an Access 2010 database. On my splash screen I have a frame with 4 options for the type of patient being entered. I have a button that I would like the user to select and it will open up the correct form, add a new ID number and enter the patient type just selected to go...

Hello I am using Access 2010. I have a table called tblTransfers that contains fields called patient_name (text field), MRN (number field) and Date_Tsfr_Req (date field). I want to create a search form that allows the user to enter in one or all of the above and then the entries meeting the...

Hello I am using Crystal 9.0 from data in an Access 2003 database. I have a report where I have grouped on fiscal year. I have various metrics per fiscal year like volumes of cases, volumes of acute days, volumes of total days. What I want to do is create a formula that compares the values...

Hello The code below copies Excel charts to a Powerpoint Presentation and was created in Excel 2003 and doesn't work in Excel 2010. Can someone advise why that might be? Thanks. Sub CopyCharts_ED() Dim oppt As New PowerPoint.Application Dim pptpres As Presentation Dim pptslide As Slide Dim...

Hello I would like to create a dialog box or user form to enter in data and then a button so the user is taken to the row matching the input. The input is a combination of two cells - CMG and RIL which are text fields. I can build the user form but not able to create code that sends the user...

Hello I am using Crystal 9.0. I use the groupnumber function quite a bit but only for reports with one group. I have a report that has 3 groups but if I put the groupnumber on each group line there are multiples of the same number i.e. 1 shows up 3 times. How can you reference a certain...

Hello I am using Crystal 9.0 and I've never created an array before. The report has 3 groups: catchment_area, hospital region and hospital. I want to create a summary statement in the report footer indicating what % of a certain region is treating a certain catchment area. To start, I'm...

Hello I am using Crystal 9 reporting from an Access 2003 database. Please note that I've read the other topics on ranking but can't seem to get my working. My source data table has ED and inpatient visits by chart number (which is unique). I want to rank by 3 different groups: volumes of ED...

Hi I am using Excel 2010. I have a worksheet with data and used named ranges so the graphs change automatically. The data is based on dates and I wanted to also have a monthly graph so created a pivot table where I could group by month and I'm graphing the results. Everything is working fine...

Hello I am using Excel 2007. I would like to be able to create a macro where the user enters a start and end date and that range is used as the filter to extract data from one worksheet to another. Is this possible? Thanks.

Hi I'm using Access 2010. I have a table of data and I want to group on discharge month. I require the month to be a month for sorting reasons later. The formula is: MonthEnd: DateSerial(Year([DisDate]),Month([DisDate]),1) This works great but when I try to group my query, this columns is...

Hello I have a worksheet with data in it and I would like to extract the applicable rows when the criteria of anything being in Column I OR anything being in Column J OR anything being in Column K. The code below doesn't yield any cases because I assume it is looking for when all 3 criteria...

Hello Can anyone please advise what version of Crystal Reports will allow using Access 2010 as the data source? Thanks.

Hi I have a workbook that Skip helped lots with where I have one sheet of data that becomes many sheets (each row of data on the "rawdata" worksheet becomes a single worksheet with the tab showing as the caseno). I now have to replace a field already on these worksheets but can't just re-run...