Search results

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

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

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

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

I have the code that I have adapted to produce a random sample but which all work well until the following piece of code ' Sort the data by the random number and move top 50 into a new table strTableName = "tblRandom_" & Format(Date, "ddmmmyyyy") strSql = "SELECT TOP 50...

I have the code that I have adapted to produce a random sample but which all work well until the following piece of code ' Sort the data by the random number and move top 50 into a new table strTableName = "tblRandom_" & Format(Date, "ddmmmyyyy") strSql = "SELECT TOP 50...

I am trying to design a query that will bring back records where the date field in a table is older than 3 months than the current date. i.e 30/03/2006 is and older than 16/06/2006 Hope this explains it clearly enough

I am trying to design a query that will bring back records where the date field in a table is older than 3 months than the current date. i.e 30/03/2006 is and older than 16/06/2006 Hope this explains it clearly enough

I was advised the other night a create reports function that I could not get working required a Do While Loop. I found the code for a Do While Loop and have amended my code accordingly but I am still getting errors is there and error in this loop Private Sub Create_Reports() Dim rstcount As...

I am having problems getting the function to work correctly. What it should do is create reports for every manager who has staff members in the tbl_Testcheck. It should then open outlook and allow the user to email the report as an attachment, then it should move on to the next manager who has...

I have a table that i need to be able to store text that may be over 255 characters long. I have changed the fields datatype setting to memo as I thought this was able to show Up to 65,535 characters. But the data is still being trimmed to 255 characters. I have looked in Access help at data...

I am trying to get the folliwing DatePart query to work as I intended. testcheck_time: DatePart("h",[EDS_testchecks]![Query_Start_Date]) & ":" & DatePart("n",[EDS_testchecks]![Query_Start_Date]) & ":" & DatePart("s",[EDS_testchecks]![Query_Start_Date]) The above works well but what it is...

I am trying to import and Excel 2000 workbook into an Access database using the following code: Private Sub Import_EDS_testchecks () DoCmd.TransferSpreadsheet acImport,9,"EDS_testchecks","C:\Documents and Settings\Kevin\My Documents\testchecks_030406.xls",True, End Sub When I try to run the...

I am trying to disable the next button on a form called frmCompany In the forms Current event procedure I am putting the following code. Private Sub Form_Current() ' If this form is on a new record, The Next button button should be disabled 'to do this to shift the focus first. If there is '...