Search results

Yes, thank you. I'me still trying to figure out how this works. I tried to use TempVar but Access just tells me: "Invalide Outside Procedure." I don't even know what that means so right now, I'm stuck.

Thanks! I tried to do this and it worked. :) But I have to keep the form hidden or invisible right? I will try TempVars just because I don't want to have to keep the form open all the time. But if I can't make it work, then I'll go back to this procedure. ;)

Hmm. I've set the form to: Me.Visible = False Is that what you are talking about? This is what my code looks like under f_Login Private Sub cmdLogin_Click() 'Check that User is selected If IsNull(Me.cboUserName) Then MsgBox "Please select a User Name.", vbCritical, "Select a User Name"...

Hi thank you for the response. However, as I've said in my first post, I don't want to use the username in Windows. I want to use the username in my login form which is also in access. :) Do you think it's possible? :(

I have a database for HR. It's almost finished. I've already created a login form. I want to create an audit trail. I've already researched about it and I think I could do those. However, they're not exactly what I was looking for. I want my audit trail table to be connected to my login form...

Okay got it! Thank you! :D

thank you!

Hi, I already linked the fields. But I don't want ecdEmployeeID to be seen. How do I set its visibility? And is it possible to make the font sizes smaller in datasheet view?

I'm making a database for HR. I have an entire form of all the fields from one table. But I made another table for credentials because one employee could have more than one. Now, the form: I want to display the credentials fields on one of the tabs. I want it to look like a datasheet...

Okay now I have another problem. So I already know how to copy the data. But how do I reverse it? For example the user made a mistake and wants to just delete permanent address. So he/she could unclick the checkbox to do that. But how do I write the code? :confused:

Oh my gosh a million thanks! That was so simple it's embarrassing. Hahaha! Again, thank you. ;)

Hi! I have a table and form for employees. I have two address, one is current, and the other one is permanent. On my form, I want to have a checkbox that says "Current address is the same as permanent address." By clicking that, I want to copy the data on the current address field to the...

Hi jdraw, you've talked previously about saving history? Do you maybe have a sample model for that? I really could not imagine how I would be able to store the field's history.

Oh, it's: I just copied the one you had, and it works. Just for confirmation, so what you used for the Immediate Supervisor field is a combo box, and not a lookup from a query?

Gina, I have one important question. I thought I understood it but apparently not. So I tried to make just a sample t_Employee with Immediate supervisor because I want to create a lookup. I tried to make a q_Employee (query) so I could use that as my lookup for eImmediateSupervisor. But...

Gina, I have one important question. I thought I understood it but apparently not. So I tried to make just a sample t_Employee with Immediate supervisor because I want to create a lookup. I tried to make a q_Employee (query) so I could use that as my lookup for eImmediateSupervisor. But...

2. & 5. Okay, I've fixed the labels. :) Thank you! 3. How do I do that? :confused: 4. Haha. I know, but for uniformity purposes, I'll just label it that because that's what we use at Finance and HR. :)

1. Ohhh I'm sorry. Hahaha. It's supposed to be "New Record" but I change that labels for every form. I just forgot to change it to "New DSPN" or "New Supplier". Thank you! 2. Really? I cannot seem to find what's missing. -_- 3. Hmm. Seems that you're right. But I don't understand. In my...

Hey! This is what I have so far. I don't really think that I'll have more than fifteen forms. So I'm just going to leave the colors as is until I decide what color scheme to apply. So, what do you think should I do next? Do I make the forms for the other tables now? :)

I have a few questions. I am making a form for t_Department. I want it to be a combination of the form and a table showing the employees under a certain department. Do you think it's better to do it that way? Or should I just make a for only for department, then make a query for the employees...