Recent content by crucial_gear

  1. C

    take a look at my finished database

    Hope you are not tired of sending you db all over the place. Would be great if you could forward me a copy. I am in the process of designing a simular type database. crucial_gear@prodigy.net thanks!!!
  2. C

    appointment scheduling

    Try doing a requery on the form that has the date. me.formname.requery
  3. C

    Problem with HTML email

    I have done quite a bit of emails with HTML - I never could get Outlook to send it correctly - it does not seem to understand the MIME format. However I used a product called Group Mail Free from Infacta (www.infacta.com). This product works very well for sending HTML formated emails. Maybe you...
  4. C

    Problem with HTML email

    I see that your post is pretty old, however I am wondering if you ever got this work? Near as I what I can tell you are trying to send an emailed based on the HTML code with the values from your database is this a correct assumption? I am developing a database now that I have considered...
  5. C

    appointment scheduling

    Don't know of any appointment application that you could use to hook into Access and pull your contacts from. Honestly the best approach would be to develop the appointment tracking within your contacts database. There are certainly enough people who post on this discussion forum that I would...
  6. C

    Simple code, yet frustating for me!

    Try using a Select Case: Select Case Me.Contractor Case is = "GECC" Me.DIMAFlatAddress.enabled = False Case Is = "SVDP" Me.DIMAFlatAddress.enabled = true End Case Just add a new Case Is statement for each condition you need to test for.
  7. C

    Is there a way to change a Combo Box to a text box using code?

    I would like to have a combo box available for the user to select a value. Once the user has made a selection and exits the Combo Box I would like the combo box to change to a text box and display the value they selected from when it was a combo box. Can this be done using code on the OnExit...
  8. C

    Combo Box values based on current record

    The zipped file is to big to attach to this post, is there an email address I can send it to? To answer your question, No the persons name is not in the table with the shift information. This is a two step process. First Step: Enter in all the shifts that are available Second Step: Assign...
  9. C

    Combo Box values based on current record

    Sure, where would like me to send it?
  10. C

    Combo Box values based on current record

    Thanks for the reply. I have tried Me.Fieldname.requery, when I click on the combo box, the values displayed are from the previous record. I need it to requery for the current record. I have attached an image of the screen. On the print screen you will see two records, the two employees...
  11. C

    Form Size

    Are your forms PopUp forms? If so the trick that I use to adjust the size of pop forms so that they stay the same size all of the time is this. While you are in design view and have made all the changes required, in the upper right hand corner click on the (sorry can't remember what is called)...
  12. C

    Combo Box values based on current record

    I have a continuous form that is being used to schedule shifts for employees. It displays a list of employees including their position and scheduled shifts. I have a combo box that is being used to select a shift for the selected employee. I only want the combo box to display the shifts...
Back
Top Bottom