Search results

@CazB you're idea worked with a little playing around. I now have 8 queries working this all out. The main one collecting the the person info and then 8 total sub-queries, 7 using a variation of the expression you provided and shown below and the last one just doing a simple count on the type...

Thanks for the replies. I have a quick update. I've manage to get the counts to work with sub queries but only if there is something to count. So if a person doesn't have a merit type it doesn't return zero and the query doesn't return any record. So I guess a side question, is it possible...

Hello Sure this is possible and currently trying different things but haven't been able to find any information on what I'm trying to do but not really sure what to search for. I have 2 tables (person / merit) currently the merti table has 4 fields (MeritID, PersonID, Issuer, Type) I'm...

Yes that was the main problem and everything is now working after a little more editing. Thanks for your help.

That was a typo, thanks for the second set of eyes. Thanks again, Harry

Hello Sorry if this is in the wrong forum. I'm trying to create a function to update and amend records in a table. The update part works and updates existing records with new data but I'm getting an error with the insert part. Might be my SQL, I found it in an example and edited but the...

Great that's work great thanks for your help here is the code if anyone is interested Dim rst As Recordset Set rst = Forms![MainPage_fm].RecordsetClone rst.FindFirst "[PersonalID]=" & Me![PersonalID] If rst.NoMatch = False Then Forms![MainPage_fm].Bookmark =...

Hello, I've been using the following code for ages but wanted to change the fields being search because if the search field(NiNo) is blank it wouldn't return any results or jump to that record. Now trying to use the PersonalID field but having problems matching the data types. The code runs...

EXCELLENT!!! That works perfectly. Cheers Here is the code I've used if anyone is interested. Private Sub Form_BeforeInsert(Cancel As Integer) If Form.RecordsetClone.RecordCount > 6 Then Cancel = True End If End Sub

Hello, I've not been able to locate any information on this and I'm guessing I'll need to do this with some VBA code. I have a table called person with associated fields, name, dob, address, etc and a table called timetable that holds day, start time, end time. I've setup the timetable as a...

yes it is bound and that makes perfect sense. Cheers

Hello, I've creating a database that will only need to store a single record in one of the tables. This table will be linked to another that can store multiple record, like a workplace and employee. There is only one workplace so I only want there to be one record in this table this record...

thank you that's help me get it working. I only need to calculate certain ages so will just repeat for those. Many thanks again. Harry

Hello Please can someone give mesome advice on my DCount statement. I'm using the statement that will count the number of records (people) with an age of 18 who are connect to a certain establishment. The age only needs to be calculated at certain times of the year so it is stored in the table...

solution found Thanks for the help just found the regional settings under windows CP works fine now. Thanks again, Harry

Hi, I need to export some data into XML and the data format needs to be YYYY-MM-DD, AC2000 doesn't seem to be able to do it like that closest I can find is in reverse, is it possible to format the date manually in code before exporting it if it can't be stored in that format? Any help is...

Hi I've got a database with 2 main tables from which I need to export the data to XML. I've heard that Access 2003 and later will allow you to export to XML, I'm currently using 2000, is there a way to do it with additional software or would it be best to upgrade access? I thought I might get...

Hi, I have 3 mail merge letters that will be used with a access database/queries they work fine, but when opening the documents they seem to open multiple copies of the database even if it its open already. Just wondering if there is a way to stop this happening, as it is likely to confuse as...

thanks Micheal for the info, will try out that replace function. thanks also Dennisk, I would have done that too but the old DB had just a single field and had to import from that and the address all vary in length and format. Wasn't quite sure how to go about changing it. thanks again. Harry

Hi, I have an address field currently formatted 1 Streetname, city, post/zip code it is displayed on a form within a multi-line textbox. I'd like to change the commas to a line return so it will display 1 streetname city postcode I was thinking that a small macro might go through each record...