Search results for query: *

Hi The physical process is that an invoice is received from a taxi vendor that identifies each transfer and the amount. The hospital will then validate those charges to this database and I want to be able to enter the invoice number and date received to each of the applicable transfers in the...

Thanks.

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...

Hi Sorry but it's me again. In another post I received assistance with creating a search form with multiple search fields. The user will double click records in the list which then opens up the appropriate form (could be one of 3 forms I have). I've got this search working well but only if...

Hi Thank you, thank you, this is excellent and just want I wanted and it works amazingly.

Hey Duane Can you please not respond to my posts if you aren't going to provide me with any assistance? I understand not giving me answers or just providing code without making me work for it because getting me to think will help me understand the concepts better BUT answering questions with...

Hey Thanks so much, PHV! It wasn't working abut I wasn't getting any error messages either. This worked as I'm sure you knew it would! Thanks again.

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...

Hi I'm not sure what you're asking? Do you mean set the Allow Additions, Allow Deletions, Allow Edits to all be "no" and then they enabled via the button codes? Thanks.

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...

Hi Skip Thank You! Not sure why I keep forgetting about structured tables because they really are amazing and that fixed my problem. Thanks again!

Hey Skip Don't worry about it, I figured out a way: use a transparent shape object the same size as the cell and then add the macro to the shape. That way I can have a shape/macro per metric. Thanks for your assistance.

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...

Hi Skip No data is in the cell of B7, just a metric title that won't change. I want the user to enter that cell to trigger the other worksheet to be visible. Thanks.

Hi Skip You're amazing, you are correct that I have data above the header. I adjusted to: =OFFSET(M1B!$A$4,0,0,COUNTA(M1B!$A:$A)-3,1) and it works but I just couldn't figure out why it wasn't working like the others and of course they don't have anything above their headers so now I know and...

Hey Skip Long time no hear, hope you're doing well! I went ahead and tried to do this on my own and got the deactivate to work for re-hiding the worksheet but in using the selectionchange event it worked but it worked for whatever cell I selected in the worksheet. Private Sub...

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...

Hi Yes I have a find button but Andy's code isn't complete for the button to apply the SQL for the selections and then have the results show up in the list. Duane, your cryptic single answers aren't helpful. If you don't wish to help then don't respond.

Hi What I want is a the user to enter information in one or more of the search boxes and then hit a button for "find" and a list box shows all applicable entries based on what was entered in the search criteria boxes. Then when the user double clicks on an item in the search box, that form is...