Search results

Dear Forum, I'm currently updating one of my Access 2000 applications for a local Charity, one of the major issues with the current one is that it uses standard forms built using the Access forms wizard and then amended to suit, this has caused some problems because the users keep leaving the...

Dear Ingrid, I know that Access 97 supports other ActiveX controls like TreeView, so it may also support ListView. Check the toolbox in Form Design mode and click on more controls for a full list, my system (Access 2000) lists it as Microsoft ListView Control. Also there are lots of examples...

Dear Ingrid, If you are using Access 2000, you could try and use the ListView Control instead, this gives you the sort of functions you are looking for. I used one recently to display messages to the user on a form and these message can be any definable colour, the Control was called...

Hi, I'm trying to open a Crosstab query as an ADO Recordset and keep getting Invalid SQL statement expected DELETE, INSERT, PROCEDURE, SELECT or UPDATE. I have opened lots of Queries before, this is the 1st Xtab. Can anyone help? My Code follows: Dim rstMthDest As ADODB.Recordset Set cnn =...

Fully Working Version Chris/Smed, Here is a working version, I still need to create the forms, and add some additional rules (breaks during the season for Holidays, Split league between Bruce and Wallace, etc.) but the hard part is done (Thanks again Smed). This will save so much time at the...

Smed, Brilliant. A very clever and very simple solution. Once again this board has triumphed. Cheers Shaun:cool:

Sorry A fixture in the UK is the same as a Schedule/Roster in the States i.e. a List of the matches to be played between a group of teams over a period of time. Regards Shaun

Homer, Another metjod I have used is to create a table (usually for parameters) with a single key field (Text) and only allow the text "KEY", then create fields for any other variables/constants, etc. you need (like version) You can access the record using Key = "KEY" and read the version...

If you select the WeekNo or Date field and sort it the output looks like this: WeekNo Fixture Date HomeTeam AwayTeam 1 31-Aug-02 Team D Team A 1 31-Aug-02 Team C Team A 1 31-Aug-02 Team B Team A 1 31-Aug-02 Team A Team B 2 07-Sep-02 Team D Team B 2 07-Sep-02 Team C Team B 2 07-Sep-02 Team B...

Chris, Many thanks for the Db, I'm not quite sure how it works? do I have to enter all the fixtures in manually? Here is where I have got to so far, my issue is that there are 18-20 teams per league and 4 leagues (some 80 teams), the teams normally only play each other once as there is not...

I'm trying to create a Db to create fixtures for my local Soccer sevens Association. I have created a table with a list of teams (usually between 18-22 teams) and a table with: WeekNo, Date, HomeTeam, AwayTeam My problem is not coding or Db creation but the method fro creating Fixtures I...

DAK, Looks like I have solved it, my code looks like: StartDate = DepartDate EndDate = .Fields("StartDate") iWeek = 0 Do While StartDate <= EndDate...

Thanks for the reply DAK, I have two tables; Resident, which contains a residents details, including their startdate and departdate, also FlatID which has a relationship with the Flats (apartment) table which contains Flat address, phone, etc. The query (FlatHist) Uses the Flat table and...

Friends, you have always managed to help before. The problem: I'm trying to calculate the Occupancy rate for a Flat, people move in and out of a flat (of which there are 8) during the year and I need to work out the time (in wks) between moves (when Flat is unoccupied), I have a query by Flat...

AlanS, Thanks, you were right, once I'd looked at why I was using the two tables, I realised that I didn't need them and combined all the fields into one table. This has made my life (and the app) much easier. Cheers

I have just been through this same problem (I think). I'm assuming that you have a blank form and have inserted a Tab Control onto the blank form (if not start that way). To add feilds to the blank Tab, select the Tab you want to add fields to (by clicking on the Tab Tag (the tag at the top of...

There are two resident types OR and TS, therefore I have created a Table with base Resident data and another tblResDetail which holds the Resident Type details. The tables have a one to one relationship based on ID and Type and the Resident Table ID is set to Autonumber, Resdetail Primary key...