Search results

Dave (aka Gemma), Thanks very much. I will have a play with this late on tonight and see what I can do with it. Uncle, Thanks you for you comments on the naming conventions.

Hi, I hope someone can point me in the right direction. I have a Access 2003 DB in it I have a table (tbl_Coredata) in the table are the fields Season, Date, Home, Away, HG, AG, (plus some others.) I want to have a form created that has a combo box on it. When the person chooses a value...

Thanks. It's a bit complicated for me at the moment. I think I will give a miss for a little while. Thanks anyway. :)

I have never used those so how would I do that? Sorry to be dumb :(

Snagov. Home to the resting place of Prince Vlad in Romania. Bet I'd get some pukka pictures here.

Hi, If this is in the wrong section, sorry and please fee free to move it. I have a vbscript that creates a html output from a table in access 2003. What I would like to know is how to execute that vbscript from a button? OR Is there a better way i.e. copy the script in to a...

now I have done this and got this (see images)

The SQL from the above gave me this: SELECT tbl_Matches.Opposition FROM tbl_Matches GROUP BY tbl_Matches.Opposition, tbl_Matches.R HAVING (((tbl_Matches.R)="W"));

I did sadly it didn't work. I seem to be missing something somewhere. in the query builder I have Field: R Table: tbl_Matches Total: Count Criteia: "W" this returns: data type mismatch in Criteria expression :(

Thanks. I have also the following problem similar.: tbl_Matches qry_OppoPerf The query looked at the tbl_Matches I want it to look at the table and where the team name is count the number of W in the column "R". I used this SQL: SELECT COUNT(*) AS [R] FROM tbl_Matches WHERE R = "W" in the...

Thanks I will try that now. EDIT: Thanks it worked ... :)

I have attached a screen dump of my problem. I am trying to count the number of cards in a game in a query. The check boxes are ticked when a card is issued, but when I run the query (on the right) it shows a minus figure .... How come. Please can someone advise me what's wrong. Using...

Ok never done one of these before but I have made one now and I am running it. Edit: The result of the query has kept all the rows but added #Deleted in to every record/cell. I was hoping it would delete ALL the rows. Sadly the names will differ depending on when the reports are run from the...

Hoping someone can help me out here. I have searched a bit and I have some answers but I need a little clarity if possible. I have a Access 2003 DB and in it I have a table called tbl_NFM In the same directory on our network I will bve having various csv files that I wish to import in to...

Pukka ..... So simple Thanks ... :) Worked a treat :)

Hi, I have a form for searching a table. On the form is a combobox (cboSearchStation) that is populated with all the station names in the table. What I need it that when a user selects a staion name it populates all the other controls on the form. (See image). I have tried a few serches...

Problem solved. I exported to Excel. Did a Vlookup. then imported as a new table and deleted the other ones out. Thanks anyways. :)

I have tried googling and I found this. http://www.ehow.com/how_2019835_update-query-access.html It didn't give me the results I wanted. What am I doing wrong?

Hi all, I have Access 2003 and I have two tables in it. I need to import/copy over selected data from one table (Station Data) to the other (tbl_Stations). You can see from the attached image the tables the fields I wish to import into table tbl_Stations. 3-Alpha, TIPLOC1 thru 4 Easting...

I keep getting this error Macrosoft Office Access can't find the macro 'Call CalcDiff().' The Macro (or it's macro group) doesn't exist, or the macro is new but hasn't been saved ....... What's that mean ?