Search results

  1. R

    VB & SQL & Dates

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

    FileSearch & Terminal Services Users

    :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...
  3. R

    Tip Mail Merge & Unmatched Queries

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

    Question Deleting documents from a folder from with Acess using VB

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

    Help with resetting form - optionbuttons

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

    Vertical Scroll Bar

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

    Error '2118' You must save the current field before you run the 'Requery' action

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

    Validation: how to stay on the invalid record

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

    MS Access / Word Interface

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

    Letter Storage & Retrieval

    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...
Back
Top Bottom