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

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

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

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

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