Recent content by dgb

No. For instance, pt A had lab results 1 month ago, 2 months ago and 10 months ago. Pt B had them 6 wks ago, 3 months ago and one year ago. So there is no pattern, but I want just the last 3 for each patient no matter when they were done. Thank you

Hello, I am trying to create a query that contains lab values for patients. I only want to display the last 3 dates for each patient. How do I do this. Thank you, Dan

Hello, I am trying to figure out how to make a text box invisable until a specific value is selected from a combo box on the same form. I am not good with writing code, thanks in advance. Dan

Can anyone help? I have a query of all records. Each record has 10 fields that can contain a normal value or a negative result. I would like to count the negative records and then perform a calculation to show the percentage of times the result was negative. I need to do this calculation for...

excel sort The data type in the database is date/time. But when i export excel does not recognize it as a date.

I am having a problem after creating a query and exporting to excel, it doesn't sort the date correctly. I tried to use tools and analyze with excel but it does the same thing. When exporting i click the save formatted button. None of these works. Any help out there. Thank you.

Thanks Travis, i was able to figure it out. Dan. And you were right, that is what i needed to do. Thanks again.

Microsoft help emailed me with the following message. I am trying to create a button that will replicate without closing the db first. and another button to sync without closing. Because supposidly you cannot replicate when the db closes in the runtime version of access. So she sent me this code...

On a db that has been packaged and deployed using the microsoft developer, and adding in replication manager to the package. Can this database use replication and synchronization. Or if running the runtime version of access does not alow the user to perform the replication and sync funtions. I...

I created a button, under the click comand I entered a Macro that does a RunCommand. This command is SynchronizeNow. It starts the normal sync process by asking if you want everything to be close prior to sync but then comes up with an action failed box with the number 264 under arguments. Does...

I have a user that would like to use a button that would start the replication process rather that having to use the menu on top. Does anyone know how to do this? thanks in advance, Dan.

I have a report that looks fine in print preview. But when I send it as an attachment or save as word document it is ok if the whole report is on one page. But if the report is two pages long, it places the broken paragraph at the bottom of the second page and places the (signature text box)...