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

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

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

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

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

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

Using access 2003 my replica set tables in both the master and replicas seems to have lost the key field! The data and field itself are simply missing from every table. When I look at the data in the tables the key field called 'UID' is not visible but I can still see it in the relationships...

Hello Is it possible to add a database .mdb file to an existing replica set? The file in question was part of a previous replica set for the same database but I had to create a new design master and new replicas as it got corrupt. Now this file (replica) one won't sync, all I get is an error...

I'm gettting an error when trying to sync a replica in access 2003 "the history of design changes does not match design master". I had to restore the design master so that's what probably caused it. Found the error on microsoft's site but couldn't find a solution. I'm trying to avoid...

I have a .mdb file (access 2003) which has ballooned in size to 1.2GB and I'm not sure why. I tried deleting some older tables (which were copies and had about 38,000 rows each) but it hasn't made a dent. Is there a way to show all the database elements tables, forms, macros, modules etc and...

Hi Im looking for advice with a union query and search facility I'm trying to create. I have 2 tables, (will just call them tbl1 and tbl2 for this example) each with a column AppNumber. The AppNumber may appear in both tables or individually in either one. I want to be able to show, or flag...

I'm trying to pass a field ([txtUPRN]) in a form to a hyperlink or button on the form. e.g. http://whatever/GetJobsByLocation?jlocation= 26800 I thought I could add a hyperlink and simply change the part 'jlocation = 26800' to 'jlocation = Me![txtUPRN]' but this would be too easy as it...

What forumla could I use in a report field to remove all characters before the first space in a text field e.g. 32A Bank Street --> Bank Street 19 Alder Street --> Alder Street I've tried =Right([JLADD1],Len([JLADD1])-2) but this obviously doesn't work for the first example above.

I have an IIf statement within a query that I need to alter: IIf([COMPDATE]>=[Date Completed],'35',([tblSurveyRecord72].[58c]-[Expr1])) In the formula above I want to set the value of a calculated field in my query ([RemainingYears]) to 35 if the statement is true i.e. replace '35' with...

I have an access 2003 split database which I have added an ODBC linked table into the design master. I know this won't replicate onto any replicas in the set. However I really need this table to appear on the replica databases so users can access the data whilst on site working offline. I...

Using access 2003, I am trying to write a SWITCH statement for a report header. I have a field TRADE which changes value on each page. I have an unbound field NUMBER which needs to change depending on what is shown in TRADE. (The field NUMBER will take a value from another field) I guessed at...

I'm trying to use an unbound text field to count all records in a report which have no value (i.e. is null) So far I've got =Count(IIf([JCONTNO]=Null,0)) but it returns 0. I've tried variations but still no joy. Could someone point me in the right direction? (Using access 2003)