Search results

  1. S

    Input value by Combox only

    On the combobox, change the Limit to List Property on the Data tab to "yes" and that will prohibit users from typing something in on the keyboard.
  2. S

    Combobox Validation Rule

    I have 2 comboboxes (cboTeacher1 and cboTeacher2) that should not contain the same entry and in the Property dialog box have entered "<> cboTeacher2" in the Validation Rule field for cboTeacher1 and placed "You can not have the same teacher's name in both Primary and Secondary Teacher" in the...
  3. S

    keeping focus on combobox?

    Thanks for all for a great bunch of suggestions! The one I went with was one told to me by a friend and it was so simple, I thought I would share it. I usually find progremming the solutions the esiest for me, but this time I used the Validation Rule and Validation Text Properties in the...
  4. S

    keeping focus on combobox?

    Selenau837, I tried your .Dropdown suggestion and it did not really seem to do anything either. i do no know a lot about the .dropdown method, so I will have to look into that more. Thanks.
  5. S

    keeping focus on combobox?

    Thanks wazz, Yes it does work, the only thing is that I would rather the old choice remain visible for the user to see their mistake instead of leaving the combobox blank. Thanks for the great reply. Sierra
  6. S

    keeping focus on combobox?

    Thanks, That worked. Is there a better place to put the code that I wrote that would handle the 2 events (BeforeUpdate and Exit)? It just seems redundent that I have to put the same code in the 2 different events. Thanks for the help.
  7. S

    keeping focus on combobox?

    I have 2 comboboxes (cboTeacher1 and cboTeacher2) and I do not want them to contain the same value. If the same value is chosen, I want a messagebox to show the error and keep the focus in the offending combobox. I wrote the code below for cboTeacher1 and it functions in the case that your are...
  8. S

    Continuous Forms - Hide a control in a record?

    Thanks, I will look into that. I do not know much about the conditional formatting, but I will have to learn more about it. Sorry it has taken me so long to reply, forced to another project and had to leave this one, but now I am back on the issue.
  9. S

    Change Zoom Default setting from Fit to 150%

    Does anyone know how to change the default setting for the zoom setting in the report print preview view? Can it be done? I have been looking around and can not find it. I want to change it from "Fit" to 150% when I am previewing a report.
  10. S

    Text Box Sizing on a form

    Table format for report results Getting Closer..... Found the Dynamic Table thread that shows how to display lines around your data to display it as a sort of excel table. It works great for its purpose. However, I am still looking at how to size the Tri1-3 text boxes so that they are the...
  11. S

    Text Box Sizing on a form

    Finally figured out that there are margin Top, Left, Bottom, and Right Margin properties and by setting the Left margin, I could rectify the #1 on my problem list above. If anyone has a suggestion on how do I enlarge the Tr-1, Tr-2, Tr-3 cells (text boxes with 1pt Border width) to match the...
  12. S

    Conditional Formatting

    I am new to this stuff, but when I have received "#NAME" in a text box it is because The reference to the field that populates the textbox was either spelled incorrectly or I put in the wrong field that was not in the Record Source for the Report/Form. Hope this helps.
  13. S

    Text Box Sizing on a form

    I am working on a report that must be displayed in a certain way (I attached an image to show what I have so far). In essence it should look like a table and I have it almost to where I want it but I can not do 2 things: 1) In the description (left column), I need the line "Demonstrates...
  14. S

    Getting ID field instead of data field displayed

    Thanks Pat. I got it running they way you discribed. I kept getting mismatch errors because of a mistake in the table that i had. Once I fixed that, the query the way you discribed it, worked great. Thanks for the detailed descriptions and the help on the security issues search terms.
  15. S

    Getting ID field instead of data field displayed

    Thanks Pat for the clear instructions and I think I followed them correctly, but it did not work. I got an error stating "The SQL Statement could not be executed because it contains ambiguous outer joins. To force one of the jons to be performed first, create a seperate query that performs...
  16. S

    Getting ID field instead of data field displayed

    I am not sure if this is a Report question or a Query question, so if I am asking in the wrong place, please forgive me. I am building a report that will be deriving its information from a single table tblStudent. In this table there are 2 fields fldTeacher1 and fldTeacher2 and these fields...
  17. S

    Continuous Forms - Hide a control in a record?

    Looked at http://www.lebans.com/conditionalformatting.htm but it did not have anything on making a checkbox invisible and apparently, conditional formating is not valid on making a checkbox disabled. I am a bit stuck.
  18. S

    Continuous Forms - Hide a control in a record?

    Thanks Wayne, I will do that, I looked on the internet some before and only found out how to change colors and how to disable a control, not make it invisible. Thanks fo rthe search term I will take a look using that. I appreciate your help. Sierra
  19. S

    Continuous Forms - Hide a control in a record?

    I have a form that displays its records in a Contiuous Form. The controls on the form are: txtRecID, txtStudID, cboTrimester, cboType, fld Comment, and blnReqConf. My issue is that I need the blnReqConf (Request Conference) checkbox and label controls to only show on the reocrds when/if the...
  20. S

    Conversion / Format help

    I have 2 questions that I think maybe similar. First Question When building a Select query through query builder, is there a function or a way I can convert the field, fldWebSite, which is of the datatype Hyperlink to text? The problem I am having is that when I export the results to a csv or...
Back
Top Bottom