Search results for query: *

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...

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...

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...

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

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...

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...

that worked! Thank you all :)

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

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.

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

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

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?

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...

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

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...

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

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...

Thank you Golom. I'll try this out.

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

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...