Search results for query: *

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

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

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

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

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

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

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

Hi all. Quick question and I'm sure it's simple but I'm not sure what else to try. I have a form that is opening another from via a button. The code for the button is as follows: Private Sub Data_Sheet_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "ClinicFrm"...

I'm desperate so I apologize if this post is redundant and any help is much appreciated. I have a combo box that is based on a query. The query looks up the "Last name" and "First name" of the form's source table then it finds the record and bookmarks it: Dim MyRecSet As Object Set MyRecSet =...

Hello all. What I'm trying to do is simple and I've read through various threads in this forum and found bits and pieces of what I need but still having an issue. The issue is: I'm attempting to make bound controls visible/not visible on a tab control. The problem is that on the first record...

Hi again all. I have a form called Clinic. In this form is a subform. The Parent/Child link between the two forms is the Clinic Date field. What I'm attempting to do is dbl-click a field called MRN (number field) on the subform which will go to the corresponding patient record. I found this...

I have a form that has a date field (Clinic Date). In this field users enter a date of a meeting held every Thursday. Records are created in the form that can have a date of next Thursday or a Thursday in December. I would like to have the user open the form and the first record that has a...

Hello again. In need of some assistance (as usual). I have a subform embedded in a tab. The subform is a table and it's Master/Child links is a date field. The subform displays the records perfectly however when a new record is added a row is inserted (the row with the *) below that record...

Hello all. I find myself yet again needing your expertise. I have a table that is pre-numbered in lieu of an autonumber process(because the autonumber won't work for our current patient records due to the fact that historical patient information is based on a manual numbering system). I would...

I have created a button that will allow the user to exit and close the form if necessary. The problem is that I have a required field that is being verified before the form is closed thus creating the user to enter an arbitrary value in the field then pressing the button again. The code for...

I have a form with two combo boxes. What I'm attempting to do is this: If Combox A has a certain value I want to make Combox Box B required for entry. The problem is that I'm fairly new to VB and not sure how to make this happen. Any help is much appreciated. Thanks!

Please excuse my newbie ignorance but this one I'm sure is simple but I have no idea were to begin. There is a field on a form that is called the MRN field. If the field is NULL then I want a message box to appear stating "MRN field is required". I'm unsure if a macro is the best approach...

Hello, Im trying to set up a worksheet to exclude blank rows when printing. This is what I'm running: Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Sheet1" Then Cancel = True Application.EnableEvents = False Application.ScreenUpdating =...

Hi. Being fairly new to Access I'm sure there is a way for all you smarty pants' to assist me. I think it's fairly easy. Fields in form: Curative Treatment Date of Primary Treatment Surgery Date When Curative Treatment = Surgery I want the Date of Primary Treatment (entered manually) to...