Search results

  1. A

    Screen shots

    Hi, I am trying to capture some of my forms for the user guide to my database, when using the screen capture it captures the whole screen where as I just want to capture the form in use. I'm not sure if there is anyway round this, I'm using XP pro and access 2000. I could go into paint and...
  2. A

    Stop showing (AutoNumber) in field

    Hi, I have a table with the ID calculated by an autonumber, I have a query to return a few records and I just wondered if anyone knew how to stop showing the blank record with just the ID field showing (AutoNumber)? cheers Andy
  3. A

    Filtering Subforms

    Hi, I have a form with a combo box (CmbTeamSelector) of ID's of teams which is used to filter the from with the ID selected using the code below: DoCmd.ApplyFilter , "TeamID = " & CmbTeamSelector I want to use this form as a sub form, but when i try this filter i get the error: The action...
  4. A

    relationships causing locked cells

    Hi, I have a table [Bowler Details] and an attached form and also a table [Bowler Scoresheet]. The attached form for the bowler scoresheet takes all the [Bowler Scoresheet] fields and then a couple of the [Bowler Details] fields. It displays the details fine, but it doesn't let me input data...
  5. A

    referencing OLE

    Hi, I have an Excel worksheet as an object on one of my forms, I want to know how I can reference a single cell from within VB, as I will needed to read ad write values from this worksheet. Any help would be much appreciated cheers Andy
  6. A

    Changing tab sizes

    Hi, I would like to change the size of the tabs on my form so they are all the same and not just the size of the text inside, I can't find a property to do this as the width is the size of the form displayed by each tab rather than the caption part, which I want to be constant through out all...
  7. A

    DAO error

    Hi, I am trying to use code to create a new record in a table, I have found code in a book and online help which looks as if it would work. But I get an error at the first line: Dim dbs as Database, rst as DAO.RecordSet it doesn't recognise 'Database' and just says: User-defined type not...
  8. A

    using tabs to show records

    Is there anyway of using tabs to show an individual record, i'm making a bowling system and just want to have 8 tabs to represent the record for each of the 8 teams that will be in the league. Each team has a unique Id that can identify the team. Or is there a way of simply saying [Form Field]...
  9. A

    dislpaying result in a form

    I'm having trouble displaying a single record in a form, i have a query which returns the correct data (ie. the required record) but this is in a datasheet format, is there any way to display this in a form or translating this querie to open the form showing the record here is the SQL query...
  10. A

    display a record in a form

    All i want to know is given the ID (primary key) of a record within a table, how can i display this (and only this) record on the associated form. Sure it is simple but i'm stuck and getting no where cheers Andy Swinburne
  11. A

    showing a specific record on a form

    I need to be able view a view a particular record, i have created a query that displays the record in the table correctly, but i want to beable to display this result in the form. This is the SQL for the query if this helps SELECT Bowlers.[Bowler ID], Bowlers.[First Name(s)], Bowlers.Surname...
Back
Top Bottom