Search results

Thanks David Fortunately there are no multiple category questions. I have rectified this issue now by using an unbound text box [category] which is populted when you click the command button - the query can then refer to this field Thanks

I currenly have a database handling responses to staff tests. To keep the number of forms down I want to use only one form containing a subform running from a query 'qryQuestionForm' but I have seven categories of questions. The query look to the previous form for [StaffID] and [CheckPeriod]...

Many thanks for all your help - I'm going to get to grips with the project now. I think I have got to grips with working with normallity!!

I do appreciate your help on this one. Also this database hold questions that check staff skill levels each month so every month each staff member of staff is tested on all 70 questions. Should I append a record for each question for each member of staff to the responses table at the...

Any luck with an example as yet?

Many thanks for your help on this one I have attached 5 sample questions from one category and all with Yes/No answers

Is it easy enough to make a form with say 10 questions on it using this table method How do you link each question to the form whilst sending the reponses elsewhere?

On the subject of normalising: This database will have is storing the answers to questions from a set group of staff. There are around 70 questions over 7 subject areas - am I better off having a table per question or per subject with 10 question fields in each Thanks for your help

Quick update - tuned out to be one PC that had the Jet problem all sorted now Many Thanks

I have a databse containing frmCH. On this there are 13 fields which are [Q1] to [Q12] and [Status] When the form is closed each time I want some code that changes the [Status] to "Complete" if all other fields are anything other than Null If any still contains Null then [Status] = "In...

I have tried removing references from my Access but it still works, can't access the other users machine for a day or so

Thanks Alisa Now you've mentioned that I remember having to activate Automation and Outlook object once before, that might be it

How do I check references I only have Access 2000 at home, on 2003 do you reach references by right clicking on the report?

Could it be something to do with moving the databse to a new drive even though there are no linked tables. Interestingly I have tried the database today on my home computer and I don't get the problem

My apologies we are still languishing in Office 2003 All users can view the snapshot attachment they just don't seem to be able to send them Also the error does name an object that can't be found only "

The dbase hasn't been split at the moment. The other users should have the ability to send Snapshots, I don't have the software to send pdf files I don't get this error only other users, not sure whats generating it??

Currently using a database created on a personal drive M: at work. I use to fill out a form which in turn generates a report sent out via SendObject. Code as follows: Private Sub Command46_Click() If Me.Dirty Then Me.Dirty = False Me.Status = "New - Awaiting Area Ref" DoCmd.SendObject...

I currently have a report that is emailed with SendObject code. Sometimes our IT guys play with the network printers and they disappear for a while - at this point when I try to send the report the error No default Printer appears - is there a way to remove this error so the report sends even...

Many thanks for that - didn't realise it would be that simple! Thanks again

Hi I currently have a form that when completed is emailed by clicking a button with VBA code. At the moment all details required are on the form and therefore the email does not appear for editing. In some instance staff may need to add attachments, is it possible to have a YES/NO type field...