Search results

I have 2 combo boxes one called primary which has Primary, Secondary, Tertiary I also i have combo box called "Is There another insurance" which has yes, no, none, What i want to do is if user selects primary the combo box called is there another insurance becomes visiable however if user...

Main form is frmProviders I'm trying to use the license # in the frmProvider as the default for my report however when i create a report it is only showing the Insurances in the subform. What i want to do is show all insurances and providers in the database along with there license # for the...

What i want to do is if a user forgets to put lets say Address or Zip Will not allow user to save record but instead will highlight the text boxs that are required. Once data is put in will allow user to save record. Any ideas

I have a basic data entry form which is called frmPeople which has the following First Name Last Name Address City State Zip What i want to do is if user changes/edits any of the information will prompt user do you wish to save changes yes/no If user clicks yes will save info if user...

I have a subform but when ever i click add new record removes everything listed in the subform and creates a new line. Is there a way when you click new record all information will still display records but creates a blank line under those records.

I use to be able to copy a web site and paste it on the my microsoft word and all the images will show which are usually art images. But now when i click copy and past to my word document only the txt show up. Second Question(not related to Office) When I Right click to save a jpeg file from...

Main form is frmPeople As you can see i have a subform called frmPeopleInsurancesSub Next to that I have a Edit Command button which open a forms called PeopleInsurances When user wants to edit one of the insurances all user has to do is click on on one of the insurance and click edit to take...

Main form is people What i'm trying to do is link the list box in the insurance tab to the personID in the patient demo tab so whatever patient is enterd in the patient demo tab there insurance will be linked show in the the insurance tab to create a kind of filter This works if i create a...

If you take a look the form called search you will see a list box what i want to do is when user selects record from list box it will display all information in the text box below any ideas Thanks in Advance

I have the following in a combo box Yes, No followed by a text box called txt4 What i want to do is when user select yes from the combo box the text box will show P If the user select no from the combo box the text box will show S Any Ideas

Please help me fix my database If you take a look at the tab called insurance i have a list box. How do i filter the list box so that it will only display the patients insurance based on the demo tab. Also i have other records in the table called people. they are not showing in the people...

Please see attached database If you open the form called people you will see a command button Called add charge once pressed will open a form called charge On the Bill To combo Box I have the following Union Select Query SELECT PrimaryInsurance, PersonID FROM tblpeople UNION Select...

Please see attached database If you open the form called frm people you will see and add charge command. Once pressed will open the form called frmcharge On the frmcharge i have 2 combo boxes that lookup people frm PrimaryInsurance, SecondaryInsurance,TeritaryInsurance I'm trying to create a...

I have microsoft access 2003 Everytime i select tool box and chose example combo box or option group none of the wizards are working just place it on the form I uninstalled and reinstalled it but still the wizards in the tool box dosnt work Last thing i was working on was a switchboard but...

See Attached Database I created a form called cptSearch On that form has a list box What i want to do is when user clicks on cpt in list box and clicks on the edit command button it will open the frm called frmcpt so user can edit details for the specific cpt code Any Ideas

Please see attached database Main form is frmPatients If you click on the main form called frmpatient you will see 2 text boxs one called Primary Insurance the other Called Secondary Insurance Above those text boxes are to hyper links which open the list box What I'm trying to do is if a...

I have a query called providerIds It appends to the a table called providerIDS Everything works fine however when ever new data is added to a form The data shows in the append query but not in the table where it appends to. How do update the table where the append query is attached to.

See attached database List box connect to qryInsurance Main Form Employees 1st Question is how to i add a wild star character so that if a user types a all insurances starting with that letter letter a will show up in the list box User Type B, c d etc etc 2nd Question if you take a look at...

If you take a look at the sample database Main from is frmaddprovider In that form i have subform followed by a default Pin#(License) If you take a look at the report what i'm trying to do is Add the provider FistName & Last Name and default Pin# to all insurances not listed in the subform...

See attached Database I'm trying to create a list box as you can see in the list box section is conected to the patients query What i'm trying to do is is link the text box to the list box but dont know how to do it. Also user can search by Account#,Last Name, First Name and Social...