Search results

Hmm. Okay, then I'll move on to making my other forms. :) Thank you!

Okay, noted. Thank you so much! I have posted my update. If you're not too busy, could maybe take a look at the code and let me know if it made sense. Lol.

Okay, here's what I have so far. I've followed your advise with the codes. I tried to study the On Error ones and understood how it works. ;) I just hope I used them correctly. As for the other command buttons, I just used Macros because the commands I wanted them to execute were basic and it...

I could already use the code, it works wonderfully. But I don't want to keep using it without understanding it fully. :(

:( I'm sorry. I really cannot understand the structure of the code. I only understood: Dim intResp As Integer intResp = MsgBox("Are you sure you want to add a new record?", vbYesNo + vbQuestion, "Save Record?") If intResp = vbYes Then DoCmd.RunCommand acCmdRecordsGoToNew Else...

I can't understand why you set intResp and an integer. But anyway, I'll try to research more about it.

Okay, I want to digest the code you sent me...

I think I will just start learning VBA. Just one last set of questions. What if I later on, I want to convert my current desktop database to a web-based one (assuming I had already learned VBA), would it still work if I had VBA? Is there a way to convert VBA to a web-compatible code? Or should I...

Wow. Okay. Thank you so much for responding so positively. So I guess it's a consensus. Macros, as I have understood, are ready-made codes. They're easier but are less flexible. My next question now is this. When do I use a Web-based db, and a desktop database? What are the differences? Can you...

Oh, I also tried to make a message box form. So I just linked the command button to the form. Then assigned actions for the buttons on the message box. For me this method is a lot easier to manage. I got that trick from the templates.

Post 131... Okay, let's close the issue. HAHAHA. Post 132... Actually, I did it! With Marcos. I used If MsgBox("Is this really what you want to do?",4)=7. But I still don't know how to link the buttons to the actual actions. Anyway, if you have any other ways, please share! :D Something like...

I was just wondering, What are the main differences between VB and Macros? When do I use VB or Macros? Which one is easier to understand, and more flexible? Please help me understand better. I'm on the process of creating a database from scratch, and this is my first time ever. I've now moved...

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

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

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

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

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

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

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.

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