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 Chriss Miller 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. Neowynds

    Send e-mail from access databases

    Great Thread multiple stars for multiple people! Quick Question... I have a form with one subform. I was ondering if there was a way to email as an attatchment just the current record of the parent form with all linked child records as well. I am using outlook, and was using this code to...
  2. Neowynds

    Send single record through outlook

    Thanks Paul, Works Star! Neo
  3. Neowynds

    Auto numbering

    Thanks for the quick response Happy Turkey Day! Possibly the problem is I am not communicating the difficulties I am having clearly. What I am looking for is a way to have a true alphanumeric sequence. The format trick works on the form but not in the actual data in the table. Also the two...
  4. Neowynds

    Changing a non-visible field visible

    Alec, Nice of you to notice that the values of both will always be equal and thats a handy little trick....You get a star! Thanks, It will help on my database too. Neo
  5. Neowynds

    Send single record through outlook

    I have a button set up on the bottom of my database with the following code to send the form frmSIR via email. Private Sub Command64_Click() On Error GoTo Err_Command64_Click Dim stDocName As String stDocName = "frmSIR" DoCmd.SendObject acForm, stDocName...
  6. Neowynds

    Auto numbering

    I have been told to stay away from them as well, however I still think they will be the best for my use, The only problem I am having is I want to make an alphanumeric autonumber (format AB1234) Where AB is dependant upon a combo box in my form. When I select the job site from the drop down box...
  7. Neowynds

    Alpha Numeric auto-generated number based on a combo box...

    Michael, I do not have enough programming experience to properly modify the code listed in your FAQ. Also the FAQ does not cover this particular instance where I need the two letters within the Case Number to be dependant upon which post location is selected in the dropdown combobox (i.e...
  8. Neowynds

    Alpha Numeric auto-generated number based on a combo box...

    Thank you both for the quick responses, If the recordset was locked properly, would the code provided above be feasible? Neo
  9. Neowynds

    converting from access 97 to access 2000

    Thank you ken you just cleared up a whole lot of questions for me. Have a star! A Very Grateful Neowynds
  10. Neowynds

    Alpha Numeric auto-generated number based on a combo box...

    Looking at the code with my limited knowledge it looks like it would work for me, however I am a bit of a newbie, so where exactly would it go? In an event and if so which one? Thanks for the Quick response Neowynds
  11. Neowynds

    Alpha Numeric auto-generated number based on a combo box...

    Hello all, I am done with my Security Incident Report database except for one thing. I need it to auto generate a case number for each file as they are entered in. The format for the number needs to be NM1234. The two text characters will be dependant upon which location they choose from a drop...
  12. Neowynds

    Easy question from newbie :-)

    If you are using the company intranet is it possible for her to make a data access page and link it to a website so that the other person can use the database without ever opening access. Im just a technical user but I think the concept might work, I would ask some of the more experienced people...
  13. Neowynds

    auto number

    OK, Not sure if anyone is still monitoring this thread or not, but I have set up my database to be exclusive so that only one person at a time may have the database open. And these are the steps I took to try to get an autogenerated CaseNumber Table = SIR 1. Table - Field named CaseNumber...
  14. Neowynds

    Access 2000 to 97 conversion problem

    Sorry it took so long to respond Ken I decided to take my first 2 days off in over a month. This was the exact problem. Thanks again Neo
  15. Neowynds

    auto number

    Thank you I think I will go with opening in exclusive mode. Just on the offchance. Thanks for the advice. Neowynds the REALIST. I am not optimistic nor pessimistic but a delightful blend of both. Wich sometimes causes a quarrel in my mind. You dont wanna see me when THAT happens. TRUST ME...
  16. Neowynds

    auto number

    I see your point, however the nature of this particular database is that the user will not even have it open unless there is a security incident (i.e. fire, theft, etc.) The chances of three officers all filling out incident reports on three things that happened simultaneously is slim to none...
  17. Neowynds

    Access 2000 to 97 conversion problem

    What do you mean declared? The combo box row source is a query that contains LocationID,LocationName,and Address. I made sure all three were still in there when I opened the database in 97 because I had run into the problem of not having them all in my query before. If you mean did I have them...
  18. Neowynds

    auto number

    Maurie, Where would that go and what would the code be? I am looking at making a numbering system for case numbers and need something similar to an invoice number. Also there is very little chance of two users entering records simultaneously on my database since there are only three authorized...
  19. Neowynds

    Access 2000 to 97 conversion problem

    Thanks for the Quick response, No no error. It is a blank box, almost as if it is not registering the third column in my query the combo box is based off of. If I switch the column number to 1 I get the LocationName. But when I switch it to 2 I dont get the address like I did in 2000. Its very...
  20. Neowynds

    how to exit microsoft access?

    There is a good example of this in the main switchboard of Northwind sample database.

Part and Inventory Search

Back
Top