Search results

  1. C

    Limit Memo Filed to 255 Characters

    Hi AlenS, I tried entering in =Len([Notes]) <= 255 for the Validation Rule property for my field named Notes, but it doesn't seem to be displaying my Validation Text message that I entered in. Any other suggestions? Thanks!
  2. C

    Limit Memo Filed to 255 Characters

    Is there a way to limit a memo field to 255 characters or at least tell the user that he has typed more than 255 characters? I would change this field to a text field, but I have data from an old system stored in this field that is more than 255 characters long. I have to stay under the 255...
  3. C

    Character Code for Page Break

    I'm trying to create some code that will remove page breaks. The report is in rich text format. Can anyone tell me the character code for a page break? Is there a character code for a page break? I've tried using the MS VB Help, but I haven't had any luck coming across it. Thanks!
  4. C

    How To Create a Delete Query

    Can anyone tell me how to create a delete query? I want to delete any company that is listed more than onec in my table based on company number. (The company number is not the primary key for this table.)
  5. C

    Problems With A Simple While Not EOF Statement

    Thanks.
  6. C

    Multiple Control Sources for One Check Box

    The check box(s) is used to select a records from my company table. When this field is set to true, the data for this particular company, along with the rest of the companiesthat were selected, is exported to an excel sheet. After the data is exported, the field is set back to false. I wanted...
  7. C

    Multiple Control Sources for One Check Box

    I have a check box on one of my forms call INDIVIDUAL. This field is in two other tables. Can this check box be referenced, so that if the user checks or unchecks the box, the value will be passed and saved to all three field in each table? Hope this makes sense. Tanks
  8. C

    Multiple Control Sources for One Check Box

    I have a check box on one of my forms call INDIVIDUAL. This field is in two other tables. Can this check box be referenced, so that if the user checks or unchecks the box, the value will be passed and saved to all three field in each table? Hope this makes sense. Tanks
  9. C

    Problems With A Simple While Not EOF Statement

    Thanks! That worked great, totally forgot about doing that. I'm making things much more complicated than they should be. Anyway, since I've been working on this using VB, could someone tell me if the code that I have come up with so far is correct? I still have some errors that I'm trying to...
  10. C

    Problems With A Simple While Not EOF Statement

    Can someone help me with the coding of this. I'm not very familiar with VBA. What I want to do is go through all the records in the table COMPANY_TABLE. If the field YN_Holder is set to true, then I want the YN_Holder set back to false. Here is what I want it to do down below. I just don't...
  11. C

    Selecting Multiple Records from Datasheet Form

    Thanks. I'll have to look into this. Currently I have created an extra field in my table. I'm trying to make it so that if the user checks this box on the form for which ever companies they want. They can then run a query that will then export records for companies that have this check box...
  12. C

    Selecting Multiple Records from Datasheet Form

    My user would like to select different companies from a Datasheet form that I have created. He would like to select multiple companies so that they can be moved into another table for export. The form that he will use does not have to be a datasheet form, but he would prefer it to look like...
  13. C

    Concatenate number and string

    Thanks.
  14. C

    Concatenate number and string

    I have to change my field type for my COMPANYNUMBER from a string to a number. By doing this, will this effect a part of my database where I havc Concatenated the COMPANYNAME with the COMPANYNUMBER? Thanks!
  15. C

    Check Code for Weakness/Error?

    Can anyone briefly look over the code that I have written for any errors/potential errors. The code seems to be working correctly, but I am not that confident in my vba skills. Brief explanation: The form frmLastUpdated will display the last time data was exported. When the user clicks on the...
  16. C

    Correct Syntax To Change Form Property

    Thanks! That worked.
  17. C

    Correct Syntax To Change Form Property

    frmLastExported is the name of my form. What I am trying to do is to make my form go away and then reapear after the data that I am importing has been processed.(I don't want to close my form, if at all possible) If I can't make the form invisible, then will the hide property that you stated...
  18. C

    Correct Syntax To Change Form Property

    I'm trying to write a function that will turn a form's visible property to false, but I haven't had any luck finding an example. I know this is wrong, but here is what I have so far: Private Sub Command5_Click() Me.frmLastUpdated.Visible = False End Sub Can anyone help me out? Thanks...
  19. C

    Code for Closing Access

    Thanks! That did it.
  20. C

    Code for Closing Access

    What ode that will allow the user to completely close acces when they click on a button? I came across it at one time, but I can't seem to find it now that I need to use it. Thanks!
Back
Top Bottom