Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dominicg123

    PPMT with date

    I am trying to do a report with an amortization table. This is a function that comes from Microsoft website that shows the payment for each period with different details. There is a counter that shows each period of payment. I trying to show a date for each period that change on each line but it...
  2. dominicg123

    Contact phone number management like in outlook

    I have a database for our company contacts. Each of of my contacts have several phone numbers. I would like to choose from a combo box, like in outlook the contact phone number that I want to display for earch record. Do you think its possible??
  3. dominicg123

    Many to Many

    I have a database with contact that have actions related to them. My problem is that a contact can have many actions and an action can be related one or two contact. Is that a many to many relationship?
  4. dominicg123

    Dlookup problem with '

    This code is used to update a text box with the value from the column 1 of a list box. Everything worked until when in the name of the field I have the ' character. Then I get a syntax error! I must have a typo somewhere... for example this will work: G:\Public\Dossiers\BRUN16\R.Brunet Annexe...
  5. dominicg123

    Moving files

    I am trying to move all the files from a folder to another one using VBA. Any good plave to start? I read some stuff on moving files but I need some help on how to move mutiple files at a time. Thank you!!
  6. dominicg123

    Another filter problem

    This code is part of a procedure to filter my record base a combo box. If Not IsNull(Me.FtlTypeDoc) Then strWhere = strWhere & "(right([Linked_Doc], 3)= """ & Me.FtlTypeDoc & """) AND " End If Linked_Doc is a path to certain files and FtlTypeDoc is a combo box with a list a extention...
  7. dominicg123

    Simple filter problem

    I have a combo box name FtlUser. I want to apply a filter with that combo box but I get a dialog box asking me for a parameter. Probably a simple mistake.... Private Sub FtlUser_AfterUpdate() Me.Form.Filter = "[ActionFor]=" & Me!FtlUser Me.FilterOn = True End Sub
  8. dominicg123

    Trying to change a sub-form

    I have a form called main that I use for a menu on the left side of the screen. I use an option group with the following code to navigate between different sub-form that are use to display information: Select Case Me![Menu Options] Case 1 Me![DisplayPanel].SourceObject =...
  9. dominicg123

    fill combo box with data from two tables

    I have a combo box on a form called cboreference. I want to fill the combo box with data from two tables: customer and user. Is this suppose to be done with VBA?
  10. dominicg123

    Change list box recordset

    I would like to change a list box recordset used on my form. The record set will have to be base on a combo box. This combo box is filled with a list of field used in my table. This is the code so far: ListeClient.RowSource = "SELECT Clients.RéfContact,xxxx FROM Clients ;" I want to...

Part and Inventory Search

Back
Top