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: *

  1. marie515

    Split Database - Unable to Add New Fields to Forms

    Hello, I have a split database and i added a new field to the main table called "finalresolution". The field was not in the table when I split it originally and now i want to add that to the front end forms (again I split this database so multiple users can use it). When we go into the main...
  2. marie515

    Generating a report or form where you can grab formatted data...

    Thank you very much Randy! So, I'm confused (not unusual) :) I have a button that opens a form which I want the contents of that form copied. So, do I add the code you provided to the "on click" Event Procedure? See below what I see when i click this -- where does this new code get added...
  3. marie515

    Generating a report or form where you can grab formatted data...

    Hello, I would like to generate a report or a form which will be formatted in a particular way (see example below)which can then allow the user to "grab" using their mouse and retain the formatting of the content so that it might be pasted it into another program. Is this possible? Example of...
  4. marie515

    Formatting an Autonumbering scheme

    Thanks Trendsetter -- I'll try your recommendation. :)
  5. marie515

    Formatting an Autonumbering scheme

    I want to have a custom numbering scheme for a database. I want the following information: RFP20041001 - (sample numbering scheme) The break down above is: RFP - all records begin with this Year - 2004 (that record was entered) Month - 10 (that record was entered) AutoNumber - 01...
  6. marie515

    Autonumber - how to customize

    Hi all, I'm interested in creating a field that will automatically generate a new log number into a record, but I don't just want a number, I would like to show the following (see example following): RFP092004a The break down of the above is: *All records begin with RFP [RFP] *All records are...
  7. marie515

    How to separate text in a single column

    that worked! Thank you all :)
  8. marie515

    How to separate text in a single column

    I meant to say 2 "*" in the note above, not 3. Sorry
  9. marie515

    How to separate text in a single column

    Lespaul -- My data consitently has 3 "*" in the name field. As an example, it may show any of the following ways: Terri**Smith Terri*L*Smith Terri*Lynn*Smith So, would the way in which PHV advised above -- work in each of the above cases? Thanks.
  10. marie515

    How to separate text in a single column

    Thank you both so much for your help!! I can't tell you how long this would have taken me to fix this.
  11. marie515

    How to separate text in a single column

    PHV -- that worked! Now -- what should I type for the last name? Thank you!!
  12. marie515

    How to separate text in a single column

    I changed it to read as follows: Name1 = Left(Name, InStr(Name, "*") - 1 When I run it, I get only "0" in the field returned. Any idea why?
  13. marie515

    How to separate text in a single column

    Thanks for your help. I entered the following in the field name in my query: FirstName = Left(FullName, InStr(Fullname, "*") - 1 When I run it, it's asking me to "enter parameter value" for "first name". Am I supposed to use the real name of my field here? My field name is "name" Can you...
  14. marie515

    How to separate text in a single column

    Thanks - My company still uses Access 97 and I don't see anything related to the split function. Any other ideas/suggestions?
  15. marie515

    How to separate text in a single column

    Hi there, I have a column with members names and the names are listed as follows: James*R*Smith Susan*L*Jameson etc. I would like to separate the 1st and last name into two separate columns. Can you advise me how I can tell the data to pull all characters to the left of the 1st "*" and to...
  16. marie515

    Refresh Screen?

    Thanks Loktar! Which event do you think I should load this onto..."before update" or "after update"?
  17. marie515

    Refresh Screen?

    Hi all, On my main menu, I show how many "open" records are in the database. This way, the user can click on the "open records" button and go directly to work on the cases that are still open. Question: Let say someone goes into the main menu and then clicks on the open case list and works...
  18. marie515

    Visible Problem

    Thank you Golom. I'll try this out.
  19. marie515

    Visible Problem

    Hi JimbOne. I'm not sure what you mean by "value"? Can you clarify?
  20. marie515

    Visible Problem

    Hi everyone, I have a drop down field in which a user can select one of many items. In that drop down, there are 2 items that when they are selected, three other fields become "visible" and the user would fill in these other 3 fields, otherwise they would remain invisible. Here is my code on...

Part and Inventory Search

Back
Top