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 Wanet Telecoms Ltd 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
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. shepshedlad

    DISTINCT SQL statement

    Hi I need to retrieve the first value from 2 columns that contain multiple values e.g Act Name 200113 ALLIED BAKERIES BRADFORD 200113 ALLIED BAKERIES STOCKPORT 200116 SPEEDIBAKE 200116 SPEEDIBAKE BRADFORD 200116 SPEEDIBAKE WAKEFIELD 200117 SPARKS BAKERY would give Act...
  7. shepshedlad

    DISTINCT SQL statement

    Hi I need to retrieve the first value from 2 columns that contain multiple values e.g Act Name 200113 ALLIED BAKERIES BRADFORD 200113 ALLIED BAKERIES STOCKPORT 200116 SPEEDIBAKE 200116 SPEEDIBAKE BRADFORD 200116 SPEEDIBAKE WAKEFIELD 200117 SPARKS BAKERY would give Act Name 200113 ALLIED...
  8. shepshedlad

    resizing Forms after opening a reports in Preview

    Hi Is there a way to stop a form altering size when a user click a button to open a report in Preview mode? Once they close the report (and they often accident use the close button top right corner which closes the whole Database!). The report closes and the original Form has been reduced from...
  9. shepshedlad

    password on button click

    Hi, Could anybody help with the issue of how to place a password on a button within a form. I have no security groups etc so no need to check to such detail. I just need to protect a form from a few users (the database only has 5 users) so thought a password on a button would do. Any help would...
  10. shepshedlad

    Combo-Box wizard "Find a record on my form based..."

    Hi I have an unbound Combo-box within my form that was set up using the wizard, selecting the "find a record on my form ....". Is it possible for this combo box to return distinct values. Example: the box looks at the customer field, returning multiple entries for each customer, is it possible...

Part and Inventory Search

Back
Top