Recent content by whitestone

I want to use a column in a query to show where data is missing in other fields. In excel I have used this statement: =IF(COUNTA(I5:J5)=2,"","error") Basically, I have two fields PRICE and WEIGHT. I want a column in the query to show 'Error' (or any kind of flag) when either (or both) of...

For a very complicated reason which I won't go into I have created an Excel file that I was hoping to transfer onto a PDA (iPaq) to use for some fieldwork. However, Excel Mobile doesn't seem to support VBA and so I loose a lot of the functionality which is essential. Does anyone know whether...

I need to order a sub form (which is a continuous form) by a Date field in decending order (so that the latest date appears at the top). When I open the subform on its own the sort works fine by just sorting using the OrderBy property but when it is opened as a subform it doesn’t sort in the...

Thanks There was a bit of corruption. Managed to track down a couple of errors in some imported data so by copying out the data to another table and reimporting the 'dodgy bits' it seems ok now.

I keep getting the error: “The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time” …when trying to export or append. Does anyone know why this may be and what I can do to fix it? No one else is using the...

Mos Def, sorry, MStef Thanks, that works well

Please help brainy bods this is bugging me… I have a form, based on a table, with 3 fields, Ref (a reference number preceded by a G i.e. G14), a Definition (text) and a sort key (number field I put in because I couldn’t work out how to sort on the digits in the Ref). I have set the records to...

Dear All I am creating a form that is bound to the main table in my database. However, I want to show one field from another table on the form that is linked to the main table (one-to-many relationship). I would do this using a sub-form but I also want the form to be a continuous form (as...

Thanks That works well.

I have three tables in my database, one of records (with various columns of information), one of groups that the records fit into (with just a group ref and definition) and a junction table that links the two (as there is a many-to-many). I want to have a report that brings up the records for a...

Thank you for your reply. Would it be possible for you to go into a little more detail about what I would actually have to do. You mention a procedure but I am unsure what you mean by this. Thanks

I have a database which lists various statistics that my organisation holds. When we get a new statistic in I want an easy way for people to check it off against the current list to see if a similar/matching one exists. What I would like is for a form to come up saying “type key word here”...

I have some bio-geographical data held in a table (names and addresses) which has a series of duplicate rows. I have run a find duplicate query to pick out all the dupes. I now want to delete the duplicates However, the query picks out all of the rows when they occurr more than once. For...

Hello All, I have a database which contains information about Legacy donations given to my charity. I am currently running research on this data. What I want to know is whether I can run a query (or any other tool) which will enable me to see how many donors gave whithin certain groups of...

I need to set up some kind of search facility which is accessed from a button in a form. I would like the user to be able to type in bit of info and be able to bring up the record in the form view. What is the best way of doing this? Thanks Ben