Search results

1. Yeah. I'm quite happy with Macros for now. 2. How exactly do you do that? :)

1. I see. All Macros can be converted to VBA right? Do you suggest that I just convert or just stick with Macros? 2. Yes, I guess. I just didn't understand what you said. Hmm. I honestly am satisfied with my t_AuditTrail. I just need a button in f_EmployeeMultiple where I can generate a report...

1. If you don't use macros, how do you do it then? :) 2. If I do this, then I will see all the employee details even the ones that did not change? You mentioned RecordID and not FieldID? I'm sorry. I really couldn't get grasp of this. I truly am confused. 3. What is a "Design Master"? Oh...

Did you see t_AuditTrail? Is that what you meant with a Log Table? I created a sort of Log Table table and added and After Update Data Macro for the fields that I want to store historical data. Hmm. If I'm only to use one log table, then I don't think I would need this part anymore. I just...

Hi. I think there was a bit of a misunderstanding. :) I just decided to make things simple and just settle with the normal autonumbers, without prefix. I guess I should have marked this thread as solved. :) Thank you for your tip. I will actually still try it. :D

User Name: johanna PW: johanna Main form is f_HRMSCommonUser It's almost finished. But I wanted to add like tables where I can store history of (for example) employee contract dates, previous department, or previous supervisor. I looked for ways on the net and settled with Append Queries hence...

Sorry. Should have explained better. Hmm. So I changed the "echEmployeeCategory" control into a combo box like you said. I also copied the rowsource but changed the names of course. I basically did everything from your instructions. The result: No changes. No error message whatsoever. :(

Hi. I tried it. It didn't work. :( :confused:

Hmm. I see. However, is it not possible to not create a new query for that? Is there another way? I don't want to create a lot of objects considering that I only have three fields to append. :)

Hi. I have the following tables w/ the following fields: 1. Employee Category EmployeeCategoryID | EmployeeCategory 2. Employee EmployeeID | Name | EmployeeCategoryID 3. Employee Category History (generated from Append Query to record history of employee categories) EmployeeID | Name |...

Wew nevermind. I was able to solve it. I just tried to change the data types. It worked!

Hey GinaWhipp, I know I'm kind of stalking you right now. Haha. I just really need your help. So I kind of put the inventory database on hold because I had to make a database for HR. It's almost finished, ALMOST. Could you maybe take a look at it and let me know what you think? I'm also stuck at...

I did what you said. I used that code for "echEmployeeID" control in my report using: ="[eEmployeeID]=" & [eEmployeeID] But it just tells me:

I have already made this work a lot of times but for some reason, there seems to be a problem in one of my buttons. So I have a command button that opens a report. In one of my reports, this macro works: ="[eEmployeeID]=" & [eEmployeeID] However, in another command button that should open...

Okay, so I tried using the switchboard manager but realized it's not what I want. It's like this, I have different kinds of forms and user interfaces per Access Level. For example, if I login as a developer, I should be able to see Form1. If I login as Officer, I could see Form2, etc. How do I...

Thanks. I will try to use the switchboard manager. I've never really heard of it until now. Do you have or know of any samples out there that has different user levels? Could you share a link so I could study it?

I really could not find any answers in this forum. If there was, they were either really hard to understand or just not what I was looking for. I can't really provide any more info, because the first post basically summarizes, and simplifies my situation.

Thanks anyway.

Hmm. Not sure what you meant by domain. But I have a separate table that contains User Name, Password, and Access Level fields. I also have a log-in form that only asks a user for his/her username and password.

I have a database for our HR team. I also have different access levels: 1. Developer 2. Head 3. Officer 4. Assistant I've already created a form with navigation buttons. But I want to restrict or add a few tabs/subforms per access level. And if I log-in as the developer, I want to be able to...