Search results

Thanks Minty, I thought it might be something like that. I'll have a go. I'm guessing ill have to change the 'case' code to select the identifier in the single table?

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

CJ, many thanks for your reply I really appreciate. I had thought of going this way but wasn't sure whether a table for each group was the right way. There can be multiple selections for each category appropriate to the event so multi choice is the way to go.

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

Many Thanks Minty. Thanks for the advice re lookup tables. I read the article. I'm not quite sure what you mean by this statement 'I would change those to normal stored values with separate lookup tables' could you possibly explain a little more please? Steve

Hi, and many thanks for the response. I've attached the skeleton of the database for your perusal. If you look on the EREMasterData Form the combobox in question is called BEATCasualFactors. Based on the selection I would like a pop up to appear for the user to select an option from the...

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

That's great many thanks. I had the same problem with the unbound warning, not sure what I did there. When creating the frmsectionGenInfo1 form did you manually add the subform or use the create form button and it auto created the link in the tables? for future reference. Again many thanks...

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

Gents If I could kiss you I most certainly would. AWESOME!! thanks so much for the help. It's working brilliantly. Steve

Hi, I've been taking a look around the internet and have found this piece of code: Private Sub Image92_Click() Dim sBasePath As String Dim sBaseFileName As String sBasePath = "\\SPFS01\shared\QualityandSafety\QA Common\Quality (Q1)\Authorisations\ENGINEERING RECORDS\" sBaseFileName =...

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

Many Thanks for looking. The control 'Text74' was an example to show where I was pulling the link from, sorry. For info the link should open 'Documents' to a folder location that contains a repository of employee records held on a network drive. The Staff number Folderlink control also has the...

sorry had to put the spaces in the URL as I haven't posted enough yet to be able to place links u[p. Although the rate I'm asking questions that shouldn't be a problem soon!! Steve

Sneuberg, Appreciate the offer: I have uploaded an example to Drop Box. here h_ttps://w_w_w.dropbox.com/s/6ysjeyc2huan17c/LicenseDatabase1DraftEX1.zip?dl=0 You'll note On the frmEmployee_Input I have place a graphic of a file and alongside I added a text box linked to EmployeeFiles field in...

Sneuberg, Many thanks. I have the image up but the problem is my lack of knowledge on how to use on click event. I'm not very good at VBA yet (But Learning). I'm sure it's pretty simple? How do you link the onclick procedure to the url in the field? Steve

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.