Search results for query: *

Duane, I see that now after researching "two digit years" and learning how they are interpreted. Thanks for pointing me in the right direction.

Thanks for your reply Duane. I failed to mention the csv is an export from our primary hospital application (Cerner) that was set up by Cerner application development team so I'm unsure what the regional settings are. I do know that when a patient is entered into Cerner the DOB is entered as a...

I'm importing a csv file that contains patient records into Access 2003. When the file is imported into an existing table it will change the year in the DOB - a date field. For example, 12/20/1928 in the csv file will change to 12/20/2028 once imported. This issue is sporadic and it does not...

Duane and TheAceman1, my apologies for not posting what I was trying to accomplish but TheAceman1 is correct, setting the RcrdCmp field according to the last checkbox checked was not want I wanted. I wanted to check if any of the checkboxes were checked. PHV, thanks for showing me the error of...

I'm curious to know why this isn't working and I'm sure the answer is quite simple but for whatever reason I cannot sort it out. Private Sub Adnma_Click() Dim Ctl As Control For Each Ctl In Me.Controls If Ctl.ControlType = acCheckBox Then If...

Disregard. I found a solution using joins in queries.

Perhaps my problem discription didn't focus enough on the formatting of the report rather than the data structure. This is the actual data structure: Procedure ProcCount AvgColToComp Diff 1200 29.98 Hemogram 1303 17.82 How it appears in the...

Hello, I have a report with a query control that resembles the following output: Location AppleCount OrangeCount CherryCount Florida 3 5 2 Texas 4 9 1 The report needs to read as: Florida Apple Count - 3 Texas...

Here's a closing thought. What if the user had an option to select more than two? For example: AddBiopsyMS or AddBiopsyMS2 or AddBiopsyMS3 What if one of those 3 were not NULL?

That was what I needed HarleyQuinn. Sorry about the typo but you figured it out regardless. Thanks again.

HarleyQuinn, Thanks for your reply. I neglected to mention that only one will be null. Using a check box on the form the user is making a choice as to which one they would like to appear on the report.

I have a report that is populated from a table using a query. On the report is the following bound controls: Name MRN MD The following is unbound: PathDateMS In the unbound field I'm successfully populating it with data from two hidden controls on the report (combining them to populate the...

Duane, That was it! In the Regional and Language Options of the Control Panel there was a setting called: When a two digit year is entered, interpret it as a year between: (Year) and (Year) My settings were between 1930 and 2029. I changed the settings to be between 1915 and and 2014 and...

This is an odd question and it may be glaringly obvious to someone more experienced than myself. I'm importing a .csv file into a table. There is a DOB field in the .csv file that is formatted as mm/dd/yy. The format of the DOB field in the table is mm/dd/yyyy. In viewing the records after...

I knew it was an easy solution...just not easy for me. Thanks PHV!

Hi all, I've perused this forum and found some answers to my question ( thread702-1440004 and thread702-1434023 ) but I'm unsure how to apply those answers to my issue. I have this code on an unbound combo box on a form: Private Sub FindPatient_AfterUpdate() FilterOn = False Dim MyRecSet As...

Running Total! Didn't think about that. Thank You Ian!

Hello all. Possibly this is an easy question and I apologize if it's been repeated. I have queried this forum and cannot find the solution (possibly I didn't know how to ask it correctly). I'm using XI and connecting to an Access DB via ODBC. I'm trying to count the number of unique values...

Hello Ladies and Gentlemen. Once again I come to you with what I'm sure is an easy solution but the solution is some how eluding me. The issue is: I have a Main Form (Main Form is not the true name) which is bound to a table. Main Form has a button called [Add Comments]. When the button is...

Thanks Remou! I knew it was as simple as that