Search results

Thank-you for your help. I had been using MsgBox SQL to display the query but thanks for letting me know about Debug. I came back to programming in my 60s for a charity having not programmed for decades so am self-taught in VB. Query: SELECT * FROM Calls WHERE Calls.ContactID = 68 And...

I am having trouble with dates in SQL within VB. I want to add a Call when a 'Making a Difference' record is created but not each time it is looked at or has minor updates so I am checking for existing records. In a Query, the following works: SELECT Calls.Notes, Calls.ContactID...

:confused: When a user deletes a contact in the application I support I use the following code to delete any associated letters using the following code: With Application.FileSearch .NewSearch .LookIn = PathLiveLetters .FileName = Contact & "-" & "*" If .Execute() > 0 Then...

I do occasional targeted & personalised mailings from our DB using SQL & Word Mail Merge. Recently I ran one based on an UNMATCHED query, which I realise now I hadn't have done before. Word ignored the unmatched part of the query/SQL & printed around double the number of letters! Because...

I have got working code for many of the things I wanted to do (problem was more complex than I described) but am now trying to adapt the code from FindFiles.mdb to import the document list. The reason for this is to deal with contacts who have been deleted so I am trying to find unmatched...

From home - couldn't post a reply yesterday. I hadn't realised you have to select the documents before clicking a button - silly me! - so now the demo is working as it should do. I still can't find the form. It is not listed under Objects, not that I need it as forms are something I don't...

Thanks for your help so far. I am beginning to understand what is going on in the demo. I came out of retirement to support a frighteningly sophisticated application which stretchs Access to the limits & invlolves vast amounts of code. I hadn't programmed for donkey's years & never in VB so...

Thank-you but I am afraid I didn't understand demo FindFiles.mdb at all. I have tried running the macro with the correct path & *.doc but it kept refused saying I could only run it for text files. I was expecting some code? I didn't find any buttons or 'kill' statements. I don't know where...

Very many thanks. At the moment, I am drowning in work (I work for a charity & have just reduced my hours to 12 per week having reached my 65th birthday but the workload hasn't reduced along with my hours). When I have a quiet period I'll try out your suggeston.

Users can write & retrieve letters (WORD) from within the application I support. My problem is that, when we remove contacts from the DB, the letters are left behind, ever increasing in number & giving us Data Protection problems. Deleting them manually is tedious & error prone. The...

Thank-you for your suggestion which I tried. I still got the message 'you can't assign a value to this field'. However, I noticed the fields were in fact cleared so I inserted 'On Error Resume Next' before the statement which setting the optionbutton fields to False. The code now works...

My apologies if you have already seen this - I added it to another, related thread but as no-one answered thought it might be overlooked. I reset all the fields on a search form - Do I = 0 to Count etc. This works for fine all (textbox, combobox, listbox, toggle buttton) except optionbutton...

I have a related problem. I reset all the fields on a search form in a similar way to Caspar in his original post - Do I = 0 to Count etc. This works for all (textbox, combobox, listbox, toggle buttton) except optionbutton which VB won't let me, saying I can't set a value to this field...

Ted: thanks for properties but, apart from the dimensions, the format for my problem box is identical to yours. Missingling: the subform IS Single Form because it has its own subform which is in Continuous view.

Thank-you both for your help BUT Ted: the box is quite big already, displaying about 10 lines of text by default. The users write a detailed account of a contact in this field. It could go for 20, 30 lines or more. Missingling: the form is a Single Form. It can't be Continuous because it...

Correction Sorry, it is a memo field not text.

I have a text field on a sub-form in which I want a vertical scroll bar. Although I have set the Scroll Bars property to 'Vertical', it is not displayed & the users have to use the Up/Down Arrow keys to see hidden text. Has anyone any idea why this might be happening? I don't have the same on...

Save & Requery The main Contacts form has other sub-forms so there is a lot going one. It is difficult to describe. I've attached a picture. The relevant forms are linked using Parent & Child fields: Calls to Contacts using ContactID (bottom right) Subjects to Calls using ContactID &...

I have a Contacts form which has a Calls sub-form which itself has a Subjects sub-form. From the Contacts form the user can click a button which writes a pro-forma letter from a selection. The application then updates the Call & allows the user to select the Subject(s) from the Subjects...

Thank-you very much I knew it would turn out to be simple but how to find out ...........