Search results

What About...............? If there are no records already in your target table then what about creating a make table query based on your source table? This will enable you to create identical table formats. Neil

This Is What I Would Do.......... Complicated but... Import the data into a 2 field table...call it TBL_IMPORTS. The first field, named ID for example, should be a autonumber field. The second field, named say DATA, should be a text field set to the maximum 255 characters for safety. Create...

Can anyone help? I am developing a Microsoft Access 2003 application to generate a set of football fixtures to mirror as far as possible the requirements of the real english league season. I need it for now to simply generate the first 13 rounds of matches (for reasons I can explain later)...

I have a MS Access database with a report in it that prints to a printer shared with many other users. When other users send prints it seems to make it ignore the landscape setting I have set for the report and print portrait. Can I hard code a report to be landscape (even though this is set...

Database Recovery I have managed to recover the tables and the queries in my database I just have 5 modules that I can open now. Can the coding within be salvaged? Regards, NEIL

Is It Possible? IS IT POSSIBLE TO ADD A PIECE OF CODE SO THAT AT NO POINT IN THE SEQUENCE IS THE DIFFERENCE BETWEEN A TEAMS NUMBER OF HOME GAMES AND NUMBER OF AWAY GAMES EXCEEDING 1? Neil

Sorry! Just thought it might help anyone who was trawling through! Did ya understand how I explained it? Neil

Try This Methodolgy ... I think the easiest method for 20 teams is..... 20 teams will create 19 rounds of matches or 38 if they play each other twice. Split the teams into 2 groups of ten teams each. For the first 10 rounds of matches group1 teams play group 2 teams and thus you can alternate...

If Your Interested...... I think the easiest method for 20 teams is..... 20 teams will create 19 rounds of matches or 38 if they play each other twice. Split the teams into 2 groups of ten teams each. For the first 10 rounds of matches group1 teams play group 2 teams and thus you can...

Try This..... If you provide me with the version of MS Access and the format of your tournament (ie 4 groups of founr top 2 forward to knock out stage???) I could knock something together for you as I have done something similar in Access to simulate the English Football League Season. IN MS...

I Posted This Somewhere Else But Does It Help? If you provide me with the version of MS Access and the format of your tournament (ie 4 groups of founr top 2 forward to knock out stage???) I could knock something together for you as I have done something similar in Access to simulate the English...

I'd Love To Do This! If you provide me with the version of MS Access and the format of your tournament (ie 4 groups of founr top 2 forward to knock out stage???) I could knock something together for you as I have done something similar in Access to simulate the English Football League Season...

Correction!!! Sorry, the 8's should not be in quote marks!! ie <> 8 not <> "8" Neil

Try This! FOR ACCESS 2000 TRY THIS......... DIM MYNUM AS LONG DIM GOUP AS LONG DIM GODOWN AS LONG IF RIGHT(FORMS![name of your form]![name of your field],1) = "8" THEN EXIT FUNCTION END IF MYNUM = FORMS![name of your form]![name of your field] GOUP = 0 GODOWN = 0 DO WHILE RIGHT(MYNUM,1) <>...

One Thing To Remember!!!!! If ya dont want a warning to appear that this will alter your data blah blah blah...then insert: docmd.setwarnings false before you call the query! Regards, DALIEN51

This Is One For A Query! He is dead right this is one for a query on the table not code on the form! isnull on the criteria line as suggested is the way forward! good luck DALIEN51

Ms Access In Read Only State Someone has exited your database abnormally, that is to say probably there computer has hung while within it. Ensure all computers that open that database have been re-booted and then compact and repair your database. Restart the machine you compacted and repaired...