Search results

I had this worked out as well just now actually. I moved the method to another method, which is related to it. Afterupdate event of another field on the form. If DateDiff("d", Me.ED_Start_Date, Me.Regular_CT_Scan_Result_Available) <= 2 Then Me.Regular_CT_Head_Timeliness.Value = "Yes" Else...

I am trying to do the following in the afterupdate event another calculated field, but the calculated field is working, but not this following code: Private Sub Regular_CT_Time_Valid_AfterUpdate() If DateDiff("d", Me.Regular_CT_Scan_Result_Available, Me.ED_Start_Date) <= 2 Then...

Hi, I have a calculated field on the form, but I'm having trouble using the datediff formula. The idea is....I would like to first see if the time difference between two time fields is less than 2 days. If it is, then I want that field A to equal to "Yes", otherwise, "No". In the expression...

Hi there, I attached a random number generator in Excel file with two buttons and macros. What's a little bit annoying is that every time a button is clicked, I get two numbers generated. Ideally, I would only want to generate one new number, depending on which button is clicked. I think...

Hi, I would like to create a 9-digit random number generator in Excel 2003. I am thinking this: =rand()*999999999 However, this does not guarantee uniqueness. Does anybody have some thoughts? Thank you

Sorry I must have not sent you the saved database while I had it open on my computer, but I attached it here again. Also....is there any way to do all of this using the query grid? I would rather like to see a list of patients as output, or essentially PHNs after the query is run. So patient...

Thanks. Please see the attached for a sample database in Access 2003. The query I wrote only extracts the latest encounter for the same patient. However, as I mentioned above, all encounters need to be looked up. If you see in the encounter table, the PHN of "5234" is repeating 3 times...

Hi, I have a one to many database set up. Primary table contains patient demographics, and the encounter table contains each medical visit. When there are two medical encounters, there will be two records of that same patient. One of the analyses is find out which encounter of the patient...

Hi, So I will have an access 2003 form built as the front-end for data entry. The backend links to the SQL server. With this kind of setup, is it possible to still create derived or calculated fields in the form? The field very much acts as the decision support, and its value will become...

Thank you. By the way, what are ad-hoc queries? Queries that users would like to do on the fly?

Hi there, I am hoping to have this Access 2003 front-end linked up to a SQL server which stores the back-end table. What I am wondering and I really hope it works this way is.......if users can access the standard query grid through Access front-end with the tables now stored on the back-end...

Hi, I have tried it, but it's not exactly working the way I intended. I can give you an example: In the visit table, I have visit_number patient_id visit_date 123 abc 2011 9 20 456 bcd 2011 7 6 675 bcd...

Re: Turning numbers into letters during output from query Thanks. I was wondering if it was possible at all to manually obscure digits. So for example, we want all the 1s turn into a, all the 2s turn into b on the output so that we can actually go back to them if necessary without having to...

Hi, Would it be possible to output a column of data that is masked? For example, if I have a column that stores personal identify information(unique 5-digit number), and when exported we would like to hide the digit, is it possible? I'm thinking....to have 1 = a, 2 = b, 3 = c, etc. When...

Later on when we do the analysis, we only want to look at the latest patient visit and results. So if patient A had a visit two years ago, we don't want to look at the treatment done around that time. We only want to look at the latest. Although the visit table can store multiple instances of...

So essentially we are saying.....even thought this is the new patient, but we want to store him as a new or different patient, or record for that matter.

Hi, thanks for reply. I am currenly using an autonumbwr for yhe pk and have set one of yhe fields to be unique and no duplicates in the record table. The field set to no duplicates represents each patient uniquely and each patient will have a unique number to represent himself. Due to...

Hi, exploring a concept here. In order to maintain the uniqueness of each record, I am thinking to have sone kind of random number generator built in or to be built outside access program for people to use for data entry. I would like to generate say...a 9digit number everytime it is asked...

Hi, I would like to have a query that pulls any ONE of the three tests stored in three different columns based on the date difference being the smallest. So column A, column B and column C, and they all contain date/time. if any one of the columns has value, use it and if there are two...

Hi, It seems that Access doesn't have countif function. I would like you guys to take a look at the example below and see if it is right or wrong: So basically I need a count of all the cases where the time difference is less than 48 hours. Code is as follows: select...