Recent content by ChunkyChats

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