Recent content by KevW

Selecting required number It would not matter if it was the first 100 records or the last 100 records. Did suggest that the user would be better with a random sample but they are happy to have the first 100 records or whatever the amount they require. this amount thuogh will vary from each time...

I have been asked to design a query that when run will ask the user how many records they require to be selected and apended to a new table. The total number of records in the database that the query will be based on will vary, as will the total number of records required in the new table each...

I have a form that contains combo boxs that have been created by the person who built the database in Access 2000. The database owner has now decided that they no longer require the combo boxs as they require the user to input the data as opposed to selecting from a list. I have not designed...

I have been given the responsibility for a database that resides on a company network. The Database has been created by using Access 2000 in Windows XP. There are windows folders fro each team that needs use of the database and within these folders is a macro that loads the form for each team...

Thanks for that I can get the autonumbering working using Pat's solution and have now been given the task of implementing it.

DMax Function I now have this code below for the onload event of the registration form, Private Sub Form_Load() Me![WORK REFERENCE NUMBER] = Format(DMax("[Work Reference Number]", "[central]") + 1) End Sub The Work Reference Number should be the autonumber and central is the table name. (...

Not sure as to whether or not this query shoulsd go here or else where? But here is the problem. I have been asked to repair a database that has lost the autonumbering facility. Apparently this was caused by somebody leaving the database open when the network crashed. Each team can access the...

Thanks for your help, I never thought to check the size of the database and that was the problem it was reaching the 2 gb limit. Looks like it is back to the drawing board for a solution to the random sample.

I have now got my random sample nearly working, It creates a temporary table and creates a newfield RandomNumber, but when it comes to assign a randnumber it updates the first 350,000 and then crashes. When I run debug the line of code it stops as it is rst.Update and any records in the temp...

Using the built in function within access 2000 how can I do the following I have the following types of number in a table 84125 80245 I want to be able to trim the leading 8 of the first number but on secon number I need to trim the 80 off the number. I can quite easily trim off the 8 off...

I had a module that could create a random smaple fo an Access 97 database. Unfortunately I now have to to create a random sample in Access 2000 for a database that contains approx 2.5 million records I have tried amending the code to the following but am now getting an 424 error object required...

Further Question Thanks for your quick reply I have added to your reputaion as this was not something I had thought of. I obviously could not see the wood for the trees. Just to get this right though the Classed ID in the tblPostcode relates to the ClassID in the tblClassed. If this is the...

I have been asked to create a database in Access 2000 that will hold 1.6 million postcodes. There will be four fields within the a table one holding the postcodes, and three fields holding information as to whether or not the post code is classed as good, neutral or bad. The requirements are to...

I have written code that will select a random sample from a table by assigning a random number to the data in a temporary table. this is all working fine until I try and use the following piece of code to create a new table and appending the top 50 records from the temporary tabel to it. ' Sort...

I have written code that will select a random sample from a table by assigning a random number to the data in a temporary table. this is all working fine until I try and use the following piece of code to create a new table and appending the top 50 records from the temporary tabel to it. ' Sort...