Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jeremy0028
  • Content: Threads
  • Order by date
  1. jeremy0028

    Subform Linking Edit command button and form

    I have the following in a subform in datasheet view The form is called PeopleInsuranceSubform ContactID(Auto# NonPK) PersonID(lookup) InsuranceName Policy# Group# I also have a command button called Edit which has the following Private Sub Edit_Click() On Error GoTo Err_Edit_Click Dim...
  2. jeremy0028

    List Box Filter

    Basically I'm trying to create a list box filter on a form so when user clicks on a patient in the Patient demo tab Insurances related to the patient will appear on the insurance tab in the list box I have 2 page tabs on a form one called Patient Demo and the other called Insurances. The...
  3. jeremy0028

    Combo Box ?

    I have a combo box called Primary which has Yes/NO I have a Text Box called Text50 If user selects Yes From the combo box then the Text Box will show P If user selects No From the Combo Box then the Text Box will show S Any Ideas
  4. jeremy0028

    Query Union Select Filter Problem

    I have a tbl called people has the following PersonID(PK) LastName FirstName MiddleName PrimaryInsurance(lookup) SecondaryInsurance(lookup) I also have a tbl called charges with a combo box called person ID so when i click the add charge command button on tbl people the person id from the...
  5. jeremy0028

    combo box combining 2 columns into 1

    I have the following table called people PersonID(pk Autonumber) LastName FirstName Mi PrimaryInsurance(lookup) SecondaryInsurance(Lookup) I have a form called add charge and on that form i have a combo box billed to Which looks up people table personID, PrimaryInsurance,Secondary Insurance...
  6. jeremy0028

    List Box Double Click Event

    Is there any why i can double click the Insurance Name in the List box and insert that Name into the Primary Or secondary Insurance Text Fields on the form called frmPatients I do not want to use combo Boxs I have a main form call frmpatients which is the loaded form on that form i have 2...
  7. jeremy0028

    Reports Question

    I have a table and frm called Insurance which has the following InsuranceID(Pk)Auto Insurance Name I have a table and form called ProviderIds Provider(lookup Combo Box) Code SELECT Providers.ProviderID, Providers.[First Name] & " " & Providers.[Last Name] & " " & Providers.Mi FROM Providers...
  8. jeremy0028

    Combo Box Add All Records.

    I have a combo box on a form called Insurance which looks up a table call tbladdinsurance InsuranceId(Pk)AutoNumber Insurance Name Instead of just selecting one record frm tbladdinsurance I want to select all records any ideas
  9. jeremy0028

    List Box double click to goto record

    I have a list box which looks up ProviderID(PK), First Name, Last Name, MI from the tbl called tbladdprovider i'm trying to create a double click event whereby when I double clik providers name it will take me to the form called frmaddprovider which will display provider information. I have...
  10. jeremy0028

    Forms Linking what am i doing wrong

    I have a main form called IRI-Form On that form i have PersonID(AutoNumberPK)Last Name First Name Middle Name I have a command button called Add Charge which open a pop up form called frmAddCharges In the frmaddcharges I have a text box called Patient In the control source i have the...
  11. jeremy0028

    Pop up form same record

    I have a table and form called patient info All the following fields are in one record Main form called patient info Account#(pk)Auto Number Last Name First Name Address City State Zip Phone I also i have a command button on main form called primary subscriber info which opens a pop up...
  12. jeremy0028

    Clear form question

    I have a form called subscriber info 1 I have the following fields Last Name txt First Name txt MI txt Address txt City txt State txt Zip txt Phone Gender(option Group) (1=Male 2=Female) I have 2 command buttons One called copy from patient info- which...
  13. jeremy0028

    Combo Box 2 part question

    I have a combo box called gender using the wizard i used i will type the values i want. I used male, female. which stores the information into a table called patient info under a field called gender How do you set the default property so it would be male evertime a user adds patient record...
  14. jeremy0028

    Subform set focus new record

    Okay i have a table and form called patient info. On the form i have a command button called Add Payments. which opens the payment form. I have a form called payments on that form it has Patient Account, payment date check #Check Amount, Payment Type I also have a subform called Payments2...
  15. jeremy0028

    Add new Record Datasheet view subform

    I have a form lets call it table one. On that form it has a combo box called patient account. I Also have a form in datasheet view called lets table 2 which is the subform for table one form. On that form i have the following Date of Service from date of service to procedure modifer fee...
  16. jeremy0028

    Append Query Question

    I have a table and form called patient info. It has Account # which is auto number And is P/K, first name, last name, address, city, state, zip, phone, DOB I also have a table and form called add charge. In the table i have Patient acount, date of service from, date of service to, procedure...
  17. jeremy0028

    Date Function

    I have a text field set as Date() so when ever a users enters a new record records computer date. However on the form it shows as 11/8/2005 suppose to show as 11/08/2005 any ideas. Also i have table with a date field. date is set as MM/DD/YYYY format however when i generate a report on the...
  18. jeremy0028

    Option group & Reports

    Database is almost complete put dont know how to do the following Newbie I have a option group called is there another insurance in this option group has yes no none in the description field of the table 1=y 2=n 3=none When i generate a report is display as 1 2 3 if one of the option is...
  19. jeremy0028

    One more combo box question

    Thanks for all your support database is almost finished last one work fine I have a table & form called patient info and a table & form called charges In the charges form i have a combo let say combo59 that looks up patient info table first name, last name, MI and stores that information into...
  20. jeremy0028

    Combo Box Question

    I have a table called diagnosis which has the following Diagnosis, description On a form i have 4 combo box that look up the diagnosis table i also have a field called dx pointers the 4 combo box are labled dx1, dx2, dx3 dx4 What i want do to is if a user select dx 1 it will show in the dx...

Part and Inventory Search

Back
Top