Recent content by shelby55

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