Search results

Hi Bob! Using very similar code to that, is it possible to have the user select a file, rather than specifically naming it in the code? Thanks :o)

Hi again! Back in the office now and picking up my messages. So the text boxes on the side of the parent are just there for the subforms to use and identify which questions to display? Like in a query, I would select 'section' and then have criteria set to '1' (for example) - this then shows...

I guess I wasn't quite as patient as you in trying to use them! So what do the hidden fields on the main part of the form do? And how do you make the form appear blank until an offender is chosen?

Hi again! I thought I had already tried this before, and when I was changing from one tab to another in the design view, the subforms were overlapping one another. So they were not showing different subforms for each tab. Maybe I was doing this wrong. I hope you don't mind the questions! It's...

Hi Simon Happy New Year! I've had a look at the form, and I can see the hidden controls. I still can't quite work out how you managed to split the subform up into tabs/sections....? :confused:

Apologies for the delay, I've not been in the office all week. This is amazing work Simon! I'm actually leaving on holiday tomorrow morning, but had a very quick peek at this just now - the form is brilliant! What was your secret to getting the subform show up in that way?

I just tried this idea of yours about using the append query to fill in the combined-key for the responses table (using ID from QUIPS and ID from Questions). This has now let me see all the questions for every offender! This means that for just three offenders, the responses table already has...

I'm in the same boat! I can picture the form in my mind and how it works, but it just seems to be beyond my reach at the moment :confused: When I ran a query to display all the questions, it works fine - just not on the form. I just noticed your other post about updating the table. Is that what...

Wow! Thanks!! :D I was starting to worry as in another similar post in this forum, someone said that it wouldn't be possible. The reference number I used is part of the information I pull through from Excel. I only use it to make sure that the entries are unique - it does not need to appear on...

Hi Bob I've realised that I'm trying to do the same thing in my database and struggling with what to do: http://www.access-programmers.co.uk/forums/showthread.php?t=203171 Is there no other way around this? I had my table designs checked by other people and they were happy that the design...

If I can get the questions to appear for each offender, then the plan is to split the questions up and divide them between tabs. Could you see what I'm trying to achieve?

Hi Simon I've just added a QUIPS Main page with a sub-form to give you an idea of what I'm after. In its current state, the subform does not link to the main page. If I choose to link the two, the questions all disappear - because they have not been completed yet. I want the form to look...

Hi Simon Thanks for looking at this for me. You're correct in thinking that people will also have the option of viewing completed assessments. I will set this up on another form, so I have one for data entry and one for reviewing completed assessments. The offender details will be imported...

Hi there I've been tasked with a work project to make a new survey database. The database will be used to complete surveys reviewing other peoples' work. The assessments are very basic and all of the questions have the same selection of answers to choose from. There are over 100 questions, and...

D'oh! ....well if you ever win the lotto....?!

Life saver!! Thank you so much Bob - once again you've saved me!! Next time you're in England, let me know because I owe you a few drinks! ;)

Almost there... In the database I've created, when opening the referral form, then adding a new 'Offender', then trying to add a new 'Referrer' - a message comes up saying that it can't find the Key ID of the 'Referrer' in the Referrer Table. The strange thing is that this message only comes...

In the database I've created, when opening the referral form, then adding a new 'Offender', then trying to add a new 'Referrer' - a message comes up saying that it can't find the Key ID of the 'Referrer' in the Referrer Table. The strange thing is that this message only comes up when I add a...

Perfect! Thanks Bob!! That worked a treat! :D :D :D

:( Hi Bob Thanks fo rputting me straight on that one. However, the information is still not being saved into the table from the form. The control source for Text42 is set to the correct field in the table. I tried putting in that line of code in the BeforeUpdate section of Text42, but that...