Search results

Thinking about this, it may be more of a query problem, or rather the solution probably lies in the query and not the table, so i'm going to repost in that thread.

Hi I have a main table with a form to put the data in. I then have a sperate table to put additional information in (a subform of the main form, linked by ID). Originally i thought this was best as not every entry in the main table will have additional info. However when I came to create...

Hi I couldn’t get the above solution to work, I’m very novice at this, so trying a different tack now: I have put code on the PropHistory subform button for 'go to new record and open the address search form': DoCmd.GotoRecord , , acNewRec 'new record On Error GoTo Err_Command1_Click...

Hi Thanks for your quick reponse. I'll try that as soon as I get a spare minute. Kev

Hi All I have a database which hold customer contact details (amongst other stuff) I have just brought in a table with all addresses in the area. I have created a dynamic search form like this: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 to search the address table...

thats great, got that working too. put it on the oncurrent event and it works when i apply any filter, which is an added bonus Thanks for all your help

Thanks for the quick replies Peters code seemed to do the trick. I could not get lagbolt's to work though - sorry lag, probably applying it wrong. Thanks again, much appreciated

Hi I'm a novice when it comes to vba. I want to put a button on a form that removes any filter applied to it. I know the on click needs to be me.filter="" however, the next step is i only want the button visible if there is a filter applied. i want to put some code in the onload...

Hi All I'm not sure if this should go in forms, querys or vba... I have a subform that has a list of transactions for each customer. This is based on a query so that i could get it to sort by date. some users prefer newest transactions at the top, some prefer oldest. It is a split...

Ok, One last thing with this macro, then i'll stop hounding you all! What do I need to add to the end of the code to close the doc "merge test.doc" but leave the outputted mail merge file open. Everything i've tried just closes all instances of word. Thanks Kev

I think i've sorted this I'm using this code: DoCmd.SetWarnings False Dim mypath As String Dim mypath2 As String Dim mypath3 As String Dim Wordpath As String Dim folder As String Dim sDBPath As String Dim oApp As Word.Application Wordpath = Environ("office") & "\winword.exe" mypath =...

Just researched my reply and it seems that would not work, have a look at this though: http://www.rondebruin.nl/mail/account.htm if you are using outlook 2007 there is this command: .SendUsingAccount = OutApp.Session.Accounts.Item(1)

Hi If your outlook has the mail account DBAdmin@xxx.com set up, could you not put in a line like: Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Dim Email As String Set olApp = Outlook.Application 'Create e-mail item Set objMail =...

I've been looking at this code again. How does access/word know what oApp and oMainDoc are? Shouldn't i have these defined and dimmed? Or are these codes that a reference library should understand? Just a few thoughts that will hopefully take me nearer to an answer. Thanks

Hi Thank you for your reply. The first bit of code works fine, it just calls the correct word document which has the template which has all the mail merge fields set up in already. . You were right about the folder path, so I have changed the code slightly. But, I still get a problem...

Hi All I realise there are a lot of threads about this, but i cant find my solution anywhere. I have a split db. I would like to automate standard letters from the data in the db. I have a button which runs the code below. Basically it creates a table called...

Hi Thanks for your reply, but ive looked at the example and im not sure that is exactly what im looking for. I need the combo box entries to be permenantly in that control, the user will be able to set up 3 links per record, then, if needed use the buttons to look at the associated record...

Hi again I have a subform (called sfrmLinks), this is a child to the main form (frmMain) in my db which I want to use to be able to navigate to linked records. Basically, in the subform have 3 combo boxes where I can select and store the linked records. Next to each is a button, and i...

Well there is one last bit.... How would i do the validation so that only one property per person contained a "current" in that field. It's important as the database is supposed to create standard letters and the query will be the data-source for a mail merge, I only want to end up with one...

That sounds like a plan, in that case can I validate that only one property for each person can have the current value? Thanks