Search results

Hi I have an excel sheet that I've imported into an access 2007 table. It has a field with the user name in it but every so often a location address appears in this column meaning that the users who appear below the address are based at that location. What I need to do is create another column...

Hi I've exported my tasks folder from outlook 2007 to an access file and imported the data into access 2007. Works fine. Problem is when I try the built in wizard within access to link to the outlook tasks folder I can link the table but some of the key fields are missing e.g. subject, which...

The block isn't being treated as an entity in itself, it's merely a field that has been added to refer to a collection of properties i.e. provide a list of addresses in a report grouped by block number. Each address (house/flat) on the system has it's own record and 99% of the reporting required...

The table is just ordered by ID number, it's linked to a main table that holds dates etc but the data I'm concerned with is within the table in question. The end game is to 'clone' data from one record to many linked using the number in red in my original post. The subject is repair values...

Hello What's the best way in an update query, using access 2003, to update data in a record based on the previous record having an identical value in a certain field? For example my data looks something like this, in this example I want row 2 to fill in the blanks with the data from row 1 as...

Thanks MDE and run time version is something I hadn't looked into yet to be honest. I'll do a bit of research on it. Thanks

Hi It's already split like this, it's the thin client part I'm struggling with.

Is your PC on a network or standalone at home? Do you have any anti virus software running that may be checking internet activity, email etc? Is your PC trying to download or install windows updates? Check these.

Hello Does anyone have experience with deploying an Access 2003/2007 database over a LAN using thin client PC's? My work are slowly replacing 'regular' PC's with thin client versions and a couple of the databases I administer are split, front end installed locally on the users C: drive and...

Yes I checked on the PC that has the problem. I have a copy of the front end file on my local network. It works fine when copied to all of the client machines. It's just the windows 7 machine with access 2003 and 2010 installed that I have this problem.

Just double checked Macros are sitting at 'low - not recommended'

It's not as I have front end client installs on various machines and it's working on them ok so I can get the working file back at any time. Just seems to be on certain PC's that, when opened, the code disappears. I was guessing that it's beacuse a newer version of access has been installed.

Hello I have a database designed in Access 2003. I have tried to open it using Access 2010 on Windows 7 but when I do so none of the buttons work. Looking at the design view does shows the [Event Procedure] next to the On Click action but when I go to view the code nothing is there. When I...

Hello With help from this forum I've coded this in access2007 to open google street view based on the postcode field. It opens the correct address in google (by that I mean google displays the address as text and the correct postcode is in the search bar) but the streetview image itself is of...

Thanks gemma (Dave) I'll take a look at the underlying queries tommorrow. jdraw - I would have to 'anonymize' a lot for this database. If I get stuck with the queries I'll see if I can post it and highlight the form.

Hello I've been given the task of migrating an old access database which was originally written in access97 but runs now in client PC's using access 2003. I'm not sure if whoever 'converted' it to 2003 made any form/code changes. My plan is to migrate it to 2007 and 2010 (we have mixed client...

Hi I'm getting the error in the title of the post whilst trying to run the query below: UPDATE GAS_SURE_NEW INNER JOIN STODBA_JJSDATE ON GAS_SURE_NEW.jjobno = STODBA_JJSDATE.JJOBNO SET STODBA_JJSDATE.JSDATE = [GAS_SURE_NEW].[jcompdate] WHERE (((STODBA_JJSDATE.JSTATUS)="3")); The JJSDATE...

You know when you stare at something for too long you miss the obvious. That's what I did, I just clicked cancel this time when access asked to identify the primary key in my link table and the queries are working now. Slightly embarrased but thanks for your reply, you pointed out my mistake!

Hi Using access 2007 (and tried 2003) I have a linked ODBC table which is using an ORACLE driver. If I query the table directly through ORACLE/SQL for a particular 'job number' I get the following results: 18598979 3 06-DEC-13 10:10 18598979 0 03-DEC-13 10:34 18598979 1 03-DEC-13 10:34...

I suspect this is what has happened, now to figure out how to re instate the primary key! Any ideas? The most likely problem is a corruption. When you perform a compact/repair, Access rebuilds the indexes. If it discovers that there is a duplicate in a unique index, the repair could solve the...