Search results

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...

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...

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 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...

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...

I have a problem with validation attached to a field or an entire record (displayed via a form) in that, if the user exits that field/record by moving to the next Access record, when the message comes up, it is this next record that is displayed, not the invalid one. This is confusing. My...

I am not sure whether this is a problem with MS Access, Visual Basic or Windows. I have also posted this under MS Access so if you have already read it I apologise. I have taken over supporting & developing an MS Access 2000 DB for a small charity & am not an Access expert or a programmer...

I am not sure whether this is a problem with MS Access, Visual Basic or Windows. I have taken over supporting & developing an MS Access 2000 DB for a small charity & am not an Access expert or a programmer. The Application includes processing to create, amend & store retrieve standard...