Prefix + AutoNumber as Item Code

[johannaellamay]

Are you asking about Tab Controls? Because you would create separate Subforms and then place them on different Tabs. Oh, Tab Controls are placed on a Main Form. Now, if you are saying you don't want everyone to see that information then you create one Form for all and another one with personal information and that one will be placed in the ADMIN section once the Main Menu/Switchboard is set up.

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.

 

[johannaellamay]

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 sizes, colors, etc.)? Because I find that it's a bit strange to make it look like the actual thing (design) without finishing all the other forms' layout/arrangement. Not sure if I'm making sense. Plus, what I imagine is having a main form that has links to all the other forms.

Anyway, here's my progress so far. View attachment X v4.1.accdb I've only really edited the layout of f_Employee, and a little bit of f_DSPN. I find that the form doesn't fit my screen unless I set the font sizes smaller. I also cannot decide if I should make the forms full screen, or just make them small, and put them in the center. Which do you think is better?

Please let me know what you think about the forms. I seriously need more opinions.

 

[GinaWhipp]

I sometimes take a week (or more) to get a Form to look the way I want, often going back to it to tweak it. Yes, I did mean make it look the way you want it to look... one at a time. I have databases with 50 plus Forms, can you imagine what that would be if I waited till I finished them all to go back and *make them ALL look pretty*?

