Search results

HI, I have created an assessment tool in Access and its working well. My only problem is that I created a cascading combo box based on tblField. The following code I borrowed from the internet which helps select a sub category based on the initial selection: Private Sub Combo7_AfterUpdate()...

Hi All, I've set up a few databases now and feel reasonably confident in their creation. however this project is a little more complex. I would like to set up a database for recording and analysing investigation data based on the attached MEDA document. I'm really not sure what the best...

Hi, I've created a form to categorise failure modes. In a combo box I have 5 1st order categories. based on the users selection I would like a pop up to appear to select the 2nd order mode which is stored in 5 separate tables. I will create forms for these as well. I am not that great at VBA so...

Hi Guys, I'm trying to create an investigation form template in Access which has multiple sections in order to classify both causal factors and contributory factors. For some reason I cannot get the primary key to auto-populate the foreign key in each of the sub sections. I've attached an...

Hi, Im afraid my VBA knowledge is poor, but I am progressing. I have a folder icon on a form which when a user clicks it should take them to the associated folder on our network. I've tried building an onclick event with little success. The network address is stored in a table (tblMaster_Data)...

Hi, I have a field of Links to employee files on our network. This field is stored with each employees FirstName, LastName.... On my form for Employee Input/amendment I would like to have an image of a file that users can simply click on to be taken to the file URL stored in the field...

Hi, I'm trying to import a list of employee details from Excel into Access. I seem to have hit a bit of a problem. I've cleaned the data and spent time optimising. However I have a 'list' created by 'data Validation' of locations where people are based in excel. Unfortunately this does not...

Hi, I'm very new to all this so please forgive me if this is well known. I have searched but don't seem to be able to find it. I have created an employee table which has fields for first and last names. Our company email address is a standard one based on First.Last(at)Companyname.com Is it...

Hi My Name is Steve, I'm an enthusiastic amateur trying to create some databases for my job. Looking forward to learning and meeting the peeps on this forum.