Search results for query: *

Hi I have classic combo boxes that look up various fields where users can make their selection and open the required report. What I can't find out, and I know this is possible as I have found it once before, is that if one of the combo boxes doesn't have anything in, i.e. the user doesn't...

Hi, Need to create a stored proc that will delete duplicate records held within a table. I can get the records out that I want to remove, but can't seem to put the right statements in the right place to delete just these rows!!! Please help!!!! So far: SELECT bookinguniqueid FROM...

Hi PLEASE HELP!!!, I have two tables that are identical in everysense, apart from thier names. I have a dts that runs overnight to move the info from table a to table b. Tables a currently have 55578 records, table b 50986 records. I am losing 4592 records in the transfer. Is there any easy...

Hi, I have two tables that I need to join together, table a and table b. (Thats the easy bit!!!). Within table a and b I have three fields clientref, locationref, ward ref. All the records within my table have only one of either clientref, locationref, wardref. These are the only three columns...

Hi, I don't know how I am going to explain this one easily but I will give it a go!!! I have a database linked to a sql database. Within this is a field that holds information that is set to hold the same information for every record, but might not as it isn't relevant. For example: Record 1...

Help!!! I have a stored procedure that has run with no problems, until now and it is returning the above error. I have increased the field sizes in the table tbut to know avail. Is there any way I can track down which record(s) are causing the problem? This is the error I receive: Server: Msg...

I have an access database linked to a sql server. Basically all the date in the SQL server are a datetime string. Is there anyway with access I can change these to just dates so I can compare varous dates being pulled accross? Please help!!! Its driving me mad!! Help files are as useful as a...

Hi, I have a stored procedure that was created for us, but is now causing me hell of a lot of problems!!!! I need to change various fields which I have managed to do, but the last one involves a sub query and I need to concatenate 2 fields which is doesn't seem to like. Is there anyway of...

Hi, Have what may seem a simple query but would save me hours!!! Is there any way I can view what each of our DTS's does, without actually going into each one and writing down what tables it uses and data it transfers? PLEASE HELP!!!

PLEASE HELP!!!!!!! This is driving me crazy!!!! Basically I am creating a database to monitor various forms that we send out. These forms all have indiviual numbers which I'm going to use as a primary key. The forms are produced in bulk. Is there anyway I can enter the numbers in one go (ie...

HELP!!!!!! I have a DTS running fine for a while then falling over with the following message: DTSRun.exe - application error the instruction at "0x10008dec" referenced memory at "0x00ac7378". Theh memory could not be "read" Click on OK to terminate the program. Can someone please enlighten...

HI, I have created a database to monitor various bits and bobs within the company I work for, but it has now been suggested that an attachment field for each record would make life better. Is this possible in access? You can do hyperlinks and god knows what else, but I can't find anything on...

Hi, I have a column that is was datatype datetime, called hours worked, and I have now managed to convert this to decimal,this shows time difference between various other columns in the table. The problem being is that I now need to use this field and multiply it by another column which is a...

ARGH!!!! I have tried and tried with this and probably the answer is staring me in the face!!!! I have a field call hrs_worked,varchar(5) and basically holds the number of hours a person has worked. I need to convert this figure to a decimal figure. I have tried a combination of cast and...

Help!!! I have a problem with time!!!! I an writing a query and basically I am trying to work out how much we are spending depending upon when the person works!!! I have columns, start time, finish time and hours worked, what I want to do is combine a separate database to this with various...

I have created a report which basically produces an invoice. Within this invoice are two date fields, if the mileage field is equal to four, these date fields need to remain blank, this I have solved. My problem is that, when the mileage field isn't equal to four, the date needs to be shown, an...

HELP!!! I have a set of employee records that have been paid in different payroll weeks (bog standard parameter that asks which payroll weeks you want to look at). Some of these records are for the same employee but for different payroll weeks. The payroll weeks are based on a Monday to Sunday...

I have a text box within a field, the control source is formated to pull 4 different pieces of information from 4 different fields to produce something similar to the following: 001-001-0045-00565 The above field changes depending upon record number etc, and so no number is the same. What I...

I have four tables, location, department, Product and Asset. All these have unique ID numbers. I want to format the ID numbers on a form so that they appear as three numbers ie, for department 1, I want the number to appear as 001, same for the other tables. I then want to take all four ID...

Stuck at present and want to go home!!! I have create a query which pulls out specific records that I want (wahey, got that bit right!!!). The next step to this is to somehow group the records based on todays date. For example, todays date is the 4 feb, i want to see the records that were input...