Showing results 1 to 12 of 12
Search took 0.01 seconds; generated 1 minute(s) ago.
Posts Made By: barryhuizenga
Forum: Visual Basic 4 / 5 / 6 Jan 4th, 2006
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Giggety...that worked nicely. The rest is gravy as I manipulate this information into the various uses I will need it for.

Thanks again.

BDH
Forum: Visual Basic 4 / 5 / 6 Jan 4th, 2006
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Of all the potential solutions I have been exploring, this is without a doubt the most elegant. I am genuinely learning a great deal through this project so I truly appreciate being able to...
Forum: Visual Basic 4 / 5 / 6 Jan 3rd, 2006
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

OK so I found a problem

I created a query that will select all records of patients who have been called and I calculate the wait time duration using this expression in the query:

TimeDiff:...
Forum: Visual Basic 4 / 5 / 6 Dec 28th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Thanks KT

I actually went with Yomet's new format and then I tweaked it a bit more to have it pull patients from selected areas.

I am currently working on adding some administrative reports to...
Forum: Visual Basic 4 / 5 / 6 Dec 22nd, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Interesting...thanks for the tips. I am genuinely thinking about incorporating the new version in the form since my "updated" design specs as requested from the task force makes your format quite...
Forum: Visual Basic 4 / 5 / 6 Dec 20th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Help Re: Waiting Room Access DB

Yomet...you rule the planet, seriously.

I have attached the file. It should be in a working condition as is since I have taken out the items that have not worked.

As my design specs are being...
Forum: Visual Basic 4 / 5 / 6 Dec 20th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Pardon my confusion, but how is this fit into my previous code

Set recTimeCalled = CurrentDb.OpenRecordset("SELECT * FROM tblPatient WHERE PAT_PatientID =" & PAT_PatientID)

I have tried a couple...
Forum: Visual Basic 4 / 5 / 6 Dec 19th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Thank You Yomet

You have a close idea about my intentions with the program and I appreciate the assistance.

Your solution fixed my first issue nicely.

For my next trick, I am going to attempt to...
Forum: Visual Basic 4 / 5 / 6 Dec 15th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Re: Waiting Room Access DB

Giggety!

OK...although this is more of a soliloquy ( :cheesy: ) than I had hoped, I am making some excellent progress.

I figured out my mismatch problem, which had to do with the priorities in my...
Forum: Visual Basic 4 / 5 / 6 Dec 15th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Help Re: Waiting Room Access DB

More specific questions...

First do the Dim and Set declarations go into the procedure for the click event of my command button or should they be put in the declaration area?

Let's say the Time I...
Forum: Visual Basic 4 / 5 / 6 Dec 14th, 2005
Replies: 18
Views: 4,131
Posted By barryhuizenga
Waiting Room Access DB

Hi

Thanks in advance for any assistance with this side project of mine.

The hospital I work for wants to improve patient interaction with a laboratory blood draw station by taking them from a...
Forum: Community Introductions Dec 14th, 2005
Replies: 2
Views: 959
Posted By barryhuizenga
Howdy from Michigan

Howdy

I am a CIS graduate who very happily stumbled into a system support position for a hospital laboratory based a great deal on my previous laboratory experience.

My responsibilities will be to...
Showing results 1 to 12 of 12

 
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 4:48 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC