Search results for query: *

DougP, I have double checked in case i was going mad but it is definitly Access 2000. Josh

Hi, I have an access 2k database that when opened gives the following error : Unrecognised Database Format I have tried to recompile it, compact and Repair it and create a new database to copy all objects across to. All of which to no avail, still keep getting the same message. This is...

Ken, Unfortunatley it is only some of the tables that are on the server. As a work around I have written VB that grabs the table that was linked, copies the contents to a local table and then deletes the linked one. Seems to be working thus far so i think i will have to live with that. Thanks...

Okay, I have tried to recreate the database to no avail. It seems to be a problem with the linked tables in Access 2000. It seems that with the linked tables the database will not compact and i think that this is the core of the problem. My company are not running the full version of Access...

Cheerio, Thank you for your input, i dont believe that Access is being that stretched as it is quite a simple query but the code is below, believe me it wasnt easy to get!! Which is half the problem the db normally errors when you try to go to design view and so it is hard to even get...

Ben, Thank you for that, sadly it doesnt seem to have made much difference. I believe that a process is kicked off in the background cause i can usually see multiple instances with task manager but doesnt display in the foreground. Do you, or anyone, have any other ideas i can try...

all, Thank you for your comments. I have tried to recreate the database but to no avail. I find that the same problems occur in the new database. I have got a few linked tables and that Access 2000 doesnt want to compact with these tables in. I have gone to the source of these tables...

Hi, I have a couple of Access 2000 databases that are giving me trouble. When trying to open a query in design view,Access thinks about it then gives you full control back, and nothing has happened!! If you continue trying to view the query this error message appears "The instruction...

I have found a site that deals with Windows NT Drivers www.extendedsystems.com Do a search on QuickBeam Josh

Thanks for all your help folks, i managed to figure it using a CASE statment Cheers Josh

I know that it doesnt fully take in everything that you need it to but you can use the DATEDIFF function to workout the number of hours between two dates: Select DATEDIFF ( hour, startdate , enddate ) Regards Josh

sure no problem The if statment that works in isolation is --check to see if the person has a leaving date if (select max(c.working_to) from v_ssd_resource c, m_ssd_resource_Cost_centre_history a where a.consultant = c.consultant) is null begin --if not then select the...

Hi, I am writing a query that requires the use of an if else statment. I have written the statement and tested it but i can not make it work as part of a larger query. Does anyone know how i could do this? Cheers Josh

Alex, I have a Compaq Armada M700 laptop, i have been to Compaqs website but they are insistent that NT doesnt support IR. Any idea how i go about finding out what IR port i have? I dont think the technical support people would know, not sure what the policy is re adding extra software so...

Hi, I have a laptop running windows NT and have heard that there is software available that will enable me to use the built in infrared port. Does anyone know if this is true? If so anyone know where i can get it? Regards Josh

Jon, Thanks for that, as it turned out I managed to use a work around. Which, unfortunatly led to another problem. I now have two dates in the format that i would like them, which is now dd - mmmm - yyyy!, however i need to work out the number of work days between these dates, which are...

Hi all, I have a date in the format "yyyy/mm/dd" that is a dynamic value. Depending on what the date is, i want a cell within another sheet to reflect the full name of the month plus a two year code. I.E. January 02. Can anyone help me to do this please????

I am trying to run the following query with VBA when the worksheet in Excel is opened: Private Sub Workbook_Open() Dim mine As Worksheet Dim runsheet As Worksheet Dim sheetcount As Integer sheetcount = 2 Do Until sheetcount = ThisWorkbook.Sheets.Count + 1 Set runsheet...

Johnpje Thanks for your help, i had an inspiration and managed to make the thing work. Josh

Johpje, sorry, missed a bit, i am only using VBA in Excel Regards Josh