Search results

Hello people. Can someone tell me how I show the source of the data in a query without adding another field in the table.? I want to pick up expiry dates from a number of tables in a series of expiry queries. E.G from plant register - expiry of registrations etc from training register -...

My database is installed in a server environment. Back end and Front end. When I log into the server and open my front end, I have full control. Yet, one of the users, on his server profile, all he can do is read. He cannot enter data. I have installed and reinstalled the front end, yet...

Hello I have a front end and back end on a terminal server. The front end was opened the other day by an administrator (direct from its location on the terminal server). He found he couldn't log in. The issue was that all the VB coding was gone. This has happened twice now. There was a...

I have a list box returning values from a query. The query is based on my table called: tblinductionexpiry. The table captures induction dates of Contractor Employees. The PK is; Induction_ID. Contname_ID ...fk and ContEmplName_ID fk. Obviously contname_ID shows up evertime one of their...

Hi I have researched the internet and am able to send an appointment to Outlook for re-scheduling expired training. I have used the following code. Private Sub Reminder_Click() Dim Outlookapp As Outlook.Application Dim OutlookAppointment As Outlook.AppointmentItem Set Outlookapp =...

I have a data base to manage members of a boat club. I have a fees table - just used for String. The fees table only has FeesID, Fee. $72.50, $36.25 $145.00 Members pay fees depending on their category. So, my members table: MemberID - Autonumber Name - Shorttext CardCode# - number...

Hi Am hoping you can help. I have a database that is a health and safety application. In it I can record training (with expiry), plant maint (with expiry) and a variety of other things for which expiry date is important. I have a table called.....tblexpiry. My plan is to run append queries...

I have a database that I have developed for the management of health and safety on an industrial site. It is split. I have developed a log in screen to keep unwanted people out. There is also a reminder's table that serves three tables - Contractors, Accidents and Employees. You will see...

Database help needed. Ok. Putting it out there. I need some help. I've googled till I'm blue in the face - literally. I have a sub form within a sub form and I need to reference a combo box on the sub form. Access only seems to write to the first sub form level. Here's my syntax...

Hello I am building a hazard management data base for health and safety. I'm not sure If I'm using my junction table correctly. The tables are for Job Safety Analysis to assign risk,harm and control. Here are my tables. I've attached the DB also. (table) JSA_ID PK JSAtask (table)...

Hi I've given you a copy of my Database. If you look at relationships you'll see the main tables Hazard class. Join. Specific hazname. Control data. Control is a sub sheet of specific. One to many relationship from Spec to Join and From Haz Class to Join. Join contains other data like...

I have a tabbed form. It has 6 Tabs. It is based on my employee's table. Each tab captures various bits of info on the employee. If you move through the controls on each tab (Name, middle name, first name) using the Tab Key (as in doing data entry), it defaults to new record rather...

My report produces multiple copies of the same record. I know why, but don't know how to fix it. I'll explain from scratch. EmployeeTable. With a one to many relationship with TrainingTable (via employee PK as FK in trainingtable). Training table has a one to many relationship with a...

Can someone please have a look at my table structure and tell me if I'm on the right track. I have 4 tables. Each table has a relationship (one to many) to the next, cascading downwards if you like. Part Section Sub Section Sub Sub Section I think I've got FK right. I.E Section has...

I'm not quite sure where to post this question. I have a table that records: Department Tasks Procedures for each task Associated Tooling (this is a lookup) Associated hazards I want to be able to Assign tasks to employee, pick out that task and print the related proceddures...

My report (query based) produces several copies. A couple of the fields the query looks up are multiple value fields (look up fields too). So, the more values you chose in that field, the more copies of the report is produced. How can I stop this from happening??

I have a query built on a table (really!). No seriously, Project Tracking is the query on which the report is built. I want to have the report based on project name. So, I have the field - Project. And, the parameter is [Enter Project Name]. It won't return any results. Yet, if I...

My form, which is linked to my employee's table wont show all the records. I know this is a basic thing. I've checked that it's not set to data entry in properties. I don't know what else to do. the record source maybe? However, It was a tabbed form (cause it contains quite a lot of...

I have used Access to build our Health and Safety system data base. (I'm reasonably new to access BTW. All my data is in tables. All my reports are based on queries. I have three forms. Accident Register (linked to a table), Investigation Register (also with it's own table) and Hazard...

Hi everyone. I'm the HSE & HR Manager of an engineering company. I've built a data base with tables, forms and a modal dialogue as a switch. All works swimmingly. I've made tables for: Job Tasks, which includes corresponding codes Employees/Positions Training I want to generate...