Search results

Hi! I have two tables for Employees and Properties of the company. Each property is assigned to a particular employee. Here are the details: Employees Table Last Name First Name Department Position Supervisor Date Hired Location Properties Table Property number Item description Assigned...

Hi! I have a Main form and a Login form. When the user opens the database, the Login form opens. Text boxes for username and password are unbound and connected to a table that stores authorized usernames and passwords. When the username and password are correct, the Login form is set to Visible...

Hi! I have a table composed of more than 20 fields. Each field I put captions. When I run the table, the captions work well and appear as I like. For example, the field name is LastName and the caption is Last Name. The problem is, when I make a form and set it to datasheet view, the caption...

Hi! I have a problem with my code. I'm trying to sort and filter a continuous form. Sort ascending and filters works perfectly fine. But my descending button doesn't work. I basically have a combo box which contains a field list. Then two buttons (asc. and desc.), then a text box for filter, a...

Hi! I'm trying to sort and filter a continuous form. I want to sort by descending and ascending, but I also want to have a combo box for filtering. For example, there a combo box for sorting with Value List as the RowSourceType, the list would be "Ascending" and "Descending", and there should be...

I am almost finished making a database for our HR department. I just have a problem with reports. Here's my sample database: http://www.access-programmers.co.uk/forums/showthread.php?p=1410980#post1410980 Please ignore the rest of the posts. My problem is this: I have created audit tables, If...

Hi! I have a continuous form based on a query for employees information. I already created a sort button with the following snippet for its macro: I did that instead of choosing "Field List" and choosing the query for its data because I couldn't quite figure out how to replace my actual field...

Hi! I'm trying to construct a database that can keep historical data on employee details like previous departments, job position, etc. Sort of like an audit trail, but I want users to also see the data in a report or something. I've researched about this and even made a prototype using macros...

Hello, I'm a real newbee so please be forgiving. This will be a long post because I want to explain the details. This is the situation that I'm stuck with: I have the following tables 1. t_Employee. It consists of the following fields: EmployeeID Name Job Title Contract Start Date Contract...

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

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

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

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

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

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

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

I'm not sure if the title is very appropriate or direct to the point. But here's what I'm working on. In our organization, when employees need to ask for office supplies, they have to fill out a Supplies Request Form (SR). Then Procurement team makes a Purchase Order Form (PO) based on the SR...

Hi, I'm making a new database and I want to assign Item Codes to my inventory. For example: ItemCode (Primary Key) | Item | ItemDescription I want to generate an automated item code containing the first letter of the Item (as prefix) followed by numbers. Example: ItemCode: P001 Item: Paper...