I am about to go into a meeting with a Client... When I get out (and no, have no idea how long it's going to last) I will review your progress.

 

[GinaWhipp]

I used the qryEmployees in your Immediate Supervisor Combo Box so you could see how it's used. Other than that looks fine.

 

[johannaellamay]

I sometimes take a week (or more) to get a Form to look the way I want, often going back to it to tweak it. Yes, I did mean make it look the way you want it to look... one at a time. I have databases with 50 plus Forms, can you imagine what that would be if I waited till I finished them all to go back and *make them ALL look pretty*?

I am about to go into a meeting with a Client... When I get out (and no, have no idea how long it's going to last) I will review your progress.

Okay, I am beginning to understand how to use queries. But I'm not sure if I fully understand it. I have seen your sample and will take a closer look, then I'll make some more forms.

You have no idea how grateful I am.

 

[johannaellamay]

Gina, I've noticed that most of your forms have a sort of "frame" like the fields are in an options group. I tried using that, but I'd have to put labels and Access automatically gives me radio buttons. How do I make just the frame? Just to visually separate a group of fields from another.

 

[GinaWhipp]

I think you mean the Rectangle control, it should be at the top on the Design tab while the Form is in Design Mode. Oh, it's between the List Box and the Check Box controls. If that's not it tell me which version of Access you are using (I forget) and tell me which Form of mine you saw it on.

You have no idea how grateful I am.

You're most welcome...beside this has almost become a mission for me! Once this database up and running, I'll feel like the proud parent!

 

[johannaellamay]

I think you mean the Rectangle control, it should be at the top on the Design tab while the Form is in Design Mode. Oh, it's between the List Box and the Check Box controls. If that's not it tell me which version of Access you are using (I forget) and tell me which Form of mine you saw it on.


You're most welcome...beside this has almost become a mission for me! Once this database up and running, I'll feel like the proud parent!

I found the rectangle one. But how do I put a sort of title/caption on the rectangle?

 

[GinaWhipp]

I use Labels to do that. I then color the Label the same color as the Form and use an etched border so it looks like the Label and the Rectangle are one.

 

[johannaellamay]

Hey, I know it's seems as if I'm jumping off from one thing to another, but I just have a growing concern for connectivity between HR, Admin, and Procurement.

For example, the database that I'm making consolidates most of the transactions made in HR, Proc., and Admin. How do I make sure that data is not redundant. Do I make separate databases for HR, Proc., and Admin? Or do I just continue with the one I'm making and include all the departments' transactions? What if HR needs to add new employees, or edit their info? Of course, it's not Admin's job to update the database. Or what if Procurement needs to change a few things on the PO, again, it's not under Admin's scope. I'm confused.

 

[johannaellamay]

I have so many questions. Haha.

Okay, so I am trying to finalize how my forms should look by doing an initial design in my first form (f_Employee). I want to add buttons to add record, delete record, save, etc. I already tried to do those and they worked. But I want to add a message box. I didn't want to have a message box that just has the "OK" button in it. I want to have options like yes/no/cancel. I was just wondering how I could make that in using macros. Or is it better to do so in VB?

When do I use macros, and when do I use VB?

 

[GinaWhipp]

Re Post 131...
That is why we took so much time making the Tables making sure only Primary Keys are in other Tables and nothing else was duplicated. The data is only stored in one table and can't be duplicated or redundant. Now, if you meant make sure it is not entered twice then you also need to provide a way for Users to look up information, such as Combo Boxes. So, on your Employees Form you would add a Combo Box to the top whereby Users could check if an Employee is already entered and if not then use the Not_In_List event to add the new Employee.

Re Post 132...
When you create you message box you can add different button based on your choice. Turn intellisense on and as you type and are in the section you should a drop down showing you your list of options. You can also add buttons by using the *+* sign. I don't use Macros but I'm sure there's something there.

 

[johannaellamay]

Re Post 131...
That is why we took so much time making the Tables making sure only Primary Keys are in other Tables and nothing else was duplicated. The data is only stored in one table and can't be duplicated or redundant. Now, if you meant make sure it is not entered twice then you also need to provide a way for Users to look up information, such as Combo Boxes. So, on your Employees Form you would add a Combo Box to the top whereby Users could check if an Employee is already entered and if not then use the Not_In_List event to add the new Employee.

Re Post 132...
When you create you message box you can add different button based on your choice. Turn intellisense on and as you type and are in the section you should a drop down showing you your list of options. You can also add buttons by using the *+* sign. I don't use Macros but I'm sure there's something there.

Re Post 131...
I'm not sure if that's what I meant. Haha. In my org, we have HR and Admin, where I am. I am the one controlling the inventory, right? HR takes care of employee info. Should there be a separate database for them and for Admin? Or should it be just one database. If it's just one, how does HR use the database, if I'm the one controlling it? Hmm. Not sure if I'm explaining it right.

Re Post 132...
How do I make the message box you mentioned? Where can I find the "intellisense"? Hmm. The message box should appear OnClick of the command button, if that makes sense.

Thank you!

 

[GinaWhipp]

Re Post 131...
Unless you want HR in there, you just need a way to add the Employee and mind you, you don't need all the information HR has right? So, just the basics will do, Name, Title. After all, you don't want HR maintaining two files that will only irritate them.

Re Post 132...
What version of Access? Hmm, what are you doing with the Message Box, are you asking them to confirm something?

 

[johannaellamay]

Re Post 131...
Unless you want HR in there, you just need a way to add the Employee and mind you, you don't need all the information HR has right? So, just the basics will do, Name, Title. After all, you don't want HR maintaining two files that will only irritate them.

Re Post 132...
What version of Access? Hmm, what are you doing with the Message Box, are you asking them to confirm something?

Re Post 131...
Oooh. So HR will have a separate database? Then I will be the one to input new data in my database, everytime there's a new staff?

Re Post 132...
Access 2010. So in f_Employee, I want a command button "Save Record" and every time it is clicked, I want a message box to appear. It should ask something like "Are you sure you want to add a new Record?" Then there should be two or three choices: Yes, No, Cancel, or something. I already know how to add the command button but when I run and click it, it saves the record, but doesn't give me a message box. And if I put message box in Macro, it only gives me an "OK" button, nothing else.

 

[GinaWhipp]

Post 131...
Are you saying HR doesn't have some sort of database they use to track Employees? And why would you need more than basic information? Access is NOT the place to keep personal information that goes against every privacy issue out there.

Post 132...
As I said before I don't use Macros so I can't speak to what is provided there BUT have you clicked the *Show All Actions* button?

 

[johannaellamay]

Post 131...
Are you saying HR doesn't have some sort of database they use to track Employees? And why would you need more than basic information? Access is NOT the place to keep personal information that goes against every privacy issue out there.

Post 132...
As I said before I don't use Macros so I can't speak to what is provided there BUT have you clicked the *Show All Actions* button?

Post 131...
They have a tracker, they use Excel. Later on, I might also make a database for them. Anyway, I'll just settle with the information that I'm gonna need for MY database.

Post 132...
I have, it only has "Message Box," and like I've said, it doesn't give me ways to add more option buttons. Anyway, if you were to make something like that, what do you use? Visual Basic? Or what?

 

[Galaxiom]

138 posts on a simple subject? Are you two sure you shouldn't be on a dating site?

 

[vbaInet]

138 posts on a simple subject? Are you two sure you shouldn't be on a dating site?

They're finalising the marriage papers.

Actually, I've been sort of following the thread, lots of other questions have been asked/answered so ignore the subject.

 

[GinaWhipp]

You guys are too funny!

vbaInet is correct, this has gone wayyyy beyond the Subject and the Category as we have moved on to Forms now.