Search results

  1. J

    Prefix + AutoNumber as Item Code

    Is it normal to spend a lot of time of designing my forms? Haha. I just realized that it's so difficult but challenging to do so. When you said "make them look and *feel* the way you want your Users to see them," did you mean that I should already lay the forms out like the real ones (actual...
  2. J

    Prefix + AutoNumber as Item Code

    Hold up, hold up. HAHA. When I was first trying to digest what you just posted, I got soooo confused. HAHAHA. So I tried to review, and yeah, now I know what I want and what I should do. Yeah, I guess I will make Tab Controls! ;) Thaaaanks. Will post here soon.
  3. J

    Prefix + AutoNumber as Item Code

    Another question. I've seen the examples that you had. How do I separate fields in different pages in a form? For example in f_Employee, there are personal infos like birthday, address, etc. And there are also employment info like job title, supervisor, etc. Is it possible to do so?
  4. J

    Prefix + AutoNumber as Item Code

    Thanks! Hmm, I can't seem to upload my work. -_-
  5. J

    Prefix + AutoNumber as Item Code

    Okay, I literally just made forms for each table, it's stupid, I know. But I honestly have no idea how proceed. It's either my brain's not working today, or I'm just completely dumb. HAHA. :banghead: Please tell me what to do. Aaaand my file doesn't fit here anymore. How do I upload it? -_-
  6. J

    Prefix + AutoNumber as Item Code

    Alright. Thanks! :)
  7. J

    Prefix + AutoNumber as Item Code

    Aaaand another thing. I just came up with this a few days ago. So when employees are requesting for supplies from Admin, they have to fill up and sign the Acknowledgment form right? I was thinking of just letting them do it on the database itself. Each employee has his/her own password which...
  8. J

    Prefix + AutoNumber as Item Code

    Aaaand another thing. I just came up with this a few days ago. So when employees are requesting for supplies from Admin, they have to fill up and sign the Acknowledgment form right? I was thinking of just letting them do it on the database itself. Each employee has his/her own password which...
  9. J

    Prefix + AutoNumber as Item Code

    See that's the thing. I want to start making the forms. But I'm afraid because I get confused with tables and queries. I don't know when I should be making the query. But I'll try. Thank you! :)
  10. J

    Prefix + AutoNumber as Item Code

    Really? Hahaha. I don't know, it's looks odd. Anyway, so I think that's it for now. What's next then? Should I make forms?
  11. J

    Prefix + AutoNumber as Item Code

    Yep, I've already figured that out. HAHA. Hmm. But you said I need a query? What would it be for?
  12. J

    Prefix + AutoNumber as Item Code

    I honestly could not understand what you just said. HAHAHAHA. Maybe I should review my knowledge on reports. But anyway, so those queries are for reports? I hope I'm right.
  13. J

    Prefix + AutoNumber as Item Code

    Here's my not so good progress. -_-
  14. J

    Prefix + AutoNumber as Item Code

    Hmm. I can't seem to add tables for the assets because I'm so confused. -_- My database should contain the following info on assets w/ (EXAMPLES): STATUS (Released, In Stock, Damaged) SEQUENCE NO. (00079) SEQUENCE LETTER (A) PROPERTY NUMBER (LOCATION + RECEIVING DOC. NUMBER + RECEIVING DOC. +...
  15. J

    Prefix + AutoNumber as Item Code

    I have just another question, why does the qryPurchaseOrderDetail and qrySupplierRequestDetail look the same? Everythings the same actually, except for one criteria. :confused:
  16. J

    Prefix + AutoNumber as Item Code

    Okay, I know this might sound so stupid but, what are those queries for? And how should I use them?
  17. J

    Prefix + AutoNumber as Item Code

    Thank you! :) Okay will study it before I proceed. ;)
  18. J

    Prefix + AutoNumber as Item Code

    HAHAHAHA. Thank you! :) I still need to add tables thought. It's for the item issuance (items that need property accountability). But I don't how to go about it. :( And you did say this: "Once you add your Acknowledgement table and upload your review database I will create a couple of queries...
  19. J

    Prefix + AutoNumber as Item Code

    Okay, replay! HAHA. I hope the links are working now.
  20. J

    Prefix + AutoNumber as Item Code

    Hi! Thank you. HAHAHA. 1. Actually, I need the saDSPN in t_SuppliesAcknowledgement. It serves a different purpose than the one at t_SuppliesRequestDetail. The DSPN for t_SuppliesRequestDetail is for charging of items requested for purchase. The one at t_SuppliesAcknowledgement is for charging...
Back
Top Bottom