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!

Recent content by valley8338

  1. valley8338

    macro to set primary key

    Here is the problem that I already ran into by not using the correct projectid. Originally, I had an autonumber field as my primary key, and the projectid was being entered manually, after the original record was created. One part of the database tracks where projects are (editing, cover...
  2. valley8338

    macro to set primary key

    I have to have the projectID in the format of yymm-##. This is not up to me to change. In searching through old posts, I found something about using a form current event, but I didn't understand the instructions. If soemone could help me with this please...
  3. valley8338

    report or query - help...

    WOO HOO!!!! It works!! I changed the projectID to my primary key (which is now causing me an entry problem, but anyways) Now I am able to pull just the project ID I want and see the tracking. Thank you so much for sticking it out with me!!!
  4. valley8338

    macro to set primary key

    The month that the project is requested would be fine, there would be no way to determine what month the project was started when they are requesting, and I need this to be my primary key for lookup fields on my forms. I would want the ## to start from 01 each new month. The reason for the ##...
  5. valley8338

    macro to set primary key

    I am trying to write a macro (I do not have much experience with this at all) that will set my primary key. here is what I need it to do... format of field will be yymm-## I need it to populate the 2 digit year and month, then increment the last 2 numbers. I am trying to write the macro in...
  6. valley8338

    Autonumber Blues

    I came across this poist and it is exactly what I need to do. I am however a little confused as to where I put this in my form. Where is the form current event? thanks!!
  7. valley8338

    report or query - help...

    Here's how I have the records being created. I have a project request form. An end user types in what they need from us and submits. We then reopen the form and edit in projectid, project lead, designer, etc. I think what I am going to try to do is have projectid autonumber and then go back...
  8. valley8338

    report or query - help...

    That is exactly what is happening. I noticed it earlier when I was trying something. I took out the primary key field and then everything started going haywire. I just changed it back. Is there any way to make this work as is? The only problem with making projectID my primary key is that it...
  9. valley8338

    report or query - help...

    allanon-- I tried typing what you put in the expression builder. I received the following error when I tried to run it. "The syntax of the subquery in this expression is incorrect. Check the subquery's syntax and enclose the subquery in parentheses"
  10. valley8338

    report or query - help...

    allanon-- I am not sure where I am supposed to type all of that in. I am working on access 97, not sure if that makes a difference. When I go in to create a query, there is nowhere for me to type any code.
  11. valley8338

    report or query - help...

    jsolutions-- I got the following error when I tried to filter. "type mismatch in join expression" both fields in the project track and the projectid table are set to text. The only differences int he field properties is that projecttrack.projectid is a combo box with a lookup and...
  12. valley8338

    report or query - help...

    It is pulling from the projectid field of the project info table. I did that to be sure that the fields match
  13. valley8338

    report or query - help...

    Wait. I just noticed that I have the projectid field in the project track as a lookup field. could this be affecting it?
  14. valley8338

    report or query - help...

    It is being typed in. The data type on both fields is text
  15. valley8338

    report or query - help...

    ok, I ran the query for projectinfo and all the data came up. When I ran projecttrack, nothing came up. I double checked the table and there is data in the projectid field and it is what I am typing in and it matches what is in the project info table. i am at a complete loss...
See more

Part and Inventory Search

Back
Top