Search results

hi I have my database forms set to not allow deletions, because in my experience people tend to do this by accident. I have since found myself haveing to do more systems admin than I would like, and trying to set up a way to allow others to delete under certain cicumstances. I have set...

Thanks for your reponse. so looking at that link, you think it is the GROUP BY clause that is causing me problems? The data I need addable is the fields in tblPerson, the data in tblProp history is just for information, it is inputted using a different form. I've never looked at DMax...

Hi All I have done some research on this already, and realise that my form doesnt work as it is based on a stacked query, but I dont know what the best solution to this is. I have tblPerson with client details. tblAddressHistory with addresses for each client. I use 2 queries to get the most...

Hi again dont worry about answering this. Ive decided to keep age in an unbound box as it is. Will change the process to ensure DOB is always known

Hi I have a table with fields for DOB and Age. On the form I would like to automate the age based on the DOB. I have this formula that was in an unbound field and worked, but i cant get it to work on the bound field...

Hi Thanks for your reply, i have made the adjustment and seem to be getting further, however i get a prompt to enter the ID number, which i dont think i should be as it should be picking it up from Me!ID (the button that the code sits on is on a form which contains the field called ID, the...

Hi The unique identifier on my combined form is called ContactID, however there is a field called ID which contains the Unique Identifier of each record in it's original table. This is the field i am trying to use to find the correct record when the main form opens, but it is not working...

Hi I'm not able to explain easily my whole database, however the essential info i think is, i have a table that inlcludeds selected summary data from 4 other tables. there is a field to identify which table the records come from "type". I have a search form and would like to open one of 4...

Hi again I'm still working on this and thought I'd post an update of the code i've now got. I realised the Me!Surname wouldn't work as the button was on a subform, so now using parent!surname which doesnt throw up an error, so now experimenting with different DefaultFilePath codes, but none...

Hi Again I have been working on this this morning and have found a function that should be able to set the default save location, so trying to put this into my code. I have this so far: Option Compare Database Private Sub Command11_Click() DoCmd.SetWarnings False Dim mypath As String Dim...

Hi all Sorry to keep returning, but my DB is starting to be really functional with all your help! I am using this code to run a mail merge: DoCmd.SetWarnings False Dim mypath As String Dim mypath3 As String Dim Wordpath As String Dim folder As String Dim sDBPath As String Dim oApp As...

Thanks, that did it, easy when you know how!

Hi I have a script that does a mail merge. At the end of the script I get 2 docs, the original merge doc with all the form fields etc in, and the merged letter. I would like to close the original document but leave the letter open so it can be edited/saved/printed. here is my code...

Hi Thanks for all your replies. I have, with your help, managed to return just the most recent address!!!! However... The next step was to get the info from all the other tables in the same place for a mail merge. And i only get 3 results returned. I have had this problem before, and...

Hi I am getting more than 1 property per person, and i am expecting only the property with the most recent date for each person. I have attached the result of the query, ID 8 returns 2 properties not just the Max DateMovedIn as does ID 12 and 19. Thanks Kev

Also, here is a screenprint of my design view for the query Thanks again

Thanks for all the replies I am trying to set up the queries the other way around now as suggested. The SQL i get for obtaining the max move in date is completely different to the example on BaldyWeb. I do not know how to write the sql without making the query in design view. This is what i...

Hi I have a query bringing together information from lots of tables for a mail merge. The bulk of the fields come from 2 tables, tblPerson and tblPropHistory. A Person can have many entries in PropHistory. I need the query to return a single result, that being the the most recent...

Thats great, thanks Gary, I cant beleive i didn't know about that!!!

Hi I posted this is tables but now think the answer lies more with the query, i have a feeling it depends on the type of join, but dont know how to sort this out as i only ever use design view and not sql. The sql for the qry is currently: SELECT tblCasenotes.Date...