Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shepshedlad
  • Order by date
  1. shepshedlad

    Max columns

    thanks Duane, if thats the case you are indeed a clever guy to knock up such a generic questionnaire. I will certainly take full advantage of your advice/skills. Rachel
  2. shepshedlad

    Max columns

    thanks guys for your input it is appreciated. I have been to your site and downloaded your Survey DB Duane and trying to work through it as we speak. I have to admit speaking as a first class novice the code looks complicated so will battle my way through it. Thanks all once again, regards Rachel
  3. shepshedlad

    Max columns

    Thanks guys for the info', I have downloaded the document regarding Rel' DB's and do understand the 'basics' of normalisation. I thought that given that there was a lack of duplicate data (as in there are many boolean choices etc and a few drop down choices etc) this would be indeed a flat file...
  4. shepshedlad

    Max columns

    Hi, I've been asked to do a questionnaire within Access. The thing is, the questionnaire is 150 questions and with little relationhsips going on. Is it feasible to do this in 1 table? or is this bad practice? Any advice greatly appreciated. Regards Rachel
  5. shepshedlad

    source data for combo box

    Thanks very much Bob for your help. Regards Rachel
  6. shepshedlad

    source data for combo box

    cheers Bob for that, I reckon I'll follow your advise about the towns. Ref' the counties tho' I did do a search but can't seem to get an appropriate list of counties to drop into Excell/Access; I'll have another scout around. Thanks once again, Regards Rachel
  7. shepshedlad

    source data for combo box

    Hi, I'm building a small DB that captures calls received from customers, which includes their details such as name/address etc etc. My question is as follows; is there a way of getting a complete list of towns/counties within the UK so that they be placed within combo boxes? It does seem a...
  8. shepshedlad

    yes/no check box

    thanks guys for the responses, I have gone with "option button group" as suggested; and it works a treat. Much appreciated Rachel
  9. shepshedlad

    yes/no check box

    Hi, Is there a way of using two check boxes so that there is one for yes and one for no, dependant on which is selected it is inputted into the same table field? Am I right in saying that the default is just one box in forms based on the selection within the table for yes/no? I tried using a...
  10. shepshedlad

    close button in report preview

    First of all thanks for the reply. I am beginning to think it is the differences of Acess versions that is the issue. On the users computer there is no selection for border style. I think the older version is very limited. But I cannot undestand why it fails to show a simple close button. If I...
  11. shepshedlad

    close button in report preview

    I'm confused! its a report that does not display the close button, and it is based on a query, unless I've mis-interpreted your answer? Also although I have control box=yes and close button=yes set on my PC. The computer that runs this report does not have these options available possibly due...
  12. shepshedlad

    close button in report preview

    Hi, The problem I have is that when my boss opens up a report in preview there is no close button visable even though it is visable on my machine. Is there something basic I am missing here? I have selected the close button to yes when constructing the report, I thought this would apply to all...
  13. shepshedlad

    send current record to print

    taking this one stage further how would the current record be sent as an email attachment in the form of a snapshot view? TIA Rachel
  14. shepshedlad

    send current record to print

    thanks guys for your help I'll have a look. TIA Rachel.
  15. shepshedlad

    send current record to print

    Hi I am trying to send a record that appear within a form to print. I navigate to a given record within my form to send to print but the option on offer via the activeX controls is only to print the actual form which is obviously no good. I have set up a report but just need to work out how to...
  16. shepshedlad

    DISTINCT SQL statement

    You are correct Harleyquinn (I am sorry for posting in 2 areas I wont do it again). And ref' the answers kindly received I'm trying hard to play around with the statements without asking very naive questions. So please forgive me ignorance. regards Rachel.
  17. shepshedlad

    DISTINCT SQL statement

    You are correct Harleyquinn (I am sorry for posting in 2 areas I wont do it again). And ref' the answers kindly received I'm trying hard to play around with the statements without asking very naive questions. So please forgive me ignorance. regards Rachel.
  18. shepshedlad

    DISTINCT SQL statement

    Cheers PHV for your help I appreciate it. regards Rachel
  19. shepshedlad

    DISTINCT SQL statement

    thanks very much Harleyquinn for your help I'll have a go now. regards Rachel
  20. shepshedlad

    DISTINCT SQL statement

    hhmm thanks for the reply, unfortunately they aren't always in alphabetical order Harleyquinn. Can the statement be easily doctered to work around this ? regards Rachel

Part and Inventory Search

Back
Top