Recent content by andyswinburne

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...

hi, just a note to anyone else who is having a similar problem. Changing the record set worked for the query but then when using the query as the source of a form i couldn't enter data. It worked just changing the 'Allow Aditions' property to False, then data can still be enter but no new...

thanks that did the trick, cheers dan

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

thanks very much, didn't realise what you meant first time, works fine. Cheers guys Andy

I have the form which filters the records using a combo box which works fine, I want to allow this form to be a subform, but when i do this the filtering no longer works, produces error mentioned above. I have tried changing the code to Me.Filter instead of the DoCmd which seemed to work...

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...

Hi, I cant post my db as it is too big. Could i email it to you directly? If you mail me with your address then i can send it to you normally without the size restriction. Sorry for the inconvience. cheers Andy

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...

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

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...

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...

cheers i'll try that, but i want to beable to create a specific number of records when the form loads. Then this would allow the user to select a team from 1 to 8 and then enter the details for a team. So what i need is to create 8 records and then have a combo box to beable to show each of the...

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]...

Problem solved, i just ran the query i created that displayed the correct field and then used the auto form to show this record. It doesn't open it in the form i wanted but it'll do the job and saves trying to use the filter which wasn't working. thanks anyway andy